[Home] [Help] [Dependency Information]
Object Name: | ECE_AR_TRX_LINE_TAX |
---|---|
Object Type: | TABLE |
Owner: | EC |
FND Design Data: | EC.ECE_AR_TRX_LINE_TAX |
Subobject Name: | |
Status: | VALID |
ECE_AR_TRX_LINE_TAX contains customer invoice line tax data to support
the outbound Invoice (810/INVOIC) transaction.
ECE_AR_TRX_LINE_TAX is based primarily on data stored in
RA_CUSTOMER_TRX_LINES and AR_VAT_TAX in Oracle Receivables.
ECE_AR_TRX_LINE_TAX contains the tax information for the customer
invoice. If applicable, VAT tax information is included.
Each row in ECE_AR_TRX_LINE_TAX is associated with one row in
ECE_AR_TRX_LINES. There is a one-to-many relationship between
ECE_AR_TRX_LINES and ECE_AR_TRX_LINE_TAX.
All columns denoted with "Int" or "Internal" represent Oracle
Applications internal values. All columns denoted with "Ext" or
"External" represent the equivalent external values sourced from the
ECE_XREF_DATA table if code conversion is enabled for the column.
Each row in ECE_AR_TRX_LINE_TAX is purged after the data is written to
the data file.
TRANSACTION_RECORD_ID is the unique key that links the
ECE_AR_TRX_LINE_TAX table to its corresponding extension table
ECE_AR_TRX_LINE_TAX_X.
Tablespace: | APPS_TS_INTERFACE |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
ECE_AR_TRX_LINE_TAX_U2 | NORMAL | UNIQUE | APPS_TS_INTERFACE | TRANSACTION_RECORD_ID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
COMMUNICATION_METHOD | VARCHAR2 | (30) | Communication Method | |
TRANSACTION_TYPE | VARCHAR2 | (30) | Transaction Type | |
TRANSACTION_ID | NUMBER | Yes | Transaction ID | |
LINE_NUMBER | NUMBER | Line Number | ||
LINE_TYPE | VARCHAR2 | (20) | Line Type | |
TAX_LINE_NUMBER | NUMBER | Tax Line Number | ||
TAX_AMOUNT | NUMBER | Tax Amount | ||
TAX_RATE | NUMBER | Tax Rate | ||
TAX_PRECEDENCE | NUMBER | (15) | Tax Precedence | |
VAT_TAX_CODE_INT | VARCHAR2 | (50) | VAT Tax Code (Internal) | |
VAT_TAX_CODE_EXT1 | VARCHAR2 | (80) | VAT Tax Code 1 (Ext) | |
VAT_TAX_CODE_EXT2 | VARCHAR2 | (80) | VAT Tax Code 2 (Ext) | |
VAT_TAX_CODE_EXT3 | VARCHAR2 | (80) | VAT Tax Code 3 (Ext) | |
VAT_TAX_CODE_EXT4 | VARCHAR2 | (80) | VAT Tax Code 4 (Ext) | |
VAT_TAX_CODE_EXT5 | VARCHAR2 | (80) | VAT Tax Code 5 (Ext) | |
TAX_ATTRIBUTE_CATEGORY | VARCHAR2 | (30) | Tax Flexfield Context | |
TAX_ATTRIBUTE1 | VARCHAR2 | (150) | Tax Flexfield 1 | |
TAX_ATTRIBUTE2 | VARCHAR2 | (150) | Tax Flexfield 2 | |
TAX_ATTRIBUTE3 | VARCHAR2 | (150) | Tax Flexfield 3 | |
TAX_ATTRIBUTE4 | VARCHAR2 | (150) | Tax Flexfield 4 | |
TAX_ATTRIBUTE5 | VARCHAR2 | (150) | Tax Flexfield 5 | |
TAX_ATTRIBUTE6 | VARCHAR2 | (150) | Tax Flexfield 6 | |
TAX_ATTRIBUTE7 | VARCHAR2 | (150) | Tax Flexfield 7 | |
TAX_ATTRIBUTE8 | VARCHAR2 | (150) | Tax Flexfield 8 | |
TAX_ATTRIBUTE9 | VARCHAR2 | (150) | Tax Flexfield 9 | |
TAX_ATTRIBUTE10 | VARCHAR2 | (150) | Tax Flexfield 10 | |
TAX_ATTRIBUTE11 | VARCHAR2 | (150) | Tax Flexfield 11 | |
TAX_ATTRIBUTE12 | VARCHAR2 | (150) | Tax Flexfield 12 | |
TAX_ATTRIBUTE13 | VARCHAR2 | (150) | Tax Flexfield 13 | |
TAX_ATTRIBUTE14 | VARCHAR2 | (150) | Tax Flexfield 14 | |
TAX_ATTRIBUTE15 | VARCHAR2 | (150) | Tax Flexfield 15 | |
TAX_EXEMPT_FLAG | VARCHAR2 | (1) | Tax Exempt Flag | |
TAX_EXEMPT_NUMBER | VARCHAR2 | (80) | Tax Exempt Number | |
TAX_EXEMPT_REASON_CODE | VARCHAR2 | (30) | Tax Exempt Reason Code | |
TAX_TYPE | VARCHAR2 | (30) | Tax Type | |
TAX_TYPE_EXT1 | VARCHAR2 | (80) | Tax Type 1 (Ext) | |
TAX_TYPE_EXT2 | VARCHAR2 | (80) | Tax Type 2 (Ext) | |
TAX_TYPE_EXT3 | VARCHAR2 | (80) | Tax Type 3 (Ext) | |
TAX_TYPE_EXT4 | VARCHAR2 | (80) | Tax Type 4 (Ext) | |
TAX_TYPE_EXT5 | VARCHAR2 | (80) | Tax Type 5 (Ext) | |
DESCRIPTION | VARCHAR2 | (60) | Description | |
LOCATION | VARCHAR2 | (60) | Location | |
TAX_CLASSIFICATION | VARCHAR2 | (30) | Tax Classification | |
TAX_CLASSIFICATION_EXT1 | VARCHAR2 | (80) | Tax Classification 1 (Ext) | |
TAX_CLASSIFICATION_EXT2 | VARCHAR2 | (80) | Tax Classification 2 (Ext) | |
TAX_CLASSIFICATION_EXT3 | VARCHAR2 | (80) | Tax Classification 3 (Ext) | |
TAX_CLASSIFICATION_EXT4 | VARCHAR2 | (80) | Tax Classification 4 (Ext) | |
TAX_CLASSIFICATION_EXT5 | VARCHAR2 | (80) | Tax Classification 5 (Ext) | |
VAT_TRANSACTION_TYPE | VARCHAR2 | (30) | VAT Transaction Type | |
VAT_TRANSACTION_TYPE_EXT1 | VARCHAR2 | (80) | VAT Transaction Type 1 (Ext) | |
VAT_TRANSACTION_TYPE_EXT2 | VARCHAR2 | (80) | VAT Transaction Type 2 (Ext) | |
VAT_TRANSACTION_TYPE_EXT3 | VARCHAR2 | (80) | VAT Transaction Type 3 (Ext) | |
VAT_TRANSACTION_TYPE_EXT4 | VARCHAR2 | (80) | VAT Transaction Type 4 (Ext) | |
VAT_TRANSACTION_TYPE_EXT5 | VARCHAR2 | (80) | VAT Transaction Type 5 (Ext) | |
VAT_TAX_ATTRIBUTE_CATEGORY | VARCHAR2 | (30) | VAT Tax Flexfield Context | |
VAT_TAX_ATTRIBUTE1 | VARCHAR2 | (150) | VAT Tax Flexfield 1 | |
VAT_TAX_ATTRIBUTE2 | VARCHAR2 | (150) | VAT Tax Flexfield 2 | |
VAT_TAX_ATTRIBUTE3 | VARCHAR2 | (150) | VAT Tax Flexfield 3 | |
VAT_TAX_ATTRIBUTE4 | VARCHAR2 | (150) | VAT Tax Flexfield 4 | |
VAT_TAX_ATTRIBUTE5 | VARCHAR2 | (150) | VAT Tax Flexfield 5 | |
VAT_TAX_ATTRIBUTE6 | VARCHAR2 | (150) | VAT Tax Flexfield 6 | |
VAT_TAX_ATTRIBUTE7 | VARCHAR2 | (150) | VAT Tax Flexfield 7 | |
VAT_TAX_ATTRIBUTE8 | VARCHAR2 | (150) | VAT Tax Flexfield 8 | |
VAT_TAX_ATTRIBUTE9 | VARCHAR2 | (150) | VAT Tax Flexfield 9 | |
VAT_TAX_ATTRIBUTE10 | VARCHAR2 | (150) | VAT Tax Flexfield 10 | |
VAT_TAX_ATTRIBUTE11 | VARCHAR2 | (150) | VAT Tax Flexfield 11 | |
VAT_TAX_ATTRIBUTE12 | VARCHAR2 | (150) | VAT Tax Flexfield 12 | |
VAT_TAX_ATTRIBUTE13 | VARCHAR2 | (150) | VAT Tax Flexfield 13 | |
VAT_TAX_ATTRIBUTE14 | VARCHAR2 | (150) | VAT Tax Flexfield 14 | |
VAT_TAX_ATTRIBUTE15 | VARCHAR2 | (150) | VAT Tax Flexfield 15 | |
RUN_ID | NUMBER | (22) | Run ID | |
TRANSACTION_RECORD_ID | NUMBER | Unique identifier that links the transaction base table to its associated extension table. | ||
CREATION_DATE | DATE | Standard Who column | ||
CREATED_BY | NUMBER | (15) | Standard Who column | |
LAST_UPDATE_DATE | DATE | Standard Who column | ||
LAST_UPDATED_BY | NUMBER | (15) | Standard Who column | |
LAST_UPDATE_LOGIN | NUMBER | (15) | Standard Who column | |
REQUEST_ID | NUMBER | Standard Who column | ||
PROGRAM_APPLICATION_ID | NUMBER | Standard Who column | ||
PROGRAM_ID | NUMBER | (15) | Standard Who column | |
PROGRAM_UPDATE_DATE | DATE | Standard Who column |
Cut, paste (and edit) the following text to query this object:
SELECT COMMUNICATION_METHOD
, TRANSACTION_TYPE
, TRANSACTION_ID
, LINE_NUMBER
, LINE_TYPE
, TAX_LINE_NUMBER
, TAX_AMOUNT
, TAX_RATE
, TAX_PRECEDENCE
, VAT_TAX_CODE_INT
, VAT_TAX_CODE_EXT1
, VAT_TAX_CODE_EXT2
, VAT_TAX_CODE_EXT3
, VAT_TAX_CODE_EXT4
, VAT_TAX_CODE_EXT5
, TAX_ATTRIBUTE_CATEGORY
, TAX_ATTRIBUTE1
, TAX_ATTRIBUTE2
, TAX_ATTRIBUTE3
, TAX_ATTRIBUTE4
, TAX_ATTRIBUTE5
, TAX_ATTRIBUTE6
, TAX_ATTRIBUTE7
, TAX_ATTRIBUTE8
, TAX_ATTRIBUTE9
, TAX_ATTRIBUTE10
, TAX_ATTRIBUTE11
, TAX_ATTRIBUTE12
, TAX_ATTRIBUTE13
, TAX_ATTRIBUTE14
, TAX_ATTRIBUTE15
, TAX_EXEMPT_FLAG
, TAX_EXEMPT_NUMBER
, TAX_EXEMPT_REASON_CODE
, TAX_TYPE
, TAX_TYPE_EXT1
, TAX_TYPE_EXT2
, TAX_TYPE_EXT3
, TAX_TYPE_EXT4
, TAX_TYPE_EXT5
, DESCRIPTION
, LOCATION
, TAX_CLASSIFICATION
, TAX_CLASSIFICATION_EXT1
, TAX_CLASSIFICATION_EXT2
, TAX_CLASSIFICATION_EXT3
, TAX_CLASSIFICATION_EXT4
, TAX_CLASSIFICATION_EXT5
, VAT_TRANSACTION_TYPE
, VAT_TRANSACTION_TYPE_EXT1
, VAT_TRANSACTION_TYPE_EXT2
, VAT_TRANSACTION_TYPE_EXT3
, VAT_TRANSACTION_TYPE_EXT4
, VAT_TRANSACTION_TYPE_EXT5
, VAT_TAX_ATTRIBUTE_CATEGORY
, VAT_TAX_ATTRIBUTE1
, VAT_TAX_ATTRIBUTE2
, VAT_TAX_ATTRIBUTE3
, VAT_TAX_ATTRIBUTE4
, VAT_TAX_ATTRIBUTE5
, VAT_TAX_ATTRIBUTE6
, VAT_TAX_ATTRIBUTE7
, VAT_TAX_ATTRIBUTE8
, VAT_TAX_ATTRIBUTE9
, VAT_TAX_ATTRIBUTE10
, VAT_TAX_ATTRIBUTE11
, VAT_TAX_ATTRIBUTE12
, VAT_TAX_ATTRIBUTE13
, VAT_TAX_ATTRIBUTE14
, VAT_TAX_ATTRIBUTE15
, RUN_ID
, TRANSACTION_RECORD_ID
, CREATION_DATE
, CREATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_LOGIN
, REQUEST_ID
, PROGRAM_APPLICATION_ID
, PROGRAM_ID
, PROGRAM_UPDATE_DATE
FROM EC.ECE_AR_TRX_LINE_TAX;
EC.ECE_AR_TRX_LINE_TAX does not reference any database object
EC.ECE_AR_TRX_LINE_TAX is referenced by following:
|
|
|