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

TABLE: IGI.IGI_CIS_VERIFY_LINES_T

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


This table contains the subcontractor details for the XML message to verify the subcontractors. The details are collected from the core tables, for example, PO_VENDORS table. The records are stored in this table when the user selects the subcontractors that must be verified. On receiving the XML message from the HMRC, the verification number, match status flag, and tax treatment status are updated in this table.


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 to either 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 used 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)
Verification reference number for the subcontractor
CIS_VERIFICATION_DATE DATE

The date on which 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 the 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_T;

Dependencies

[top of page]

IGI.IGI_CIS_VERIFY_LINES_T does not reference any database object

IGI.IGI_CIS_VERIFY_LINES_T is referenced by following:

SchemaAPPS
SynonymIGI_CIS_VERIFY_LINES_T