DBA Data[Home] [Help] [Dependency Information]

TABLE: JA.JAI_AR_TRX_INS_LINES_T

Object Details
Object Name: JAI_AR_TRX_INS_LINES_T
Object Type: TABLE
Owner: JA
FND Design Data: TableJA.JAI_AR_TRX_INS_LINES_T
Subobject Name:
Status: VALID


This table also holds tax records after a manual invoice is saved. The tax records are flushed after the tax records are processed.


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
JAI_AR_TRX_INS_LINES_T NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnCUSTOMER_TRX_ID
Columns
Name Datatype Length Mandatory Comments
PADDR RAW (32)
Holds the Process Address . This column is not used in any logic.
EXTENDED_AMOUNT NUMBER

The Tax amount in transaction currency.
CUSTOMER_TRX_LINE_ID NUMBER (15)
Customer transaction Line identifier of the tax record. This is unique for every record.
CUSTOMER_TRX_ID NUMBER (15)
Unique Identifier that identifies an invoice.
LINE_NUMBER NUMBER

Tax Line Number of this tax record.
SET_OF_BOOKS_ID NUMBER (15)
The ledger identifier for the tax record.
LINK_TO_CUST_TRX_LINE_ID NUMBER (15)
The Line identifier of the invoice line to which this tax record is attached.
LINE_TYPE VARCHAR2 (20)
Identifies whether this is a TAX record or a FREIGHT Record.
ORG_ID NUMBER (15)
The Operating Unit identifier of this invoice.
UOM_CODE VARCHAR2 (3)
Unit of measurement for the item on which this tax record is attached.
VAT_TAX_ID NUMBER (15)
The Tax identifier of the Localization tax code.
ACCTD_AMOUNT NUMBER

The Tax amount in functional currency.
AMOUNT NUMBER

The Tax amount in transaction currency.
CUST_TRX_LINE_SALES_REP_ID NUMBER (15)
Sales Representative identifier associated with the invoice.
GL_DATE DATE

This column has the GL date of the invoice.
INSERT_UPDATE_FLAG VARCHAR2 (1)
Always holds the value U.
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
TAX_RATE NUMBER

The rate based on which tax amount has been calculated.
ERROR_FLAG VARCHAR2 (1)
Holds the error status of the tax record . Possible values are Null, P or R. P indicates Pending, R indicates Errored. Check the Err_Mesg field to see the error message.
ERR_MESG VARCHAR2 (250)
Holds the reason why the tax record was not processed. The Error_flag will be R.
SOURCE VARCHAR2 (30) Yes This Column holds the source of the invoice - Whether it is an Auto invoice or a manual Invoice . Possible Values are - RAXTRX - Meaning Auto invoiced Invoice, ARXTWMAI - Meaning Manual Invoice.
CODE_COMBINATION_ID NUMBER (15)
The Code Combination identifier associated with the tax account.
OBJECT_VERSION_NUMBER NUMBER

Object Version Number
INTERFACE_FLAG VARCHAR2 (1)
Identifier of data from Open interface
Query Text

Cut, paste (and edit) the following text to query this object:


SELECT PADDR
,      EXTENDED_AMOUNT
,      CUSTOMER_TRX_LINE_ID
,      CUSTOMER_TRX_ID
,      LINE_NUMBER
,      SET_OF_BOOKS_ID
,      LINK_TO_CUST_TRX_LINE_ID
,      LINE_TYPE
,      ORG_ID
,      UOM_CODE
,      VAT_TAX_ID
,      ACCTD_AMOUNT
,      AMOUNT
,      CUST_TRX_LINE_SALES_REP_ID
,      GL_DATE
,      INSERT_UPDATE_FLAG
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      TAX_RATE
,      ERROR_FLAG
,      ERR_MESG
,      SOURCE
,      CODE_COMBINATION_ID
,      OBJECT_VERSION_NUMBER
,      INTERFACE_FLAG
FROM JA.JAI_AR_TRX_INS_LINES_T;

Dependencies

[top of page]

JA.JAI_AR_TRX_INS_LINES_T does not reference any database object

JA.JAI_AR_TRX_INS_LINES_T is referenced by following:

SchemaJA
ViewJAI_AR_TRX_INS_LINES_T#