[Home] [Help] [Dependency Information]
Object Name: | IGI_CIS_MTH_RET_PAY_T_ALL |
---|---|
Object Type: | TABLE |
Owner: | IGI |
Subobject Name: | |
Status: | VALID |
Interface table that holds the summary of payments made to a particular subcontractor.
This table has a many to one relationship with the IGI_CIS_MTH_RET_LINES_T_ALL table.
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
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 |
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_T_ALL;
IGI.IGI_CIS_MTH_RET_PAY_T_ALL does not reference any database object
IGI.IGI_CIS_MTH_RET_PAY_T_ALL is referenced by following:
|
|
|