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

TABLE: JA.JAI_RGM_INVOICE_GEN_T

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


This table has the details of records which have been VAT accounted or which need to be 'VAT' Accounted or those records where VAT Invoice Number needs to be generated or has been generated.


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
JAI_RGM_INVOICE_GEN_T_U1 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnDELIVERY_ID
JAI_RGM_INVOICE_GEN_T_U2 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnCUSTOMER_TRX_ID
Columns
Name Datatype Length Mandatory Comments
REGIME_ID NUMBER

It has the value of the Regime Identifier for which this invoice number is being generated
DELIVERY_ID NUMBER

It has the delivery Identifier of the shipment for which the Invoice Number is generated
DELIVERY_DATE DATE

It has the delivery date on which the shipment happened.
CUSTOMER_TRX_ID NUMBER

The invoice identifier of the AR invoice created. This value is populated only for a manual AR invoice.
TRX_DATE DATE

The invoice date of the Manual AR Invoice.
ORGANIZATION_ID NUMBER

Inventory Organization from where the shipment takes place.
LOCATION_ID NUMBER

Location identifier associated with the subinventory from where the shipment happened.
REGISTRATION_NUM VARCHAR2 (240)
The primary registration number of the regime
VAT_INVOICE_NO VARCHAR2 (240)
The invoice number which was generated.
VAT_INV_GEN_STATUS VARCHAR2 (30)
The Status of the Delivery with respect to Invoice Number Generation. It has Values "P" - Pending , "C" - Completed , "E" - Error
VAT_INV_GEN_ERR_MESSAGE VARCHAR2 (1996)
This column holds the error message when the VAT invoice generation program errored out for a delivery.
VAT_ACCT_STATUS VARCHAR2 (30)
The Status of the Delivery with respect to accounting. It has Values "P" - Pending , "C" - Completed , "E" - Error
VAT_ACCT_ERR_MESSAGE VARCHAR2 (1996)
This column holds the error message when the VAT invoice generation program errored out for a delivery.
REQUEST_ID NUMBER

RequestId of the concurrent request which processed the current delivery
PROGRAM_APPLICATION_ID NUMBER

The Application of the Application in whch the concurrent program was registered.
PROGRAM_ID NUMBER

The Internal Identifier of the Concurrent program
PROGRAM_UPDATE_DATE DATE

The last update date of the concurrent program.
PARTY_ID NUMBER

The Customer / Supplier
PARTY_SITE_ID NUMBER

Customer Site / Supplier Site Identifier
PARTY_TYPE VARCHAR2 (2)
It has "C" - Customer , "V" For Supplier.
CREATION_DATE DATE

Standard Who column
CREATED_BY NUMBER

Standard Who column
LAST_UPDATE_DATE DATE

Standard Who column
LAST_UPDATE_LOGIN NUMBER

Standard Who column
LAST_UPDATED_BY NUMBER

Standard Who column
OBJECT_VERSION_NUMBER NUMBER (9)
Object Version Number.
PROGRAM_LOGIN_ID NUMBER

Identifies the Oracle Applications Concurrent Program Login Identifier
Query Text

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


SELECT REGIME_ID
,      DELIVERY_ID
,      DELIVERY_DATE
,      CUSTOMER_TRX_ID
,      TRX_DATE
,      ORGANIZATION_ID
,      LOCATION_ID
,      REGISTRATION_NUM
,      VAT_INVOICE_NO
,      VAT_INV_GEN_STATUS
,      VAT_INV_GEN_ERR_MESSAGE
,      VAT_ACCT_STATUS
,      VAT_ACCT_ERR_MESSAGE
,      REQUEST_ID
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
,      PARTY_ID
,      PARTY_SITE_ID
,      PARTY_TYPE
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      LAST_UPDATED_BY
,      OBJECT_VERSION_NUMBER
,      PROGRAM_LOGIN_ID
FROM JA.JAI_RGM_INVOICE_GEN_T;

Dependencies

[top of page]

JA.JAI_RGM_INVOICE_GEN_T does not reference any database object

JA.JAI_RGM_INVOICE_GEN_T is referenced by following:

SchemaAPPS
SynonymJAI_RGM_INVOICE_GEN_T