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

TABLE: JA.JAI_RGM_GST_INVOICE_GEN_T

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


This table is used for generating the GST invoice number


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

Identifier of delivery
DELIVERY_DATE DATE

Delivery date
ORDER_LINE_ID NUMBER

Identifier of order line
ORDER_NUMBER NUMBER

Identifier of order
CUSTOMER_TRX_ID NUMBER

Identifier of customer transaction
TRX_DATE DATE

Transaction date
ORGANIZATION_ID NUMBER

Identifier of organization
LOCATION_ID NUMBER

Identifier of location
REQUEST_ID NUMBER

Identifier of request
PROGRAM_APPLICATION_ID NUMBER

Identifier of application of program
PROGRAM_ID NUMBER

Identifier of program
PROGRAM_UPDATE_DATE DATE

Program update date
PARTY_ID NUMBER

Identifier of party
PARTY_SITE_ID NUMBER

Identifier of party site
PARTY_TYPE VARCHAR2 (2)
Party type
GST_INVOICE_NO VARCHAR2 (150)
GST invoice number
GST_INV_GEN_STATUS VARCHAR2 (30)
GST invoice generation status
GST_INV_GEN_ERR_MESSAGE VARCHAR2 (2000)
GST invoice generation error message
GST_ACCT_STATUS VARCHAR2 (30)
GST account status
GST_ACCT_ERR_MESSAGE VARCHAR2 (2000)
GST account error message
CREATION_DATE DATE
Yes Set who column
CREATED_BY NUMBER
Yes Set who column
LAST_UPDATE_DATE DATE
Yes Set who column
LAST_UPDATE_LOGIN NUMBER
Yes Set who column
LAST_UPDATED_BY NUMBER
Yes Set who column
OBJECT_VERSION_NUMBER NUMBER

Object version number
PROGRAM_LOGIN_ID NUMBER

Identifier of login of program
Query Text

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


SELECT DELIVERY_ID
,      DELIVERY_DATE
,      ORDER_LINE_ID
,      ORDER_NUMBER
,      CUSTOMER_TRX_ID
,      TRX_DATE
,      ORGANIZATION_ID
,      LOCATION_ID
,      REQUEST_ID
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
,      PARTY_ID
,      PARTY_SITE_ID
,      PARTY_TYPE
,      GST_INVOICE_NO
,      GST_INV_GEN_STATUS
,      GST_INV_GEN_ERR_MESSAGE
,      GST_ACCT_STATUS
,      GST_ACCT_ERR_MESSAGE
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      LAST_UPDATED_BY
,      OBJECT_VERSION_NUMBER
,      PROGRAM_LOGIN_ID
FROM JA.JAI_RGM_GST_INVOICE_GEN_T;

Dependencies

[top of page]

JA.JAI_RGM_GST_INVOICE_GEN_T does not reference any database object

JA.JAI_RGM_GST_INVOICE_GEN_T is referenced by following:

SchemaJA
ViewJAI_RGM_GST_INVOICE_GEN_T#