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

Context: Global Data Elements

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

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:

-

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: Reconciliation Headers

Context: Global Data Elements

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

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

Context: Global Data Elements

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

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

Belgium Context: BE.EFT Payments

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

JGZZ_INVOICE_INFO1

IBLC Code

Finland Context: FI.Konekielinen viite

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

JGZZ_INVOICE_INFO1

Reference Number

JGZZ_INVOICE_INFO2

Check Digit

Finland Context: FI.Vapaa viite

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

JGZZ_INVOICE_INFO1

Reference Text

Finland Context: FI.Vero

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

JGZZ_INVOICE_INFO1

Tax Reference

JGZZ_INVOICE_INFO2

Tax Message

JGZZ_INVOICE_INFO3

Long Message Line 1

JGZZ_INVOICE_INFO4

Long Message Line 2

Finland Context: FI.Viesti

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

JGZZ_INVOICE_INFO1

Short Message Line

JGZZ_INVOICE_INFO2

Long Message Line 1

JGZZ_INVOICE_INFO3

Long Message Line 2

Netherlands Context: NL.Foreign Payments

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

JGZZ_INVOICE_INFO1

Payment Category Code

JGZZ_INVOICE_INFO10

Goods Code/Article Number

JGZZ_INVOICE_INFO11

Payment Nature

Norway Context: NO.Norway

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

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

Sweden Context: SE.Bankgiro Inland

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

JGZZ_INVOICE_INFO1

Message Row 1

JGZZ_INVOICE_INFO2

Message Row 2

Sweden Context: SE.Bankgiro SISU

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

JGZZ_INVOICE_INFO1

Federal Reserve Code

JGZZ_INVOICE_INFO2

Express Invoice

JGZZ_INVOICE_INFO3

Invoice Charge Code

JGZZ_INVOICE_INFO4

Future Contract

Sweden Context: SE.Bankgiro UTLI

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

JGZZ_INVOICE_INFO1

Federal Reserve Code

JGZZ_INVOICE_INFO2

Express Invoice

JGZZ_INVOICE_INFO3

Invoice Charge Code

JGZZ_INVOICE_INFO4

Future Contract

Sweden Context: SE.Postgiro Inland

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

JGZZ_INVOICE_INFO1

Message Row 1

JGZZ_INVOICE_INFO2

Message Row 2

Sweden Context: SE.Postgiro Utland

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

JGZZ_INVOICE_INFO1

Federal Reserve Code

JGZZ_INVOICE_INFO2

Express Payment

JGZZ_INVOICE_INFO3

Future Contract Postgiro

Switzerland Context: CH.Swiss DTA Payment

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

JGZZ_INVOICE_INFO1

ESR Number

Switzerland Context: CH.Swiss SAD Payment

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

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

Finland Context: FI.LMP

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

JGZZ_FORMAT_INFO2

Illegal Characters

JGZZ_FORMAT_INFO3

Legal Replacement Characters

JGZZ_FORMAT_INFO5

EDI Identifier

JGZZ_FORMAT_INFO6

Processing Type

Finland Context: FI.LUM2

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

JGZZ_FORMAT_INFO1

Exchange Rate Contract Number

JGZZ_FORMAT_INFO2

Illegal Characters

JGZZ_FORMAT_INFO3

Legal Replacement Characters

JGZZ_FORMAT_INFO7 EFT

User Number

Finland Context: FI.ULMP

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

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

Germany Context: DE.U

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

JGZZ_PS_INFO1

Country

JGZZ_PS_INFO3

Declaration Flag

JGZZ_PS_INFO9

Alpha

JGZZ_PS_INFO17

Numeric

Germany Context: DE.V

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

JGZZ_PS_INFO1

Export Country

JGZZ_PS_INFO3

Declaration Flag

JGZZ_PS_INFO8

Import Country

JGZZ_PS_INFO9

Transit Goods

JGZZ_PS_INFO10

Money Due Date

JGZZ_PS_INFO11

Import Numeric

JGZZ_PS_INFO12

Selling Cost

JGZZ_PS_INFO17

Goods No.

JGZZ_PS_INFO18

Export Alpha

JGZZ_PS_INFO19

Export Numeric

JGZZ_PS_INFO20

Purchase Cost

JGZZ_PS_INFO21

Passing Trade

JGZZ_PS_INFO22

Goods Separated

JGZZ_PS_INFO23

Stored Inland

JGZZ_PS_INFO24

Stored Abroad

JGZZ_PS_INFO25

Export Goods

JGZZ_PS_INFO26

Export No

JGZZ_PS_INFO27

Import Alpha

JGZZ_PS_INFO28

Buyers Address

Germany Context: DE.W

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

JGZZ_PS_INFO1

Country Name

JGZZ_PS_INFO3

Declaration Flag

JGZZ_PS_INFO9

Record Type

JGZZ_PS_INFO17

Reason

JGZZ_PS_INFO18

Alpha

JGZZ_PS_INFO19

Numeric

JGZZ_PS_INFO20

Explanation

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

Germany Context: DE.JEDEDEFI

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

JGZZ_SYSTEM_INFO1

LZB Area Number

JGZZ_SYSTEM_INFO2

Company Number

JGZZ_SYSTEM_INFO3

Declaration Flag

JGZZ_SYSTEM_INFO5

Declaration Limit

Netherlands Context: NL.JENLFFGN

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

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

Norway Context: NO.JENOPBDR

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

JGZZ_SYSTEM_INFO1

Customer ID

JGZZ_SYSTEM_INFO2

Agreement ID

JGZZ_SYSTEM_INFO3

Last Sequence Number

JGZZ_SYSTEM_INFO4

Last Date File Created

JGZZ_SYSTEM_INFO5

Last Num Sent to BBS

JGZZ_SYSTEM_INFO6

Sigil ID

JGZZ_SYSTEM_INFO7

Sum

Norway Context: NO.JENOPDDG

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

JGZZ_SYSTEM_INFO1

Customer ID

JGZZ_SYSTEM_INFO2

Return Code

JGZZ_SYSTEM_INFO3

Department

JGZZ_SYSTEM_INFO4

Alternate Bank Account

JGZZ_SYSTEM_INFO5

File ID

JGZZ_SYSTEM_INFO6

Password

JGZZ_SYSTEM_INFO7

Status

JGZZ_SYSTEM_INFO8

Record Length

JGZZ_SYSTEM_INFO9

File Number

Norway Context: NO.JENOPTGN

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

JGZZ_SYSTEM_INFO1

NIF Value

JGZZ_SYSTEM_INFO2

Division

JGZZ_SYSTEM_INFO3

Password

JGZZ_SYSTEM_INFO4

Operator Number

JGZZ_SYSTEM_INFO8

Trans Seq Num

JGZZ_SYSTEM_INFO10

Seq Control

Sweden Context: SE.JESEPBAI

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

JGZZ_SYSTEM_INFO3

Invoice Information

JGZZ_SYSTEM_INFO4

Invoice End Date

JGZZ_SYSTEM_INFO5

Invoice Title

JGZZ_SYSTEM_INFO6

Amount Header

JGZZ_SYSTEM_INFO7

Account Code

JGZZ_SYSTEM_INFO8

Credit Code

JGZZ_SYSTEM_INFO9

Credit Days

JGZZ_SYSTEM_INFO10

EFT File Directory

JGZZ_SYSTEM_INFO13

Payment Date

Sweden Context: SE.JESEPBSI

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

JGZZ_SYSTEM_INFO2

Sender Name

JGZZ_SYSTEM_INFO3

Sender Address

JGZZ_SYSTEM_INFO4

Report Code

JGZZ_SYSTEM_INFO5

Sort Code

JGZZ_SYSTEM_INFO6

Invoice Option

JGZZ_SYSTEM_INFO7

Federal Reserve Code

JGZZ_SYSTEM_INFO8

EFT File Directory

JGZZ_SYSTEM_INFO9

Days Credit Memo Valid

JGZZ_SYSTEM_INFO13

Payment Date

Sweden Context: SE.JESEPBUT

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

JGZZ_SYSTEM_INFO2

Sender Name

JGZZ_SYSTEM_INFO3

Sender Address

JGZZ_SYSTEM_INFO4

Clearing Number

JGZZ_SYSTEM_INFO5

Credit Days

JGZZ_SYSTEM_INFO6

Federal Reserve Code

JGZZ_SYSTEM_INFO7

BGC

JGZZ_SYSTEM_INFO8

EFT File Directory

JGZZ_SYSTEM_INFO13

Payment Date

Sweden Context: SE.JESEPPOI

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

JGZZ_SYSTEM_INFO1

Customer Number

JGZZ_SYSTEM_INFO2

Credit Days

JGZZ_SYSTEM_INFO3

Sender Information 1

JGZZ_SYSTEM_INFO4

Sender Information 2

JGZZ_SYSTEM_INFO6

Sort Option

JGZZ_SYSTEM_INFO7

Accounting Code

JGZZ_SYSTEM_INFO8

Envelope

JGZZ_SYSTEM_INFO9

Sender Code

JGZZ_SYSTEM_INFO11

EFT File Directory

JGZZ_SYSTEM_INFO12

Date + Sequence

JGZZ_SYSTEM_INFO13

Payment Date

Sweden Context: SE.JESEPPOU

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

JGZZ_SYSTEM_INFO2

Customer Number

JGZZ_SYSTEM_INFO3

Sender Name

JGZZ_SYSTEM_INFO4

Sender Address

JGZZ_SYSTEM_INFO5

Sender Postal Address

JGZZ_SYSTEM_INFO6

Federal Reserve Code

JGZZ_SYSTEM_INFO7

Sort Option

JGZZ_SYSTEM_INFO8

Report Code

JGZZ_SYSTEM_INFO9

Credit Days

JGZZ_SYSTEM_INFO10

EFT File Directory

JGZZ_SYSTEM_INFO11

Date + Sequence

JGZZ_SYSTEM_INFO13

Payment Date

Switzerland Context: CH.JECHRDTA

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

JGZZ_SYSTEM_INFO1

Company ID

JGZZ_SYSTEM_INFO2

Company Name

JGZZ_SYSTEM_INFO3

Company Address Line 1

JGZZ_SYSTEM_INFO4

Company Address Line 2

JGZZ_SYSTEM_INFO5

Company City

JGZZ_SYSTEM_INFO6

Company TELEKURS ID

JGZZ_SYSTEM_INFO7

Department TELEKURS ID

Switzerland Context: CH.JECHRSAD

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

JGZZ_SYSTEM_INFO1

Company ID

JGZZ_SYSTEM_INFO2

Company Name

JGZZ_SYSTEM_INFO3

Company Address Line 1

JGZZ_SYSTEM_INFO4

Company Address Line 2

JGZZ_SYSTEM_INFO5

Company City

JGZZ_SYSTEM_INFO6

Company Postal Code

JGZZ_SYSTEM_INFO7

Company PTT File ID

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

Austria Context: AT

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

JGZZ_SITE_INFO1

Bank Charge Code

Belgium Context: BE

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

JGZZ_SITE_INFO1

IBLC

JGZZ_SITE_INFO10

Cost Code

Germany Context: DE

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

JGZZ_SITE_INFO1

Declaration Flag

JGZZ_SITE_INFO2

Reasons

JGZZ_SITE_INFO3

Bank Instruction

JGZZ_SITE_INFO4

Charge Code

JGZZ_SITE_INFO5

Payment Method

JGZZ_SITE_INFO6

Explanation

JGZZ_SITE_INFO7

Bank Instruction Details

JGZZ_SITE_INFO10

Country

JGZZ_SITE_INFO11

Declaration Type

JGZZ_SITE_INFO12

NUMERIC

Finland Context: FI

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

JGZZ_SITE_INFO1

Payment Format

JGZZ_SITE_INFO2

Dependence Code

JGZZ_SITE_INFO3

Payment Type

JGZZ_SITE_INFO4

Short Message Line

JGZZ_SITE_INFO5

Long Message Line 1

JGZZ_SITE_INFO6

Long Message Line 2

JGZZ_SITE_INFO10

Bank Expense Code

Netherlands Context: NL

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

JGZZ_SITE_INFO1

Crossed Check

JGZZ_SITE_INFO10

Check Forwarding Code

JGZZ_SITE_INFO11

Domestic Costs Code

JGZZ_SITE_INFO12

Correspondent's Costs Code

JGZZ_SITE_INFO13

Urgency Code

Norway Context: NO

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

JGZZ_SITE_INFO6

Foreign Transactions

JGZZ_SITE_INFO7

Norwegian Transactions

Sweden Context: SE

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

JGZZ_SITE_INFO1

Receiver Name

JGZZ_SITE_INFO2

Federal Reserve Code

JGZZ_SITE_INFO4

Payment Expense Code

JGZZ_SITE_INFO5

UTLI Header Code

JGZZ_SITE_INFO6

OCR Customer Reference

Switzerland Context: CH

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

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

Context: Y

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

JGZZ_ATTRIBUTE1

Interest Invoice

JGZZ_ATTRIBUTE2

Transaction Types

JGZZ_ATTRIBUTE4

Interest Invoice Text

JGZZ_ATTRIBUTE5

Hold Charged Invoices

JGZZ_ATTRIBUTE6

Effective Date

JGZZ_ATTRIBUTE7

Salesperson

JGZZ_ATTRIBUTE8

Payment Terms

JGZZ_ATTRIBUTE9

Include Credit Items

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

Context: Y

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

JGZZ_ATTRIBUTE2

Fixed Fee

JGZZ_ATTRIBUTE3

Minimum Amount

JGZZ_ATTRIBUTE4

Minimum Payment Amount

JGZZ_ATTRIBUTE5

Exchange Rate Type

JGZZ_ATTRIBUTE6

Exchange Rate

JGZZ_ATTRIBUTE7

Calculation Method

JGZZ_ATTRIBUTE8

Daily Rates

JGZZ_ATTRIBUTE9

Monthly Rates

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

Context: Y

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

JGZZ_ATTRIBUTE1

Interest Invoice

JGZZ_ATTRIBUTE2

Transaction Types

JGZZ_ATTRIBUTE4

Interest Invoice Text

JGZZ_ATTRIBUTE5

Hold Charged Invoices

JGZZ_ATTRIBUTE6

Effective Date

JGZZ_ATTRIBUTE7

Salesperson

JGZZ_ATTRIBUTE8

Payment Terms

JGZZ_ATTRIBUTE9

Include Credit Items

JGZZ_ATTRIBUTE10

Update Profiles

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

Context: Y

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

JGZZ_ATTRIBUTE2

Fixed Fee

JGZZ_ATTRIBUTE3

Minimum Amount

JGZZ_ATTRIBUTE4

Minimum Payment Amount

JGZZ_ATTRIBUTE5

Exchange Rate Type

JGZZ_ATTRIBUTE6

Exchange Rate

JGZZ_ATTRIBUTE7

Calculation Method

JGZZ_ATTRIBUTE8

Daily Rates

JGZZ_ATTRIBUTE9

Monthly Rates

JGZZ_ATTRIBUTE10

Update Profiles


 
   

05-04 01:13