[Home] [Help] [Dependency Information]
Object Name: | JG_ZZ_VAT_DOC_SEQUENCES |
---|---|
Object Type: | TABLE |
Owner: | JG |
FND Design Data: | JG.JG_ZZ_VAT_DOC_SEQUENCES |
Subobject Name: | |
Status: | VALID |
Each record in this table stores the FND document sequence associated with VAT register. For reporting purpose document category is derived based on FND document sequence association with document categories.
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
JG_ZZ_VAT_DOC_SEQUENCES_U1 | NORMAL | UNIQUE | APPS_TS_TX_IDX | VAT_DOC_SEQUENCE_ID |
JG_ZZ_VAT_DOC_SEQUENCES_U2 | NORMAL | UNIQUE | APPS_TS_TX_IDX |
VAT_REGISTER_ID
DOC_SEQUENCE_ID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
VAT_REGISTER_ID | NUMBER | (15) | Yes | VAT Register Identifier |
DOC_SEQUENCE_ID | NUMBER | (15) | Yes | Document Sequence Identifier. Foreign key to FND_DOCUMENT_SEQUENCES |
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 | |
VAT_DOC_SEQUENCE_ID | NUMBER | (15) | Yes | VAT Document Sequence Identifier |
LAST_UPDATE_LOGIN | NUMBER | (15) | Standard Who column |
Cut, paste (and edit) the following text to query this object:
SELECT VAT_REGISTER_ID
, DOC_SEQUENCE_ID
, CREATED_BY
, CREATION_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, VAT_DOC_SEQUENCE_ID
, LAST_UPDATE_LOGIN
FROM JG.JG_ZZ_VAT_DOC_SEQUENCES;
JG.JG_ZZ_VAT_DOC_SEQUENCES does not reference any database object
JG.JG_ZZ_VAT_DOC_SEQUENCES is referenced by following:
|
|
|