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

TABLE: JA.JAI_AR_TRX_CM_T

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


This table holds the details of the st forms
details for an AR credit memo.


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Columns
Name Datatype Length Mandatory Comments
OE_ST_ID NUMBER

Indicates the ST form Identifier.
INV_TRX_ID NUMBER

Customer transaction identifier of the invoice
INV_TRX_NUM VARCHAR2 (40)
Transaction number of the invoice
INV_TARGET_AMT NUMBER

Indicates the Tax target amount of the invoice.
CM_TRX_ID NUMBER

Customer transaction identifier of the credit memo
CM_TRX_NUM VARCHAR2 (40)
Transaction number of the credit memo
CM_TARGET_AMT NUMBER

Indicates the tax target amount of the credit memo.
INV_UPDATE_FLAG VARCHAR2 (1)
Indicates whether the invoice is updated.
INV_TRX_LINE_ID NUMBER

Customer transaction line identifier of the invoice
CM_TRX_LINE_ID NUMBER

Customer transaction line identifier of the Credit memo
CREATED_BY NUMBER (15) Yes Standard Who column
CREATION_DATE DATE
Yes Standard Who column
LAST_UPDATED_BY NUMBER (15) Yes Standard Who column
LAST_UPDATE_DATE DATE
Yes Standard Who column
LAST_UPDATE_LOGIN NUMBER (15)
Standard Who column
OBJECT_VERSION_NUMBER NUMBER

Object Version Number
Query Text

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


SELECT OE_ST_ID
,      INV_TRX_ID
,      INV_TRX_NUM
,      INV_TARGET_AMT
,      CM_TRX_ID
,      CM_TRX_NUM
,      CM_TARGET_AMT
,      INV_UPDATE_FLAG
,      INV_TRX_LINE_ID
,      CM_TRX_LINE_ID
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      OBJECT_VERSION_NUMBER
FROM JA.JAI_AR_TRX_CM_T;

Dependencies

[top of page]

JA.JAI_AR_TRX_CM_T does not reference any database object

JA.JAI_AR_TRX_CM_T is referenced by following:

SchemaAPPS
SynonymJAI_AR_TRX_CM_T