eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

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

TABLE: JA.JAI_AR_SUP_HDRS_ALL

Object Details

Object Name:	JAI_AR_SUP_HDRS_ALL
Object Type:	TABLE
Owner:	JA
FND Design Data:	JA.JAI_AR_SUP_HDRS_ALL
Subobject Name:
Status:	VALID

This table stores the Supplementary Transaction details.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
JAI_AR_SUP_HDRS_ALL_PK	NORMAL	UNIQUE	APPS_TS_TX_IDX	SUP_HDR_ID
JAI_AR_SUP_HDRS_ALL_UK1	NORMAL	UNIQUE	APPS_TS_TX_IDX	CUSTOMER_TRX_ID SUPP_INV_TYPE
JAI_AR_SUP_HDRS_ALL_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	SUPPLEMENTARY_NUM

Columns

Name	Datatype	Length	Mandatory	Comments
CUSTOMER_TRX_ID	NUMBER	(15)		Indicates the customer transaction identifier of the Invoice.
CUSTOMER_ID	NUMBER	(15)	Yes	Indicates the customer identifier of the invoice.
TRX_DATE	DATE		Yes	Indicates the transaction date of the invoice.
SUPP_INV_DATE	DATE			Indicates the Supplementary Invoice raised date.
SUPP_INV_RAISED_IND	VARCHAR2	(2)	Yes	Indicator to identify whether the Supplementary Invoice has been raised for original invoice.
CHOSEN_FOR_PROCESS	VARCHAR2	(2)	Yes	Indicator to identify whether the Supplementary invoice has been chosen for raising supplementary invoice.
PROCESS_DATE	DATE			Date when the original invoice was processed for supplementary transactions.
SUPP_INV_TYPE	VARCHAR2	(2)		Indicated whether the current invoice is a supplement CM / supplement DM / Supplement Invoice.
EXIST_NET_SALES_AMT	NUMBER			Indicates the existing sales amount for the invoice.
EXIST_EXCISE_AMT	NUMBER			Indicates the existing excise amount for the invoice.
EXIST_OTHER_AMT	NUMBER			Indicates the existing other amount for the invoice.
NEW_NET_SALES_AMT	NUMBER			Indicates the new sales amount for the invoice.
NEW_EXCISE_AMT	NUMBER			Indicates the new excise amount for the invoice.
NEW_OTHER_AMT	NUMBER			Indicates the new other amount for the invoice.
EXCISE_DIFF_AMT	NUMBER			Indicates the difference between the new and old excise amounts.
OTHER_DIFF_AMT	NUMBER			Indicates the difference between the new and old other amounts.
LAST_UPDATE_DATE	DATE			Standard Who column
LAST_UPDATED_BY	NUMBER			Standard Who column
LAST_UPDATE_LOGIN	NUMBER			Standard Who column
CREATION_DATE	DATE			Standard Who column
CREATED_BY	NUMBER			Standard Who column
SET_OF_BOOKS_ID	NUMBER			Indicates the set of books identifier of the supplementary transaction.
CUSTOMER_SITE	NUMBER			Indicates the customer site of the supplementary transaction.
ORG_ID	NUMBER			Indicates the operating unit identifier of the supplementary transaction.
BATCH_ID	NUMBER			Indicates the batch identifier of the supplementary transaction.
SUP_HDR_ID	NUMBER	(15)	Yes	Table Pk. Sequence generated value
SUPPLEMENTARY_NUM	NUMBER	(15)		Indicates the system generated supplementary identifier .
OBJECT_VERSION_NUMBER	NUMBER			Object version Number

Query Text

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


SELECT CUSTOMER_TRX_ID
,      CUSTOMER_ID
,      TRX_DATE
,      SUPP_INV_DATE
,      SUPP_INV_RAISED_IND
,      CHOSEN_FOR_PROCESS
,      PROCESS_DATE
,      SUPP_INV_TYPE
,      EXIST_NET_SALES_AMT
,      EXIST_EXCISE_AMT
,      EXIST_OTHER_AMT
,      NEW_NET_SALES_AMT
,      NEW_EXCISE_AMT
,      NEW_OTHER_AMT
,      EXCISE_DIFF_AMT
,      OTHER_DIFF_AMT
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      CREATION_DATE
,      CREATED_BY
,      SET_OF_BOOKS_ID
,      CUSTOMER_SITE
,      ORG_ID
,      BATCH_ID
,      SUP_HDR_ID
,      SUPPLEMENTARY_NUM
,      OBJECT_VERSION_NUMBER
FROM JA.JAI_AR_SUP_HDRS_ALL;

Dependencies

[top of page]

JA.JAI_AR_SUP_HDRS_ALL does not reference any database object

JA.JAI_AR_SUP_HDRS_ALL is referenced by following:

JA: JAI_AR_SUP_HDRS_ALL#