Oracle eBusiness Suite Technical Reference

Release 11i - Copyright (c) 2001 - 2005 Oracle

This Technical Reference Manual (TRM) in any form, software or printed matter, contains proprietary information of Oracle ; it is provided under an Oracle agreement containing restrictions on use and disclosure and is also protected by copyright, patent, and other intellectual property law. Restrictions applicable to this TRM include, but are not limited to: (a) exercising either the same degree of care to safeguard the confidentiality of this TRM as you exercise to safeguard the confidentiality of your own most important Confidential Information or a reasonable degree of care, whichever is greater; (b) maintaining agreements with your employees and agents that protect the Confidential Information of third parties such as Oracle and instructing such employees and agents of these requirements for this TRM; (c) restricting disclosure of this TRM to those of your employees who have a 'need to know' consistent with the purposes for which this TRM was disclosed to you; (d) maintaining this TRM at all times on your premises; (e) not removing or destroying any proprietary or confidential legends or markings placed upon this TRM in whatever form, software or printed matter; and (f) not reproducing or transmitting this TRM in any form or by any means, electronic or mechanical, for any purpose, without the express written permission of Oracle. You should not use this TRM in any form, software or printed matter, to create software that performs the same or similar functions as any Oracle products.

The information in this TRM is subject to change without notice. If you find any problems in the TRM in any form, software or printed matter, please report them to us in writing. Oracle does not warrant that this TRM is error free. This TRM is provided to customer 'as is' with no warranty of any kind. This TRM does not constitute Documentation as that term is defined in Oracle's agreements. Reverse engineering of the Programs (software and documentation) associated with this TRM are prohibited. The Programs associated with this TRM are not intended for use in any nuclear, aviation, mass transit, medical, or other inherently dangerous applications. It shall be licensee's responsibility to take all appropriate fail safe, backup, redundancy and other measures to ensure the safe use of such applications if the Programs are used for such purposes, and Oracle disclaims liability for any damages caused by such use of the Programs. Program Documentation is licensed for use solely to support the deployment of the Programs and not for any other any other purpose. Restricted Rights Legend

This TRM and the Programs associated with this TRM delivered subject to the DOD FAR Supplement are 'commercial computer software' and use, duplication and disclosure of the TRM and the Programs associated with this TRM shall be subject to the licensing restrictions set forth in the applicable Oracle license agreement. Otherwise, this TRM and the Programs associated with this TRM delivered subject to the Federal Acquisition Regulations are 'restricted computer software' and use, duplication and disclosure of the TRM and the Programs associated with this TRM shall be subject to the restrictions in FAR 52.227-14, Rights in Data General, including Alternate III (June 1987). Oracle, 500 Oracle Parkway, Redwood City, CA 94065.

Oracle is a registered trademark. AIM Advantage™, Big Business. Small Business. All Business.™, CDM Advantage™, .comference™, ConText®, Des40®, Easy*Query™, Easy*SQL®, Education Objects™, EMM Advantage™, Enabling the Information Age®, ExpertDetectSM, Express®, FastForwardSM, GEMMS®, Gist™, Hyper*SQL™, instantOracle™, "Internet Business Intelligence - Insight for Everyone"™, iSQL*Plus™, JInitiator™, NLS*Workbench®, Object Marketplace™, ODP Pulse™, ODP Techwire™, OLA™, On Oracle™, Oracle®, Oracle Book®, Oracle Bookbatch®, Oracle BookBuilder®, OracleBRONZE®, Oracle Business OnLine®, OracleDevConnectSM, Oracle® Discoverer™, Oracle® Expert™, Oracle Financials®, OracleGOLDSM, OracleIncidentSM, OracleJSP™, OracleLifeCycleSM, Oracle Media Objects®, OracleMERCURYSM, OracleMetaLinkSM, OraclemetalsSM, OracleMobile™, Oracle Names®, Oracle NetSolutions®, Oracle® One™, Oracle Open Gateways®, Oracle OpenWorld®, OraclePLATINUMSM, Oracle Power Objects®, Oracle Press®, Oracle Procedural Gateway®, Oracle Quality®, Oracle Secure Network Services®, OracleSILVERSM, Oracle® SQL/Services™, Oracle® SQL*TutorSM, OracleSTERLINGSM, Oracle Store®, Oracle Transparent Gateway®, OracleWare®, Oracle8i™, Oracle9i™, PC Express®, Personal Express®, PJM Advantage™, PL/SQL™, Pro*Ada®, Pro*C™, Pro*C/C++™, Pro*COBOL®, Pro*FORTRAN®, Pro*Pascal®, Pro*PL/1®, Pro*REXX®, Profit™, ProREXX™, Report Card™, Secure Access 2.0™, Secure Network Services®, Security Without Compromise™, SellingPoint®, SQL*Plus®, Tutor™ are trademarks or registered trademarks of Oracle. Other names may be trademarks of their respective owners. The absence of a product or service name, slogan, or logo from this list does not constitute a waiver of Oracle's trademark or other intellectual property rights concerning that name, slogan, or logo.

eTRM - JG Tables and Views

TABLE - JG.JE_PARENT_CHILD_GT
TABLE - JG.JE_PROFIT_LOSS_RPT_GT
TABLE - AP.JG_ZZ_AP_BALANCES
TABLE - AP.JG_ZZ_AP_IR_REP_ITF
TABLE - AP.JG_ZZ_AP_TMP_ACCOUNT
TABLE - AP.JG_ZZ_AP_TMP_BAL
TABLE - AP.JG_ZZ_AP_TMP_DETAIL
TABLE - JG.JG_ZZ_AP_WHT_ITF
TABLE - AR.JG_ZZ_AR_BALANCES
TABLE - JG.JG_ZZ_AR_SRC_TRX_TY_ALL
TABLE - AR.JG_ZZ_AR_TMP_ACCOUNT
TABLE - AR.JG_ZZ_AR_TMP_BAL
TABLE - AR.JG_ZZ_AR_TMP_DETAIL
TABLE - JG.JG_ZZ_ENTITY_ASSOC
TABLE - JG.JG_ZZ_FA_REG_ITF
TABLE - JG.JG_ZZ_GL_RECON_TRX
TABLE - JG.JG_ZZ_GL_UNREC_TRX
TABLE - AR.JG_ZZ_II_INT_RATES_ALL
TABLE - AR.JG_ZZ_INTEREST_BATCHES_ALL
TABLE - AR.JG_ZZ_INTEREST_INVOICES_ALL
TABLE - AR.JG_ZZ_INT_INV_LINES_ALL
TABLE - AP.JG_ZZ_INVOICE_INFO
TABLE - AR.JG_ZZ_JGZZCSLP_MESSAGES
TABLE - AP.JG_ZZ_JGZZVSLP_MESSAGES
TABLE - AP.JG_ZZ_PAY_FORMAT_INFO
TABLE - AP.JG_ZZ_PAY_SCHED_INFO
TABLE - AP.JG_ZZ_SYS_FORMATS_ALL_B
TABLE - AP.JG_ZZ_SYS_FORMATS_ALL_TL
TABLE - GL.JG_ZZ_TA_ACCOUNT_RANGES
TABLE - GL.JG_ZZ_TA_ALLOCATED_LINES
TABLE - GL.JG_ZZ_TA_CC_RANGES
TABLE - GL.JG_ZZ_TA_RULE_LINES
TABLE - GL.JG_ZZ_TA_RULE_SETS
TABLE - JG.JG_ZZ_TMP_RPT_HEADERS
TABLE - JG.JG_ZZ_VAT_ALLOC_RULES
TABLE - JG.JG_ZZ_VAT_BOX_ALLOCS
TABLE - JG.JG_ZZ_VAT_BOX_ERRORS
TABLE - JG.JG_ZZ_VAT_DOC_SEQUENCES
TABLE - JG.JG_ZZ_VAT_FINAL_REPORTS
TABLE - JG.JG_ZZ_VAT_REGISTERS_B
TABLE - JG.JG_ZZ_VAT_REGISTERS_TL
TABLE - JG.JG_ZZ_VAT_REP_ENTITIES
TABLE - JG.JG_ZZ_VAT_REP_STATUS
TABLE - JG.JG_ZZ_VAT_TRX_DETAILS
TABLE - JG.JG_ZZ_VAT_TRX_GT
TABLE - JG.JG_ZZ_VAT_TRX_UPG_STG
TABLE - JG.JG_ZZ_VAT_UPG_STG
TABLE - AP.JG_ZZ_VEND_SITE_INFO
VIEW - APPS.JG_AP_TAX_LINES_SUMMARY_V
VIEW - APPS.JG_PO_REL_TAX_LINES_SUMMARY_V
VIEW - APPS.JG_PO_REQ_TAX_LINES_SUMMARY_V
VIEW - APPS.JG_PO_TAX_LINES_SUMMARY_V
VIEW - APPS.JG_ZZ_AP_BALANCES_V
VIEW - APPS.JG_ZZ_AP_CONTRA_V
VIEW - APPS.JG_ZZ_AP_IR_REP_ITF_V
VIEW - APPS.JG_ZZ_AR_BALANCES_V
VIEW - APPS.JG_ZZ_ENTERED_CURRENCIES_V
VIEW - APPS.JG_ZZ_ENTITY_ASSOC_V
VIEW - APPS.JG_ZZ_II_INT_RATES
VIEW - APPS.JG_ZZ_SRS_LEDGER_BUD_ENCUM_V
VIEW - APPS.JG_ZZ_SRS_LEDGER_PER_START_V
VIEW - APPS.JG_ZZ_TA_ACCOUNT_RANGES_V
VIEW - APPS.JG_ZZ_TA_CC_RANGES_V
VIEW - APPS.JG_ZZ_TA_JE_LINES_V
VIEW - APPS.JG_ZZ_TA_RULE_LINES_V
VIEW - APPS.JG_ZZ_TA_RULE_SETS_V
VIEW - APPS.JG_ZZ_VAT_ALLOC_RULES_V
VIEW - APPS.JG_ZZ_VAT_DOC_SEQUENCES_V
VIEW - APPS.JG_ZZ_VAT_REGISTERS_VL
VIEW - APPS.JG_ZZ_VAT_REP_ENTITIES_V

Table: JE_PARENT_CHILD_GT

Description:
Comments
Columns
Name Datatype Length Mandatory Comments
PARENT_VALUE VARCHAR2 (60)
CHILD_VALUE VARCHAR2 (60)
AMOUNT NUMBER

PRIOR_AMOUNT NUMBER

[top of page]

JG.JE_PARENT_CHILD_GT does not reference any database object

JG.JE_PARENT_CHILD_GT is referenced by following:

APPS
SYNONYM - JE_PARENT_CHILD_GT

[top of page]

Table: JE_PROFIT_LOSS_RPT_GT

Description:
Comments
Columns
Name Datatype Length Mandatory Comments
PARENT_VALUE VARCHAR2 (60)
AMOUNT NUMBER

PRIOR_AMOUNT NUMBER

[top of page]

JG.JE_PROFIT_LOSS_RPT_GT does not reference any database object

JG.JE_PROFIT_LOSS_RPT_GT is referenced by following:

APPS
SYNONYM - JE_PROFIT_LOSS_RPT_GT

[top of page]

Table: JG_ZZ_AP_BALANCES

Description: Sub-ledger balances for Payables
Primary Key: JG_ZZ_AP_BALANCES_PK
  1. SET_OF_BOOKS_ID
  2. CODE_COMBINATION_ID
  3. CURRENCY_CODE
  4. PERIOD_NAME
  5. VENDOR_ID
  6. VENDOR_SITE_ID
Comments
Indexes
Index Type Tablespace Column
JG_ZZ_AP_BALANCES_U1 UNIQUE APPS_TS_TX_IDX SET_OF_BOOKS_ID
CODE_COMBINATION_ID
CURRENCY_CODE
PERIOD_NAME
VENDOR_ID
VENDOR_SITE_ID
Columns
Name Datatype Length Mandatory Comments
SET_OF_BOOKS_ID NUMBER (15) Y
CODE_COMBINATION_ID NUMBER (15) Y
CURRENCY_CODE VARCHAR2 (15) Y
PERIOD_NAME VARCHAR2 (15) Y
VENDOR_ID NUMBER (15) Y
VENDOR_SITE_ID NUMBER (15)
BEGIN_BAL_ENTERED_DR NUMBER

BEGIN_BAL_ENTERED_CR NUMBER

BEGIN_BAL_ACCOUNTED_DR NUMBER

BEGIN_BAL_ACCOUNTED_CR NUMBER

PERIOD_NET_ENTERED_DR NUMBER

PERIOD_NET_ENTERED_CR NUMBER

PERIOD_NET_ACCOUNTED_DR NUMBER

PERIOD_NET_ACCOUNTED_CR NUMBER

LAST_UPDATE_DATE DATE
Y
LAST_UPDATED_BY NUMBER (15) Y
CREATION_DATE DATE
Y
CREATED_BY NUMBER (15) Y
POSTED_TO_GL_FLAG VARCHAR2 (1)

[top of page]

AP.JG_ZZ_AP_BALANCES does not reference any database object

AP.JG_ZZ_AP_BALANCES is referenced by following:

APPS
SYNONYM - JG_ZZ_AP_BALANCES

[top of page]

Table: JG_ZZ_AP_IR_REP_ITF

Description: Interim table for 'RXi/RX-only: Payables Invoice Register by Detail' Report
Comments
Indexes
Index Type Tablespace Column
JG_ZZ_AP_IR_REP_ITF_N1 NONUNIQUE APPS_TS_TX_IDX REQUEST_ID
Columns
Name Datatype Length Mandatory Comments
REQUEST_ID NUMBER (15) Y
CREATED_BY NUMBER (15) Y
CREATION_DATE DATE
Y
LAST_UPDATE_DATE DATE
Y
LAST_UPDATED_BY NUMBER (15)
LAST_UPDATE_LOGIN NUMBER (15)
FUNCTIONAL_CURRENCY_CODE VARCHAR2 (15)
ORGANIZATION_NAME VARCHAR2 (80)
INVOICE_ID NUMBER
Y
LIABILITY_CCID NUMBER

LIABILITY_ACCOUNT VARCHAR2 (240)
LIABILITY_DESC VARCHAR2 (240)
LIABILITY_NATACC VARCHAR2 (240)
LIABILITY_NATACC_DESC VARCHAR2 (240)
INVOICE_TYPE VARCHAR2 (25)
INVOICE_DISTRIBUTION_ID NUMBER

LINE_NUMBER NUMBER

LINE_TYPE VARCHAR2 (25)
DISTRIBUTION_CCID NUMBER

DISTRIBUTION_ACCOUNT VARCHAR2 (240)
DISTRIBUTION_ACCOUNT_DESC VARCHAR2 (240)
DISTRIBUTION_NATACC VARCHAR2 (240)
DISTRIBUTION_NATACC_DESC VARCHAR2 (240)
DIST_NUMBER NUMBER (15)
DIST_TYPE VARCHAR2 (25)
ACCOUNTING_DATE DATE

[top of page]

AP.JG_ZZ_AP_IR_REP_ITF does not reference any database object

AP.JG_ZZ_AP_IR_REP_ITF is referenced by following:

APPS
SYNONYM - JG_ZZ_AP_IR_REP_ITF

[top of page]

Table: JG_ZZ_AP_TMP_ACCOUNT

Description: Contains information of each contra account
Comments
Indexes
Index Type Tablespace Column
JG_ZZ_AP_TMP_ACCOUNT_N1 NONUNIQUE APPS_TS_TX_IDX ACCOUNTING_EVENT_ID
JG_ZZ_AP_TMP_ACCOUNT_N2 NONUNIQUE APPS_TS_TX_IDX AE_LINE_ID
Columns
Name Datatype Length Mandatory Comments
REQUEST_ID NUMBER (15)
AE_LINE_ID NUMBER (15)
ACCOUNTING_EVENT_ID NUMBER (15)
LINE_NUMBER NUMBER (15)
LINE_TYPE_FIELD VARCHAR2 (25)
TAX_CODE_ID NUMBER (15)
SET_OF_BOOKS_ID NUMBER (15)
CODE_COMBINATION_ID NUMBER (15)
ACCT_FLEX_FIELD VARCHAR2 (240)
ACCT_FLEX_DESC VARCHAR2 (240)
BALANCE VARCHAR2 (25)
BALANCE_DESC VARCHAR2 (240)
ACCOUNT VARCHAR2 (25)
ACCOUNT_DESC VARCHAR2 (240)
CREATED_BY NUMBER (15)
CREATION_DATE DATE

LAST_UPDATED_BY NUMBER (15)
LAST_UPDATE_DATE DATE

LAST_UPDATE_LOGIN NUMBER (15)

[top of page]

AP.JG_ZZ_AP_TMP_ACCOUNT does not reference any database object

AP.JG_ZZ_AP_TMP_ACCOUNT is referenced by following:

APPS
SYNONYM - JG_ZZ_AP_TMP_ACCOUNT

[top of page]

Table: JG_ZZ_AP_TMP_BAL

Description: Temporary sub-ledger balances for Payables
Primary Key: JG_ZZ_AP_TMP_BAL_PK
  1. SET_OF_BOOKS_ID
  2. CODE_COMBINATION_ID
  3. CURRENCY_CODE
  4. PERIOD_NAME
  5. VENDOR_ID
  6. VENDOR_SITE_ID
Comments
Columns
Name Datatype Length Mandatory Comments
SET_OF_BOOKS_ID NUMBER (15) Y
CODE_COMBINATION_ID NUMBER (15) Y
CURRENCY_CODE VARCHAR2 (15) Y
PERIOD_NAME VARCHAR2 (15) Y
VENDOR_ID NUMBER (15) Y
VENDOR_SITE_ID NUMBER (15) Y
BEGIN_BAL_ENTERED_DR NUMBER

BEGIN_BAL_ENTERED_CR NUMBER

BEGIN_BAL_ACCOUNTED_DR NUMBER

BEGIN_BAL_ACCOUNTED_CR NUMBER

PERIOD_NET_ENTERED_DR NUMBER

PERIOD_NET_ENTERED_CR NUMBER

PERIOD_NET_ACCOUNTED_DR NUMBER

PERIOD_NET_ACCOUNTED_CR NUMBER

LAST_UPDATE_DATE DATE
Y
LAST_UPDATED_BY NUMBER (15) Y
CREATION_DATE DATE
Y
CREATED_BY NUMBER (15) Y
POSTED_TO_GL_FLAG VARCHAR2 (1)

[top of page]

AP.JG_ZZ_AP_TMP_BAL does not reference any database object

AP.JG_ZZ_AP_TMP_BAL is referenced by following:

APPS
SYNONYM - JG_ZZ_AP_TMP_BAL

[top of page]

Table: JG_ZZ_AP_TMP_DETAIL

Description: Used for calculating sub-ledger balances and holding detailed reporting data for Payables
Comments
Indexes
Index Type Tablespace Column
JG_ZZ_AP_TMP_DETAIL_N1 NONUNIQUE APPS_TS_TX_IDX SET_OF_BOOKS_ID
ACCOUNTING_DATE
VENDOR_ID
JG_ZZ_AP_TMP_DETAIL_N2 NONUNIQUE APPS_TS_TX_IDX CODE_COMBINATION_ID
Columns
Name Datatype Length Mandatory Comments
SET_OF_BOOKS_ID NUMBER (15) Y
ACCOUNTING_DATE DATE
Y
SUBLEDGER_DOC_SEQUENCE_ID NUMBER (15)
SUBLEDGER_DOC_SEQUENCE_VALUE NUMBER

CURRENCY_CODE VARCHAR2 (15) Y
CODE_COMBINATION_ID NUMBER (15)
ENTERED_DR NUMBER

ENTERED_CR NUMBER

ACCOUNTED_DR NUMBER

ACCOUNTED_CR NUMBER

TRANS_TYPE VARCHAR2 (25)
TRANS_NUMBER VARCHAR2 (50)
TRANS_DESCRIPTION VARCHAR2 (240)
VENDOR_ID NUMBER (15)
VENDOR_SITE_ID NUMBER (15)
POSTED_TO_GL_FLAG VARCHAR2 (1)
CREATED_BY NUMBER (15) Y
DATE_CREATED DATE
Y
ACCOUNTING_EVENT_ID NUMBER (15)
ACCT_FLEX_FIELD VARCHAR2 (240)
ACCT_FLEX_DESC VARCHAR2 (240)
BALANCE VARCHAR2 (25)
BALANCE_DESC VARCHAR2 (240)
ACCOUNT VARCHAR2 (25)
ACCOUNT_DESC VARCHAR2 (240)

[top of page]

AP.JG_ZZ_AP_TMP_DETAIL does not reference any database object

AP.JG_ZZ_AP_TMP_DETAIL is referenced by following:

APPS
SYNONYM - JG_ZZ_AP_TMP_DETAIL

[top of page]

Table: JG_ZZ_AP_WHT_ITF

Description: Korean Withholding Tax Extract Table
Comments

This interface table would store the results of each submission of data
extract report for Korean Withholding Tax Listing report. It is a denormalized
table, used for storing the Operating Unit, Supplier information and Net Tax
data. This table will consist of a separate row per withholding invoice
distribution, which matches the user parameters.

Columns
Name Datatype Length Mandatory Comments
HRL_GLOBAL_ATTRIBUTE3 VARCHAR2 (150)
HR_LOCATIONS_ALL Global Attribute3
HRL_GLOBAL_ATTRIBUTE4 VARCHAR2 (150)
HR_LOCATIONS_ALL Global Attribute4
HRL_GLOBAL_ATTRIBUTE5 VARCHAR2 (150)
HR_LOCATIONS_ALL Global Attribute5
HRL_GLOBAL_ATTRIBUTE6 VARCHAR2 (150)
HR_LOCATIONS_ALL Global Attribute6
HRL_GLOBAL_ATTRIBUTE7 VARCHAR2 (150)
HR_LOCATIONS_ALL Global Attribute7
HRL_GLOBAL_ATTRIBUTE8 VARCHAR2 (150)
HR_LOCATIONS_ALL Global Attribute8
HRL_GLOBAL_ATTRIBUTE9 VARCHAR2 (150)
HR_LOCATIONS_ALL Global Attribute9
HRL_GLOBAL_ATTRIBUTE10 VARCHAR2 (150)
HR_LOCATIONS_ALL Global Attribute10
HRL_GLOBAL_ATTRIBUTE11 VARCHAR2 (150)
HR_LOCATIONS_ALL Global Attribute11
HRL_GLOBAL_ATTRIBUTE12 VARCHAR2 (150)
HR_LOCATIONS_ALL Global Attribute12
HRL_GLOBAL_ATTRIBUTE13 VARCHAR2 (150)
HR_LOCATIONS_ALL Global Attribute13
HRL_GLOBAL_ATTRIBUTE14 VARCHAR2 (150)
HR_LOCATIONS_ALL Global Attribute14
HRL_GLOBAL_ATTRIBUTE15 VARCHAR2 (150)
HR_LOCATIONS_ALL Global Attribute15
HRL_GLOBAL_ATTRIBUTE16 VARCHAR2 (150)
HR_LOCATIONS_ALL Global Attribute16
HRL_GLOBAL_ATTRIBUTE17 VARCHAR2 (150)
HR_LOCATIONS_ALL Global Attribute17
HRL_GLOBAL_ATTRIBUTE18 VARCHAR2 (150)
HR_LOCATIONS_ALL Global Attribute18
HRL_GLOBAL_ATTRIBUTE19 VARCHAR2 (150)
HR_LOCATIONS_ALL Global Attribute19
HRL_GLOBAL_ATTRIBUTE20 VARCHAR2 (150)
HR_LOCATIONS_ALL Global Attribute20
HRL_GA_CATEGORY VARCHAR2 (150)
HR_LOCATIONS_ALL Global Attribute Category
LOCATION_NAME VARCHAR2 (60)
Name of the Company site
LOCATION_ADDRESS1 VARCHAR2 (240)
Location Address1
LOCATION_ADDRESS2 VARCHAR2 (240)
Location Address2
LOCATION_ADDRESS3 VARCHAR2 (240)
Location Address3
LOCATION_COUNTRY VARCHAR2 (60)
Country
LOCATION_ZIPCODE VARCHAR2 (30)
Postal Code
LOCATION_PHONE VARCHAR2 (30)
Telephone Number
LOCATION_FAX VARCHAR2 (60)
Fax Number
LEGAL_ENTITY_NAME VARCHAR2 (60)
Name of the legal entity
LEGAL_ENTITY_CITY VARCHAR2 (30)
Legal Entity City
LEGAL_ENTITY_ADDRESS1 VARCHAR2 (240)
Legal Entity Address1
LEGAL_ENTITY_ADDRESS2 VARCHAR2 (240)
Legal Entity Address2
LEGAL_ENTITY_ADDRESS3 VARCHAR2 (240)
Legal Entity Address3
LEGAL_ENTITY_COUNTRY VARCHAR2 (60)
Legal Entity Country
LEGAL_ENTITY_ZIPCODE VARCHAR2 (30)
Legal Entity Postal Code
LEGAL_ENTITY_PHONE VARCHAR2 (30)
Legal Entity Phone
HRL_GLOBAL_ATTRIBUTE1 VARCHAR2 (150)
HR_LOCATIONS_ALL Global Attribute1
HRL_GLOBAL_ATTRIBUTE2 VARCHAR2 (150)
HR_LOCATIONS_ALL Global Attribute2
SUPPLIER_ID NUMBER
Y Vendor Id
SUPPLIER_SITE_ID NUMBER
Y Vendor Site Id
SUPPLIER_NAME VARCHAR2 (240) Y Name of the Supplier
SUPPLIER_SITE_NAME VARCHAR2 (15) Y Supplier Site Name
PV_ATTRIBUTE1 VARCHAR2 (150)
PO_VENDORS Attribute1
PV_ATTRIBUTE2 VARCHAR2 (150)
PO_VENDORS Attribute2
PV_ATTRIBUTE3 VARCHAR2 (150)
PO_VENDORS Attribute3
PV_ATTRIBUTE4 VARCHAR2 (150)
PO_VENDORS Attribute4
PV_ATTRIBUTE5 VARCHAR2 (150)
PO_VENDORS Attribute5
PV_ATTRIBUTE6 VARCHAR2 (150)
PO_VENDORS Attribute6
PV_ATTRIBUTE7 VARCHAR2 (150)
PO_VENDORS Attribute7
PV_ATTRIBUTE8 VARCHAR2 (150)
PO_VENDORS Attribute8
PV_ATTRIBUTE9 VARCHAR2 (150)
PO_VENDORS Attribute9
PV_ATTRIBUTE10 VARCHAR2 (150)
PO_VENDORS Attribute10
PV_ATTRIBUTE11 VARCHAR2 (150)
PO_VENDORS Attribute11
PV_ATTRIBUTE12 VARCHAR2 (150)
PO_VENDORS Attribute12
PV_ATTRIBUTE13 VARCHAR2 (150)
PO_VENDORS Attribute13
PV_ATTRIBUTE14 VARCHAR2 (150)
PO_VENDORS Attribute14
PV_ATTRIBUTE15 VARCHAR2 (150)
PO_VENDORS Attribute15
PV_ATTRIBUTE_CATEGORY VARCHAR2 (150)
PO_VENDORS Attribute Category
PV_GA_CATEGORY VARCHAR2 (150)
PO_VENDORS Global Attribute Category
PV_GLOBAL_ATTRIBUTE1 VARCHAR2 (150)
PO_VENDORS Global Attribute1
PV_GLOBAL_ATTRIBUTE2 VARCHAR2 (150)
PO_VENDORS Global Attribute2
PV_GLOBAL_ATTRIBUTE3 VARCHAR2 (150)
PO_VENDORS Global Attribute3
PV_GLOBAL_ATTRIBUTE4 VARCHAR2 (150)
PO_VENDORS Global Attribute4
PV_GLOBAL_ATTRIBUTE5 VARCHAR2 (150)
PO_VENDORS Global Attribute5
PV_GLOBAL_ATTRIBUTE6 VARCHAR2 (150)
PO_VENDORS Global Attribute6
PV_GLOBAL_ATTRIBUTE7 VARCHAR2 (150)
PO_VENDORS Global Attribute7
PV_GLOBAL_ATTRIBUTE8 VARCHAR2 (150)
PO_VENDORS Global Attribute8
PV_GLOBAL_ATTRIBUTE9 VARCHAR2 (150)
PO_VENDORS Global Attribute9
PV_GLOBAL_ATTRIBUTE10 VARCHAR2 (150)
PO_VENDORS Global Attribute10
PV_GLOBAL_ATTRIBUTE11 VARCHAR2 (150)
PO_VENDORS Global Attribute11
PV_GLOBAL_ATTRIBUTE12 VARCHAR2 (150)
PO_VENDORS Global Attribute12
PV_GLOBAL_ATTRIBUTE13 VARCHAR2 (150)
PO_VENDORS Global Attribute13
PV_GLOBAL_ATTRIBUTE14 VARCHAR2 (150)
PO_VENDORS Global Attribute14
PV_GLOBAL_ATTRIBUTE15 VARCHAR2 (150)
PO_VENDORS Global Attribute15
PV_GLOBAL_ATTRIBUTE16 VARCHAR2 (150)
PO_VENDORS Global Attribute16
PV_GLOBAL_ATTRIBUTE17 VARCHAR2 (150)
PO_VENDORS Global Attribute17
PV_GLOBAL_ATTRIBUTE18 VARCHAR2 (150)
PO_VENDORS Global Attribute18
PV_GLOBAL_ATTRIBUTE19 VARCHAR2 (150)
PO_VENDORS Global Attribute19
PV_GLOBAL_ATTRIBUTE20 VARCHAR2 (150)
PO_VENDORS Global Attribute20
PVS_ATTRIBUTE1 VARCHAR2 (150)
PO_VENDOR_SITES_ALL Attribute1
PVS_ATTRIBUTE2 VARCHAR2 (150)
PO_VENDOR_SITES_ALL Attribute2
PVS_ATTRIBUTE3 VARCHAR2 (150)
PO_VENDOR_SITES_ALL Attribute3
PVS_ATTRIBUTE4 VARCHAR2 (150)
PO_VENDOR_SITES_ALL Attribute4
PVS_ATTRIBUTE5 VARCHAR2 (150)
PO_VENDOR_SITES_ALL Attribute5
PVS_ATTRIBUTE6 VARCHAR2 (150)
PO_VENDOR_SITES_ALL Attribute6
PVS_ATTRIBUTE7 VARCHAR2 (150)
PO_VENDOR_SITES_ALL Attribute7
PVS_ATTRIBUTE8 VARCHAR2 (150)
PO_VENDOR_SITES_ALL Attribute8
PVS_ATTRIBUTE9 VARCHAR2 (150)
PO_VENDOR_SITES_ALL Attribute9
PVS_ATTRIBUTE10 VARCHAR2 (150)
PO_VENDOR_SITES_ALL Attribute10
PVS_ATTRIBUTE11 VARCHAR2 (150)
PO_VENDOR_SITES_ALL Attribute11
PVS_ATTRIBUTE12 VARCHAR2 (150)
PO_VENDOR_SITES_ALL Attribute12
PVS_ATTRIBUTE13 VARCHAR2 (150)
PO_VENDOR_SITES_ALL Attribute13
PVS_ATTRIBUTE14 VARCHAR2 (150)
PO_VENDOR_SITES_ALL Attribute14
PVS_ATTRIBUTE15 VARCHAR2 (150)
PO_VENDOR_SITES_ALL Attribute15
PVS_GLOBAL_ATTRIBUTE3 VARCHAR2 (150)
PO_VENDOR_SITES_ALL Global Attribute3
PVS_GLOBAL_ATTRIBUTE4 VARCHAR2 (150)
PO_VENDOR_SITES_ALL Global Attribute4
PVS_GLOBAL_ATTRIBUTE5 VARCHAR2 (150)
PO_VENDOR_SITES_ALL Global Attribute5
PVS_GLOBAL_ATTRIBUTE6 VARCHAR2 (150)
PO_VENDOR_SITES_ALL Global Attribute6
PVS_GLOBAL_ATTRIBUTE7 VARCHAR2 (150)
PO_VENDOR_SITES_ALL Global Attribute7
PVS_GLOBAL_ATTRIBUTE8 VARCHAR2 (150)
PO_VENDOR_SITES_ALL Global Attribute8
PVS_GLOBAL_ATTRIBUTE9 VARCHAR2 (150)
PO_VENDOR_SITES_ALL Global Attribute9
PVS_GLOBAL_ATTRIBUTE10 VARCHAR2 (150)
PO_VENDOR_SITES_ALL Global Attribute10
PVS_GLOBAL_ATTRIBUTE11 VARCHAR2 (150)
PO_VENDOR_SITES_ALL Global Attribute11
PVS_GLOBAL_ATTRIBUTE12 VARCHAR2 (150)
PO_VENDOR_SITES_ALL Global Attribute12
PVS_GLOBAL_ATTRIBUTE13 VARCHAR2 (150)
PO_VENDOR_SITES_ALL Global Attribute13
PVS_GLOBAL_ATTRIBUTE14 VARCHAR2 (150)
PO_VENDOR_SITES_ALL Global Attribute14
PVS_GLOBAL_ATTRIBUTE15 VARCHAR2 (150)
PO_VENDOR_SITES_ALL Global Attribute15
PVS_GLOBAL_ATTRIBUTE16 VARCHAR2 (150)
PO_VENDOR_SITES_ALL Global Attribute16
PVS_GLOBAL_ATTRIBUTE17 VARCHAR2 (150)
PO_VENDOR_SITES_ALL Global Attribute17
PVS_GLOBAL_ATTRIBUTE18 VARCHAR2 (150)
PO_VENDOR_SITES_ALL Global Attribute18
PVS_GLOBAL_ATTRIBUTE19 VARCHAR2 (150)
PO_VENDOR_SITES_ALL Global Attribute19
PVS_GLOBAL_ATTRIBUTE20 VARCHAR2 (150)
PO_VENDOR_SITES_ALL Global Attribute20
PVS_ATTRIBUTE_CATEGORY VARCHAR2 (150)
PO_VENDOR_SITES_ALL Attribute Category
PVS_GA_CATEGORY VARCHAR2 (150)
PO_VENDOR_SITES_ALLGlobal Attribute Category
INV_ATTRIBUTE1 VARCHAR2 (150)
AP_INVOICES_ALL Attribute1
INV_ATTRIBUTE2 VARCHAR2 (150)
AP_INVOICES_ALL Attribute2
INV_ATTRIBUTE3 VARCHAR2 (150)
AP_INVOICES_ALL Attribute3
INV_ATTRIBUTE4 VARCHAR2 (150)
AP_INVOICES_ALL Attribute4
INV_ATTRIBUTE5 VARCHAR2 (150)
AP_INVOICES_ALL Attribute5
INV_ATTRIBUTE6 VARCHAR2 (150)
AP_INVOICES_ALL Attribute6
INV_ATTRIBUTE7 VARCHAR2 (150)
AP_INVOICES_ALL Attribute7
INV_ATTRIBUTE8 VARCHAR2 (150)
AP_INVOICES_ALL Attribute8
INV_ATTRIBUTE9 VARCHAR2 (150)
AP_INVOICES_ALL Attribute9
INV_ATTRIBUTE10 VARCHAR2 (150)
AP_INVOICES_ALL Attribute10
INV_ATTRIBUTE11 VARCHAR2 (150)
AP_INVOICES_ALL Attribute11
INV_ATTRIBUTE12 VARCHAR2 (150)
AP_INVOICES_ALL Attribute12
INV_ATTRIBUTE13 VARCHAR2 (150)
AP_INVOICES_ALL Attribute13
INV_ATTRIBUTE14 VARCHAR2 (150)
AP_INVOICES_ALL Attribute14
INV_ATTRIBUTE15 VARCHAR2 (150)
AP_INVOICES_ALL Attribute15
INV_GLOBAL_ATTRIBUTE1 VARCHAR2 (150)
AP_INVOICES_ALL Global Attribute1
INV_GLOBAL_ATTRIBUTE2 VARCHAR2 (150)
AP_INVOICES_ALL Global Attribute2
INV_GLOBAL_ATTRIBUTE3 VARCHAR2 (150)
AP_INVOICES_ALL Global Attribute3
INV_GLOBAL_ATTRIBUTE4 VARCHAR2 (150)
AP_INVOICES_ALL Global Attribute4
INV_GLOBAL_ATTRIBUTE5 VARCHAR2 (150)
AP_INVOICES_ALL Global Attribute5
INV_GLOBAL_ATTRIBUTE6 VARCHAR2 (150)
AP_INVOICES_ALL Global Attribute6
INV_GLOBAL_ATTRIBUTE7 VARCHAR2 (150)
AP_INVOICES_ALL Global Attribute7
INV_GLOBAL_ATTRIBUTE8 VARCHAR2 (150)
AP_INVOICES_ALL Global Attribute8
INV_GLOBAL_ATTRIBUTE9 VARCHAR2 (150)
AP_INVOICES_ALL Global Attribute9
INV_GLOBAL_ATTRIBUTE10 VARCHAR2 (150)
AP_INVOICES_ALL Global Attribute10
INV_GLOBAL_ATTRIBUTE11 VARCHAR2 (150)
AP_INVOICES_ALL Global Attribute11
INV_GLOBAL_ATTRIBUTE12 VARCHAR2 (150)
AP_INVOICES_ALL Global Attribute12
INV_GLOBAL_ATTRIBUTE13 VARCHAR2 (150)
AP_INVOICES_ALL Global Attribute13
INV_GLOBAL_ATTRIBUTE14 VARCHAR2 (150)
AP_INVOICES_ALL Global Attribute14
INV_GLOBAL_ATTRIBUTE15 VARCHAR2 (150)
AP_INVOICES_ALL Global Attribute15
INV_GLOBAL_ATTRIBUTE16 VARCHAR2 (150)
AP_INVOICES_ALL Global Attribute16
INV_GLOBAL_ATTRIBUTE17 VARCHAR2 (150)
AP_INVOICES_ALL Global Attribute17
INV_GLOBAL_ATTRIBUTE18 VARCHAR2 (150)
AP_INVOICES_ALL Global Attribute18
INV_GLOBAL_ATTRIBUTE19 VARCHAR2 (150)
AP_INVOICES_ALL Global Attribute19
INV_GLOBAL_ATTRIBUTE20 VARCHAR2 (150)
AP_INVOICES_ALL Global Attribute20
INV_ATTRIBUTE_CATEGORY VARCHAR2 (150)
AP_INVOICES Attribute Category
INV_GA_CATEGORY VARCHAR2 (150)
AP_INVOICES Global Attribute Category
IND_GLOBAL_ATTRIBUTE1 VARCHAR2 (150)
AP_INVOICE_DISTRIBUTIONS_ALL Global Attribute1
IND_GLOBAL_ATTRIBUTE2 VARCHAR2 (150)
AP_INVOICE_DISTRIBUTIONS_ALL Global Attribute2
IND_GLOBAL_ATTRIBUTE3 VARCHAR2 (150)
AP_INVOICE_DISTRIBUTIONS_ALL Global Attribute3
IND_GLOBAL_ATTRIBUTE4 VARCHAR2 (150)
AP_INVOICE_DISTRIBUTIONS_ALL Global Attribute4
IND_GLOBAL_ATTRIBUTE5 VARCHAR2 (150)
AP_INVOICE_DISTRIBUTIONS_ALL Global Attribute5
IND_GLOBAL_ATTRIBUTE6 VARCHAR2 (150)
AP_INVOICE_DISTRIBUTIONS_ALL Global Attribute6
IND_GLOBAL_ATTRIBUTE7 VARCHAR2 (150)
AP_INVOICE_DISTRIBUTIONS_ALL Global Attribute7
IND_GLOBAL_ATTRIBUTE8 VARCHAR2 (150)
AP_INVOICE_DISTRIBUTIONS_ALL Global Attribute8
IND_GLOBAL_ATTRIBUTE9 VARCHAR2 (150)
AP_INVOICE_DISTRIBUTIONS_ALL Global Attribute9
IND_GLOBAL_ATTRIBUTE10 VARCHAR2 (150)
AP_INVOICE_DISTRIBUTIONS_ALL Global Attribute10
IND_GLOBAL_ATTRIBUTE11 VARCHAR2 (150)
AP_INVOICE_DISTRIBUTIONS_ALL Global Attribute11
IND_GLOBAL_ATTRIBUTE12 VARCHAR2 (150)
AP_INVOICE_DISTRIBUTIONS_ALL Global Attribute12
IND_GLOBAL_ATTRIBUTE13 VARCHAR2 (150)
AP_INVOICE_DISTRIBUTIONS_ALL Global Attribute13
IND_GLOBAL_ATTRIBUTE14 VARCHAR2 (150)
AP_INVOICE_DISTRIBUTIONS_ALL Global Attribute14
IND_GLOBAL_ATTRIBUTE15 VARCHAR2 (150)
AP_INVOICE_DISTRIBUTIONS_ALL Global Attribute15
IND_GLOBAL_ATTRIBUTE16 VARCHAR2 (150)
AP_INVOICE_DISTRIBUTIONS_ALL Global Attribute16
IND_GLOBAL_ATTRIBUTE17 VARCHAR2 (150)
AP_INVOICE_DISTRIBUTIONS_ALL Global Attribute17
IND_GLOBAL_ATTRIBUTE18 VARCHAR2 (150)
AP_INVOICE_DISTRIBUTIONS_ALL Global Attribute18
IND_GLOBAL_ATTRIBUTE19 VARCHAR2 (150)
AP_INVOICE_DISTRIBUTIONS_ALL Global Attribute19
IND_GLOBAL_ATTRIBUTE20 VARCHAR2 (150)
AP_INVOICE_DISTRIBUTIONS_ALL Global Attribute20
IND_GA_CATEGORY VARCHAR2 (150)
AP_INVOICE_DISTRIBUTIONS_ALL Global Attribute Category
SUPPLIER_COUNTRY VARCHAR2 (25)
Supplier's Country
SUPPLIER_ADDRESS_LINE1 VARCHAR2 (240)
Supplier's Address Line 1
SUPPLIER_ADDRESS_LINE2 VARCHAR2 (240)
Supplier's Address Line 2
SUPPLIER_ADDRESS_LINE3 VARCHAR2 (240)
Supplier's Address Line 3
SUPPLIER_CITY VARCHAR2 (25)
Supplier's City
SUPPLIER_POSTAL_CODE VARCHAR2 (20)
Supplier's Zip code
SUPPLIER_PROVINCE VARCHAR2 (150)
Supplier's Province
SUPPLIER_COUNTY VARCHAR2 (150)
Supplier Site County
SUPP_CONCATENATED_ADDRESS VARCHAR2 (800)
Concatenated Supplier Address
PVS_GLOBAL_ATTRIBUTE1 VARCHAR2 (150)
Supplier's Tax Authority
SUPPLIER_TAX_REGISTRATION_NUM VARCHAR2 (20)
Supplier's VAT Registration Number
SUPPLIER_TAXPAYER_ID VARCHAR2 (30)
Supplier's Tax Payer ID
PVS_GLOBAL_ATTRIBUTE2 VARCHAR2 (150)
Subcategory of Business Income
BIZ_INC_SUB_CATEG_MEANING VARCHAR2 (80)
Meaning of the Business Income Subcategory code
DIST_CODE_COMBINATION_ID NUMBER (15)
Accounting flex field identifier for account associated with a distribution line
ACCOUNTING_FLEXFIELD VARCHAR2 (1000)
Stores the concatenated value of the accounting flex field
TRANSACTION_NUMBER VARCHAR2 (50) Y Invoice Number
ACCOUNTING_DATE DATE
Y GL Accounting Date of Withholding
DOCUMENT_NUMBER VARCHAR2 (50)
Document Sequence Number
ORGANIZATION_TYPE VARCHAR2 (25)
Supplier's Organization Type
ORG_TYPE_MEANING VARCHAR2 (80)
Meaning of the organization type lookup code
TAX_ID NUMBER (15) Y Id of Tax Code
TAX_CODE VARCHAR2 (15) Y Withholding Tax Name
AWT_DESCRIPTION VARCHAR2 (240)
Description of Withholding Tax Name
TAX_TYPE VARCHAR2 (25)
Type of Tax
TAX_RATE_ID NUMBER (15) Y Tax Rate Id
TAX_RATE NUMBER
Y Tax Code Rate
ATC_GLOBAL_ATTRIBUTE6 VARCHAR2 (150)
Recognized Expense Percentage
ATC_GLOBAL_ATTRIBUTE7 VARCHAR2 (150)
Nominal Tax Rate
ATC_GLOBAL_ATTRIBUTE1 VARCHAR2 (150)
Location associated with the Tax code
ATC_GLOBAL_ATTRIBUTE2 VARCHAR2 (150)
AP_TAX_CODES_ALL Global Attribute2
ATC_GLOBAL_ATTRIBUTE3 VARCHAR2 (150)
AP_TAX_CODES_ALL Global Attribute3
ATC_GLOBAL_ATTRIBUTE8 VARCHAR2 (150)
AP_TAX_CODES_ALL Global Attribute8
ATC_GLOBAL_ATTRIBUTE9 VARCHAR2 (150)
Category of Resident Income
ATC_GLOBAL_ATTRIBUTE10 VARCHAR2 (150)
AP_TAX_CODES_ALL Global Attribute10
ATC_GLOBAL_ATTRIBUTE11 VARCHAR2 (150)
AP_TAX_CODES_ALL Global Attribute11
ATC_GLOBAL_ATTRIBUTE12 VARCHAR2 (150)
AP_TAX_CODES_ALL Global Attribute12
ATC_GLOBAL_ATTRIBUTE13 VARCHAR2 (150)
AP_TAX_CODES_ALL Global Attribute13
ATC_GLOBAL_ATTRIBUTE14 VARCHAR2 (150)
AP_TAX_CODES_ALL Global Attribute14
ATC_GLOBAL_ATTRIBUTE15 VARCHAR2 (150)
AP_TAX_CODES_ALL Global Attribute15
ATC_GLOBAL_ATTRIBUTE16 VARCHAR2 (150)
AP_TAX_CODES_ALL Global Attribute16
ATC_GLOBAL_ATTRIBUTE17 VARCHAR2 (150)
AP_TAX_CODES_ALL Global Attribute17
ATC_GLOBAL_ATTRIBUTE18 VARCHAR2 (150)
AP_TAX_CODES_ALL Global Attribute18
ATC_GLOBAL_ATTRIBUTE19 VARCHAR2 (150)
AP_TAX_CODES_ALL Global Attribute19
ATC_GLOBAL_ATTRIBUTE20 VARCHAR2 (150)
AP_TAX_CODES_ALL Global Attribute20
ATC_GA_CATEGORY VARCHAR2 (150)
AP_TAX_CODES_ALL Global Attribute Category
WH_TAX_TYPE_MEANING VARCHAR2 (80)
Meaning of the Withholding Tax Type lookup code
ATC_GLOBAL_ATTRIBUTE4 VARCHAR2 (150)
Withholding Tax Type of the Tax Code (Stores the lookup code of the tax type)
RES_INC_CATEG_MEANING VARCHAR2 (80)
Meaning of the Resident Income category code
ATC_GLOBAL_ATTRIBUTE5 VARCHAR2 (150)
Category of Foreign Income
FOR_INC_CATEG_MEANING VARCHAR2 (80)
Meaning of the Foreign Income Category Code
TAX_AUTHORITY_NAME VARCHAR2 (240) Y Name of the Tax Authority for the tax code
STATUS VARCHAR2 (1)
Payment status
INCOME_TAX NUMBER

Income Withholding Tax amount of the invoice
RESIDENT_TAX NUMBER

Resident Withholding Tax amount of the invoice
TOTAL_WHT_AMOUNT NUMBER

Total of income tax & resident tax withheld amount
PAYMENT_CURRENCY VARCHAR2 (15)
Payment Currency code
INVOICE_PAYMENT_ID NUMBER (15)
Invoice Payment Id
PAYMENT_AMOUNT NUMBER

Payment Amount for the invoice
PAYMENT_DATE DATE

Invoice Payment Date
PAYMENT_NUMBER NUMBER (15)
Invoice Payment Number
CHECK_ID NUMBER (15)
Check Id
CHECK_NUMBER NUMBER (15)
Check Number for the invoice payment
CHECK_AMOUNT NUMBER

Check Amount
INVOICE_ID NUMBER (15) Y Invoice Id
INVOICE_DISTRIBUTION_ID NUMBER (15) Y Invoice Distribution Id
INVOICE_AMOUNT NUMBER

Amount of Invoice
INVOICE_DATE DATE

Invoice Date
CURRENCY_CODE VARCHAR2 (15)
Transaction Currency Code
FUNC_CURRENCY_CODE VARCHAR2 (15)
Functional Currency Code
AMT_SUBJECT_TO_WH NUMBER

Amount used to calculate withholding taxes
RECOGNIZED_EXPENSE_AMT NUMBER

Amount reduced for recognized expense.
INC_WH_TAX_BASE_AMT NUMBER

Taxable base amount for the income withholding tax code
RES_WH_TAX_BASE_AMT NUMBER

Taxable base amount for the resident withholding tax code
TOTAL_TAX_BASE_AMT NUMBER

Total Taxable base amount
NET_AMOUNT NUMBER

Net Payment Amount
LINE_NUMBER NUMBER (15)
Distribution Line number
TYPE_1099 VARCHAR2 (10)
1099 Type
ITEM_DESCRIPTION VARCHAR2 (240)
Description of the invoice distribution line
ORGANIZATION_NAME VARCHAR2 (60)
Name of the Operating Unit
REPORTING_ENTITY_NAME VARCHAR2 (50)
Name of the reporting entity
REPORTING_SOB_NAME VARCHAR2 (30)
Set of Book Name
SOB_ID NUMBER (15) Y Set of Books Id
REQUEST_ID NUMBER (15) Y Request Id of the concurrent program populating this table
NOMINAL_OR_REG_TAX_RATE NUMBER

If Recognized expense is applicable, this shows nominal tax rate, else normal tax rate
LAST_UPDATE_DATE DATE
Y Standard WHO Column
LAST_UPDATED_BY NUMBER (15) Y Standard WHO Column
LAST_UPDATE_LOGIN NUMBER (15) Y Standard WHO Column
CREATION_DATE DATE
Y Standard WHO Column
CREATED_BY NUMBER (15) Y Standard WHO Column
INVOICE_LINE_NUM NUMBER

Invoice Line Number

[top of page]

JG.JG_ZZ_AP_WHT_ITF does not reference any database object

JG.JG_ZZ_AP_WHT_ITF is referenced by following:

APPS
SYNONYM - JG_ZZ_AP_WHT_ITF

[top of page]

Table: JG_ZZ_AR_BALANCES

Description: Sub-ledger balances for Receivables
Primary Key: JG_ZZ_AR_BALANCES_PK
  1. SET_OF_BOOKS_ID
  2. CODE_COMBINATION_ID
  3. CURRENCY_CODE
  4. PERIOD_NAME
  5. CUSTOMER_ID
  6. CUSTOMER_SITE_ID
Comments
Indexes
Index Type Tablespace Column
JG_ZZ_AR_BALANCES_U1 UNIQUE APPS_TS_TX_IDX SET_OF_BOOKS_ID
CODE_COMBINATION_ID
CURRENCY_CODE
PERIOD_NAME
CUSTOMER_ID
CUSTOMER_SITE_ID
Columns
Name Datatype Length Mandatory Comments
SET_OF_BOOKS_ID NUMBER (15) Y
CODE_COMBINATION_ID NUMBER (15) Y
CURRENCY_CODE VARCHAR2 (15) Y
PERIOD_NAME VARCHAR2 (15) Y
CUSTOMER_ID NUMBER (15) Y
CUSTOMER_SITE_ID NUMBER (15) Y
BEGIN_BAL_ENTERED_DR NUMBER

BEGIN_BAL_ENTERED_CR NUMBER

BEGIN_BAL_ACCOUNTED_DR NUMBER

BEGIN_BAL_ACCOUNTED_CR NUMBER

PERIOD_NET_ENTERED_DR NUMBER

PERIOD_NET_ENTERED_CR NUMBER

PERIOD_NET_ACCOUNTED_DR NUMBER

PERIOD_NET_ACCOUNTED_CR NUMBER

LAST_UPDATE_DATE DATE
Y
LAST_UPDATED_BY NUMBER (15) Y
CREATION_DATE DATE
Y
CREATED_BY NUMBER (15) Y
POSTED_TO_GL_FLAG VARCHAR2 (1)

[top of page]

AR.JG_ZZ_AR_BALANCES does not reference any database object

AR.JG_ZZ_AR_BALANCES is referenced by following:

APPS
SYNONYM - JG_ZZ_AR_BALANCES

[top of page]

Table: JG_ZZ_AR_SRC_TRX_TY_ALL

Description: This table stores associations of transaction sources and transaction types. This table restricts you to using only associated transaction types for a selected transaction source.
Primary Key: JG_ZZ_AR_SRC_TRX_TY_ALL_PK
  1. BATCH_SOURCE_ID
  2. CUST_TRX_TYPE_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
JG_ZZ_AR_SRC_TRX_TY_ALL.BATCH_SOURCE_ID RA_BATCH_SOURCES_ALL
JG_ZZ_AR_SRC_TRX_TY_ALL.CUST_TRX_TYPE_ID RA_CUST_TRX_TYPES_ALL
Comments

This table stores associations of transaction sources and transaction types. This table restricts you to using only associated transaction types for a selected transaction source.

Columns
Name Datatype Length Mandatory Comments
BATCH_SOURCE_ID NUMBER (15) Y Batch source identifier
CUST_TRX_TYPE_ID NUMBER (15) Y Transaction type identifier
INVOICE_CLASS VARCHAR2 (20) Y Transaction class, could be one of NV,CM,DM,GUAR,DEP,CB
ORG_ID NUMBER (15)
Operating unit identifier
LAST_UPDATE_DATE DATE
Y Standard Who column
LAST_UPDATED_BY NUMBER (15) Y Standard Who column
CREATION_DATE DATE
Y Standard Who column
CREATED_BY NUMBER (15) Y Standard Who column
LAST_UPDATE_LOGIN NUMBER (15)
Standard Who column
ATTRIBUTE_CATEGORY VARCHAR2 (30)
Descriptive Flexfield structure defining column
ATTRIBUTE1 VARCHAR2 (150)
Descriptive Flexfield segment column
ATTRIBUTE2 VARCHAR2 (150)
Descriptive Flexfield segment column
ATTRIBUTE3 VARCHAR2 (150)
Descriptive Flexfield segment column
ATTRIBUTE4 VARCHAR2 (150)
Descriptive Flexfield segment column
ATTRIBUTE5 VARCHAR2 (150)
Descriptive Flexfield segment column
ATTRIBUTE6 VARCHAR2 (150)
Descriptive Flexfield segment column
ATTRIBUTE7 VARCHAR2 (150)
Descriptive Flexfield segment column
ATTRIBUTE8 VARCHAR2 (150)
Descriptive Flexfield segment column
ATTRIBUTE9 VARCHAR2 (150)
Descriptive Flexfield segment column
ATTRIBUTE10 VARCHAR2 (150)
Descriptive Flexfield segment column
ATTRIBUTE11 VARCHAR2 (150)
Descriptive Flexfield segment column
ATTRIBUTE12 VARCHAR2 (150)
Descriptive Flexfield segment column
ATTRIBUTE13 VARCHAR2 (150)
Descriptive Flexfield segment column
ATTRIBUTE14 VARCHAR2 (150)
Descriptive Flexfield segment column
ATTRIBUTE15 VARCHAR2 (150)
Descriptive Flexfield segment column
ENABLE_FLAG VARCHAR2 (1)
Transaction type disabled Y/N
NUMERIC_BAR_CODE VARCHAR2 (100)
It stores the numeric bar code for the document numbering requirement.

[top of page]

JG.JG_ZZ_AR_SRC_TRX_TY_ALL does not reference any database object

JG.JG_ZZ_AR_SRC_TRX_TY_ALL is referenced by following:

APPS
SYNONYM - JG_ZZ_AR_SRC_TRX_TY
SYNONYM - JG_ZZ_AR_SRC_TRX_TY_ALL

[top of page]

Table: JG_ZZ_AR_TMP_ACCOUNT

Description: Table containing information about each contra account
Comments
Indexes
Index Type Tablespace Column
JG_ZZ_AR_TMP_ACCOUNT_N1 NONUNIQUE APPS_TS_TX_IDX CONTRA_HEADER_ID
Columns
Name Datatype Length Mandatory Comments
REQUEST_ID NUMBER (15)
VAT_TAX_ID NUMBER (15)
MEMO_LINE_ID NUMBER (15)
CONTRA_HEADER_ID VARCHAR2 (85) Y
CODE_COMBINATION_ID NUMBER (15)
LINE_NUMBER NUMBER (15)
LINK_LINE_NUM NUMBER (15)
LINE_TYPE VARCHAR2 (25)
ACCT_FLEX_FIELD VARCHAR2 (240)
ACCT_FLEX_DESC VARCHAR2 (1200)
BALANCE VARCHAR2 (25)
BALANCE_DESC VARCHAR2 (240)
ACCOUNT VARCHAR2 (25)
ACCOUNT_DESC VARCHAR2 (240)
ACCTD_DR NUMBER

ACCTD_CR NUMBER

ENTERED_DR NUMBER

ENTERED_CR NUMBER

POSTED_TO_GL_FLAG VARCHAR2 (1)
TAX_NAME VARCHAR2 (50)
DESCRIPTION VARCHAR2 (240)
CREATED_BY NUMBER (15)
CREATION_DATE DATE

LAST_UPDATED_BY NUMBER (15)
LAST_UPDATE_DATE DATE

LAST_UPDATE_LOGIN NUMBER (15)

[top of page]

AR.JG_ZZ_AR_TMP_ACCOUNT does not reference any database object

AR.JG_ZZ_AR_TMP_ACCOUNT is referenced by following:

APPS
SYNONYM - JG_ZZ_AR_TMP_ACCOUNT

[top of page]

Table: JG_ZZ_AR_TMP_BAL

Description: Temporary sub-ledger balances for Receivables
Primary Key: JG_ZZ_AR_TMP_BAL_PK
  1. SET_OF_BOOKS_ID
  2. CODE_COMBINATION_ID
  3. CURRENCY_CODE
  4. PERIOD_NAME
  5. CUSTOMER_ID
  6. CUSTOMER_SITE_ID
Comments
Indexes
Index Type Tablespace Column
JG_ZZ_AR_TMP_BAL_N1 NONUNIQUE APPS_TS_TX_IDX SET_OF_BOOKS_ID
PERIOD_NAME
CUSTOMER_ID
Columns
Name Datatype Length Mandatory Comments
SET_OF_BOOKS_ID NUMBER (15) Y
CODE_COMBINATION_ID NUMBER (15) Y
CURRENCY_CODE VARCHAR2 (15) Y
PERIOD_NAME VARCHAR2 (15) Y
CUSTOMER_ID NUMBER (15) Y
CUSTOMER_SITE_ID NUMBER (15) Y
BEGIN_BAL_ENTERED_DR NUMBER

BEGIN_BAL_ENTERED_CR NUMBER

BEGIN_BAL_ACCOUNTED_DR NUMBER

BEGIN_BAL_ACCOUNTED_CR NUMBER

PERIOD_NET_ENTERED_DR NUMBER

PERIOD_NET_ENTERED_CR NUMBER

PERIOD_NET_ACCOUNTED_DR NUMBER

PERIOD_NET_ACCOUNTED_CR NUMBER

LAST_UPDATE_DATE DATE
Y
LAST_UPDATED_BY NUMBER (15) Y
CREATION_DATE DATE
Y
CREATED_BY NUMBER (15) Y
POSTED_TO_GL_FLAG VARCHAR2 (1)

[top of page]

AR.JG_ZZ_AR_TMP_BAL does not reference any database object

AR.JG_ZZ_AR_TMP_BAL is referenced by following:

APPS
SYNONYM - JG_ZZ_AR_TMP_BAL

[top of page]

Table: JG_ZZ_AR_TMP_DETAIL

Description: Used for calculating sub-ledger balances and holding detailed reporting data for Receivables
Comments
Indexes
Index Type Tablespace Column
JG_ZZ_AR_TMP_DETAIL_N1 NONUNIQUE APPS_TS_TX_IDX SET_OF_BOOKS_ID
ACCOUNTING_DATE
CUSTOMER_ID
JG_ZZ_AR_TMP_DETAIL_N2 NONUNIQUE APPS_TS_TX_IDX CODE_COMBINATION_ID
Columns
Name Datatype Length Mandatory Comments
SET_OF_BOOKS_ID NUMBER (15) Y
ACCOUNTING_DATE DATE
Y
SUBLEDGER_DOC_SEQUENCE_ID NUMBER

SUBLEDGER_DOC_SEQUENCE_VALUE NUMBER

CURRENCY_CODE VARCHAR2 (15) Y
CODE_COMBINATION_ID NUMBER (15)
ENTERED_DR NUMBER

ENTERED_CR NUMBER

ACCOUNTED_DR NUMBER

ACCOUNTED_CR NUMBER

TRANS_TYPE VARCHAR2 (25)
TRANS_NUMBER VARCHAR2 (50)
TRANS_DESCRIPTION VARCHAR2 (240)
CUSTOMER_ID NUMBER (15)
CUSTOMER_SITE_ID NUMBER (15)
POSTED_TO_GL_FLAG VARCHAR2 (1)
CREATED_BY NUMBER (15) Y
DATE_CREATED DATE
Y
CONTRA_HEADER_ID VARCHAR2 (85)
ACCOUNT_CLASS VARCHAR2 (20)
TRANSACTION_ID NUMBER (15)
ACCT_FLEX_FIELD VARCHAR2 (240)
ACCT_FLEX_DESC VARCHAR2 (1200)
BALANCE VARCHAR2 (25)
BALANCE_DESC VARCHAR2 (240)
ACCOUNT VARCHAR2 (25)
ACCOUNT_DESC VARCHAR2 (240)
PURCHASE_ORDER VARCHAR2 (50)
AGREEMENT_NAME VARCHAR2 (30)

[top of page]

AR.JG_ZZ_AR_TMP_DETAIL does not reference any database object

AR.JG_ZZ_AR_TMP_DETAIL is referenced by following:

APPS
SYNONYM - JG_ZZ_AR_TMP_DETAIL

[top of page]

Table: JG_ZZ_ENTITY_ASSOC

Description: Business Entity Relationships information
Primary Key: JG_ZZ_ENTITY_ASSOC_PK
  1. ENTITY_ASSOCIATION_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
JG_ZZ_ENTITY_ASSOC.ASSOCIATED_ENTITY_ID PO_VENDORS
Comments

JGZZ_ENTITY_ASSOC stores information about Business Entity Relationships. It relates a Business Entity (Customer, Supplier or Company) with Related Businesses (Tax Authorities) and the Secondary ID Numbers. Multiple relationships can be created for a single Business Entity.
The Business Entity is represented by the PRIMARY_ID_NUMBER column whose value is derived from either HR_LOCATIONS.GLOBAL_ATTRIBUTE11, RA_CUSTOMERS.JGZZ_FISCAL_CODE, or PO_VENDORS.NUM_1099 column. The Related Business is represented by the ASSOCIATED_ENTITY_ID column, whose value is derived from PO_VENDORS.VENDOR_ID column. The Related Business is defined in the Suppliers Window as "Tax Authority" classification. The Secondary ID Type is represented by the ID_TYPE column, whose value is derived from a user definable lookup with a type of JGZZ_ENTITY_ASSOC_ID_TYPE. The Secondary ID Number is represented by the ID_NUMBER column.

Columns
Name Datatype Length Mandatory Comments
ENTITY_ASSOCIATION_ID NUMBER (15) Y Business entity relationship identifier
ASSOCIATED_ENTITY_ID NUMBER
Y Associated entity identifier
CREATED_BY NUMBER (15) Y Standard Who column
LAST_UPDATED_BY NUMBER (15) Y Standard Who column
PRIMARY_ID_NUMBER VARCHAR2 (30) Y Primary identity number
ID_TYPE VARCHAR2 (30) Y Identity type
ID_NUMBER VARCHAR2 (30) Y Identity number
EFFECTIVE_DATE DATE
Y Effective date
CREATION_DATE DATE
Y Standard Who column
LAST_UPDATE_DATE DATE
Y Standard Who column
LAST_UPDATE_LOGIN NUMBER (15)
Standard Who column
DESCRIPTION VARCHAR2 (240)
Description
INEFFECTIVE_DATE DATE

Ineffective date
ATTRIBUTE_CATEGORY VARCHAR2 (30)
Descriptive Flexfield structure defining column
ATTRIBUTE1 VARCHAR2 (150)
Descriptive Flexfield segment column
ATTRIBUTE2 VARCHAR2 (150)
Descriptive Flexfield segment column
ATTRIBUTE3 VARCHAR2 (150)
Descriptive Flexfield segment column
ATTRIBUTE4 VARCHAR2 (150)
Descriptive Flexfield segment column
ATTRIBUTE5 VARCHAR2 (150)
Descriptive Flexfield segment column
ATTRIBUTE6 VARCHAR2 (150)
Descriptive Flexfield segment column
ATTRIBUTE7 VARCHAR2 (150)
Descriptive Flexfield segment column
ATTRIBUTE8 VARCHAR2 (150)
Descriptive Flexfield segment column
ATTRIBUTE9 VARCHAR2 (150)
Descriptive Flexfield segment column
ATTRIBUTE10 VARCHAR2 (150)
Descriptive Flexfield segment column
ATTRIBUTE11 VARCHAR2 (150)
Descriptive Flexfield segment column
ATTRIBUTE12 VARCHAR2 (150)
Descriptive Flexfield segment column
ATTRIBUTE13 VARCHAR2 (150)
Descriptive Flexfield segment column
ATTRIBUTE14 VARCHAR2 (150)
Descriptive Flexfield segment column
ATTRIBUTE15 VARCHAR2 (150)
Descriptive Flexfield segment column
ATTRIBUTE16 VARCHAR2 (150)
Descriptive Flexfield segment column
ATTRIBUTE17 VARCHAR2 (150)
Descriptive Flexfield segment column
ATTRIBUTE18 VARCHAR2 (150)
Descriptive Flexfield segment column
ATTRIBUTE19 VARCHAR2 (150)
Descriptive Flexfield segment column
ATTRIBUTE20 VARCHAR2 (150)
Descriptive Flexfield segment column

[top of page]

JG.JG_ZZ_ENTITY_ASSOC does not reference any database object

JG.JG_ZZ_ENTITY_ASSOC is referenced by following:

APPS
SYNONYM - JG_ZZ_ENTITY_ASSOC

[top of page]

Table: JG_ZZ_FA_REG_ITF

Description: JG_ZZ_FA_REG_ITF holds data needed for Fixed Assets Register Report
Comments

JG_ZZ_FA_REG_ITF used by Fixed Assets Register Report

Columns
Name Datatype Length Mandatory Comments
REQUEST_ID NUMBER
Y Request Id
ORGANIZATION_NAME VARCHAR2 (60) Y Name of the Operating Unit
FUNCTIONAL_CURRENCY_CODE VARCHAR2 (15) Y Functional Currency Code
LAST_UPDATE_DATE DATE
Y Standard Who column
LAST_UPDATED_BY NUMBER
Y Standard Who column
LAST_UPDATE_LOGIN NUMBER

Standard Who column
CREATION_DATE DATE
Y Standard Who column
CREATED_BY NUMBER
Y Standard Who column
MAJOR_CATEGORY VARCHAR2 (30) Y Major Category
MINOR_CATEGORY VARCHAR2 (30)
Minor Category
DEPRN_RATE NUMBER

Depreciation Rate
STARTING_DEPRN_YEAR VARCHAR2 (4)
Starting Year of Depreciation
ASSET_HEADING VARCHAR2 (15)
Constant Text
ASSET_NUMBER VARCHAR2 (15) Y Asset Number
DESCRIPTION VARCHAR2 (80)
Description
PARENT_ASSET_ID NUMBER

Parent Asset Id
PARENT_ASSET_NUMBER VARCHAR2 (15)
Parent Asset Number
ASSET_COST_ORIG NUMBER

Original Asset Cost
BONUS_RATE NUMBER

Bonus Rate
INVOICE_NUMBER VARCHAR2 (50)
Invoice Number
SUPPLIER_NAME VARCHAR2 (360)
Supplier Name
COST_ACCOUNT VARCHAR2 (25)
Cost Account
EXPENSE_ACCOUNT VARCHAR2 (25)
Expense Account
RESERVE_ACCOUNT VARCHAR2 (25)
Reserve Account
BONUS_DEPRN_ACCOUNT VARCHAR2 (25)
Bonus Depreciation Account
BONUS_RESERVE_ACCOUNT VARCHAR2 (25)
Bonus Reserve Account
ASSET_COST_INITIAL NUMBER

Initial Asset Cost
ASSET_COST_INCREASE NUMBER

Asset Cost Increase
ASSET_COST_DECREASE NUMBER

Asset Cost Decrease
ASSET_COST_FINAL NUMBER

Final Asset Cost
REVALUATION_INITIAL NUMBER

Initial Revaluation Cost
REVALUATION_INCREASE NUMBER

Revaluation Increase
REVALUATION_DECREASE NUMBER

Revaluation Decrease
REVALUATION_FINAL NUMBER

Final Revaluation Cost
DEPRN_RESERVE_INITIAL NUMBER

Initial Depreciation Reserve
DEPRN_RESERVE_INCREASE NUMBER

Depreciation Reserve Increase
DEPRN_RESERVE_DECREASE NUMBER

Depreciation Reserve Decrease
DEPRN_RESERVE_FINAL NUMBER

Final Depreciation Reserve
BONUS_RESERVE_INITIAL NUMBER

Initial Bonus Reserve
BONUS_RESERVE_INCREASE NUMBER

Bonus Reserve Increase
BONUS_RESERVE_DECREASE NUMBER

Bonus Reserve Decrease
BONUS_RESERVE_FINAL NUMBER

Bonus Reserve Final
NET_BOOK_VALUE_INITIAL NUMBER

Initial Net Book Value
NET_BOOK_VALUE_INCREASE NUMBER

Net Book Value Increase
NET_BOOK_VALUE_DECREASE NUMBER

Net Book Value Decrease
NET_BOOK_VALUE_FINAL NUMBER

Final Net Book Value
TRANSACTION_DATE DATE

Transaction Date
TRANSACTION_NUMBER NUMBER

Transaction Number
TRANSACTION_CODE VARCHAR2 (20)
Transaction Code
TRANSACTION_AMOUNT NUMBER

Transaction Amount
SALES_AMOUNT NUMBER

Sales Amount
COST_RETIRED NUMBER

Retired Cost
DATE_RETIRED DATE

Date Retired
DEPRN_RESERVE NUMBER

Depreciation Reserve
BONUS_RESERVE NUMBER

Bonus Reserve
NET_BOOK_VALUE NUMBER

Net Book Value
GAIN_LOSS NUMBER

Gain/Loss
HEADER VARCHAR2 (110)
Rxi Report Heading
DATE_PLACED_IN_SERVICE DATE

Date Placed in Service
INITIAL_HEADING VARCHAR2 (15)
Initial Heading
VARIATION_HEADING VARCHAR2 (15)
Variation Heading
FINAL_HEADING VARCHAR2 (132)
Final Heading
ASSET_VARIATION NUMBER

Asset Variation
REVAL_VARIATION NUMBER

Revaluation Variation
DEPRN_VARIATION NUMBER

Depreciation Variation
BONUS_VARIATION NUMBER

Bonus Variation
NETBO_VARIATION NUMBER

Net Book Value Variation
REVALUATION_TOTAL NUMBER

Total Revaluation
DEPRECIATION_METHOD VARCHAR2 (12)
Depreciation Method
LIFE_IN_MONTHS NUMBER

Life in Months
LIFE_IN_YEARS NUMBER

Life in Years
PRORATE_CONVENTION VARCHAR2 (10)
Prorate Convention
TAG_NUMBER VARCHAR2 (15)
Tag Number
SERIAL_NUMBER VARCHAR2 (35)
Serial Number
ASSET_KEY_FLEXFIELD VARCHAR2 (35)
Asset Flexfield Description
YTD_DEPRN NUMBER (15)
Depreciation Expense

[top of page]

JG.JG_ZZ_FA_REG_ITF does not reference any database object

JG.JG_ZZ_FA_REG_ITF is referenced by following:

APPS
SYNONYM - JG_ZZ_FA_REG_ITF

[top of page]

Table: JG_ZZ_GL_RECON_TRX

Description: A RXi Interface Table for the RXi report General Ledger Reconciled Transactions Report.
Comments
Indexes
Index Type Tablespace Column
JG_ZZ_GL_REC_TRX_N1 NONUNIQUE APPS_TS_TX_IDX REQUEST_ID
Columns
Name Datatype Length Mandatory Comments
CREATION_DATE DATE
Y
LAST_UPDATED_BY NUMBER (15) Y
LAST_UPDATE_LOGIN NUMBER (15)
LAST_UPDATE_DATE DATE
Y
CREATED_BY NUMBER (15) Y
REQUEST_ID NUMBER

SET_OF_BOOKS_ID NUMBER (15)
CODE_COMBINATION_ID NUMBER (15)
ACC_FLEX VARCHAR2 (240)
JGZZ_RECON_ID NUMBER

JGZZ_RECON_DATE DATE

JGZZ_RECON_REF VARCHAR2 (240)
NAME VARCHAR2 (100)
EFFECTIVE_DATE DATE

CURRENCY_CODE VARCHAR2 (15)
ENTERED_CR NUMBER

ENTERED_DR NUMBER

ACCOUNTED_CR NUMBER

ACCOUNTED_DR NUMBER

[top of page]

JG.JG_ZZ_GL_RECON_TRX does not reference any database object

JG.JG_ZZ_GL_RECON_TRX is referenced by following:

APPS
SYNONYM - JG_ZZ_GL_RECON_TRX

[top of page]

Table: JG_ZZ_GL_UNREC_TRX

Description: A RXi Interface Table for the RXi report General Ledger Unreconciled Transactions Report.
Comments
Indexes
Index Type Tablespace Column
JG_ZZ_GL_UNREC_TRX_N1 NONUNIQUE APPS_TS_TX_IDX REQUEST_ID
Columns
Name Datatype Length Mandatory Comments
REQUEST_ID NUMBER (15) Y
CREATED_BY NUMBER (15) Y
CREATION_DATE DATE
Y
LAST_UPDATED_BY NUMBER (15) Y
LAST_UPDATE_DATE DATE
Y
LAST_UPDATE_LOGIN NUMBER (15)
ACCOUNTING_FLEXFIELD VARCHAR2 (240)
JGZZ_RECON_REF VARCHAR2 (240)
NAME VARCHAR2 (100)
EFFECTIVE_DATE DATE

CURRENCY_CODE VARCHAR2 (15)
ENTERED_DR NUMBER

ENTERED_CR NUMBER

ACCOUNTED_DR NUMBER

ACCOUNTED_CR NUMBER

PERIOD_NAME VARCHAR2 (15)

[top of page]

JG.JG_ZZ_GL_UNREC_TRX does not reference any database object

JG.JG_ZZ_GL_UNREC_TRX is referenced by following:

APPS
SYNONYM - JG_ZZ_GL_UNREC_TRX

[top of page]

Table: JG_ZZ_II_INT_RATES_ALL

Description:
Primary Key: JG_ZZ_II_INT_RATES_ALL_PK
  1. LOOKUP_TYPE
  2. LOOKUP_CODE
Comments
Columns
Name Datatype Length Mandatory Comments
LOOKUP_TYPE VARCHAR2 (30) Y
LOOKUP_CODE VARCHAR2 (30) Y
MEANING NUMBER
Y
DESCRIPTION VARCHAR2 (240)
ENABLED_FLAG VARCHAR2 (1) Y
START_DATE_ACTIVE DATE

END_DATE_ACTIVE DATE

CREATED_BY NUMBER (15) Y
CREATION_DATE DATE
Y
LAST_UPDATED_BY NUMBER (15) Y
LAST_UPDATE_LOGIN NUMBER (15)
LAST_UPDATE_DATE DATE
Y
ORG_ID NUMBER (15)

[top of page]

AR.JG_ZZ_II_INT_RATES_ALL does not reference any database object

AR.JG_ZZ_II_INT_RATES_ALL is referenced by following:

APPS
SYNONYM - JG_ZZ_II_INT_RATES_ALL

[top of page]

Table: JG_ZZ_INTEREST_BATCHES_ALL

Description: Interest invoice batch details
Primary Key: JG_ZZ_INTEREST_BATCHES_PK
  1. INTEREST_BATCH_ID
  2. ORG_ID
Foreign Keys to this table:
Foreign Key Column Foreign Table
JG_ZZ_INTEREST_INVOICES_ALL.INTEREST_BATCH_ID
JG_ZZ_INTEREST_INVOICES_ALL.ORG_ID 		JG_ZZ_INTEREST_BATCHES_ALL
Comments
Indexes
Index Type Tablespace Column
JG_ZZ_INTEREST_BATCHES_U1 UNIQUE APPS_TS_TX_IDX INTEREST_BATCH_ID
ORG_ID
Columns
Name Datatype Length Mandatory Comments
INTEREST_BATCH_ID NUMBER
Y
BATCH_NAME VARCHAR2 (30) Y
CALCULATE_INTEREST_TO_DATE DATE
Y
GL_DATE DATE
Y
LAST_UPDATED_BY NUMBER (15) Y
LAST_UPDATE_DATE DATE
Y
LAST_UPDATE_LOGIN NUMBER (15)
CREATED_BY NUMBER (15)
CREATION_DATE DATE

TRANSFERRED_FLAG VARCHAR2 (1)
ORG_ID NUMBER (15)

[top of page]

AR.JG_ZZ_INTEREST_BATCHES_ALL does not reference any database object

AR.JG_ZZ_INTEREST_BATCHES_ALL is referenced by following:

APPS
SYNONYM - JG_ZZ_INTEREST_BATCHES_ALL

[top of page]

Table: JG_ZZ_INTEREST_INVOICES_ALL

Description: Invoice header information for interest invoices
Primary Key: JG_ZZ_INTEREST_INVOICES_PK
  1. INTEREST_INVOICE_ID
  2. ORG_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
JG_ZZ_INTEREST_INVOICES_ALL.INTEREST_BATCH_ID
JG_ZZ_INTEREST_INVOICES_ALL.ORG_ID 		JG_ZZ_INTEREST_BATCHES_ALL
Foreign Keys to this table:
Foreign Key Column Foreign Table
JG_ZZ_INT_INV_LINES_ALL.INTEREST_INVOICE_ID
JG_ZZ_INT_INV_LINES_ALL.ORG_ID 		JG_ZZ_INTEREST_INVOICES_ALL
Comments
Indexes
Index Type Tablespace Column
JG_ZZ_INTEREST_INVOICES_U1 UNIQUE APPS_TS_TX_IDX INTEREST_INVOICE_ID
ORG_ID
Columns
Name Datatype Length Mandatory Comments
INTEREST_INVOICE_ID NUMBER (15) Y
INTEREST_BATCH_ID NUMBER (15) Y
CUSTOMER_ID NUMBER (15) Y
CUSTOMER_SITE_USE_ID NUMBER (15)
CURRENCY_CODE VARCHAR2 (15)
EXCHANGE_RATE_TYPE VARCHAR2 (30)
LAST_UPDATED_BY NUMBER (15) Y
LAST_UPDATE_DATE DATE
Y
LAST_UPDATE_LOGIN NUMBER (15)
CREATED_BY NUMBER (15)
CREATION_DATE DATE

ORG_ID NUMBER (15)
EXCHANGE_RATE NUMBER

COLLECTOR_ID NUMBER (15)
CUSTOMER_PROFILE_ID NUMBER (15)

[top of page]

AR.JG_ZZ_INTEREST_INVOICES_ALL does not reference any database object

AR.JG_ZZ_INTEREST_INVOICES_ALL is referenced by following:

APPS
SYNONYM - JG_ZZ_INTEREST_INVOICES_ALL

[top of page]

Table: JG_ZZ_INT_INV_LINES_ALL

Description: Detail invoice lines for interest invoices
Primary Key: JG_ZZ_INT_INV_LINES_PK
  1. INTEREST_INVOICE_ID
  2. INTEREST_INVOICE_LINE_ID
  3. ORG_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
JG_ZZ_INT_INV_LINES_ALL.INTEREST_INVOICE_ID
JG_ZZ_INT_INV_LINES_ALL.ORG_ID 		JG_ZZ_INTEREST_INVOICES_ALL
Comments
Indexes
Index Type Tablespace Column
JG_ZZ_INT_INV_LINES_U1 UNIQUE APPS_TS_TX_IDX INTEREST_INVOICE_ID
INTEREST_INVOICE_LINE_ID
ORG_ID
JG_ZZ_INT_INV_LINES_N1 NONUNIQUE APPS_TS_TX_IDX PAYMENT_SCHEDULE_ID
Columns
Name Datatype Length Mandatory Comments
INTEREST_INVOICE_LINE_ID NUMBER (15) Y
INTEREST_INVOICE_ID NUMBER (15) Y
PAYMENT_SCHEDULE_ID NUMBER (15)
TYPE VARCHAR2 (30) Y
DAILY_INTEREST_CHARGE NUMBER

OUTSTANDING_AMOUNT NUMBER

DAYS_OVERDUE_LATE NUMBER

DAYS_OF_INTEREST NUMBER

INTEREST_CHARGED NUMBER

PAYMENT_DATE DATE

RECEIVABLE_APPLICATION_ID NUMBER

LAST_UPDATED_BY NUMBER (15) Y
LAST_UPDATE_DATE DATE
Y
LAST_UPDATE_LOGIN NUMBER (15)
CREATED_BY NUMBER (15)
CREATION_DATE DATE

ORG_ID NUMBER (15)
INTEREST_RATE NUMBER

[top of page]

AR.JG_ZZ_INT_INV_LINES_ALL does not reference any database object

AR.JG_ZZ_INT_INV_LINES_ALL is referenced by following:

APPS
SYNONYM - JG_ZZ_INT_INV_LINES_ALL

[top of page]

Table: JG_ZZ_INVOICE_INFO

Description: Additional country-specific payment information for invoices
Primary Key: JG_ZZ_INVOICE_INFO_PK
  1. INVOICE_ID
Comments
Indexes
Index Type Tablespace Column
JG_ZZ_INVOICE_INFO_U1 UNIQUE APPS_TS_TX_IDX INVOICE_ID
Columns
Name Datatype Length Mandatory Comments
INVOICE_ID NUMBER
Y
JGZZ_ATTRIBUTE_CATEGORY VARCHAR2 (35) Y
JGZZ_INVOICE_INFO1 VARCHAR2 (150)
JGZZ_INVOICE_INFO2 VARCHAR2 (150)
JGZZ_INVOICE_INFO3 VARCHAR2 (150)
JGZZ_INVOICE_INFO4 VARCHAR2 (150)
JGZZ_INVOICE_INFO5 VARCHAR2 (150)
JGZZ_INVOICE_INFO6 VARCHAR2 (150)
JGZZ_INVOICE_INFO7 VARCHAR2 (150)
JGZZ_INVOICE_INFO8 VARCHAR2 (150)
JGZZ_INVOICE_INFO9 VARCHAR2 (150)
JGZZ_INVOICE_INFO10 VARCHAR2 (150)
JGZZ_INVOICE_INFO11 VARCHAR2 (150)
JGZZ_INVOICE_INFO12 VARCHAR2 (150)
JGZZ_INVOICE_INFO13 VARCHAR2 (150)
JGZZ_INVOICE_INFO14 VARCHAR2 (150)
JGZZ_INVOICE_INFO15 VARCHAR2 (150)
JGZZ_INVOICE_INFO16 VARCHAR2 (150)
JGZZ_INVOICE_INFO17 VARCHAR2 (150)
JGZZ_INVOICE_INFO18 VARCHAR2 (150)
JGZZ_INVOICE_INFO19 VARCHAR2 (150)
JGZZ_INVOICE_INFO20 VARCHAR2 (150)
JGZZ_INVOICE_INFO21 VARCHAR2 (150)
JGZZ_INVOICE_INFO22 VARCHAR2 (150)
JGZZ_INVOICE_INFO23 VARCHAR2 (150)
JGZZ_INVOICE_INFO24 VARCHAR2 (150)
JGZZ_INVOICE_INFO25 VARCHAR2 (150)
JGZZ_INVOICE_INFO26 VARCHAR2 (150)
JGZZ_INVOICE_INFO27 VARCHAR2 (150)
JGZZ_INVOICE_INFO28 VARCHAR2 (150)
JGZZ_INVOICE_INFO29 VARCHAR2 (150)
JGZZ_INVOICE_INFO30 VARCHAR2 (150)
LAST_UPDATED_BY NUMBER (15) Y
LAST_UPDATE_DATE DATE
Y
LAST_UPDATE_LOGIN NUMBER (15)
CREATED_BY NUMBER (15)
CREATION_DATE DATE

[top of page]

AP.JG_ZZ_INVOICE_INFO does not reference any database object

AP.JG_ZZ_INVOICE_INFO is referenced by following:

APPS
SYNONYM - JG_ZZ_INVOICE_INFO

[top of page]

Table: JG_ZZ_JGZZCSLP_MESSAGES

Description: Holds status messages of Customer Account Balance Maintenance program
Comments
Columns
Name Datatype Length Mandatory Comments
DUMMY VARCHAR2 (80)

[top of page]

AR.JG_ZZ_JGZZCSLP_MESSAGES does not reference any database object

AR.JG_ZZ_JGZZCSLP_MESSAGES is referenced by following:

APPS
SYNONYM - JG_ZZ_JGZZCSLP_MESSAGES

[top of page]

Table: JG_ZZ_JGZZVSLP_MESSAGES

Description: Holds status messages of Vendor Account Balance Maintenance program
Comments
Columns
Name Datatype Length Mandatory Comments
DUMMY VARCHAR2 (80)

[top of page]

AP.JG_ZZ_JGZZVSLP_MESSAGES does not reference any database object

AP.JG_ZZ_JGZZVSLP_MESSAGES is referenced by following:

APPS
SYNONYM - JG_ZZ_JGZZVSLP_MESSAGES

[top of page]

Table: JG_ZZ_PAY_FORMAT_INFO

Description: Holds Country Specific Format Data
Primary Key: JG_ZZ_PAY_FORMAT_INFO_PK
  1. CHECK_FORMAT_ID
Comments
Indexes
Index Type Tablespace Column
JG_ZZ_PAY_FORMAT_INFO_U1 UNIQUE APPS_TS_TX_IDX CHECK_FORMAT_ID
Columns
Name Datatype Length Mandatory Comments
CHECK_FORMAT_ID NUMBER
Y
JGZZ_ATTRIBUTE_CATEGORY VARCHAR2 (35)
JGZZ_FORMAT_INFO1 VARCHAR2 (150)
JGZZ_FORMAT_INFO2 VARCHAR2 (150)
JGZZ_FORMAT_INFO3 VARCHAR2 (150)
JGZZ_FORMAT_INFO4 VARCHAR2 (150)
JGZZ_FORMAT_INFO5 VARCHAR2 (150)
JGZZ_FORMAT_INFO6 VARCHAR2 (150)
JGZZ_FORMAT_INFO7 VARCHAR2 (150)
JGZZ_FORMAT_INFO8 VARCHAR2 (150)
JGZZ_FORMAT_INFO9 VARCHAR2 (150)
JGZZ_FORMAT_INFO10 VARCHAR2 (150)
JGZZ_FORMAT_INFO11 VARCHAR2 (150)
JGZZ_FORMAT_INFO12 VARCHAR2 (150)
JGZZ_FORMAT_INFO13 VARCHAR2 (150)
JGZZ_FORMAT_INFO14 VARCHAR2 (150)
JGZZ_FORMAT_INFO15 VARCHAR2 (150)
JGZZ_FORMAT_INFO16 VARCHAR2 (150)
JGZZ_FORMAT_INFO17 VARCHAR2 (150)
JGZZ_FORMAT_INFO18 VARCHAR2 (150)
JGZZ_FORMAT_INFO19 VARCHAR2 (150)
JGZZ_FORMAT_INFO20 VARCHAR2 (150)
JGZZ_FORMAT_INFO21 VARCHAR2 (150)
JGZZ_FORMAT_INFO22 VARCHAR2 (150)
JGZZ_FORMAT_INFO23 VARCHAR2 (150)
JGZZ_FORMAT_INFO24 VARCHAR2 (150)
JGZZ_FORMAT_INFO25 VARCHAR2 (150)
JGZZ_FORMAT_INFO26 VARCHAR2 (150)
JGZZ_FORMAT_INFO27 VARCHAR2 (150)
JGZZ_FORMAT_INFO28 VARCHAR2 (150)
JGZZ_FORMAT_INFO29 VARCHAR2 (150)
JGZZ_FORMAT_INFO30 VARCHAR2 (150)
LAST_UPDATED_BY NUMBER (15) Y
LAST_UPDATE_DATE DATE
Y
LAST_UPDATE_LOGIN NUMBER (15)
CREATED_BY NUMBER (15)
CREATION_DATE DATE

[top of page]

AP.JG_ZZ_PAY_FORMAT_INFO does not reference any database object

AP.JG_ZZ_PAY_FORMAT_INFO is referenced by following:

APPS
SYNONYM - JG_ZZ_PAY_FORMAT_INFO

[top of page]

Table: JG_ZZ_PAY_SCHED_INFO

Description: Additional country-specific information for payment schedules
Primary Key: JG_ZZ_PAY_SCHED_INFO_PK
  1. INVOICE_ID
  2. PAYMENT_NUM
Comments
Indexes
Index Type Tablespace Column
JG_ZZ_PAY_SCHED_INFO_U1 UNIQUE APPS_TS_TX_IDX INVOICE_ID
PAYMENT_NUM
Columns
Name Datatype Length Mandatory Comments
INVOICE_ID NUMBER
Y
PAYMENT_NUM NUMBER
Y
JGZZ_ATTRIBUTE_CATEGORY VARCHAR2 (35)
JGZZ_PS_INFO1 VARCHAR2 (150)
JGZZ_PS_INFO2 VARCHAR2 (150)
JGZZ_PS_INFO3 VARCHAR2 (150)
JGZZ_PS_INFO4 VARCHAR2 (150)
JGZZ_PS_INFO5 VARCHAR2 (150)
JGZZ_PS_INFO6 VARCHAR2 (150)
JGZZ_PS_INFO7 VARCHAR2 (150)
JGZZ_PS_INFO8 VARCHAR2 (150)
JGZZ_PS_INFO9 VARCHAR2 (150)
JGZZ_PS_INFO10 VARCHAR2 (150)
JGZZ_PS_INFO11 VARCHAR2 (150)
JGZZ_PS_INFO12 VARCHAR2 (150)
JGZZ_PS_INFO13 VARCHAR2 (150)
JGZZ_PS_INFO14 VARCHAR2 (150)
JGZZ_PS_INFO15 VARCHAR2 (150)
JGZZ_PS_INFO16 VARCHAR2 (150)
JGZZ_PS_INFO17 VARCHAR2 (150)
JGZZ_PS_INFO18 VARCHAR2 (150)
JGZZ_PS_INFO19 VARCHAR2 (150)
JGZZ_PS_INFO20 VARCHAR2 (150)
JGZZ_PS_INFO21 VARCHAR2 (150)
JGZZ_PS_INFO22 VARCHAR2 (150)
JGZZ_PS_INFO23 VARCHAR2 (150)
JGZZ_PS_INFO24 VARCHAR2 (150)
JGZZ_PS_INFO25 VARCHAR2 (150)
JGZZ_PS_INFO26 VARCHAR2 (150)
JGZZ_PS_INFO27 VARCHAR2 (150)
JGZZ_PS_INFO28 VARCHAR2 (150)
JGZZ_PS_INFO29 VARCHAR2 (150)
JGZZ_PS_INFO30 VARCHAR2 (150)
LAST_UPDATED_BY NUMBER (15) Y
LAST_UPDATE_DATE DATE
Y
LAST_UPDATE_LOGIN NUMBER (15)
CREATED_BY NUMBER (15)
CREATION_DATE DATE

[top of page]

AP.JG_ZZ_PAY_SCHED_INFO does not reference any database object

AP.JG_ZZ_PAY_SCHED_INFO is referenced by following:

APPS
SYNONYM - JG_ZZ_PAY_SCHED_INFO

[top of page]

Table: JG_ZZ_SYS_FORMATS_ALL_B

Description: EFT Payments Table Data
Primary Key: JG_SYS_FORMATS_ALL_B_PK
  1. JGZZ_COUNTRY_CODE
  2. JGZZ_EFT_TYPE
Foreign Keys to this table:
Foreign Key Column Foreign Table
JG_ZZ_SYS_FORMATS_ALL_TL.JGZZ_COUNTRY_CODE
JG_ZZ_SYS_FORMATS_ALL_TL.JGZZ_EFT_TYPE 		JG_ZZ_SYS_FORMATS_ALL_B
Comments
Indexes
Index Type Tablespace Column
JG_ZZ_SYS_FORMATS_ALL_B_U1 UNIQUE APPS_TS_TX_IDX JGZZ_COUNTRY_CODE
JGZZ_EFT_TYPE
ORG_ID
Columns
Name Datatype Length Mandatory Comments
JGZZ_COUNTRY_CODE VARCHAR2 (15) Y
JGZZ_EFT_TYPE VARCHAR2 (30) Y
JGZZ_ATTRIBUTE_CATEGORY VARCHAR2 (35)
JGZZ_SYSTEM_INFO1 VARCHAR2 (150)
JGZZ_SYSTEM_INFO2 VARCHAR2 (150)
JGZZ_SYSTEM_INFO3 VARCHAR2 (150)
JGZZ_SYSTEM_INFO4 VARCHAR2 (150)
JGZZ_SYSTEM_INFO5 VARCHAR2 (150)
JGZZ_SYSTEM_INFO6 VARCHAR2 (150)
JGZZ_SYSTEM_INFO7 VARCHAR2 (150)
JGZZ_SYSTEM_INFO8 VARCHAR2 (150)
JGZZ_SYSTEM_INFO9 VARCHAR2 (150)
JGZZ_SYSTEM_INFO10 VARCHAR2 (150)
JGZZ_SYSTEM_INFO11 VARCHAR2 (150)
JGZZ_SYSTEM_INFO12 VARCHAR2 (150)
JGZZ_SYSTEM_INFO13 VARCHAR2 (150)
JGZZ_SYSTEM_INFO14 VARCHAR2 (150)
JGZZ_SYSTEM_INFO15 VARCHAR2 (150)
JGZZ_SYSTEM_INFO16 VARCHAR2 (150)
JGZZ_SYSTEM_INFO17 VARCHAR2 (150)
JGZZ_SYSTEM_INFO18 VARCHAR2 (150)
JGZZ_SYSTEM_INFO19 VARCHAR2 (150)
JGZZ_SYSTEM_INFO20 VARCHAR2 (150)
JGZZ_SYSTEM_INFO21 VARCHAR2 (150)
JGZZ_SYSTEM_INFO22 VARCHAR2 (150)
JGZZ_SYSTEM_INFO23 VARCHAR2 (150)
JGZZ_SYSTEM_INFO24 VARCHAR2 (150)
JGZZ_SYSTEM_INFO25 VARCHAR2 (150)
JGZZ_SYSTEM_INFO26 VARCHAR2 (150)
JGZZ_SYSTEM_INFO27 VARCHAR2 (150)
JGZZ_SYSTEM_INFO28 VARCHAR2 (150)
JGZZ_SYSTEM_INFO29 VARCHAR2 (150)
JGZZ_SYSTEM_INFO30 VARCHAR2 (150)
LAST_UPDATED_BY NUMBER (15) Y
LAST_UPDATE_DATE DATE
Y
LAST_UPDATE_LOGIN NUMBER (15)
CREATED_BY NUMBER (15) Y
CREATION_DATE DATE
Y
ORG_ID NUMBER (15)

[top of page]

AP.JG_ZZ_SYS_FORMATS_ALL_B does not reference any database object

AP.JG_ZZ_SYS_FORMATS_ALL_B is referenced by following:

APPS
SYNONYM - JG_ZZ_SYS_FORMATS_ALL_B

[top of page]

Table: JG_ZZ_SYS_FORMATS_ALL_TL

Description: Holds additional country specific information for EFT Payment Formats.
Primary Key: JG_SYS_FORMATS_ALL_TL_PK
  1. JGZZ_COUNTRY_CODE
  2. JGZZ_EFT_TYPE
  3. LANGUAGE
Foreign Keys from this table:
Foreign Key Column Foreign Table
JG_ZZ_SYS_FORMATS_ALL_TL.JGZZ_COUNTRY_CODE
JG_ZZ_SYS_FORMATS_ALL_TL.JGZZ_EFT_TYPE 		JG_ZZ_SYS_FORMATS_ALL_B
Comments
Indexes
Index Type Tablespace Column
JG_ZZ_SYS_FORMATS_ALL_TL_U1 UNIQUE APPS_TS_TX_IDX JGZZ_COUNTRY_CODE
JGZZ_EFT_TYPE
ORG_ID
LANGUAGE
Columns
Name Datatype Length Mandatory Comments
JGZZ_COUNTRY_CODE VARCHAR2 (15) Y
JGZZ_EFT_TYPE VARCHAR2 (30) Y
JGZZ_DESCRIPTION VARCHAR2 (100)
LANGUAGE VARCHAR2 (4) Y
SOURCE_LANG VARCHAR2 (4) Y
CREATION_DATE DATE
Y
CREATED_BY NUMBER (15) Y
LAST_UPDATE_DATE DATE
Y
LAST_UPDATED_BY NUMBER (15) Y
LAST_UPDATE_LOGIN NUMBER (15)
ORG_ID NUMBER (15)

[top of page]

AP.JG_ZZ_SYS_FORMATS_ALL_TL does not reference any database object

AP.JG_ZZ_SYS_FORMATS_ALL_TL is referenced by following:

APPS
SYNONYM - JG_ZZ_SYS_FORMATS_ALL_TL

[top of page]

Table: JG_ZZ_TA_ACCOUNT_RANGES

Description: Stores the journal allocation natural account ranges
Comments
Indexes
Index Type Tablespace Column
JG_ZZ_TA_ACCOUNT_RANGES_U1 UNIQUE APPS_TS_TX_IDX ACCOUNT_RANGE_ID
JG_ZZ_TA_ACCOUNT_RANGES_U2 UNIQUE APPS_TS_TX_IDX CC_RANGE_ID
ACCOUNT_RANGE_LOW
ACCOUNT_RANGE_HIGH
Columns
Name Datatype Length Mandatory Comments
ACCOUNT_RANGE_ID NUMBER
Y
CC_RANGE_ID NUMBER
Y
ACCOUNT_RANGE_LOW VARCHAR2 (25) Y
ACCOUNT_RANGE_HIGH VARCHAR2 (25) Y
CREATION_DATE DATE
Y
CREATED_BY NUMBER (15) Y
LAST_UPDATED_BY NUMBER (15) Y
LAST_UPDATE_DATE DATE
Y
OFFSET_ACCOUNT VARCHAR2 (25)
LAST_UPDATE_LOGIN NUMBER (15)
CONTEXT VARCHAR2 (150)
ATTRIBUTE1 VARCHAR2 (150)
ATTRIBUTE2 VARCHAR2 (150)
ATTRIBUTE3 VARCHAR2 (150)
ATTRIBUTE4 VARCHAR2 (150)
ATTRIBUTE5 VARCHAR2 (150)
ATTRIBUTE6 VARCHAR2 (150)
ATTRIBUTE7 VARCHAR2 (150)
ATTRIBUTE8 VARCHAR2 (150)
ATTRIBUTE9 VARCHAR2 (150)
ATTRIBUTE10 VARCHAR2 (150)
ATTRIBUTE11 VARCHAR2 (150)
ATTRIBUTE12 VARCHAR2 (150)
ATTRIBUTE13 VARCHAR2 (150)
ATTRIBUTE14 VARCHAR2 (150)
ATTRIBUTE15 VARCHAR2 (150)

[top of page]

GL.JG_ZZ_TA_ACCOUNT_RANGES does not reference any database object

GL.JG_ZZ_TA_ACCOUNT_RANGES is referenced by following:

APPS
SYNONYM - JG_ZZ_TA_ACCOUNT_RANGES

[top of page]

Table: JG_ZZ_TA_ALLOCATED_LINES

Description: Stores the information on the original journal line used to allocate new journal line
Comments
Indexes
Index Type Tablespace Column
JG_ZZ_TA_ALLOCATED_LINES_U1 UNIQUE APPS_TS_TX_IDX JE_HEADER_ID
JE_LINE_NUM
JG_ZZ_TA_ALLOCATED_LINES_N1 NONUNIQUE APPS_TS_TX_IDX REQUEST_ID
Columns
Name Datatype Length Mandatory Comments
JE_BATCH_ID NUMBER (15) Y
REQUEST_ID NUMBER (15)
JE_HEADER_ID NUMBER (15) Y
JE_LINE_NUM NUMBER (15) Y
CREATION_DATE DATE
Y
CREATED_BY NUMBER (15) Y
LAST_UPDATED_BY NUMBER (15) Y
LAST_UPDATE_DATE DATE
Y
LAST_UPDATE_LOGIN NUMBER (15)
PROGRAM_APPLICATION_ID NUMBER (15)
PROGRAM_ID NUMBER (15)
PROGRAM_UPDATE_DATE DATE

[top of page]

GL.JG_ZZ_TA_ALLOCATED_LINES does not reference any database object

GL.JG_ZZ_TA_ALLOCATED_LINES is referenced by following:

APPS
SYNONYM - JG_ZZ_TA_ALLOCATED_LINES

[top of page]

Table: JG_ZZ_TA_CC_RANGES

Description: Holds Cost Center Range for Rules.
Comments
Indexes
Index Type Tablespace Column
JG_ZZ_TA_CC_RANGES_U1 UNIQUE APPS_TS_TX_IDX CC_RANGE_ID
Columns
Name Datatype Length Mandatory Comments
CC_RANGE_ID NUMBER
Y
RULE_SET_ID NUMBER
Y
CC_RANGE_LOW VARCHAR2 (25) Y
CC_RANGE_HIGH VARCHAR2 (25) Y
CREATION_DATE DATE
Y
CREATED_BY NUMBER (15) Y
LAST_UPDATED_BY NUMBER (15) Y
LAST_UPDATE_DATE DATE
Y
DESCRIPTION VARCHAR2 (25)
LAST_UPDATE_LOGIN NUMBER (15)
CONTEXT VARCHAR2 (150)
ATTRIBUTE1 VARCHAR2 (150)
ATTRIBUTE2 VARCHAR2 (150)
ATTRIBUTE3 VARCHAR2 (150)
ATTRIBUTE4 VARCHAR2 (150)
ATTRIBUTE5 VARCHAR2 (150)
ATTRIBUTE6 VARCHAR2 (150)
ATTRIBUTE7 VARCHAR2 (150)
ATTRIBUTE8 VARCHAR2 (150)
ATTRIBUTE9 VARCHAR2 (150)
ATTRIBUTE10 VARCHAR2 (150)
ATTRIBUTE11 VARCHAR2 (150)
ATTRIBUTE12 VARCHAR2 (150)
ATTRIBUTE13 VARCHAR2 (150)
ATTRIBUTE14 VARCHAR2 (150)
ATTRIBUTE15 VARCHAR2 (150)

[top of page]

GL.JG_ZZ_TA_CC_RANGES does not reference any database object

GL.JG_ZZ_TA_CC_RANGES is referenced by following:

APPS
SYNONYM - JG_ZZ_TA_CC_RANGES

[top of page]

Table: JG_ZZ_TA_RULE_LINES

Description: Stores the Journal Allocation Lines
Comments
Indexes
Index Type Tablespace Column
JG_ZZ_TA_RULE_LINES_U1 UNIQUE APPS_TS_TX_IDX RULE_LINE_ID
Columns
Name Datatype Length Mandatory Comments
ACCOUNT_RANGE_ID NUMBER
Y
RULE_LINE_ID NUMBER
Y
NATURAL_ACCOUNT VARCHAR2 (25) Y
ALLOCATION_PERCENT NUMBER
Y
CREATION_DATE DATE
Y
CREATED_BY NUMBER (15) Y
LAST_UPDATED_BY NUMBER (15) Y
LAST_UPDATE_DATE DATE
Y
OFFSET_ACCOUNT VARCHAR2 (25)
LAST_UPDATE_LOGIN NUMBER (15)
CONTEXT VARCHAR2 (150)
ATTRIBUTE1 VARCHAR2 (150)
ATTRIBUTE2 VARCHAR2 (150)
ATTRIBUTE3 VARCHAR2 (150)
ATTRIBUTE4 VARCHAR2 (150)
ATTRIBUTE5 VARCHAR2 (150)
ATTRIBUTE6 VARCHAR2 (150)
ATTRIBUTE7 VARCHAR2 (150)
ATTRIBUTE8 VARCHAR2 (150)
ATTRIBUTE9 VARCHAR2 (150)
ATTRIBUTE10 VARCHAR2 (150)
ATTRIBUTE11 VARCHAR2 (150)
ATTRIBUTE12 VARCHAR2 (150)
ATTRIBUTE13 VARCHAR2 (150)
ATTRIBUTE14 VARCHAR2 (150)
ATTRIBUTE15 VARCHAR2 (150)

[top of page]

GL.JG_ZZ_TA_RULE_LINES does not reference any database object

GL.JG_ZZ_TA_RULE_LINES is referenced by following:

APPS
SYNONYM - JG_ZZ_TA_RULE_LINES

[top of page]

Table: JG_ZZ_TA_RULE_SETS

Description: Stores the header information for each Journal Allocation Rule Set.
Comments
Indexes
Index Type Tablespace Column
JG_ZZ_TA_RULE_SETS_U1 UNIQUE APPS_TS_TX_IDX RULE_SET_ID
JG_ZZ_TA_RULE_SETS_U2 UNIQUE APPS_TS_TX_IDX CHART_OF_ACCOUNTS_ID
NAME
Columns
Name Datatype Length Mandatory Comments
RULE_SET_ID NUMBER
Y
CHART_OF_ACCOUNTS_ID NUMBER (15) Y
PARTIAL_ALLOCATION VARCHAR2 (1) Y
NAME VARCHAR2 (100) Y
ENABLED_FLAG VARCHAR2 (1) Y
CREATION_DATE DATE
Y
CREATED_BY NUMBER (15) Y
LAST_UPDATED_BY NUMBER (15) Y
LAST_UPDATE_DATE DATE
Y
ACCOUNT_TYPE VARCHAR2 (1)
LAST_UPDATE_LOGIN NUMBER (15)
CONTEXT VARCHAR2 (150)
ATTRIBUTE1 VARCHAR2 (150)
ATTRIBUTE2 VARCHAR2 (150)
ATTRIBUTE3 VARCHAR2 (150)
ATTRIBUTE4 VARCHAR2 (150)
ATTRIBUTE5 VARCHAR2 (150)
ATTRIBUTE6 VARCHAR2 (150)
ATTRIBUTE7 VARCHAR2 (150)
ATTRIBUTE8 VARCHAR2 (150)
ATTRIBUTE9 VARCHAR2 (150)
ATTRIBUTE10 VARCHAR2 (150)
ATTRIBUTE11 VARCHAR2 (150)
ATTRIBUTE12 VARCHAR2 (150)
ATTRIBUTE13 VARCHAR2 (150)
ATTRIBUTE14 VARCHAR2 (150)
ATTRIBUTE15 VARCHAR2 (150)

[top of page]

GL.JG_ZZ_TA_RULE_SETS does not reference any database object

GL.JG_ZZ_TA_RULE_SETS is referenced by following:

APPS
SYNONYM - JG_ZZ_TA_RULE_SETS

[top of page]

Table: JG_ZZ_TMP_RPT_HEADERS

Description: Statutory Report Header
Comments

Statutory Report Header

Columns
Name Datatype Length Mandatory Comments
REQUEST_ID NUMBER (15)
Request Identifier
NUM_OF_PAGE NUMBER

Number of Pages

[top of page]

JG.JG_ZZ_TMP_RPT_HEADERS does not reference any database object

JG.JG_ZZ_TMP_RPT_HEADERS is referenced by following:

APPS
SYNONYM - JG_ZZ_TMP_RPT_HEADERS

[top of page]

Table: JG_ZZ_VAT_ALLOC_RULES

Description: Captures rules for allocating VAT boxes to transaction during allocation process
Primary Key: JG_ZZ_VAT_ALLOC_RULES_PK
  1. ALLOCATION_RULE_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
JG_ZZ_VAT_ALLOC_RULES.VAT_REPORTING_ENTITY_ID JG_ZZ_VAT_REP_ENTITIES
Foreign Keys to this table:
Foreign Key Column Foreign Table
JG_ZZ_VAT_BOX_ALLOCS.ALLOCATION_RULE_ID JG_ZZ_VAT_ALLOC_RULES
Comments

For each source, financial and VAT transaction type captures allocation
rules. These rules are used by allocation process to allocate VAT box
to each transaction lines for reporting purpose. Each line contains
VAT box for lines of type TAX and TAXABLE.

Indexes
Index Type Tablespace Column
JG_ZZ_VAT_ALLOC_RULES_U1 UNIQUE APPS_TS_TX_IDX ALLOCATION_RULE_ID
JG_ZZ_VAT_ALLOC_RULES_U2 UNIQUE APPS_TS_TX_IDX VAT_REPORTING_ENTITY_ID
SOURCE
FINANCIAL_DOCUMENT_TYPE
VAT_TRANSACTION_TYPE
TAX_CODE
TAX_STATUS
TAX_JURISDICTION_CODE
TAX_RATE_CODE
PERIOD_TYPE
EFFECTIVE_FROM_DATE
TAX_BOX_RECOVERABLE
TAX_BOX_NON_RECOVERABLE
TAXABLE_BOX_RECOVERABLE
TAXABLE_BOX_NON_RECOVERABLE
TAX_RATE_ID
Columns
Name Datatype Length Mandatory Comments
ALLOCATION_RULE_ID NUMBER (15) Y Allocation Rules Identifier
VAT_REPORTING_ENTITY_ID NUMBER (15) Y Reporting entity Identifier for the rule
SOURCE VARCHAR2 (30)
Transaction source. Possible values are AP, AR and GL.
FINANCIAL_DOCUMENT_TYPE VARCHAR2 (20)
Financial transaction type
VAT_TRANSACTION_TYPE VARCHAR2 (30)
VAT transaction type
TAX_ID NUMBER (15)
Tax Identifier
TAX_CODE VARCHAR2 (50)
Tax code
TAX_STATUS VARCHAR2 (30)
Tax Status
TAX_JURISDICTION_CODE VARCHAR2 (30)
Tax Jurisdiction
TAX_RATE_CODE VARCHAR2 (50)
Tax rate code
TAX_RATE_ID NUMBER (15)
Tax rate Identifier
TAX_BOX_RECOVERABLE VARCHAR2 (15)
Indicates recoverable VAT box number for tax lines.
TAX_BOX_NON_RECOVERABLE VARCHAR2 (15)
Indicates nonrecoverable VAT box number for tax lines.
TAXABLE_BOX_RECOVERABLE VARCHAR2 (15)
Indicates recoverable VAT box number for taxable lines.
TAXABLE_BOX_NON_RECOVERABLE VARCHAR2 (15)
Indicates nonrecoverable VAT box number for taxable lines
TOTAL_BOX VARCHAR2 (15)
Total VAT box number
EFFECTIVE_FROM_DATE DATE

Indicates date from which rule is effective.
EFFECTIVE_TO_DATE DATE

Indicates till what date rule is effective. NULL value means effective for ever
PERIOD_TYPE VARCHAR2 (15)
Period type
CREATED_BY NUMBER (15) Y Standard Who column
CREATION_DATE DATE
Y Standard Who column
LAST_UPDATED_BY NUMBER (15) Y Standard Who column
LAST_UPDATE_DATE DATE
Y Standard Who column
LAST_UPDATE_LOGIN NUMBER (15)
Standard Who column
TAX_REC_SIGN_FLAG VARCHAR2 (1)
Sign flag for recoverable tax amount
TAX_NON_REC_SIGN_FLAG VARCHAR2 (1)
Sign flag for nonrecoverable tax amount
TAXABLE_REC_SIGN_FLAG VARCHAR2 (1)
Sign flag for recoverable taxable amount
TAXABLE_NON_REC_SIGN_FLAG VARCHAR2 (1)
Sign flag for nonrecoverable taxable amount

[top of page]

JG.JG_ZZ_VAT_ALLOC_RULES does not reference any database object

JG.JG_ZZ_VAT_ALLOC_RULES is referenced by following:

APPS
SYNONYM - JG_ZZ_VAT_ALLOC_RULES

[top of page]

Table: JG_ZZ_VAT_BOX_ALLOCS

Description: Stores VAT box allocation information for tax and taxable amounts by period type
Primary Key: JG_ZZ_VAT_BOX_ALLOCS_PK
  1. VAT_BOX_ALLOCATION_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
JG_ZZ_VAT_BOX_ALLOCS.REQUEST_ID FND_CONCURRENT_REQUESTS
JG_ZZ_VAT_BOX_ALLOCS.VAT_TRANSACTION_ID JG_ZZ_VAT_TRX_DETAILS
JG_ZZ_VAT_BOX_ALLOCS.ALLOCATION_RULE_ID JG_ZZ_VAT_ALLOC_RULES
JG_ZZ_VAT_BOX_ALLOCS.VAT_TRANSACTION_ID JG_ZZ_VAT_TRX_DETAILS
Comments

Stores VAT box allocation information for tax and taxable amounts by period type. This information gets populated upon running the VAT box allocation concurrent program and this concurrent processing will be enabled only if allocations are enabled in reporting entities window

Indexes
Index Type Tablespace Column
JG_ZZ_VAT_BOX_ALLOCS_U1 UNIQUE APPS_TS_TX_IDX VAT_BOX_ALLOCATION_ID
JG_ZZ_VAT_BOX_ALLOCS_U2 UNIQUE APPS_TS_TX_IDX VAT_TRANSACTION_ID
ALLOCATION_RULE_ID
Columns
Name Datatype Length Mandatory Comments
VAT_BOX_ALLOCATION_ID NUMBER (15) Y Record identifier in the table.
VAT_TRANSACTION_ID NUMBER (15) Y Identifier to VAT Tax Transaction.
ALLOCATION_RULE_ID NUMBER (15)
Identifier to VAT box allocation rule.
PERIOD_TYPE VARCHAR2 (15)
Indicates the period type of the allocation
TAX_RECOVERABLE_FLAG VARCHAR2 (1)
Indicates the recoverability of the tax
TAX_BOX VARCHAR2 (30)
Indicates the tax box allocated to transaction
TAXABLE_BOX VARCHAR2 (30)
Indicates the taxable box allocated to the transaction
REQUEST_ID NUMBER (15)
Enhanced Who column
PROGRAM_APPLICATION_ID NUMBER (15)
Enhanced Who column
PROGRAM_ID NUMBER (15)
Enhanced Who column
PROGRAM_UPDATE_DATE DATE

Enhanced Who column
PROGRAM_LOGIN_ID NUMBER (15)
Enhanced Who column
CREATION_DATE DATE
Y Standard Who column
CREATED_BY NUMBER (15) Y Standard Who column
LAST_UPDATE_DATE DATE
Y Standard Who column
LAST_UPDATED_BY NUMBER (15) Y Standard Who column
LAST_UPDATE_LOGIN NUMBER (15)
Standard Who column

[top of page]

JG.JG_ZZ_VAT_BOX_ALLOCS does not reference any database object

JG.JG_ZZ_VAT_BOX_ALLOCS is referenced by following:

APPS
SYNONYM - JG_ZZ_VAT_BOX_ALLOCS

[top of page]

Table: JG_ZZ_VAT_BOX_ERRORS

Description: Stores the errors that are generated during VAT box allocation processing
Primary Key: JG_ZZ_VAT_BOX_ERRORS_PK
  1. VAT_TRANSACTION_ID
  2. PERIOD_TYPE
  3. ALLOCATION_ERROR_CODE
Comments

Stores the errors that are generated during VAT box allocation processing. These errors will be flushed out when allocation processing is run again and error no more exists. This is a temporary table that stores the allocation errors

Indexes
Index Type Tablespace Column
JG_ZZ_VAT_BOX_ERRORS_U1 UNIQUE APPS_TS_TX_IDX VAT_TRANSACTION_ID
PERIOD_TYPE
ALLOCATION_ERROR_CODE
Columns
Name Datatype Length Mandatory Comments
VAT_TRANSACTION_ID NUMBER (15) Y Indicates the VAT tax transaction.
ALLOCATION_ERROR_CODE VARCHAR2 (30) Y Error identifier of the transaction when allocation failed
PERIOD_TYPE VARCHAR2 (15) Y Indicates the period type of the allocation
CREATION_DATE DATE
Y Standard Who column
CREATED_BY NUMBER (15) Y Standard Who column
LAST_UPDATE_DATE DATE
Y Standard Who column
LAST_UPDATED_BY NUMBER (15) Y Standard Who column
LAST_UPDATE_LOGIN NUMBER (15)
Standard Who column

[top of page]

JG.JG_ZZ_VAT_BOX_ERRORS does not reference any database object

JG.JG_ZZ_VAT_BOX_ERRORS is referenced by following:

APPS
SYNONYM - JG_ZZ_VAT_BOX_ERRORS

[top of page]

Table: JG_ZZ_VAT_DOC_SEQUENCES

Description: Captures document sequences associated with VAT register for reporting purpose
Primary Key: JG_ZZ_VAT_DOC_SEQUENCES_PK
  1. VAT_DOC_SEQUENCE_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
JG_ZZ_VAT_DOC_SEQUENCES.VAT_REGISTER_ID JG_ZZ_VAT_REGISTERS_B
JG_ZZ_VAT_DOC_SEQUENCES.DOC_SEQUENCE_ID FND_DOCUMENT_SEQUENCES
Comments

Each record in this table stores the FND document sequence associated with VAT register. For reporting purpose document category is derived based on FND document sequence association with document categories.

Indexes
Index Type Tablespace Column
JG_ZZ_VAT_DOC_SEQUENCES_U1 UNIQUE APPS_TS_TX_IDX VAT_DOC_SEQUENCE_ID
JG_ZZ_VAT_DOC_SEQUENCES_U2 UNIQUE APPS_TS_TX_IDX VAT_REGISTER_ID
DOC_SEQUENCE_ID
Columns
Name Datatype Length Mandatory Comments
VAT_REGISTER_ID NUMBER (15) Y VAT Register Identifier
DOC_SEQUENCE_ID NUMBER (15) Y Document Sequence Identifier. Foreign key to FND_DOCUMENT_SEQUENCES
CREATED_BY NUMBER (15) Y Standard Who column
CREATION_DATE DATE
Y Standard Who column
LAST_UPDATED_BY NUMBER (15) Y Standard Who column
LAST_UPDATE_DATE DATE
Y Standard Who column
VAT_DOC_SEQUENCE_ID NUMBER (15) Y VAT Document Sequence Identifier
LAST_UPDATE_LOGIN NUMBER (15)
Standard Who column

[top of page]

JG.JG_ZZ_VAT_DOC_SEQUENCES does not reference any database object

JG.JG_ZZ_VAT_DOC_SEQUENCES is referenced by following:

APPS
SYNONYM - JG_ZZ_VAT_DOC_SEQUENCES

[top of page]

Table: JG_ZZ_VAT_FINAL_REPORTS

Description: Stores details of final print generation of reports, by entity and period
Primary Key: JG_ZZ_VAT_FINAL_REPORTS_PK
  1. FINAL_REPORT_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
JG_ZZ_VAT_FINAL_REPORTS.REPORTING_STATUS_ID JG_ZZ_VAT_REP_STATUS
Comments

This table captures data internally, by VAT reporting entity and period, when final print is processed for each report. Final print of a report is the first-time generation of the report after final processing has completed successfully for the given entity and period.

Indexes
Index Type Tablespace Column
JG_ZZ_VAT_FINAL_REPORTS_U1 UNIQUE APPS_TS_TX_IDX FINAL_REPORT_ID
JG_ZZ_VAT_FINAL_REPORTS_U2 UNIQUE APPS_TS_TX_IDX REPORTING_STATUS_ID
REPORT_NAME
VAT_REGISTER_ID
Columns
Name Datatype Length Mandatory Comments
FINAL_REPORT_ID NUMBER (15) Y Final report identifier
REPORTING_STATUS_ID NUMBER (15) Y Reporting status identifier
REPORT_NAME VARCHAR2 (30) Y Report identifier
REQUEST_ID NUMBER (15)
Enhanced Who column
PROGRAM_ID NUMBER (15)
Enhanced Who column
PROGRAM_APPLICATION_ID NUMBER (15)
Enhanced Who column
PROGRAM_LOGIN_ID NUMBER (15)
Enhanced Who column
CREATED_BY NUMBER (15) Y Standard Who column
CREATION_DATE DATE
Y Standard Who column
LAST_UPDATE_DATE DATE
Y Standard Who column
LAST_UPDATED_BY NUMBER (15) Y Standard Who column
LAST_UPDATE_LOGIN NUMBER (15)
Standard Who column
OBJECT_VERSION_NUMBER NUMBER (15) Y Object Version Number
VAT_REGISTER_ID NUMBER (15)
VAT register identifier
START_SEQUENCE_NUM NUMBER (15)
Starting sequence number
LAST_START_SEQUENCE_NUM NUMBER (15)
Starting sequence number used during Reprint mode

[top of page]

JG.JG_ZZ_VAT_FINAL_REPORTS does not reference any database object

JG.JG_ZZ_VAT_FINAL_REPORTS is referenced by following:

APPS
SYNONYM - JG_ZZ_VAT_FINAL_REPORTS

[top of page]

Table: JG_ZZ_VAT_REGISTERS_B

Description: Base table for storing VAT Registers association with reporting entity
Primary Key: JG_ZZ_VAT_REGISTERS_B_PK
  1. VAT_REGISTER_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
JG_ZZ_VAT_REGISTERS_B.VAT_REPORTING_ENTITY_ID JG_ZZ_VAT_REP_ENTITIES
Foreign Keys to this table:
Foreign Key Column Foreign Table
JG_ZZ_VAT_DOC_SEQUENCES.VAT_REGISTER_ID JG_ZZ_VAT_REGISTERS_B
JG_ZZ_VAT_REGISTERS_TL.VAT_REGISTER_ID JG_ZZ_VAT_REGISTERS_B
Comments

Base table that captures VAT Registers association with reporting entity configuration. For each reporting entity configuration there can be more that one VAT Registers definition.

Indexes
Index Type Tablespace Column
JG_ZZ_VAT_REGISTERS_B_U1 UNIQUE APPS_TS_TX_IDX VAT_REGISTER_ID
Columns
Name Datatype Length Mandatory Comments
VAT_REGISTER_ID NUMBER (15) Y VAT Register Identifier.
VAT_REPORTING_ENTITY_ID NUMBER (15) Y VAT Reporting Entity Configuration Identifier
REGISTER_TYPE VARCHAR2 (30)
Register Type
EFFECTIVE_FROM_DATE DATE

Indicates date from which VAT register is effective
EFFECTIVE_TO_DATE DATE

Indicates till which date register is effective.
CREATED_BY NUMBER (15) Y Standard Who column
CREATION_DATE DATE
Y Standard Who column
LAST_UPDATED_BY NUMBER (15) Y Standard Who column
LAST_UPDATE_DATE DATE
Y Standard Who column
LAST_UPDATE_LOGIN NUMBER (15)
Standard Who column

[top of page]

JG.JG_ZZ_VAT_REGISTERS_B does not reference any database object

JG.JG_ZZ_VAT_REGISTERS_B is referenced by following:

APPS
SYNONYM - JG_ZZ_VAT_REGISTERS_B

[top of page]

Table: JG_ZZ_VAT_REGISTERS_TL

Description: Captures translatable columns for table JG_ZZ_VAT_REGISTERS_B
Primary Key: JG_ZZ_VAT_REGISTERS_TL_PK
  1. LANGUAGE
  2. VAT_REGISTER_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
JG_ZZ_VAT_REGISTERS_TL.VAT_REGISTER_ID JG_ZZ_VAT_REGISTERS_B
Comments

Captures translatable columns for table JG_ZZ_VAT_REGISTERS_B

Indexes
Index Type Tablespace Column
JG_ZZ_VAT_REGISTERS_TL_U1 UNIQUE APPS_TS_TX_IDX VAT_REGISTER_ID
LANGUAGE
Columns
Name Datatype Length Mandatory Comments
VAT_REGISTER_ID NUMBER (15) Y VAT Register Identifier
REGISTER_NAME VARCHAR2 (50) Y Name for VAT Register
LANGUAGE VARCHAR2 (4) Y Language Code
SOURCE_LANG VARCHAR2 (4) Y Source Language Code
CREATED_BY NUMBER (15) Y Standard Who column
CREATION_DATE DATE
Y Standard Who column
LAST_UPDATED_BY NUMBER (15) Y Standard Who column
LAST_UPDATE_DATE DATE
Y Standard Who column
LAST_UPDATE_LOGIN NUMBER (15)
Standard Who column

[top of page]

JG.JG_ZZ_VAT_REGISTERS_TL does not reference any database object

JG.JG_ZZ_VAT_REGISTERS_TL is referenced by following:

APPS
SYNONYM - JG_ZZ_VAT_REGISTERS_TL

[top of page]

Table: JG_ZZ_VAT_REP_ENTITIES

Description: Captures configuration information for legal entities for VAT reporting.
Primary Key: JG_ZZ_VAT_REP_ENTITIES_PK
  1. VAT_REPORTING_ENTITY_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
JG_ZZ_VAT_REP_ENTITIES.PARTY_ID HZ_PARTIES
JG_ZZ_VAT_REP_ENTITIES.LEDGER_ID GL_LEDGERS
Foreign Keys to this table:
Foreign Key Column Foreign Table
JG_ZZ_VAT_ALLOC_RULES.VAT_REPORTING_ENTITY_ID JG_ZZ_VAT_REP_ENTITIES
JG_ZZ_VAT_REGISTERS_B.VAT_REPORTING_ENTITY_ID JG_ZZ_VAT_REP_ENTITIES
JG_ZZ_VAT_REP_STATUS.VAT_REPORTING_ENTITY_ID JG_ZZ_VAT_REP_ENTITIES
JG_ZZ_VAT_REP_STATUS.VAT_REPORTING_ENTITY_ID JG_ZZ_VAT_REP_ENTITIES
Comments

This is a key table which stores VAT reporting entities configuration setup. A combination of legal entity, tax regime and tax registration number uniquely identifies record in this table. Configuration information also includes details regarding tax colander, threshold amount for reporting and flags to indicate reporting method used like Allocation Rules or VAT Registers

Indexes
Index Type Tablespace Column
JG_ZZ_VAT_REP_ENTITIES_U1 UNIQUE APPS_TS_TX_IDX VAT_REPORTING_ENTITY_ID
Columns
Name Datatype Length Mandatory Comments
VAT_REPORTING_ENTITY_ID NUMBER (15) Y VAT Reporting Entity configuration Identifier
LEGAL_ENTITY_ID NUMBER (15)
Legal Entity Identifier
PARTY_ID NUMBER (15)
Party Identifier
TAX_REGIME_CODE VARCHAR2 (30)
Tax Regime Code
TAX_REGISTRATION_NUMBER VARCHAR2 (50)
First Party Tax Registration Number. Also know as TRN
TAX_CALENDAR_NAME VARCHAR2 (15)
Accounting Calender used for Tax Reporting
ENABLE_REGISTERS_FLAG VARCHAR2 (1)
Possible values Y or N. Value Y indicates VAT Registers method is enabled
ENABLE_REPORT_SEQUENCE_FLAG VARCHAR2 (1)
Possible values Y or N. Value Y indicates report sequence is enabled
ENABLE_ALLOCATIONS_FLAG VARCHAR2 (1)
Possible values Y or N. Value Y indicates Allocation Rules method is enabled
ENABLE_ANNUAL_ALLOCATION_FLAG VARCHAR2 (1)
Possible values Y or N. Value Y indicates Annual Allocations are enabled
THRESHOLD_AMOUNT NUMBER

Indicates minimum transaction amount for VAT Reporting
CREATED_BY NUMBER (15) Y Standard Who column
CREATION_DATE DATE
Y Standard Who column
LAST_UPDATED_BY NUMBER (15) Y Standard Who column
LAST_UPDATE_DATE DATE
Y Standard Who column
LAST_UPDATE_LOGIN NUMBER (15)
Standard Who column
ENTITY_LEVEL_CODE VARCHAR2 (30) Y Reporting entity level. Possible values are:Legal Entity, Ledger, BSV.
ENTITY_TYPE_CODE VARCHAR2 (30) Y Reporting entity type. Possible values are:Legal, Accounting.
LEDGER_ID NUMBER (15)
Ledger Identifier
BALANCING_SEGMENT_VALUE VARCHAR2 (25)
Balancing segment value
MAPPING_VAT_REP_ENTITY_ID NUMBER (15)
Mapping VAT Reporting Entity Identifier
ENTITY_IDENTIFIER VARCHAR2 (600)
Reporting Entity Identifier
DRIVING_DATE_CODE VARCHAR2 (30)
This column will hold the value for driving date for the relevant calendar/TRN
LAST_REPORTED_PERIOD VARCHAR2 (15)
Last reported period in 11i

[top of page]

JG.JG_ZZ_VAT_REP_ENTITIES does not reference any database object

JG.JG_ZZ_VAT_REP_ENTITIES is referenced by following:

APPS
SYNONYM - JG_ZZ_VAT_REP_ENTITIES

[top of page]

Table: JG_ZZ_VAT_REP_STATUS

Description: Stores the reporting status of the Tax Registration Number by period and source.
Primary Key: JG_ZZ_VAT_REP_STATUS_PK
  1. REPORTING_STATUS_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
JG_ZZ_VAT_REP_STATUS.VAT_REPORTING_ENTITY_ID JG_ZZ_VAT_REP_ENTITIES
JG_ZZ_VAT_REP_STATUS.VAT_REPORTING_ENTITY_ID JG_ZZ_VAT_REP_ENTITIES
JG_ZZ_VAT_REP_STATUS.REQUEST_ID FND_CONCURRENT_REQUESTS
JG_ZZ_VAT_REP_STATUS.PROGRAM_LOGIN_ID FND_LOGINS
Foreign Keys to this table:
Foreign Key Column Foreign Table
JG_ZZ_VAT_FINAL_REPORTS.REPORTING_STATUS_ID JG_ZZ_VAT_REP_STATUS
JG_ZZ_VAT_TRX_DETAILS.REPORTING_STATUS_ID JG_ZZ_VAT_REP_STATUS
Comments

Stores the reporting status of the Tax Registration Number by period and source.

Indexes
Index Type Tablespace Column
JG_ZZ_VAT_REP_STATUS_U1 UNIQUE APPS_TS_TX_IDX REPORTING_STATUS_ID
JG_ZZ_VAT_REP_STATUS_U2 UNIQUE APPS_TS_TX_IDX VAT_REPORTING_ENTITY_ID
TAX_CALENDAR_PERIOD
SOURCE
Columns
Name Datatype Length Mandatory Comments
REPORTING_STATUS_ID NUMBER (15) Y Reporting status Identifier
VAT_REPORTING_ENTITY_ID NUMBER (15) Y Indentifier of VAT reporting entity
TAX_REGISTRATION_NUMBER VARCHAR2 (30) Y Indicates the VAT registration number of reporting entity
TAX_CALENDAR_NAME VARCHAR2 (15) Y Indicates the tax calendar
TAX_CALENDAR_YEAR NUMBER (15) Y Indicates the tax calendar year
TAX_CALENDAR_PERIOD VARCHAR2 (15) Y Indicates the tax calendar period
PERIOD_START_DATE DATE
Y Indicates the start date of period
PERIOD_END_DATE DATE
Y Indicates the end date of period
SOURCE VARCHAR2 (30) Y Indicates source of the transaction. Possible values AP, AR and GL
SELECTION_STATUS_FLAG VARCHAR2 (1)
Indicates the selection status.
ALLOCATION_STATUS_FLAG VARCHAR2 (1)
Indicates the allocation status.
FINAL_REPORTING_STATUS_FLAG VARCHAR2 (1)
Indicates the selection status.
ARCHIVAL_STATUS_FLAG VARCHAR2 (1)
Indicates the selection status.
SELECTION_PROCESS_ID NUMBER (15)
Identifier stamped by the selection process.
ALLOCATION_PROCESS_ID NUMBER (15)
Identifier stamped by allocation.
FINAL_REPORTING_PROCESS_ID NUMBER (15)
Identifier of the final reporting process.
ARCHIVAL_PROCESS_ID NUMBER (15)
Identifier of the archival process.
SELECTION_PROCESS_DATE DATE

Date on which selection process was run
ALLOCATION_PROCESS_DATE DATE

Date on which allocation process was run
FINAL_REPORTING_PROCESS_DATE DATE

Date on which final process was run
ARCHIVAL_PROCESS_DATE DATE

Date on which archival process was run
REQUEST_ID NUMBER (15)
Enhanced Who column
PROGRAM_ID NUMBER (15)
Enhanced Who column
PROGRAM_APPLICATION_ID NUMBER (15)
Enhanced Who column
PROGRAM_UPDATE_DATE DATE

Enhanced Who column
PROGRAM_LOGIN_ID NUMBER (15)
Enhanced Who column
CREATED_BY NUMBER (15) Y Standard Who column
CREATION_DATE DATE
Y Standard Who column
LAST_UPDATE_DATE DATE
Y Standard Who column
LAST_UPDATED_BY NUMBER (15) Y Standard Who column
LAST_UPDATE_LOGIN NUMBER (15)
Standard Who column
MAPPING_VAT_REP_ENTITY_ID NUMBER (15) Y Mapping VAT Reporting Entity Identifier
CREDIT_BALANCE_AMT NUMBER

Credit VAT balance amount used by Italian VATregisters.

[top of page]

JG.JG_ZZ_VAT_REP_STATUS does not reference any database object

JG.JG_ZZ_VAT_REP_STATUS is referenced by following:

APPS
SYNONYM - JG_ZZ_VAT_REP_STATUS

[top of page]

Table: JG_ZZ_VAT_TRX_DETAILS

Description: Contains AP, AR and GL Transactions selected for VAT reporting
Primary Key: JG_ZZ_VAT_TRX_DETAILS_PK
  1. VAT_TRANSACTION_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
JG_ZZ_VAT_TRX_DETAILS.REPORTING_STATUS_ID JG_ZZ_VAT_REP_STATUS
Foreign Keys to this table:
Foreign Key Column Foreign Table
JG_ZZ_VAT_BOX_ALLOCS.VAT_TRANSACTION_ID JG_ZZ_VAT_TRX_DETAILS
JG_ZZ_VAT_BOX_ALLOCS.VAT_TRANSACTION_ID JG_ZZ_VAT_TRX_DETAILS
Comments

JG_ZZ_VAT_TRX_DETAILS contains all transactions selected for VAT reporting. The transaction is inserted in the table once for each TRN, LE, Regime, Period, Source combination. The EMEA VAT processing features such as Allocation Rules, Final Reporting etc will update information in this table. It can be used as a source for audits on what information was reported to the Tax authorities at any point in time.

Indexes
Index Type Tablespace Column
JG_ZZ_VAT_TRX_DETAILS_U1 UNIQUE APPS_TS_TX_IDX VAT_TRANSACTION_ID
JG_ZZ_VAT_TRX_DETAILS_N1 NONUNIQUE APPS_TS_TX_IDX REPORTING_STATUS_ID
JG_ZZ_VAT_TRX_DETAILS_N2 NONUNIQUE APPS_TS_TX_IDX APPLICATION_ID
EVENT_CLASS_CODE
ENTITY_CODE
TRX_ID
Columns
Name Datatype Length Mandatory Comments
VAT_TRANSACTION_ID NUMBER (15) Y Primary Key - Sequence generated
REPORTING_STATUS_ID NUMBER (15) Y Reporting status identifier . Foreign Key for jg_zz_rep_status table.
SELECTION_PROCESS_ID NUMBER (15) Y Selection Process Identifier. Foreign Key for JG_ZZ_REP_STATUS table
FINAL_REPORTING_ID NUMBER (15)
Final Process Identifier. Foreign Key for JG_ZZ_REP_STATUS table
REP_ENTITY_ID NUMBER (15)
Legal Entity Identifier or Operating Unit identifier
REP_CONTEXT_ENTITY_NAME VARCHAR2 (240)
Legal Entity Name or Operating Unit Name
REP_CONTEXT_ENTITY_LOCATION_ID NUMBER (15)
Location identifier of the Legal Entity or Operating Unit
TAXPAYER_ID VARCHAR2 (30)
First Party TaxpayerID
ORG_INFORMATION2 VARCHAR2 (150)
Tax Registration Number of OU
LEGAL_AUTHORITY_NAME VARCHAR2 (360)
Legal Authority Name
LEGAL_AUTH_ADDRESS_LINE2 VARCHAR2 (240)
Legal Authority Address information
LEGAL_AUTH_ADDRESS_LINE3 VARCHAR2 (240)
Legal Authority Address information
LEGAL_AUTH_CITY VARCHAR2 (60)
Legal Authority Address information
LEGAL_CONTACT_PARTY_NAME VARCHAR2 (360)
Legal Contact Name
ACTIVITY_CODE VARCHAR2 (150)
Activity Code
LEDGER_ID NUMBER (15)
Ledger (Set of books) identifier
LEDGER_NAME VARCHAR2 (30)
Ledger Name
CHART_OF_ACCOUNTS_ID NUMBER (15)
Chart of Accounts identifier
EXTRACT_SOURCE_LEDGER VARCHAR2 (30)
Identifies the source ledger for this line. Can be one of AP, AR, GL
ESTABLISHMENT_ID NUMBER

Establishment identifier of the first party
INTERNAL_ORGANIZATION_ID NUMBER

Identifier of the internal organization for which a transaction is processed.
APPLICATION_ID NUMBER

Application identifier of the transaction
ENTITY_CODE VARCHAR2 (30)
Entity Code
EVENT_CLASS_CODE VARCHAR2 (30)
Lookup code for XLA event class code.
TRX_ID NUMBER (15)
The transaction header identifier, identifying the transaction extracted.
TRX_NUMBER VARCHAR2 (150)
The transaction number.
TRX_DESCRIPTION VARCHAR2 (240)
Description for the transaction.
TRX_CURRENCY_CODE VARCHAR2 (15)
Transaction currency code
TRX_TYPE_ID NUMBER (15)
Internal identifier used to control the receivable transaction type.
TRX_TYPE_MNG VARCHAR2 (80)
Meaning of Transaction type.
TRX_LINE_ID NUMBER (15)
Identifier of the lowest level for which tax is calculated.
TRX_LINE_NUMBER NUMBER

Transaction line number
TRX_LINE_DESCRIPTION VARCHAR2 (240)
Enter Comments Here
TRX_LEVEL_TYPE VARCHAR2 (30)
Transaction level type.Values can be HEADER, LINE, FREIGHT or SHIPMENT.
TRX_LINE_TYPE VARCHAR2 (30)
Identifies the line type of a transaction line.
TRX_LINE_CLASS VARCHAR2 (30)
Event class for the transaction line.
TRX_CLASS_MNG VARCHAR2 (80)
Meaning of Transaction class
TRX_DATE DATE

Transaction date
TRX_DUE_DATE DATE

Payment due date of the transaction.
TRX_COMMUNICATED_DATE DATE

Printed/Received date of the transaction.
PRODUCT_ID NUMBER

Internal identifier of the inventory item or memo line used in transaction line.
FUNCTIONAL_CURRENCY_CODE VARCHAR2 (30)
Functional currency code
CURRENCY_CONVERSION_TYPE VARCHAR2 (30)
The exchange rate type used to convert the transaction currency to functional.
CURRENCY_CONVERSION_DATE DATE

The date used to lookup the exchange rate.
CURRENCY_CONVERSION_RATE NUMBER

The exchange rate used to convert the transaction currency to the functional.
TERRITORY_SHORT_NAME VARCHAR2 (80)
Territory Short Name
DOC_SEQ_ID NUMBER (15)
Internal identifier of the sequence name used in the transaction.
DOC_SEQ_NAME VARCHAR2 (150)
Name of the sequence used in the transaction.
DOC_SEQ_VALUE VARCHAR2 (240)
Document sequence number for the transaction.
TRX_LINE_AMT NUMBER

Transaction line amount.
RECEIPT_CLASS_ID NUMBER (15)
Receipt Class Identifier.
APPLIED_FROM_APPLICATION_ID NUMBER (15)
Only AP. Application Id for the Applied from document.
APPLIED_FROM_ENTITY_CODE VARCHAR2 (30)
Entity Code for the Applied From document
APPLIED_FROM_EVENT_CLASS_CODE VARCHAR2 (30)
Event class code for the Applied From document.
APPLIED_FROM_TRX_ID NUMBER (15)
Internal Unique Identifier used to identify the Applied From document.
APPLIED_FROM_LINE_ID NUMBER (15)
Identifier of the lowest level for which tax is calculated.
APPLIED_FROM_TRX_NUMBER VARCHAR2 (150)
Transaction Number for the Applied From document.
APPLIED_TO_APPLICATION_ID NUMBER (15)
Application Id for the Applied To document.
APPLIED_TO_ENTITY_CODE VARCHAR2 (30)
Entity Code for the Applied To document.
APPLIED_TO_EVENT_CLASS_CODE VARCHAR2 (30)
Event class for the Applied To document.
APPLIED_TO_TRX_ID NUMBER (15)
The internal Id used to identify the Applied to document Name
APPLIED_TO_TRX_LINE_ID NUMBER (15)
The internal line Id used to identify the Applied to document Name
APPLIED_TO_TRX_NUMBER VARCHAR2 (150)
Transaction Number for the Applied To document.
ADJUSTED_DOC_APPLICATION_ID NUMBER (15)
Adjusted document application identifier
ADJUSTED_DOC_ENTITY_CODE VARCHAR2 (30)
Adjusted document entity code.
ADJUSTED_DOC_EVENT_CLASS_CODE VARCHAR2 (30)
Adjusted document event class code.
ADJUSTED_DOC_TRX_ID NUMBER (15)
Adjusted document transaction identifier
ADJUSTED_DOC_NUMBER VARCHAR2 (150)
The Adjusted to transaction number
ADJUSTED_DOC_DATE DATE

The Adjusted to transaction date
REF_DOC_APPLICATION_ID NUMBER (15)
Reference document application identifier.
REF_DOC_ENTITY_CODE VARCHAR2 (30)
Reference document entity code.
REF_DOC_EVENT_CLASS_CODE VARCHAR2 (30)
Reference document event class code.
REF_DOC_TRX_ID NUMBER (15)
Identifier for the reference document header
REF_DOC_LINE_ID NUMBER (15)
Identifier of the lowest level for which tax is calculated.
MERCHANT_PARTY_DOCUMENT_NUMBER VARCHAR2 (150)
Merchant party document number recorded on the Payables expense report
MERCHANT_PARTY_NAME VARCHAR2 (150)
Merchant party name recorded on the Payables expense report
MERCHANT_PARTY_REFERENCE VARCHAR2 (250)
Merchant party reference recorded on the Payables expense report
MERCHANT_PARTY_TAX_REG_NUMBER VARCHAR2 (150)
Merchant party tax registration number recorded on the Payables expense report
MERCHANT_PARTY_TAXPAYER_ID VARCHAR2 (150)
Merchant party taxpayer id recorded on the Payables expense report
START_EXPENSE_DATE DATE

Start Expense Date
TAXABLE_LINE_SOURCE_TABLE VARCHAR2 (30)
Identifies the taxable Source Table name.
TAX_LINE_ID NUMBER (15)
Tax line Identifier for transactions.
TAX_LINE_NUMBER NUMBER

Tax line number for transactions.
TAX_INVOICE_DATE DATE

Tax Reporting Date
TAXABLE_AMT NUMBER

Taxable amount in transaction currency
TAXABLE_AMT_FUNCL_CURR NUMBER

Taxable amount in functional currency
TAX_AMT NUMBER

Tax amount in transaction currency
TAX_AMT_FUNCL_CURR NUMBER

Tax amount in functional currency
REC_TAX_AMT_TAX_CURR NUMBER

Total recoverable tax amount in tax currency
NREC_TAX_AMT_TAX_CURR NUMBER

Total non-recoverable tax amount in tax currency
TAXABLE_DISC_AMT NUMBER

Taxable Discount amount in transaction currency
TAXABLE_DISC_AMT_FUNCL_CURR NUMBER

Taxable Discount amount in functional currency
TAX_DISC_AMT NUMBER

Tax Discount Amount in Transaction Currency
TAX_DISC_AMT_FUNCL_CURR NUMBER

Tax Discount Amount in Functional Currency
TAX_RATE_ID NUMBER (15)
Internal identifier for tax rate
TAX_RATE_CODE VARCHAR2 (30)
Tax rate name associated with the tax rate identifier.
TAX_RATE NUMBER

The rate specified for a tax status in effect for a period of time
TAX_RATE_CODE_NAME VARCHAR2 (240)
Tax Rate Code Name
TAX_RATE_CODE_DESCRIPTION VARCHAR2 (240)
Tax Rate Code description
TAX_RATE_VAT_TRX_TYPE_CODE VARCHAR2 (30)
VAT Transaction type Code for the Tax Rate
TAX_RATE_VAT_TRX_TYPE_DESC VARCHAR2 (240)
Description of VAT Transaction type Code for the Tax Rate
TAX_RATE_CODE_VAT_TRX_TYPE_MNG VARCHAR2 (240)
Meaning associated with VAT Transaction Type code for the Tax Rate
TAX_RATE_REGISTER_TYPE_CODE VARCHAR2 (30)
Tax rate Register Type
TAX_TYPE_CODE VARCHAR2 (30)
Tax rate type code
TAX_TYPE_MNG VARCHAR2 (80)
Enter Comments Here
TAX_RECOVERY_RATE NUMBER

Tax Recovery rate
TAX_REGIME_CODE VARCHAR2 (30)
Tax Regime code
TAX VARCHAR2 (30)
Tax
TAX_JURISDICTION_CODE VARCHAR2 (30)
Tax Jurisdiction code
TAX_STATUS_ID NUMBER (15)
Internal identifier of Tax status.
TAX_STATUS_CODE VARCHAR2 (30)
Tax status code.
TAX_CURRENCY_CODE VARCHAR2 (30)
Tax Currency code
OFFSET_TAX_RATE_CODE VARCHAR2 (30)
Offset Tax Rate Code
BILLING_TP_NAME VARCHAR2 (360)
The Ship to Customer Name, used only for Receivable Transactions
BILLING_TP_NUMBER VARCHAR2 (240)
Number of the trading partner (customer or supplier).
BILLING_TP_TAX_REG_NUM VARCHAR2 (50)
Billing Trading partner Tax registration number
BILLING_TP_TAXPAYER_ID VARCHAR2 (50)
Taxpayer Identifier of the trading partner (customer or supplier).
BILLING_TP_PARTY_NUMBER VARCHAR2 (30)
Customer or Supplier Number.
BILLING_TRADING_PARTNER_ID NUMBER (15)
Billing Trading partner Identifier
BILLING_TP_TAX_REPORTING_FLAG VARCHAR2 (1)
Billing Trading Partner Tax reporting Flag
BILLING_TP_SITE_ID NUMBER (15)
Site Details
BILLING_TP_ADDRESS_ID NUMBER (15)
Site Details
BILLING_TP_SITE_NAME VARCHAR2 (40)
Site Details
BILLING_TP_SITE_TAX_REG_NUM VARCHAR2 (50)
Site Details
SHIPPING_TP_NAME VARCHAR2 (360)
The ShipTo Customer Number, used only for Receivables Transaction.
SHIPPING_TP_NUMBER VARCHAR2 (60)
The ShipTo Customer name, used only for Receivables Transaction.
SHIPPING_TP_TAX_REG_NUM VARCHAR2 (50)
The ShipTo Customer tax registration number, used only for AR transactions.
SHIPPING_TP_TAXPAYER_ID VARCHAR2 (50)
The ShipTo Customer taxpayerId, used only for Receivables Transaction.
SHIPPING_TRADING_PARTNER_ID NUMBER (15)
The ShipTo Customer Number, used only for Receivables Transaction.
SHIPPING_TP_SITE_ID NUMBER (15)
Site Details
SHIPPING_TP_ADDRESS_ID NUMBER (15)
Site Details
SHIPPING_TP_SITE_NAME VARCHAR2 (40)
Site Details
SHIPPING_TP_SITE_TAX_REG_NUM VARCHAR2 (50)
Site Details
BILL_FROM_PARTY_ID NUMBER (15)
Supplier ID
BILL_FROM_PARTY_SITE_ID NUMBER (15)
Enter Comments Here
BANKING_TP_NAME VARCHAR2 (360)
Banking Trading Partner Name, (For AR Misc transactions alone).
BANKING_TP_TAXPAYER_ID VARCHAR2 (50)
Banking Trading Partner TaxPayer Id, (For AR Misc transactions alone).
BANK_ACCOUNT_NAME VARCHAR2 (80)
Back Account Name
BANK_ACCOUNT_NUM VARCHAR2 (30)
Bank Account Number
BANK_ACCOUNT_ID NUMBER (15)
Bank Account Identifier
BANK_BRANCH_ID NUMBER (15)
Bank Branch Identifier
LEGAL_ENTITY_TAX_REG_NUMBER VARCHAR2 (80)
Legal Entity Tax Reg Num
HQ_ESTB_REG_NUMBER VARCHAR2 (30)
HQ establishment Tax Reg Num
TAX_LINE_REGISTRATION_NUMBER VARCHAR2 (50)
Tax Line Tax Reg Num
CANCELLED_DATE DATE

Cancelled Date
CANCEL_FLAG VARCHAR2 (1)
Flag to indicate if the tax line is cancelled.
OFFSET_FLAG VARCHAR2 (1)
Flag to indicate that the tax is a offset tax.
POSTED_FLAG VARCHAR2 (1)
Flag to indicate that the tax distribution was posted
MRC_TAX_LINE_FLAG VARCHAR2 (1)
Flag to indicate MRC tax line
RECONCILIATION_FLAG VARCHAR2 (1)
Reconcilation Flag
TAX_RECOVERABLE_FLAG VARCHAR2 (1)
Tax Recoverable flag
REVERSE_FLAG VARCHAR2 (1)
It indicates a tax distribution reverses another Tax distribution.
CORRECTION_FLAG VARCHAR2 (1)
Flag to indicate correction records
AR_CASH_RECEIPT_REVERSE_STATUS VARCHAR2 (30)
Receipt Reverse status - Ar_cash_receipts.status
AR_CASH_RECEIPT_REVERSE_DATE DATE

Receipt Reverse date - Ar_cash_receipts. Reversal_Date
PAYABLES_INVOICE_SOURCE VARCHAR2 (50)
ap_invoices.source
ACCTD_AMOUNT_DR NUMBER

Ar_distributions. Acctd_amount_dr
ACCTD_AMOUNT_CR NUMBER

Ar_distributions. Acctd_amount_cr
REC_APPLICATION_STATUS VARCHAR2 (30)
Ar_receivable_Applications.status
VAT_COUNTRY_CODE VARCHAR2 (50)
Financial_system_parameters. Vat_country_code
INVOICE_IDENTIFIER VARCHAR2 (20)
Gl_je_lines.invoice_identifier
ACCOUNT_CLASS VARCHAR2 (20)
Ra_cust_trx_line_gl_dist.account_class
LATEST_REC_FLAG VARCHAR2 (1)
Ra_cust_trx_line_gl_dist.latest_rec_flag
JGZZ_FISCAL_CODE VARCHAR2 (50)
Hz_parties. Jgzz_fiscal_code - zx_rep_trx_detail_t.Billing_tp_taxpayer_id
TAX_REFERENCE VARCHAR2 (50)
Hz_parties.Tax_reference - zx_rep_trx_detail_t.Billing_tp_tax_reg_num
PT_LOCATION VARCHAR2 (25)
Portguese Location - Possible values are: A, C, M
INVOICE_REPORT_TYPE VARCHAR2 (150)
Enter Comments Here
ES_CORRECTION_YEAR VARCHAR2 (25)
Enter Comments Here
ES_CORRECTION_PERIOD VARCHAR2 (25)
Spanish Correction Period
TRIANGULATION VARCHAR2 (240)
Spanish Triangulation - ZX_LINES_DET_FACTORS.DOCUMENT_SUB_TYPE
DOCUMENT_SUB_TYPE VARCHAR2 (240)
French Deduction Tax Rule - ZX_LINES_DET_FACTORS.DOCUMENT_SUB_TYPE
ASSESSABLE_VALUE NUMBER

Italian GDF, Self Invoice taxable amount
PROPERTY_LOCATION VARCHAR2 (240)
Spanish GDF Property Locations
CHK_VAT_AMOUNT_PAID VARCHAR2 (25)
ECE VAT Registers GDF
IMPORT_DOCUMENT_NUMBER VARCHAR2 (240)
Czech GDFs
IMPORT_DOCUMENT_DATE DATE

Czech GDFs
PRL_NO VARCHAR2 (25)
Spanish HR Locations GDFs
PROPERTY_RENTAL VARCHAR2 (25)
Spanish HR Locations GDFs
RATES_REFERENCE VARCHAR2 (25)
Spanish HR Locations GDFs
STAIR_NUM VARCHAR2 (240)
Spanish HR Locations GDFs
FLOOR_NUM VARCHAR2 (240)
Spanish HR Locations GDFs
DOOR_NUM VARCHAR2 (240)
Spanish HR Locations GDFs
AMOUNT_APPLIED NUMBER

Amount Applied
ACTG_EVENT_TYPE_CODE VARCHAR2 (30)
Event type code
ACTG_EVENT_TYPE_MNG VARCHAR2 (240)
event type meaning
ACTG_EVENT_NUMBER NUMBER

Event Number
ACTG_EVENT_STATUS_FLAG VARCHAR2 (1)
Event status flag
ACTG_EVENT_STATUS_MNG VARCHAR2 (240)
Even status meaning
ACTG_CATEGORY_CODE VARCHAR2 (30)
Category Code
ACTG_CATEGORY_MNG VARCHAR2 (240)
Category meaning
ACCOUNTING_DATE DATE

Accounting date
GL_TRANSFER_FLAG VARCHAR2 (1)
GL Transfer flag
ACTG_LINE_NUM NUMBER (15)
Accounting Line Number
ACTG_LINE_TYPE_CODE VARCHAR2 (30)
Accounting Line Type Code
ACTG_LINE_TYPE_MNG VARCHAR2 (240)
Accounting Line Type Code meaning
ACTG_LINE_DESCRIPTION VARCHAR2 (1996)
Accounting Line Description.
ACTG_STAT_AMT NUMBER

Statistical Amount
ACTG_PARTY_ID NUMBER (15)
Party Identifier
ACTG_PARTY_SITE_ID NUMBER (15)
Party Site Identifier
ACTG_PARTY_TYPE VARCHAR2 (30)
Party Type
ACTG_EVENT_ID NUMBER (15)
Accounting Event Identifier
ACTG_HEADER_ID NUMBER

Accounting Header Identifier
ACTG_LINE_ID NUMBER (15)
Accounting Line Identifer
ACTG_SOURCE_ID NUMBER (15)
Accounting source id
ACTG_SOURCE_TABLE VARCHAR2 (30)
Accounting source table
ACTG_LINE_CCID NUMBER (15)
Code Combination Identifier
ACCOUNT_FLEXFIELD VARCHAR2 (2000)
Account Flexfield
ACCOUNT_DESCRIPTION VARCHAR2 (1996)
Account Description
PERIOD_NAME VARCHAR2 (30)
Period Name
TRX_ARAP_BALANCING_SEGMENT VARCHAR2 (240)
Balancing segment
TRX_ARAP_NATURAL_ACCOUNT VARCHAR2 (240)
Natural segment
TRX_TAXABLE_BALANCING_SEGMENT VARCHAR2 (240)
Taxable Balancing segment
TRX_TAXABLE_NATURAL_ACCOUNT VARCHAR2 (240)
Taxable Natural segment
TRX_TAX_BALANCING_SEGMENT VARCHAR2 (240)
Tax Balancing segment
TRX_TAX_NATURAL_ACCOUNT VARCHAR2 (240)
Tax Natural segment.
CREATED_BY NUMBER (15) Y Standard Who column
CREATION_DATE DATE
Y Standard Who column
LAST_UPDATED_BY NUMBER (15) Y Standard Who column
LAST_UPDATE_DATE DATE
Y Standard Who column
LAST_UPDATE_LOGIN NUMBER (15)
Standard Who column
REQUEST_ID NUMBER

Standard Who column
PROGRAM_APPLICATION_ID NUMBER

Standard Who column
PROGRAM_ID NUMBER

Standard Who column
PROGRAM_LOGIN_ID NUMBER

Standard Who column
OBJECT_VERSION_NUMBER NUMBER
Y Object Version Number
GL_DATE DATE

GL_DATE for the tax transaction line
TRX_CONTROL_ACCOUNT_FLEXFIELD VARCHAR2 (2000)
Taxable line account flexfield
TAX_ORIGIN VARCHAR2 (30)
Tax Origin
REPORTING_CODE VARCHAR2 (60)
EMEA VAT Reporting code
DEF_REC_SETTLEMENT_OPTION_CODE VARCHAR2 (30)
Deferred settlement code

[top of page]

JG.JG_ZZ_VAT_TRX_DETAILS does not reference any database object

JG.JG_ZZ_VAT_TRX_DETAILS is referenced by following:

APPS
SYNONYM - JG_ZZ_VAT_TRX_DETAILS

[top of page]

Table: JG_ZZ_VAT_TRX_GT

Description:
Comments
Columns
Name Datatype Length Mandatory Comments
JG_INFO_V1 VARCHAR2 (240)
JG_INFO_V2 VARCHAR2 (240)
JG_INFO_V3 VARCHAR2 (240)
JG_INFO_V4 VARCHAR2 (240)
JG_INFO_V5 VARCHAR2 (240)
JG_INFO_V6 VARCHAR2 (1996)
JG_INFO_V7 VARCHAR2 (240)
JG_INFO_V8 VARCHAR2 (240)
JG_INFO_V9 VARCHAR2 (1996)
JG_INFO_V10 VARCHAR2 (1996)
JG_INFO_V11 VARCHAR2 (150)
JG_INFO_V12 VARCHAR2 (150)
JG_INFO_V13 VARCHAR2 (150)
JG_INFO_V14 VARCHAR2 (150)
JG_INFO_V15 VARCHAR2 (1996)
JG_INFO_V16 VARCHAR2 (150)
JG_INFO_V17 VARCHAR2 (1996)
JG_INFO_V18 VARCHAR2 (150)
JG_INFO_V19 VARCHAR2 (150)
JG_INFO_V20 VARCHAR2 (150)
JG_INFO_V21 VARCHAR2 (150)
JG_INFO_V22 VARCHAR2 (150)
JG_INFO_V23 VARCHAR2 (150)
JG_INFO_V24 VARCHAR2 (150)
JG_INFO_V25 VARCHAR2 (150)
JG_INFO_V26 VARCHAR2 (150)
JG_INFO_V27 VARCHAR2 (150)
JG_INFO_V28 VARCHAR2 (150)
JG_INFO_V29 VARCHAR2 (150)
JG_INFO_V30 VARCHAR2 (150)
JG_INFO_V31 VARCHAR2 (150)
JG_INFO_V32 VARCHAR2 (1996)
JG_INFO_V33 VARCHAR2 (150)
JG_INFO_V34 VARCHAR2 (150)
JG_INFO_V35 VARCHAR2 (150)
JG_INFO_V36 VARCHAR2 (150)
JG_INFO_V37 VARCHAR2 (150)
JG_INFO_V38 VARCHAR2 (150)
JG_INFO_V39 VARCHAR2 (150)
JG_INFO_V40 VARCHAR2 (150)
JG_INFO_N1 NUMBER

JG_INFO_N2 NUMBER

JG_INFO_N3 NUMBER

JG_INFO_N4 NUMBER

JG_INFO_N5 NUMBER

JG_INFO_N6 NUMBER

JG_INFO_N7 NUMBER

JG_INFO_N8 NUMBER

JG_INFO_N9 NUMBER

JG_INFO_N10 NUMBER

JG_INFO_N11 NUMBER

JG_INFO_N12 NUMBER

JG_INFO_N13 NUMBER

JG_INFO_N14 NUMBER

JG_INFO_N15 NUMBER

JG_INFO_N16 NUMBER

JG_INFO_N17 NUMBER

JG_INFO_N18 NUMBER

JG_INFO_N19 NUMBER

JG_INFO_N20 NUMBER

JG_INFO_N21 NUMBER

JG_INFO_N22 NUMBER

JG_INFO_N23 NUMBER

JG_INFO_N24 NUMBER

JG_INFO_N25 NUMBER

JG_INFO_N26 NUMBER

JG_INFO_N27 NUMBER

JG_INFO_N28 NUMBER

JG_INFO_N29 NUMBER

JG_INFO_N30 NUMBER

JG_INFO_D1 DATE

JG_INFO_D2 DATE

JG_INFO_D3 DATE

JG_INFO_D4 DATE

JG_INFO_D5 DATE

JG_INFO_D6 DATE

JG_INFO_D7 DATE

JG_INFO_D8 DATE

JG_INFO_D9 DATE

JG_INFO_D10 DATE

JG_INFO_D11 DATE

JG_INFO_D12 DATE

JG_INFO_D13 DATE

JG_INFO_D14 DATE

JG_INFO_D15 DATE

[top of page]

JG.JG_ZZ_VAT_TRX_GT does not reference any database object

JG.JG_ZZ_VAT_TRX_GT is referenced by following:

APPS
SYNONYM - JG_ZZ_VAT_TRX_GT

[top of page]

Table: JG_ZZ_VAT_TRX_UPG_STG

Description: Consolidates all transactions from R11i final reporting tables migrated to R12
Primary Key: JG_ZZ_VAT_TRX_UPG_STG_PK
  1. VAT_TRX_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
JG_ZZ_VAT_TRX_UPG_STG.VAT_HEADER_ID JG_ZZ_VAT_UPG_STG
JG_ZZ_VAT_TRX_UPG_STG.ORGANIZATION_ID HR_ALL_ORGANIZATION_UNITS
JG_ZZ_VAT_TRX_UPG_STG.APPLICATION_ID FND_APPLICATION
JG_ZZ_VAT_TRX_UPG_STG.LEDGER_ID GL_LEDGERS
Comments

This table is used to derive TRL call parameters (date range by Ledger) for retrieving the final reported transactions, and to filter TRL output only to those records that are finally reported in R11i.

Indexes
Index Type Tablespace Column
JG_ZZ_VAT_TRX_UPG_STG_U1 UNIQUE APPS_TS_TX_IDX VAT_TRX_ID
JG_ZZ_VAT_TRX_UPG_STG_N1 NONUNIQUE APPS_TS_TX_IDX VAT_HEADER_ID
JG_ZZ_VAT_TRX_UPG_STG_N2 NONUNIQUE APPS_TS_TX_IDX APPLICATION_ID
ENTITY_CODE
EVENT_CLASS_CODE
TRX_ID
Columns
Name Datatype Length Mandatory Comments
VAT_TRX_ID NUMBER (15) Y VAT Final Reporting Transaction Identifier
VAT_HEADER_ID NUMBER (15) Y VAT header identifier
ORGANIZATION_ID NUMBER (15) Y Operating Unit Identifier for the transaction
APPLICATION_ID NUMBER (15) Y The application corresponding to the transaction
ENTITY_CODE VARCHAR2 (30)
Entity code of the transaction
EVENT_CLASS_CODE VARCHAR2 (30)
Application products event class of the transaction
TRX_ID NUMBER (15) Y Transaction identifier
LEDGER_ID NUMBER (15) Y Ledger to which the transaction belongs
TAX_INVOICE_DATE DATE

Tax reporting date for the transaction
TAX_REGIME_CODE VARCHAR2 (30)
Tax Regime Code
TAX_RATE_ID NUMBER (15)
Tax Rate Identifier
TAX_RATE_CODE VARCHAR2 (30)
Tax Rate Code
MIGRATION_FLAG VARCHAR2 (1)
Flag that indicates migrated transactions
LAST_UPDATED_BY NUMBER (15) Y Standard Who Column
CREATION_DATE DATE
Y Standard Who Column
LAST_UPDATE_LOGIN NUMBER (15)
Standard Who Column
LAST_UPDATE_DATE DATE
Y Standard Who Column
CREATED_BY NUMBER (15) Y Standard Who Column
OBJECT_VERSION_NUMBER NUMBER (15) Y Object Version Number

[top of page]

JG.JG_ZZ_VAT_TRX_UPG_STG does not reference any database object

JG.JG_ZZ_VAT_TRX_UPG_STG is referenced by following:

APPS
SYNONYM - JG_ZZ_VAT_TRX_UPG_STG

[top of page]

Table: JG_ZZ_VAT_UPG_STG

Description: Stores mapping information of Legal Entity, Ledgers, OUs, and Country Codes
Primary Key: JG_ZZ_VAT_UPG_STG_PK
  1. VAT_HEADER_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
JG_ZZ_VAT_UPG_STG.ORGANIZATION_ID HR_ALL_ORGANIZATION_UNITS
JG_ZZ_VAT_UPG_STG.LOCATION_ID HR_LOCATIONS_ALL
Foreign Keys to this table:
Foreign Key Column Foreign Table
JG_ZZ_VAT_TRX_UPG_STG.VAT_HEADER_ID JG_ZZ_VAT_UPG_STG
Comments

This table stores mapping information of Legal Entities, Ledgers, Operating Units, and Country Codes. The table is populated by the upgrade script, which extracts all Operating Units belonging to countries that use the EMEA VAT solution, and identifies the corresponding Ledgers, GRE/LEs, and country codes. Other upgrade processes, including Stamping of Tax Invoice Date, Migration of Finally Reported transactions, and Country Specific Setup migration also refer to this table.

Indexes
Index Type Tablespace Column
JG_ZZ_VAT_UPG_STG_U1 UNIQUE APPS_TS_TX_IDX VAT_HEADER_ID
JG_ZZ_VAT_UPG_STG_N1 NONUNIQUE APPS_TS_TX_IDX ORGANIZATION_ID
LEDGER_ID
LEGAL_ENTITY_ID
COUNTRY_CODE
Columns
Name Datatype Length Mandatory Comments
VAT_HEADER_ID NUMBER (15) Y VAT header identifier. System generated key column
ORGANIZATION_ID NUMBER (15) Y Organization identifier
LEDGER_ID NUMBER (15)
Ledger identifier for an organization
LEGAL_ENTITY_ID NUMBER (15)
Legal entity identifier associated with ORGANIZATION_ID
COUNTRY_CODE VARCHAR2 (2) Y Country code associated with ORGANIZATION_ID
LOCATION_ID NUMBER (15) Y Location identifier for the combination of ORGANIZATION_ID and COUNTRY_CODE
GEOGRAPHY_ID NUMBER (15) Y Geography identifier of the country
PARTY_ID NUMBER (15)
Party identifier for a legal entity
TAX_REGISTRATION_NUMBER VARCHAR2 (50)
Tax registration number for a legal entity
TAX_CALENDER VARCHAR2 (30)
Tax calendar; dependent on the country and ledger
REPORT_SEQUENCE_FLAG VARCHAR2 (1)
Report sequence flag for ECE countries
CREATED_BY NUMBER (15) Y Standard Who column
CREATION_DATE DATE
Y Standard Who column
LAST_UPDATED_BY NUMBER (15) Y Standard Who column
LAST_UPDATE_DATE DATE
Y Standard Who column
LAST_UPDATE_LOGIN NUMBER (15)
Standard Who column
OBJECT_VERSION_NUMBER NUMBER (15) Y Object Version Number

[top of page]

JG.JG_ZZ_VAT_UPG_STG does not reference any database object

JG.JG_ZZ_VAT_UPG_STG is referenced by following:

APPS
SYNONYM - JG_ZZ_VAT_UPG_STG

[top of page]

Table: JG_ZZ_VEND_SITE_INFO

Description: Additional country-specific information for vendor sites
Primary Key: JG_ZZ_VEND_SITE_INFO_PK
  1. JGZZ_COUNTRY_CODE
  2. VENDOR_SITE_ID
Comments
Indexes
Index Type Tablespace Column
JG_ZZ_VEND_SITE_INFO_U1 UNIQUE APPS_TS_TX_IDX VENDOR_SITE_ID
JGZZ_COUNTRY_CODE
Columns
Name Datatype Length Mandatory Comments
JGZZ_COUNTRY_CODE VARCHAR2 (15) Y
VENDOR_SITE_ID NUMBER
Y
JGZZ_ATTRIBUTE_CATEGORY VARCHAR2 (35) Y
JGZZ_SITE_INFO1 VARCHAR2 (150)
JGZZ_SITE_INFO2 VARCHAR2 (150)
JGZZ_SITE_INFO3 VARCHAR2 (150)
JGZZ_SITE_INFO4 VARCHAR2 (150)
JGZZ_SITE_INFO5 VARCHAR2 (150)
JGZZ_SITE_INFO6 VARCHAR2 (150)
JGZZ_SITE_INFO7 VARCHAR2 (150)
JGZZ_SITE_INFO8 VARCHAR2 (150)
JGZZ_SITE_INFO9 VARCHAR2 (150)
JGZZ_SITE_INFO10 VARCHAR2 (150)
JGZZ_SITE_INFO11 VARCHAR2 (150)
JGZZ_SITE_INFO12 VARCHAR2 (150)
JGZZ_SITE_INFO13 VARCHAR2 (150)
JGZZ_SITE_INFO14 VARCHAR2 (150)
JGZZ_SITE_INFO15 VARCHAR2 (150)
JGZZ_SITE_INFO16 VARCHAR2 (150)
JGZZ_SITE_INFO17 VARCHAR2 (150)
JGZZ_SITE_INFO18 VARCHAR2 (150)
JGZZ_SITE_INFO19 VARCHAR2 (150)
JGZZ_SITE_INFO20 VARCHAR2 (150)
JGZZ_SITE_INFO21 VARCHAR2 (150)
JGZZ_SITE_INFO22 VARCHAR2 (150)
JGZZ_SITE_INFO23 VARCHAR2 (150)
JGZZ_SITE_INFO24 VARCHAR2 (150)
JGZZ_SITE_INFO25 VARCHAR2 (150)
JGZZ_SITE_INFO26 VARCHAR2 (150)
JGZZ_SITE_INFO27 VARCHAR2 (150)
JGZZ_SITE_INFO28 VARCHAR2 (150)
JGZZ_SITE_INFO29 VARCHAR2 (150)
JGZZ_SITE_INFO30 VARCHAR2 (150)
LAST_UPDATED_BY NUMBER (15)
LAST_UPDATE_DATE DATE

LAST_UPDATE_LOGIN NUMBER (15)
CREATED_BY NUMBER (15)
CREATION_DATE DATE

[top of page]

AP.JG_ZZ_VEND_SITE_INFO does not reference any database object

AP.JG_ZZ_VEND_SITE_INFO is referenced by following:

APPS
SYNONYM - JG_ZZ_VEND_SITE_INFO

[top of page]

View: JG_AP_TAX_LINES_SUMMARY_V

Comments
***** Warning: Oracle Internal Use Only *****

Oracle Corporation does not support access to Oracle applications data using this object, except from standard Oracle Applications programs.

View Type

Internal

Columns
Name Datatype Length Mandatory Comments
TRX_HEADER_ID NUMBER (15)
TRX_LINE_ID VARCHAR2 (0)
TRX_SHIPMENT_ID VARCHAR2 (0)
TRX_DISTRIBUTION_ID NUMBER (15)
TAX_LINE_NUMBER VARCHAR2 (0)
SET_OF_BOOKS_ID NUMBER (15)
REQUEST_ID NUMBER (15)
TRX_NUMBER VARCHAR2 (50)
PREVIOUS_TRX_HEADER_ID NUMBER (15)
TRX_DATE DATE

TRX_CURRENCY_CODE VARCHAR2 (15)
EXCHANGE_RATE NUMBER

MINIMUM_ACCOUNTABLE_UNIT VARCHAR2 (0)
PRECISION VARCHAR2 (0)
SHIP_FROM_SUPPLIER_ID NUMBER (15)
SHIP_FROM_SUPPLIER_NUMBER VARCHAR2 (30)
SHIP_FROM_SUPPLIER_NAME VARCHAR2 (240)
SHIP_FROM_SITE_USE_ID NUMBER (15)
SHIP_FROM_COUNTRY VARCHAR2 (25)
SHIP_FROM_STATE VARCHAR2 (150)
SHIP_FROM_COUNTY VARCHAR2 (150)
SHIP_FROM_CITY VARCHAR2 (0)
SHIP_FROM_PROVINCE VARCHAR2 (0)
SHIP_FROM_POSTAL_CODE VARCHAR2 (20)
SHIP_FROM_IN_CITY_LIMITS_FLAG VARCHAR2 (0)
SHIP_FROM_GEOCODE VARCHAR2 (0)
LINE_NUMBER NUMBER (15)
TRX_LINE_TYPE VARCHAR2 (25)
INVENTORY_ITEM_ID VARCHAR2 (0)
PART_NUMBER VARCHAR2 (0)
QUANTITY VARCHAR2 (0)
QUANTITY_ORDERED VARCHAR2 (0)
UNIT_PRICE NUMBER

PRICE_OVERRIDE VARCHAR2 (0)
TAXABLE_FLAG VARCHAR2 (0)
CODE_COMBINATION_ID NUMBER

FOB_CODE VARCHAR2 (0)
PREVIOUS_TRX_LINE_ID VARCHAR2 (40)
USSGL_TRANSACTION_CODE VARCHAR2 (30)
USSGL_TRX_CODE_CONTEXT VARCHAR2 (30)
SHIP_TO_LOCATION_ID VARCHAR2 (0)
SHIP_TO_ORGANIZATION_ID VARCHAR2 (0)
SHIP_TO_WAREHOUSE_ID VARCHAR2 (0)
SHIP_TO_COUNTRY VARCHAR2 (0)
SHIP_TO_STATE VARCHAR2 (0)
SHIP_TO_COUNTY VARCHAR2 (0)
SHIP_TO_CITY VARCHAR2 (0)
SHIP_TO_PROVINCE VARCHAR2 (0)
SHIP_TO_POSTAL_CODE VARCHAR2 (0)
SHIP_TO_IN_CITY_LIMITS_FLAG VARCHAR2 (0)
SHIP_TO_GEOCODE VARCHAR2 (0)
POO_ADDRESS_CODE VARCHAR2 (0)
POA_ADDRESS_CODE VARCHAR2 (0)
TAX_CODE_ID NUMBER (15)
TAX_CODE VARCHAR2 (15)
TAX_USER_OVERRIDE_FLAG VARCHAR2 (1)
TAX_RATE NUMBER

TOTAL_TAX_AMOUNT VARCHAR2 (0)
RECOVERABLE_TAX VARCHAR2 (0)
NONRECOVERABLE_TAX VARCHAR2 (0)
LOCATION_QUALIFIER VARCHAR2 (0)
COMPOUNDING_PRECEDENCE VARCHAR2 (0)
TAX_EXEMPTION_ID VARCHAR2 (0)
TAX_EXCEPTION_ID VARCHAR2 (0)
VENDOR_CONTROL_EXEMPTIONS VARCHAR2 (0)
TAX_RECOVERY_RATE NUMBER

TAX_RECOVERY_OVERRIDE_FLAG VARCHAR2 (1)
GLOBAL_ATTRIBUTE1 NUMBER

GLOBAL_ATTRIBUTE2 VARCHAR2 (0)
GLOBAL_ATTRIBUTE3 VARCHAR2 (0)
GLOBAL_ATTRIBUTE4 VARCHAR2 (0)
GLOBAL_ATTRIBUTE5 VARCHAR2 (0)
GLOBAL_NUMERIC_ATTRIBUTE1 VARCHAR2 (0)
GLOBAL_NUMERIC_ATTRIBUTE2 VARCHAR2 (0)
GLOBAL_NUMERIC_ATTRIBUTE3 VARCHAR2 (0)
GLOBAL_NUMERIC_ATTRIBUTE4 VARCHAR2 (0)
GLOBAL_NUMERIC_ATTRIBUTE5 VARCHAR2 (0)
TAX_EXEMPT_FLAG VARCHAR2 (0)
TAX_EXEMPT_NUMBER VARCHAR2 (0)
TAX_EXEMPT_REASON_CODE VARCHAR2 (0)
COMPANY_CODE VARCHAR2 (0)
DIVISION_CODE VARCHAR2 (0)
AUDIT_FLAG VARCHAR2 (0)
TAX_HEADER_LEVEL_FLAG VARCHAR2 (1)
TAX_ROUNDING_RULE VARCHAR2 (1)
TAX_TYPE VARCHAR2 (25)
TAX_DESCRIPTION VARCHAR2 (240)
ALLOW_TAX_CODE_OVERRIDE_FLAG VARCHAR2 (0)
PROJECT_ID VARCHAR2 (40)
TASK_ID VARCHAR2 (40)
EXPENDITURE_TYPE VARCHAR2 (30)
EXPENDITURE_ORGANIZATION_ID VARCHAR2 (40)
EXPENDITURE_ITEM_DATE VARCHAR2 (9)
PA_QUANTITY VARCHAR2 (40)
TAX_MINIMUM_ACCOUNTABLE_UNIT VARCHAR2 (0)
TAX_PRECISION VARCHAR2 (0)
AMOUNT_INCLUDES_TAX_FLAG VARCHAR2 (1)
TAX_CALCULATED_FLAG VARCHAR2 (1)
TAX_RECOVERABLE_FLAG VARCHAR2 (1)
CURRENCY_UNIT_PRICE VARCHAR2 (0)
ACCOUNT_GL_DATE DATE

[top of page]

APPS.JG_AP_TAX_LINES_SUMMARY_V references the following:

APPS
SYNONYM - AP_INVOICES
SYNONYM - AP_INVOICE_DISTRIBUTIONS
SYNONYM - AP_TAX_CODES
PACKAGE - AP_TAX_ENGINE_PKG
PACKAGE - AP_UTILITIES_PKG
SYNONYM - AR_TAX_GROUP_CODES
SYNONYM - FINANCIALS_SYSTEM_PARAMETERS
VIEW - PO_VENDORS
VIEW - PO_VENDOR_SITES

APPS.JG_AP_TAX_LINES_SUMMARY_V is not referenced by any database object

[top of page]

View: JG_PO_REL_TAX_LINES_SUMMARY_V

Comments
***** Warning: Oracle Internal Use Only *****

Oracle Corporation does not support access to Oracle applications data using this object, except from standard Oracle Applications programs.

View Type

Internal

Columns
Name Datatype Length Mandatory Comments
TRX_HEADER_ID NUMBER

TRX_LINE_ID VARCHAR2 (0)
TRX_SHIPMENT_ID NUMBER

TRX_DISTRIBUTION_ID NUMBER

TAX_LINE_NUMBER VARCHAR2 (0)
SET_OF_BOOKS_ID NUMBER (15)
REQUEST_ID NUMBER

TRX_NUMBER VARCHAR2 (0)
PREVIOUS_TRX_HEADER_ID VARCHAR2 (0)
TRX_DATE DATE

TRX_CURRENCY_CODE VARCHAR2 (15)
EXCHANGE_RATE VARCHAR2 (0)
MINIMUM_ACCOUNTABLE_UNIT NUMBER

PRECISION NUMBER (1)
SHIP_FROM_SUPPLIER_ID NUMBER

SHIP_FROM_SUPPLIER_NUMBER VARCHAR2 (0)
SHIP_FROM_SUPPLIER_NAME VARCHAR2 (240)
SHIP_FROM_SITE_USE_ID NUMBER

SHIP_FROM_COUNTRY VARCHAR2 (25)
SHIP_FROM_STATE VARCHAR2 (150)
SHIP_FROM_COUNTY VARCHAR2 (150)
SHIP_FROM_CITY VARCHAR2 (0)
SHIP_FROM_PROVINCE VARCHAR2 (0)
SHIP_FROM_POSTAL_CODE VARCHAR2 (20)
SHIP_FROM_IN_CITY_LIMITS_FLAG VARCHAR2 (0)
SHIP_FROM_GEOCODE VARCHAR2 (0)
LINE_NUMBER NUMBER

TRX_LINE_TYPE VARCHAR2 (25)
INVENTORY_ITEM_ID NUMBER

PART_NUMBER VARCHAR2 (40)
QUANTITY NUMBER

QUANTITY_ORDERED NUMBER

UNIT_PRICE NUMBER

PRICE_OVERRIDE NUMBER

TAXABLE_FLAG VARCHAR2 (1)
CODE_COMBINATION_ID NUMBER

FOB_CODE VARCHAR2 (25)
PREVIOUS_TRX_LINE_ID VARCHAR2 (0)
USSGL_TRANSACTION_CODE VARCHAR2 (30)
USSGL_TRX_CODE_CONTEXT VARCHAR2 (30)
SHIP_TO_LOCATION_ID NUMBER

SHIP_TO_ORGANIZATION_ID NUMBER

SHIP_TO_WAREHOUSE_ID VARCHAR2 (0)
SHIP_TO_COUNTRY VARCHAR2 (60)
SHIP_TO_STATE VARCHAR2 (0)
SHIP_TO_COUNTY VARCHAR2 (0)
SHIP_TO_CITY VARCHAR2 (30)
SHIP_TO_PROVINCE VARCHAR2 (0)
SHIP_TO_POSTAL_CODE VARCHAR2 (30)
SHIP_TO_IN_CITY_LIMITS_FLAG VARCHAR2 (0)
SHIP_TO_GEOCODE VARCHAR2 (0)
POO_ADDRESS_CODE VARCHAR2 (0)
POA_ADDRESS_CODE VARCHAR2 (0)
TAX_CODE_ID NUMBER

TAX_CODE VARCHAR2 (0)
TAX_USER_OVERRIDE_FLAG VARCHAR2 (1)
TAX_RATE NUMBER

TOTAL_TAX_AMOUNT VARCHAR2 (0)
RECOVERABLE_TAX VARCHAR2 (0)
NONRECOVERABLE_TAX VARCHAR2 (0)
LOCATION_QUALIFIER VARCHAR2 (0)
COMPOUNDING_PRECEDENCE VARCHAR2 (0)
TAX_EXEMPTION_ID VARCHAR2 (0)
TAX_EXCEPTION_ID VARCHAR2 (0)
VENDOR_CONTROL_EXEMPTIONS VARCHAR2 (0)
TAX_RECOVERY_RATE NUMBER

TAX_RECOVERY_OVERRIDE_FLAG VARCHAR2 (1)
GLOBAL_ATTRIBUTE1 VARCHAR2 (0)
GLOBAL_ATTRIBUTE2 VARCHAR2 (0)
GLOBAL_ATTRIBUTE3 VARCHAR2 (0)
GLOBAL_ATTRIBUTE4 VARCHAR2 (0)
GLOBAL_ATTRIBUTE5 VARCHAR2 (0)
GLOBAL_NUMERIC_ATTRIBUTE1 VARCHAR2 (0)
GLOBAL_NUMERIC_ATTRIBUTE2 VARCHAR2 (0)
GLOBAL_NUMERIC_ATTRIBUTE3 VARCHAR2 (0)
GLOBAL_NUMERIC_ATTRIBUTE4 VARCHAR2 (0)
GLOBAL_NUMERIC_ATTRIBUTE5 VARCHAR2 (0)
TAX_EXEMPT_FLAG VARCHAR2 (0)
TAX_EXEMPT_NUMBER VARCHAR2 (0)
TAX_EXEMPT_REASON_CODE VARCHAR2 (0)
COMPANY_CODE VARCHAR2 (0)
DIVISION_CODE VARCHAR2 (0)
AUDIT_FLAG VARCHAR2 (0)
TAX_HEADER_LEVEL_FLAG VARCHAR2 (0)
TAX_ROUNDING_RULE VARCHAR2 (1)
TAX_TYPE VARCHAR2 (25)
TAX_DESCRIPTION VARCHAR2 (240)
ALLOW_TAX_CODE_OVERRIDE_FLAG VARCHAR2 (0)
PROJECT_ID NUMBER

TASK_ID NUMBER

EXPENDITURE_TYPE VARCHAR2 (30)
EXPENDITURE_ORGANIZATION_ID NUMBER

EXPENDITURE_ITEM_DATE DATE

PA_QUANTITY VARCHAR2 (0)
TAX_MINIMUM_ACCOUNTABLE_UNIT VARCHAR2 (0)
TAX_PRECISION VARCHAR2 (0)
AMOUNT_INCLUDES_TAX_FLAG VARCHAR2 (0)
TAX_CALCULATED_FLAG VARCHAR2 (0)
TAX_RECOVERABLE_FLAG VARCHAR2 (0)

[top of page]

APPS.JG_PO_REL_TAX_LINES_SUMMARY_V references the following:

APPS
SYNONYM - AP_TAX_CODES
SYNONYM - AR_TAX_GROUP_CODES
SYNONYM - FINANCIALS_SYSTEM_PARAMETERS
SYNONYM - FND_CURRENCIES
PACKAGE - FND_GLOBAL
PACKAGE - HR_GENERAL
VIEW - HR_LOCATIONS
PACKAGE - HR_SECURITY
SYNONYM - MTL_CATEGORIES
SYNONYM - MTL_SYSTEM_ITEMS
SYNONYM - PO_DISTRIBUTIONS
PACKAGE - PO_HEADERS_SV3
VIEW - PO_LINE_LOCATIONS_RELEASE_V
SYNONYM - PO_LINE_TYPES
PACKAGE - PO_RELEASES_SV2
VIEW - PO_RELEASES_V
VIEW - PO_VENDORS
VIEW - PO_VENDOR_SITES

APPS.JG_PO_REL_TAX_LINES_SUMMARY_V is not referenced by any database object

[top of page]

View: JG_PO_REQ_TAX_LINES_SUMMARY_V

Comments
***** Warning: Oracle Internal Use Only *****

Oracle Corporation does not support access to Oracle applications data using this object, except from standard Oracle Applications programs.

View Type

Internal

Columns
Name Datatype Length Mandatory Comments
TRX_HEADER_ID NUMBER

TRX_LINE_ID NUMBER

TRX_SHIPMENT_ID NUMBER

TRX_DISTRIBUTION_ID NUMBER

TAX_LINE_NUMBER VARCHAR2 (0)
SET_OF_BOOKS_ID NUMBER (15)
REQUEST_ID NUMBER

TRX_NUMBER VARCHAR2 (20)
PREVIOUS_TRX_HEADER_ID VARCHAR2 (0)
TRX_DATE DATE

TRX_CURRENCY_CODE VARCHAR2 (15)
EXCHANGE_RATE NUMBER

MINIMUM_ACCOUNTABLE_UNIT NUMBER

PRECISION NUMBER (1)
SHIP_FROM_SUPPLIER_ID NUMBER

SHIP_FROM_SUPPLIER_NUMBER VARCHAR2 (0)
SHIP_FROM_SUPPLIER_NAME VARCHAR2 (240)
SHIP_FROM_SITE_USE_ID NUMBER

SHIP_FROM_COUNTRY VARCHAR2 (25)
SHIP_FROM_STATE VARCHAR2 (150)
SHIP_FROM_COUNTY VARCHAR2 (150)
SHIP_FROM_CITY VARCHAR2 (25)
SHIP_FROM_PROVINCE VARCHAR2 (150)
SHIP_FROM_POSTAL_CODE VARCHAR2 (20)
SHIP_FROM_IN_CITY_LIMITS_FLAG VARCHAR2 (0)
SHIP_FROM_GEOCODE VARCHAR2 (0)
LINE_NUMBER NUMBER

TRX_LINE_TYPE VARCHAR2 (25)
INVENTORY_ITEM_ID NUMBER

PART_NUMBER VARCHAR2 (40)
QUANTITY NUMBER

QUANTITY_ORDERED NUMBER

UNIT_PRICE NUMBER

PRICE_OVERRIDE VARCHAR2 (0)
TAXABLE_FLAG VARCHAR2 (0)
CODE_COMBINATION_ID NUMBER

FOB_CODE VARCHAR2 (0)
PREVIOUS_TRX_LINE_ID VARCHAR2 (0)
USSGL_TRANSACTION_CODE VARCHAR2 (30)
USSGL_TRX_CODE_CONTEXT VARCHAR2 (30)
SHIP_TO_LOCATION_ID NUMBER

SHIP_TO_ORGANIZATION_ID NUMBER

SHIP_TO_WAREHOUSE_ID VARCHAR2 (0)
SHIP_TO_COUNTRY VARCHAR2 (60)
SHIP_TO_STATE VARCHAR2 (0)
SHIP_TO_COUNTY VARCHAR2 (0)
SHIP_TO_CITY VARCHAR2 (30)
SHIP_TO_PROVINCE VARCHAR2 (0)
SHIP_TO_POSTAL_CODE VARCHAR2 (30)
SHIP_TO_IN_CITY_LIMITS_FLAG VARCHAR2 (0)
SHIP_TO_GEOCODE VARCHAR2 (0)
POO_ADDRESS_CODE VARCHAR2 (0)
POA_ADDRESS_CODE VARCHAR2 (0)
TAX_CODE_ID NUMBER

TAX_CODE VARCHAR2 (0)
TAX_USER_OVERRIDE_FLAG VARCHAR2 (1)
TAX_RATE NUMBER

TOTAL_TAX_AMOUNT VARCHAR2 (0)
RECOVERABLE_TAX VARCHAR2 (0)
NONRECOVERABLE_TAX VARCHAR2 (0)
LOCATION_QUALIFIER VARCHAR2 (0)
COMPOUNDING_PRECEDENCE VARCHAR2 (0)
TAX_EXEMPTION_ID VARCHAR2 (0)
TAX_EXCEPTION_ID VARCHAR2 (0)
VENDOR_CONTROL_EXEMPTIONS VARCHAR2 (0)
TAX_RECOVERY_RATE NUMBER

TAX_RECOVERY_OVERRIDE_FLAG VARCHAR2 (1)
GLOBAL_ATTRIBUTE1 VARCHAR2 (0)
GLOBAL_ATTRIBUTE2 VARCHAR2 (0)
GLOBAL_ATTRIBUTE3 VARCHAR2 (0)
GLOBAL_ATTRIBUTE4 VARCHAR2 (0)
GLOBAL_ATTRIBUTE5 VARCHAR2 (0)
GLOBAL_NUMERIC_ATTRIBUTE1 VARCHAR2 (0)
GLOBAL_NUMERIC_ATTRIBUTE2 VARCHAR2 (0)
GLOBAL_NUMERIC_ATTRIBUTE3 VARCHAR2 (0)
GLOBAL_NUMERIC_ATTRIBUTE4 VARCHAR2 (0)
GLOBAL_NUMERIC_ATTRIBUTE5 VARCHAR2 (0)
TAX_EXEMPT_FLAG VARCHAR2 (0)
TAX_EXEMPT_NUMBER VARCHAR2 (0)
TAX_EXEMPT_REASON_CODE VARCHAR2 (0)
COMPANY_CODE VARCHAR2 (0)
DIVISION_CODE VARCHAR2 (0)
AUDIT_FLAG VARCHAR2 (0)
TAX_HEADER_LEVEL_FLAG VARCHAR2 (0)
TAX_ROUNDING_RULE VARCHAR2 (1)
TAX_TYPE VARCHAR2 (25)
TAX_DESCRIPTION VARCHAR2 (240)
ALLOW_TAX_CODE_OVERRIDE_FLAG VARCHAR2 (0)
PROJECT_ID NUMBER

TASK_ID NUMBER

EXPENDITURE_TYPE VARCHAR2 (30)
EXPENDITURE_ORGANIZATION_ID NUMBER

EXPENDITURE_ITEM_DATE DATE

PA_QUANTITY VARCHAR2 (0)
TAX_MINIMUM_ACCOUNTABLE_UNIT VARCHAR2 (0)
TAX_PRECISION VARCHAR2 (0)
AMOUNT_INCLUDES_TAX_FLAG VARCHAR2 (0)
TAX_CALCULATED_FLAG VARCHAR2 (0)
TAX_RECOVERABLE_FLAG VARCHAR2 (0)
CURRENCY_UNIT_PRICE NUMBER

[top of page]

APPS.JG_PO_REQ_TAX_LINES_SUMMARY_V references the following:

APPS
SYNONYM - AP_TAX_CODES
SYNONYM - AR_TAX_GROUP_CODES
SYNONYM - FINANCIALS_SYSTEM_PARAMETERS
SYNONYM - FND_CURRENCIES
PACKAGE - HR_GENERAL
VIEW - HR_LOCATIONS
SYNONYM - MTL_CATEGORIES
SYNONYM - MTL_SYSTEM_ITEMS
SYNONYM - PO_LINE_TYPES
SYNONYM - PO_REQUISITION_HEADERS
SYNONYM - PO_REQUISITION_LINES
SYNONYM - PO_REQ_DISTRIBUTIONS
VIEW - PO_VENDORS
VIEW - PO_VENDOR_SITES

APPS.JG_PO_REQ_TAX_LINES_SUMMARY_V is not referenced by any database object

[top of page]

View: JG_PO_TAX_LINES_SUMMARY_V

Comments
***** Warning: Oracle Internal Use Only *****

Oracle Corporation does not support access to Oracle applications data using this object, except from standard Oracle Applications programs.

View Type

Internal

Columns
Name Datatype Length Mandatory Comments
TRX_HEADER_ID NUMBER

TRX_LINE_ID NUMBER

TRX_SHIPMENT_ID NUMBER

TRX_DISTRIBUTION_ID NUMBER

TAX_LINE_NUMBER VARCHAR2 (0)
SET_OF_BOOKS_ID NUMBER (15)
REQUEST_ID NUMBER

TRX_NUMBER VARCHAR2 (20)
PREVIOUS_TRX_HEADER_ID VARCHAR2 (0)
TRX_DATE DATE

TRX_CURRENCY_CODE VARCHAR2 (15)
EXCHANGE_RATE NUMBER

MINIMUM_ACCOUNTABLE_UNIT NUMBER

PRECISION NUMBER (1)
SHIP_FROM_SUPPLIER_ID NUMBER

SHIP_FROM_SUPPLIER_NUMBER VARCHAR2 (0)
SHIP_FROM_SUPPLIER_NAME VARCHAR2 (240)
SHIP_FROM_SITE_USE_ID NUMBER

SHIP_FROM_COUNTRY VARCHAR2 (25)
SHIP_FROM_STATE VARCHAR2 (150)
SHIP_FROM_COUNTY VARCHAR2 (150)
SHIP_FROM_CITY VARCHAR2 (0)
SHIP_FROM_PROVINCE VARCHAR2 (0)
SHIP_FROM_POSTAL_CODE VARCHAR2 (20)
SHIP_FROM_IN_CITY_LIMITS_FLAG VARCHAR2 (0)
SHIP_FROM_GEOCODE VARCHAR2 (0)
LINE_NUMBER NUMBER

TRX_LINE_TYPE VARCHAR2 (25)
INVENTORY_ITEM_ID NUMBER

PART_NUMBER VARCHAR2 (40)
QUANTITY NUMBER

QUANTITY_ORDERED NUMBER

UNIT_PRICE NUMBER

PRICE_OVERRIDE NUMBER

TAXABLE_FLAG VARCHAR2 (1)
CODE_COMBINATION_ID NUMBER

FOB_CODE VARCHAR2 (25)
PREVIOUS_TRX_LINE_ID VARCHAR2 (0)
USSGL_TRANSACTION_CODE VARCHAR2 (30)
USSGL_TRX_CODE_CONTEXT VARCHAR2 (30)
SHIP_TO_LOCATION_ID NUMBER

SHIP_TO_ORGANIZATION_ID NUMBER

SHIP_TO_WAREHOUSE_ID VARCHAR2 (0)
SHIP_TO_COUNTRY VARCHAR2 (60)
SHIP_TO_STATE VARCHAR2 (0)
SHIP_TO_COUNTY VARCHAR2 (0)
SHIP_TO_CITY VARCHAR2 (30)
SHIP_TO_PROVINCE VARCHAR2 (0)
SHIP_TO_POSTAL_CODE VARCHAR2 (30)
SHIP_TO_IN_CITY_LIMITS_FLAG VARCHAR2 (0)
SHIP_TO_GEOCODE VARCHAR2 (0)
POO_ADDRESS_CODE VARCHAR2 (0)
POA_ADDRESS_CODE VARCHAR2 (0)
TAX_CODE_ID NUMBER

TAX_CODE VARCHAR2 (0)
TAX_USER_OVERRIDE_FLAG VARCHAR2 (1)
TAX_RATE NUMBER

TOTAL_TAX_AMOUNT VARCHAR2 (0)
RECOVERABLE_TAX VARCHAR2 (0)
NONRECOVERABLE_TAX VARCHAR2 (0)
LOCATION_QUALIFIER VARCHAR2 (0)
COMPOUNDING_PRECEDENCE VARCHAR2 (0)
TAX_EXEMPTION_ID VARCHAR2 (0)
TAX_EXCEPTION_ID VARCHAR2 (0)
VENDOR_CONTROL_EXEMPTIONS VARCHAR2 (0)
TAX_RECOVERY_RATE NUMBER

TAX_RECOVERY_OVERRIDE_FLAG VARCHAR2 (1)
GLOBAL_ATTRIBUTE1 VARCHAR2 (0)
GLOBAL_ATTRIBUTE2 VARCHAR2 (0)
GLOBAL_ATTRIBUTE3 VARCHAR2 (0)
GLOBAL_ATTRIBUTE4 VARCHAR2 (0)
GLOBAL_ATTRIBUTE5 VARCHAR2 (0)
GLOBAL_NUMERIC_ATTRIBUTE1 VARCHAR2 (0)
GLOBAL_NUMERIC_ATTRIBUTE2 VARCHAR2 (0)
GLOBAL_NUMERIC_ATTRIBUTE3 VARCHAR2 (0)
GLOBAL_NUMERIC_ATTRIBUTE4 VARCHAR2 (0)
GLOBAL_NUMERIC_ATTRIBUTE5 VARCHAR2 (0)
TAX_EXEMPT_FLAG VARCHAR2 (0)
TAX_EXEMPT_NUMBER VARCHAR2 (0)
TAX_EXEMPT_REASON_CODE VARCHAR2 (0)
COMPANY_CODE VARCHAR2 (0)
DIVISION_CODE VARCHAR2 (0)
AUDIT_FLAG VARCHAR2 (0)
TAX_HEADER_LEVEL_FLAG VARCHAR2 (0)
TAX_ROUNDING_RULE VARCHAR2 (1)
TAX_TYPE VARCHAR2 (25)
TAX_DESCRIPTION VARCHAR2 (240)
ALLOW_TAX_CODE_OVERRIDE_FLAG VARCHAR2 (0)
PROJECT_ID NUMBER

TASK_ID NUMBER

EXPENDITURE_TYPE VARCHAR2 (30)
EXPENDITURE_ORGANIZATION_ID NUMBER

EXPENDITURE_ITEM_DATE DATE

PA_QUANTITY VARCHAR2 (0)
TAX_MINIMUM_ACCOUNTABLE_UNIT VARCHAR2 (0)
TAX_PRECISION VARCHAR2 (0)
AMOUNT_INCLUDES_TAX_FLAG VARCHAR2 (0)
TAX_CALCULATED_FLAG VARCHAR2 (0)
TAX_RECOVERABLE_FLAG VARCHAR2 (0)

[top of page]

APPS.JG_PO_TAX_LINES_SUMMARY_V references the following:

APPS
SYNONYM - AP_TAX_CODES
SYNONYM - AR_TAX_GROUP_CODES
SYNONYM - FINANCIALS_SYSTEM_PARAMETERS
SYNONYM - FND_CURRENCIES
PACKAGE - HR_GENERAL
VIEW - HR_LOCATIONS
SYNONYM - MTL_CATEGORIES
SYNONYM - MTL_SYSTEM_ITEMS
SYNONYM - PO_DISTRIBUTIONS
SYNONYM - PO_HEADERS
SYNONYM - PO_LINES
SYNONYM - PO_LINE_LOCATIONS
SYNONYM - PO_LINE_TYPES
VIEW - PO_VENDORS
VIEW - PO_VENDOR_SITES

APPS.JG_PO_TAX_LINES_SUMMARY_V is not referenced by any database object

[top of page]

View: JG_ZZ_AP_BALANCES_V

Comments
View Type

A public view which may be useful for custom reporting or other data requirements.

View for vendor sub-ledger reports.

Columns
Name Datatype Length Mandatory Comments
SET_OF_BOOKS_ID NUMBER (15)
Accounting books identifier
CODE_COMBINATION_ID NUMBER (15)
Key flexfield combination identifier
CURRENCY_CODE VARCHAR2 (15)
Currency code
PERIOD_NAME VARCHAR2 (15)
Accounting period
VENDOR_ID NUMBER (15)
Vendor unique identifier
VENDOR_SITE_ID NUMBER (15)
Vendor site unique identifier
BEGIN_BAL_ENTERED_DR NUMBER

Accounting flexfield beginning debit balance in enterd currency
BEGIN_BAL_ENTERED_CR NUMBER

Accounting flexfield beginning credit balance in enterd currency
BEGIN_BAL_ACCOUNTED_DR NUMBER

Accounting flexfield beginning debit balance in base currency
BEGIN_BAL_ACCOUNTED_CR NUMBER

Accounting flexfield beginning credit balance in base currency
PERIOD_NET_ENTERED_DR NUMBER

Accounting flexfield period net debit balance in entered currency
PERIOD_NET_ENTERED_CR NUMBER

Accounting flexfield period net credit balance in entered currency
PERIOD_NET_ACCOUNTED_DR NUMBER

Accounting flexfield period net debit balance in base currency
PERIOD_NET_ACCOUNTED_CR NUMBER

Accounting flexfield period net credit balance in base currency
LAST_UPDATE_DATE DATE

Standard Who column
LAST_UPDATED_BY NUMBER (15)
Standard Who column
CREATION_DATE DATE

Standard Who column
CREATED_BY NUMBER (15)
Standard Who column
POSTED_TO_GL_FLAG VARCHAR2 (1)
Flag Indicating Balance Posted to General Ledger

[top of page]

APPS.JG_ZZ_AP_BALANCES_V references the following:

APPS
SYNONYM - JG_ZZ_AP_BALANCES
SYNONYM - JG_ZZ_AP_TMP_BAL

APPS.JG_ZZ_AP_BALANCES_V is not referenced by any database object

[top of page]

View: JG_ZZ_AP_CONTRA_V

Comments
***** Warning: Oracle Internal Use Only *****

Oracle Corporation does not support access to Oracle applications data using this object, except from standard Oracle Applications programs.

View Type

Internal

Columns
Name Datatype Length Mandatory Comments
SET_OF_BOOKS_ID NUMBER (15)
SET OF BOOKS ID
ACCOUNTING_EVENT_ID NUMBER (15)
CODE_COMBINATION_ID NUMBER (15)
LINE_NUMBER NUMBER

LINE_TYPE_CODE VARCHAR2 (30) Y
LINE_TYPE VARCHAR2 (25)
TAX_NAME VARCHAR2 (240)
DESCRIPTION VARCHAR2 (1996)
ACCOUNT VARCHAR2 (25)
ACCOUNT_DESC VARCHAR2 (240)
ENTERED_DR NUMBER

ENTERED_CR NUMBER

ACCOUNTED_DR NUMBER

ACCOUNTED_CR NUMBER

[top of page]

APPS.JG_ZZ_AP_CONTRA_V references the following:

APPS
SYNONYM - GL_CODE_COMBINATIONS
SYNONYM - JG_ZZ_AP_TMP_ACCOUNT
SYNONYM - XLA_AE_HEADERS
SYNONYM - XLA_AE_LINES
SYNONYM - XLA_EVENTS
SYNONYM - XLA_TRANSACTION_ENTITIES
VIEW - ZX_RATES_VL

APPS.JG_ZZ_AP_CONTRA_V is not referenced by any database object

[top of page]

View: JG_ZZ_AP_IR_REP_ITF_V

Comments
***** Warning: Oracle Internal Use Only *****

Oracle Corporation does not support access to Oracle applications data using this object, except from standard Oracle Applications programs.

View Type

Internal

Columns
Name Datatype Length Mandatory Comments
ROW_ID ROWID (10)
REQUEST_ID NUMBER (15) Y
CREATED_BY NUMBER (15) Y
CREATION_DATE DATE
Y
LAST_UPDATE_DATE DATE
Y
LAST_UPDATED_BY NUMBER (15)
LAST_UPDATE_LOGIN NUMBER (15)
FUNCTIONAL_CURRENCY_CODE VARCHAR2 (15)
ORGANIZATION_NAME VARCHAR2 (80)
INVOICE_ID NUMBER
Y
BATCH_ID NUMBER (15)
BATCH_NAME VARCHAR2 (50)
VENDOR_ID NUMBER (15)
SUPPLIER_NAME VARCHAR2 (240)
SUPPLIER_NAME_ALT VARCHAR2 (320)
SUPPLIER_NUMBER VARCHAR2 (30) Y
SUPPLIER_SITE VARCHAR2 (15) Y
INVOICE_NUM VARCHAR2 (50) Y
INVOICE_CURRENCY_CODE VARCHAR2 (15) Y
DOC_SEQUENCE_NAME VARCHAR2 (30)
DOC_SEQUENCE_VALUE NUMBER

INVOICE_DATE DATE

INVOICE_AMOUNT NUMBER

INVOICE_AMOUNT_REMAINING NUMBER

INVOICE_DESCRIPTION VARCHAR2 (240)
INVOICE_TYPE VARCHAR2 (80) Y
PAYMENT_METHOD VARCHAR2 (80) Y
LIABILITY_CCID NUMBER

LIABILITY_ACCOUNT VARCHAR2 (240)
LIABILITY_DESC VARCHAR2 (240)
LIABILITY_NATACC VARCHAR2 (240)
LIABILITY_NATACC_DESC VARCHAR2 (240)
LINE_NUMBER NUMBER

LINE_TYPE VARCHAR2 (80)
LINE_TYPE_DESCRIPTION VARCHAR2 (240)
LINE_AMOUNT NUMBER

INVOICE_DISTRIBUTION_ID NUMBER

DISTRIBUTION_TYPE VARCHAR2 (80)
DISTRIBUTION_LINE_NUMBER NUMBER (15)
DISTRIBUTION_LINE_AMOUNT NUMBER

DISTRIBUTION_DESCRIPTION VARCHAR2 (240)
DISTRIBUTION_ACCT_DATE DATE

INCOME_TAX_TYPE VARCHAR2 (10)
TAX_CODE VARCHAR2 (30)
TAX_RATE NUMBER

POSTED_FLAG VARCHAR2 (80)
DISTRIBUTION_CCID NUMBER

DISTRIBUTION_ACCOUNT VARCHAR2 (240)
DISTRIBUTION_ACCOUNT_DESC VARCHAR2 (240)
DISTRIBUTION_NATACC VARCHAR2 (240)
DISTRIBUTION_NATACC_DESC VARCHAR2 (240)

[top of page]

APPS.JG_ZZ_AP_IR_REP_ITF_V references the following:

APPS
SYNONYM - AP_BATCHES_ALL
SYNONYM - AP_INVOICES_ALL
SYNONYM - AP_INVOICE_DISTRIBUTIONS_ALL
SYNONYM - AP_INVOICE_LINES_ALL
VIEW - AP_LOOKUP_CODES
SYNONYM - AP_TAX_CODES_ALL
SYNONYM - FND_DOCUMENT_SEQUENCES
PACKAGE - FND_GLOBAL
SYNONYM - JG_ZZ_AP_IR_REP_ITF
VIEW - PO_VENDORS
VIEW - PO_VENDOR_SITES_ALL
SYNONYM - ZX_REC_NREC_DIST

APPS.JG_ZZ_AP_IR_REP_ITF_V is not referenced by any database object

[top of page]

View: JG_ZZ_AR_BALANCES_V

Comments
***** Warning: Oracle Internal Use Only *****

Oracle Corporation does not support access to Oracle applications data using this object, except from standard Oracle Applications programs.

View Type

Internal

Columns
Name Datatype Length Mandatory Comments
SET_OF_BOOKS_ID NUMBER (15)
Accounting books identifier
CODE_COMBINATION_ID NUMBER (15)
Key flexfield combination identifier
CURRENCY_CODE VARCHAR2 (15)
Currency
PERIOD_NAME VARCHAR2 (15)
Accounting period
CUSTOMER_ID NUMBER (15)
Customer unique identifier
CUSTOMER_SITE_ID NUMBER (15)
Customer site unique identifier
BEGIN_BAL_ENTERED_DR NUMBER

Accounting flexfield beginning debit balance in entered currency
BEGIN_BAL_ENTERED_CR NUMBER

Accounting flexfield beginning credit balance in entered currency
BEGIN_BAL_ACCOUNTED_DR NUMBER

Accounting flexfield beginning debit balance in base currency
BEGIN_BAL_ACCOUNTED_CR NUMBER

Accounting flexfield beginning credit balance in base currency
PERIOD_NET_ENTERED_DR NUMBER

Accounting flexfield period net debit balance in entered currency
PERIOD_NET_ENTERED_CR NUMBER

Accounting flexfield period net credit balance in entered currency
PERIOD_NET_ACCOUNTED_DR NUMBER

Accounting flexfield period net debit balance in base currency
PERIOD_NET_ACCOUNTED_CR NUMBER

Accounting flexfield period net credit balance in base currency
LAST_UPDATE_DATE DATE

Standard Who column
LAST_UPDATED_BY NUMBER (15)
Standard Who column
CREATION_DATE DATE

Standard Who column
CREATED_BY NUMBER (15)
Standard Who column
POSTED_TO_GL_FLAG VARCHAR2 (1)
Flag indicating balance posted to General Ledger

[top of page]

APPS.JG_ZZ_AR_BALANCES_V references the following:

APPS
SYNONYM - JG_ZZ_AR_BALANCES
SYNONYM - JG_ZZ_AR_TMP_BAL

APPS.JG_ZZ_AR_BALANCES_V is not referenced by any database object

[top of page]

View: JG_ZZ_ENTERED_CURRENCIES_V

Comments
***** Warning: Oracle Internal Use Only *****

Oracle Corporation does not support access to Oracle applications data using this object, except from standard Oracle Applications programs.

View Type

Internal

Columns
Name Datatype Length Mandatory Comments
CURRENCY_TYPE CHAR (1)
CURRENCY_CODE VARCHAR2 (80)

[top of page]

APPS.JG_ZZ_ENTERED_CURRENCIES_V references the following:

APPS
SYNONYM - FND_CURRENCIES
VIEW - GL_LOOKUPS

APPS.JG_ZZ_ENTERED_CURRENCIES_V is not referenced by any database object

[top of page]

View: JG_ZZ_ENTITY_ASSOC_V

Comments
View Type

A multi-org view which will retrive data for your current operating unit and ignore data in other operating units.

This view is primarily used by Business Entity Relationships form

Columns
Name Datatype Length Mandatory Comments
ROW_ID ROWID (10)
Database row identifier
ENTITY_ASSOCIATION_ID NUMBER (15) Y Business entity relationship identifier
PRIMARY_ID_NUMBER VARCHAR2 (30) Y Primary identity number
ASSOCIATED_ENTITY_ID NUMBER
Y Associated entity identity number
ASSOCIATED_ENTITY_NAME VARCHAR2 (240)
Associated entity name
ID_TYPE VARCHAR2 (30) Y Identity type
ID_TYPE_DSP VARCHAR2 (80) Y Identity type for display
ID_NUMBER VARCHAR2 (30) Y Identity number
DESCRIPTION VARCHAR2 (240)
Description
EFFECTIVE_DATE DATE
Y Effective date
INEFFECTIVE_DATE DATE

Ineffective date
ATTRIBUTE_CATEGORY VARCHAR2 (30)
Descriptive Flexfield Structure Defining column
ATTRIBUTE1 VARCHAR2 (150)
Descriptive Flexfield Segment column
ATTRIBUTE2 VARCHAR2 (150)
Descriptive Flexfield Segment column
ATTRIBUTE3 VARCHAR2 (150)
Descriptive Flexfield Segment column
ATTRIBUTE4 VARCHAR2 (150)
Descriptive Flexfield Segment column
ATTRIBUTE5 VARCHAR2 (150)
Descriptive Flexfield Segment column
ATTRIBUTE6 VARCHAR2 (150)
Descriptive Flexfield Segment column
ATTRIBUTE7 VARCHAR2 (150)
Descriptive Flexfield Segment column
ATTRIBUTE8 VARCHAR2 (150)
Descriptive Flexfield Segment column
ATTRIBUTE9 VARCHAR2 (150)
Descriptive Flexfield Segment column
ATTRIBUTE10 VARCHAR2 (150)
Descriptive Flexfield Segment column
ATTRIBUTE11 VARCHAR2 (150)
Descriptive Flexfield Segment column
ATTRIBUTE12 VARCHAR2 (150)
Descriptive Flexfield Segment column
ATTRIBUTE13 VARCHAR2 (150)
Descriptive Flexfield Segment column
ATTRIBUTE14 VARCHAR2 (150)
Descriptive Flexfield Segment column
ATTRIBUTE15 VARCHAR2 (150)
Descriptive Flexfield Segment column
ATTRIBUTE16 VARCHAR2 (150)
Descriptive Flexfield Segment column
ATTRIBUTE17 VARCHAR2 (150)
Descriptive Flexfield Segment column
ATTRIBUTE18 VARCHAR2 (150)
Descriptive Flexfield Segment column
ATTRIBUTE19 VARCHAR2 (150)
Descriptive Flexfield Segment column
ATTRIBUTE20 VARCHAR2 (150)
Descriptive Flexfield Segment column
CREATED_BY NUMBER (15) Y Standard Who Column
CREATION_DATE DATE
Y Standard Who Column
LAST_UPDATED_BY NUMBER (15) Y Standard Who Column
LAST_UPDATE_DATE DATE
Y Standard Who Column
LAST_UPDATE_LOGIN NUMBER (15)
Standard Who Column

[top of page]

APPS.JG_ZZ_ENTITY_ASSOC_V references the following:

APPS
PACKAGE - FND_GLOBAL
VIEW - FND_LOOKUPS
SYNONYM - JG_ZZ_ENTITY_ASSOC
VIEW - PO_VENDORS

APPS.JG_ZZ_ENTITY_ASSOC_V is not referenced by any database object

[top of page]

View: JG_ZZ_II_INT_RATES

Comments
View Type

A multi-org view which will retrive data for your current operating unit and ignore data in other operating units.

Columns
Name Datatype Length Mandatory Comments
LOOKUP_TYPE VARCHAR2 (30) Y
LOOKUP_CODE VARCHAR2 (30) Y
MEANING NUMBER
Y
DESCRIPTION VARCHAR2 (240)
ENABLED_FLAG VARCHAR2 (1) Y
START_DATE_ACTIVE DATE

END_DATE_ACTIVE DATE

CREATED_BY NUMBER (15) Y Standard Who column
CREATION_DATE DATE
Y Standard Who column
LAST_UPDATED_BY NUMBER (15) Y Standard Who column
LAST_UPDATE_LOGIN NUMBER (15)
Standard Who column
LAST_UPDATE_DATE DATE
Y Standard Who column
ORG_ID NUMBER (15)

[top of page]

APPS.JG_ZZ_II_INT_RATES references the following:

APPS
SYNONYM - JG_ZZ_II_INT_RATES_ALL

APPS.JG_ZZ_II_INT_RATES is not referenced by any database object

[top of page]

View: JG_ZZ_SRS_LEDGER_BUD_ENCUM_V

Comments
***** Warning: Oracle Internal Use Only *****

Oracle Corporation does not support access to Oracle applications data using this object, except from standard Oracle Applications programs.

View Type

Internal

Columns
Name Datatype Length Mandatory Comments
BUDGET_ENCUMBRANCE_NAME VARCHAR2 (80)
BUDGET_ENCUMBRANCE_ID NUMBER

LEDGER_ID VARCHAR2 (40)
ACTUAL_FLAG CHAR (1)

[top of page]

APPS.JG_ZZ_SRS_LEDGER_BUD_ENCUM_V references the following:

APPS
SYNONYM - GL_BUDGETS
SYNONYM - GL_BUDGET_PERIOD_RANGES
SYNONYM - GL_BUDGET_VERSIONS
SYNONYM - GL_ENCUMBRANCE_TYPES
VIEW - GL_LOOKUPS

APPS.JG_ZZ_SRS_LEDGER_BUD_ENCUM_V is not referenced by any database object

[top of page]

View: JG_ZZ_SRS_LEDGER_PER_START_V

Comments
***** Warning: Oracle Internal Use Only *****

Oracle Corporation does not support access to Oracle applications data using this object, except from standard Oracle Applications programs.

View Type

Internal

Columns
Name Datatype Length Mandatory Comments
PERIOD_NUM NUMBER (15)
PERIOD_NAME VARCHAR2 (15)
PERIOD_YEAR NUMBER (15)
EFFECTIVE_PERIOD_NUM NUMBER

LEDGER_ID NUMBER (15)
BUDGET_ENCUMBRANCE_ID NUMBER

ACTUAL_FLAG CHAR (1)

[top of page]

APPS.JG_ZZ_SRS_LEDGER_PER_START_V references the following:

APPS
SYNONYM - GL_BUDGET_PERIOD_RANGES
SYNONYM - GL_LEDGERS
SYNONYM - GL_LEDGER_SET_ASSIGNMENTS
SYNONYM - GL_PERIODS
SYNONYM - GL_PERIOD_STATUSES

APPS.JG_ZZ_SRS_LEDGER_PER_START_V is not referenced by any database object

[top of page]

View: JG_ZZ_TA_ACCOUNT_RANGES_V

Comments
View Type

A supplementary view used to simplify forms coding.

Warning: Oracle does not recommend you query or alter datausing this view. It may change dramatically in subsequent minor or major releases.

Columns
Name Datatype Length Mandatory Comments
ROW_ID ROWID (10)
ACCOUNT_RANGE_ID NUMBER
Y
CC_RANGE_ID NUMBER
Y
ACCOUNT_RANGE_LOW VARCHAR2 (25) Y
ACCOUNT_RANGE_HIGH VARCHAR2 (25) Y
OFFSET_ACCOUNT VARCHAR2 (25)
CREATION_DATE DATE
Y
CREATED_BY NUMBER (15) Y
LAST_UPDATED_BY NUMBER (15) Y
LAST_UPDATE_DATE DATE
Y
LAST_UPDATE_LOGIN NUMBER (15)
CONTEXT VARCHAR2 (150)
ATTRIBUTE1 VARCHAR2 (150)
ATTRIBUTE2 VARCHAR2 (150)
ATTRIBUTE3 VARCHAR2 (150)
ATTRIBUTE4 VARCHAR2 (150)
ATTRIBUTE5 VARCHAR2 (150)
ATTRIBUTE6 VARCHAR2 (150)
ATTRIBUTE7 VARCHAR2 (150)
ATTRIBUTE8 VARCHAR2 (150)
ATTRIBUTE9 VARCHAR2 (150)
ATTRIBUTE10 VARCHAR2 (150)
ATTRIBUTE11 VARCHAR2 (150)
ATTRIBUTE12 VARCHAR2 (150)
ATTRIBUTE13 VARCHAR2 (150)
ATTRIBUTE14 VARCHAR2 (150)
ATTRIBUTE15 VARCHAR2 (150)

[top of page]

APPS.JG_ZZ_TA_ACCOUNT_RANGES_V references the following:

APPS
SYNONYM - JG_ZZ_TA_ACCOUNT_RANGES
APPS.JG_ZZ_TA_ACCOUNT_RANGES_V is referenced by following:

APPS
PACKAGE BODY - JG_ZZ_TA_CC_RANGES_PKG

[top of page]

View: JG_ZZ_TA_CC_RANGES_V

Comments
View Type

A supplementary view used to simplify forms coding.

Warning: Oracle does not recommend you query or alter datausing this view. It may change dramatically in subsequent minor or major releases.

Columns
Name Datatype Length Mandatory Comments
ROW_ID ROWID (10)
RULE_SET_ID NUMBER
Y
CC_RANGE_ID NUMBER
Y
CC_RANGE_LOW VARCHAR2 (25) Y
CC_RANGE_HIGH VARCHAR2 (25) Y
DESCRIPTION VARCHAR2 (25)
CREATION_DATE DATE
Y
CREATED_BY NUMBER (15) Y
LAST_UPDATED_BY NUMBER (15) Y
LAST_UPDATE_DATE DATE
Y
LAST_UPDATE_LOGIN NUMBER (15)
CONTEXT VARCHAR2 (150)
ATTRIBUTE1 VARCHAR2 (150)
ATTRIBUTE2 VARCHAR2 (150)
ATTRIBUTE3 VARCHAR2 (150)
ATTRIBUTE4 VARCHAR2 (150)
ATTRIBUTE5 VARCHAR2 (150)
ATTRIBUTE6 VARCHAR2 (150)
ATTRIBUTE7 VARCHAR2 (150)
ATTRIBUTE8 VARCHAR2 (150)
ATTRIBUTE9 VARCHAR2 (150)
ATTRIBUTE10 VARCHAR2 (150)
ATTRIBUTE11 VARCHAR2 (150)
ATTRIBUTE12 VARCHAR2 (150)
ATTRIBUTE13 VARCHAR2 (150)
ATTRIBUTE14 VARCHAR2 (150)
ATTRIBUTE15 VARCHAR2 (150)

[top of page]

APPS.JG_ZZ_TA_CC_RANGES_V references the following:

APPS
SYNONYM - JG_ZZ_TA_CC_RANGES
APPS.JG_ZZ_TA_CC_RANGES_V is referenced by following:

APPS
PACKAGE BODY - JG_ZZ_TA_RULE_SETS_PKG

[top of page]

View: JG_ZZ_TA_JE_LINES_V

Comments
***** Warning: Oracle Internal Use Only *****

Oracle Corporation does not support access to Oracle applications data using this object, except from standard Oracle Applications programs.

View Type

Internal

Columns
Name Datatype Length Mandatory Comments
ALLOC_ROW_ID ROWID (10)
ROW_ID ROWID (10)
STATUS VARCHAR2 (1) Y
JE_BATCH_ID NUMBER (15)
JE_HEADER_ID NUMBER (15) Y
ACTUAL_FLAG VARCHAR2 (1) Y
JE_HEADER_NAME VARCHAR2 (100) Y
JE_DOC_SEQUENCE_VALUE NUMBER

EXTERNAL_REFERENCE VARCHAR2 (80)
JE_DOC_SEQUENCE_NAME VARCHAR2 (30)
BUDGET_VERSION_ID NUMBER (15)
ENCUMBRANCE_TYPE_ID NUMBER (15)
CURRENCY_CODE VARCHAR2 (15) Y
CURRENCY_CONVERSION_TYPE VARCHAR2 (30) Y
CURRENCY_CONVERSION_DATE DATE

CURRENCY_CONVERSION_RATE NUMBER

PERIOD_NAME VARCHAR2 (15) Y
JE_BATCH_NAME VARCHAR2 (100) Y
JE_LINE_NUM NUMBER (15) Y
EFFECTIVE_DATE DATE
Y
ACCOUNTED_CR NUMBER

ACCOUNTED_DR NUMBER

ENTERED_CR NUMBER

ENTERED_DR NUMBER

LEDGER_ID NUMBER (15) Y
STAT_AMOUNT NUMBER

SUBLEDGER_DOC_SEQUENCE_ID NUMBER

SUBLEDGER_DOC_SEQUENCE_VALUE NUMBER

INVOICE_DATE DATE

TAX_CODE VARCHAR2 (15)
INVOICE_IDENTIFIER VARCHAR2 (20)
INVOICE_AMOUNT NUMBER

USSGL_TRANSACTION_CODE VARCHAR2 (30)
JGZZ_RECON_REF VARCHAR2 (240)
CONTEXT VARCHAR2 (150)
CONTEXT2 VARCHAR2 (150)
CONTEXT3 VARCHAR2 (150)
CONTEXT4 VARCHAR2 (150)
ATTRIBUTE1 VARCHAR2 (150)
ATTRIBUTE2 VARCHAR2 (150)
ATTRIBUTE3 VARCHAR2 (150)
ATTRIBUTE4 VARCHAR2 (150)
ATTRIBUTE5 VARCHAR2 (150)
ATTRIBUTE6 VARCHAR2 (150)
ATTRIBUTE7 VARCHAR2 (150)
ATTRIBUTE8 VARCHAR2 (150)
ATTRIBUTE9 VARCHAR2 (150)
ATTRIBUTE10 VARCHAR2 (150)
ATTRIBUTE11 VARCHAR2 (150)
ATTRIBUTE12 VARCHAR2 (150)
ATTRIBUTE13 VARCHAR2 (150)
ATTRIBUTE14 VARCHAR2 (150)
ATTRIBUTE15 VARCHAR2 (150)
ATTRIBUTE16 VARCHAR2 (150)
ATTRIBUTE17 VARCHAR2 (150)
ATTRIBUTE18 VARCHAR2 (150)
ATTRIBUTE19 VARCHAR2 (150)
ATTRIBUTE20 VARCHAR2 (150)
CODE_COMBINATION_ID NUMBER (15) Y
ACCOUNT_TYPE VARCHAR2 (1) Y
SEGMENT1 VARCHAR2 (25)
SEGMENT2 VARCHAR2 (25)
SEGMENT3 VARCHAR2 (25)
SEGMENT4 VARCHAR2 (25)
SEGMENT5 VARCHAR2 (25)
SEGMENT6 VARCHAR2 (25)
SEGMENT7 VARCHAR2 (25)
SEGMENT8 VARCHAR2 (25)
SEGMENT9 VARCHAR2 (25)
SEGMENT10 VARCHAR2 (25)
SEGMENT11 VARCHAR2 (25)
SEGMENT12 VARCHAR2 (25)
SEGMENT13 VARCHAR2 (25)
SEGMENT14 VARCHAR2 (25)
SEGMENT15 VARCHAR2 (25)
SEGMENT16 VARCHAR2 (25)
SEGMENT17 VARCHAR2 (25)
SEGMENT18 VARCHAR2 (25)
SEGMENT19 VARCHAR2 (25)
SEGMENT20 VARCHAR2 (25)
SEGMENT21 VARCHAR2 (25)
SEGMENT22 VARCHAR2 (25)
SEGMENT23 VARCHAR2 (25)
SEGMENT24 VARCHAR2 (25)
SEGMENT25 VARCHAR2 (25)
SEGMENT26 VARCHAR2 (25)
SEGMENT27 VARCHAR2 (25)
SEGMENT28 VARCHAR2 (25)
SEGMENT29 VARCHAR2 (25)
SEGMENT30 VARCHAR2 (25)
REQUEST_ID NUMBER (15)

[top of page]

APPS.JG_ZZ_TA_JE_LINES_V references the following:

APPS
SYNONYM - FND_DOCUMENT_SEQUENCES
SYNONYM - GL_CODE_COMBINATIONS
SYNONYM - GL_DAILY_CONVERSION_TYPES
SYNONYM - GL_JE_BATCHES
SYNONYM - GL_JE_HEADERS
SYNONYM - GL_JE_LINES
SYNONYM - GL_JE_LINES_RECON
SYNONYM - JG_ZZ_TA_ALLOCATED_LINES
APPS.JG_ZZ_TA_JE_LINES_V is referenced by following:

APPS
PACKAGE BODY - JG_ALLOCATE_JOURNALS_PKG
PACKAGE - JG_ALLOCATE_JOURNALS_PKG
PACKAGE BODY - JG_CREATE_JOURNALS_PKG

[top of page]

View: JG_ZZ_TA_RULE_LINES_V

Comments
View Type

A supplementary view used to simplify forms coding.

Warning: Oracle does not recommend you query or alter datausing this view. It may change dramatically in subsequent minor or major releases.

Columns
Name Datatype Length Mandatory Comments
ROW_ID ROWID (10)
ACCOUNT_RANGE_ID NUMBER
Y
RULE_LINE_ID NUMBER
Y
NATURAL_ACCOUNT VARCHAR2 (25) Y
ALLOCATION_PERCENT NUMBER
Y
OFFSET_ACCOUNT VARCHAR2 (25)
CREATION_DATE DATE
Y
CREATED_BY NUMBER (15) Y
LAST_UPDATED_BY NUMBER (15) Y
LAST_UPDATE_DATE DATE
Y
LAST_UPDATE_LOGIN NUMBER (15)
CONTEXT VARCHAR2 (150)
ATTRIBUTE1 VARCHAR2 (150)
ATTRIBUTE2 VARCHAR2 (150)
ATTRIBUTE3 VARCHAR2 (150)
ATTRIBUTE4 VARCHAR2 (150)
ATTRIBUTE5 VARCHAR2 (150)
ATTRIBUTE6 VARCHAR2 (150)
ATTRIBUTE7 VARCHAR2 (150)
ATTRIBUTE8 VARCHAR2 (150)
ATTRIBUTE9 VARCHAR2 (150)
ATTRIBUTE10 VARCHAR2 (150)
ATTRIBUTE11 VARCHAR2 (150)
ATTRIBUTE12 VARCHAR2 (150)
ATTRIBUTE13 VARCHAR2 (150)
ATTRIBUTE14 VARCHAR2 (150)
ATTRIBUTE15 VARCHAR2 (150)

[top of page]

APPS.JG_ZZ_TA_RULE_LINES_V references the following:

APPS
SYNONYM - JG_ZZ_TA_RULE_LINES
APPS.JG_ZZ_TA_RULE_LINES_V is referenced by following:

APPS
PACKAGE BODY - JG_ZZ_TA_ACCOUNT_RANGES_PKG

[top of page]

View: JG_ZZ_TA_RULE_SETS_V

Comments
View Type

A supplementary view used to simplify forms coding.

Warning: Oracle does not recommend you query or alter datausing this view. It may change dramatically in subsequent minor or major releases.

Columns
Name Datatype Length Mandatory Comments
ROW_ID ROWID (10)
RULE_SET_ID NUMBER
Y
NAME VARCHAR2 (100) Y
ID_FLEX_STRUCTURE_NAME VARCHAR2 (30) Y
PARTIAL_ALLOCATION VARCHAR2 (1) Y
ENABLED_FLAG VARCHAR2 (1) Y
ACCOUNT_TYPE VARCHAR2 (1)
ACCOUNT_TYPE_DISP VARCHAR2 (240)
CHART_OF_ACCOUNTS_ID NUMBER (15) Y
CREATION_DATE DATE
Y
CREATED_BY NUMBER (15) Y
LAST_UPDATED_BY NUMBER (15) Y
LAST_UPDATE_DATE DATE
Y
LAST_UPDATE_LOGIN NUMBER (15)
CONTEXT VARCHAR2 (150)
ATTRIBUTE1 VARCHAR2 (150)
ATTRIBUTE2 VARCHAR2 (150)
ATTRIBUTE3 VARCHAR2 (150)
ATTRIBUTE4 VARCHAR2 (150)
ATTRIBUTE5 VARCHAR2 (150)
ATTRIBUTE6 VARCHAR2 (150)
ATTRIBUTE7 VARCHAR2 (150)
ATTRIBUTE8 VARCHAR2 (150)
ATTRIBUTE9 VARCHAR2 (150)
ATTRIBUTE10 VARCHAR2 (150)
ATTRIBUTE11 VARCHAR2 (150)
ATTRIBUTE12 VARCHAR2 (150)
ATTRIBUTE13 VARCHAR2 (150)
ATTRIBUTE14 VARCHAR2 (150)
ATTRIBUTE15 VARCHAR2 (150)

[top of page]

APPS.JG_ZZ_TA_RULE_SETS_V references the following:

APPS
VIEW - FND_ID_FLEX_STRUCTURES_VL
VIEW - GL_LOOKUPS
SYNONYM - JG_ZZ_TA_RULE_SETS

APPS.JG_ZZ_TA_RULE_SETS_V is not referenced by any database object

[top of page]

View: JG_ZZ_VAT_ALLOC_RULES_V

Comments
View Type

A supplementary view used to simplify forms coding.

Warning: Oracle does not recommend you query or alter datausing this view. It may change dramatically in subsequent minor or major releases.

Columns
Name Datatype Length Mandatory Comments
ROW_ID ROWID (10)
ALLOCATION_RULE_ID NUMBER (15) Y
VAT_REPORTING_ENTITY_ID NUMBER (15) Y
SOURCE VARCHAR2 (30)
FINANCIAL_DOCUMENT_TYPE VARCHAR2 (20)
VAT_TRANSACTION_TYPE VARCHAR2 (30)
TAX_ID NUMBER (15)
TAX_CODE VARCHAR2 (50)
TAX_STATUS VARCHAR2 (30)
TAX_JURISDICTION_CODE VARCHAR2 (30)
TAX_RATE_CODE VARCHAR2 (50)
TAX_RATE_ID NUMBER (15)
TAX_BOX_RECOVERABLE VARCHAR2 (15)
TAX_BOX_NON_RECOVERABLE VARCHAR2 (15)
TAXABLE_BOX_RECOVERABLE VARCHAR2 (15)
TAXABLE_BOX_NON_RECOVERABLE VARCHAR2 (15)
TOTAL_BOX VARCHAR2 (15)
EFFECTIVE_FROM_DATE DATE

EFFECTIVE_TO_DATE DATE

PERIOD_TYPE VARCHAR2 (15)
CREATED_BY NUMBER (15) Y
CREATION_DATE DATE
Y
LAST_UPDATED_BY NUMBER (15) Y
LAST_UPDATE_DATE DATE
Y
LAST_UPDATE_LOGIN NUMBER (15)
TAX_REC_SIGN_FLAG VARCHAR2 (1)
TAX_NON_REC_SIGN_FLAG VARCHAR2 (1)
TAXABLE_REC_SIGN_FLAG VARCHAR2 (1)
TAXABLE_NON_REC_SIGN_FLAG VARCHAR2 (1)

[top of page]

APPS.JG_ZZ_VAT_ALLOC_RULES_V references the following:

APPS
SYNONYM - JG_ZZ_VAT_ALLOC_RULES

APPS.JG_ZZ_VAT_ALLOC_RULES_V is not referenced by any database object

[top of page]

View: JG_ZZ_VAT_DOC_SEQUENCES_V

Comments
View Type

A supplementary view used to simplify forms coding.

Warning: Oracle does not recommend you query or alter datausing this view. It may change dramatically in subsequent minor or major releases.

Columns
Name Datatype Length Mandatory Comments
ROW_ID ROWID (10)
VAT_DOC_SEQUENCE_ID NUMBER (15) Y
VAT_REGISTER_ID NUMBER (15) Y
DOC_SEQUENCE_ID NUMBER (15) Y
CREATED_BY NUMBER (15) Y
CREATION_DATE DATE
Y
LAST_UPDATED_BY NUMBER (15) Y
LAST_UPDATE_DATE DATE
Y
LAST_UPDATE_LOGIN NUMBER (15)

[top of page]

APPS.JG_ZZ_VAT_DOC_SEQUENCES_V references the following:

APPS
SYNONYM - JG_ZZ_VAT_DOC_SEQUENCES

APPS.JG_ZZ_VAT_DOC_SEQUENCES_V is not referenced by any database object

[top of page]

View: JG_ZZ_VAT_REGISTERS_VL

Comments
View Type

MultiLingual view (a language resolved view of the data.)

Columns
Name Datatype Length Mandatory Comments
ROW_ID ROWID (10)
VAT_REGISTER_ID NUMBER (15) Y
VAT_REPORTING_ENTITY_ID NUMBER (15) Y
REGISTER_TYPE VARCHAR2 (30)
REGISTER_NAME VARCHAR2 (50) Y
EFFECTIVE_FROM_DATE DATE

EFFECTIVE_TO_DATE DATE

LAST_UPDATE_DATE DATE
Y
LAST_UPDATED_BY NUMBER (15) Y
CREATION_DATE DATE
Y
CREATED_BY NUMBER (15) Y
LAST_UPDATE_LOGIN NUMBER (15)

[top of page]

APPS.JG_ZZ_VAT_REGISTERS_VL references the following:

APPS
SYNONYM - JG_ZZ_VAT_REGISTERS_B
SYNONYM - JG_ZZ_VAT_REGISTERS_TL
APPS.JG_ZZ_VAT_REGISTERS_VL is referenced by following:

APPS
PACKAGE BODY - JG_ZZ_JOURNAL_AP_PKG
PACKAGE BODY - JG_ZZ_JOURNAL_AR_PKG
PACKAGE BODY - JG_ZZ_VAT_REGISTERS_PKG
PACKAGE - JG_ZZ_VAT_REGISTERS_PKG

[top of page]

View: JG_ZZ_VAT_REP_ENTITIES_V

Comments
View Type

A supplementary view used to simplify forms coding.

Warning: Oracle does not recommend you query or alter datausing this view. It may change dramatically in subsequent minor or major releases.

Columns
Name Datatype Length Mandatory Comments
ROW_ID ROWID (10)
VAT_REPORTING_ENTITY_ID NUMBER (15) Y
LEGAL_ENTITY_ID NUMBER (15)
PARTY_ID NUMBER (15)
TAX_REGIME_CODE VARCHAR2 (30)
TAX_REGISTRATION_NUMBER VARCHAR2 (50)
TAX_CALENDAR_NAME VARCHAR2 (15)
ENABLE_ALLOCATIONS_FLAG VARCHAR2 (1)
ENABLE_ANNUAL_ALLOCATION_FLAG VARCHAR2 (1)
ENABLE_REGISTERS_FLAG VARCHAR2 (1)
ENABLE_REPORT_SEQUENCE_FLAG VARCHAR2 (1)
THRESHOLD_AMOUNT NUMBER

CREATED_BY NUMBER (15) Y
CREATION_DATE DATE
Y
LAST_UPDATED_BY NUMBER (15) Y
LAST_UPDATE_DATE DATE
Y
LAST_UPDATE_LOGIN NUMBER (15)
ENTITY_TYPE_CODE VARCHAR2 (30) Y
ENTITY_LEVEL_CODE VARCHAR2 (30) Y
LEDGER_ID NUMBER (15)
BALANCING_SEGMENT_VALUE VARCHAR2 (25)
MAPPING_VAT_REP_ENTITY_ID NUMBER (15)
ENTITY_IDENTIFIER VARCHAR2 (600)
DRIVING_DATE_CODE VARCHAR2 (30)
This column will hold the value for driving date for the relevant calendar/TRN

[top of page]

APPS.JG_ZZ_VAT_REP_ENTITIES_V references the following:

APPS
SYNONYM - JG_ZZ_VAT_REP_ENTITIES

APPS.JG_ZZ_VAT_REP_ENTITIES_V is not referenced by any database object

[top of page]
Copyright (c) 2001 - 2005, Oracle - Use Restricted by Contract