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

VIEW: IGI.IGI_CIS_MTH_RET_LINES_H_ALL#

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

[View Source]

Columns
Name Datatype Length Mandatory Comments
HEADER_ID NUMBER (15) Yes
VENDOR_ID NUMBER
Yes
ORG_ID NUMBER (15)
VENDOR_NAME VARCHAR2 (240)
VENDOR_TYPE_LOOKUP_CODE VARCHAR2 (30)
FIRST_NAME VARCHAR2 (240)
SECOND_NAME VARCHAR2 (240)
LAST_NAME VARCHAR2 (240)
SALUTATION VARCHAR2 (30)
TRADING_NAME VARCHAR2 (240)
UNMATCHED_TAX_FLAG VARCHAR2 (1)
UNIQUE_TAX_REFERENCE_NUM NUMBER (15)
COMPANY_REGISTRATION_NUMBER VARCHAR2 (30)
NATIONAL_INSURANCE_NUMBER VARCHAR2 (30)
VERIFICATION_NUMBER VARCHAR2 (30)
TOTAL_PAYMENTS NUMBER

MATERIAL_COST NUMBER

TOTAL_DEDUCTIONS NUMBER

LABOUR_COST NUMBER

DISCOUNT_AMOUNT NUMBER

LAST_UPDATE_DATE DATE
Yes
LAST_UPDATED_BY NUMBER
Yes
LAST_UPDATE_LOGIN NUMBER

CREATION_DATE DATE
Yes
CREATED_BY NUMBER
Yes
CIS_TAX NUMBER

Query Text

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


SELECT HEADER_ID
,      VENDOR_ID
,      ORG_ID
,      VENDOR_NAME
,      VENDOR_TYPE_LOOKUP_CODE
,      FIRST_NAME
,      SECOND_NAME
,      LAST_NAME
,      SALUTATION
,      TRADING_NAME
,      UNMATCHED_TAX_FLAG
,      UNIQUE_TAX_REFERENCE_NUM
,      COMPANY_REGISTRATION_NUMBER
,      NATIONAL_INSURANCE_NUMBER
,      VERIFICATION_NUMBER
,      TOTAL_PAYMENTS
,      MATERIAL_COST
,      TOTAL_DEDUCTIONS
,      LABOUR_COST
,      DISCOUNT_AMOUNT
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      CREATION_DATE
,      CREATED_BY
,      CIS_TAX
FROM IGI.IGI_CIS_MTH_RET_LINES_H_ALL#;

Dependencies

[top of page]

IGI.IGI_CIS_MTH_RET_LINES_H_ALL# references the following:

SchemaIGI
TableIGI_CIS_MTH_RET_LINES_H_ALL
IGI.IGI_CIS_MTH_RET_LINES_H_ALL# is referenced by following:

SchemaAPPS
SynonymIGI_CIS_MTH_RET_LINES_H
SynonymIGI_CIS_MTH_RET_LINES_H_ALL