Skip to content

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

VIEW: JG.JG_ZZ_AP_WHT_ITF#

Object Details
Object Name: JG_ZZ_AP_WHT_ITF#
Object Type: VIEW
Owner: JG
Subobject Name:
Status: VALID

[View Source]

Columns
Name Datatype Length Mandatory Comments
HRL_GLOBAL_ATTRIBUTE3 VARCHAR2 (150)
HRL_GLOBAL_ATTRIBUTE4 VARCHAR2 (150)
HRL_GLOBAL_ATTRIBUTE5 VARCHAR2 (150)
HRL_GLOBAL_ATTRIBUTE6 VARCHAR2 (150)
HRL_GLOBAL_ATTRIBUTE7 VARCHAR2 (150)
HRL_GLOBAL_ATTRIBUTE8 VARCHAR2 (150)
HRL_GLOBAL_ATTRIBUTE9 VARCHAR2 (150)
HRL_GLOBAL_ATTRIBUTE10 VARCHAR2 (150)
HRL_GLOBAL_ATTRIBUTE11 VARCHAR2 (150)
HRL_GLOBAL_ATTRIBUTE12 VARCHAR2 (150)
HRL_GLOBAL_ATTRIBUTE13 VARCHAR2 (150)
HRL_GLOBAL_ATTRIBUTE14 VARCHAR2 (150)
HRL_GLOBAL_ATTRIBUTE15 VARCHAR2 (150)
HRL_GLOBAL_ATTRIBUTE16 VARCHAR2 (150)
HRL_GLOBAL_ATTRIBUTE17 VARCHAR2 (150)
HRL_GLOBAL_ATTRIBUTE18 VARCHAR2 (150)
HRL_GLOBAL_ATTRIBUTE19 VARCHAR2 (150)
HRL_GLOBAL_ATTRIBUTE20 VARCHAR2 (150)
HRL_GA_CATEGORY VARCHAR2 (150)
LOCATION_NAME VARCHAR2 (60)
LOCATION_ADDRESS1 VARCHAR2 (240)
LOCATION_ADDRESS2 VARCHAR2 (240)
LOCATION_ADDRESS3 VARCHAR2 (240)
LOCATION_COUNTRY VARCHAR2 (60)
LOCATION_ZIPCODE VARCHAR2 (30)
LOCATION_PHONE VARCHAR2 (30)
LOCATION_FAX VARCHAR2 (60)
HRL_GLOBAL_ATTRIBUTE1 VARCHAR2 (150)
HRL_GLOBAL_ATTRIBUTE2 VARCHAR2 (150)
SUPPLIER_ID NUMBER
Yes
SUPPLIER_SITE_ID NUMBER
Yes
SUPPLIER_NAME VARCHAR2 (240) Yes
SUPPLIER_SITE_NAME VARCHAR2 (15) Yes
PV_ATTRIBUTE1 VARCHAR2 (150)
PV_ATTRIBUTE2 VARCHAR2 (150)
PV_ATTRIBUTE3 VARCHAR2 (150)
PV_ATTRIBUTE4 VARCHAR2 (150)
PV_ATTRIBUTE5 VARCHAR2 (150)
PV_ATTRIBUTE6 VARCHAR2 (150)
PV_ATTRIBUTE7 VARCHAR2 (150)
PV_ATTRIBUTE8 VARCHAR2 (150)
PV_ATTRIBUTE9 VARCHAR2 (150)
PV_ATTRIBUTE10 VARCHAR2 (150)
PV_ATTRIBUTE11 VARCHAR2 (150)
PV_ATTRIBUTE12 VARCHAR2 (150)
PV_ATTRIBUTE13 VARCHAR2 (150)
PV_ATTRIBUTE14 VARCHAR2 (150)
PV_ATTRIBUTE15 VARCHAR2 (150)
PV_ATTRIBUTE_CATEGORY VARCHAR2 (150)
PV_GA_CATEGORY VARCHAR2 (150)
PV_GLOBAL_ATTRIBUTE1 VARCHAR2 (150)
PV_GLOBAL_ATTRIBUTE2 VARCHAR2 (150)
PV_GLOBAL_ATTRIBUTE3 VARCHAR2 (150)
PV_GLOBAL_ATTRIBUTE4 VARCHAR2 (150)
PV_GLOBAL_ATTRIBUTE5 VARCHAR2 (150)
PV_GLOBAL_ATTRIBUTE6 VARCHAR2 (150)
PV_GLOBAL_ATTRIBUTE7 VARCHAR2 (150)
PV_GLOBAL_ATTRIBUTE8 VARCHAR2 (150)
PV_GLOBAL_ATTRIBUTE9 VARCHAR2 (150)
PV_GLOBAL_ATTRIBUTE10 VARCHAR2 (150)
PV_GLOBAL_ATTRIBUTE11 VARCHAR2 (150)
PV_GLOBAL_ATTRIBUTE12 VARCHAR2 (150)
PV_GLOBAL_ATTRIBUTE13 VARCHAR2 (150)
PV_GLOBAL_ATTRIBUTE14 VARCHAR2 (150)
PV_GLOBAL_ATTRIBUTE15 VARCHAR2 (150)
PV_GLOBAL_ATTRIBUTE16 VARCHAR2 (150)
PV_GLOBAL_ATTRIBUTE17 VARCHAR2 (150)
PV_GLOBAL_ATTRIBUTE18 VARCHAR2 (150)
PV_GLOBAL_ATTRIBUTE19 VARCHAR2 (150)
PV_GLOBAL_ATTRIBUTE20 VARCHAR2 (150)
PVS_ATTRIBUTE1 VARCHAR2 (150)
PVS_ATTRIBUTE2 VARCHAR2 (150)
PVS_ATTRIBUTE3 VARCHAR2 (150)
PVS_ATTRIBUTE4 VARCHAR2 (150)
PVS_ATTRIBUTE5 VARCHAR2 (150)
PVS_ATTRIBUTE6 VARCHAR2 (150)
PVS_ATTRIBUTE7 VARCHAR2 (150)
PVS_ATTRIBUTE8 VARCHAR2 (150)
PVS_ATTRIBUTE9 VARCHAR2 (150)
PVS_ATTRIBUTE10 VARCHAR2 (150)
PVS_ATTRIBUTE11 VARCHAR2 (150)
PVS_ATTRIBUTE12 VARCHAR2 (150)
PVS_ATTRIBUTE13 VARCHAR2 (150)
PVS_ATTRIBUTE14 VARCHAR2 (150)
PVS_ATTRIBUTE15 VARCHAR2 (150)
PVS_GLOBAL_ATTRIBUTE3 VARCHAR2 (150)
PVS_GLOBAL_ATTRIBUTE4 VARCHAR2 (150)
PVS_GLOBAL_ATTRIBUTE5 VARCHAR2 (150)
PVS_GLOBAL_ATTRIBUTE6 VARCHAR2 (150)
PVS_GLOBAL_ATTRIBUTE7 VARCHAR2 (150)
PVS_GLOBAL_ATTRIBUTE8 VARCHAR2 (150)
PVS_GLOBAL_ATTRIBUTE9 VARCHAR2 (150)
PVS_GLOBAL_ATTRIBUTE10 VARCHAR2 (150)
PVS_GLOBAL_ATTRIBUTE11 VARCHAR2 (150)
PVS_GLOBAL_ATTRIBUTE12 VARCHAR2 (150)
PVS_GLOBAL_ATTRIBUTE13 VARCHAR2 (150)
PVS_GLOBAL_ATTRIBUTE14 VARCHAR2 (150)
PVS_GLOBAL_ATTRIBUTE15 VARCHAR2 (150)
PVS_GLOBAL_ATTRIBUTE16 VARCHAR2 (150)
PVS_GLOBAL_ATTRIBUTE17 VARCHAR2 (150)
PVS_GLOBAL_ATTRIBUTE18 VARCHAR2 (150)
PVS_GLOBAL_ATTRIBUTE19 VARCHAR2 (150)
PVS_GLOBAL_ATTRIBUTE20 VARCHAR2 (150)
PVS_ATTRIBUTE_CATEGORY VARCHAR2 (150)
PVS_GA_CATEGORY VARCHAR2 (150)
INV_ATTRIBUTE1 VARCHAR2 (150)
INV_ATTRIBUTE2 VARCHAR2 (150)
INV_ATTRIBUTE3 VARCHAR2 (150)
INV_ATTRIBUTE4 VARCHAR2 (150)
INV_ATTRIBUTE5 VARCHAR2 (150)
INV_ATTRIBUTE6 VARCHAR2 (150)
INV_ATTRIBUTE7 VARCHAR2 (150)
INV_ATTRIBUTE8 VARCHAR2 (150)
INV_ATTRIBUTE9 VARCHAR2 (150)
INV_ATTRIBUTE10 VARCHAR2 (150)
INV_ATTRIBUTE11 VARCHAR2 (150)
INV_ATTRIBUTE12 VARCHAR2 (150)
INV_ATTRIBUTE13 VARCHAR2 (150)
INV_ATTRIBUTE14 VARCHAR2 (150)
INV_ATTRIBUTE15 VARCHAR2 (150)
INV_GLOBAL_ATTRIBUTE1 VARCHAR2 (150)
INV_GLOBAL_ATTRIBUTE2 VARCHAR2 (150)
INV_GLOBAL_ATTRIBUTE3 VARCHAR2 (150)
INV_GLOBAL_ATTRIBUTE4 VARCHAR2 (150)
INV_GLOBAL_ATTRIBUTE5 VARCHAR2 (150)
INV_GLOBAL_ATTRIBUTE6 VARCHAR2 (150)
INV_GLOBAL_ATTRIBUTE7 VARCHAR2 (150)
INV_GLOBAL_ATTRIBUTE8 VARCHAR2 (150)
INV_GLOBAL_ATTRIBUTE9 VARCHAR2 (150)
INV_GLOBAL_ATTRIBUTE10 VARCHAR2 (150)
INV_GLOBAL_ATTRIBUTE11 VARCHAR2 (150)
INV_GLOBAL_ATTRIBUTE12 VARCHAR2 (150)
INV_GLOBAL_ATTRIBUTE13 VARCHAR2 (150)
INV_GLOBAL_ATTRIBUTE14 VARCHAR2 (150)
INV_GLOBAL_ATTRIBUTE15 VARCHAR2 (150)
INV_GLOBAL_ATTRIBUTE16 VARCHAR2 (150)
INV_GLOBAL_ATTRIBUTE17 VARCHAR2 (150)
INV_GLOBAL_ATTRIBUTE18 VARCHAR2 (150)
INV_GLOBAL_ATTRIBUTE19 VARCHAR2 (150)
INV_GLOBAL_ATTRIBUTE20 VARCHAR2 (150)
INV_ATTRIBUTE_CATEGORY VARCHAR2 (150)
INV_GA_CATEGORY VARCHAR2 (150)
IND_GLOBAL_ATTRIBUTE1 VARCHAR2 (150)
IND_GLOBAL_ATTRIBUTE2 VARCHAR2 (150)
IND_GLOBAL_ATTRIBUTE3 VARCHAR2 (150)
IND_GLOBAL_ATTRIBUTE4 VARCHAR2 (150)
IND_GLOBAL_ATTRIBUTE5 VARCHAR2 (150)
IND_GLOBAL_ATTRIBUTE6 VARCHAR2 (150)
IND_GLOBAL_ATTRIBUTE7 VARCHAR2 (150)
IND_GLOBAL_ATTRIBUTE8 VARCHAR2 (150)
IND_GLOBAL_ATTRIBUTE9 VARCHAR2 (150)
IND_GLOBAL_ATTRIBUTE10 VARCHAR2 (150)
IND_GLOBAL_ATTRIBUTE11 VARCHAR2 (150)
IND_GLOBAL_ATTRIBUTE12 VARCHAR2 (150)
IND_GLOBAL_ATTRIBUTE13 VARCHAR2 (150)
IND_GLOBAL_ATTRIBUTE14 VARCHAR2 (150)
IND_GLOBAL_ATTRIBUTE15 VARCHAR2 (150)
IND_GLOBAL_ATTRIBUTE16 VARCHAR2 (150)
IND_GLOBAL_ATTRIBUTE17 VARCHAR2 (150)
IND_GLOBAL_ATTRIBUTE18 VARCHAR2 (150)
IND_GLOBAL_ATTRIBUTE19 VARCHAR2 (150)
IND_GLOBAL_ATTRIBUTE20 VARCHAR2 (150)
IND_GA_CATEGORY VARCHAR2 (150)
SUPPLIER_COUNTRY VARCHAR2 (25)
SUPPLIER_ADDRESS_LINE1 VARCHAR2 (240)
SUPPLIER_ADDRESS_LINE2 VARCHAR2 (240)
SUPPLIER_ADDRESS_LINE3 VARCHAR2 (240)
SUPPLIER_CITY VARCHAR2 (25)
SUPPLIER_POSTAL_CODE VARCHAR2 (20)
SUPPLIER_PROVINCE VARCHAR2 (150)
SUPPLIER_COUNTY VARCHAR2 (150)
SUPP_CONCATENATED_ADDRESS VARCHAR2 (800)
PVS_GLOBAL_ATTRIBUTE1 VARCHAR2 (150)
SUPPLIER_TAX_REGISTRATION_NUM VARCHAR2 (20)
SUPPLIER_TAXPAYER_ID VARCHAR2 (30)
PVS_GLOBAL_ATTRIBUTE2 VARCHAR2 (150)
BIZ_INC_SUB_CATEG_MEANING VARCHAR2 (80)
DIST_CODE_COMBINATION_ID NUMBER (15)
ACCOUNTING_FLEXFIELD VARCHAR2 (1000)
TRANSACTION_NUMBER VARCHAR2 (50) Yes
ACCOUNTING_DATE DATE
Yes
DOCUMENT_NUMBER VARCHAR2 (50)
ORGANIZATION_TYPE VARCHAR2 (25)
ORG_TYPE_MEANING VARCHAR2 (80)
TAX_ID NUMBER (15) Yes
TAX_CODE VARCHAR2 (15) Yes
AWT_DESCRIPTION VARCHAR2 (240)
TAX_TYPE VARCHAR2 (25)
TAX_RATE_ID NUMBER (15) Yes
TAX_RATE NUMBER
Yes
ATC_GLOBAL_ATTRIBUTE6 VARCHAR2 (150)
ATC_GLOBAL_ATTRIBUTE7 VARCHAR2 (150)
ATC_GLOBAL_ATTRIBUTE1 VARCHAR2 (150)
ATC_GLOBAL_ATTRIBUTE2 VARCHAR2 (150)
ATC_GLOBAL_ATTRIBUTE3 VARCHAR2 (150)
ATC_GLOBAL_ATTRIBUTE8 VARCHAR2 (150)
ATC_GLOBAL_ATTRIBUTE9 VARCHAR2 (150)
ATC_GLOBAL_ATTRIBUTE10 VARCHAR2 (150)
ATC_GLOBAL_ATTRIBUTE11 VARCHAR2 (150)
ATC_GLOBAL_ATTRIBUTE12 VARCHAR2 (150)
ATC_GLOBAL_ATTRIBUTE13 VARCHAR2 (150)
ATC_GLOBAL_ATTRIBUTE14 VARCHAR2 (150)
ATC_GLOBAL_ATTRIBUTE15 VARCHAR2 (150)
ATC_GLOBAL_ATTRIBUTE16 VARCHAR2 (150)
ATC_GLOBAL_ATTRIBUTE17 VARCHAR2 (150)
ATC_GLOBAL_ATTRIBUTE18 VARCHAR2 (150)
ATC_GLOBAL_ATTRIBUTE19 VARCHAR2 (150)
ATC_GLOBAL_ATTRIBUTE20 VARCHAR2 (150)
ATC_GA_CATEGORY VARCHAR2 (150)
WH_TAX_TYPE_MEANING VARCHAR2 (80)
ATC_GLOBAL_ATTRIBUTE4 VARCHAR2 (150)
RES_INC_CATEG_MEANING VARCHAR2 (80)
ATC_GLOBAL_ATTRIBUTE5 VARCHAR2 (150)
FOR_INC_CATEG_MEANING VARCHAR2 (80)
TAX_AUTHORITY_NAME VARCHAR2 (240) Yes
STATUS VARCHAR2 (1)
INCOME_TAX NUMBER

RESIDENT_TAX NUMBER

TOTAL_WHT_AMOUNT NUMBER

PAYMENT_CURRENCY VARCHAR2 (15)
INVOICE_PAYMENT_ID NUMBER (15)
PAYMENT_AMOUNT NUMBER

PAYMENT_DATE DATE

PAYMENT_NUMBER NUMBER (15)
CHECK_ID NUMBER (15)
CHECK_NUMBER NUMBER (15)
CHECK_AMOUNT NUMBER

INVOICE_ID NUMBER (15) Yes
INVOICE_DISTRIBUTION_ID NUMBER (15) Yes
INVOICE_AMOUNT NUMBER

INVOICE_DATE DATE

CURRENCY_CODE VARCHAR2 (15)
FUNC_CURRENCY_CODE VARCHAR2 (15)
AMT_SUBJECT_TO_WH NUMBER

RECOGNIZED_EXPENSE_AMT NUMBER

INC_WH_TAX_BASE_AMT NUMBER

RES_WH_TAX_BASE_AMT NUMBER

TOTAL_TAX_BASE_AMT NUMBER

NET_AMOUNT NUMBER

LINE_NUMBER NUMBER (15)
TYPE_1099 VARCHAR2 (10)
ITEM_DESCRIPTION VARCHAR2 (240)
ORGANIZATION_NAME VARCHAR2 (60)
REPORTING_ENTITY_NAME VARCHAR2 (50)
REPORTING_SOB_NAME VARCHAR2 (30)
SOB_ID NUMBER (15) Yes
REQUEST_ID NUMBER (15) Yes
NOMINAL_OR_REG_TAX_RATE NUMBER

LAST_UPDATE_DATE DATE
Yes
LAST_UPDATED_BY NUMBER (15) Yes
LAST_UPDATE_LOGIN NUMBER (15) Yes
CREATION_DATE DATE
Yes
CREATED_BY NUMBER (15) Yes
INVOICE_LINE_NUM NUMBER

Query Text

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


SELECT HRL_GLOBAL_ATTRIBUTE3
,      HRL_GLOBAL_ATTRIBUTE4
,      HRL_GLOBAL_ATTRIBUTE5
,      HRL_GLOBAL_ATTRIBUTE6
,      HRL_GLOBAL_ATTRIBUTE7
,      HRL_GLOBAL_ATTRIBUTE8
,      HRL_GLOBAL_ATTRIBUTE9
,      HRL_GLOBAL_ATTRIBUTE10
,      HRL_GLOBAL_ATTRIBUTE11
,      HRL_GLOBAL_ATTRIBUTE12
,      HRL_GLOBAL_ATTRIBUTE13
,      HRL_GLOBAL_ATTRIBUTE14
,      HRL_GLOBAL_ATTRIBUTE15
,      HRL_GLOBAL_ATTRIBUTE16
,      HRL_GLOBAL_ATTRIBUTE17
,      HRL_GLOBAL_ATTRIBUTE18
,      HRL_GLOBAL_ATTRIBUTE19
,      HRL_GLOBAL_ATTRIBUTE20
,      HRL_GA_CATEGORY
,      LOCATION_NAME
,      LOCATION_ADDRESS1
,      LOCATION_ADDRESS2
,      LOCATION_ADDRESS3
,      LOCATION_COUNTRY
,      LOCATION_ZIPCODE
,      LOCATION_PHONE
,      LOCATION_FAX
,      LEGAL_ENTITY_NAME
,      LEGAL_ENTITY_CITY
,      LEGAL_ENTITY_ADDRESS1
,      LEGAL_ENTITY_ADDRESS2
,      LEGAL_ENTITY_ADDRESS3
,      LEGAL_ENTITY_COUNTRY
,      LEGAL_ENTITY_ZIPCODE
,      LEGAL_ENTITY_PHONE
,      HRL_GLOBAL_ATTRIBUTE1
,      HRL_GLOBAL_ATTRIBUTE2
,      SUPPLIER_ID
,      SUPPLIER_SITE_ID
,      SUPPLIER_NAME
,      SUPPLIER_SITE_NAME
,      PV_ATTRIBUTE1
,      PV_ATTRIBUTE2
,      PV_ATTRIBUTE3
,      PV_ATTRIBUTE4
,      PV_ATTRIBUTE5
,      PV_ATTRIBUTE6
,      PV_ATTRIBUTE7
,      PV_ATTRIBUTE8
,      PV_ATTRIBUTE9
,      PV_ATTRIBUTE10
,      PV_ATTRIBUTE11
,      PV_ATTRIBUTE12
,      PV_ATTRIBUTE13
,      PV_ATTRIBUTE14
,      PV_ATTRIBUTE15
,      PV_ATTRIBUTE_CATEGORY
,      PV_GA_CATEGORY
,      PV_GLOBAL_ATTRIBUTE1
,      PV_GLOBAL_ATTRIBUTE2
,      PV_GLOBAL_ATTRIBUTE3
,      PV_GLOBAL_ATTRIBUTE4
,      PV_GLOBAL_ATTRIBUTE5
,      PV_GLOBAL_ATTRIBUTE6
,      PV_GLOBAL_ATTRIBUTE7
,      PV_GLOBAL_ATTRIBUTE8
,      PV_GLOBAL_ATTRIBUTE9
,      PV_GLOBAL_ATTRIBUTE10
,      PV_GLOBAL_ATTRIBUTE11
,      PV_GLOBAL_ATTRIBUTE12
,      PV_GLOBAL_ATTRIBUTE13
,      PV_GLOBAL_ATTRIBUTE14
,      PV_GLOBAL_ATTRIBUTE15
,      PV_GLOBAL_ATTRIBUTE16
,      PV_GLOBAL_ATTRIBUTE17
,      PV_GLOBAL_ATTRIBUTE18
,      PV_GLOBAL_ATTRIBUTE19
,      PV_GLOBAL_ATTRIBUTE20
,      PVS_ATTRIBUTE1
,      PVS_ATTRIBUTE2
,      PVS_ATTRIBUTE3
,      PVS_ATTRIBUTE4
,      PVS_ATTRIBUTE5
,      PVS_ATTRIBUTE6
,      PVS_ATTRIBUTE7
,      PVS_ATTRIBUTE8
,      PVS_ATTRIBUTE9
,      PVS_ATTRIBUTE10
,      PVS_ATTRIBUTE11
,      PVS_ATTRIBUTE12
,      PVS_ATTRIBUTE13
,      PVS_ATTRIBUTE14
,      PVS_ATTRIBUTE15
,      PVS_GLOBAL_ATTRIBUTE3
,      PVS_GLOBAL_ATTRIBUTE4
,      PVS_GLOBAL_ATTRIBUTE5
,      PVS_GLOBAL_ATTRIBUTE6
,      PVS_GLOBAL_ATTRIBUTE7
,      PVS_GLOBAL_ATTRIBUTE8
,      PVS_GLOBAL_ATTRIBUTE9
,      PVS_GLOBAL_ATTRIBUTE10
,      PVS_GLOBAL_ATTRIBUTE11
,      PVS_GLOBAL_ATTRIBUTE12
,      PVS_GLOBAL_ATTRIBUTE13
,      PVS_GLOBAL_ATTRIBUTE14
,      PVS_GLOBAL_ATTRIBUTE15
,      PVS_GLOBAL_ATTRIBUTE16
,      PVS_GLOBAL_ATTRIBUTE17
,      PVS_GLOBAL_ATTRIBUTE18
,      PVS_GLOBAL_ATTRIBUTE19
,      PVS_GLOBAL_ATTRIBUTE20
,      PVS_ATTRIBUTE_CATEGORY
,      PVS_GA_CATEGORY
,      INV_ATTRIBUTE1
,      INV_ATTRIBUTE2
,      INV_ATTRIBUTE3
,      INV_ATTRIBUTE4
,      INV_ATTRIBUTE5
,      INV_ATTRIBUTE6
,      INV_ATTRIBUTE7
,      INV_ATTRIBUTE8
,      INV_ATTRIBUTE9
,      INV_ATTRIBUTE10
,      INV_ATTRIBUTE11
,      INV_ATTRIBUTE12
,      INV_ATTRIBUTE13
,      INV_ATTRIBUTE14
,      INV_ATTRIBUTE15
,      INV_GLOBAL_ATTRIBUTE1
,      INV_GLOBAL_ATTRIBUTE2
,      INV_GLOBAL_ATTRIBUTE3
,      INV_GLOBAL_ATTRIBUTE4
,      INV_GLOBAL_ATTRIBUTE5
,      INV_GLOBAL_ATTRIBUTE6
,      INV_GLOBAL_ATTRIBUTE7
,      INV_GLOBAL_ATTRIBUTE8
,      INV_GLOBAL_ATTRIBUTE9
,      INV_GLOBAL_ATTRIBUTE10
,      INV_GLOBAL_ATTRIBUTE11
,      INV_GLOBAL_ATTRIBUTE12
,      INV_GLOBAL_ATTRIBUTE13
,      INV_GLOBAL_ATTRIBUTE14
,      INV_GLOBAL_ATTRIBUTE15
,      INV_GLOBAL_ATTRIBUTE16
,      INV_GLOBAL_ATTRIBUTE17
,      INV_GLOBAL_ATTRIBUTE18
,      INV_GLOBAL_ATTRIBUTE19
,      INV_GLOBAL_ATTRIBUTE20
,      INV_ATTRIBUTE_CATEGORY
,      INV_GA_CATEGORY
,      IND_GLOBAL_ATTRIBUTE1
,      IND_GLOBAL_ATTRIBUTE2
,      IND_GLOBAL_ATTRIBUTE3
,      IND_GLOBAL_ATTRIBUTE4
,      IND_GLOBAL_ATTRIBUTE5
,      IND_GLOBAL_ATTRIBUTE6
,      IND_GLOBAL_ATTRIBUTE7
,      IND_GLOBAL_ATTRIBUTE8
,      IND_GLOBAL_ATTRIBUTE9
,      IND_GLOBAL_ATTRIBUTE10
,      IND_GLOBAL_ATTRIBUTE11
,      IND_GLOBAL_ATTRIBUTE12
,      IND_GLOBAL_ATTRIBUTE13
,      IND_GLOBAL_ATTRIBUTE14
,      IND_GLOBAL_ATTRIBUTE15
,      IND_GLOBAL_ATTRIBUTE16
,      IND_GLOBAL_ATTRIBUTE17
,      IND_GLOBAL_ATTRIBUTE18
,      IND_GLOBAL_ATTRIBUTE19
,      IND_GLOBAL_ATTRIBUTE20
,      IND_GA_CATEGORY
,      SUPPLIER_COUNTRY
,      SUPPLIER_ADDRESS_LINE1
,      SUPPLIER_ADDRESS_LINE2
,      SUPPLIER_ADDRESS_LINE3
,      SUPPLIER_CITY
,      SUPPLIER_POSTAL_CODE
,      SUPPLIER_PROVINCE
,      SUPPLIER_COUNTY
,      SUPP_CONCATENATED_ADDRESS
,      PVS_GLOBAL_ATTRIBUTE1
,      SUPPLIER_TAX_REGISTRATION_NUM
,      SUPPLIER_TAXPAYER_ID
,      PVS_GLOBAL_ATTRIBUTE2
,      BIZ_INC_SUB_CATEG_MEANING
,      DIST_CODE_COMBINATION_ID
,      ACCOUNTING_FLEXFIELD
,      TRANSACTION_NUMBER
,      ACCOUNTING_DATE
,      DOCUMENT_NUMBER
,      ORGANIZATION_TYPE
,      ORG_TYPE_MEANING
,      TAX_ID
,      TAX_CODE
,      AWT_DESCRIPTION
,      TAX_TYPE
,      TAX_RATE_ID
,      TAX_RATE
,      ATC_GLOBAL_ATTRIBUTE6
,      ATC_GLOBAL_ATTRIBUTE7
,      ATC_GLOBAL_ATTRIBUTE1
,      ATC_GLOBAL_ATTRIBUTE2
,      ATC_GLOBAL_ATTRIBUTE3
,      ATC_GLOBAL_ATTRIBUTE8
,      ATC_GLOBAL_ATTRIBUTE9
,      ATC_GLOBAL_ATTRIBUTE10
,      ATC_GLOBAL_ATTRIBUTE11
,      ATC_GLOBAL_ATTRIBUTE12
,      ATC_GLOBAL_ATTRIBUTE13
,      ATC_GLOBAL_ATTRIBUTE14
,      ATC_GLOBAL_ATTRIBUTE15
,      ATC_GLOBAL_ATTRIBUTE16
,      ATC_GLOBAL_ATTRIBUTE17
,      ATC_GLOBAL_ATTRIBUTE18
,      ATC_GLOBAL_ATTRIBUTE19
,      ATC_GLOBAL_ATTRIBUTE20
,      ATC_GA_CATEGORY
,      WH_TAX_TYPE_MEANING
,      ATC_GLOBAL_ATTRIBUTE4
,      RES_INC_CATEG_MEANING
,      ATC_GLOBAL_ATTRIBUTE5
,      FOR_INC_CATEG_MEANING
,      TAX_AUTHORITY_NAME
,      STATUS
,      INCOME_TAX
,      RESIDENT_TAX
,      TOTAL_WHT_AMOUNT
,      PAYMENT_CURRENCY
,      INVOICE_PAYMENT_ID
,      PAYMENT_AMOUNT
,      PAYMENT_DATE
,      PAYMENT_NUMBER
,      CHECK_ID
,      CHECK_NUMBER
,      CHECK_AMOUNT
,      INVOICE_ID
,      INVOICE_DISTRIBUTION_ID
,      INVOICE_AMOUNT
,      INVOICE_DATE
,      CURRENCY_CODE
,      FUNC_CURRENCY_CODE
,      AMT_SUBJECT_TO_WH
,      RECOGNIZED_EXPENSE_AMT
,      INC_WH_TAX_BASE_AMT
,      RES_WH_TAX_BASE_AMT
,      TOTAL_TAX_BASE_AMT
,      NET_AMOUNT
,      LINE_NUMBER
,      TYPE_1099
,      ITEM_DESCRIPTION
,      ORGANIZATION_NAME
,      REPORTING_ENTITY_NAME
,      REPORTING_SOB_NAME
,      SOB_ID
,      REQUEST_ID
,      NOMINAL_OR_REG_TAX_RATE
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      CREATION_DATE
,      CREATED_BY
,      INVOICE_LINE_NUM
FROM JG.JG_ZZ_AP_WHT_ITF#;

Dependencies

[top of page]

JG.JG_ZZ_AP_WHT_ITF# references the following:

SchemaJG
TableJG_ZZ_AP_WHT_ITF
JG.JG_ZZ_AP_WHT_ITF# is referenced by following:

SchemaAPPS
SynonymJG_ZZ_AP_WHT_ITF