Oracle Global Finanicals Oracle Global Financials Technical Reference（一）

时间：2022-03-14 03:51

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.

Column Name	Field Prompt
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.

Column Name	Field Prompt
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.

Column Name	Field Prompt
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.

Column Name	Field Prompt
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.

Column Name	Field Prompt
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.

Column Name	Field Prompt
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.

Column Name	Field Prompt
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.

Column Name	Field Prompt
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.

Column Name	Field Prompt
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.

Column Name	Field Prompt
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.

Column Name	Field Prompt
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.

Column Name	Field Prompt
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.

Column Name	Field Prompt
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.

Column Name	Field Prompt
GLOBAL_ATTRIBUTE19	Document Type

Colombia Context: JL.CO.APXINWKB.INVOICES

This table shows the column name and field prompt for this context.

Column Name	Field Prompt
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.

Column Name	Field Prompt
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.

Column Name	Field Prompt
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.

Column Name	Field Prompt
GLOBAL_ATTRIBUTE1	Deduction Tax Rule

Hungary Context: JE.HU.APXINWKB.TAX_DATE

This table shows the column name and field prompt for this context.

Column Name	Field Prompt
GLOBAL_ATTRIBUTE1	Tax Date

Poland Context: JE.PL.APXINWKB.INVOICE_INFO

This table shows the column names and field prompts for this context.

Column Name	Field Prompt
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.

Column Name	Field Prompt
GLOBAL_ATTRIBUTE1	Supplier Exchange Rate

Spain Context: JE.ES.APXINWKB.MODELO347

This table shows the column name and field prompt for this context.

Column Name	Field Prompt
GLOBAL_ATTRIBUTE1	Invoice Type

Spain Context: JE.ES.APXINWKB.MODELO347PR

This table shows the column name and field prompt for this context.

Column Name	Field Prompt
GLOBAL_ATTRIBUTE1	Invoice Type

Spain Context: JE.ES.APXINWKB.MODELO349

This table shows the column names and field prompts for this context.

Column Name	Field Prompt
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.

Column Name	Field Prompt
GLOBAL_ATTRIBUTE1	Invoice Type

Spain Context: JE.ES.APXINWKB.MODELO415_347

This table shows the column name and field prompt for this context.

Column Name	Field Prompt
GLOBAL_ATTRIBUTE1	Invoice Type

Spain Context: JE.ES.APXINWKB.MODELO415_347PR

This table shows the column name and field prompt for this context.

Column Name	Field Prompt
GLOBAL_ATTRIBUTE1	Invoice Type

Spain Context: JE.ES.APXINWKB.OTHER

This table shows the column name and field prompt for this context.

Column Name	Field Prompt
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.

Column Name	Field Prompt
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.

Column Name	Field Prompt
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.

Column Name	Field Prompt
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.

Column Name	Field Prompt
GLOBAL_ATTRIBUTE1	IBLC Code

Brazil Context: JL.BR.APXIISIM.INVOICES_FOLDER

This table shows the column names and field prompts for this context.

Column Name	Field Prompt
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.

Column Name	Field Prompt
GLOBAL_ATTRIBUTE19	Document Type

Czech Republic Context: JE.CZ.APXIISIM.INVOICE_INFO

This table shows the column names and field prompts for this context.

Column Name	Field Prompt
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.

Column Name	Field Prompt
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.

Column Name	Field Prompt
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.

Column Name	Field Prompt
GLOBAL_ATTRIBUTE1	Reference Text

France Context: JE.FR.APXIISIM.TAX_RULE

This table shows the column name and field prompt for this context.

Column Name	Field Prompt
GLOBAL_ATTRIBUTE1	Deduction Tax Rule

Hungary Context: JE.HU.APXIISIM.TAX_DATE

This table shows the column name and field prompt for this context.

Column Name	Field Prompt
GLOBAL_ATTRIBUTE1	Tax Date

Netherlands Context: JE.NL.APXIISIM.FOREIGN

This table shows the column names and field prompts for this context.

Column Name	Field Prompt
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.

Column Name	Field Prompt
GLOBAL_ATTRIBUTE1	Invoice Number
GLOBAL_ATTRIBUTE2	Declaration Code
GLOBAL_ATTRIBUTE3	Declaration Desc
GLOBAL_ATTRIBUTE4	Urgency Called
GLOBAL_ATTRIBUTE5	Message to Supplier