My Oracle Support Banner

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

Last updated on FEBRUARY 25, 2019

Applies to:

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


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


To view full details, sign in with your My Oracle Support account.

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

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.