Oracle Global Finanicals Technical Reference(一)
来源:互联网 发布:ubuntu 制作deb安装包 编辑:程序博客网 时间:2024/06/07 05:55
Oracle Global Finanicals Oracle Global Financials Technical Reference Manual
Release 11i
Globalization Flexfields
This document describes the globalization flexfields that store certain pieces of country- and region-specific information in the Oracle Applications data model. It contains explanations of the meaning of flexfield segment columns in country- or region-specific contexts that you may need to reference to write custom reports or use for other data extraction.
Overview
The Oracle Applications data model stores information about each business entity used by Oracle Payables, Oracle Purchasing, and so on. For a given business entity, such as an AP Invoice, there are columns to hold attributes associated with a typical invoice as used throughout the world.
However, since statutory and practical requirements can differ from region to region, designing an economical data model can be challenging. One possible but unwieldy solution might require hundreds of additional columns to store attributes required in Argentina, Brazil, the Czech Republic. Instead, Oracle Applications uses a separate mechanism for storing certain pieces of country- or region-specific information about these business entities, the globalization flexfield, using standard flexfields technology.
A globalization flexfield is a pre-defined descriptive flexfield. Each major business entity table includes ten to twenty flexfield segment columns, with contexts for various countries or regions that require additional information about that entity. In turn, some pieces of country-specific code expect certain country-specific information to reside in particular generic segment columns.
To write custom reports against country-specific data, you need to know how to interpret data contained in these flexfield segment columns. For a given table, use the information in this section to see whether we have defined a country- or region-specific context and learn the meaning of segment columns whenever that context is active. Typically, the context is stored in the GLOBAL_ATTRIBUTE_CATEGORY column, and the generic segments are named GLOBAL_ATTRIBUTEn, where n is a number between 1 and 20. Refer to the appropriate TRM to confirm the names of these columns.
Note that this mechanism allows a single table to store information that spans the entire globe, where each individual table row can be associated with a different country- or region-specific context.
For example, suppose you are trying to write a custom report used in Brazil that includes information about freight carriers. With the Oracle Inventory Technical Reference Manual, you might learn that the ORG_FREIGHT table holds definitions for each freight carrier, and learn about the columns that hold generic information about freight carriers. In addition, you should refer to the information below to learn that the ORG_FREIGHT.GLOBAL_ATTRIBUTE5 column stores the Inscription Number whenever the GLOBAL_ATTRIBUTE_CATEGORY holds the context JL.BR.INVSDFCR.ORG_FREIGHT.
Warning:
You should not modify existing definitions or create new definitions; Oracle does not support changes or additions to any of the defnitions below.
For more information, see the Oracle Applications Flexfields Guide.
AP_AWT_TAX_RATES_ALL
AP_AWT_TAX_RATES_ALL contains tax rates for Withholding tax type tax codes. Oracle Payables predefines the Standard and Penalty tax rate types for withholding taxes. In addition, Certificate rate types are assigned to a specific supplier site and Exception rate types are assigned to a specific invoice. START_AMOUNT and END_AMOUNT columns are only used if the parent withholding tax uses amount ranges.
Flexfield: JG_AP_AWT_TAX_RATES
- Argentina Context: JL.AR.APXTADTC.TAX_RATES
This table shows the column names and field prompts for this context.
GLOBAL_ATTRIBUTE1
Amount to Subtract from Taxable Base
GLOBAL_ATTRIBUTE2
Amount to Add to Withholding
AP_BANK_ACCOUNTS_ALL
AP_BANK_ACCOUNTS_ALL contains information about your bank accounts. You need one row for each bank account you define. Each bank account must be affiliated with one bank branch. When you initiate an automatic payment batch, enter a manual check, or create a Quick payment, you can select a bank account that you define in this table.
This table corresponds to the Bank Accounts window.
Flexfield: JG_AP_BANK_ACCOUNTS
- Brazil Context: JL.BR.APXSUMBA.AR.Additional
This table shows the column names and field prompts for this context.
GLOBAL_ATTRIBUTE1
Collection Remittance Media
GLOBAL_ATTRIBUTE2
Collection Format Program
GLOBAL_ATTRIBUTE3
Factoring Remittance Media
GLOBAL_ATTRIBUTE4
Factoring Format Program
GLOBAL_ATTRIBUTE5
Occurrence Report Format Program
GLOBAL_ATTRIBUTE6
Occurrence File Format Program
GLOBAL_ATTRIBUTE7
Company Code for Bank
- Denmark Context: JE.DK.APXSUMBA.INT.EDI_INFO
This table shows the column names and field prompts for this context.
GLOBAL_ATTRIBUTE1
Communication Agreement ID
GLOBAL_ATTRIBUTE2
Bank Code
GLOBAL_ATTRIBUTE3
UBT-Number
GLOBAL_ATTRIBUTE4
User Name
GLOBAL_ATTRIBUTE5
Password
GLOBAL_ATTRIBUTE6
Sender Identification
- Denmark Context: JE.DK.APXSUMBA.SUP.EDI_INFO
This table shows the column names and field prompts for this context.
GLOBAL_ATTRIBUTE1
Payment Means
GLOBAL_ATTRIBUTE2
Payment Channel
GLOBAL_ATTRIBUTE3
Country Code
GLOBAL_ATTRIBUTE4
Bank Code
GLOBAL_ATTRIBUTE5
Import Code
GLOBAL_ATTRIBUTE6
Agreement Type
GLOBAL_ATTRIBUTE7
Agreement Number
GLOBAL_ATTRIBUTE8
Settlement Code
GLOBAL_ATTRIBUTE9
Short Notice
GLOBAL_ATTRIBUTE10
Bank Notice
GLOBAL_ATTRIBUTE18
Payment CategoryID
GLOBAL_ATTRIBUTE19
dummy
GLOBAL_ATTRIBUTE20
Payment Category
- Germany Context: JE.DE.APXSUMBA.DD_CODE
This table shows the column name and field prompt for this context.
GLOBAL_ATTRIBUTE1
Direct Debit Authorization Code
- Sweden Context: JE.SE.APXSUMBA.PAYMENT_TYPE
This table shows the column name and field prompt for this context.
GLOBAL_ATTRIBUTE1
Payment Type
AP_BANK_BRANCHES
AP_BANK_BRANCHES contains information about the bank branches you define when you set up your banks. You need one row for each bank branch you use. One bank branch may have multiple bank accounts.
This table corresponds to the Bank Branch region of the Banks window.
Flexfield: JG_AP_BANK_BRANCHES
- Brazil Context: JL.BR.APXSUMBA.AR.Additional
This table shows the column name and field prompt for this context.
GLOBAL_ATTRIBUTE1
Maximum Number of Collection Documents
- Colombia Context: JL.CO.APXSUMBA.BANKS
This table shows the column names and field prompts for this context.
GLOBAL_ATTRIBUTE10
Primary ID Type
GLOBAL_ATTRIBUTE11
Primary ID Number
GLOBAL_ATTRIBUTE12
Primary ID Validation Digit
GLOBAL_ATTRIBUTE13
Primary ID Branch
GLOBAL_ATTRIBUTE14
Primary ID Bank Name
- Spain Context: JE.ES.APXSUMBA.BANK_INFO
This table shows the column name and field prompt for this context.
GLOBAL_ATTRIBUTE1
Taxpayer ID
AP_CHECKS_ALL
AP_CHECKS_ALL stores information about payments issued to suppliers or refunds received from suppliers. You need one row for each payment you issue to a supplier or refund received from a supplier. Your Oracle Payables application uses this information to record payments you make to suppliers or refunds you receive from suppliers. Your Oracle Payables application stores the supplier name and bank account name for auditing purposes, in case either one is changed after you create the payment. Your Oracle Payables application stores address information for all payments. If you allow changes to the supplier payment address on manual payments or Quick payments, your Oracle Payables application maintains the new address information in this table. Your Oracle Payables application uses BANK_ACCOUNT_NUM, BANK_NUM, and BANK_ACCOUNT_TYPE for the supplier's bank information when you use the Electronic payment method. Your Oracle Payables application stores a dummy value for CHECK_STOCK_ID for refunds, thus, CHECK_STOCK_ID should not be treated as a foreign key to AP_CHECK_STOCKS_ALL in the case of refunds.
Flexfield: JG_AP_CHECKS
- Thailand Context: JA.TH.APXPAWKB.CHECKS
This table shows the column names and field prompts for this context.
GLOBAL_ATTRIBUTE1
Tax Invoice Number
GLOBAL_ATTRIBUTE2
Tax Invoice Date
GLOBAL_ATTRIBUTE3
Supplier Tax Invoice Number
GLOBAL_ATTRIBUTE4
Tax Accounting Period
GLOBAL_ATTRIBUTE5
Payment Delivery Date
AP_EXPENSE_REPORT_HEADERS_ALL
AP_EXPENSE_REPORTS_HEADERS_ALL stores header information about the expense reports entered in Oracle Payables and Oracle Self-Service Expenses.
There is one row for each expense report you enter. Your Oracle Payables application uses this information to create invoice header information when you transfer expense reports to invoice tables. Transfer expense reports to invoice tables using the Payables Invoice Import Program.
Your Oracle Payables application places the invoice ID in the VOUCHNO column when you transfer an expense report. To import invoices from an external source, Oracle recommends that you use the new Payables Open Interface tables.
This table corresponds to the header region of the Expense Reports window.
Flexfield: JG_AP_EXPENSE_REPORT_HEADERS
- Thailand Context: JA.TH.APXXXEER.REPORT_HEADERS
This table shows the column names and field prompts for this context.
GLOBAL_ATTRIBUTE1
Tax Invoice Number
GLOBAL_ATTRIBUTE2
Tax Invoice Date
GLOBAL_ATTRIBUTE3
Supplier Tax Invoice Number
GLOBAL_ATTRIBUTE4
Tax Accounting Period
AP_INVOICES_ALL
AP_INVOICES_ALL contains records for invoices you enter. There is one row for each invoice you enter. An invoice can have one or more invoice distribution lines. An invoice can also have one or more scheduled payments.
An invoice of type EXPENSE REPORT must relate to a row in AP_EXPENSE_REPORT_HEADERS_ALL unless the record has been purged from AP_EXPENSE_REPORT_HEADERS_ALL. Your Oracle Payables application uses the INTEREST type invoice for interest that it calculates on invoices that are overdue. Your Oracle Payables application links the interest invoice to the original invoice by inserting the INVOICE_ID in the AP_INVOICE_RELATIONSHIPS table.
This table corresponds to the Invoices window.
Flexfield: JG_AP_INVOICES
- Argentina Context: JL.AR.APXINWKB.INVOICES
This table shows the column names and field prompts for this context.
GLOBAL_ATTRIBUTE10
Destination Code
GLOBAL_ATTRIBUTE11
Legal Transaction Category
GLOBAL_ATTRIBUTE12
Transaction Letter
GLOBAL_ATTRIBUTE13
Tax Authority Transaction Type
GLOBAL_ATTRIBUTE14
Customs Code
GLOBAL_ATTRIBUTE15
Customs Issue Date
GLOBAL_ATTRIBUTE16
Customs Issue Number
GLOBAL_ATTRIBUTE17
Tax Inclusive
GLOBAL_ATTRIBUTE18
Ship To Location
GLOBAL_ATTRIBUTE19
CAI Number
GLOBAL_ATTRIBUTE20
CAI Due Date
- Brazil Context: JL.BR.APXINWKB.AP_INVOICES
This table shows the column names and field prompts for this context.
GLOBAL_ATTRIBUTE1
Collection Document Association
GLOBAL_ATTRIBUTE2
Operation Fiscal Code
GLOBAL_ATTRIBUTE3
Series
GLOBAL_ATTRIBUTE4
Class
GLOBAL_ATTRIBUTE5
ICMS Base Amount
GLOBAL_ATTRIBUTE6
ICMS Name
GLOBAL_ATTRIBUTE7
ICMS Amount
GLOBAL_ATTRIBUTE8
IPI Amount
GLOBAL_ATTRIBUTE10
Consolidated Invoice Number
- Chile Context: JL.CL.APXINWKB.AP_INVOICES
This table shows the column name and field prompt for this context.
GLOBAL_ATTRIBUTE19
Document Type
- Colombia Context: JL.CO.APXINWKB.INVOICES
This table shows the column name and field prompt for this context.
GLOBAL_ATTRIBUTE18
Ship To Location
- Czech Republic Context: JE.CZ.APXINWKB.INVOICE_INFO
This table shows the column names and field prompts for this context.
GLOBAL_ATTRIBUTE1
Tax Date
GLOBAL_ATTRIBUTE2
VAT Register transaction reported on
GLOBAL_ATTRIBUTE3
Import Document Number
GLOBAL_ATTRIBUTE4
Import Document Date
GLOBAL_ATTRIBUTE5
Data Type
GLOBAL_ATTRIBUTE6
Constant Symbol
GLOBAL_ATTRIBUTE7
Specific Symbol
- Denmark Context: JE.DK.APXINWKB.EDI_INFO
This table shows the column names and field prompts for this context.
GLOBAL_ATTRIBUTE1
Payment Means
GLOBAL_ATTRIBUTE2
Payment Channel
GLOBAL_ATTRIBUTE3
Country Code
GLOBAL_ATTRIBUTE4
Party ID
GLOBAL_ATTRIBUTE5
Import Code
GLOBAL_ATTRIBUTE6
Supplier Message
GLOBAL_ATTRIBUTE7
Import Code Specification
GLOBAL_ATTRIBUTE8
Settlement Code
GLOBAL_ATTRIBUTE18
Payment categoryID
GLOBAL_ATTRIBUTE19
dummy
GLOBAL_ATTRIBUTE20
Payment Category
- France Context: JE.FR.APXINWKB.TAX_RULE
This table shows the column name and field prompt for this context.
GLOBAL_ATTRIBUTE1
Deduction Tax Rule
- Hungary Context: JE.HU.APXINWKB.TAX_DATE
This table shows the column name and field prompt for this context.
GLOBAL_ATTRIBUTE1
Tax Date
- Poland Context: JE.PL.APXINWKB.INVOICE_INFO
This table shows the column names and field prompts for this context.
GLOBAL_ATTRIBUTE1
VAT Date
GLOBAL_ATTRIBUTE2
VAT_REGISTER
- Singapore Context: JA.SG.APXINWKB.INVOICES
This table shows the column name and field prompt for this context.
GLOBAL_ATTRIBUTE1
Supplier Exchange Rate
- Spain Context: JE.ES.APXINWKB.MODELO347
This table shows the column name and field prompt for this context.
GLOBAL_ATTRIBUTE1
Invoice Type
- Spain Context: JE.ES.APXINWKB.MODELO347PR
This table shows the column name and field prompt for this context.
GLOBAL_ATTRIBUTE1
Invoice Type
- Spain Context: JE.ES.APXINWKB.MODELO349
This table shows the column names and field prompts for this context.
GLOBAL_ATTRIBUTE1
Invoice Type
GLOBAL_ATTRIBUTE2
Year Corrected
GLOBAL_ATTRIBUTE3
Period Corrected
- Spain Context: JE.ES.APXINWKB.MODELO415
This table shows the column name and field prompt for this context.
GLOBAL_ATTRIBUTE1
Invoice Type
- Spain Context: JE.ES.APXINWKB.MODELO415_347
This table shows the column name and field prompt for this context.
GLOBAL_ATTRIBUTE1
Invoice Type
- Spain Context: JE.ES.APXINWKB.MODELO415_347PR
This table shows the column name and field prompt for this context.
GLOBAL_ATTRIBUTE1
Invoice Type
- Spain Context: JE.ES.APXINWKB.OTHER
This table shows the column name and field prompt for this context.
GLOBAL_ATTRIBUTE1
Invoice Type
- Spain Context: JE.ES.APXINWKB.INVOICE_INFO
This context is disabled and no longer used.
- Taiwan Context: JA.TW.APXINWKB.INVOICES
This table shows the column names and field prompts for this context.
GLOBAL_ATTRIBUTE1
Government Uniform Invoice Type
GLOBAL_ATTRIBUTE2
Wine/Cigarette
GLOBAL_ATTRIBUTE3
Deductible Type
GLOBAL_ATTRIBUTE4
Print Date
- Thailand Context: JA.TH.APXINWKB.INVOICES
This table shows the column names and field prompts for this context.
GLOBAL_ATTRIBUTE1
Tax Invoice Number
GLOBAL_ATTRIBUTE2
Tax Invoice Date
GLOBAL_ATTRIBUTE3
Supplier Tax Invoice Number
GLOBAL_ATTRIBUTE4
Tax Accounting Period
AP_INVOICES_INTERFACE
AP_INVOICES_INTERFACE stores header information about invoices that you create or load for import. The invoice data can come from the following sources: EDI invoices from your suppliers that you load through Oracle e-Commerce Gateway, invoices that you load using Oracle SQL*Loader, lease invoices from Property Manager credit card transaction data that you load using the Credit Card Invoice Interface Summary and invoices that you enter through the Invoice Gateway. There is one row for each invoice you import. Your Oracle Payables application uses this information to create invoice header information when you submit the Payables Open Interface program.
AP_INVOICES_INTERFACE contains a unique invoice ID which is used to interface with AP_INVOICES_ALL.
Flexfield: JG_AP_INVOICES_INTERFACE
- Argentina Context: JL.AR.APXIISIM.INVOICES_FOLDER
This table shows the column names and field prompts for this context.
GLOBAL_ATTRIBUTE11
Legal Transaction Category
GLOBAL_ATTRIBUTE12
Transaction Letter
GLOBAL_ATTRIBUTE13
Tax Authority Transaction Type
GLOBAL_ATTRIBUTE14
Customs Code
GLOBAL_ATTRIBUTE15
Customs Issue Date
GLOBAL_ATTRIBUTE16
Customs Issue Number
GLOBAL_ATTRIBUTE17
Tax Inclusive
- Belgium Context: JE.BE.APXIISIM.EFT
This table shows the column name and field prompt for this context.
GLOBAL_ATTRIBUTE1
IBLC Code
- Brazil Context: JL.BR.APXIISIM.INVOICES_FOLDER
This table shows the column names and field prompts for this context.
GLOBAL_ATTRIBUTE1
Collection Document Association
GLOBAL_ATTRIBUTE2
Operation Fiscal Code
GLOBAL_ATTRIBUTE3
Series
GLOBAL_ATTRIBUTE4
Class
GLOBAL_ATTRIBUTE5
ICMS Base Amount
GLOBAL_ATTRIBUTE6
ICMS Name
GLOBAL_ATTRIBUTE7
ICMS Amount
GLOBAL_ATTRIBUTE8
IPI Amount
GLOBAL_ATTRIBUTE10
Consolidated Invoice Number
- Chile Context: JL.CL.APXIISIM.INVOICES_FOLDER
This table shows the column name and field prompt for this context.
GLOBAL_ATTRIBUTE19
Document Type
- Czech Republic Context: JE.CZ.APXIISIM.INVOICE_INFO
This table shows the column names and field prompts for this context.
GLOBAL_ATTRIBUTE1
Tax Date
GLOBAL_ATTRIBUTE2
VAT Register transaction reported on
GLOBAL_ATTRIBUTE3
Import Document Number
GLOBAL_ATTRIBUTE4
Import Document Date
GLOBAL_ATTRIBUTE5
Data Type
GLOBAL_ATTRIBUTE6
Constant Symbol
GLOBAL_ATTRIBUTE7
Specific Symbol
- Denmark Context: JE.DK.APXIISIM.EDI_INFO
This table shows the column names and field prompts for this context.
GLOBAL_ATTRIBUTE1
Payment Means
GLOBAL_ATTRIBUTE2
Payment Channel
GLOBAL_ATTRIBUTE3
Country Code
GLOBAL_ATTRIBUTE4
Party ID
GLOBAL_ATTRIBUTE5
Import Code
GLOBAL_ATTRIBUTE6
Supplier Message
GLOBAL_ATTRIBUTE7
Import Code Specification
GLOBAL_ATTRIBUTE8
Settlement Code
GLOBAL_ATTRIBUTE18
Payment categoryID
GLOBAL_ATTRIBUTE19
dummy
GLOBAL_ATTRIBUTE20
Payment Category
- Finland Context: JE.FI.APXIISIM.KKL_VIITE
This table shows the column names and field prompts for this context.
GLOBAL_ATTRIBUTE1
Reference Number
GLOBAL_ATTRIBUTE2
Check Digit
- Finland Context: JE.FI.APXIISIM.VAPAA_VIITE
This table shows the column name and field prompt for this context.
GLOBAL_ATTRIBUTE1
Reference Text
- France Context: JE.FR.APXIISIM.TAX_RULE
This table shows the column name and field prompt for this context.
GLOBAL_ATTRIBUTE1
Deduction Tax Rule
- Hungary Context: JE.HU.APXIISIM.TAX_DATE
This table shows the column name and field prompt for this context.
GLOBAL_ATTRIBUTE1
Tax Date
- Netherlands Context: JE.NL.APXIISIM.FOREIGN
This table shows the column names and field prompts for this context.
GLOBAL_ATTRIBUTE1
Payment Category Code
GLOBAL_ATTRIBUTE10
Goods Code/Article Number
GLOBAL_ATTRIBUTE11
Payment Nature
- Norway Context: JE.NO.APXIISIM.NORWAY
This table shows the column names and field prompts for this context.
GLOBAL_ATTRIBUTE1
Invoice Number
GLOBAL_ATTRIBUTE2
Declaration Code
GLOBAL_ATTRIBUTE3
Declaration Desc
GLOBAL_ATTRIBUTE4
Urgency Called
GLOBAL_ATTRIBUTE5
Message to Supplier
- Poland Context: JE.PL.APXIISIM.INVOICE_INFO
This table shows the column names and field prompts for this context.
GLOBAL_ATTRIBUTE1
Tax Date
GLOBAL_ATTRIBUTE2
VAT_REGISTER
- Singapore Context: JA.SG.APXIISIM.INVOICES_FOLDER
This table shows the column name and field prompt for this context.
GLOBAL_ATTRIBUTE1
Supplier Exchange Rate
- Spain Context: JE.ES.APXIISIM.MODELO347
This table shows the column name and field prompt for this context.
GLOBAL_ATTRIBUTE1
Invoice Type
- Spain Context: JE.ES.APXIISIM.MODELO347PR
This table shows the column name and field prompt for this context.
.GLOBAL_ATTRIBUTE1
Invoice Type
- Spain Context: JE.ES.APXIISIM.MODELO349
This table shows the column names and field prompts for this context.
GLOBAL_ATTRIBUTE1
Invoice Type
GLOBAL_ATTRIBUTE2
Correction Year
GLOBAL_ATTRIBUTE3
Correction Period
- Spain Context: JE.ES.APXIISIM.OTHER
This table shows the column name and field prompt for this context.
GLOBAL_ATTRIBUTE1
Invoice Type
- Spain Context: JE.ES.APXINWKB.MODELO347
This context is disabled and no longer used.
- Spain Context: JE.ES.APXINWKB.MODELO347PR
This context is disabled and no longer used.
- Spain Context: JE.ES.APXINWKB.MODELO349
This context is disabled and no longer used.
- Spain Context: JE.ES.APXINWKB.OTHER
This context is disabled and no longer used.
- Sweden Context: JE.SE.APXIISIM.BANK_SISU
This table shows the column names and field prompts for this context.
GLOBAL_ATTRIBUTE1
Federal Reserve Code
GLOBAL_ATTRIBUTE2
Express Invoice
GLOBAL_ATTRIBUTE3
Invoice Charge Code
GLOBAL_ATTRIBUTE4
Future Contract
- Sweden Context: JE.SE.APXIISIM.BANK_UTLI
This table shows the column names and field prompts for this context.
GLOBAL_ATTRIBUTE1
Federal Reserve Code
GLOBAL_ATTRIBUTE2
Express Invoice
GLOBAL_ATTRIBUTE3
Invoice Charge Code
GLOBAL_ATTRIBUTE4
Future Contract
- Sweden Context: JE.SE.APXIISIM.POST_INLAND
This table shows the column names and field prompts for this context.
GLOBAL_ATTRIBUTE1
Message Row 1
GLOBAL_ATTRIBUTE2
Message Row 2
- Sweden Context: JE.SE.APXIISIM.POST_UTLAND
This table shows the column names and field prompts for this context.
GLOBAL_ATTRIBUTE1
Federal Reserve Code
GLOBAL_ATTRIBUTE2
Express Payment
GLOBAL_ATTRIBUTE3
Future Contract Postgiro
- Switzerland Context: JE.CH.APXIISIM.DTA
This table shows the column name and field prompt for this context.
GLOBAL_ATTRIBUTE1
ESR Number
- Switzerland Context: JE.CH.APXIISIM.SAD
This table shows the column name and field prompt for this context.
GLOBAL_ATTRIBUTE1
ESR Number
- Taiwan Context: JA.TW.APXIISIM.INVOICES_FOLDER
This table shows the column names and field prompts for this context.
GLOBAL_ATTRIBUTE1
Government Uniform Invoice Type
GLOBAL_ATTRIBUTE2
Wine/Cigarette
GLOBAL_ATTRIBUTE3
Deductible Type
GLOBAL_ATTRIBUTE4
Print Date
- Thailand Context: JA.TH.APXIISIM.INVOICES_INTF
This table shows the column names and field prompts for this context.
GLOBAL_ATTRIBUTE1
Tax Invoice Number
GLOBAL_ATTRIBUTE2
Tax Invoice Date
GLOBAL_ATTRIBUTE3
Supplier Tax Invoice Number
GLOBAL_ATTRIBUTE4
Tax Accounting Period
AP_INVOICE_DISTRIBUTIONS_ALL
AP_INVOICE_DISTRIBUTIONS_ALL holds the distribution line information that you enter for invoices. There is a row for each invoice distribution. A distribution line must be associated with an invoice. An invoice can have multiple distribution lines.
Your Oracle Payables application automatically creates rows in this table when: 1) you choose a distribution set at the invoice level 2) you import expense reports 3) you match an invoice to a purchase order or receipt; it uses information from the matched purchase order or receipt 4) you import invoices via the Open Interface Import process 5) you select to automatically calculate tax 6) you select to automatically do withholding.
Each invoice distribution line has its own accounting date. When you account for an invoice, your Oracle Payables application creates accounting events, accounting entry headers and accounting entry lines for those distribution lines that have accounting dates included in the selected accounting date range for the Payables Accounting Process. The accounting entries can then be transferred over to General Ledger by running the Transfer to General Ledger process which creates journal entries.
Values for POSTED_FLAG may be Y for accounted distributions or N for distributions that have not been accounted. Values for ACCRUAL_POSTED_FLAG may be Y if distribution has been accounted and system is set up for accrual basis accounting or N if either distribution has not been accounted or accrual basis accounting is not used.
Values for CASH_POSTED_FLAG may be Y if distribution has been accounted and system is set up for cash basis accounting, N if either distribution has not been accounted or system is not set up for cash basis accounting or P if distribution has been partially accounted in the cash set of books.
The MATCH_STATUS_FLAG indicates the approval status for the distribution. Values for the MATCH_STATUS_FLAG can be null or N for invoice distributions that Approval has not tested or T for distributions that have been tested or A for distributions that have been tested and approved.
Invoice distributions may be interfaced over/from Oracle Assets or Oracle Projects. Your Oracle Payables application sets the ASSETS_ADDITION_FLAG to U for distributions not tested by Oracle Assets; Oracle Assets then adjusts this flag after it tests a distribution for assignment as an asset. To avoid the same invoice distribution being interfaced to both Oracle Projects and Oracle Assets, you must interface any project-related invoice distribution to Oracle Projects before you can interface it to Oracle Assets. If the project-related invoice distribution is charged to a capital project in Oracle Projects, Oracle Projects sets the ASSET_ADDITION_FLAG to P when the PA_ADDITION_FLAG is set to Y, Z or T. Oracle Assets only picks up invoice distributions with the ASSET_ADDITION_FLAG set to U and if project-related, with the PA_ADDITION_FLAG set to Y, Z, or T. PA_ADDITION_FLAG tracks the status of project-related supplier invoice distribution lines and expense report distribution lines. For supplier invoice distributions entered via Oracle Payables, the PA_ADDITION_FLAG is set to N if the distribution is project-related, otherwise it is set to E and it is updated by Oracle Projects when the distribution is processed by the Oracle Projects Interface Supplier Invoice process. Oracle Projects sets the PA_ADDITION_FLAG to Y or Z after the item is successfully processed, or may be set to a rejection code if the line is rejected during transfer to Oracle Projects; see QuickCodes listing for all the errors. You must correct the rejection reason and try to retransfer the line. For supplier invoice adjustment lines interfaced from Oracle Projects to Oracle Payables (which must net to zero with another line), the value for the PA_ADDITION_FLAG is set to T. For expense report distributions interfaced from Oracle Projects to Oracle Payables via Invoice Import, this value is set to N. This row is never picked up by the Interface Supplier Invoices process based on the AP_INVOICES.INVOICE_TYPE_LOOKUP_CODE = EXPENSE REPORT. For expense report adjustment lines interfaced from Oracle Projects to Oracle Payables which net to zero with another line, this value is set to T. Both lines are associated with the original invoice by the Oracle Projects Interface Expense Reports to AP process.
Values for the ENCUMBERED_FLAG are as follows: Y indicates a regular distribution that has been successfully encumbered by Payables; W indicates a regular distribution that has been encumbered in advisory mode even though insufficient funds existed; H indicates a regular distribution that has not been encumbered because it was put on hold; N or null indicates a regular line that has not been encumbered because it has not been looked at yet; D is the same as Y for a reversal distribution line; X is the same as W for a reversal distribution line; P is the same as H for a reversal distribution line; R indicates a line to be ignored by encumbrance and approval code because neither the original nor the reversal distributions were looked at and they offset each other so, they can be ignored.
This table corresponds to the Distributions window.
Flexfield: JG_AP_INVOICE_DISTRIBUTIONS
- Argentina Context: JL.AR.APXINWKB.DISTRIBUTIONS
This table shows the column names and field prompts for this context.
GLOBAL_ATTRIBUTE3
Ship To Location
GLOBAL_ATTRIBUTE4
Tax Inclusive Amount
- Brazil Context: JL.BR.APXINWKB.D_SUM_FOLDER
This table shows the column name and field prompt for this context.
GLOBAL_ATTRIBUTE1
Operation Fiscal Code
- Canada Context: JA.CA.APXINWKB.INVOICE_DISTR
This context is disabled and no longer used.
- Colombia Context: JL.CO.APXINWKB.DISTRIBUTIONS
This table shows the column names and field prompts for this context.
GLOBAL_ATTRIBUTE2
Taxpayer ID
GLOBAL_ATTRIBUTE3
Ship To Location
- Czech Republic Context: JE.CZ.APINXWKB.FINAL
This table shows the column names and field prompts for this context.
GLOBAL_ATTRIBUTE1
Final VAT Register Request ID
- Hungary Context: JE.HU.APXINWKB.FINAL
This table shows the column names and field prompts for this context.
GLOBAL_ATTRIBUTE1
Final VAT Registration Request ID
GLOBAL_ATTRIBUTE6
Statistical Code
- Italy Context: JE.IT.APXINWKB.DISTRIBUTIONS
This table shows the column names and field prompts for this context.
GLOBAL_ATTRIBUTE1
Taxable Amount
GLOBAL_ATTRIBUTE2
Deferred Expense
GLOBAL_ATTRIBUTE3
Deferred Expense Account
GLOBAL_ATTRIBUTE4
Deferred Expense Date
- Poland Context: JE.PL.APINXWKB.FINAL
This table shows the column names and field prompts for this context.
GLOBAL_ATTRIBUTE1
Final VAT Register Request ID
- Poland Context: JE.PL.APXINWKB.STAT_CODE
This context is disabled and no longer used.
- Spain Context: JE.ES.APXINWKB_DISTS.INV_DIST
This context is disabled and no longer used.
- Slovakia Context: JE.SK.APINXWKB.FINAL
This table shows the column names and field prompts for this context.
GLOBAL_ATTRIBUTE1
Final VAT Register Request ID
AP_INVOICE_LINES_INTERFACE
AP_INVOICE_LINES_INTERFACE stores information used to create one or more invoice distributions. Note that one row in this table may create, during the import process, more than one invoice distribution. For example, if you enter a Tax line in this table and prorate it across multiple Item lines, during Open Interface Import the system may create multiple Tax invoice distributions based on the single Tax line in this table.
Flexfield: JG_AP_INVOICE_LINES_INTERFACE
- Argentina Context: JL.AR.APXIISIM.LINES_FOLDER
This table shows the column names and field prompts for this context.
GLOBAL_ATTRIBUTE3
Ship To Location
GLOBAL_ATTRIBUTE4
Tax Inclusive Amount
- Brazil Context: JL.BR.APXIISIM.LINES_FOLDER
This table shows the column name and field prompt for this context.
GLOBAL_ATTRIBUTE1
Operation Fiscal Code
- Canada Context: JA.CA.APXIISIM.LINES_FOLDER
This context is disabled and no longer used.
- Colombia Context: JL.CO.APXIISIM.LINES_FOLDER
This table shows the column names and field prompts for this context.
GLOBAL_ATTRIBUTE2
Taxpayer ID
GLOBAL_ATTRIBUTE3
Ship To Location
- Czech Republic Context: JE.CZ.APXIISIM.FINAL
This table shows the column name and field prompt for this context.
GLOBAL_ATTRIBUTE1
Final VAT Register Request ID
- Hungary Context: JE.HU.APXIISM.FINAL
This table shows the column names and field prompts for this context.
GLOBAL_ATTRIBUTE1
Final VAT Register Request ID
GLOBAL_ATTRIBUTE6
Statistical Code
- Hungary Context: JE.HU.APXIISIM.STAT_CODE
This context is disabled and no longer used.
- Hungary Context: JE.HU.APXINWKB.STAT_CODE
This context is disabled and no longer used.
- Italy Context: JE.IT.APXIISM.DISTRIBUTIONS
This table shows the column names and field prompts for this context.
GLOBAL_ATTRIBUTE1
Taxable Amount
GLOBAL_ATTRIBUTE2
Deferred Expense
GLOBAL_ATTRIBUTE3
Deferred Expense Account
GLOBAL_ATTRIBUTE4
Deferred Expense Date
- Poland Context: JE.PL.APXIISIM.FINAL
This table shows the column names and field prompts for this context.
GLOBAL_ATTRIBUTE1
Final VAT Register Request ID
- Poland Context: JE.PL.APXIISIM.STAT_CODE
This context is disabled and no longer used.
- Poland Context: JE.APXINWKB.STAT_CODE
This context is disabled and no longer used.
- Slovakia Context: JE.SK.APXIISM.FINAL
This table shows the column names and field prompts for this context.
GLOBAL_ATTRIBUTE1
Final VAT Register Request ID
AP_PAYMENT_SCHEDULES_ALL
AP_PAYMENT_SCHEDULES_ALL contains information about scheduled payments for an invoice. You need one row for each time you intend to make a payment on an invoice. Your Oracle Payables application uses this information to determine when to make payments on an invoice and how much to pay in an automatic payment batch.
Values for HOLD_FLAG may be 'Y' to place a hold on the scheduled payment, or 'N' not to do so. Values for PAYMENT_STATUS_FLAG may be 'Y' for fully paid payment schedules, 'N' for unpaid scheduled payments, or 'P' for partially paid scheduled payments. For converted records, enter a value for AMOUNT_REMAINING.
This table corresponds to the Scheduled Payments window.
Flexfield: JG_AP_PAYMENT_SCHEDULES
- Brazil Context: JL.BR.APXINWKB.AP_PAY_SCHED
This table shows the column names and field prompts for this context.
GLOBAL_ATTRIBUTE1
Interest Type
GLOBAL_ATTRIBUTE2
Interest Rate / Amount
GLOBAL_ATTRIBUTE3
Interest Period
GLOBAL_ATTRIBUTE4
Interest Formula
GLOBAL_ATTRIBUTE5
Interest Grace Days
GLOBAL_ATTRIBUTE6
Penalty Type
GLOBAL_ATTRIBUTE7
Penalty Rate / Amount
GLOBAL_ATTRIBUTE8
Associated
GLOBAL_ATTRIBUTE11
Bank Collection ID
AP_REPORTING_ENTITIES_ALL
AP_REPORTING_ENTITIES_ALL contains information about the reporting entities you define for 1099 reporting. You must define at least one reporting entity for your company or agency; however, you can define as many reporting entities as you require to satisfy your multi-organization reporting needs. Each tax reporting entity you define must have a unique Tax Identification Number. When you submit your 1099 reports, you submit the reports once for each tax reporting entity you define. This table corresponds to the Reporting Entity window.
Flexfield: JG_AP_REPORTING_ENTITIES
- Portugal Context: JE.PT.APXTRDRE.TAX_INFO
This table shows the column names and field prompts for this context.
GLOBAL_ATTRIBUTE1
Tax Office Location
GLOBAL_ATTRIBUTE2
Tax Office Code
GLOBAL_ATTRIBUTE3
Tax Office Number
GLOBAL_ATTRIBUTE4
SIC Code
AP_SYSTEM_PARAMETERS_ALL
AP_SYSTEM_PARAMETERS_ALL contains the parameters and defaults you define for operating your Oracle Payables application system. This table contains information such as your set of books, your functional currency and your default bank account and payment terms. Your Oracle Payables application also uses this information to determine default values that cascade down to supplier and invoice entry. This table corresponds to the Payables Options window. There is only one row in this table. There is no primary key for this table.
Flexfield: JG_AP_SYSTEM_PARAMETERS
- Brazil Context: JL.BR.APXCUMSP.SYS_PARAMETER
This table shows the column names and field prompts for this context.
GLOBAL_ATTRIBUTE1
Enable Bank Collection
GLOBAL_ATTRIBUTE2
Collection Document Association
GLOBAL_ATTRIBUTE3
Association Method
GLOBAL_ATTRIBUTE4
Payment Location
GLOBAL_ATTRIBUTE5
Country Profile
AP_TAX_CODES_ALL
AP_TAX_CODES_ALL contains information about the tax codes you define. You need one row for each tax code you want to use when entering invoices.
When you enter invoices, you can use a list of values to select a tax code defined in this table. Your Oracle Payables application also uses TAX_RATE to calculate use tax when you enter a taxable amount for an invoice.
This table corresponds to the Tax Codes window.
Flexfield: JG_AP_TAX_CODES
- Argentina Context: JL.AR.APXTADTC.TAX_NAMES
This table shows the column names and field prompts for this context.
GLOBAL_ATTRIBUTE4
Withholding Type
GLOBAL_ATTRIBUTE5
Tax Regime Reporting Code
GLOBAL_ATTRIBUTE6
Foreign Rate Indicator
GLOBAL_ATTRIBUTE7
Zone
GLOBAL_ATTRIBUTE8
Item Line Type Applicability
GLOBAL_ATTRIBUTE9
Freight Line Type Applicability
GLOBAL_ATTRIBUTE10
Miscellaneous Line Type Applicability
GLOBAL_ATTRIBUTE11
Tax Line Type Applicability
GLOBAL_ATTRIBUTE12
Minimum Taxable Base Amount
GLOBAL_ATTRIBUTE13
Minimum Withheld Amount
GLOBAL_ATTRIBUTE14
Adjustment Minimum Base
GLOBAL_ATTRIBUTE15
Cumulative Payment Applicable
GLOBAL_ATTRIBUTE16
Tax Inclusive
GLOBAL_ATTRIBUTE20
Supplier Condition Reporting Code
- Argentina Context: JL.AR.APXTADTC.VAT
This table shows the column name and field prompt for this context.
GLOBAL_ATTRIBUTE4
DGI Transaction Code
GLOBAL_ATTRIBUTE5
Tax Regime Reporting Code
- Brazil Context: JL.BR.APXTADTC.AP_TAX_CODES
This table shows the column names and field prompts for this context.
GLOBAL_ATTRIBUTE1
Tax Non Recoverable Account
GLOBAL_ATTRIBUTE2
Withholding Tax Type
GLOBAL_ATTRIBUTE3
VALIDATE_FULL
- Chile Context: JL.CL.APXTADTC.AP_TAX_CODES
This table shows the column name and field prompt for this context.
GLOBAL_ATTRIBUTE19
Tax Category
- Colombia Context: JL.CO.APXTADTC.TAX_NAMES
This table shows the column names and field prompts for this context.
GLOBAL_ATTRIBUTE4
Withholding Type
GLOBAL_ATTRIBUTE5
TAX Authority Category
GLOBAL_ATTRIBUTE6
Foreign Rate Indicator
GLOBAL_ATTRIBUTE8
Item Line Type Applicability
GLOBAL_ATTRIBUTE9
Freight Line Type Applicability
GLOBAL_ATTRIBUTE10
Miscellaneous Line Type Applicability
GLOBAL_ATTRIBUTE11
Tax Line Type Applicability
GLOBAL_ATTRIBUTE12
Minimum Taxable Base Amount
GLOBAL_ATTRIBUTE13
Minimum Withheld Amount
GLOBAL_ATTRIBUTE14
Income Tax Rate
GLOBAL_ATTRIBUTE15
First Tax Type
GLOBAL_ATTRIBUTE16
Second Tax Type
GLOBAL_ATTRIBUTE17
Municipal Tax Type
GLOBAL_ATTRIBUTE18
Reduction Percentage
GLOBAL_ATTRIBUTE19
Reported Tax Rate
- Czech Republic Context: JE.CZ.APXTADTC.TAX_ORIGIN
This table shows the column name and field prompt for this context.
GLOBAL_ATTRIBUTE1
Tax Origin
- Hungary Context: JE.HU.APXTADTC.TAX_ORIGIN
This context is disabled and no longer used.
- Korea Context: JA.KR.APXTADTC.WITHHOLDING
This table shows the column names and field prompts for this context.
GLOBAL_ATTRIBUTE1
Location
GLOBAL_ATTRIBUTE2
Withholding Tax Type
GLOBAL_ATTRIBUTE3
Withholding Certificate Type
GLOBAL_ATTRIBUTE4
Domestic Income Category
GLOBAL_ATTRIBUTE5
Foreign Income Category
GLOBAL_ATTRIBUTE6
Recognized Expense
GLOBAL_ATTRIBUTE7
Minimum Withheld Amount
- Poland Context: JE.PL.APXTADTC.TAX_ORIGIN
This table shows the column name and field prompt for this context.
GLOBAL_ATTRIBUTE1
Tax Origin
- Portugal Context: JE.PT.APXTADTC.TAX_INFO
This table shows the column names and field prompts for this context.
GLOBAL_ATTRIBUTE1
Location
GLOBAL_ATTRIBUTE2
Periodic:Taxable Box
GLOBAL_ATTRIBUTE3
Periodic: Recoverable Tax Box
GLOBAL_ATTRIBUTE4
Annual:Total Taxable Box
GLOBAL_ATTRIBUTE5
Annual:Recoverable Taxable Box
GLOBAL_ATTRIBUTE6
Annual :Non Recoverable Taxable
GLOBAL_ATTRIBUTE7
Annual:Recoverable Tax Box
- Singapore Context: JA.SG.APXTADTC.TAX_CODE
This context is disabled and no longer used.
- Switzerland Context: JE.CH.APXTADTC.TAX_INFO
This table shows the column name and field prompt for this context.
GLOBAL_ATTRIBUTE1
Tax Regime
- Taiwan Context: JA.TW.APXTADTC.TAX_CODES
This table shows the column name and field prompt for this context.
GLOBAL_ATTRIBUTE1
Government Tax Type
- Thailand Context: JA.TH.APXTADTC.TAX_CODES
This table shows the column name and field prompt for this context.
GLOBAL_ATTRIBUTE1
Tax Invoice Location
AR_CASH_RECEIPTS_ALL
The AR_CASH_RECEIPTS_ALL table stores one record for each receipt that you enter. Oracle Receivables concurrently creates records in the AR_CASH_RECEIPT_HISTORY_ALL, AR_PAYMENT_SCHEDULES_ALL, and AR_RECEIVABLE_APPLICATIONS_ALL tables for invoice-related receipts. For receipts that are not related to invoices, such as miscellaneous receipts, Receivables creates records in the AR_MISC_CASH_DISTRIBUTIONS_ALL table instead of the AR_RECEIVABLE_APPLICATIONS_ALL table.
Receivables associates a status with each receipt. These statuses include:
- APP - Applied
- UNAPP - Unapplied
- UNID - Unidentified
- NSF - Non-sufficient funds
- REV - Reversed receipt
- STOP - Stop payment
Receivables does not update the status of a receipt from UNAPP to APP until the entire amount of the receipt is either applied or placed on account. A receipt can have a status of APP even if the entire receipt amount is placed on account.
Cash receipts proceed through the confirmation, remittance, and clearance steps. Each step creates rows in the AR_CASH_RECEIPT_HISTORY table. The CODE_COMBINATION_ID column in this table stores the accounts that are debited and credited as part of the cycle of steps.
The RECEIVABLES_TRX_ID column links the AR_CASH_RECEIPTS_ALL table to the AR_RECEIVABLES_TRX_ALL table and identifies the receivables activity that you select when you enter miscellaneous receipts.
The DISTRIBUTION_SET_ID column links the AR_CASH_RECEIPTS_ALL table to the AR_DISTRIBUTION_SETS_ALL table and identifies the distribution set and the distribution set line accounts that are credited when you enter miscellaneous receipts.
The CUSTOMER_BANK_ACCOUNT_ID column replaced the CUSTOMER_MICR_ID column as a pointer to the customer bank account. The CUSTOMER_BANK_ACCOUNT_ID column is a foreign key to the AP_BANK_ACCOUNTS_ALL table for bank accounts that do not belong to you and have a type of EXTERNAL.
The GL_DATE and REVERSAL_GL_DATE columns were also moved to the AR_CASH_RECEIPT_HISTORY_ALL table because each step has its own General Ledger date and accounting impact.
The primary key for this table is CASH_RECEIPT_ID, which identifies the receipt transaction that created the row for the receipt.
Flexfield: JG_AR_CASH_RECEIPTS
- Argentina Context: JL.AR.ARXRWMAI.RGW_FOLDER
This table shows the column names and field prompts for this context.
GLOBAL_ATTRIBUTE1
Package Number
GLOBAL_ATTRIBUTE4
Withholding Certificate Number
GLOBAL_ATTRIBUTE5
Withholding Certificate Date
GLOBAL_ATTRIBUTE6
Tax Regime Reporting Code
- Greece Context: JE.GR.ARXRWMAI.RA_INFO
This table shows the column names and field prompts for this context.
GLOBAL_ATTRIBUTE1
Receipt Acknowledgment Number
GLOBAL_ATTRIBUTE2
Receipt Acknowledgment Date
GLOBAL_ATTRIBUTE3
Document Category
- Portugal Context: JE.PT.ARXRWMAI.RA_INFO
This table shows the column names and field prompts for this context.
GLOBAL_ATTRIBUTE1
Receipt Acknowledgment Number
GLOBAL_ATTRIBUTE2
Receipt Acknowledgment Date
GLOBAL_ATTRIBUTE3
Document Category
- Taiwan Context: JA.TW.ARXRWMAI.CASH_RECEIPTS
This context is disabled and no longer used.
AR_INTERIM_CASH_RCPT_LINES_ALL
The AR_INTERIM_CASH_RCPT_LINES_ALL table is a temporary table that stores entries for each QuickCash receipt application. After you run the Post QuickCash program, Oracle Receivables creates an entry in the AR_RECEIVABLE_APPLICATIONS_ALL table for each application. Receivables then deletes data from this table.
The primary keys for this table are CASH_RECEIPT_ID and CASH_RECEIPT_LINE_ID.
Flexfield: JG_AR_INTERIM_CASH_RCPT_LINES
- Brazil Context: JL.BR.ARXRWMAI.Additional Info
This table shows the column names and field prompts for this context.
GLOBAL_ATTRIBUTE1
Calculated Interest
GLOBAL_ATTRIBUTE2
Received Interest
GLOBAL_ATTRIBUTE3
Main Amount Received
GLOBAL_ATTRIBUTE4
Base Interest Calculation
GLOBAL_ATTRIBUTE5
Interest Payment Date
GLOBAL_ATTRIBUTE6
Calculated Interest Tmp
GLOBAL_ATTRIBUTE7
Received Interest Tmp
GLOBAL_ATTRIBUTE8
Interest Payment Date Tmp
AR_MEMO_LINES_ALL_B
The AR_MEMO_LINES_ALL_B table stores information about standard memo lines for debit memos, on-account credits, debit memo reversals, chargebacks, and invoices. If AutoAccounting is based on standard line items, Oracle Receivables uses this table to obtain the revenue account.
This table also stores the tax code, unit standard price, unit of measure, and standard invoicing and accounting rules for each standard memo line.
The primary key for this table is MEMO_LINE_ID.
Flexfield: JG_AR_MEMO_LINES
- Argentina Context: JL.AR.ARXSTDML.AR_MEMO_LINES
This table shows the column names and field prompts for this context.
GLOBAL_ATTRIBUTE1
Fiscal Classification Code
GLOBAL_ATTRIBUTE2
Transaction Condition Class
GLOBAL_ATTRIBUTE7
Branch Number
- Brazil Context: JL.BR.ARXSDML.Additional
This context is disabled and no longer used.
- Brazil Context: JL.BR.ARXSTDML.Additional
This table shows the column names and field prompts for this context.
GLOBAL_ATTRIBUTE1
Fiscal Classification Code
GLOBAL_ATTRIBUTE2
Transaction Condition Class
GLOBAL_ATTRIBUTE3
Item Origin
GLOBAL_ATTRIBUTE4
Item Fiscal Type
GLOBAL_ATTRIBUTE5
Federal Tributary Situation
GLOBAL_ATTRIBUTE6
State Tributary Situation
- Colombia Context: JL.CO.ARXSTDML.AR_MEMO_LINES
This table shows the column names and field prompts for this context.
GLOBAL_ATTRIBUTE1
Fiscal Classification Code
GLOBAL_ATTRIBUTE2
Transaction Condition Class
- Hungary Context: JE.HU.ARXSTDML.STAT_CODE
This table shows the column name and field prompt for this context.
GLOBAL_ATTRIBUTE1
Statistical Code
- Poland Context: JE.PL.ARXSTDML.STAT_CODE
This table shows the column name and field prompt for this context.
GLOBAL_ATTRIBUTE1
Statistical Code
AR_PAYMENT_SCHEDULES_ALL
The AR_PAYMENT_SCHEDULES_ALL table stores all transactions except adjustments and miscellaneous cash receipts. Oracle Receivables updates this table when activity occurs against an invoice, debit memo, chargeback, credit memo, on-account credit, or receipt. Oracle Receivables groups different transactions by entering one of these values in the CLASS column:
- INV - Invoice
- DM - Debit Memo
- GUAR - Guarantee
- CM - Credit Memo
- DEP - Deposit
- CB - Chargeback
- PMT - Receipt
Transaction classes determine if a transaction relates to either the RA_CUSTOMER_TRX_ALL table or the AR_CASH_RECEIPTS_ALL table. Using the CUSTOMER_TRX_ID foreign key column, the AR_PAYMENT_SCHEDULES_ALL table joins to the RA_CUSTOMER_TRX_ALL table for non-payment transaction entries, such as the creation of credit memos, debit memos, invoices, chargebacks, or deposits. Using the CASH_RECEIPT_ID foreign key column, the AR_PAYMENT_SCHEDULES_ALL table joins to the AR_CASH_RECEIPTS_ALL table for invoice-related payment transactions.
When a receipt is applied, Oracle Receivables updates the AMOUNT_APPLIED, AMOUNT_DUE_REMAINING, and STATUS columns. The STATUS column changes from OP to CL for any transaction that has an AMOUNT_DUE_REMAINING value of 0. For a receipt, the amount due that remains includes on-account and unapplied amounts. Oracle Receivables stores debit items such as invoices, debit memos, chargebacks, deposits, and guarantees as positive numbers in the AMOUNT_DUE_REMAINING and AMOUNT_DUE_ORIGINAL columns. Credit items such as credit memos and receipts are stored as negative numbers.
Receipts can be confirmed or not confirmed as designated by the CONFIRMED_FLAG column. The sum of the AMOUNT_DUE_REMAINING column for a customer for all confirmed payment schedules reflects the current customer balance. If this amount is negative, then the AMOUNT_DUE_REMAINING column indicates the credit balance amount that is currently available for this customer. For invoices with split terms, Oracle Receivables creates one record in the RA_CUSTOMER_TRX_ALL table and one record in the AR_PAYMENT_SCHEDULES_ALL table for each installment. In the AR_PAYMENT_SCHEDULES_ALL table, the DUE_DATE and AMOUNT_DUE_REMAINING columns can differ for each installment of a split term invoice. Each installment is differentiated by the TERMS_SEQUENCE_NUMBER column.
If you create a debit memo reversal when you reverse a receipt, Oracle Receivables creates a new payment schedule record for the debit memo and populates the REVERSED_CASH_RECEIPT_ID column with the CASH_RECEIPT_ID column for the receipt that was reversed. Oracle Receivables creates a new payment schedule record when you create a chargeback in the Receipts window. The ASSOCIATED_CASH_RECEIPT_ID column is the cash receipt of the payment that you entered when you created the chargeback in this window.
The ACTUAL_DATE_CLOSED and GL_DATE_CLOSED columns are populated with the date of the latest transaction. The ACTUAL_DATE_CLOSED column gives the date that you applied a payment or credit to an open transaction that set the AMOUNT_DUE_REMAINING column to 0 for that transaction. Oracle Receivables uses the ACTUAL_DATE_CLOSED column to determine which transactions to include when you print statements. The GL_DATE_CLOSED column indicates the General Ledger date that your transaction was closed on. This column identifies which transactions Oracle Receivables selects when it displays current and overdue debit items in the aging reports. The aging reports also use the current balances in the AMOUNT_DUE_REMAINING column to display outstanding amounts for current and overdue debit items.
The primary key for this table is PAYMENT_SCHEDULE_ID, which identifies the transaction that created the row.
Flexfield: JG_AR_PAYMENT_SCHEDULES
- Brazil Context: JL.BR.ARXTWMAI.Additional
This table shows the column names and field prompts for this context.
GLOBAL_ATTRIBUTE1
Main Amount Received
GLOBAL_ATTRIBUTE2
Base Interest Calculation
GLOBAL_ATTRIBUTE3
Calculated Interest
GLOBAL_ATTRIBUTE4
Received Interest
GLOBAL_ATTRIBUTE5
Interest Difference Action
GLOBAL_ATTRIBUTE6
Write Off Reason
GLOBAL_ATTRIBUTE7
Interest Payment Date
GLOBAL_ATTRIBUTE8
Payment Method
GLOBAL_ATTRIBUTE9
Bearer of Trade Note
GLOBAL_ATTRIBUTE11
Format Flag
GLOBAL_ATTRIBUTE12
Document Status
GLOBAL_ATTRIBUTE13
Bank Transfer Batch Number
GLOBAL_ATTRIBUTE14
Selection Number of Bank Transfer Batch
GLOBAL_ATTRIBUTE15
Write Off Date
AR_RECEIPT_CLASSES
The AR_RECEIPT_CLASSES table stores user-defined receipt classes. Receipt classes determine if receipts that are assigned to a receipt class are manually or automatically created and also indicate the required processing steps, such as confirmation, remittance, and clearance.
The primary key for this table is RECEIPT_CLASS_ID.
Flexfield: JG_AR_RECEIPT_CLASSES
- Brazil Context: JL.BR.ARXSUDRC.Additional
This table shows the column name and field prompt for this context.
GLOBAL_ATTRIBUTE1
Collection Method
- Chile Context: JL.CL.ARXSUDRC.RECEIPT_CLASS
This table shows the column names and field prompts for this context.
GLOBAL_ATTRIBUTE2
Bills of Exchange
GLOBAL_ATTRIBUTE3
Tax Code
AR_RECEIVABLE_APPLICATIONS_ALL
The AR_RECEIVABLE_APPLICATIONS_ALL table stores all accounting entries for both your cash and credit memo applications. The APPLICATION_TYPE column stores either CASH or CM (for credit memo applications). Each row in this table includes the amount applied, status, and accounting flexfield information.
Possible statuses of your applications include:
- APP - Applied
- UNAPP - Unapplied
- ACC - On-Account
- UNID - Unidentified
You use this information to determine the applications of your payments or credit memos. The status of a receivable application determines which flexfield account that Receivables uses. For example, if you enter a cash receipt of $500 as Unidentified, Receivables creates a record in the AR_RECEIVABLE_APPLICATIONS_ALL table with $500 in the AMOUNT_APPLIED column and UNID in the STATUS column. Receivables uses the CODE_COMBINATION_ID foreign key column to associate this payment with the Unidentified flexfield account. The CODE_COMBINATION_ID column stores valid Accounting Flexfield segment value combinations that are credited in General Ledger when this application is posted.
Cash applications represent cash receipt applications. The sum of the AMOUNT_APPLIED column for cash applications should always equal the amount of the cash receipt. A negative value in the AMOUNT_APPLIED column becomes a debit when this application is posted to General Ledger.
When a cash receipt is initially created, Receivables creates a row in this table for the cash receipt amount with a status of UNAPP. For each subsequent application, Receivables creates two rows: one row with a status of APP for the amount that is applied to the invoice, and one row with status of UNAPP for the negative of the amount that is applied.
If you reverse a cash application, Receivables creates two new rows: one row with status of APP for the original application's inverse amount (the negative of the original application amount), and one row with a status of UNAPP for the positive amount of the application that is reversed.
For example:
UNAPP
$100
Creation of a $100 cash receipt
APP
$60
Application of $60 of this cash receipt
UNAPP
-$60
This row debits the Unapplied account
APP
-$60
Reversal of the $60 application
UNAPP
$60
This rows credits the Unapplied account
Credit memo applications, on the other hand, do not have rows with a status of UNAPP. Credit memo applications use only rows with a status of APP.
The CASH_RECEIPT_ID column stores the cash receipt ID of the receipt that you entered. Receivables concurrently creates a record for this receipt in the AR_CASH_RECEIPTS_ALL table. This column is null for a credit memo application. The CUSTOMER_TRX_ID and PAYMENT_SCHEDULE_ID columns also identify the transaction that you are actually applying.
The APPLIED_CUSTOMER_TRX_ID and APPLIED_PAYMENT_SCHEDULE_ID columns identify the invoice or credit memo that receives the application.
For example, if you apply a receipt against an invoice, Receivables creates a record in the AR_RECEIVABLE_APPLICATIONS_ALL table. The CASH_RECEIPT_ID and PAYMENT_SCHEDULE_ID columns for this record identify the receipt that you are applying. The APPLIED_CUSTOMER_TRX_ID and APPLIED_PAYMENT_SCHEDULE_ID columns for this record belong to the invoice that is receiving the application.
If you apply a credit memo against the invoice, Receivables creates a record in the AR_RECEIVABLE_APPLICATIONS_ALL table. The CUSTOMER_TRX_ID and PAYMENT_SCHEDULE_ID columns for this record identify the credit memo that you are applying. The APPLIED_CUSTOMER_TRX_ID and APPLIED_PAYMENT_SCHEDULE_ID columns for this record belong to the invoice that is receiving the application.
If you combine an on-account credit and a receipt, Receivables creates a record in the AR_RECEIVABLE_APPLICATIONS_ALL table. The CASH_RECEIPT_ID and PAYMENT_SCHEDULE_ID columns for this record identify the receipt. The APPLIED_CUSTOMER_TRX_ID and APPLIED_PAYMENT_SCHEDULE_ID columns for this record identify the on-account credit that you are combining with the receipt.
The CONFIRMED_FLAG column is a denormalization from the AR_CASH_RECEIPTS_ALL table. If the cash receipt is not confirmed, the applications of that receipt are not reflected in the payment schedule of the transaction that the receipt is applied against.
The primary key for this table is RECEIVABLE_APPLICATION_ID, which uniquely identifies the transaction that created the row.
Flexfield: JG_AR_RECEIVABLE_APPLICATIONS
- Brazil Context: JL.BR.ARXRWMAI.Additional Info
This table shows the column names and field prompts for this context.
GLOBAL_ATTRIBUTE1
Main Amount Received
GLOBAL_ATTRIBUTE2
Base Interest Calculation
GLOBAL_ATTRIBUTE3
Calculated Interest
GLOBAL_ATTRIBUTE4
Received Interest
GLOBAL_ATTRIBUTE5
Interest Difference Action
GLOBAL_ATTRIBUTE6
Write Off Reason
GLOBAL_ATTRIBUTE7
Interest Payment Date
GLOBAL_ATTRIBUTE8
Write-Off Date
GLOBAL_ATTRIBUTE9
Calculated Interest Tmp
GLOBAL_ATTRIBUTE10
Received Interest Tmp
GLOBAL_ATTRIBUTE11
Interest Payment Date
AR_SYSTEM_PARAMETERS_ALL
The AR_SYSTEM_PARAMETERS_ALL table stores information that you supply to customize Oracle Receivables. This table stores installation-wide options. At least one row must always exist in this table.
There is no primary key for this table.
Flexfield: JG_AR_SYSTEM_PARAMETERS
- Argentina Context: JL.AR.ARXSYSPA.SYS_PARAMETERS
This table shows the column names and field prompts for this context.
GLOBAL_ATTRIBUTE1
Branch Number Method
GLOBAL_ATTRIBUTE9
Tax Location Flexfield Classification
GLOBAL_ATTRIBUTE10
Tax Location Segment Qualifier
GLOBAL_ATTRIBUTE11
Country Code
GLOBAL_ATTRIBUTE13
Tax Rule Set
GLOBAL_ATTRIBUTE14
Use Legal Messages
GLOBAL_ATTRIBUTE15
Transaction Type
- Brazil Context: JL.BR.ARXSYSPA.Additional Info
This table shows the column names and field prompts for this context.
GLOBAL_ATTRIBUTE1
Company Name
GLOBAL_ATTRIBUTE2
Interest Type
GLOBAL_ATTRIBUTE3
Interest Rate Amount
GLOBAL_ATTRIBUTE4
Interest Period
GLOBAL_ATTRIBUTE5
Interest Formula
GLOBAL_ATTRIBUTE6
Grace Days
GLOBAL_ATTRIBUTE7
Penalty Type
GLOBAL_ATTRIBUTE8
Penalty Rate Amount
GLOBAL_ATTRIBUTE9
Tax Location Flexfield Classification
GLOBAL_ATTRIBUTE10
Tax Location Segment Qualifier
GLOBAL_ATTRIBUTE11
Country Code
GLOBAL_ATTRIBUTE12
Print Invoice Immediately
GLOBAL_ATTRIBUTE13
Tax Rule Set
GLOBAL_ATTRIBUTE14
Use Legal Messages
GLOBAL_ATTRIBUTE15
Transaction Type
GLOBAL_ATTRIBUTE16
Interest Batch Source
GLOBAL_ATTRIBUTE17
Interest Transaction Type
GLOBAL_ATTRIBUTE18
Interest Receipt Method
- Colombia Context: JL.CO.ARXSYSPA.SYS_PARAMETERS
This table shows the column names and field prompts for this context.
GLOBAL_ATTRIBUTE8
VAT Tax Category
GLOBAL_ATTRIBUTE9
Tax Location Flexfield Classification
GLOBAL_ATTRIBUTE10
Tax Location Segment Qualifier
GLOBAL_ATTRIBUTE11
Country Code
GLOBAL_ATTRIBUTE13
Tax Rule Set
GLOBAL_ATTRIBUTE14
Use Legal Messages
GLOBAL_ATTRIBUTE15
Transaction Type
- Taiwan Context: JA.TW.ARXSYSPA.SYS_PARAMETERS
This context is disabled and no longer used.
AR_VAT_TAX_ALL_B
The AR_VAT_TAX_ALL_B table contains tax codes that are defined in the Tax Codes and Rates window. Each row represents a tax code and a tax rate valid for the period between the START_DATE and the END_DATE columns. For example, if you define a VAT code with a 10% rate, the TAX_RATE column would store 10.
The primary keys for this table are TAX_CODE and START_DATE.
Flexfield: JG_AR_VAT_TAX
- Argentina Context: JL.AR.ARXSUVAT.AR_VAT_TAX
This table shows the column names and field prompts for this context.
GLOBAL_ATTRIBUTE1
Tax Category
GLOBAL_ATTRIBUTE2
Print Tax Line
GLOBAL_ATTRIBUTE3
Legal Message Code
GLOBAL_ATTRIBUTE4
DGI Transaction Code
GLOBAL_ATTRIBUTE5
Turnover Jurisdiction Code
GLOBAL_ATTRIBUTE6
Municipal Jurisdiction
- Brazil Context: JL.BR.ARXSUVAT.Tax Information
This table shows the column names and field prompts for this context.
GLOBAL_ATTRIBUTE1
Tax Category
GLOBAL_ATTRIBUTE2
Print Tax Line
GLOBAL_ATTRIBUTE3
Legal Message Code
- Chile Context: JL.CL.ARXSUVAT.VAT_TAX
This table shows the column names and field prompts for this context.
GLOBAL_ATTRIBUTE4
Tax Code Classification
GLOBAL_ATTRIBUTE5
Debit Account
GLOBAL_ATTRIBUTE6
Bills of Exchange Tax
- Colombia Context: JL.CO.ARXSUVAT.AR_VAT_TAX
This table shows the column names and field prompts for this context.
GLOBAL_ATTRIBUTE1
Tax Category
GLOBAL_ATTRIBUTE2
Print Tax Line
GLOBAL_ATTRIBUTE3
Legal Message Code
- Czech Republic Context: JE.CZ.ARXSUVAT.TAX_ORIGIN
This table shows the column name and field prompt for this context.
GLOBAL_ATTRIBUTE1
Tax Origin
- Hungary Context: JE.HU.ARXSUVAT.TAX_ORIGIN
This table shows the column name and field prompt for this context.
GLOBAL_ATTRIBUTE1
Tax Origin
- Korea Context: JA.KR.ARXSUVAT.VAT
This table shows the column name and field prompt for this context.
GLOBAL_ATTRIBUTE1
Location
- Poland Context: JE.PL.ARXSUVAT.TAX_ORIGIN
This table shows the column name and field prompt for this context.
GLOBAL_ATTRIBUTE1
Tax Origin
- Portugal Context: JE.PT.ARXSUVAT.TAX_INFO
This table shows the column names and field prompts for this context.
GLOBAL_ATTRIBUTE1
Location
GLOBAL_ATTRIBUTE2
Periodic: Taxable Box
GLOBAL_ATTRIBUTE3
Periodic: Tax Box
GLOBAL_ATTRIBUTE4
Annual: Total Taxable Box
GLOBAL_ATTRIBUTE5
Annual: Taxable Box
GLOBAL_ATTRIBUTE6
Annual:Non Recoverable Taxable
GLOBAL_ATTRIBUTE7
Annual: Tax Box
- Singapore Context: JA.SG.ARXSUVAT.VAT_TAX
This context is disabled and no longer used.
- Taiwan Context: JA.TW.ARXSUVAT.VAT_TAX
This table shows the column name and field prompt for this context.
GLOBAL_ATTRIBUTE1
Government Tax Type
FA_ADDITIONS_B
FA_ADDITIONS_B contains descriptive information to help you identify your assets. Oracle Assets does not use this table to calculate depreciation.
When you add an asset, Oracle Assets inserts a row into this table and into FA_ASSET_HISTORY.
When you change the asset information stored in this table, Oracle Assets updates it in this table. It also creates a new row in FA_ASSET_HISTORY.
When you perform a unit retirement, Oracle Assets reduces the CURRENT_UNITS by the units retired.
UNIT_ADJUSTMENT_FLAG is set to YES by the Additions form if you change the number of units for an asset. The Transfers form resets it to NO after you reassign the remaining units.
Oracle Assets does not support ASSET_IDs that exceed 2,000,000,000.
Flexfield: JG_FA_ADDITIONS
- Argentina Context: JL.AR.FAXASSET.ADDITIONS_ADD
This table shows the column name and field prompt for this context.
GLOBAL_ATTRIBUTE1
Inflation Start Date
- Argentina Context: JL.AR.FAXASSET.FA_ADDITIONS
This context is disabled and no longer used.
- Chile Context: JL.CL.FAXASSET.ADDITIONS_ADD
This table shows the column name and field prompt for this context.
GLOBAL_ATTRIBUTE1
Inflation Start Date
- Colombia Context: JL.CO.FAXASSET.ADDITIONS_ADD
This table shows the column name and field prompt for this context.
GLOBAL_ATTRIBUTE1
Inflation Start Date
- Greece Context: JE.GR.FAXASSET.ASSET
This table shows the column names and field prompts for this context.
GLOBAL_ATTRIBUTE1
Commitment
GLOBAL_ATTRIBUTE2
Investment Law
- Mexico Context: JL.MX.FAXASSET.ADDITIONS_ADD
This table shows the column name and field prompt for this context.
GLOBAL_ATTRIBUTE1
Inflation Start Date
FA_ADJUSTMENTS
FA_ADJUSTMENTS stores information that Oracle Assets needs to create journal entries for transactions. The posting program creates journal entries for regular depreciation expense from information in FA_DEPRN_DETAIL. Oracle Assets inserts a row in this table for the debit and credit sides of a financial transaction. All the rows for the same transaction have the same value in the TRANSACTION_HEADER_ID column.
The SOURCE_TYPE_CODE column tells you which program created the adjustment:
ADDITION
Depreciation program
ADJUSTMENT
Expensed or Amortized Adjustment User Exit
CIP ADDITION
Depreciation program
CIP ADJUSTMENT
Expensed or Amortized Adjustment User Exit
CIP RETIREMENT
Gain/loss program
DEPRECIATION
Depreciation program (Retroactive transactions and expensed depreciation adjustments)
RETIREMENT
Gain/loss program
RECLASS
Reclassification user exit
TRANSFER
Transfers form
TAX
Reserve Adjustments form
REVALUATION
Mass revaluation program
The ADJUSTMENT_TYPE column tells you which type of account Oracle Assets adjusts.
DEBIT_CREDIT_FLAG is DR if the amount is a debit and CR if the amount is a credit.
ADJUSTMENT_AMOUNT is the amount debited or credited to the account.
ANNUALIZED_ADJUSTMENT is the adjustment amount for a period times the number of periods in a fiscal year. The depreciation program uses it to calculate the depreciation adjustment for an asset when you perform multiple retroactive transactions on the asset. Oracle Assets calculates ADJUSTMENT_PER_PERIOD by dividing the ADJUSTMENT_AMOUNT for a retroactive transaction by the number of periods between the period you entered the transaction and the period that it was effective. For current period transactions, this column is zero.
PERIOD_COUNTER_CREATED IS the period that you entered the adjustment into Oracle Assets.
PERIOD_COUNTER_ADJUSTED is the period to which the adjustment applies. It is the same as PERIOD_COUNTER_CREATED, unless you enter a reserve adjustment, in which case PERIOD_COUNTER_ADJUSTED is the last period of the fiscal year to which the adjustment applies.
CODE_COMBINATION_ID indicates the Accounting Flexfield combination Oracle Assets debits or credits for all transactions except reclassifications and intercompany transfers. This CODE_COMBINATION_ID is generated using the Account Generator, and the posting program does not perform any further processing.
Flexfield: JG_FA_ADJUSTMENTS
- Argentina Context: JL.AR.FAXSUCAT.FA_ADJUSTMENTS
This context is disabled and no longer used.
FA_BOOKS
FA_BOOKS contains the information that Oracle Assets needs to calculate depreciation.
When you initially add an asset, Oracle Assets inserts one row into the table. This becomes the "active" row for the asset. Whenever you use the Depreciation Books form to change the asset's depreciation information, or if you retire or reinstate it, Oracle Assets inserts another row into the table, which then becomes the new "active" row, and marks the previous row as obsolete. At any point in time, there is only one "active" row in the table for an asset in any given depreciation book. Generally, Oracle Assets uses the active row, but if you run a report for a prior accounting period, Oracle Assets selects the row that was active during that period. You can identify the active row for an asset in a book because it is the only one whose DATE_INEFFECTIVE and TRANSACTION_HEADER_ID_OUT are NULL.
When Oracle Assets terminates a row, the DATE_INEFFECTIVE and TRANSACTION_HEADER_OUT are set to the DATE_EFFECTIVE and TRANSACTION_HEADER_IN of the new row, respectively. This means that you can easily identify rows affected by the same transaction because they have the same DATE_EFFECTIVE / DATE_INEFFECTIVE and TRANSACTION_HEADER_ID_IN / TRANSACTION_HEADER_ID_OUT pairs. When Oracle Assets creates the new row, the value used for the TRANSACTION_HEADER_ID_IN column is the same as the TRANSACTION_HEADER_ID in the row inserted into FA_TRANSACTION_HEADERS, and the DATE_EFFECTIVE is the system date.
When you retire an asset, Oracle Assets inserts a new row to reduce the COST by the amount retired.
When you reinstate an asset, Oracle Assets inserts a new row to increase the COST by the COST_RETIRED in the corresponding row in FA_RETIREMENTS.
RATE_ADJUSTMENT_FACTOR is originally 1. It is used to spread depreciation over the remaining life of an asset after an amortization or revaluation. If you perform a revaluation or an amortized adjustment, Oracle Assets resets the Rate Adjustment Factor to prorate the remaining recoverable net book value over the remaining life. This fraction is calculated as [Recoverable Cost - what Depreciation Reserve would be]/Recoverable Cost. The depreciation program uses this value to adjust the depreciation rate for an asset.
NOTE:
Altering the Adjusted Cost value damages data integrity.
COST_CHANGE_FLAG is set to YES by the Depreciation Books form if you change the financial information for an asset and elect to expense the resulting depreciation adjustment. The depreciation program resets it to NO when it depreciates the asset.
ADJUSTMENT_REQUIRED_STATUS tells the depreciation program to make an adjustment to depreciation expense for retroactive transactions. The Depreciation Books form sets it to ADD for a retroactive addition, the Transfers form sets it to TFR for a retroactive transfer, and it is NONE for all other cases.
ADJUSTED_COST is used to calculate depreciation; it is the remaining depreciable basis since addition or latest amortized adjustment or revaluation.
Oracle Assets resets the Adjusted Cost at the beginning of the fiscal year for assets depreciating under NBV-based methods. ADJUSTED_CAPACITY is similar.
NOTE:
Altering the Adjusted Cost value damages data integrity.
TAX_REQUEST_ID is the concurrent request number for the Mass Copy process that copied the asset into a tax book. This column is always NULL for corporate book rows.
PERIOD_COUNTER_CAPITALIZED is the period in which you capitalized a construction-in-process (CIP) asset.
TRANSACTION_HEADER_ID_IN identifies the transaction that created the row.
Flexfield: JG_FA_BOOKS
- Argentina Context: JL.AR.FAXASSET.FA_BOOKS
This table shows the column name and field prompt for this context.
GLOBAL_ATTRIBUTE1
Adjust for Inflation
- Chile Context: JL.CL.FAXASSET.FA_BOOKS
This table shows the column name and field prompt for this context.
GLOBAL_ATTRIBUTE1
Adjust for Inflation
- Colombia Context: JL.CO.FAXASSET.FA_BOOKS
This table shows the column names and field prompts for this context.
GLOBAL_ATTRIBUTE1
Adjust for Inflation
GLOBAL_ATTRIBUTE2
Current Revaluation
GLOBAL_ATTRIBUTE3
Previous Revaluation
GLOBAL_ATTRIBUTE4
Last Appraisal Number
GLOBAL_ATTRIBUTE5
Last Appraisal Date
GLOBAL_ATTRIBUTE6
Last Appraisal Value
GLOBAL_ATTRIBUTE7
Depreciation on Inflation Adjusted Cost
- Mexico Context: JL.MX.FAXASSET.FA_BOOKS
This table shows the column name and field prompt for this context.
GLOBAL_ATTRIBUTE1
Adjust for Inflation
FA_BOOK_CONTROLS
FA_BOOK_CONTROLS contains control information that affects all assets in a depreciation book.
LAST_PERIOD_COUNTER is the last period for which you ran the depreciation program on a book. Oracle Assets uses it to prevent you from running the depreciation program multiple times for a period and to ensure that you run it for consecutive periods.
INITIAL_PERIOD_COUNTER is the period prior to the one in which you created this book.
INITIAL_DATE is the last date on which you ran depreciation for this book on your previous system before you started using Oracle Assets.
ACCOUNTING_FLEX_STRUCTURE determines which Accounting Flexfield structure the depreciation book uses. It matches aCHART_OF_ACCOUNTS_ID in GL_CODE_COMBINATIONS. Oracle Assets uses it to configure Accounting Flexfield pop-up windows and to runreports that use the account number.
DEPRN_REQUEST_ID is the concurrent request number for the last time you ran the depreciation program on a book. Oracle Assets updates this columnas soon as the depreciation program begins running.
DEPRN_STATUS specifies whether depreciation is locking the book. Oracle Assets uses DEPRN_STATUS to prevent you from entering transactions while depreciation is running. It can be:
C
Completed
E
Error
R
Running
S
Submitted
Flexfield: JG_FA_BOOK_CONTROLS
- Argentina Context: JL.AR.FAXSUBCT.FA_BOOK_CTRLS
This table shows the column names and field prompts for this context.
GLOBAL_ATTRIBUTE1
Adjust for Inflation
GLOBAL_ATTRIBUTE2
Last Inflation Adjustment Period
GLOBAL_ATTRIBUTE3
Last Inflation Adjustment
GLOBAL_ATTRIBUTE6
Journal Category for Depreciation Expense of Retired Assets
- Chile Context: JL.CL.FAXSUBCT.FA_BOOK_CONTROL
This context is disabled and no longer used.
- Chile Context: JL.CL.FAXSUBCT.FA_BOOK_CTRLS
This table shows the column names and field prompts for this context.
GLOBAL_ATTRIBUTE1
Adjust for Inflation
GLOBAL_ATTRIBUTE2
Last Inflation Adjustment Period
GLOBAL_ATTRIBUTE3
Last Inflation Adjustment
GLOBAL_ATTRIBUTE6
Journal Category for Depreciation Expense of Retired Assets
- Colombia Context: JL.CO.FAXSUBCT.FA_BOOK_CONTROL
This context is disabled and no longer used.
- Colombia Context: JL.CO.FAXSUBCT.FA_BOOK_CTRLS
This table shows the column names and field prompts for this context.
GLOBAL_ATTRIBUTE1
Adjust for Inflation
GLOBAL_ATTRIBUTE2
Last Inflation Adjustment Period
GLOBAL_ATTRIBUTE3
Last Inflation Adjustment
GLOBAL_ATTRIBUTE5
Last Closed Period
GLOBAL_ATTRIBUTE6
Inflation Adjustment Journal Category
GLOBAL_ATTRIBUTE7
Inflation Adjustment Reclassification Journal Category
GLOBAL_ATTRIBUTE8
Inflation Adjustment CIP Reclass Journal Category
GLOBAL_ATTRIBUTE9
Inflation Adjustment Transfer Journal Category
GLOBAL_ATTRIBUTE10
Inflation Adjustment CIP Transfer Journal Category
GLOBAL_ATTRIBUTE11
Inflation Adjustment Retirements Journal Category
GLOBAL_ATTRIBUTE12
Inflation Adjustment CIP Retirements Journal Category
GLOBAL_ATTRIBUTE13
Technical Appraisal Journal Category
GLOBAL_ATTRIBUTE14
Inflation Adjustment Addition Journal Category
GLOBAL_ATTRIBUTE15
Inflation Adjustment CIP Addition Journal Category
GLOBAL_ATTRIBUTE16
Inflation Adjustment - Adjustment Journal Category
GLOBAL_ATTRIBUTE17
Inflation Adjustment CIP Adjustment Journal Category
GLOBAL_ATTRIBUTE18
CIP Inflation Adjustment Journal Category
GLOBAL_ATTRIBUTE19
Last Transferred Period
- Mexico Context: JL.MX.FAXSUBCT.FA_BOOK_CTRLS
This table shows the column names and field prompts for this context.
GLOBAL_ATTRIBUTE1
Adjust for Inflation
GLOBAL_ATTRIBUTE2
Last Inflation Adjustment Period
GLOBAL_ATTRIBUTE3
Last Inflation Adjustment
GLOBAL_ATTRIBUTE4
Middle Month Function
GLOBAL_ATTRIBUTE6
Journal Category for Depreciation Expense of Retired Assets
FA_CATEGORY_BOOKS
FA_CATEGORY_BOOKS provides cost and reserve accounts for a book and category combination.
The Asset Categories form inserts a row in this table for each book in which you use an asset category. For example, if you define a category for three depreciation books, Oracle Assets inserts three rows into this table.
Flexfield: JG_FA_CATEGORY_BOOKS
- Argentina Context: JL.AR.FAXSUCAT.FA_CAT_BOOKS
This table shows the column names and field prompts for this context.
GLOBAL_ATTRIBUTE1
Adjust for Inflation
GLOBAL_ATTRIBUTE16
Asset Group
- Chile Context: JL.CL.FAXSUCAT.FA_CAT_BOOKS
This table shows the column name and field prompt for this context.
GLOBAL_ATTRIBUTE1
Adjust for Inflation
- Colombia Context: JL.CO.FAXSUCAT.FA_CAT_BOOKS
This table shows the column names and field prompts for this context.
GLOBAL_ATTRIBUTE1
Adjust for Inflation
GLOBAL_ATTRIBUTE2
Chart of Accounts
GLOBAL_ATTRIBUTE3
Inflation Adjustment Cost Account
GLOBAL_ATTRIBUTE4
Indexing Cost Account
GLOBAL_ATTRIBUTE5
Inflation Adjustment Depreciation Reserve Account
GLOBAL_ATTRIBUTE6
Indexing Depreciation Reserve Account
GLOBAL_ATTRIBUTE9
Inflation Adjustment CIP Cost Account
GLOBAL_ATTRIBUTE10
Deferred Indexing CIP Cost Account
GLOBAL_ATTRIBUTE11
Technical Appraisal Valuation Account
GLOBAL_ATTRIBUTE12
Technical Appraisal Surplus Account
GLOBAL_ATTRIBUTE13
Technical Appraisal Reserve Account
GLOBAL_ATTRIBUTE14
Technical Appraisal Reserve Expense Account
GLOBAL_ATTRIBUTE15
Technical Appraisal Reserve Recovery Account
- Mexico Context: JL.MX.FAXSUCAT.FA_CAT_BOOKS
This table shows the column name and field prompt for this context.
GLOBAL_ATTRIBUTE1
Adjust for Inflation
- Mexico Context: JLMX.FAXSUCAT.FA_CAT_BOOKS
This context is disabled and no longer used.
FA_MASS_ADDITIONS
FA_MASS_ADDITIONS stores information about assets that you want to automatically add to Oracle Assets from another system. You can use this table to load assets for system conversions.
When you run the mass additions create process, Oracle Assets inserts one row into this table for each invoice line it selects from Oracle Payables.
When you run the mass additions post process, Oracle Assets creates assets or adjustments from any rows in which the POSTING_STATUS is POST.
Mass additions post inserts rows into FA_ADDITIONS, FA_ASSET_HISTORY, FA_ASSET_INVOICES, FA_BOOKS, FA_DISTRIBUTION_HISTORY, FA_TRANSACTION_HEADERS, FA_INVOICE_TRANSACTIONS, FA_DEPRN_SUMMARY, FA_DEPRN_DETAIL, and FA_TRANSFER_DETAILS. Oracle Assets then changes POSTING_STATUS and QUEUE_NAME to POSTED.
POSTING_STATUS shows the status of a mass addition. POSTING_STATUS and QUEUE_NAME are the same, except when you assign user-defined queue names, or you split or merge a mass addition. The following table summarizes the relationship between POSTING_STATUS and QUEUE_NAME:
NEW
NEW -- Status when mass addition is first created.
ON HOLD
ON HOLD and User-defined hold queues -- Mass addition is waiting for additional information before posting.
Posting Status after split
SPLIT -- You divided a multi-unit mass addition into individual mass additions.
Posting Status after merge
MERGED -- You merged other mass additions into this one.
POST
ADD TO ASSET -- You are adding a mass addition to an existing asset as a cost adjustment and the mass addition is ready for posting.
POST
POST -- Mass addition is ready for posting.
POSTED
POSTED -- The Mass additions posting program created an asset from this mass addition.
DELETE
DELETE -- You want to delete this mass addition.
The SPLIT_MERGED_CODE column tells you whether a mass addition was split or merged:
MC
Merged child - You merged this mass addition into another one.
MP
Merged parent - You merged other mass additions into this one.
SC
Split child - Oracle Assets created this mass addition from a multi-unit mass addition.
SP
Split parent - You split this multi-unit mass addition into single-unit mass additions.
POST_BATCH_ID identifies the post mass additions concurrent request that posted your assets to Oracle Assets.
ADD_TO_ASSET_ID identifies the asset to which you are adding the cost of the mass addition in this row.
PARENT_ASSET_ID identifies the parent asset of a mass addition. The mass addition post process inserts this value into the PARENT_ASSET_ID column in the FA_ADDITIONS table when you post the mass addition.
PARENT_MASS_ADDITION_ID identifies the mass addition into which you merged this mass addition.
When you add the cost of a mass addition to an existing asset, NEW_MASTER_FLAG is set to YES by the Prepare Mass Additions form when the resulting asset has the asset category and description of the mass addition. This value is NO when the resulting asset has the asset category and description of the existing asset.
ATTRIBUTE1 through ATTRIBUTE30 descriptive flexfield segments are NOT the same as on FA_ADDITIONS, since they are on a different table.
For more information on loading this table, read the Importing Asset Information into Oracle Assets Using Mass Additions essay in the Oracle Financials and Oracle Government Financials Implementation Manual.
When you add a mass addition to an existing asset, Oracle Assets does not allow you to enter a salvage value for the mass addition. If adding the mass addition changes the salvage value of the destination asset, you can adjust the salvage value of the destination asset in the Depreciation Books form.
Flexfield: JG_FA_MASS_ADDITIONS
- Argentina Context: JL.AR.FAXMADDS.FA_MASS_ADD
This table shows the column name and field prompt for this context.
GLOBAL_ATTRIBUTE1
Inflation Start Date
- Chile Context: JL.CL.FAXMADDS.FA_MASS_ADD
This table shows the column name and field prompt for this context.
GLOBAL_ATTRIBUTE1
Inflation Start Date
- Colombia Context: JL.CO.FAXMADDS.FA_MASS_ADD
This table shows the column name and field prompt for this context.
GLOBAL_ATTRIBUTE1
Inflation Start Date
- Mexico Context: JL.MX.FAXMADDS.FA_MASS_ADD
This table shows the column name and field prompt for this context.
GLOBAL_ATTRIBUTE1
Inflation Start Date
FND_CURRENCIES
FND_CURRENCIES stores information about currencies. Each row includes the currency code (CURRENCY_CODE) established by ISO (International Standards Organization) standard, the name of the currency (NAME), a flag to indicate whether the currency is enabled for use at your site (ENABLED_FLAG), a flag to indicate if this is a currency or a statistical unit (CURRENCY_FLAG), and the territory code of the issuing country (ISSUING_TERRITORY_CODE). Each row also includes the number of digits to the right of the decimal point (PRECISION), the extended precision (EXTENDED_PRECISION), the symbol denoting the currency, a description of the currency, and descriptive flexfield attribute columns. There is also information on when the currency becomes active and inactive, and the minimum accountable unit for the currency. You need one row for each currency defined with Oracle Application Object Library. Oracle Application Object Library uses this information to display dynamic currency values. You can also use this information to assign a currency to a set of books.
Flexfield: JG_FND_CURRENCIES
- Argentina Context: JL.AR.FNDNLDCX.CURRENCIES
This table shows the column name and field prompt for this context.
GLOBAL_ATTRIBUTE1
Currency Code
- Brazil Context: JL.BR.FNDNLDCX.FND_CURRENCY
This table shows the column name and field prompt for this context.
GLOBAL_ATTRIBUTE1
CNAB Standard Code
GL_JE_HEADERS
GL_JE_HEADERS stores journal entries. There is a one-to-many relationship between journal entry batches and journal entries. Each row in this table includes the associated batch ID, the journal entry name and description, and other information about the journal entry. This table corresponds to the Journals window of the Enter Journals form. STATUS is 'U' for unposted, 'P' for posted. Other statuses indicate that an error condition was found. A complete list is below.
CONVERSION_FLAG equal to 'N' indicates that you manually changed a converted amount in the Journal Entry Lines region of a foreign currency journal entry. In this case, the posting program does not re-convert your foreign amounts. This can happen only if your user profile option MULTIPLE_RATES_PER_JE is 'Yes'. BALANCING_SEGMENT_VALUE is null if there is only one balancing segment value in your journal entry. If there is more than one, BALANCING_SEGMENT_VALUE is the greatest balancing segment value in your journal entry.
Following is a list of STATUS codes for this table:
-
Bad rounding account
>
Reserved for country - specific functionality
<
Reserved for country - specific functionality
U
Unposted
P
Posted
1
Invalid currency code
2
Invalid source
3
Invalid category
4
Invalid set of books
5
Invalid set of books
6
(Actual) Unopened period
6
(Budget) Invalid budget version
6
(Encumbrance) Invalid encumbrance type
7
Invalid entry
8
Invalid entry
A
Code combination does not exist
B
Multiple lines have code combination error
C
Code combination: detail posting not allowed
D
Multiple lines have code combination error
E
Multiple lines have code combination error
F
Code combination not enabled
G
Multiple lines have code combination error
H
Multiple lines have code combination error
I
Multiple lines have code combination error
J
Code combination not yet effective (date)
K
Multiple lines have code combination error
L
Multiple lines have code combination error
M
Code combination past effective date
N
Multiple lines have code combination error
O
Multiple lines have code combination error
Q
Multiple lines have code combination error
R
Multiple lines have code combination error
T
Multiple lines have code combination error
V
Multiple lines have code combination error
Z
Multiple lines have code combination error
Flexfield: JG_GL_JE_HEADERS
- Greece Context: JE.GR.GLXJEENT.HEADER
This table shows the column names and field prompts for this context.
GLOBAL_ATTRIBUTE1
Accounting Sequence Name
GLOBAL_ATTRIBUTE2
Accounting Sequence Number
GL_JE_LINES
GL_JE_LINES stores the journal entry lines that you enter in the Enter Journals form. There is a one-to-many relationship between journal entries and journal entry lines. Each row in this table stores the associated journal entry header ID, the line number, the associated code combination ID, and the debits or credits associated with the journal line. STATUS is 'U' for unposted or 'P' for posted.
Flexfield: JG_GL_JE_LINES_INFO
- Colombia Context: JL.CO.GLXJEENT.THIRDPARTY
This table shows the column name and field prompt for this context.
GLOBAL_ATTRIBUTE1
Third Party ID
- Poland Context: JE.PL.GLXJEENT.SEQUENCE
This table shows the column names and field prompts for this context.
GLOBAL_ATTRIBUTE1
Journal Line Sequence
- Turkey Context: JE.TR.GLXJEENT.SEQUENCE
This table shows the column names and field prompts for this context.
GLOBAL_ATTRIBUTE1
Journal Line Sequence
- Czech Context: JE.CZ.GLXJEENT.SEQUENCE
This table shows the column names and field prompts for this context.
GLOBAL_ATTRIBUTE3
Final VAT Register Request ID
- Hungary Context: JE.HU.GLXJEENT.SEQUENCE
This table shows the column names and field prompts for this context.
GLOBAL_ATTRIBUTE3
Final VAT Register Request ID
- Poland Context: JE.PL.GLXJEENT.SEQUENCE
This table shows the column names and field prompts for this context.
GLOBAL_ATTRIBUTE3
Final VAT Register Request ID
- Slovakia Context: JE.SK.GLXJEENT.SEQUENCE
This table shows the column names and field prompts for this context.
GLOBAL_ATTRIBUTE3
Final VAT Register Request ID
GL_SETS_OF_BOOKS
GL_SETS_OF_BOOKS stores information about the sets of books you define in your Oracle General Ledger application. Each row includes the set of books name, description, functional currency, and other information. This table corresponds to the Set of Books form.
Flexfield: JG_GL_SETS_OF_BOOKS
- Greece Context: JE.GR.GLXSTBKS.BOOKS
This table shows the column names and field prompts for this context.
GLOBAL_ATTRIBUTE1
Default Cutoff Days
GLOBAL_ATTRIBUTE2
Assign Accounting Sequence to GL Journals from AX?
GLOBAL_ATTRIBUTE3
Prefix External Reference with Accounting Sequence?
- Czech Context: JE.CZ.GLXSTBKS.BOOKS
This table shows the column names and field prompts for this context.
GLOBAL_ATTRIBUTE1
VAT Reporting Calendar
GLOBAL_ATTRIBUTE2
VAT Register Sequencing
- Hungary Context: JE.HU.GLXSTBKS.BOOKS
This table shows the column names and field prompts for this context.
GLOBAL_ATTRIBUTE1
VAT Reporting Calendar
GLOBAL_ATTRIBUTE2
VAT Register Sequencing
- Poland Context: JE.PL.GLXSTBKS.BOOKS
This table shows the column names and field prompts for this context.
GLOBAL_ATTRIBUTE1
VAT Reporting Calendar
GLOBAL_ATTRIBUTE2
VAT Register Sequencing
- Slovakia Context: JE.SK.GLXSTBKS.BOOKS
This table shows the column names and field prompts for this context.
GLOBAL_ATTRIBUTE1
VAT Reporting Calendar
GLOBAL_ATTRIBUTE2
VAT Register Sequencing
HR_LOCATIONS_ALL
HR_LOCATIONS_ALL holds information about specific work locations defined for an enterprise, including address details.
Flexfield: JG_HR_LOCATIONS
- Argentina Context: JL.AR.PERWSLOC.LOC
This table shows the column names and field prompts for this context.
GLOBAL_ATTRIBUTE1
Organization Tax Class
GLOBAL_ATTRIBUTE6
Tax Code
GLOBAL_ATTRIBUTE7
Branch Number
GLOBAL_ATTRIBUTE8
Company Name
GLOBAL_ATTRIBUTE9
Alternate Company Name
GLOBAL_ATTRIBUTE11
Primary ID Number
GLOBAL_ATTRIBUTE12
Primary ID Validation Digit
GLOBAL_ATTRIBUTE13
Federal Tax Bureau Office
GLOBAL_ATTRIBUTE14
Inception Date
- Brazil Context: JL.BR.PERWSLOC.LOC
This table shows the column names and field prompts for this context.
GLOBAL_ATTRIBUTE1
Organization Tax Class
GLOBAL_ATTRIBUTE2
Tax Rate Differential Account
GLOBAL_ATTRIBUTE3
COA_ID
GLOBAL_ATTRIBUTE4
VALIDATE_FULL
GLOBAL_ATTRIBUTE5
Brand
GLOBAL_ATTRIBUTE6
Tax Code
- Chile Context: JL.CL.PERWSLOC.LOC
This table shows the column names and field prompts for this context.
GLOBAL_ATTRIBUTE8
Company Name
GLOBAL_ATTRIBUTE9
Alternate Company Name
GLOBAL_ATTRIBUTE11
Primary ID Number
GLOBAL_ATTRIBUTE12
Primary ID Validation Digit
GLOBAL_ATTRIBUTE13
Inscription
GLOBAL_ATTRIBUTE14
Legal Representative
GLOBAL_ATTRIBUTE15
Legal Representative ID
- Colombia Context: JL.CO.PERWSLOC.LOC
This table shows the column names and field prompts for this context.
GLOBAL_ATTRIBUTE1
Organization Tax Class
GLOBAL_ATTRIBUTE6
Tax Code
GLOBAL_ATTRIBUTE8
Company Name
GLOBAL_ATTRIBUTE9
Alternate Company Name
GLOBAL_ATTRIBUTE11
Primary ID Number
GLOBAL_ATTRIBUTE12
Primary ID Validation Digit
GLOBAL_ATTRIBUTE13
City Code
GLOBAL_ATTRIBUTE14
Economic Activity Code
- Greece Context: JE.GR.PERWSLOC.LOC
This table shows the column names and field prompts for this context.
GLOBAL_ATTRIBUTE1
Fiscal Company
GLOBAL_ATTRIBUTE2
VAT Number
GLOBAL_ATTRIBUTE3
Tax Office
GLOBAL_ATTRIBUTE4
Tax Area
GLOBAL_ATTRIBUTE5
Company Activity
GLOBAL_ATTRIBUTE6
Electronic File Number
- Italy Context: JE.IT.PERWSLOC.LOC
This table shows the column names and field prompts for this context.
GLOBAL_ATTRIBUTE1
Fiscal Code
GLOBAL_ATTRIBUTE2
Company Name
- Korea Context: JA.KR.PERWSLOC.WITHHOLDING
This table shows the column names and field prompts for this context.
GLOBAL_ATTRIBUTE1
Tax Registration Number
GLOBAL_ATTRIBUTE4
Taxable Person
GLOBAL_ATTRIBUTE5
Industry Subclassification
GLOBAL_ATTRIBUTE6
Industry Classification
GLOBAL_ATTRIBUTE11
Corporate Identification
- Singapore Context: JA.SG.PERWSLOC.LOC
This table shows the column names and field prompts for this context.
GLOBAL_ATTRIBUTE2
Job Title
GLOBAL_ATTRIBUTE3
Title
GLOBAL_ATTRIBUTE4
Taxable Person
GLOBAL_ATTRIBUTE5
Bank Code
GLOBAL_ATTRIBUTE6
Bank Branch Code
GLOBAL_ATTRIBUTE7
Bank Account Number
GLOBAL_ATTRIBUTE13
Tax Filing Period
- Spain Context: JE.ES.PERWSLOC.PRL_NO
This table shows the column name and field prompt for this context.
GLOBAL_ATTRIBUTE1
Property Rental
- Spain Context: JE.ES.PERWSLOC.PRL_YES
This table shows the column names and field prompts for this context.
GLOBAL_ATTRIBUTE1
Property Rental
GLOBAL_ATTRIBUTE2
Rates Reference
GLOBAL_ATTRIBUTE3
Stair Num
GLOBAL_ATTRIBUTE4
Floor Num
GLOBAL_ATTRIBUTE5
Door Num
- Spain Context: JE.ES.PERWSLOC.RENTED_LOCATION
This context is disabled and no longer used.
- Taiwan Context: JA.TW.PERWSLOC.LOC
This table shows the column names and field prompts for this context.
GLOBAL_ATTRIBUTE1
Taxpayer ID
GLOBAL_ATTRIBUTE2
Taxable Person
HZ_CUSTOMER_PROFILES
The HZ_CUSTOMER_PROFILES table stores information about the credit characteristics of a single customer account. A profile class defined in the HZ_CUSTOMER_PROFILE_CLASSES table can be used to provide default values for the attributes in this table. The default values copied into this table can be modified to more closely match the customer account defined in this table.
The primary key for this table is CUST_ACCOUNT_PROFILE_ID.
Flexfield: JG_HZ_CUSTOMER_PROFILES
- Brazil Context: JL.BR.ARXCUDCI.Additional Info
This table shows the column names and field prompts for this context.
GLOBAL_ATTRIBUTE1
Remittance Protest Instructions
GLOBAL_ATTRIBUTE2
Remittance Interest Instructions
HZ_CUST_ACCOUNTS
The HZ_CUST_ACCOUNTS table stores information about customer relationships established with a party. Since a party can have multiple customer accounts, this table may contain several records for a single party. For example, an individual person may establish a personal account, a family account, and a professional account for a consulting practice. Note that the focus of this table is a business relationship and how transactions are conducted in the relationship.
The primary key for this table is CUST_ACCOUNT_ID.
Flexfield: JG_HZ_CUST_ACCOUNTS
- Argentina Context : JL.AR.ARXCUDCI.CUSTOMERS
This table shows the column names and field prompts for this context.
GLOBAL_ATTRIBUTE9
Origin
GLOBAL_ATTRIBUTE10
Primary ID Type
GLOBAL_ATTRIBUTE12
Primary ID Validation Digit
- Chile Context : JL.CL.ARXCUDCI.CUSTOMERS
This table shows the column names and field prompts for this context.
GLOBAL_ATTRIBUTE10
Primary ID Type
GLOBAL_ATTRIBUTE12
Primary ID Validation Digit
- Colombia Context : JL.CO.ARXCUDCI.CUSTOMERS
This table shows the column names and field prompts for this context.
GLOBAL_ATTRIBUTE10
Primary ID Type
GLOBAL_ATTRIBUTE12
Primary ID Validation Digit
- Greece Context : JE.GR.ARXCUDCI.CUSTOMERS
This table shows the column name and field prompt for this context.
GLOBAL_ATTRIBUTE1
Public Sector Companies Reporting
HZ_CUST_ACCT_SITES_ALL
The HZ_CUST_ACCT_SITES_ALL table stores information about customer account sites or locations for customer accounts. One customer account can have multiple sites or locations. Address information for a site is stored in the HZ_LOCATIONS table.
The primary key for this table is CUST_ACCT_SITE_ID.
Flexfield : JG_HZ_CUST_ACCT_SITES
- Argentine Context : JL.AR.ARXCUDCI.Additional
This table shows the column names and field prompts for this context.
GLOBAL_ATTRIBUTE8
Contributor Class
GLOBAL_ATTRIBUTE9
Use Cust Site Profile
- Brazil Context : JL.BR.ARXCUDCI.Additional
This table shows the column names and field prompts for this context.
GLOBAL_ATTRIBUTE2
Inscription Type
GLOBAL_ATTRIBUTE3
Inscription Number
GLOBAL_ATTRIBUTE4
Inscription Branch
GLOBAL_ATTRIBUTE5
Inscription Digit
GLOBAL_ATTRIBUTE6
State Inscription
GLOBAL_ATTRIBUTE7
Minicipal Inscription
GLOBAL_ATTRIBUTE8
Contributor Class
GLOBAL_ATTRIBUTE9
Use Cust Site Profile
- Brazil Context : JL.BR.ARXSURMT.Additional
This table shows the column name and field prompt for this context.
GLOBAL_ATTRIBUTE1
Company Name
- Colombia Context : JL.CO.ARXCUDCI.Additional
This table shows the column names and field prompts for this context.
GLOBAL_ATTRIBUTE8
Contributor Class
GLOBAL_ATTRIBUTE9
Use Cust Site Profile
- Korea Context : JA.KR.ARXCUDCI.VAT
This table shows the column names and field prompts for this context.
GLOBAL_ATTRIBUTE1
Taxable Person
GLOBAL_ATTRIBUTE3
Industry Subclassification
GLOBAL_ATTRIBUTE8
Industry Classification
HZ_CUST_PROFILE_CLASSES
The HZ_CUST_PROFILE_CLASSES table stores information about the credit characteristics that are common across a group of customer accounts. The characteristics specified in this table can be used as default characteristics for similar customer accounts. For example, you can create a profile class called Large Independent Retail Stores and can specify several attributes that describe this class of customer. In the future, you can assign new customers to this class so that the new customer inherits the characteristics of the class.
The primary key for this table is PROFILE_CLASS_ID.
Flexfield: JG_HZ_CUSTOMER_PROFILE_CLASSES
- Brazil Context: JL.BR.ARXMACPC.Additional Info
This table shows the column names and field prompts for this context.
GLOBAL_ATTRIBUTE1
Remit Protest Instructions
GLOBAL_ATTRIBUTE2
Remit Interest Instructions
GLOBAL_ATTRIBUTE3
Interest Type
GLOBAL_ATTRIBUTE4
Interest Rate/Amount
GLOBAL_ATTRIBUTE5
Interest Period
GLOBAL_ATTRIBUTE6
Interest Formula
GLOBAL_ATTRIBUTE7
Grace Days
GLOBAL_ATTRIBUTE8
Penalty Type
GLOBAL_ATTRIBUTE9
Penalty Rate/Amount
HZ_CUST_SITE_USES_ALL
The HZ_CUST_SITE_USES_ALL table stores information about the business purposes assigned to a customer account site. A customer account site can have multiple purposes; however, each record in this table only specifies one purpose for a customer account site. For example, a customer account site may be assigned as a Ship-To site in one record and as a Bill-To site in another record. Note that address information about sites is stored in the HZ_LOCATIONS table.
The primary key for this table is SITE_USE_ID.
Flexfield: JG_HZ_CUST_SITE_USES
- Greece Context : JE.GR.ARXCUDCI.RA
This table shows the column name and field prompt for this context.
GLOBAL_ATTRIBUTE1
Receipt Acknowledgement
- Portugal Context : JE.PT.ARXCUDCI.RA
This table shows the column name and field prompt for this context.
GLOBAL_ATTRIBUTE1
Receipt Acknowledgement
- Spain Context : JE.ES.ARXCUDCI.RA
This table shows the column name and field prompt for this context.
GLOBAL_ATTRIBUTE1
Charges Bearer
MTL_ITEM_TEMPLATES
MTL_ITEM_TEMPLATES is the definition table for item templates. It contains the user-defined name (TEMPLATE_NAME) and description (DESCRIPTION).
You can use a template to set certain item attributes. When you apply a template to an item, the enabled item attributes are propagated to the item. You may apply several different templates to an item to achieve a layering of attributes.
Flexfield: JG_MTL_ITEM_TEMPLATES
- Brazil Context: JL.BR.INVIDTMP.Fiscal
This table shows the column names and field prompts for this context.
GLOBAL_ATTRIBUTE1
Fiscal Classification Code
GLOBAL_ATTRIBUTE2
Transaction Nature
GLOBAL_ATTRIBUTE3
Item Origin
GLOBAL_ATTRIBUTE4
Item Fiscal Type
GLOBAL_ATTRIBUTE5
Federal Tributary Situation
GLOBAL_ATTRIBUTE6
State Tributary Situation
GLOBAL_ATTRIBUTE7
IPI Tax Name
GLBOAL_ATTRIBUTE8
Inventory Item Application
GLBOAL_ATTRIBUTE9
IPI Tax Switcher
MTL_PARAMETERS
MTL_PARAMETERS maintains a set of default options like general ledger accounts; locator, lot, and serial controls; inter-organization options; costingmethod; etc. for each organization defined in Oracle Inventory.
Each organization's item master organization (MASTER_ORGANIZATION_ID) and costing organization (COST_ORGANIZATION_ID) are maintained here.
You specify which manufacturing calendar the organization will use (CALENDAR_CODE), as well as the set of exceptions to this calendar(CALENDAR_EXCEPTION_SET_ID).
NEGATIVE_INV_RECEIPT_CODE indicates whether this organization will allow negative balances in inventory. It is used in the transaction system toensure, for example, that you do not over-issue a particular item (if you have indicated that negative balances are not allowed).
For lot number and serial number auto-generation, you can specify whether you want the numbers generated from defaults defined at the organization level orthe item level (LOT_NUMBER_GENERATION,SERIAL_NUMBER_GENERATION). You can also specify uniqueness constraints for lot numbers(LOT_NUMBER_UNIQUENESS) and serial numbers (SERIAL_NUMBER_TYPE).
Among the accounting defaults that can be defined here are valuation accounts, receiving accounts, profit and loss accounts, and inter- organization transfer accounts.
Flexfield: JG_MTL_PARAMETERS
- Italy Context: JE.IT.INVSDOIO.NPI parameters
This table shows the column names and field prompts for this context.
GLOBAL_ATTRIBUTE19
Invoices to be received
GLOBAL_ATTRIBUTE20
PO Mirror
- Thailand Context: JA.TH.INVSDOIO.Parameter Info
This context is disabled and no longer used.
MTL_SYSTEM_ITEMS_B
MTL_SYSTEM_ITEMS_B is the definition table for items. This table holds the definitions for inventory items, engineering items, and purchasing items. You can specify item-related information in fields such as: Bill of Material, Costing, Purchasing, Receiving, Inventory, Physical attributes, General Planning, MPS/MRP Planning, Lead times, Work in Process, Order Management, and Invoicing.
You can set up the item with multiple segments, since it is implemented as a flexfield. Use the standard 'System Items' flexfield that is shipped with the product to configure your item flexfield. The flexfield code is MSTK.
The primary key for an item is the INVENTORY_ITEM_ID and ORGANIZATION_ID. Therefore, the same item can be defined in more than one organization.
Each item is initially defined in an item master organization. The user then assigns the item to other organizations that need to recognize this item; a row is inserted for each new organization the item is assigned to. Many columns such as MTL_TRANSACTIONS_ENABLED_FLAG and BOM_ENABLED_FLAG correspond to item attributes defined in the MTL_ITEM_ATTRIBUTES table. The attributes that are available to the user depend on which Oracle applications are installed. The table MTL_ATTR_APPL_DEPENDENCIES maintains the relationships between item attributes and Oracle applications.
Two unit of measure columns are stored in MTL_SYSTEM_ITEMS table. PRIMARY_UOM_CODE is the 3-character unit that is used throughout Oracle Manufacturing. PRIMARY_UNIT_OF_MEASURE is the 25-character unit that is used throughout Oracle Purchasing.
Items now support multilingual description. MLS is implemented with a pair of tables: MTL_SYSTEM_ITEMS_B and MTL_SYSTEM_ITEMS_TL. Translations table (MTL_SYSTEM_ITEMS_TL) holds item descriptions in multiple languages. DESCRIPTION column in the base table (MTL_SYSTEM_ITEMS_B) is for backward compatibility and is maintained in the installation base language only.
Flexfield: JG_MTL_SYSTEM_ITEMS
- Argentina Context: JL.AR.INVIDITM.SYSTEM_ITEMS
This table shows the column names and field prompts for this context.
GLOBAL_ATTRIBUTE1
Fiscal Classification Code
GLOBAL_ATTRIBUTE2
Transaction Condition Class
GLOBAL_ATTRIBUTE8
Inventory Item Application
GLOBAL_ATTRIBUTE10
Branch Number
- Brazil Context: JL.BR.INVIDITM.AR.Fiscal
This context is disabled and no longer used.
- Brazil Context: JL.BR.INVIDITM.XX.Fiscal
This table shows the column names and field prompts for this context.
GLOBAL_ATTRIBUTE1
Fiscal Classification Code
GLOBAL_ATTRIBUTE2
Transaction Condition Class
GLOBAL_ATTRIBUTE3
Item Origin
GLOBAL_ATTRIBUTE4
Item Fiscal Type
GLOBAL_ATTRIBUTE5
Federal Tributary Situation
GLOBAL_ATTRIBUTE6
State Tributary Situation
GLOBAL_ATTRIBUTE7
IPI Tax Name
GLOBAL_ATTRIBUTE8
Inventory Item Application
GLOBAL_ATTRIBUTE9
IPI Tax Switcher
- Brazil Context: JL.BR.INVIVATT.Fiscal
This context is disabled and no longer used.
- Colombia Context: JL.CO.INVIDITM.Infl_Adj
This context is disabled and no longer used.
- Colombia Context: JL.CO.INVIDITM.SYSTEM_ITEMS
This table shows the column names and field prompts for this context.
GLOBAL_ATTRIBUTE1
Fiscal Classification Code
GLOBAL_ATTRIBUTE2
Transaction Condition Class
GLOBAL_ATTRIBUTE3
Inflation Adjustment Account
GLOBAL_ATTRIBUTE4
Monetary Correction Account
GLOBAL_ATTRIBUTE5
Sales Cost Account
GLOBAL_ATTRIBUTE8
Inventory Item Application
- Hungary Context: JE.HU.INVIDITM.STAT_CODE
This table shows the column name and field prompt for this context.
GLOBAL_ATTRIBUTE1
Statistical Code
- Italy Context: JE.IT.INVIDITM.NPI_SYSTEM_ITEM
This table shows the column names and field prompts for this context.
GLOBAL_ATTRIBUTE7
Fiscal IPV credit
GLOBAL_ATTRIBUTE8
Fiscal IPV debit
GLOBAL_ATTRIBUTE9
Fiscal Return
GLOBAL_ATTRIBUTE10
Fiscal Expense
- Poland Context: JE.PL.INVIDITM.STAT_CODE
This table shows the column name and field prompt for this context.
GLOBAL_ATTRIBUTE1
Statistical Code
OE_ORDER_LINES_ALL
OE_ORDER_LINES_ALL stores information for all order lines in Oracle Order Management.
Flexfield: JG_OE_ORDER_LINES
- Argentina Context: JL.AR.OEXOEORD.LINES
This table shows the column names and field prompts for this context.
GLOBAL_ATTRIBUTE5
Fiscal Classification Code
GLOBAL_ATTRIBUTE6
Transaction Condition Class
GLOBAL_ATTRIBUTE7
Default Fiscal Classification Code
GLOBAL_ATTRIBUTE8
Default Transaction Condition Class
- Brazil Context: JL.BR.OEXOEORD.LINES
This table shows the column names and field prompts for this context.
GLOBAL_ATTRIBUTE1
Operation Fiscal Code
GLOBAL_ATTRIBUTE2
Freight Accessory Expense
GLOBAL_ATTRIBUTE3
Insurance Accesory Expense
GLOBAL_ATTRIBUTE4
Other Accessory Expenses
GLOBAL_ATTRIBUTE5
Fiscal Classification Code
GLOBAL_ATTRIBUTE6
Transaction Condition Class
GLOBAL_ATTRIBUTE7
Default Fiscal Classification Code
GLOBAL_ATTRIBUTE8
Default Transaction Condition Class
- Colombia Context: JL.CO.OEXOEORD.LINES
This context is disabled and no longer used.
ORG_FREIGHT_TL
ORG_FREIGHT is the definition table for freight carriers. It also holds the distribution account information.
The freight carrier (FREIGHT_CODE) and freight charge distribution account (DISTRIBUTION_ACCOUNT) are used in inter-organization transfers.
Freight carriers are defined in the Freight Carriers window in Oracle Inventory.
Flexfield: JG_ORG_FREIGHT
- Brazil Context: JL.BR.INVSDFCR.ORG_FREIGHT
This table shows the column names and field prompts for this context.
GLOBAL_ATTRIBUTE1
Address
GLOBAL_ATTRIBUTE2
City
GLOBAL_ATTRIBUTE3
State
GLOBAL_ATTRIBUTE4
Inscription Type
GLOBAL_ATTRIBUTE5
Inscription Number
GLOBAL_ATTRIBUTE6
Inscription Branch
GLOBAL_ATTRIBUTE7
Inscription Digit
GLOBAL_ATTRIBUTE8
State Inscription
PO_HEADERS_ALL
PO_HEADERS_ALL contains header information for your purchasing documents. You need one row for each document you create. There are six types of documents that use PO_HEADERS_ALL:
- RFQs
- Quotations
- Standard purchase orders
- Planned purchase orders
- Blanket purchase orders
- Contracts
Each row contains buyer information, supplier information, brief notes, foreign currency information, terms and conditions information, and the status of the document.
Oracle Purchasing uses this information to record information that is related to a complete document.
PO_HEADER_ID is the unique system-generated primary key and is invisible to the user. SEGMENT1 is the system-assigned number you use to identify the document in forms and reports. Oracle Purchasing generates SEGMENT1 using the PO_UNIQUE_IDENTIFIER_CONT_ALL table if you choose to let Oracle Purchasing generate document numbers for you. SEGMENT1 is not unique for the entire table. Different document types can share the same numbers. You can uniquely identify a row in PO_HEADERS_ALL using SEGMENT1 and TYPE_LOOKUP_CODE or using PO_HEADER_ID.
If APPROVED_FLAG is 'Y', the purchase order is approved. If your document type is a blanket purchase order, contract purchase order, RFQ, or quotation, Oracle Purchasing uses START_DATE and END_DATE to store the valid date range for the document. Oracle Purchasing only uses BLANKET_TOTAL_AMOUNT for blanket purchase orders or contract purchase orders.
If you autocreate a quotation from an RFQ using the Copy Document window, Oracle Purchasing stores the foreign key to your original RFQ in FROM_HEADER_ID. Oracle Purchasing also uses FROM_TYPE_LOOKUP_CODE to indicate that you copied the quotation from an RFQ.
Oracle Purchasing does not use SUMMARY_FLAG and ENABLED_FLAG. Because future vers ions of Oracle Purchasing will use them, SUMMARY_FLAG and ENABLED_FLAG should always be 'N' and 'Y' respectively.
You enter document header information in the Header region of the Purchase Orders, RFQs, and Quotations windows.
Flexfield: JG_PO_HEADERS
- Brazil Context: JL.BR.POXPOEPO.PO_HEADERS
This table shows the column name and field prompt for this context.
GLOBAL_ATTRIBUTE1
Total IPI Tax
PO_LINES_ALL
PO_LINES_ALL stores current information about each purchase order line. You need one row for each line you attach to a document. There are five document types that use lines:
- RFQs
- Quotations
- Standard purchase orders
- Blanket purchase orders
- Planned purchase orders
Each row includes the line number, the item number and category, unit, price, tax information, matching information, and quantity ordered for the line. Oracle Purchasing uses this information to record and update item and price information for purchase orders, quotations, and RFQs.
PO_LINE_ID is the unique system-generated line number invisible to the user. LINE_NUM is the number of the line on the purchase order. Oracle
Purchasing uses CONTRACT_NUM to reference a contract purchase order from a standard purchase order line. Oracle Purchasing uses ALLOW_PRICE_OVERRIDE_FLAG, COMMITTED_AMOUNT, QUANTITY_COMMITTED, MIN_RELEASE_AMOUNT only for blanket and planned purchase order lines.
The QUANTITY field stores the total quantity of all purchase order shipment lines (found in PO_LINE_LOCATIONS_ALL).
Flexfield: JG_PO_LINES
- Brazil Context: JL.BR.POXPOEPO.PO_LINES
This table shows the column name and field prompt for this context.
GLOBAL_ATTRIBUTE1
Fiscal Classification Code
PO_LINE_LOCATIONS_ALL
PO_LINE_LOCATIONS_ALL contains information about purchase order shipment schedules and blanket agreement price breaks. You need one row for each schedule or price break you attach to a document line. There are seven types of documents that use shipment schedules:
- RFQs
- Quotations
- Standard purchase orders
- Planned purchase orders
- Planned purchase order releases
- Blanket purchase orders
- Blanket purchase order releases
Each row includes the location, quantity, and dates for each shipment schedule. Oracle Purchasing uses this information to record delivery schedule information for purchase orders, and price break information for blanket purchase orders, quotations and RFQs.
PO_RELEASE_ID applies only to blanket purchase order release shipments. PO_RELEASE_ID identifies the release on which you placed this shipment.
SOURCE_SHIPMENT_ID applies only to planned purchase order release shipments. It identifies the planned purchase order shipment you chose to release from.
PRICE_OVERRIDE always equals the purchase order line price for standard purchase order shipments. For blanket and planned purchase orders, PRICE_OVERRIDE depends on the values of the ALLOW_PRICE_OVERRIDE_FLAG and NOT_TO_EXCEED_PRICE in the corresponding row in PO_LINES_ALL:
- If ALLOW_PRICE_OVERRIDE_FLAG is 'N', then PRICE_OVERRIDE equals UNIT_PRICE in PO_LINES_ALL.
- If ALLOW_PRICE_OVERRIDE_FLAG is 'Y', the PRICE_OVERRIDE can take any value that is smaller than NOT_TO_EXCEED_PRICE in PO_LINES_ALL.
The QUANTITY field corresponds to the total quantity ordered on all purchase order distribution lines (found in PO_DISTRIBUTIONS_ALL).
Oracle Purchasing automatically updates QUANTITY_RECEIVED, QUANTITY_ACCEPTED, and QUANTITY_REJECTED when you receive, return, or inspect goods or services. Oracle Payables automatically updates QUANTITY_BILLED when you match an invoice with a purchase order shipment. Oracle Purchasing automatically updates QUANTITY_CANCELLED when you cancel a purchase order shipment.
Oracle Purchasing sets APPROVED_FLAG to 'Y' when you approve the corresponding purchase order if there are no problems associated with the shipment and its related distributions.
Oracle Purchasing sets ENCUMBERED_FLAG to 'Y' and enters the ENCUMBERED_DATE when you approve a purchase order if you use encumbrance.
Flexfield: JG_PO_LINE_LOCATIONS
- Brazil Context: JL.BR.APXINWKB.SHIP_MATCH
This context is disabled and no longer used.
- Brazil Context: JL.BR.APXPMTCH.SHIPMENT_MATCH
This table shows the column names and field prompts for this context.
GLOBAL_ATTRIBUTE1
ICMS Base Amount
GLOBAL_ATTRIBUTE2
ICMS Name
GLOBAL_ATTRIBUTE3
ICMS Amount
GLOBAL_ATTRIBUTE4
IPI Base Amount
GLOBAL_ATTRIBUTE5
IPI Name
GLOBAL_ATTRIBUTE6
IPI Amount
- Brazil Context: JL.BR.POXPOEPO.PO_SHIPMENTS
This table shows the column names and field prompts for this context.
GLOBAL_ATTRIBUTE1
ICMS Base Amount
GLOBAL_ATTRIBUTE2
ICMS Tax Name
GLOBAL_ATTRIBUTE3
ICMS Tax Amount
GLOBAL_ATTRIBUTE4
IPI Base Amount
GLOBAL_ATTRIBUTE5
IPI Tax Name
GLOBAL_ATTRIBUTE6
IPI Tax Amount
- Brazil Context: JL.BR.POXPOERL.PO_SHIPMENTS
This table shows the column names and field prompts for this context.
GLOBAL_ATTRIBUTE1
ICMS Base Amount
GLOBAL_ATTRIBUTE2
ICMS Tax Name
GLOBAL_ATTRIBUTE3
ICMS Tax Amount
GLOBAL_ATTRIBUTE4
IPI Base Amount
GLOBAL_ATTRIBUTE5
IPI Tax Name
GLOBAL_ATTRIBUTE6
IPI Tax Amount
PO_RELEASES_ALL
PO_RELEASES_ALL contains information about blanket and planned purchase order releases. You need one row for each release you issue for a blanket or planned purchase order. Each row includes the buyer, date, release status, and release number. Each release must have at least one purchase order shipment (PO_LINE_LOCATIONS_ALL). RELEASE_NUM is the number you assign to the release.
Flexfield: JG_PO_RELEASES
- Brazil Context: JL.BR.POXPOERL.PO_RELEASES
This table shows the column name and field prompt for this context.
GLOBAL_ATTRIBUTE1
Total IPI Tax
PO_SYSTEM_PARAMETERS_ALL
PO_SYSTEM_PARAMETERS_ALL stores default, control, and option information you provide to customize Oracle Purchasing to your company's needs. PO_SYSTEM_PARAMETERS_ALL corresponds to the Purchasing Options window. This table has no primary key. The table should never have morethan one row.
Flexfield: JG_PO_SYSTEM_PARAMETERS
- Brazil Context: JL.BR.POXSTDPO.PO_OPTIONS
This table shows the column names and field prompts for this context.
GLOBAL_ATTRIBUTE1
Transaction Nature / One-Time Items
GLOBAL_ATTRIBUTE2
Country Code Profile
PO_VENDORS
PO_VENDORS stores information about your suppliers. You need one row for each supplier you define. Each row includes the supplier name as well as purchasing, receiving, payment, accounting, tax, classification, and general information. Oracle Purchasing uses this information to determine active suppliers. VENDOR_ID is the unique system-generated receipt header number invisible to the user. SEGMENT1 is the system-generated or manually assigned number you use to identify the supplier in forms and reports. Oracle Purchasing generates SEGMENT1 using the PO_UNIQUE_IDENTIFIER_CONTROL table if you choose to let Oracle Purchasing generate supplier numbers for you. This table is one of three tables that store supplier information. PO_VENDORS corresponds to the Suppliers window.
Flexfield: JG_PO_VENDORS
- Argentina Context: JL.AR.APXVDMVD.SUPPLIERS
This table shows the column names and field prompts for this context.
GLOBAL_ATTRIBUTE1
VAT Registration Status Code
GLOBAL_ATTRIBUTE9
Origin
GLOBAL_ATTRIBUTE10
Taxpayer ID Type
GLOBAL_ATTRIBUTE12
Taxpayer ID Validation Digit
GLOBAL_ATTRIBUTE15
Multilateral Contributor
GLOBAL_ATTRIBUTE16
Transaction Letter
- Brazil Context: JL.BR.APXVDMVD.VENDORS
This table shows the column names and field prompts for this context.
GLOBAL_ATTRIBUTE1
Collection Document Association
GLOBAL_ATTRIBUTE2
Interest Type
GLOBAL_ATTRIBUTE3
Interest Rate / Amount
GLOBAL_ATTRIBUTE4
Interest Period
GLOBAL_ATTRIBUTE5
Interest Formula
GLOBAL_ATTRIBUTE6
Interest Grace Days
GLOBAL_ATTRIBUTE7
Penalty Type
GLOBAL_ATTRIBUTE8
Penalty Rate / Amount
- Chile Context: JL.CL.APXVDMVD.SUPPLIERS
This table shows the column names and field prompts for this context.
GLOBAL_ATTRIBUTE10
Taxpayer ID Type
GLOBAL_ATTRIBUTE12
Taxpayer ID Valid Digit
- Colombia Context: JL.CO.APXVDMVD.SUPPLIERS
This table shows the column names and field prompts for this context.
GLOBAL_ATTRIBUTE10
Taxpayer ID Type
GLOBAL_ATTRIBUTE12
Taxpayer ID Validation Digit
- Greece Context: JE.GR.APXVDMVD.SUPPLIERS
This table shows the column name and field prompt for this context.
GLOBAL_ATTRIBUTE1
Public Sector Companies Reporting
- Italy Context: JE.IT.APXVDMVD.WHT_INFO
This table shows the column names and field prompts for this context.
GLOBAL_ATTRIBUTE2
Date of Birth
GLOBAL_ATTRIBUTE3
Place of Birth
- Taiwan Context: JA.TW.APXVDMVD.PO_VENDORS
This table shows the column names and field prompts for this context.
GLOBAL_ATTRIBUTE1
Uniform Number
GLOBAL_ATTRIBUTE2
Government Uniform Invoice Type
PO_VENDOR_SITES_ALL
PO_VENDOR_SITES_ALL stores information about your supplier sites. You need a row for each supplier site you define. Each row includes the site address, supplier reference, purchasing, payment, bank, and general information. Oracle Purchasing uses this information to store supplier address information.
This table is one of three tables that store supplier information. PO_VENDOR_SITES_ALL corresponds to the Sites region of the Suppliers window.
Flexfield: JG_PO_VENDOR_SITES
- Argentina Context: JL.AR.APXVDMVD.SUPPLIER_SITES
This table shows the column name and field prompt for this context.
GLOBAL_ATTRIBUTE17
Legal Address
GLOBAL_ATTRIBUTE18
Fiscal Printer Used
GLOBAL_ATTRIBUTE19
CAI Number
GLOBAL_ATTRIBUTE20
CAI Due Date
- Brazil Context: JL.BR.APXVDMVD.SITES
This table shows the column names and field prompts for this context.
GLOBAL_ATTRIBUTE1
Collection Document Association
GLOBAL_ATTRIBUTE2
Interest Type
GLOBAL_ATTRIBUTE3
Interest Rate / Amount
GLOBAL_ATTRIBUTE4
Interest Period
GLOBAL_ATTRIBUTE5
Interest Formula
GLOBAL_ATTRIBUTE6
Interest Grace Days
GLOBAL_ATTRIBUTE7
Penalty Type
GLOBAL_ATTRIBUTE8
Penalty Rate / Amount
GLOBAL_ATTRIBUTE9
Inscription Type
GLOBAL_ATTRIBUTE10
Inscription Number
GLOBAL_ATTRIBUTE11
Inscription Branch
GLOBAL_ATTRIBUTE12
Inscription Digit
GLOBAL_ATTRIBUTE13
State Inscription
GLOBAL_ATTRIBUTE14
City Inscription
GLOBAL_ATTRIBUTE15
Contributor Type
GLOBAL_ATTRIBUTE16
Tax Calendar
- Colombia Context: JL.CO.APXVDMVD.SUPPLIER_SITES
This table shows the column name and field prompt for this context.
GLOBAL_ATTRIBUTE17
Legal Address
- Czech Context: JE.CZ.APXVDMVD.PO_VENDORS
This context is disabled and no longer used.
- Israel Context: JE.IL.APXVDMVD.TAXPAYER_ID
This context is disabled and no longer used.
- Italy Context: JE.IT.APXVDMVD.DOC_CATEGORY
This table shows the column name and field prompt for this context.
GLOBAL_ATTRIBUTE1
Document Category Name
- Korea Context: JA.KR.APXVDMVD.WITHHOLDING
This table shows the column name and field prompt for this context.
GLOBAL_ATTRIBUTE1
Taxable Person
GLOBAL_ATTRIBUTE2
Business Income Subcategory
GLOBAL_ATTRIBUTE4
Industry Classification
GLOBAL_ATTRIBUTE5
Industry Subclassificaiton
RA_BATCH_SOURCES_ALL
The RA_BATCH_SOURCES_ALL table stores information about the sources of your invoices, credit memos, and commitments. Each row includes information about invoice, batch, and credit memo numbering. Oracle Receivables creates one row for each batch source that you define. Receivables uses batch sources to default a transaction type during invoice entry and to determine invoice, batch, and credit memo numbering.
The BATCH_SOURCE_TYPE column stores INV for manual batches or FOREIGN for imported batches. The STATUS, CREDIT_MEMO_BATCH_SOURCE_ID, AUTO_BATCH_NUMBERING, and AUTO_TRX_NUMBERING columns are required even though they are null allowed.
The primary key for this table is BATCH_SOURCE_ID.
Flexfield: JG_RA_BATCH_SOURCES
- Argentina Context: JL.AR.RAXSUMSC.BATCH_SOURCES
This table shows the column names and field prompts for this context.
GLOBAL_ATTRIBUTE1
Imported Source
GLOBAL_ATTRIBUTE2
Branch Number
GLOBAL_ATTRIBUTE3
Document Letter
GLOBAL_ATTRIBUTE4
Last Transaction Date
GLOBAL_ATTRIBUTE5
Advance Days
GLOBAL_ATTRIBUTE7
Fiscal Printer Used
GLOBAL_ATTRIBUTE8
CAI Number
GLOBAL_ATTRIBUTE9
CAI Due Date
- Brazil Context: JL.BR.RAXSUMSC.Additional
This table shows the column names and field prompts for this context.
GLOBAL_ATTRIBUTE1
Invoice Sub-Series
GLOBAL_ATTRIBUTE2
Company Name
- Taiwan Context: JA.TW.RAXSUMSC.BATCH_SOURCES
This table shows the column names and field prompts for this context.
GLOBAL_ATTRIBUTE1
Reference Transaction Source
GLOBAL_ATTRIBUTE2
Initial Transaction Number
GLOBAL_ATTRIBUTE3
Invoice Word
GLOBAL_ATTRIBUTE4
Final Transaction Number
GLOBAL_ATTRIBUTE5
Last Issued Date
GLOBAL_ATTRIBUTE6
Advance Days
RA_CUSTOMER_TRX_ALL
The RA_CUSTOMER_TRX_ALL table stores invoice, debit memo, commitment, bills receivable, and credit memo header information. Each row in this table includes general invoice information such as customer, transaction type, and printing instructions. One row exists for each invoice, debit memo, commitment, bill receivable, and credit memo that you create in Oracle Receivables. Invoices, debit memos, credit memos, bills receivable, and commitments are distinguished by their associated transaction types, which are stored in the RA_CUST_TRX_TYPES_ALL table.
If you entered a credit memo, the PREVIOUS_CUSTOMER_TRX_ID column stores the customer transaction ID of the invoice that you credited. In the case of on-account credits, which are not related to any invoice when the credits are created, the PREVIOUS_CUSTOMER_TRX_ID column is null. If you create an invoice against a commitment, Receivables stores the customer transaction ID of the commitment in the INITIAL_CUSTOMER_TRX_ID column. Otherwise, the INITIAL_CUSTOMER_TRX_ID column is null.
The COMPLETE_FLAG column stores Y or N to indicate if the invoice is complete. When you complete an invoice, Receivables creates your payment schedules and updates any commitments against this invoice. Before an invoice can be completed, the invoice must have at least one invoice line, revenue records must exist for each line and add up to the line amount, and a sales tax record must exist for each line.
The SOLD_TO_CUSTOMER_ID, SOLD_TO_SITE_USE_ID, BILL_TO_CUSTOMER_ID, BILL_TO_SITE_USE_ID, SHIP_TO_SITE_USE_ID, PRINTING_OPTION, PRINTING_PENDING, TERM_ID, REMIT_TO_ADDRESS_ID, PRIMARY_SALES_REP_ID, and INVOICE_CURRENCY_CODE columns are required even though they are null allowed.
The primary key for this table is CUSTOMER_TRX_ID.
Flexfield: JG_RA_CUSTOMER_TRX
- Argentina Context: JL.AR.ARXTWMAI.TGW_HEADER
This table shows the column names and field prompts for this context.
GLOBAL_ATTRIBUTE17
CAI Number
GLOBAL_ATTRIBUTE18
CAI Due Date
GLOBAL_ATTRIBUTE19
Original Transaction Type Id
GLOBAL_ATTRIBUTE20
Copy Status
- Brazil Context: JL.BR.ARXTWMAI.Additional Info
This table shows the column names and field prompts for this context.
GLOBAL_ATTRIBUTE1
Interest Type
GLOBAL_ATTRIBUTE2
Interest Rate/Amount
GLOBAL_ATTRIBUTE3
Interest Period
GLOBAL_ATTRIBUTE4
Interest Formula
GLOBAL_ATTRIBUTE5
Grace Days
GLOBAL_ATTRIBUTE6
Penalty Type
GLOBAL_ATTRIBUTE7
Penalty Rate/Amount
GLOBAL_ATTRIBUTE8
Issue Date
GLOBAL_ATTRIBUTE9
Freight Accessory Expense
GLOBAL_ATTRIBUTE10
Insurance Accessory Expense
GLOBAL_ATTRIBUTE11
Other Accessory Expenses
GLOBAL_ATTRIBUTE12
License Plate
GLOBAL_ATTRIBUTE13
Volume Quantity
GLOBAL_ATTRIBUTE14
Volume Type
GLOBAL_ATTRIBUTE15
Volume Number
GLOBAL_ATTRIBUTE16
Total Gross Weight
GLOBAL_ATTRIBUTE17
Total Net Weight
GLOBAL_ATTRIBUTE18
ISS_DATE
- Chile Context: JL.CL.ARXTWMAI.TGW_HEADER
This table shows the column names and field prompts for this context.
GLOBAL_ATTRIBUTE19
Original Transaction Type Id
GLOBAL_ATTRIBUTE20
Copy Status
- Colombia Context: JL.CO.ARXTWMAI.TGW_HEADER
This table shows the column names and field prompts for this context.
GLOBAL_ATTRIBUTE19
Original Transaction Type Id
GLOBAL_ATTRIBUTE20
Copy Status
- Czech Republic Context: JE.CZ.ARXTWMAI.TAX_DATE
This table shows the column names and field prompts for this context.
GLOBAL_ATTRIBUTE1
Tax Date
- Hungary Context: JE.HU.ARXTWMAI.TAX_DATE
This table shows the column name and field prompt for this context.
GLOBAL_ATTRIBUTE1
Tax Date
- Poland Context: JE.PL.ARXTWMAI.TAX_DATE
This table shows the column names and field prompts for this context.
GLOBAL_ATTRIBUTE1
Tax Date
GLOBAL_ATTRIBUTE3
Bank Account Number
- Spain Context: JE.ES.ARXTWMAI.INVOICE_INFO
This context is disabled and no longer used.
- Spain Context: JE.ES.ARXTWMAI.MODELO347
This table shows the column name and field prompt for this context.
GLOBAL_ATTRIBUTE1
Invoice Type
- Spain Context: JE.ES.ARXTWMAI.MODELO347PR
This table shows the column names and field prompts for this context.
GLOBAL_ATTRIBUTE1
Invoice Type
GLOBAL_ATTRIBUTE2
Property Location
- Spain Context: JE.ES.ARXTWMAI.MODELO349
This table shows the column names and field prompts for this context.
GLOBAL_ATTRIBUTE1
Invoice Type
GLOBAL_ATTRIBUTE3
Correction Year
GLOBAL_ATTRIBUTE4
Correction Period
GLOBAL_ATTRIBUTE5
Triangulation
- Spain Context: JE.ES.ARXTWMAI.MODELO415
This table shows the column name and field prompt for this context.
GLOBAL_ATTRIBUTE1
Invoice Type
- Spain Context: JE.ES.ARXTWMAI.MODELO415_347
This table shows the column name and field prompt for this context.
GLOBAL_ATTRIBUTE1
Invoice Type
- Spain Context: JE.ES.ARXTWMAI.MODELO415_347PR
This table shows the column names and field prompts for this context.
GLOBAL_ATTRIBUTE1
Invoice Type
GLOBAL_ATTRIBUTE2
Property Location
- Spain Context: JE.ES.ARXTWMAI.OTHER
This table shows the column name and field prompt for this context.
GLOBAL_ATTRIBUTE1
Invoice Type
- Spain Context: JE.EX.ARXTWMAI.OTHER
This context is disabled and no longer used.
- Taiwan Context: JA.TW.ARXTWMAI.RA_CUSTOMER_TRX
This table shows the column names and field prompts for this context.
GLOBAL_ATTRIBUTE1
Government Uniform Invoice Type
GLOBAL_ATTRIBUTE2
Wine/Cigarette
GLOBAL_ATTRIBUTE3
Deductible Type
GLOBAL_ATTRIBUTE4
Export Certificate Number
GLOBAL_ATTRIBUTE5
Export Name
GLOBAL_ATTRIBUTE6
Export Method
GLOBAL_ATTRIBUTE7
Export Type
GLOBAL_ATTRIBUTE8
Export Date
GLOBAL_ATTRIBUTE9
Original Transaction Number
GLOBAL_ATTRIBUTE10
Legacy Uniform Invoice
- Slovakia Context: JE.SK.ARXTWMAI.TAX_DATE
This table shows the column name and field prompt for this context.
GLOBAL_ATTRIBUTE1
TAX DATE
RA_CUSTOMER_TRX_LINES_ALL
The RA_CUSTOMER_TRX_LINES_ALL table stores information about invoice, debit memo, credit memo, bills receivable, and commitment lines. For example, an invoice can have one line for Product A and another line for Product B. Each line requires one row in this table.
Invoice, debit memo, credit memo, bills receivable, and commitment lines are distinguished by the transaction type of the corresponding row in the RA_CUSTOMER_TRX_ALL table. Credit memos must also have a value in the PREVIOUS_CUSTOMER_TRX_LINE_ID column. On-account credits, which are not related to specific invoices or invoice lines when they are created, will not have values in this column.
The QUANTITY_ORDERED column stores the amount of product that was ordered. The QUANTITY_INVOICED column stores the amount of product that was invoiced. For manually entered invoices, the QUANTITY_ORDERED and QUANTITY_INVOICED columns must be the same. For invoices that were imported through AutoInvoice, the QUANTITY_ORDERED and QUANTITY_INVOICED columns can be different. If you enter a credit memo, the QUANTITY_CREDITED column stores the amount of product that was credited.
The UOM_CODE column stores the unit of measure code as defined in the MTL_UNITS_OF_MEASURE table. The UNIT_STANDARD_PRICE column stores the list price per unit for this transaction line. The UNIT_SELLING_PRICE column stores the selling price per unit for this transaction line. For transactions that were imported through AutoInvoice, the UNIT_STANDARD_PRICE and UNIT_SELLING_PRICE columns can be different. The DESCRIPTION, TAXING_RULE, QUANTITY_ORDERED, UNIT_STANDARD_PRICE, UOM_CODE, and UNIT_SELLING_PRICE columns are required even though they are null allowed.
Receivables uses the LINE_TYPE column to distinguish between the different types of lines that are stored in this table. LINE represents regular invoice lines that normally refer to an item. TAX represents a tax line. The LINK_TO_CUST_TRX_LINE_ID column references the invoice line that is associated with the row that holds the TAX line type. FREIGHT is similar to TAX, but you can have at most one freight line per invoice line. You can also have one freight line that has a null LINK_TO_CUST_TRX_LINE_ID column. An invoice that has one freight line with a null LINK_TO_CUST_TRX_LINE_ID column has header-level freight.
CB represents a chargeback line. For every row in this table that belongs to a completed postable or nonpostable transaction, where the RA_CUSTOMER_TRX.COMPLETE_FLAG is Y, there must be at least one row in the RA_CUST_TRX_LINE_GL_DIST table that stores accounting information. There must be at least one row in this table even for nonpostable transactions.
The primary key for this table is CUSTOMER_TRX_LINE_ID.
Flexfield: JG_RA_CUSTOMER_TRX_LINES
- Argentina Context: JL.AR.ARXTWMAI.LINES
This table shows the column names and field prompts for this context.
GLOBAL_ATTRIBUTE2
Fiscal Classification Code
GLOBAL_ATTRIBUTE3
Transaction Condition Class
GLOBAL_ATTRIBUTE8
Legal Justification Message 1
GLOBAL_ATTRIBUTE9
Legal Justification Message 2
GLOBAL_ATTRIBUTE10
Legal Justification Message 3
GLOBAL_ATTRIBUTE11
Tax Base Amount
GLOBAL_ATTRIBUTE12
Tax Base Rate
GLOBAL_ATTRIBUTE13
Default Fiscal Class Code
GLOBAL_ATTRIBUTE14
Default Transaction Condition Class Code
GLOBAL_ATTRIBUTE19
Charged Tax Amount
GLOBAL_ATTRIBUTE20
Calculated Tax Amount
- Brazil Context: JL.BR.ARXTWMAI.Additional Info
This table shows the column names and field prompts for this context.
GLOBAL_ATTRIBUTE1
Operation Fiscal Code
GLOBAL_ATTRIBUTE2
Fiscal Classification Code
GLOBAL_ATTRIBUTE3
Transaction Condition Class
GLOBAL_ATTRIBUTE4
Item Origin
GLOBAL_ATTRIBUTE5
Item Fiscal Type
GLOBAL_ATTRIBUTE6
Federal Tributary Situation
GLOBAL_ATTRIBUTE7
State Tributary Situation
GLOBAL_ATTRIBUTE8
Legal Justification Message 1
GLOBAL_ATTRIBUTE9
Legal Justification Message 2
GLOBAL_ATTRIBUTE10
Legal Justification Message 3
GLOBAL_ATTRIBUTE11
Tax Base Amount
GLOBAL_ATTRIBUTE12
Tax Base Rate
GLOBAL_ATTRIBUTE13
Default Fiscal Class Code
GLOBAL_ATTRIBUTE14
Default Transaction Condition Class Code
GLOBAL_ATTRIBUTE15
ITEM_ORG
GLOBAL_ATTRIBUTE16
ITEM_FISC
GLOBAL_ATTRIBUTE17
FED_TRIB
GLOBAL_ATTRIBUTE18
STAT_TRIB
GLOBAL_ATTRIBUTE19
Charged Tax Amount
GLOBAL_ATTRIBUTE20
Calculated Tax Amount
- Colombia Context: JL.CO.ARXTWMAI.LINES
This table shows the column names and field prompts for this context.
GLOBAL_ATTRIBUTE2
Fiscal Classification Code
GLOBAL_ATTRIBUTE3
Transaction Condition Class
GLOBAL_ATTRIBUTE8
Legal Justification Message 1
GLOBAL_ATTRIBUTE9
Legal Justification Message 2
GLOBAL_ATTRIBUTE10
Legal Justification Message 3
GLOBAL_ATTRIBUTE11
Tax Base Amount
GLOBAL_ATTRIBUTE12
Tax Base Rate
GLOBAL_ATTRIBUTE13
Default Fiscal Class Code
GLOBAL_ATTRIBUTE14
Default Transaction Condition Class Code
GLOBAL_ATTRIBUTE19
Charged Tax Amount
GLOBAL_ATTRIBUTE20
Calculated Tax Amount
- Czech Context: JE.CZ.ARXTWMAI.REGISTER_INFO
This table shows the column names and field prompts for this context.
GLOBAL_ATTRIBUTE1
Final VAT Register Request ID
- Hungary Context: JE.HU.ARXTWMAI.REGISTER_INFO
This table shows the column names and field prompts for this context.
GLOBAL_ATTRIBUTE1
Final VAT Register Request ID
- Poland Context: JE.PL.ARXTWMAI.REGISTER_INFO
This table shows the column names and field prompts for this context.
GLOBAL_ATTRIBUTE1
Final VAT Register Request ID
- Slovakia Context: JE.SK.ARXTWMAI.REGISTER_INFO
This table shows the column names and field prompts for this context.
GLOBAL_ATTRIBUTE1
Final VAT Register Request ID
RA_CUST_TRX_TYPES_ALL
The RA_CUST_TRX_TYPES_ALL table stores information about each transaction type that is used for invoices, commitments, bills receivable, and credit memos. Each row includes AutoAccounting information as well as standard defaults for the invoices that result.
The POST_TO_GL column stores Y or N to indicate if this transaction can post to your General Ledger.
The ACCOUNTING_AFFECT_FLAG column stores Y or N to indicate if this transaction can update your open receivables balances. If the ACCOUNTING_AFFECT_FLAG column is Y, you can see this transaction in your agings.
The TYPE column contains:
- INV - Invoice
- CM - Credit Memo
- DM - Debit Memo
- DEP - Deposit
- GUAR - Guarantee
If AutoAccounting is based on transaction type, the GL_ID_REV, GL_ID_FREIGHT, and GL_ID_REC columns store the default revenue, freight, and receivables accounts. The STATUS and CREDIT_MEMO_TYPE_ID columns are required even though they are null allowed.
The primary key for this table is CUST_TRX_TYPE_ID.
Flexfield: JG_RA_CUST_TRX_TYPES
- Argentina Context: JL.AR.RAXSUCTT.CUST_TRX_TYPES
This table shows the column names and field prompts for this context.
GLOBAL_ATTRIBUTE4
Tax Code
GLOBAL_ATTRIBUTE6
Void Original Transaction
- Brazil Context: JL.BR.RAXSUCTT.Globalization
This table shows the column names and field prompts for this context.
GLOBAL_ATTRIBUTE1
Document Type
GLOBAL_ATTRIBUTE2
Operation Type
GLOBAL_ATTRIBUTE3
Operation Fiscal Code
GLOBAL_ATTRIBUTE4
Tax Code
- Chile Context: JL.CL.RAXSUCTT.CUST_TRX_TYPES
This table shows the column names and field prompts for this context.
GLOBAL_ATTRIBUTE5
Document Seq Order
GLOBAL_ATTRIBUTE6
Void Original Transaction
GLOBAL_ATTRIBUTE7
Include in Sales Ledger
- Colombia Context: JL.CO.RAXSUCTT.CUST_TRX_TYPES
This table shows the column names and field prompts for this context.
GLOBAL_ATTRIBUTE4
Tax Code
GLOBAL_ATTRIBUTE6
Void Original Transaction
- Columbia Context: JE.HU.RAXSUCTT.REVALUATION
This context is disabled and no longer used
- Spain Context: JE.ES.RAXSUCTT.INV_TYPE
This context is disabled and no longer used
- Taiwan Context: JA.TW.RAXSUCTT.CUST_TRX_TYPES
This table shows the column name and field prompt for this context.
GLOBAL_ATTRIBUTE1
Government Uniform Invoice Type
- Thailand Context: JA.TH.RAXSUCTT.CUST_TRX_TYPES
This table shows the column names and field prompts for this context.
GLOBAL_ATTRIBUTE1
Tax Invoice
GLOBAL_ATTRIBUTE2
Last Issued Date
GLOBAL_ATTRIBUTE3
Advance Days
SO_LINE_ATTRIBUTES
SO_LINE_ATTRIBUTES stores globalization and industry-specific information about sales order lines in Oracle Order Management.
The table is a sibling of SO_LINES_ALL; for each row in SO_LINES_ALL there is, at most, one counterpart row in SO_LINE_ATTRIBUTES.
Flexfield: JG_SO_LINE_ATTRIBUTES
- Argentina Context: JL.AR.OEXOEMOE.Lines
This table shows the column names and field prompts for this context.
GLOBAL_ATTRIBUTE5
Fiscal Classification Code
GLOBAL_ATTRIBUTE6
Transaction Condition Class
GLOBAL_ATTRIBUTE7
Fiscal Classification Code
GLOBAL_ATTRIBUTE8
Transaction Condition Class
- Argentina Context: JL.AR.OEXOEVOR.Lines
This table shows the column names and field prompts for this context.
GLOBAL_ATTRIBUTE5
Fiscal Classification Code
GLOBAL_ATTRIBUTE6
Transaction Condition Class
GLOBAL_ATTRIBUTE7
Fiscal Classification Code
GLOBAL_ATTRIBUTE8
Transaction Condition Class
- Argentina Context: JL.AR.OEXORRSO.Lines
This table shows the column names and field prompts for this context.
GLOBAL_ATTRIBUTE5
Fiscal Classification Code
GLOBAL_ATTRIBUTE6
Transaction Condition Class
GLOBAL_ATTRIBUTE7
Fiscal Classification Code
GLOBAL_ATTRIBUTE8
Transaction Condition Class
- Brazil Context: JL.BR.OEXOEMOE.Lines
This table shows the column names and field prompts for this context.
GLOBAL_ATTRIBUTE1
Operation Fiscal Code
GLOBAL_ATTRIBUTE2
Freight Accessory Expense
GLOBAL_ATTRIBUTE3
Insurance Accessory Expense
GLOBAL_ATTRIBUTE4
Other Accessory Expenses
GLOBAL_ATTRIBUTE5
Fiscal Classification Code
GLOBAL_ATTRIBUTE6
Transaction Condition Class
GLOBAL_ATTRIBUTE7
Fiscal Classification Code
GLOBAL_ATTRIBUTE8
Transaction Condition Class
- Brazil Context: JL.BR.OEXOEVOR.Lines
This table shows the column names and field prompts for this context.
GLOBAL_ATTRIBUTE1
Operation Fiscal Code
GLOBAL_ATTRIBUTE2
Freight Accessory Expense
GLOBAL_ATTRIBUTE3
Insurance Accessory Expense
GLOBAL_ATTRIBUTE4
Other Accessory Expenses
GLOBAL_ATTRIBUTE5
Fiscal Classification Code
GLOBAL_ATTRIBUTE6
Transaction Condition Class
GLOBAL_ATTRIBUTE7
Fiscal Classification Code
GLOBAL_ATTRIBUTE8
Transaction Condition Class
- Brazil Context: JL.BR.OEXORRSO.Lines
This table shows the column names and field prompts for this context.
GLOBAL_ATTRIBUTE1
Operation Fiscal Code
GLOBAL_ATTRIBUTE2
Freight Accessory Expense
GLOBAL_ATTRIBUTE3
Insurance Accessory Expense
GLOBAL_ATTRIBUTE4
Other Accessory Expenses
GLOBAL_ATTRIBUTE5
Fiscal Classification Code
GLOBAL_ATTRIBUTE6
Transaction Condition Class
GLOBAL_ATTRIBUTE7
Fiscal Classification Code
GLOBAL_ATTRIBUTE8
Transaction Condition Class
- Colombia Context: JL.CO.OEXOEMOE.Lines
This table shows the column names and field prompts for this context.
GLOBAL_ATTRIBUTE5
Fiscal Classification Code
GLOBAL_ATTRIBUTE6
Transaction Condition Class
GLOBAL_ATTRIBUTE7
Fiscal Classification Code
GLOBAL_ATTRIBUTE8
Transaction Condition Class
- Colombia Context: JL.CO.OEXOEVOR.Lines
This table shows the column names and field prompts for this context.
GLOBAL_ATTRIBUTE5
Fiscal Classification code
GLOBAL_ATTRIBUTE6
Transaction Condition Class
GLOBAL_ATTRIBUTE7
Fiscal Classification code
GLOBAL_ATTRIBUTE8
Transaction Condition Class
- Colombia Context: JL.CO.OEXORRSO.Lines
This table shows the column names and field prompts for this context.
GLOBAL_ATTRIBUTE5
Fiscal Classification Code
GLOBAL_ATTRIBUTE6
Transaction Condition Class
GLOBAL_ATTRIBUTE7
Fiscal Classification Code
GLOBAL_ATTRIBUTE8
Transaction Condition Class
WSH_DELIVERIES
WSH_DELIVERIES handles grouping of shipping lines for a given customer and ultimate ship-to location.
Flexfield:JG_OE_WSH_DELIVERIES
This flexfield is obsolete and no longer used.
- Brazil Context: JL.BR.WSHFDDPW.Additional Info
This context is obsolete and no longer used.
- Brazil Context: JL.BR.WSHFSCDL.Additional Info
This context is obsolete and no longer used.
WSH_NEW_DELIVERIES
Flexfield: JG_WSH_NEW_DELIVERIES
- Brazil Context: JL.BR.WSHFSTRX.DLVY
This table shows the column names and field prompts for this context.
GLOBAL_ATTRIBUTE1
Volume Type
GLOBAL_ATTRIBUTE2
Volume Number
GLOBAL_ATTRIBUTE3
Volume Quantity
Copyright © 1998, 2005, Oracle. All rights reserved.
- Oracle Global Finanicals Technical Reference(一)
- Oracle Global Finanicals Technical Reference(二)
- Essbase Technical Reference
- Credential Provider Technical Reference
- Local Reference and Global Reference
- OMAP35x Technical Reference Manual (Rev. Y)
- Oracle - 临时表(GLOBAL TEMPORARY TABLE)
- oracle PGA(process global area)初探
- Oracle Reference
- Cortex-A7 MPCore Technical Reference Manual(Revision: r0p5)
- 【资源共享】完整版RK3399芯片手册《RK3399 Technical Reference Manual 1.4》
- global variables oracle !
- Oracle GLOBAL TEMPORARY TABLE
- Oracle GLOBAL TEMPORARY TABLE
- 11i Oracle General Ledger Technical Document.
- 技术写作(technical communication)
- 读书笔记 - Derby Reference Manual(一)
- SpringLDAP-Reference (中文文档一)
- 嵌入式系统的内存管理
- EasyUI 之datagrid 使用
- USES_CONVERSION 害得我好苦
- #pragma comment(lib, "XXX.lib") 静态库
- Swift入门教程17-协议(二)
- Oracle Global Finanicals Technical Reference(一)
- 置换选择排序
- 监听android的Home键
- Unix timestamp 格式化显示问题
- http和socket之长连接和短连接区别
- 第16周项目项目4-为动态数组扩容
- Cracking the coding interview--Q9.7
- 第16周项目2-用指针玩转字符串-(2.1)去除特定字符
- 获取10个1-20之间的随机数,要求不能重复