Oracle Global Finanicals Technical Reference（二）
| Oracle Global Finanicals Oracle Global Financials Technical Reference Manual Release 11i |
|
European Region (EMEA) Flexfields
European flexfields are included in the setup and transaction windows of Oracle General Ledger, Payables, and Receivables products. These flexfields enable country-specific and regional information that is specific to Europe.
GL_CODE_COMBINATIONS
GL_CODE_COMBINATIONS stores valid account combinations for each Accounting Flexfield structure within your Oracle General Ledger application. Associated with each account are certain codes and flags, including whether the account is enabled, whether detail posting or detail budgeting is allowed, and others.
Segment values are stored in the SEGMENT columns. Note that each Accounting Flexfield structure may use different SEGMENT columns within the table to store the flexfield value combination. Moreover, the SEGMENT columns that are used are not guaranteed to be in any order.
The Oracle Application Object Library table FND_ID_FLEX_SEGMENTS stores information about which column in this table is used for each segment of each Accounting Flexfield structure. Summary accounts have SUMMARY_FLAG = 'Y' and TEMPLATE_ID not NULL. Detail accounts have SUMMARY_FLAG = 'N' and TEMPLATE_ID NULL.
Flexfield: Reconciliation Combinations
This table shows the column name and field prompt for this context.
| Column Name | Field Prompt |
|---|---|
|
ALLOCATION_CREATE_FLAG |
Reconciliation Flag |
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:
Flexfield: Reconciliation Headers
This table shows the column name and field prompt for this context.
| Column Name | Field Prompt |
|---|---|
|
JGZZ_RECON_REF |
Reconciliation Reference |
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: Enter Journals: Reconciliation
This table shows the column names and field prompts for this context.
| Column Name | Field Prompt |
|---|---|
|
JGZZ_RECON_REF |
Reconciliation Reference |
|
JGZZ_RECON_DATE |
Reconciliation Date |
JG_ZZ_INVOICE_INFO
This table holds additional country-specific invoice information that is used in the generation of different payment formats, typically EFT.
Flexfield: Invoice EFT Details
This table shows the column name and field prompt for this context.
| Column Name | Field Prompt |
|---|---|
|
JGZZ_INVOICE_INFO1 |
IBLC Code |
This table shows the column names and field prompts for this context.
| Column Name | Field Prompt |
|---|---|
|
JGZZ_INVOICE_INFO1 |
Reference Number |
|
JGZZ_INVOICE_INFO2 |
Check Digit |
This table shows the column name and field prompt for this context.
| Column Name | Field Prompt |
|---|---|
|
JGZZ_INVOICE_INFO1 |
Reference Text |
This table shows the column names and field prompts for this context.
| Column Name | Field Prompt |
|---|---|
|
JGZZ_INVOICE_INFO1 |
Tax Reference |
|
JGZZ_INVOICE_INFO2 |
Tax Message |
|
JGZZ_INVOICE_INFO3 |
Long Message Line 1 |
|
JGZZ_INVOICE_INFO4 |
Long Message Line 2 |
This table shows the column names and field prompts for this context.
| Column Name | Field Prompt |
|---|---|
|
JGZZ_INVOICE_INFO1 |
Short Message Line |
|
JGZZ_INVOICE_INFO2 |
Long Message Line 1 |
|
JGZZ_INVOICE_INFO3 |
Long Message Line 2 |
This table shows the column names and field prompts for this context.
| Column Name | Field Prompt |
|---|---|
|
JGZZ_INVOICE_INFO1 |
Payment Category Code |
|
JGZZ_INVOICE_INFO10 |
Goods Code/Article Number |
|
JGZZ_INVOICE_INFO11 |
Payment Nature |
This table shows the column names and field prompts for this context.
| Column Name | Field Prompt |
|---|---|
|
JGZZ_INVOICE_INFO1 |
KID |
|
JGZZ_INVOICE_INFO2 |
Declaration Code |
|
JGZZ_INVOICE_INFO3 |
Declaration Desc |
|
JGZZ_INVOICE_INFO4 |
Urgency Called |
|
JGZZ_INVOICE_INFO5 |
Message to Supplier |
This table shows the column names and field prompts for this context.
| Column Name | Field Prompt |
|---|---|
|
JGZZ_INVOICE_INFO1 |
Message Row 1 |
|
JGZZ_INVOICE_INFO2 |
Message Row 2 |
This table shows the column names and field prompts for this context.
| Column Name | Field Prompt |
|---|---|
|
JGZZ_INVOICE_INFO1 |
Federal Reserve Code |
|
JGZZ_INVOICE_INFO2 |
Express Invoice |
|
JGZZ_INVOICE_INFO3 |
Invoice Charge Code |
|
JGZZ_INVOICE_INFO4 |
Future Contract |
This table shows the column names and field prompts for this context.
| Column Name | Field Prompt |
|---|---|
|
JGZZ_INVOICE_INFO1 |
Federal Reserve Code |
|
JGZZ_INVOICE_INFO2 |
Express Invoice |
|
JGZZ_INVOICE_INFO3 |
Invoice Charge Code |
|
JGZZ_INVOICE_INFO4 |
Future Contract |
This table shows the column names and field prompts for this context.
| Column Name | Field Prompt |
|---|---|
|
JGZZ_INVOICE_INFO1 |
Message Row 1 |
|
JGZZ_INVOICE_INFO2 |
Message Row 2 |
This table shows the column names and field prompts for this context.
| Column Name | Field Prompt |
|---|---|
|
JGZZ_INVOICE_INFO1 |
Federal Reserve Code |
|
JGZZ_INVOICE_INFO2 |
Express Payment |
|
JGZZ_INVOICE_INFO3 |
Future Contract Postgiro |
This table shows the column name and field prompt for this context.
| Column Name | Field Prompt |
|---|---|
|
JGZZ_INVOICE_INFO1 |
ESR Number |
This table shows the column name and field prompt for this context.
| Column Name | Field Prompt |
|---|---|
|
JGZZ_INVOICE_INFO1 |
ESR Number |
JG_ZZ_PAY_FORMAT_INFO
This table holds additional country-specific payment format information that is used to generate different payment formats, typically EFT.
Flexfield: Payment Format EFT Details
This table shows the column names and field prompts for this context.
| Column Name | Field Prompt |
|---|---|
|
JGZZ_FORMAT_INFO2 |
Illegal Characters |
|
JGZZ_FORMAT_INFO3 |
Legal Replacement Characters |
|
JGZZ_FORMAT_INFO5 |
EDI Identifier |
|
JGZZ_FORMAT_INFO6 |
Processing Type |
This table shows the column names and field prompts for this context.
| Column Name | Field Prompt |
|---|---|
|
JGZZ_FORMAT_INFO1 |
Exchange Rate Contract Number |
|
JGZZ_FORMAT_INFO2 |
Illegal Characters |
|
JGZZ_FORMAT_INFO3 |
Legal Replacement Characters |
|
JGZZ_FORMAT_INFO7 EFT |
User Number |
This table shows the column names and field prompts for this context.
| Column Name | Field Prompt |
|---|---|
|
JGZZ_FORMAT_INFO1 |
Exchange Rate Contract Number |
|
JGZZ_FORMAT_INFO2 |
Illegal Characters |
|
JGZZ_FORMAT_INFO3 |
Legal Replacement Characters |
|
JGZZ_FORMAT_INFO7 |
EFT User Number |
JG_ZZ_PAY_SCHED_INFO
This table holds additional country-specific payment schedule information that is used to generate different payment formats, typically EFT.
Flexfield: Scheduled Payment EFT Details
This table shows the column names and field prompts for this context.
| Column Name | Field Prompt |
|---|---|
|
JGZZ_PS_INFO1 |
Country |
|
JGZZ_PS_INFO3 |
Declaration Flag |
|
JGZZ_PS_INFO9 |
Alpha |
|
JGZZ_PS_INFO17 |
Numeric |
This table shows the column names and field prompts for this context.
This table shows the column names and field prompts for this context.
JG_ZZ_SYS_FORMATS_ALL_B
This table holds additional country-specific information for EFT Payment Formats. Custom values in this table are not translated. Translated column values for multilingual support are stored in the JG_ZZ_SYS_FORMATS_ALL_TL table.
Flexfield: System Format
This table shows the column names and field prompts for this context.
| Column Name | Field Prompt |
|---|---|
|
JGZZ_SYSTEM_INFO1 |
LZB Area Number |
|
JGZZ_SYSTEM_INFO2 |
Company Number |
|
JGZZ_SYSTEM_INFO3 |
Declaration Flag |
|
JGZZ_SYSTEM_INFO5 |
Declaration Limit |
This table shows the column names and field prompts for this context.
| Column Name | Field Prompt |
|---|---|
|
JGZZ_SYSTEM_INFO1 |
DNB Registration Num |
|
JGZZ_SYSTEM_INFO10 |
Trader Number |
|
JGZZ_SYSTEM_INFO11 |
Authorized Bank |
|
JGZZ_SYSTEM_INFO12 |
Business Sector |
|
JGZZ_SYSTEM_INFO13 |
EFT Rate Type |
This table shows the column names and field prompts for this context.
This table shows the column names and field prompts for this context.
This table shows the column names and field prompts for this context.
This table shows the column names and field prompts for this context.
This table shows the column names and field prompts for this context.
This table shows the column names and field prompts for this context.
This table shows the column names and field prompts for this context.
This table shows the column names and field prompts for this context.
This table shows the column names and field prompts for this context.
This table shows the column names and field prompts for this context.
JG_ZZ_VEND_SITE_INFO
This table holds additional country-specific supplier site information that is used to generate different payment formats, typically EFT.
Flexfield: Supplier Site EFT Details
This table shows the column name and field prompt for this context.
| Column Name | Field Prompt |
|---|---|
|
JGZZ_SITE_INFO1 |
Bank Charge Code |
This table shows the column names and field prompts for this context.
| Column Name | Field Prompt |
|---|---|
|
JGZZ_SITE_INFO1 |
IBLC |
|
JGZZ_SITE_INFO10 |
Cost Code |
This table shows the column names and field prompts for this context.
This table shows the column names and field prompts for this context.
This table shows the column names and field prompts for this context.
This table shows the column names and field prompts for this context.
| Column Name | Field Prompt |
|---|---|
|
JGZZ_SITE_INFO6 |
Foreign Transactions |
|
JGZZ_SITE_INFO7 |
Norwegian Transactions |
This table shows the column names and field prompts for this context.
This table shows the column name and field prompt for this context.
| Column Name | Field Prompt |
|---|---|
|
JGZZ_SITE_INFO2 |
Payment Type |
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: Interest Invoice Profile
This table shows the column names and field prompts for this context.
HZ_CUST_PROFILE_AMTS
The HZ_CUST_PROFILE_AMTS table stores information about the credit limits specified for a customer profile class for a single currency. The credit limits of the profile class can then be assigned to specific customer accounts or customer account sites. Many of the values in this table may be default values, from the HZ_CUST_PROF_CLASS_AMTS table, which can be modified in this table for a specified customer account or customer account site. For example, while the profile class Large Independent Retail Stores may have an overall credit limit of 250, 000 euros, you may limit a new customer in this class to an overall credit limit of 50,000 euros.
The primary key for this table is CUST_ACCT_PROFILE_AMT_ID.
Flexfield: Interest Invoice Profile Amounts
This table shows the column names and field prompts for this context.
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: Interest Invoice Profile Class
This table shows the column names and field prompts for this context.
HZ_CUST_PROF_CLASS_AMTS
The HZ_CUST_PROF_CLASS_AMTS table stores information about the credit limits placed on a customer profile class for a specific currency. For example, the profile class Large Independent Retail Stores may have an overall credit limit of 250,000 euros and a per transaction limit of 50,000 euros.
The primary key for this table is PROFILE_CLASS_AMOUNT_ID.
Flexfield: Interest Invoice Profile Class Amounts
This table shows the column names and field prompts for this context.
|
|
|
