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

TABLE: IGI.IGI_CIS_MTH_RET_LINES_H_ALL

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


Audit table used in the monthly returns process to store records at the details or lines level


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 from IGI_CIS_MTH_RET_HDR_S sequence
VENDOR_ID NUMBER
Yes Vendor ID
ORG_ID NUMBER (15)
Organization ID
VENDOR_NAME VARCHAR2 (240)
Vendor Name
VENDOR_TYPE_LOOKUP_CODE VARCHAR2 (30)
Vendor type lookup code
FIRST_NAME VARCHAR2 (240)
Subcontractor's first name
SECOND_NAME VARCHAR2 (240)
Sub Contractor's second name
LAST_NAME VARCHAR2 (240)
Subcontractor's last name
SALUTATION VARCHAR2 (30)
Salutation
TRADING_NAME VARCHAR2 (240)
Trading name
UNMATCHED_TAX_FLAG VARCHAR2 (1)
Tax rate indicator that does not match
UNIQUE_TAX_REFERENCE_NUM NUMBER (15)
Subcontractors' unique tax reference number
COMPANY_REGISTRATION_NUMBER VARCHAR2 (30)
Company Registration Number
NATIONAL_INSURANCE_NUMBER VARCHAR2 (30)
National Insurance Number
VERIFICATION_NUMBER VARCHAR2 (30)
Verification reference number for the subcontractor or the partner
TOTAL_PAYMENTS NUMBER

Total payments made to the subcontractor in a particular period
MATERIAL_COST NUMBER

Material cost
TOTAL_DEDUCTIONS NUMBER

Total deductions
LABOUR_COST NUMBER

Labor amount
DISCOUNT_AMOUNT NUMBER

Discount amount
LAST_UPDATE_DATE DATE
Yes Standard Who column
LAST_UPDATED_BY NUMBER
Yes Standard Who column
LAST_UPDATE_LOGIN NUMBER

Standard Who column
CREATION_DATE DATE
Yes Standard Who column
CREATED_BY NUMBER
Yes Standard Who column
Query Text

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


SELECT HEADER_ID
,      VENDOR_ID
,      ORG_ID
,      VENDOR_NAME
,      VENDOR_TYPE_LOOKUP_CODE
,      FIRST_NAME
,      SECOND_NAME
,      LAST_NAME
,      SALUTATION
,      TRADING_NAME
,      UNMATCHED_TAX_FLAG
,      UNIQUE_TAX_REFERENCE_NUM
,      COMPANY_REGISTRATION_NUMBER
,      NATIONAL_INSURANCE_NUMBER
,      VERIFICATION_NUMBER
,      TOTAL_PAYMENTS
,      MATERIAL_COST
,      TOTAL_DEDUCTIONS
,      LABOUR_COST
,      DISCOUNT_AMOUNT
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      CREATION_DATE
,      CREATED_BY
FROM IGI.IGI_CIS_MTH_RET_LINES_H_ALL;

Dependencies

[top of page]

IGI.IGI_CIS_MTH_RET_LINES_H_ALL does not reference any database object

IGI.IGI_CIS_MTH_RET_LINES_H_ALL is referenced by following:

SchemaAPPS
SynonymIGI_CIS_MTH_RET_LINES_H
SynonymIGI_CIS_MTH_RET_LINES_H_ALL