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

VIEW: IGI.IGI_CIS_CI36_PAYMENTS#

Object Details
Object Name: IGI_CIS_CI36_PAYMENTS#
Object Type: VIEW
Owner: IGI
Subobject Name:
Status: VALID

[View Source]

Columns
Name Datatype Length Mandatory Comments
INVOICE_ID NUMBER (15) Yes
INVOICE_NUM VARCHAR2 (50) Yes
INVOICE_PAYMENT_ID NUMBER (15) Yes
PAYMENT_NUM NUMBER (15) Yes
AMOUNT NUMBER
Yes
PMT_VCH_NUMBER VARCHAR2 (15)
PMT_VCH_AMOUNT NUMBER

PMT_VCH_DESCRIPTION VARCHAR2 (240)
CHECK_NUMBER NUMBER (15)
CHECK_DATE DATE

VENDOR_ID NUMBER (15) Yes
VENDOR_NAME VARCHAR2 (240)
VENDOR_SITE_ID NUMBER (15) Yes
VENDOR_SITE_CODE VARCHAR2 (100)
GROUP_ID NUMBER (15)
CERTIFICATE_TYPE VARCHAR2 (25)
CERTIFICATE_NUMBER VARCHAR2 (50)
CERTIFICATE_DESCRIPTION VARCHAR2 (50)
NI_NUMBER VARCHAR2 (30)
SEGMENT1 VARCHAR2 (30)
PMT_VCH_RECEIVED_DATE DATE

ADDRESS_LINE1 VARCHAR2 (35)
ADDRESS_LINE2 VARCHAR2 (35)
ADDRESS_LINE3 VARCHAR2 (35)
ZIP VARCHAR2 (20)
Query Text

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#;

Dependencies

[top of page]

IGI.IGI_CIS_CI36_PAYMENTS# references the following:

SchemaIGI
TableIGI_CIS_CI36_PAYMENTS
IGI.IGI_CIS_CI36_PAYMENTS# is referenced by following:

SchemaAPPS
SynonymIGI_CIS_CI36_PAYMENTS