[Home] [Help] [Dependency Information]
Object Name: | IGI_CIS_CI36_PAYMENTS |
---|---|
Object Type: | TABLE |
Owner: | IGI |
FND Design Data: | IGI.IGI_CIS_CI36_PAYMENTS |
Subobject Name: | |
Status: | VALID |
IGI_CIS_CI36_PAYMENTS Stores payments to be processed for the (IGIPCI36) 'End of Year Returns' report
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
INVOICE_ID | NUMBER | (15) | Yes | Invoice Identifier |
INVOICE_NUM | VARCHAR2 | (50) | Yes | Invoice Number |
INVOICE_PAYMENT_ID | NUMBER | (15) | Yes | Invoice Payment Identifier |
PAYMENT_NUM | NUMBER | (15) | Yes | Payment Number |
AMOUNT | NUMBER | Yes | Payment Amount | |
PMT_VCH_NUMBER | VARCHAR2 | (15) | Payment Voucher Number | |
PMT_VCH_AMOUNT | NUMBER | Payment Voucher Amount | ||
PMT_VCH_DESCRIPTION | VARCHAR2 | (240) | Payment Voucher Description | |
CHECK_NUMBER | NUMBER | (15) | Payment Check Number | |
CHECK_DATE | DATE | Payment Check Date | ||
VENDOR_ID | NUMBER | (15) | Yes | Vendor Identifier |
VENDOR_NAME | VARCHAR2 | (240) | Vendor Name | |
VENDOR_SITE_ID | NUMBER | (15) | Yes | Vendor Site Identifier |
VENDOR_SITE_CODE | VARCHAR2 | (100) | Vendor Site Code | |
GROUP_ID | NUMBER | (15) | Tax Group Identifier | |
CERTIFICATE_TYPE | VARCHAR2 | (25) | CIS Certificate Type | |
CERTIFICATE_NUMBER | VARCHAR2 | (50) | CIS Certificate Number | |
CERTIFICATE_DESCRIPTION | VARCHAR2 | (50) | CIS Certificate Description | |
NI_NUMBER | VARCHAR2 | (30) | National Insurance Number | |
SEGMENT1 | VARCHAR2 | (30) | Key flexfield segment | |
PMT_VCH_RECEIVED_DATE | DATE | CIS Payment Voucher received date | ||
ADDRESS_LINE1 | VARCHAR2 | (35) | Address Line 1 | |
ADDRESS_LINE2 | VARCHAR2 | (35) | Address Line 2 | |
ADDRESS_LINE3 | VARCHAR2 | (35) | Address Line 3 | |
ZIP | VARCHAR2 | (20) | ZIP code |
Cut, paste (and edit) the following text to query this object:
SELECT INVOICE_ID
, INVOICE_NUM
, INVOICE_PAYMENT_ID
, PAYMENT_NUM
, AMOUNT
, PMT_VCH_NUMBER
, PMT_VCH_AMOUNT
, PMT_VCH_DESCRIPTION
, CHECK_NUMBER
, CHECK_DATE
, VENDOR_ID
, VENDOR_NAME
, VENDOR_SITE_ID
, VENDOR_SITE_CODE
, GROUP_ID
, CERTIFICATE_TYPE
, CERTIFICATE_NUMBER
, CERTIFICATE_DESCRIPTION
, NI_NUMBER
, SEGMENT1
, PMT_VCH_RECEIVED_DATE
, ADDRESS_LINE1
, ADDRESS_LINE2
, ADDRESS_LINE3
, ZIP
FROM IGI.IGI_CIS_CI36_PAYMENTS;
IGI.IGI_CIS_CI36_PAYMENTS does not reference any database object
IGI.IGI_CIS_CI36_PAYMENTS is referenced by following:
|
|
|