[Home] [Help] [Dependency Information]
Object Name: | IGI_CIS_VERIFY_HEADERS_H |
---|---|
Object Type: | TABLE |
Owner: | IGI |
Subobject Name: | |
Status: | VALID |
Maintains the verification process audit header records.
The data is populated from the interface header table on successfully submitting the verification process.
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
HEADER_ID | NUMBER | (15) | Yes | Verification header ID.This Id is generated from theIGI_CIS_VERIFY_HEADERS_T_S sequence |
REQUEST_ID | NUMBER | (15) | Concurrent program request ID that last updated this row | |
UNIQUE_TAX_REFERENCE_NUM | NUMBER | (15) | Unique tax reference number of reporting entity, contractor | |
REQUEST_STATUS_CODE | VARCHAR2 | (1) | Request Status | |
ACCOUNTS_OFFICE_REFERENCE | VARCHAR2 | (30) | Accounts office reference of the reporting entity | |
CIS_SENDER_ID | VARCHAR2 | (30) | CIS sender ID | |
TAX_OFFICE_NUMBER | NUMBER | (15) | Tax office reference of the contractor | |
PAYE_REFERENCE | VARCHAR2 | (30) | PAYE reference for the contractor | |
PROGRAM_ID | NUMBER | (15) | Concurrent program Who column. The program ID that last updated this row. | |
PROGRAM_APPLICATION_ID | NUMBER | (15) | Concurrent program Who column The application ID of the program that last updated this row. | |
PROGRAM_LOGIN_ID | NUMBER | (15) | Identifies the Oracle Applications concurrent program login ID | |
PROGRAM_UPDATE_DATE | DATE | Concurrent Program Who column. The date the program last updated this row. | ||
LAST_UPDATE_DATE | DATE | Yes | Standard Who column. The date the user last updated this row. | |
LAST_UPDATED_BY | NUMBER | (15) | Yes | Standard Who column The user who created this row FK to FND_USER.USER_ID |
LAST_UPDATE_LOGIN | NUMBER | (15) | Standard Who column The operating system login of the user who last updated this row FK FND_ LOGINS.LOGIN_ID. | |
CREATION_DATE | DATE | Yes | Standard Who column. The date this row was created. | |
CREATED_BY | NUMBER | (15) | Yes | Standard Who column. The user who created this row FK to FND_USER.USER_ID. |
Cut, paste (and edit) the following text to query this object:
SELECT HEADER_ID
, REQUEST_ID
, UNIQUE_TAX_REFERENCE_NUM
, REQUEST_STATUS_CODE
, ACCOUNTS_OFFICE_REFERENCE
, CIS_SENDER_ID
, TAX_OFFICE_NUMBER
, PAYE_REFERENCE
, PROGRAM_ID
, PROGRAM_APPLICATION_ID
, PROGRAM_LOGIN_ID
, PROGRAM_UPDATE_DATE
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_LOGIN
, CREATION_DATE
, CREATED_BY
FROM IGI.IGI_CIS_VERIFY_HEADERS_H;
IGI.IGI_CIS_VERIFY_HEADERS_H does not reference any database object
IGI.IGI_CIS_VERIFY_HEADERS_H is referenced by following:
|
|
|