[Home] [Help]
[Dependency Information]
[Home] [Help]
[Dependency Information]
| Object Name: | IGI_CIS_CERT_INV_PMT_VCH_V |
|---|---|
| Object Type: | VIEW |
| Owner: | APPS |
| FND Design Data: |  IGI.IGI_CIS_CERT_INV_PMT_VCH_V
|
| Subobject Name: | |
| Status: | VALID |
A supplementary view used to simplify forms coding.
Warning: Oracle does not recommend you query or alter datausing this view. It may change dramatically in subsequent minor or major
releases.
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| ROW_ID | VARCHAR2 | (30) | Record identifier | |
| VENDOR_ID | NUMBER | Yes | Supplier identifier | |
| VENDOR_NAME | VARCHAR2 | (240) | Supplier Name | |
| SEGMENT1 | VARCHAR2 | (30) | Yes | Key flexfield segment |
| SET_OF_BOOKS_ID | NUMBER | Set of Books identifier | ||
| VENDOR_SITE_ID | NUMBER | Yes | Supplier Site identifier | |
| VENDOR_SITE_CODE | VARCHAR2 | (15) | Supplier Site Code | |
| ADDRESS_LINE1 | VARCHAR2 | (240) | First line of Supplier address | |
| ADDRESS_LINE2 | VARCHAR2 | (240) | Second line of Supplier address | |
| ADDRESS_LINE3 | VARCHAR2 | (240) | Third line of Supplier address | |
| ZIP | VARCHAR2 | (20) | Postal Code | |
| CERTIFICATE_TYPE | VARCHAR2 | (30) | Certificate Type | |
| CERTIFICATE_NUMBER | VARCHAR2 | (50) | Certificate Number | |
| CERTIFICATE_DESCRIPTION | VARCHAR2 | (50) | Certificate Description | |
| NI_NUMBER | VARCHAR2 | (30) | National Insurance Number | |
| INVOICE_NUM | VARCHAR2 | (50) | Yes | Invoice Number |
| PAYMENT_STATUS_FLAG | VARCHAR2 | (1) | Flag that indicates if invoice has been paid (Y, N or P) | |
| AMOUNT | NUMBER | Yes | Payment Amount | |
| PAYMENT_NUM | NUMBER | (15) | Yes | Invoice Payment Number |
| CHECK_NUMBER | NUMBER | (15) | Yes | Payment Number |
| CHECK_DATE | DATE | Yes | Payment Date | |
| MATERIAL_AMOUNT | NUMBER | Material component of Payment Amount | ||
| LABOUR_AMOUNT | NUMBER | Laborl component of Payment Amount | ||
| CIS_AMOUNT | NUMBER | Construction Industry Scheme Tax amount | ||
| NET_AMOUNT | NUMBER | Net Invoice Amount | ||
| PMT_VCH_NUMBER | VARCHAR2 | (15) | Payment Voucher Number | |
| PMT_VCH_AMOUNT | NUMBER | Payment Voucher Amount | ||
| PMT_VCH_RECEIVED_DATE | DATE | Payment Voucher Received date | ||
| PMT_VCH_DESCRIPTION | VARCHAR2 | (240) | Payment Voucher Description | |
| CREATED_BY | NUMBER | (15) | Standard who column - user who created this row (foreign key to FND_USER.USER_ID). | |
| CREATION_DATE | DATE | Standard who column - date when this row was created. | ||
| LAST_UPDATE_DATE | DATE | Yes | Standard Who column - date when a user last updated this row. | |
| LAST_UPDATE_LOGIN | NUMBER | (15) | Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID). | |
| LAST_UPDATED_BY | NUMBER | (15) | Yes | Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID). |
| INVOICE_ID | NUMBER | (15) | Yes | Invoice identifier |
| INVOICE_PAYMENT_ID | NUMBER | (15) | Yes | Invoice Payment identifier |
Cut, paste (and edit) the following text to query this object:
SELECT ROW_ID
, VENDOR_ID
, VENDOR_NAME
, SEGMENT1
, SET_OF_BOOKS_ID
, VENDOR_SITE_ID
, VENDOR_SITE_CODE
, ADDRESS_LINE1
, ADDRESS_LINE2
, ADDRESS_LINE3
, ZIP
, CERTIFICATE_TYPE
, CERTIFICATE_NUMBER
, CERTIFICATE_DESCRIPTION
, NI_NUMBER
, INVOICE_NUM
, PAYMENT_STATUS_FLAG
, AMOUNT
, PAYMENT_NUM
, CHECK_NUMBER
, CHECK_DATE
, MATERIAL_AMOUNT
, LABOUR_AMOUNT
, CIS_AMOUNT
, NET_AMOUNT
, PMT_VCH_NUMBER
, PMT_VCH_AMOUNT
, PMT_VCH_RECEIVED_DATE
, PMT_VCH_DESCRIPTION
, CREATED_BY
, CREATION_DATE
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
, LAST_UPDATED_BY
, INVOICE_ID
, INVOICE_PAYMENT_ID
FROM APPS.IGI_CIS_CERT_INV_PMT_VCH_V;
APPS
AP_AWT_GROUPS
AP_CHECKS
AP_INVOICES
AP_INVOICE_DISTRIBUTIONS
AP_TAX_CODES
FND_GLOBAL
- show dependent code
IGI_CIS_AWT_TAX_RATES
IGI_CIS_GET_PROFILE
- show dependent code
IGI_CIS_INVOICE_PAYMENTS
PO_VENDORS
PO_VENDOR_SITES
APPS
IGI_CIS_PMT_VCH_V
|
|
|
|