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

TABLE: JA.JAI_AR_TRXS

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


Stores information about the receivables invoices.


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
JAI_AR_TRXS_N1 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnTRX_NUMBER
JAI_AR_TRXS_PK NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnCUSTOMER_TRX_ID
Columns
Name Datatype Length Mandatory Comments
CUSTOMER_TRX_ID NUMBER (15) Yes Customer transaction identifier.
ORGANIZATION_ID NUMBER

Organization identifier.
LOCATION_ID NUMBER

Location identifier.
UPDATE_RG_FLAG VARCHAR2 (1)
Update RG Flag Indicator.
ONCE_COMPLETED_FLAG VARCHAR2 (1)
Once complete flag for transactions.
TOTAL_AMOUNT NUMBER

Sum of the total tax amount and line amounts for a customer transaction performed.
LINE_AMOUNT NUMBER

Amount corresponding to a line.
TAX_AMOUNT NUMBER

Amount indicating the tax to be paid.
TRX_NUMBER VARCHAR2 (20) Yes Transaction Number.
BATCH_SOURCE_ID NUMBER (15)
Batch source Identifier for transaction.
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
SET_OF_BOOKS_ID NUMBER (15)
Ledger identifier
PRIMARY_SALESREP_ID NUMBER (15)
Primary Sales representative Identifier.
INVOICE_CURRENCY_CODE VARCHAR2 (15)
Invoice Currency Code.
EXCHANGE_RATE_TYPE VARCHAR2 (30)
Exchange Rate Type.
EXCHANGE_DATE DATE

Exchange Date.
EXCHANGE_RATE NUMBER

Exchange rate.
CREATED_FROM VARCHAR2 (30)
Created from.
UPDATE_RG23D_FLAG VARCHAR2 (1)
Update RG23D Flag Indicator.
TAX_INVOICE_NO VARCHAR2 (100)
Tax Invoice Number.
VAT_INVOICE_NO VARCHAR2 (240)
VAT invoice number.
VAT_INVOICE_DATE DATE

VAT exemption Date.
OBJECT_VERSION_NUMBER NUMBER

Object Version Number
LEGAL_ENTITY_ID NUMBER (15)
Legal entity identifier
ST_INV_NUMBER VARCHAR2 (240)
Service Tax Invoice Number
GST_INVOICE_NO VARCHAR2 (150)
GST Invoice Number
GST_INVOICE_DATE DATE

GST Invoice Date
COMPLETE_FLAG VARCHAR2 (1)
Complete Flag
SHIP_TO_CUSTOMER_ID NUMBER

Ship to Customer ID
SHIP_TO_SITE_USE_ID NUMBER

Ship to Site Use ID
Query Text

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


SELECT CUSTOMER_TRX_ID
,      ORGANIZATION_ID
,      LOCATION_ID
,      UPDATE_RG_FLAG
,      ONCE_COMPLETED_FLAG
,      TOTAL_AMOUNT
,      LINE_AMOUNT
,      TAX_AMOUNT
,      TRX_NUMBER
,      BATCH_SOURCE_ID
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      SET_OF_BOOKS_ID
,      PRIMARY_SALESREP_ID
,      INVOICE_CURRENCY_CODE
,      EXCHANGE_RATE_TYPE
,      EXCHANGE_DATE
,      EXCHANGE_RATE
,      CREATED_FROM
,      UPDATE_RG23D_FLAG
,      TAX_INVOICE_NO
,      VAT_INVOICE_NO
,      VAT_INVOICE_DATE
,      OBJECT_VERSION_NUMBER
,      LEGAL_ENTITY_ID
,      ST_INV_NUMBER
,      GST_INVOICE_NO
,      GST_INVOICE_DATE
,      COMPLETE_FLAG
,      SHIP_TO_CUSTOMER_ID
,      SHIP_TO_SITE_USE_ID
FROM JA.JAI_AR_TRXS;

Dependencies

[top of page]

JA.JAI_AR_TRXS does not reference any database object

JA.JAI_AR_TRXS is referenced by following:

SchemaJA
ViewJAI_AR_TRXS#