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

TABLE: IGI.IGI_CIS_VERIFY_LINES_H

Object Details
Object Name: IGI_CIS_VERIFY_LINES_H
Object Type: TABLE
Owner: IGI
Subobject Name:
Status: VALID


Maintains the verification process audit detail level records.
The data is populated from the interface lines table on successfully submitting the verification process


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Columns
Name Datatype Length Mandatory Comments
HEADER_ID NUMBER (15) Yes Header ID
ACTION_INDICATOR VARCHAR2 (1)
Action indicator referring to match or verify
VENDOR_TYPE_LOOKUP_CODE VARCHAR2 (30)
Vendor type lookup code
VENDOR_ID NUMBER
Yes Vendor ID
VENDOR_NAME VARCHAR2 (240)
Vendor Name
VENDOR_SITE_ID NUMBER

Vendor Site ID. This identifies the pay site to derive the address
VENDOR_SITE_CODE VARCHAR2 (15)
Vendor site code
FIRST_NAME VARCHAR2 (240)
Subcontractor's first name
SECOND_NAME VARCHAR2 (240)
Subcontractor's second name
LAST_NAME VARCHAR2 (240)
Subcontractor's last name
SALUTATION VARCHAR2 (30)
Salutation
TRADING_NAME VARCHAR2 (240)
Trading name
UNIQUE_TAX_REFERENCE_NUM NUMBER (15)
Subcontractor's unique tax reference number
WORK_REFERENCE VARCHAR2 (30)
Subcontractor's work reference
COMPANY_REGISTRATION_NUMBER VARCHAR2 (30)
Company registration number
NATIONAL_INSURANCE_NUMBER VARCHAR2 (30)
National insurance number
PARTNERSHIP_UTR NUMBER (15)
Partnership Unique Taxpayer Reference
PARTNERSHIP_NAME VARCHAR2 (240)
Partnership name
VERIFICATION_NUMBER VARCHAR2 (30)
Subcontractor's verification reference number
CIS_VERIFICATION_DATE DATE

The date on which the subcontractor is verified. The date is entered after receiving the response
ADDRESS_LINE1 VARCHAR2 (240)
Address Line1
ADDRESS_LINE2 VARCHAR2 (240)
Address Line2
ADDRESS_LINE3 VARCHAR2 (240)
Address Line3
ADDRESS_LINE4 VARCHAR2 (240)
Address Line4
MATCH_STATUS VARCHAR2 (30)
Match status in the XML message.
POST_CODE VARCHAR2 (30)
Postal code
COUNTRY VARCHAR2 (240)
Country
CONTACT_NUMBER VARCHAR2 (30)
Contact number
TAX_TREATMENT_STATUS VARCHAR2 (30)
Tax treatment status in the XML message.
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 user who last updated this row FK FND_ LOGINS.LOGIN_ID.
CREATION_DATE DATE
Yes Standard Who column. The date this row is created.
CREATED_BY NUMBER (15) Yes Standard Who column The user who created this row FK to FND_USER.USER_ID.
Query Text

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


SELECT HEADER_ID
,      ACTION_INDICATOR
,      VENDOR_TYPE_LOOKUP_CODE
,      VENDOR_ID
,      VENDOR_NAME
,      VENDOR_SITE_ID
,      VENDOR_SITE_CODE
,      FIRST_NAME
,      SECOND_NAME
,      LAST_NAME
,      SALUTATION
,      TRADING_NAME
,      UNIQUE_TAX_REFERENCE_NUM
,      WORK_REFERENCE
,      COMPANY_REGISTRATION_NUMBER
,      NATIONAL_INSURANCE_NUMBER
,      PARTNERSHIP_UTR
,      PARTNERSHIP_NAME
,      VERIFICATION_NUMBER
,      CIS_VERIFICATION_DATE
,      ADDRESS_LINE1
,      ADDRESS_LINE2
,      ADDRESS_LINE3
,      ADDRESS_LINE4
,      MATCH_STATUS
,      POST_CODE
,      COUNTRY
,      CONTACT_NUMBER
,      TAX_TREATMENT_STATUS
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      CREATION_DATE
,      CREATED_BY
FROM IGI.IGI_CIS_VERIFY_LINES_H;

Dependencies

[top of page]

IGI.IGI_CIS_VERIFY_LINES_H does not reference any database object

IGI.IGI_CIS_VERIFY_LINES_H is referenced by following:

SchemaIGI
ViewIGI_CIS_VERIFY_LINES_H#