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

TABLE: IGI.IGI_CIS_MTH_RET_LINES_T_ALL

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


Interface 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 the 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)
Subcontractor'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)
Subcontractor's 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 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
CIS_TAX NUMBER

AWT tax amount being reported to the CIS Tax Authority
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
,      CIS_TAX
FROM IGI.IGI_CIS_MTH_RET_LINES_T_ALL;

Dependencies

[top of page]

IGI.IGI_CIS_MTH_RET_LINES_T_ALL does not reference any database object

IGI.IGI_CIS_MTH_RET_LINES_T_ALL is referenced by following:

SchemaIGI
ViewIGI_CIS_MTH_RET_LINES_T_ALL#