R11: Need to understand exactly which fields/database table-columns AR tax group rules refer to (Doc ID 1082228.1)

Last updated on DECEMBER 14, 2016

Applies to:

Oracle Receivables - Version 11.5.0 to 11.5.10.3 [Release 11.5.0 to 11.5.10]
Information in this document applies to any platform.

Goal

Is it documented anywhere, or can you provide us with the information on a mapping of exactly what each data element in the AR Tax Group actually references in Oracle

"Ship From Country" is the Country of the address of the Ship From Location on the Order Line. This is stored in TABLE.FIELD.

We are re-evaluating our VAT setup across Europe and this information would be very useful in determining the (standard) functionality that we have available to us in order to do this on the AR side.

What table.field are the following references for tax group stored in:
1. Ship To = Country; State; County; Province; City; Tax Registration Number
2. Bill To = Country; State; County; Province; City; Tax Classification; Tax Registration Number
3. Order = Origin Country; State; County; Province; City
4. Order Acceptance = Country; State; County; Province; City
5. Transaction = FOB; Type
6. Item = User Item Type
7. Ship From

Solution

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms