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

TABLE: IGI.IGI_CIS_MTH_RET_PAY_H_ALL

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


The main table that holds the summary of payments made to a particular subcontractor.
This table has a many to one relationship with IGI_CIS_MTH_RET_LINES_H_ALL table


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Columns
Name Datatype Length Mandatory Comments
HEADER_ID NUMBER (15)
Interface header ID from the IGI_CIS_MTH_RET_HDR_S sequence
ORG_ID NUMBER (15)
Organization ID
VENDOR_ID NUMBER (15)
Vendor ID, in case of Nominees and Debt Factors this is the parent vendor ID
CHILD_VENDOR_ID NUMBER (15)
Vendor ID for Nominees and Debt Factors
INVOICE_ID NUMBER (15)
Invoice ID
INVOICE_PAYMENT_ID NUMBER (15)
Invoice payment ID
AMOUNT NUMBER

Payment amount
LABOUR_COST NUMBER

Labour cost
MATERIAL_COST NUMBER

Material cost
TOTAL_DEDUCTIONS NUMBER

Deducted amount
DISCOUNT_AMOUNT NUMBER

Payment discount
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
,      ORG_ID
,      VENDOR_ID
,      CHILD_VENDOR_ID
,      INVOICE_ID
,      INVOICE_PAYMENT_ID
,      AMOUNT
,      LABOUR_COST
,      MATERIAL_COST
,      TOTAL_DEDUCTIONS
,      DISCOUNT_AMOUNT
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      CREATION_DATE
,      CREATED_BY
FROM IGI.IGI_CIS_MTH_RET_PAY_H_ALL;

Dependencies

[top of page]

IGI.IGI_CIS_MTH_RET_PAY_H_ALL does not reference any database object

IGI.IGI_CIS_MTH_RET_PAY_H_ALL is referenced by following:

SchemaAPPS
SynonymIGI_CIS_MTH_RET_PAY_H
SynonymIGI_CIS_MTH_RET_PAY_H_ALL