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

TABLE: IGI.IGI_CIS_CDROM_LINES_T

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


This table is used to upload the subcontractor details from the CIS333 CD-ROM. The uploaded subcontractor is matched with suppliers in the contractor database to update the verification information such as withholding tax group, verification date, etc


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Columns
Name Datatype Length Mandatory Comments
SUBCONTRACTOR_UTR NUMBER (15)
Subcontractor's unique tax reference number
SUBCONTRACTOR_NAME VARCHAR2 (240)
Subcontractor's name
SUBCONTRACTOR_REF_ID VARCHAR2 (30)
National insurance number or company registration number
TAX_MONTH_LAST_PAID DATE

Tax paid last month
TAX_TREATMENT VARCHAR2 (30)
Tax treatment
MATCH_FLAG VARCHAR2 (1)
Subcontractor match status
LAST_UPDATE_DATE DATE

Standard Who column. The date the user last updated this row.
LAST_UPDATED_BY NUMBER (15)
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

Standard Who column. The date this row is created
CREATED_BY NUMBER (15)
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 SUBCONTRACTOR_UTR
,      SUBCONTRACTOR_NAME
,      SUBCONTRACTOR_REF_ID
,      TAX_MONTH_LAST_PAID
,      TAX_TREATMENT
,      MATCH_FLAG
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      CREATION_DATE
,      CREATED_BY
FROM IGI.IGI_CIS_CDROM_LINES_T;

Dependencies

[top of page]

IGI.IGI_CIS_CDROM_LINES_T does not reference any database object

IGI.IGI_CIS_CDROM_LINES_T is referenced by following:

SchemaAPPS
SynonymIGI_CIS_CDROM_LINES_T