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

TABLE: IGI.IGI_CIS_CI36_EXTRACT

Object Details
Object Name: IGI_CIS_CI36_EXTRACT
Object Type: TABLE
Owner: IGI
FND Design Data: TableIGI.IGI_CIS_CI36_EXTRACT
Subobject Name:
Status: VALID


IGI_CIS_CI36_EXTRACT stores data extracted for the (IGIPCI36) 'End of Year Returns' report.


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Columns
Name Datatype Length Mandatory Comments
CERTIFICATE_TYPE VARCHAR2 (25)
CIS Certificate Type
VENDOR_NAME VARCHAR2 (240)
CIS Vendor Name
VENDOR_SITE_CODE VARCHAR2 (100)
Vendor Site Code
CERTIFICATE_NUMBER VARCHAR2 (50)
CIS Certificate Number
CERTIFICATE_DESCRIPTION VARCHAR2 (50)
CIS Certificate Description
NI_NUMBER VARCHAR2 (30)
National Insurance Number
PMT_VCH_NUMBER VARCHAR2 (15)
Payment Voucher Number
PMT_VCH_DESCRIPTION VARCHAR2 (240)
Payment Voucher Description
MATERIAL_AMOUNT NUMBER

Material Amount
LABOR_AMOUNT NUMBER

Labor Amount
CIS_AMOUNT NUMBER

CIS Tax Amount
NET_AMOUNT NUMBER

Net Amount
SEGMENT1 VARCHAR2 (30)
Key flexfield segment
INVOICE_NUM VARCHAR2 (50)
Invoice Number
CHECK_NUMBER NUMBER (15)
Check Number
CHECK_DATE DATE

Check Date
AMOUNT NUMBER

Amount
PMT_VCH_RECEIVED_DATE DATE

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
Query Text

Cut, paste (and edit) the following text to query this object:


SELECT CERTIFICATE_TYPE
,      VENDOR_NAME
,      VENDOR_SITE_CODE
,      CERTIFICATE_NUMBER
,      CERTIFICATE_DESCRIPTION
,      NI_NUMBER
,      PMT_VCH_NUMBER
,      PMT_VCH_DESCRIPTION
,      MATERIAL_AMOUNT
,      LABOR_AMOUNT
,      CIS_AMOUNT
,      NET_AMOUNT
,      SEGMENT1
,      INVOICE_NUM
,      CHECK_NUMBER
,      CHECK_DATE
,      AMOUNT
,      PMT_VCH_RECEIVED_DATE
,      ADDRESS_LINE1
,      ADDRESS_LINE2
,      ADDRESS_LINE3
,      ZIP
FROM IGI.IGI_CIS_CI36_EXTRACT;

Dependencies

[top of page]

IGI.IGI_CIS_CI36_EXTRACT does not reference any database object

IGI.IGI_CIS_CI36_EXTRACT is referenced by following:

SchemaAPPS
SynonymIGI_CIS_CI36_EXTRACT