Oracle Cloud Configuration Guide

General Ledger

Author: Ranganathan K
Creation Date:
Last Updated: 8-Aug-2019
Last Updated By:
Document Version:
Seq Configuration Item
1 Manage Legal Jur
2 Manage Legal Add
3 Manage LE
4 COA Value Sets
5 COA Structures
6 COA Structure Instances
7 COA Values
8 Legal Entity Values
9 Cost Center Values
10 Line of Business Values
11 Natural Account Values
12 Inter CO Values
13 Future Values
14 Accounting Calenders
15 Primary Ledgers
16 BSV Values
17 Assign Legal Entities to Ledgers
18 Specify Ledger Options
Document Title: Oracle Cloud General Ledger Configuration Guide
Current Version: 0.1

Overview
The following document contains the configuration information for the Oracle Cloud General

Change History
Version Date Changes

Approver Detail
Review # Date Instance / Go-Live
mation for the Oracle Cloud General Ledger Configurations

Changes Owner

Name & Role of Approver Signature

Back to Overview
Manage Chart of Accounts Value Sets
Navigation: Financials > Define Common Applications Configuration for Financials > Define Enterprise Structures for Financials > Define Financial Reporting Structures > D

Value Set Code Description Module Validation Type Validation Security

Date Type Enabled

FORD_COMPANY Company segment General Ledger Independent Character No

FORD_COST_CENTER Cost center segment General Ledger Independent Character No
FORD_LINE_OF_BUSINESS Line of business segment General Ledger Independent Character No
FORD_NATURAL_ACCOUNT Natural account segment General Ledger Independent Character No
FORD_INTER_COMPANY Inter company segment General Ledger Independent Character No
FORD_FUTURE Future segment General Ledger Independent Character No

Screenshots
Define Financial Reporting Structures > Define Chart of Accounts > Manage Chart of Accounts Value Sets

Data Security Resource Name Value Maximum Minimum Maximum Upper Case Zero Fill Independent Value
SubType Length Value Value Only Set Code

Text 3 Yes Yes

Text 4 Yes Yes
Text 4 Yes Yes
Text 5 Yes Yes
Text 3 Yes Yes
Text 4 Yes Yes
Back to Overview
Manage Chart of Accounts Structures
Navigation: Financials > Define Common Applications Configuration for Financials > Define Enterprise Structures for Financials > Define Financial Reporting Structures >

Step 1 Define Flexfield Structure

Select 'Manage Structures'
Structure Code Name Description Delimiter Enabled
FORD_COA FORD_COA FORD Chart of Accounts Structure . Yes

Step 2 Define Flexfield Segments

Click on Create

Segments Summary
Structure Code Segment Code API Name Name Description

FORD_COA FORD_COMPANY FORDCO FORD_COMPANY Ford Company

FORD_COA FORD_COST_CENTER FORDCC FORD_COST_CENTER Ford Cost Center
FORD_COA FORD_LINE_OF_BUSINESS FORDLOB FORD_LINE_OF_BUSINESS Ford Line of Business
FORD_COA FORD_NATURAL_ACCOUNT FORDNA FORD_NATURAL_ACCOUNT Ford Natural Account
FORD_COA FORD_INTER_COMPANY FORDIC FORD_INTER_COMPANY Ford Inter Company
FORD_COA FORD_FUTURE FORDFU FORD_FUTURE Ford Future

Click Save and Done

Screenshots
 2. The following
segment labels
are mandatory:
Primary
Balancing
segment and
Natural Account
segment.
ial Reporting Structures > Define Chart of Accounts > Manage Chart of Accounts Structures 3. The
Intercompany
segment is
optional. If
specified it will
reuse the value
set created for
primary
balancing
segment.
4. The Second
and Third
Balancing
segments are
Sequence Prompt Short Prompt Enabled Display Range Type
optional. Second Column Name
Number Width
balancing
1 Company CO Y segment
3 may be SEGMENT1
2 CostCenter CC Y assigned
4 with SEGMENT2
3 Line of Business LOB Y the
4 Cost Center SEGMENT3
segment.
4 Account NA Y 5 SEGMENT4
5 Inter Company IC Y 3 SEGMENT5
6 Future FUT Y 4 SEGMENT6

s
 Default Value Set Code Segment Labels

FORD_COMPANY Primary Balancing Segment

FORD_COST_CENTER Cost Center Segment
FORD_LINE_OF_BUSINESS
FORD_NATURAL_ACCOUNT Natural Account Segment
FORD_INTER_COMPANY Intercompany Segment
FORD_FUTURE
Back to Overview
Manage Chart of Accounts Structure Instances
Navigation: Financials > Define Common Applications Configuration for Financials > Define Enterprise Structures for Financials > Define Financial Reporting Structures > De

Select 'Manage Structure Instances'. Select Create.

Structure Instance Code API name

FORD_COA FORDCOA

Click on Action --> Edit under Segment Instances: To Define defaults

Segment Code Value Set Code

FORD_COMPANY FORD_COMPANY
FORD_COST_CENTER FORD_COST_CENTER
FORD_LINE_OF_BUSINESS FORD_LINE_OF_BUSINESS
FORD_NATURAL_ACCOUNT FORD_NATURAL_ACCOUNT
FORD_INTER_COMPANY FORD_INTER_COMPANY
FORD_FUTURE FORD_FUTURE

Select 'Deploy Flexfield'

Screen
or Financials > Define Financial Reporting Structures > Define Chart of Accounts > Manage Chart of Accounts Structure Instances

Name Description Enabled Dynamic Structure Name

Combination
Creation
Allowed

FORD_COA Ford Chart of Accounts Yes Yes FORD_COA

Required Displayed BI Enabled Default Type Default Value Query

Required
Yes Yes Yes Optional
Yes Yes Yes Optional
Yes Yes Yes Optional
Yes Yes Yes Optional
Yes Yes Yes Optional
Yes Yes Yes Optional

Screenshots
Tree Name
Back to Overview
Manage Chart of Accounts Value Set Values
Navigation: Financials > Define Common Applications Configuration for Financials > Define Enterprise Structures for Financials > Define Financial Reporting Structures > De

Screenshots

Upload values using Rapid Implementation

cial Reporting Structures > Define C
 ID#AAAADVT7v====== (2019-08-12 E
ID#AAAADVT7v ====== 12:59:01) b8
XY ID#AAAADVT7v12:59:01) ALLOW_POSTI
cw ID#AAAADVT7v SUMMARY_FLA ALLOW_BUDGE
(2019-08-12 a4 ENABLED_FLA NG_FLAG
VALUE_SET_C dk G TING_FLAG
12:59:01) END_DATE_ACG (2019-08-12
ODE (2019-08- VALUE (2019- NOT NULL (2019-08-12
START_DATE_A TIVE (2019- NOT NULL 12:59:01)
12 12:59:01) 08-12 12:59:01) VARCHAR2(1) 12:59:01)
*Value Set Code ValueNOT NULL StartNOT CTIVE
DateNULL End Date 08-12Flag
*Enabled 12:59:01) VARCHAR2(1
*Summary F*Allow Posti*AllowVARCHAR2(1)
Budge Enter Y if
FORD_COMPANY 101 VARCHAR2(6001/01/15 DATE Y FORMAT: N CHAR)Y Enter YYor N to
VARCHAR2(25 budgeting is
FORMAT: YYYY/MM/DD Enter Y to
FORD_COMPANY 201 CHAR) 01/01/15 CHAR) Y N Y indicateY if the allowed for this
YYYY/MM/DD Enter Y to allowed posting
segment value is segment value
Enter the end enable the for this segment
Enter the valueEnter the a parent value or and N if
Enter the start date of the segment value value and N to
set code for the
segment value. a child value. budgeting is not
Screenshots date of the segment value. and N to disable disallow posting.
segment values. Valid values are allowed. Valid
segment value. the segment Valid values are
Y for parent values are Y, N.
value. Y or N are Y, N.
value and N for
valid values.
child value.
 E
01) b8 ====== ======
ALLOW_POSTI ====== ====== ======
ARY_FLA ALLOW_BUDGE ID#AAAADVT7v====== ====== ====== ID#AAAADVT7v
NG_FLAG ID#AAAADVT7vID#AAAADVT7vID#AAAADVT7v
TING_FLAG XA ID#AAAADVT7vID#AAAADVT7v ID#AAAADVT7vUY
(2019-08-12 g0 ps nM
ULL (2019-08-12 DESCRIPTION_n4 d0 go DESCRIPTION_
12:59:01) DESCRIPTION_DESCRIPTION_DESCRIPTION_
HAR2(1) 12:59:01) US (2019-08-DESCRIPTION_DESCRIPTION_ DESCRIPTION_ESA (2019-08-
VARCHAR2(1)
Description D (2019-08-12
DK (2019-08-E (2019-08-12
Enter YUS if Description Description
12 12:59:01) Description
AR (2019-08- DescriptionDescription
CS (2019-08- Description Description
EL (2019-08-12 12:59:01)
12:59:01) 12 12:59:01) 12:59:01)
Y or N to Ford budgeting
Motor Companyis Segment value
12 12:59:01)12 12:59:01) 12 12:59:01)Segment value
Enter Y to Segment value
Segment value
Segment value
e if the Fordallowed
Of Britainfor this description Segment
in value
Segment value Segment value
description in
allowed posting description description
in description
in in
nt value is segment value American description description
in in description Latin
in American
for this segment German Danish Spanish
nt value or and N if English Arabic language.
Czech language. Greek language.
Spanish
value and N to language. language. language.
value. budgeting is not language. language.
disallow posting.
alues are allowed. Valid
Valid values are
arent values are Y, N.
Y, N.
and N for
alue.
 ID#AAAADVT7v ID#AAAADVT7vID#AAAADVT7v ID#AAAADVT7vID#AAAADVT7vID#AAAADVT7vl
ID#AAAADVT7v ID#AAAADVT7v ID#AAAADVT
====== 4 ID#AAAADVT7v ID#AAAADVT7v ID#AAAADVT7v
= g8 ZQ dM pw kg Q YY kw Yc
====== ID#AAAADVT7v (2019-08-12 oo ow Wk
AADVT7v (2019-08-12 (2019-08-12(2019-08-12 (2019-08-12(2019-08-12(2019-08-12(2019-08-12 (2019-08-12 (2019-08-12
ID#AAAADVT7vUY 12:59:01) (2019-08-12 (2019-08-12 (2019-08-12
12:59:01) 12:59:01) 12:59:01) 12:59:01) 12:59:01) 12:59:01) 12:59:01) 12:59:01) 12:59:01)
go DESCRIPTION_ DESCRIPTION_ 12:59:01) 12:59:01) 12:59:01)
RIPTION_ DESCRIPTION_ DESCRIPTION_DESCRIPTION_ DESCRIPTION_DESCRIPTION_DESCRIPTION_DESCRIPTION_ DESCRIPTION_ DESCRIPTION
DESCRIPTION_ESA (2019-08- FRC DESCRIPTION_ DESCRIPTION_ DESCRIPTION_
019-08-12 Description Description
F Description HR
Description HU
Description I
D escription IS
Description IW
Description JA
Description KO
Description Description LT
Description Description PT
EL (2019-08-12 12:59:01) VARCHAR2(240 I NL PL
01) VARCHAR2(240 VARCHAR2(240VARCHAR2(240 VARCHAR2(240VARCHAR2(240VARCHAR2(240VARCHAR2(240 VARCHAR2(240 VARCHAR2(2
12 12:59:01)Segment value ) VARCHAR2(240 VARCHAR2(240 VARCHAR2(240
ent value ) ) ) ) ) ) ) ) )
Segment value
description in ) ) )
ption in
description Latin
in American Segment value
h Segment value Segment value
Segment value Segment value
Segment value
Segment value
Segment value Segment value Segment value
Greek language.
Spanish description in Segment value Segment value Segment value
ge. description in description description
in in description description
in description
in description
in in description in description in
language. Canadian description in description in description in
French Croatian Hungarian Icelandic Hebrew Japanese Korean Lithuanian Portuguese
French Italian language. Dutch language. Polish language.
language. language. language. language. language. language. language. language. language.
language.
AADVT7v ID#AAAADVT7v ID#AAAADVT7vID#AAAADVT7vID#AAAADVT7vID#AAAADVT7vID#AAAADVT7vID#AAAADVT7vID#AAAADVT7v ID#AAAADVT7v ======
ID#AAAADVT7v Zo ID#AAAADVT7v bo ac
Yc Ug gg k4 Xw e4 pQ kk k0 ID#AAAADVT
Wk (2019-08-12 dE (2019-08-12(2019-08-12
9-08-12 (2019-08-12 (2019-08-12(2019-08-12(2019-08-12(2019-08-12(2019-08-12(2019-08-12(2019-08-12 (2019-08-12 gA
(2019-08-12 12:59:01) (2019-08-12 12:59:01) 12:59:01)
01) 12:59:01) 12:59:01) 12:59:01) 12:59:01) 12:59:01) 12:59:01) 12:59:01) 12:59:01) 12:59:01) Dipesh Gupta
12:59:01) DESCRIPTION_ 12:59:01) DESCRIPTION_ DESCRIPTION_
RIPTION_ DESCRIPTION_ DESCRIPTION_DESCRIPTION_DESCRIPTION_DESCRIPTION_DESCRIPTION_DESCRIPTION_DESCRIPTION_ DESCRIPTION_ (2019-08-12
DESCRIPTION_ PTB DESCRIPTION_ ZHS ZHT
PT
Description Description N
Description RO
Description RU
Description S
Description SF
Description SK
Description SL
Description Description TR
Description Description IS VALIDATED 12:59:01)
PL VARCHAR2(240 TH VARCHAR2(240 VARCHAR2(240
HAR2(240 VARCHAR2(240 VARCHAR2(240VARCHAR2(240VARCHAR2(240VARCHAR2(240VARCHAR2(240VARCHAR2(240VARCHAR2(240 VARCHAR2(240 Please do not
VARCHAR2(240 ) VARCHAR2(240 ) )
) ) ) ) ) ) ) ) ) put any value
) )
edit this colum
Segment value Segment valueSegment value
ent value Segment value Segment value
Segment value
Segment value
Segment value
Segment value
Segment value
Segment value Segment value This column is
Segment value description in Segment value description description
in in
ption in description in description description
in description
in description
in description
in description
in description
in in description in for validation
description in Brazilian description in Simplified Traditional
nian Portuguese Norwegian Romanian Russian Swedish Finnish Slovak Slovenian Turkish purposes.
Polish language. Portuguese Thai language. Chinese Chinese
ge. language. language. language. language. language. language. language. language. language.
language. language. language.
 ======
ac
ID#AAAADVT7v
9-08-12(2019-08-12
gA
01) 12:59:01)
Dipesh Gupta
RIPTION_
DESCRIPTION_
(2019-08-12
ZHT
IS VALIDATED 12:59:01)
HAR2(240
VARCHAR2(240
Please do not
)
put any value or
edit this column.
ent value
Segment value
This column is
ption description
in in
for validation
ied Traditional
purposes.
e Chinese
ge. language.
 ID#AAAADVT7v====== ======
ID#AAAADVT7v ======
ok ID#AAAADVT7vID#AAAADVT7v
dY ID#AAAADVT7v
(2019-08-12 hc Us
VALUE_SET_C ao
12:59:01) END_DATE_ACEND_DATE_AC
ODE (2019-08- VALUE (2019-
START_DATE_A TIVE (2019- TIVE (2019-
12 12:59:01) 08-12 12:59:01)
*Value Set Code *Value Start Date End CTIVE
Date 08-12 12:59:01)08-12 12:59:01)
Enabled
NOT NULL NOT NULL
0000VARCHAR2(60 DATE FORMAT: FORMAT:
FORD_COST_CENTER VARCHAR2(25
01/01/15 Y
FORMAT: YYYY/MM/DD YYYY/MM/DD
FORD_COST_CENTER 1000CHAR) 01/01/15 CHAR) Y
YYYY/MM/DD
FORD_COST_CENTER 1100 01/01/15 Y Enter the end Enter the end
FORD_COST_CENTER 1200Enter the 01/01/15
valueEnter the Y date of the
Enter the start date of the
set code for the
segment value.
FORD_COST_CENTER 2000 01/01/15 date of the Y segment value. segment value.
segment values.
FORD_COST_CENTER 3000 01/01/15 segment value.
Y
FORD_COST_CENTER 3100 01/01/15 Y
FORD_COST_CENTER 3200 01/01/15 Y
FORD_COST_CENTER 3300 01/01/15 Y
FORD_COST_CENTER 3400 01/01/15 Y
Screenshots
====== ====== mE
12:59:01) gY ======
ID#AAAADVT7vID#AAAADVT7v ALLOW_POSTI
SUMMARY_FLA ALLOW_BUDGE ID#AAAADVT7v======
hc Us NG_FLAG
G TING_FLAG og ID#AAAADVT7v
END_DATE_ACEND_DATE_AC (2019-08-12
NOT NULL (2019-08-12 DESCRIPTION_kM
TIVE (2019- TIVE (2019- 12:59:01)
VARCHAR2(1) 12:59:01) US (2019-08-DESCRIPTION_
08-12 12:59:01)08-12 Flag
*Summary 12:59:01)
*Allow Posting F*AllowVARCHAR2(1)
BudgetingDescription
Enter YUS if Description
12 12:59:01)AR (2019-08-
FORMAT: N FORMAT: Y
Enter Y or N to
Y budgeting is
Default Segment value
12 12:59:01)
YYYY/MM/DD YYYY/MM/DD Enter Y to
N Y indicate if theY allowed for this
Engineering description Segment
in value
allowed posting
N Y segment value
Y is segment value
Production American description in
Enter the end Enter the end for this segment
a parent value or and N& ifDevelopment English Arabic language.
date of the N date of the Y Y value and NResearch
to
a child value. budgeting is not language.
segment value.
N segment value.
Y Y disallow posting.
Marketing
Valid values are allowed. Valid
N Y Y for parentY Valid valuesFinance are & Accounting
values are Y, N.
N Y value and N Y forY, N. Procurement
N Y child value.Y Human Resources
N Y Y Information Technology
N Y Y Legal
Screenshots
 ID#AAAADVT7v ID#AAAADVT
====== ====== bY
====== ====== ====== T4 Q
ID#AAAADVT7v====== ====== ====== ID#AAAADVT7v (2019-08-12
ID#AAAADVT7v ID#AAAADVT7v ID#AAAADVT7v (2019-08-12 (2019-08-1
og ID#AAAADVT7vID#AAAADVT7v ID#AAAADVT7vj
W0 12:59:01)
eQ ZE a8 12:59:01) 12:59:01)
DESCRIPTION_kM cQ s DESCRIPTION_ DESCRIPTION_
DESCRIPTION_ DESCRIPTION_ DESCRIPTION_ DESCRIPTION_ DESCRIPTIO
US (2019-08-DESCRIPTION_DESCRIPTION_ DESCRIPTION_ESA (2019-08- FRC
Description Description D (2019-08-12
Description DK DK (2019-08-
Description E (2019-08-12
Description Description Description F
Description Description HR
12 12:59:01)AR (2019-08-CS (2019-08- EL (2019-08-12 12:59:01) VARCHAR2(240
12:59:01) 12 12:59:01)12:59:01) VARCHAR2(240 VARCHAR2(2
Segment value
12 12:59:01)12 12:59:01) 12 12:59:01)Segment value )
Segment value Segment value Segment value ) )
description Segment
in value
Segment value Segment value
description in
description in description description
in in
American description description
in in description Latin
in American Segment value
German Danish Spanish Segment value Segment valu
English Arabic language.
Czech language. Greek language.
Spanish description in
language. language. language. description in description in
language. language. Canadian
French Croatian
French
language. language.
language.
======
ID#AAAADVT
YQ
Shabbeer Sye
(2019-08-12
12:59:01)
Mandatory:
--------------
Asset
Budgetary Cre
Budgerary De
Expense
Liability
Owners Equit
Revenue
Statistical Ass
Statistical
Expense
AADVT7v ID#AAAADVT7vi
ID#AAAADVT7v ID#AAAADVT7vID#AAAADVT7vj
ID#AAAADVT7vID#AAAADVT7vf ID#AAAADVT7v
bY ID#AAAADVT7v ID#AAAADVT7v ID#AAAA
Q VA XM Y mM s h8
(2019-08-12 d8 ek kQ
9-08-12 (2019-08-12(2019-08-12 (2019-08-12(2019-08-12(2019-08-12(2019-08-12 (2019-08-12
12:59:01) (2019-08-12 (2019-08-12 (2019
01) 12:59:01) 12:59:01) 12:59:01) 12:59:01) 12:59:01) 12:59:01) 12:59:01)
DESCRIPTION_ 12:59:01) 12:59:01) 12:59:01
RIPTION_ DESCRIPTION_DESCRIPTION_ DESCRIPTION_DESCRIPTION_DESCRIPTION_DESCRIPTION_ DESCRIPTION_
FRC DESCRIPTION_ DESCRIPTION_ DESCRI
HR
Description HU
Description I
D escription IS IS
Description IW
Description JA
Description KO
Description Description LT
Description
VARCHAR2(240 I NL PL
HAR2(240 VARCHAR2(240VARCHAR2(240 VARCHAR2(240VARCHAR2(240VARCHAR2(240VARCHAR2(240 VARCHAR2(240
) VARCHAR2(240 VARCHAR2(240 VARCHA
) ) ) ) ) ) )
) ) )
Segment value
ent value Segment value
Segment value Segment value
Segment value
Segment value
Segment value Segment value
description in Segment value Segment value Segmen
ption in description description
in in description description
in description
in description
in in description in
Canadian description in description in descripti
Croatian Hungarian Icelandic Hebrew Japanese Korean Lithuanian
French Italian language. Dutch language. Polish la
ge. language. language. language. language. language. language. language.
language.
 ======
ID#AAAADVT7v
nw
Shabbeer Syed
(2019-08-12
12:59:01)
Optional:
-------------
Account
Payables
Accounts
Receivalbes
====== Accrued
ID#AAAADVT7v Liabilities
YQ Accumulated
Shabbeer Syed Depreciation
(2019-08-12 Cash
12:59:01) Common Stock
Mandatory: Contracting
-------------- Expenses
Asset Cost of Goods
Budgetary Credit Sold
Budgerary Debit Depreciation
Expense Expenses
Liability Employee
Owners Equity Benefit Related
Revenue expenses
Statistical Asset General
Statistical Administrative
Expense and Payroll
Expense
Income Tax
Intrest Expenses
Other Assets
Other Current
Assets
Other Current
Liabilities
Tax Liability
Travel and
Entertainment
Expenses
 ID#AAAADVT7v ID#AAAADVT7v ID#AAAADVT7vID#AAAADVT7vID#AAAADVT7vID#AAAADVT7vID#AAAADVT7vID#AAAADVT7vj
ID#AAAADVT7v
AADVT7v ID#AAAADVT7v m8 ID#AAA
h8 c0 bk hY hg Yk W4 8 gk
kQ (2019-08-12 g
(2019-08-12 (2019-08-12 (2019-08-12(2019-08-12(2019-08-12(2019-08-12(2019-08-12(2019-08-12(2019-08-12
9-08-12 (2019-08-12 12:59:01) (2019
12:59:01) 12:59:01) 12:59:01) 12:59:01) 12:59:01) 12:59:01) 12:59:01) 12:59:01) 12:59:01)
01) 12:59:01) DESCRIPTION_ 12:59:01
DESCRIPTION_ DESCRIPTION_ DESCRIPTION_DESCRIPTION_DESCRIPTION_DESCRIPTION_DESCRIPTION_DESCRIPTION_DESCRIPTION_
RIPTION_ DESCRIPTION_ PTB DESCR
LT Description PT
Description Description N
Description RO
Description RU
Description S
Description SF
Description SK
Description SL
Description
PL VARCHAR2(240 TH
VARCHAR2(240 VARCHAR2(240 VARCHAR2(240VARCHAR2(240VARCHAR2(240VARCHAR2(240VARCHAR2(240VARCHAR2(240VARCHAR2(240
HAR2(240 VARCHAR2(240 ) VARCH
) ) ) ) ) ) ) ) )
) )
Segment value
Segment value Segment value Segment value
Segment value
Segment value
Segment value
Segment value
Segment value
Segment value
ent value Segment value description in Segmen
description in description in description description
in description
in description
in description
in description
in description
in in
ption in description in Brazilian descript
Lithuanian Portuguese Norwegian Romanian Russian Swedish Finnish Slovak Slovenian
anguage. Polish language. Portuguese Thai lan
language. language. language. language. language. language. language. language. language.
language.
AADVT7vj
ID#AAAADVT7v ID#AAAADVT7v ======
ID#AAAADVT7vi Vc oU
gk XE ID#AAAADVT7v
g (2019-08-12(2019-08-12
9-08-12(2019-08-12 (2019-08-12 Vw
(2019-08-12 12:59:01) 12:59:01)
01) 12:59:01) 12:59:01) Dipesh Gupta
12:59:01) DESCRIPTION_ DESCRIPTION_
RIPTION_
DESCRIPTION_ DESCRIPTION_ (2019-08-12
DESCRIPTION_ ZHS ZHT
SL Description TR
Description Description IS VALIDATED 12:59:01)
TH VARCHAR2(240 VARCHAR2(240
HAR2(240
VARCHAR2(240 VARCHAR2(240 Please do not
VARCHAR2(240 ) )
) ) put any value or
)
edit this column.
Segment valueSegment value
ent value
Segment value Segment value This column is
Segment value description description
in in
ption description
in in description in for validation
description in Simplified Traditional
Slovenian Turkish purposes.
Thai language. Chinese Chinese
ge. language. language.
language. language.
*Value Set Code *Value Start Date End Date Enabled
FORD_LINE_OF_BUSINESS 1001 01/01/15 Y
FORD_LINE_OF_BUSINESS 2001 01/01/15 Y
FORD_LINE_OF_BUSINESS 3001 01/01/15 Y
FORD_LINE_OF_BUSINESS 4001 01/01/15 Y
Screenshots
*Summary Flag *Allow Posting F*Allow BudgetingDescription US Description
N Y Y Ford Cars
N Y Y Ford Trucks
N Y Y Ford Sport Utility Vehicles
N Y Y Lincoln Luxury Vehicles
Screenshots
Description Description Description DK Description Description Description Description Description Description
Description Description IDescription IS Description Description Description Description Description Description
Description Description Description Description Description Description Description Description Description Description
Description Description Description IS VALIDATED
 ID#AAAADVT7v====== Y0
====== 12:59:01)
pA ID#AAAADVT7v ALLOW_POS
ID#AAAADVT7v SUMMARY_FLA
(2019-08-12
VU NG_FLAG
bg G
12:59:01) END_DATE_AC (2019-08-12
VALUE (2019- NOT NULL
START_DATE_ATIVE (2019- 12:59:01)
08-12 12:59:01) VARCHAR2(1)
*Value Set Code *Value StartNOT
Date NULL CTIVEEnabled
End Date 08-12*Summar
12:59:01)*Allow VARCHAR2(1
DATE FORMAT:
y Flag Posting
VARCHAR2(25 Enter Y or N to
FORMAT: YYYY/MM/DD Flag Enter Y to
CHAR) indicate if the
YYYY/MM/DD allowed posti
segment value is
Enter the end for this segme
FORD_NATURAL_ACCOUNT10000 CASHEnter the
- DOMESTIC TRUE
Enter Ythe start
date N
of the Y a parent value or
value and N t
FORD_NATURAL_ACCOUNT10001 segment value. a child value.
CASH - EUR date ofY thesegment
TRUE N value.Y disallow posti
Valid values are
FORD_NATURAL_ACCOUNT10007 CASH CLEARING segment
TRUE Y value.N Y Y for parentValid values a
FORD_NATURAL_ACCOUNT10200 CASH - INTERNATIONAL TRUE Y N Y value and Y, N.
N for
FORD_NATURAL_ACCOUNT10400 CASH - PETTY TRUE Y N Y child value.
FORD_NATURAL_ACCOUNT10500 CASH - INVESTMENTS TRUE Y N Y
FORD_NATURAL_ACCOUNT10700 SHORT TERM INVESTMENTS - INTEREST RECEIVABLE TRUE Y N Y
FORD_NATURAL_ACCOUNT10800 SHORT TERM INVESTMENTS - UNREALIZED GAIN/LOSS TRUE Y N Y
FORD_NATURAL_ACCOUNT10900 RESTRICTED CASH TRUE Y N Y
FORD_NATURAL_ACCOUNT11000 ACCOUNTS RECEIVABLE - TRADE TRUE Y N Y
FORD_NATURAL_ACCOUNT11100 ACCOUNTS RECEIVABLE - OTHER TRUE Y N Y
FORD_NATURAL_ACCOUNT11110 ACCOUNTS RECEIVABLES - UNAPPLIED CASH TRUE Y N Y
FORD_NATURAL_ACCOUNT11120 ACCOUNTS RECEIVABLES - UNIDENTIFIED CASH TRUE Y N Y
FORD_NATURAL_ACCOUNT11130 UNBILLED RECEIVABLE TRUE Y N Y
FORD_NATURAL_ACCOUNT11200 ALLOWANCE FOR DOUBTFUL ACCOUNTS TRUE Y N Y
FORD_NATURAL_ACCOUNT11300 CURRENT TRADE ACCOUNTS RECEIVABLE - INTERCOMPANY TRUE Y N Y
FORD_NATURAL_ACCOUNT11400 RECEIVABLES-ADJUSTMENT TRUE Y N Y
FORD_NATURAL_ACCOUNT12000 INVENTORY VALUATION TRUE Y N Y
FORD_NATURAL_ACCOUNT12100 WORK IN PROCESS TRUE Y N Y
FORD_NATURAL_ACCOUNT12200 RAW MATERIALS TRUE Y N Y
FORD_NATURAL_ACCOUNT12300 INVENTORY IN INSPECTION TRUE Y N Y
FORD_NATURAL_ACCOUNT12400 MATERIAL OVERHEAD TRUE Y N Y
FORD_NATURAL_ACCOUNT12500 WORK IN PROCESS OVERHEAD TRUE Y N Y
FORD_NATURAL_ACCOUNT12600 RAW MATERIALS OVERHEAD TRUE Y N Y
FORD_NATURAL_ACCOUNT12700 OTHER NON CURRENT ASSET TRUE Y N Y
FORD_NATURAL_ACCOUNT12800 ASSET ACCOUNT MISCELLANEOUS TRUE Y N Y
FORD_NATURAL_ACCOUNT13000 PREPAID INCOME TAXES TRUE Y N Y
FORD_NATURAL_ACCOUNT13100 INCOME TAX RECOVERABLE TRUE Y N Y
FORD_NATURAL_ACCOUNT13150 FOREIGN TAX RECOVERABLE TRUE Y N Y
FORD_NATURAL_ACCOUNT13200 PREPAID RENT TRUE Y N Y
FORD_NATURAL_ACCOUNT13300 PREPAID INSURANCE TRUE Y N Y
FORD_NATURAL_ACCOUNT13500 OTHER PREPAIDS TRUE Y N Y
FORD_NATURAL_ACCOUNT14000 OTHER CURRENT ASSETS - INTEREST RATE SWAP/HEDGING TRUE Y N Y
FORD_NATURAL_ACCOUNT14100 OTHER CURRENT ASSETS - DEFFERRED COST TRUE Y N Y
FORD_NATURAL_ACCOUNT14200 OTHER CURRENT ASSETS - DEFERRED CHARGES SHORT TERM FINANC TRUE Y N Y
FORD_NATURAL_ACCOUNT14300 OTHER CURRENT ASSETS - UNBILLED RECEIVABLES TRUE Y N Y
FORD_NATURAL_ACCOUNT14400 OTHER CURRENT ASSETS - INTEREST RECEIVABLE - INTERCOMPANY TRUE Y N Y
FORD_NATURAL_ACCOUNT14410 INTERCOMPANY CLEARING TRUE Y N Y
FORD_NATURAL_ACCOUNT14500 OTHER CURRENT ASSETS - NOTES RECEIVABLE - INTERCOMPANY TRUE Y N Y
FORD_NATURAL_ACCOUNT14600 OTHER CURRENT ASSETS - OTHER TRUE Y N Y
FORD_NATURAL_ACCOUNT14700 AUTOUNVOICE CLEARING ACCOUNT TRUE Y N Y
FORD_NATURAL_ACCOUNT14800 LEASE CLEARING ACCOUNT TRUE Y N Y
FORD_NATURAL_ACCOUNT15000 LAND TRUE Y N Y
FORD_NATURAL_ACCOUNT15100 LAND IMPROVEMENTS TRUE Y N Y
FORD_NATURAL_ACCOUNT15200 BUILDINGS TRUE Y N Y
FORD_NATURAL_ACCOUNT15300 LEASEHOLD TRUE Y N Y
FORD_NATURAL_ACCOUNT15400 LEASEHOLD IMPROVEMENTS TRUE Y N Y
FORD_NATURAL_ACCOUNT15500 EQUIPMENT TRUE Y N Y
FORD_NATURAL_ACCOUNT15600 FURNITURE AND FIXTURES TRUE Y N Y
FORD_NATURAL_ACCOUNT15700 SOFTWARE TRUE Y N Y
FORD_NATURAL_ACCOUNT15750 HARDWARE TRUE Y N Y
FORD_NATURAL_ACCOUNT15800 VEHICLES TRUE Y N Y
FORD_NATURAL_ACCOUNT15900 CONSTRUCTION IN PROGRESS TRUE Y N Y
FORD_NATURAL_ACCOUNT16000 CLR: LAND TRUE Y N Y
FORD_NATURAL_ACCOUNT16100 CLR: LAND IMPROVEMENTS TRUE Y N Y
FORD_NATURAL_ACCOUNT16200 CLR: BUILDINGS TRUE Y N Y
FORD_NATURAL_ACCOUNT16300 CLR: LEASEHOLD TRUE Y N Y
FORD_NATURAL_ACCOUNT16400 CLR: LEASEHOLD IMPROVEMENTS TRUE Y N Y
FORD_NATURAL_ACCOUNT16500 CLR: EQUIPMENT TRUE Y N Y
FORD_NATURAL_ACCOUNT16600 CLR: FURNITURE AND FIXTURES TRUE Y N Y
FORD_NATURAL_ACCOUNT16700 CLR: SOFTWARE TRUE Y N Y
FORD_NATURAL_ACCOUNT16750 CLR: HARDWARE TRUE Y N Y
FORD_NATURAL_ACCOUNT16800 CLR: VEHICLES TRUE Y N Y
FORD_NATURAL_ACCOUNT16900 CLR: CIP TRUE Y N Y
FORD_NATURAL_ACCOUNT17100 ACCUM: LAND IMPROVEMENTS TRUE Y N Y
FORD_NATURAL_ACCOUNT17200 ACCUM: BUILDINGS TRUE Y N Y
FORD_NATURAL_ACCOUNT17300 ACCUM: LEASEHOLD TRUE Y N Y
FORD_NATURAL_ACCOUNT17400 ACCUM: LEASEHOLD IMPROVEMENTS TRUE Y N Y
FORD_NATURAL_ACCOUNT17500 ACCUM: EQUIPMENT TRUE Y N Y
FORD_NATURAL_ACCOUNT17600 ACCUM: FURNITURE AND FIXTURES TRUE Y N Y
FORD_NATURAL_ACCOUNT17700 ACCUM: SOFTWARE TRUE Y N Y
FORD_NATURAL_ACCOUNT17750 ACCUM: HARDWARE TRUE Y N Y
FORD_NATURAL_ACCOUNT17800 ACCUM: VEHICLES TRUE Y N Y
FORD_NATURAL_ACCOUNT17900 INTANGIBLE ASSETS TRUE Y N Y
FORD_NATURAL_ACCOUNT17950 INTANGIBLE ASSETS AMORTIZATION TRUE Y N Y
FORD_NATURAL_ACCOUNT18000 INVESTMENTS - DEFFERRED COMPENSATION ASSET TRUE Y N Y
FORD_NATURAL_ACCOUNT18100 INVESTMENTS - SERP PLAN TRUE Y N Y
FORD_NATURAL_ACCOUNT18200 INVESTMENTS - NONCURRENT GENERAL PENSION TRUE Y N Y
FORD_NATURAL_ACCOUNT18300 INVESTMENTS - LONG TERM PENSION TRUE Y N Y
FORD_NATURAL_ACCOUNT18400 INVESTMENTS - AVAILABLE SALE TRUE Y N Y
FORD_NATURAL_ACCOUNT18500 INVESTMENTS - EQUITY METHOD AND JOINT VENTURES TRUE Y N Y
FORD_NATURAL_ACCOUNT18600 INVESTMENT - COST METHOD TRUE Y N Y
FORD_NATURAL_ACCOUNT18700 INVESTMENTS - WHOLLY OWNED SUBSIDIARIES TRUE Y N Y
FORD_NATURAL_ACCOUNT18998 PROJECT CIP ACCOUNT TRUE Y N Y
FORD_NATURAL_ACCOUNT18999 PROJECT CIP CLEARING TRUE Y N Y
FORD_NATURAL_ACCOUNT19000 OTHER NONCURRENT ASSETS - DEFERRED CHARGES FINANCING TRUE Y N Y
FORD_NATURAL_ACCOUNT19100 OTHER NONCURRENT ASSETS - SEVERANCE FUND TRUE Y N Y
FORD_NATURAL_ACCOUNT19200 OTHER NONCURRENT ASSETS - NOTES RECEIVABLE - INTERCOMPANY TRUE Y N Y
FORD_NATURAL_ACCOUNT19300 OTHER NONCURRENT ASSETS - INTEREST RECEIVABLE - INTERCOMPA TRUE Y N Y
FORD_NATURAL_ACCOUNT19400 OTHER NONCURRENT ASSETS - INTEREST RATE SWAP/HEDGING TRUE Y N Y
FORD_NATURAL_ACCOUNT19500 OTHER NONCURRENT ASSETS - LONG TERM ASSETS TRUE Y N Y
FORD_NATURAL_ACCOUNT19600 OTHER NONCURRENT ASSETS - OTHER TRUE Y N Y
FORD_NATURAL_ACCOUNT19700 OTHER NONCURRENT ASSETS - DEFERRED COST TRUE Y N Y
FORD_NATURAL_ACCOUNT19800 OTHER NONCURRENT ASSETS - DEPOSITS TRUE Y N Y
FORD_NATURAL_ACCOUNT20000 ACCOUNTS PAYABLE - TRADE TRUE Y N Y
FORD_NATURAL_ACCOUNT20300 ACCOUNTS PAYABLE - TRADE - INTERCOMPANY TRUE Y N Y
FORD_NATURAL_ACCOUNT20400 ACCRUAL INTERCOMPANY TRUE Y N Y
FORD_NATURAL_ACCOUNT20500 ACCOUNTS PAYABLE - EMPLOYEE TRUE Y N Y
FORD_NATURAL_ACCOUNT21000 ACCRUED SALARIES & WAGES TRUE Y N Y
FORD_NATURAL_ACCOUNT21100 ACCRUED VACATION TRUE Y N Y
FORD_NATURAL_ACCOUNT21200 ACCRUED BONUS TRUE Y N Y
FORD_NATURAL_ACCOUNT21300 ACCRUED PAYROLL RELATED TAXES TRUE Y N Y
FORD_NATURAL_ACCOUNT23000 OTHER CURRENT LIABILITIES TRUE Y N Y
FORD_NATURAL_ACCOUNT23100 ACCRUAL ACCOUNT INVENTORY TRUE Y N Y
FORD_NATURAL_ACCOUNT23200 EXPENSE ACCRUAL ACCOUNT TRUE Y N Y
FORD_NATURAL_ACCOUNT24000 FEDERAL INCOME TAXES PAYABLE TRUE Y N Y
FORD_NATURAL_ACCOUNT24100 STATE INCOME TAXES PAYABLE TRUE Y N Y
FORD_NATURAL_ACCOUNT24200 FOREIGN INCOME TAXES PAYABLE TRUE Y N Y
FORD_NATURAL_ACCOUNT25000 PROPERTY TAXES PAYABLE TRUE Y N Y
FORD_NATURAL_ACCOUNT26000 SALES AND USE TAXES PAYABLE TRUE Y N Y
FORD_NATURAL_ACCOUNT27000 OTHER ACCRUED TAXES PAYABLE TRUE Y N Y
FORD_NATURAL_ACCOUNT28000 LONG TERM DEBT NET OF CURRENT PORTION TRUE Y N Y
FORD_NATURAL_ACCOUNT28200 ACCRUED PENSION TRUE Y N Y
FORD_NATURAL_ACCOUNT29000 OTHER NON-CURRENT LIABILITIES TRUE Y N Y
FORD_NATURAL_ACCOUNT29100 LEASEHOLD LIABILITY TRUE Y N Y
FORD_NATURAL_ACCOUNT31000 COMMON STOCK TRUE Y N Y
FORD_NATURAL_ACCOUNT31100 CAPITAL IN EXCESS OF PAR VALUE TRUE Y N Y
FORD_NATURAL_ACCOUNT35000 DISABLED FALSE Y N Y
FORD_NATURAL_ACCOUNT35100 RETAINED EARNINGS TRUE Y N Y
FORD_NATURAL_ACCOUNT35200 MINORITY INTEREST IN RETAINED EARNINGS TRUE Y N Y
FORD_NATURAL_ACCOUNT35300 CUMULATIVE ADJUSTMENTS TRUE Y N Y
FORD_NATURAL_ACCOUNT35400 NET EARNINGS TRUE Y N Y
FORD_NATURAL_ACCOUNT35500 CUMULATIVE TRANSLATION ADJUSTMENTS TRUE Y N Y
FORD_NATURAL_ACCOUNT36000 DIVIDENDS DECLARED AND PAID TRUE Y N Y
FORD_NATURAL_ACCOUNT41000 TRADE SALES TRUE Y N Y
FORD_NATURAL_ACCOUNT41100 UNEARNED REVENUE TRUE Y N Y
FORD_NATURAL_ACCOUNT42000 Purchase Discount Taken TRUE Y N Y
FORD_NATURAL_ACCOUNT42100 INTERCOMPANY SALES TRUE Y N Y
FORD_NATURAL_ACCOUNT50000 COGS - STANDARD COSTS TRUE Y N Y
FORD_NATURAL_ACCOUNT51000 COGS - STANDARD COSTS - INTERCOMPANY TRUE Y N Y
FORD_NATURAL_ACCOUNT51020 ADVERTISING TRUE Y N Y
FORD_NATURAL_ACCOUNT51021 OFFICE SUPPLIES TRUE Y N Y
FORD_NATURAL_ACCOUNT51023 OFFICE HARDWARE AND DATA TRUE Y N Y
FORD_NATURAL_ACCOUNT52000 COGS - NON-STANDARD COSTS TRUE Y N Y
FORD_NATURAL_ACCOUNT53000 RECEIVING INSPECTION ACCOUNT TRUE Y N Y
FORD_NATURAL_ACCOUNT54000 OFFSET ACCOUNT TRUE Y N Y
FORD_NATURAL_ACCOUNT55000 SALES DISCOUNT TRUE Y N Y
FORD_NATURAL_ACCOUNT56000 PURCHASE PRICE VARIANCE TRUE Y N Y
FORD_NATURAL_ACCOUNT56100 INVOICE PRICE VARIANCE TRUE Y N Y
FORD_NATURAL_ACCOUNT56200 PO CHARGE ACCOUNT TRUE Y N Y
FORD_NATURAL_ACCOUNT57000 MATERIAL OVERHEAD TRUE Y N Y
FORD_NATURAL_ACCOUNT57100 RESOURCE ABSORPTION TRUE Y N Y
FORD_NATURAL_ACCOUNT60000 SALARY AND WAGES TRUE Y N Y
FORD_NATURAL_ACCOUNT61000 TAXABLE FRINGE BENEFITS TRUE Y N Y
FORD_NATURAL_ACCOUNT61500 PAYROLL TAXES TRUE Y N Y
FORD_NATURAL_ACCOUNT61800 OTHER FRINGES TRUE Y N Y
FORD_NATURAL_ACCOUNT62000 TRAVEL AIR FARES/ AIRPORT TAX TRUE Y N Y
FORD_NATURAL_ACCOUNT62030 AUDIT & CONSULTING TRUE Y N Y
FORD_NATURAL_ACCOUNT62500 RELOCATION TRUE Y N Y
FORD_NATURAL_ACCOUNT62600 EQUITY COMPENSATION TRUE Y N Y
FORD_NATURAL_ACCOUNT62800 REPAIRS AND MAINTENANCE TRUE Y N Y
FORD_NATURAL_ACCOUNT63000 DEPRECIATION EXPENSE - LAND IMPROVEMENTS TRUE Y N Y
FORD_NATURAL_ACCOUNT63100 DEPRECIATION EXPENSE - BUILDINGS TRUE Y N Y
FORD_NATURAL_ACCOUNT63200 DEPRECIATION EXPENSE - LEASEHOLD TRUE Y N Y
FORD_NATURAL_ACCOUNT63300 DEPRECIATION EXPENSE - LEASEHOLD IMPROVEMENTS TRUE Y N Y
FORD_NATURAL_ACCOUNT63400 DEPRECIATION EXPENSE - EQUIPMENT TRUE Y N Y
FORD_NATURAL_ACCOUNT63500 DEPRECIATION EXPENSE - FURNITURE AND FIXTURES TRUE Y N Y
FORD_NATURAL_ACCOUNT63600 DEPRECIATION EXPENSE - SOFTWARE TRUE Y N Y
FORD_NATURAL_ACCOUNT63700 DEPRECIATION EXPENSE - VEHICLES TRUE Y N Y
FORD_NATURAL_ACCOUNT63800 DEPRECIATION EXPENSE - HARDWARE TRUE Y N Y
FORD_NATURAL_ACCOUNT63999 PROJECT EXP CLEARING TRUE Y N Y
FORD_NATURAL_ACCOUNT64000 FREIGHT EXPENSE TRUE Y N Y
FORD_NATURAL_ACCOUNT64100 OUTSIDE SERVICES TRUE Y N Y
FORD_NATURAL_ACCOUNT64500 TEMPORARY HELP TRUE Y N Y
FORD_NATURAL_ACCOUNT64600 PROFESSIONAL FEES TRUE Y N Y
FORD_NATURAL_ACCOUNT64700 LEGAL FEES TRUE Y N Y
FORD_NATURAL_ACCOUNT64750 INSURANCE TRUE Y N Y
FORD_NATURAL_ACCOUNT64800 EXPENSE ACCRUAL ACCOUNT TRUE Y N Y
FORD_NATURAL_ACCOUNT64900 UTILITIES TRUE Y N Y
FORD_NATURAL_ACCOUNT64980 TELECOMMUNICATIONS TRUE Y N Y
FORD_NATURAL_ACCOUNT65000 FACILITIES TRUE Y N Y
FORD_NATURAL_ACCOUNT65100 WAREHOUSE SUPPLIES TRUE Y N Y
FORD_NATURAL_ACCOUNT65110 MEALS TRUE Y N Y
FORD_NATURAL_ACCOUNT65120 MISCELLANEOUS EXPENSES TRUE Y N Y
FORD_NATURAL_ACCOUNT65125 MILEAGE TRUE Y N Y
FORD_NATURAL_ACCOUNT65130 TAXI GROUND TRANSPORT TOLLS TRUE Y N Y
FORD_NATURAL_ACCOUNT65135 VEHICLE RENTAL TRUE Y N Y
FORD_NATURAL_ACCOUNT65140 ACCOMODATION TRUE Y N Y
FORD_NATURAL_ACCOUNT65150 ENTERTAINMENT TRUE Y N Y
FORD_NATURAL_ACCOUNT65200 COMMUNICATIONS POSTAGE, CALLS,PHOTOCOPY & PRINTING TRUE Y N Y
FORD_NATURAL_ACCOUNT65300 LEASED EQUIPMENT TRUE Y N Y
FORD_NATURAL_ACCOUNT65400 WARRANTY EXPENSE TRUE Y N Y
FORD_NATURAL_ACCOUNT65500 MARKETING EXPENSE TRUE Y N Y
FORD_NATURAL_ACCOUNT65600 PUBLIC RELATIONS TRUE Y N Y
FORD_NATURAL_ACCOUNT65700 DUES AND SUBSCRIPTIONS TRUE Y N Y
FORD_NATURAL_ACCOUNT65750 EDUCATION AND TRAINING TRUE Y N Y
FORD_NATURAL_ACCOUNT65800 BAD DEBT EXPENSE TRUE Y N Y
FORD_NATURAL_ACCOUNT66000 TAXES TRUE Y N Y
FORD_NATURAL_ACCOUNT66500 ALLOCATIONS TRUE Y N Y
FORD_NATURAL_ACCOUNT67000 OTHER OPERATING EXPENSE TRUE Y N Y
FORD_NATURAL_ACCOUNT67010 OPERATING LEASE EXPENSE TRUE Y N Y
FORD_NATURAL_ACCOUNT68000 RESEARCH AND DEVELOPMENT EXPENSES TRUE Y N Y
FORD_NATURAL_ACCOUNT69000 AMORTIZATION OF INTANGIBLE ASSETS TRUE Y N Y
FORD_NATURAL_ACCOUNT70010 OTHER - FINANCE CHARGES - AMORTIZATION TRUE Y N Y
FORD_NATURAL_ACCOUNT70020 OTHER DEBT DISCOUNT AMORTIZATION TRUE Y N Y
FORD_NATURAL_ACCOUNT70030 OTHER - INTEREST EXPENSE TRUE Y N Y
FORD_NATURAL_ACCOUNT70040 OTHER - INTEREST EXPENSE/CONVERTIBLE DEBT TRUE Y N Y
FORD_NATURAL_ACCOUNT70050 OTHER - INTEREST EXPENSE - INTERCOMPANY TRUE Y N Y
FORD_NATURAL_ACCOUNT70060 OTHER - PENALTIES TRUE Y N Y
FORD_NATURAL_ACCOUNT70070 INTEREST EXPENSE ON LEASE TRUE Y N Y
FORD_NATURAL_ACCOUNT71000 GAIN/LOSS ON INVESTMENT TRUE Y N Y
FORD_NATURAL_ACCOUNT71100 EQUITY INCOME FROM AFFILIATES TRUE Y N Y
FORD_NATURAL_ACCOUNT72000 REALIZED TRANSLATION GAIN/LOSS TRUE Y N Y
FORD_NATURAL_ACCOUNT72100 UNREALIZED TRANSLATION GAIN/LOSS TRUE Y N Y
FORD_NATURAL_ACCOUNT73000 DEFERRED RMA GAIN/LOSS TRUE Y N Y
FORD_NATURAL_ACCOUNT73100 RMA GAIN/LOSS TRUE Y N Y
FORD_NATURAL_ACCOUNT75000 INTEREST INCOME TRUE Y N Y
FORD_NATURAL_ACCOUNT75500 INTEREST INCOME - INTERCOMPANY TRUE Y N Y
FORD_NATURAL_ACCOUNT76000 FAIR VALUE MARK TO MARKET ADJUSTMENT TRUE Y N Y
FORD_NATURAL_ACCOUNT76100 OTHER INCOME TRUE Y N Y
FORD_NATURAL_ACCOUNT76200 OTHER INCOME - INTERCOMPANY TRUE Y N Y
FORD_NATURAL_ACCOUNT76300 ROYALTY INCOME TRUE Y N Y
FORD_NATURAL_ACCOUNT76400 ROYALTY EXPENSE TRUE Y N Y
FORD_NATURAL_ACCOUNT76500 BANK CHARGES TRUE Y N Y
FORD_NATURAL_ACCOUNT76600 LOSS/GAIN ON FIXED ASSETS TRUE Y N Y
FORD_NATURAL_ACCOUNT76610 CLR: LOSS/GAIN ON FIXED ASSETS TRUE Y N Y
FORD_NATURAL_ACCOUNT76700 MISCELLANEOUS VARIANCE TRUE Y N Y
FORD_NATURAL_ACCOUNT76710 VALUATION UNIT TRANSFER VARIANCE TRUE Y N Y
FORD_NATURAL_ACCOUNT80000 FEDERAL INCOME TAX EXPENSE TRUE Y N Y
FORD_NATURAL_ACCOUNT81000 STATE INCOME TAX EXPENSE TRUE Y N Y
FORD_NATURAL_ACCOUNT82000 FOREIGN INCOME TAX EXPENSE TRUE Y N Y
FORD_NATURAL_ACCOUNT83000 FOREIGN INCOME TAX WITHHOLDING TRUE Y N Y
FORD_NATURAL_ACCOUNT90000 Net Earnings (Elimination Account) TRUE Y N Y
FORD_NATURAL_ACCOUNT91000 Net Earnings Minority Interest (Elimination Account) TRUE Y N Y
FORD_NATURAL_ACCOUNTACOMP TOTAL ACCRUED COMPENSATION BENEFITS AND RELATED TAXES TRUE Y Y N
FORD_NATURAL_ACCOUNTAMORT AMORTIZATION OF INTANGIBLE ASSETS TRUE Y Y N
FORD_NATURAL_ACCOUNTCASHA TOTAL CASH & CASH EQUIVALENTS TRUE Y Y N
FORD_NATURAL_ACCOUNTCURAS TOTAL CURRENT ASSETS TRUE Y Y N
FORD_NATURAL_ACCOUNTCURLB TOTAL CURRENT LIABILITIES TRUE Y Y N
FORD_NATURAL_ACCOUNTCURRC TOTAL CURRENT RECEIVABLES TRUE Y Y N
FORD_NATURAL_ACCOUNTELIMN ELIMINATION ACCOUNTS TRUE Y Y N
FORD_NATURAL_ACCOUNTGRMAR GROSS MARGIN TRUE Y Y N
FORD_NATURAL_ACCOUNTINCBT NET INCOME/LOSS BEFORE INCOME TAXES TRUE Y Y N
FORD_NATURAL_ACCOUNTINCTX INCOME TAX EXPENSE TRUE Y Y N
FORD_NATURAL_ACCOUNTINEXO OTHER EXPENSE AND INCOME TRUE Y Y N
FORD_NATURAL_ACCOUNTINTAN INTANGIBLE ASSETS NET TRUE Y Y N
FORD_NATURAL_ACCOUNTINTEX TOTAL INTEREST EXPENSE TRUE Y Y N
FORD_NATURAL_ACCOUNTINTIN TOTAL INTEREST INCOME TRUE Y Y N
FORD_NATURAL_ACCOUNTINVEQ TOTAL INVESTOR'S EQUITY TRUE Y Y N
FORD_NATURAL_ACCOUNTINVGR INVENTORY - GROSS TRUE Y Y N
FORD_NATURAL_ACCOUNTINVNT INVENTORY - NET TRUE Y Y N
FORD_NATURAL_ACCOUNTINVRE INVENTORY RESERVES TRUE Y Y N
FORD_NATURAL_ACCOUNTINVST TOTAL INVESTMENTS TRUE Y Y N
FORD_NATURAL_ACCOUNTLGFXC TOTAL LOSS/GAIN ON FOREIGN CURRENCY TRUE Y Y N
FORD_NATURAL_ACCOUNTLGINV TOTAL LOSS/GAIN ON INVESTMENTS TRUE Y Y N
FORD_NATURAL_ACCOUNTNCRAS TOTAL NON-CURRENT ASSETS TRUE Y Y N
FORD_NATURAL_ACCOUNTNCRLB TOTAL NON-CURRENT LIABILITIES TRUE Y Y N
FORD_NATURAL_ACCOUNTNETSL NET SALES TRUE Y Y N
FORD_NATURAL_ACCOUNTNTPFT Net Profit TRUE Y Y N
FORD_NATURAL_ACCOUNTNTINC NET INCOME/LOSS TRUE Y Y N
FORD_NATURAL_ACCOUNTOEXIN OTHER EXPENSE/INCOME NET TRUE Y Y N
FORD_NATURAL_ACCOUNTONCAO TOTAL OTHER NONCURRENT ASSETS - OTHER TRUE Y Y N
FORD_NATURAL_ACCOUNTOPEXP TOTAL OPERATING EXPENSES TRUE Y Y N
FORD_NATURAL_ACCOUNTOPINC OPERATING INCOME TRUE Y Y N
FORD_NATURAL_ACCOUNTOTHCA TOTAL OTHER CURRENT ASSETS TRUE Y Y N
FORD_NATURAL_ACCOUNTPPEAC PROPERTY PLANT AND EQUIPMENT ACCUMMULATED DEPRECIATION TRUE Y Y N
FORD_NATURAL_ACCOUNTPPECL PROPERTY PLANT AND EQUIPMENT CLEARING TRUE Y Y N
FORD_NATURAL_ACCOUNTPPEGR PROPERTY PLANT AND EQUIPMENT GROSS TRUE Y Y N
FORD_NATURAL_ACCOUNTPPENT PROPERTY PLANT AND EQUIPMENT NET TRUE Y Y N
FORD_NATURAL_ACCOUNTPREIT TOTAL PREPAID INCOME TAXES TRUE Y Y N
FORD_NATURAL_ACCOUNTPREPD TOTAL PREPAIDS TRUE Y Y N
FORD_NATURAL_ACCOUNTRANDD RESEARCH AND DEVELOPMENT EXPENSES TRUE Y Y N
FORD_NATURAL_ACCOUNTRTERN TOTAL RETAINED EARNINGS TRUE Y Y N
FORD_NATURAL_ACCOUNTSGAEX TOTAL SELLING GENERAL AND ADMINISTRATIVE EXPENSES TRUE Y Y N
FORD_NATURAL_ACCOUNTSTINV TOTAL SHORT TERM INVESTMENTS TRUE Y Y N
FORD_NATURAL_ACCOUNTTAXPY TOTAL TAXES PAYABLE TRUE Y Y N
FORD_NATURAL_ACCOUNTTCOGS TOTAL COST OF SALES TRUE Y Y N
FORD_NATURAL_ACCOUNTTOEXP TOTAL EXPENSES TRUE Y Y N
FORD_NATURAL_ACCOUNTTOCLB TOTAL OTHER CURRENT LIABILITIES TRUE Y Y N
FORD_NATURAL_ACCOUNTTOTAS TOTAL ASSETS TRUE Y Y N
FORD_NATURAL_ACCOUNTTOTEQ TOTAL EQUITY TRUE Y Y N
FORD_NATURAL_ACCOUNTTOTLB TOTAL LIABILITIES TRUE Y Y N
FORD_NATURAL_ACCOUNTTOTTP TOTAL TRADE PAYABLES TRUE Y Y N
FORD_NATURAL_ACCOUNTTOREV TOTAL REVENUE TRUE Y Y N
Screenshots
 Y0 gU ======
12:59:01) nQ E (2019-08-12 (2019-08-12 ======
ALLOW_POSTI THIRD_PARTY_ID#AAAADVT7v ====== ====== ======
SUMMARY_FLA ALLOW_BUDGE 12:59:01) 12:59:01) ID#AAAADVT7v====== ======
NG_FLAG CTRL_ACCOUN Uk ID#AAAADVT7vID#AAAADVT7v ID#AAAADVT7v
G TING_FLAG Enter the natural Enter a financialVY ID#AAAADVT7vID#AAAADVT7v
(2019-08-12 T (2019-08-12
RECONCILE_FL hs eY ZU
NOT NULL (2019-08-12 account type if category value DESCRIPTION_ U8 V4
12:59:01) 12:59:01) AG (2019-08- DESCRIPTION_DESCRIPTION_ DESCRIPTION_
VARCHAR2(1) 12:59:01) the segment for Oracle US (2019-08-DESCRIPTION_DESCRIPTION_
*AllowVARCHAR2(1)
A Enter Y if Thirdvalue Enter the
PartyisReconcile third
12 12:59:01)
Financial Category Description US Description Description Description D (2019-08-12
Description DK DK (2019-08-
Description E (2019-08-12
for the Fusion 12 12:59:01)AR (2019-08-CS (2019-08-
Budgeting Control Flag party control
Do not enter a AR CS D 12:59:01) E 12 12:59:01) 12:59:01)
Enter Y or N to budgeting is natural account Transactional Segment value 12 12:59:01)12 12:59:01)
Flag Enter Y to Account account value.
value in this Segment value Segment valueSegment value
indicate if the allowed for this segment. Valid Business description Segment
in value
Segment value
allowed posting Valid valuescolumn.
are: This description in description description
in in
segment value is segment value values are: A for Intelligence American description description
in in
for this segment CUSTOMER, feature is not German Danish Spanish
a parent
Y value or Asset
and N if N Assets,NL forSUPPLIER,supported reporting. Valid English Arabic language.
Czech language.
value and N to R in this language. language. language.
a child value. budgeting is notLiabilities, E for values are language.
Y disallow posting.
Asset N N for Restrictrelease.
Valid values are allowed. Valid Expenses, O for values defined in
Y Valid values
Y for parent
are
Assetvalues N [Link]’sN Manual Journals,
are Y, the
Y Y,
value and
N.
N for Asset N Equities, N andY, N.
R FINANCIAL_CA
Y
child value. Asset N for Revenues.
N TEGORY lookup
Y Asset N N type.
Y Asset N N
Y Asset N N
Y Asset N N
Y Asset N N
Y Asset N N
Y Asset N N
Y Asset N N
Y Asset N N
Y Asset N N
Y Asset N N
Y Asset N N
Y Asset N N
Y Asset N N
Y Asset N N
Y Asset N N
Y Asset N N
Y Asset N N
Y Asset N N
Y Asset N N
Y Asset N N
Y Asset N N
Y Asset N N
Y Asset N N
Y Asset N N
Y Asset N N
Y Asset N N
Y Asset N N
Y Asset N N
Y Asset N N
Y Asset N N
Y Asset N N
Y Asset N N
Y Asset N N
Y Asset N N
Y Asset N N
Y Asset N N
Y Asset N N
Y Asset N N
Y Asset N N
Y Asset N N
Y Asset N N
Y Asset N N
Y Asset N N
Y Asset N N
Y Asset N N
Y Asset N N
Y Asset N N
Y Asset N N
Y Asset N N
Y Asset N N
Y Asset N N
Y Asset N N
Y Asset N N
Y Asset N N
Y Asset N N
Y Asset N N
Y Asset N N
Y Asset N N
Y Asset N N
Y Asset N N
Y Asset N N
Y Asset N N
Y Asset N N
Y Asset N N
Y Asset N N
Y Asset N N
Y Asset N N
Y Asset N N
Y Asset N N
Y Asset N N
Y Asset N N
Y Asset N N
Y Asset N N
Y Asset N N
Y Asset N N
Y Asset N N
Y Asset N N
Y Asset N N
Y Asset N N
Y Asset N N
Y Asset N N
Y Asset N N
Y Asset N N
Y Asset N N
Y Asset N N
Y Asset N N
Y Asset N N
Y Asset N N
Y Liability N N
Y Liability N N
Y Liability N N
Y Liability N N
Y Liability N N
Y Liability N N
Y Liability N N
Y Liability N N
Y Liability N N
Y Liability N N
Y Liability N N
Y Liability N N
Y Liability N N
Y Liability N N
Y Liability N N
Y Liability N N
Y Liability N N
Y Liability N N
Y Liability N N
Y Liability N N
Y Liability N N
Y Owner's Equity N N
Y Owner's Equity N N
Y Owner's Equity N N
Y Owner's Equity N N
Y Owner's Equity N N
Y Owner's Equity N N
Y Owner's Equity N N
Y Owner's Equity N N
Y Owner's Equity N N
Y Revenue N N
Y Revenue N N
Y Revenue N N
Y Revenue N N
Y Expense N N
Y Expense N N
Y Expense N N
Y Expense N N
Y Expense N N
Y Expense N N
Y Expense N N
Y Expense N N
Y Expense N N
Y Expense N N
Y Expense N N
Y Expense N N
Y Expense N N
Y Expense N N
Y Expense N N
Y Expense N N
Y Expense N N
Y Expense N N
Y Expense N N
Y Expense N N
Y Expense N N
Y Expense N N
Y Expense N N
Y Expense N N
Y Expense N N
Y Expense N N
Y Expense N N
Y Expense N N
Y Expense N N
Y Expense N N
Y Expense N N
Y Expense N N
Y Expense N N
Y Expense N N
Y Expense N N
Y Expense N N
Y Expense N N
Y Expense N N
Y Expense N N
Y Expense N N
Y Expense N N
Y Expense N N
Y Expense N N
Y Expense N N
Y Expense N N
Y Expense N N
Y Expense N N
Y Expense N N
Y Expense N N
Y Expense N N
Y Expense N N
Y Expense N N
Y Expense N N
Y Expense N N
Y Expense N N
Y Expense N N
Y Expense N N
Y Expense N N
Y Expense N N
Y Expense N N
Y Expense N N
Y Expense N N
Y Expense N N
Y Expense N N
Y Expense N N
Y Expense N N
Y Expense N N
Y Expense N N
Y Expense N N
Y Expense N N
Y Expense N N
Y Expense N N
Y Expense N N
Y Expense N N
Y Expense N N
Y Expense N N
Y Expense N N
Y Expense N N
Y Expense N N
Y Expense N N
Y Expense N N
Y Expense N N
Y Expense N N
Y Expense N N
Y Expense N N
Y Expense N N
Y Expense N N
Y Expense N N
Y Expense N N
Y Expense N N
Y Expense N N
Y Expense N N
Y Expense N N
Y Expense N N
Y Revenue N N
Y Liability N N
N Liability N N
N Expense N N
N Asset N N
N Asset N N
N Liability N N
N Asset N N
N Liability N N
N Revenue N N
N Revenue N N
N Expense N N
N Expense N N
N Asset N N
N Expense N N
N Revenue N N
N Expense N N
N Asset N N
N Asset N N
N Asset N N
N Asset N N
N Expense N N
N Expense N N
N Asset N N
N Liability N N
N Revenue N N
N Revenue N N
N Revenue N N
N Expense N N
N Asset N N
N Expense N N
N Revenue N N
N Asset N N
N Asset N N
N Asset N N
N Asset N N
N Asset N N
N Asset N N
N Asset N N
N Expense N N
N Expense N N
N Expense N N
N Asset N N
N Liability N N
N Expense N N
N Expense N N
N Liability N N
N Asset N N
N Expense N N
N Liability N N
N Liability N N
N Revenue N N
 ID#AAAADVT7v sID#AAAADVT7v ID#AAAADVT7vf Accumulated
ID#AAAADVT7v ID#AAAADVT7vID#AAAADVT7vID#AAAADVT7v ID#AAAADVT
====== eo Shabbeer Syed ID#AAAADVT7v Depreciation ID#AAAADVT7v
====== ====== ak aE g eE Z0 VI a0 mo
====== ID#AAAADVT7v (2019-08-12 (2019-08-12 mA Cash cM
ID#AAAADVT7vID#AAAADVT7v (2019-08-12 (2019-08-12(2019-08-12 (2019-08-12(2019-08-12(2019-08-12(2019-08-12 (2019-08-1
ID#AAAADVT7vX0 12:59:01) 12:59:01) (2019-08-12Common Stock (2019-08-12
eY ZU 12:59:01) 12:59:01) 12:59:01) 12:59:01) 12:59:01) 12:59:01) 12:59:01) 12:59:01)
d4 DESCRIPTION_ DESCRIPTION_ Mandatory: 12:59:01) Contracting 12:59:01)
DESCRIPTION_DESCRIPTION_ DESCRIPTION_ DESCRIPTION_ DESCRIPTION_ DESCRIPTION_ DESCRIPTION_DESCRIPTION_DESCRIPTION_ DESCRIPTIO
DESCRIPTION_ESA (2019-08- FRC -------------- DESCRIPTION_ Expenses DESCRIPTION_
DK (2019-08-E (2019-08-12
Description Description Description F
Description Description HR
Description HU
Description Description IS IS
Description IW
Description JA
Description KO
Description Description LT
EL (2019-08-12 12:59:01) VARCHAR2(240 Asset I I Cost ofJA Goods NL
12 12:59:01)
EL 12:59:01)ESA 12 12:59:01)
F Segment VARCHAR2(240
FRCvalue HR ) HU VARCHAR2(240 VARCHAR2(240 IW VARCHAR2(240 VARCHAR2(240
KO VARCHAR2(240
NL VARCHAR2(240
LT VARCHAR2(
Budgetary Credit VARCHAR2(240 Sold VARCHAR2(240
Segment value
Segment value ) ) ) ) ) ) ) )
Segment value
description in Budgerary Debit ) Depreciation )
description description
in in
description Latin
in American Segment valueExpense Expenses
Danish Spanish Segment value Segment value Segment value Segment valueSegment value
Segment value
Segment value Segment valu
Greek language.
Spanish description Liability
in Segment valueEmployee Segment value
language. language. description in description description
in in description description
in description
in description
in in description in
language. Canadian Owners Equity description in Benefit Related description in
French Croatian Hungarian Icelandic Hebrew Japanese Korean Lithuanian
French Revenue language. Italian language. expenses language. language. language. Dutch language.
language. language. language. language.
language. Statistical Asset General
Statistical Administrative
Expense and Payroll
Expense
Income Tax
Intrest Expenses
Other Assets
Other Current
Assets
Other Current
Liabilities
Tax Liability
Travel and
Entertainment
Expenses
 AADVT7v ID#AAAADVT7v ID#AAAADVT7v ID#AAAADVT7vID#AAAADVT7vID#AAAADVT7vID#AAAADVT7vID#AAAADVT7vID#AAAADVT7vID#AAAADVT7v ID#AAAADVT7v
ID#AAAADVT7v ID#AAAADVT7v U0 ID#AAAADVT7vi UE
mo ds cg ko ZY cE Xk oY V8 kE
cM eI (2019-08-12 A (2019-08-12
19-08-12 (2019-08-12 (2019-08-12 (2019-08-12(2019-08-12(2019-08-12(2019-08-12(2019-08-12(2019-08-12(2019-08-12 (2019-08-12
(2019-08-12 (2019-08-12 12:59:01) (2019-08-12 12:59:01)
01) 12:59:01) 12:59:01) 12:59:01) 12:59:01) 12:59:01) 12:59:01) 12:59:01) 12:59:01) 12:59:01) 12:59:01)
12:59:01) 12:59:01) DESCRIPTION_ 12:59:01) DESCRIPTION_
RIPTION_ DESCRIPTION_ DESCRIPTION_ DESCRIPTION_DESCRIPTION_DESCRIPTION_DESCRIPTION_DESCRIPTION_DESCRIPTION_DESCRIPTION_ DESCRIPTION_
DESCRIPTION_ DESCRIPTION_ PTB DESCRIPTION_ ZHS
LT
Description Description PT
Description Description N
Description RO
Description RU
Description S
Description SF
Description SK
Description SL
Description Description TR
Description
NL PL VARCHAR2(240 TH VARCHAR2(240
HAR2(240 PL VARCHAR2(240 PTB VARCHAR2(240 RO VARCHAR2(240
RU VARCHAR2(240
S VARCHAR2(240
SF VARCHAR2(240
SK VARCHAR2(240
SL VARCHAR2(240
TH VARCHAR2(240 ZHS VARCHAR2(240
VARCHAR2(240 PT VARCHAR2(240 N ) TR VARCHAR2(240 )
) ) ) ) ) ) ) ) ) )
) ) )
Segment value Segment value
ent value Segment value Segment value Segment value
Segment value
Segment value
Segment value
Segment value
Segment value
Segment value Segment value
Segment value Segment value description in Segment value description in
ption in description in description in description description
in description
in description
in description
in description
in description
in in description in
description in description in Brazilian description in Simplified
n Lithuanian Portuguese Norwegian Romanian Russian Swedish Finnish Slovak Slovenian Turkish
Dutch language. Polish language. Portuguese Thai language. Chinese
age. language. language. language. language. language. language. language. language. language. language.
language. language.
 ID#AAAADVT7v ======
AADVT7vi UE kU
kE ID#AAAADVT7vi
(2019-08-12(2019-08-12
(2019-08-12 w
19-08-12 12:59:01) 12:59:01)
12:59:01) Dipesh Gupta
01) DESCRIPTION_DESCRIPTION_
DESCRIPTION_ (2019-08-12
RIPTION_ ZHS ZHT
TR Description IS 12:59:01)
VARCHAR2(240VARCHAR2(240
VARCHAR2(240
ZHT VALIDATE Please do not
HAR2(240 ) )
) D put any value or
edit this column.
Segment value
Segment value
Segment value This column is
ent value description description
in in
description in for validation
ption in Simplified Traditional
Turkish purposes.
anguage. Chinese Chinese
language.
language. language.
 ID#AAAADVT7v====== (2019-08-12 Q
ID#AAAADVT7v ====== 12:59:01) Yw
Ww ID#AAAADVT7v12:59:01) ALLOW_POSTI
dU ID#AAAADVT7v SUMMARY_FLA ALLOW_BUDGE
(2019-08-12 XQ ENABLED_FLA NG_FLAG
VALUE_SET_C e0 G TING_FLAG
12:59:01) END_DATE_ACG (2019-08-12
ODE (2019-08- VALUE (2019- NOT NULL (2019-08-12
START_DATE_A TIVE (2019- NOT NULL 12:59:01)
12 12:59:01) 08-12 12:59:01) VARCHAR2(1) 12:59:01)
*Value Set Code ValueNOT NULL StartNOT CTIVE
DateNULL End Date 08-12Flag
*Enabled 12:59:01) VARCHAR2(1
*Summary F*Allow Posti*AllowVARCHAR2(1)
Budge Enter Y if
101 VARCHAR2(6001/01/15 DATE Y FORMAT: N CHAR)Y Enter YYor N to
FORD_INTER_COMPANY VARCHAR2(25 budgeting is
FORMAT: YYYY/MM/DD Enter Y to
FORD_INTER_COMPANY 201 CHAR) 01/01/15 CHAR) Y N Y indicateY if the allowed for this
YYYY/MM/DD Enter Y to allowed posting
segment value is segment value
Enter the end enable the for this segment
Enter the valueEnter the a parent value or and N if
Enter the start date of the segment value value and N to
set code for the
segment value. a child value. budgeting is not
date of the segment value. and N to disable disallow posting.
segment values. Valid values are allowed. Valid
segment value. the segment Valid values are
Y for parent values are Y, N.
value. Y or N are Y, N.
value and N for
valid values.
child value.
Screenshots
 Q
01) Yw ====== ======
ALLOW_POSTI ====== ====== ======
ARY_FLA ALLOW_BUDGE ID#AAAADVT7v====== ====== ====== ID#AAAADVT7v
NG_FLAG ID#AAAADVT7vID#AAAADVT7vID#AAAADVT7v
TING_FLAG o8 ID#AAAADVT7vID#AAAADVT7v ID#AAAADVT7vWY
(2019-08-12 dI Vs Y8
ULL (2019-08-12 DESCRIPTION_po bQ oE DESCRIPTION_
12:59:01) DESCRIPTION_DESCRIPTION_DESCRIPTION_
HAR2(1) 12:59:01) US (2019-08-DESCRIPTION_DESCRIPTION_ DESCRIPTION_ESA (2019-08-
VARCHAR2(1)
Description D (2019-08-12
DK (2019-08-E (2019-08-12
Enter YUS if Description Description
12 12:59:01) Description
AR (2019-08- DescriptionDescription
CS (2019-08- Description Description
EL (2019-08-12 12:59:01)
12:59:01) 12 12:59:01) 12:59:01)
Y or N to Ford budgeting
Motor Companyis Segment value
12 12:59:01)12 12:59:01) 12 12:59:01)Segment value
Enter Y to Segment value
Segment value
Segment value
e if the Fordallowed
Of Britainfor this description Segment
in value
Segment value Segment value
description in
allowed posting description description
in description
in in
nt value is segment value American description description
in in description Latin
in American
for this segment German Danish Spanish
nt value or and N if English Arabic language.
Czech language. Greek language.
Spanish
value and N to language. language. language.
value. budgeting is not language. language.
disallow posting.
alues are allowed. Valid
Valid values are
arent values are Y, N.
Y, N.
and N for
alue.
 ID#AAAADVT7vl ID#AAAADVT7vID#AAAADVT7v ID#AAAADVT7vID#AAAADVT7vID#AAAADVT7vID#AAAADVT7v ID#AAAADVT7v ID#AAAADVT
====== c8 ID#AAAADVT7v ID#AAAADVT7v ID#AAAADVT7v
= Y hw hI pI mU kA o0 ag pg
====== ID#AAAADVT7v (2019-08-12 XU o4 ck
AADVT7v (2019-08-12 (2019-08-12(2019-08-12 (2019-08-12(2019-08-12(2019-08-12(2019-08-12 (2019-08-12 (2019-08-12
ID#AAAADVT7vWY 12:59:01) (2019-08-12 (2019-08-12 (2019-08-12
12:59:01) 12:59:01) 12:59:01) 12:59:01) 12:59:01) 12:59:01) 12:59:01) 12:59:01) 12:59:01)
oE DESCRIPTION_ DESCRIPTION_ 12:59:01) 12:59:01) 12:59:01)
RIPTION_ DESCRIPTION_ DESCRIPTION_DESCRIPTION_ DESCRIPTION_DESCRIPTION_DESCRIPTION_DESCRIPTION_ DESCRIPTION_ DESCRIPTION
DESCRIPTION_ESA (2019-08- FRC DESCRIPTION_ DESCRIPTION_ DESCRIPTION_
019-08-12 Description Description
F Description HR
Description HU
Description I
D escription IS
Description IW
Description JA
Description KO
Description Description LT
Description Description PT
EL (2019-08-12 12:59:01) VARCHAR2(240 I NL PL
01) VARCHAR2(240 VARCHAR2(240VARCHAR2(240 VARCHAR2(240VARCHAR2(240VARCHAR2(240VARCHAR2(240 VARCHAR2(240 VARCHAR2(2
12 12:59:01)Segment value ) VARCHAR2(240 VARCHAR2(240 VARCHAR2(240
ent value ) ) ) ) ) ) ) ) )
Segment value
description in ) ) )
ption in
description Latin
in American Segment value
h Segment value Segment value
Segment value Segment value
Segment value
Segment value
Segment value Segment value Segment value
Greek language.
Spanish description in Segment value Segment value Segment value
ge. description in description description
in in description description
in description
in description
in in description in description in
language. Canadian description in description in description in
French Croatian Hungarian Icelandic Hebrew Japanese Korean Lithuanian Portuguese
French Italian language. Dutch language. Polish language.
language. language. language. language. language. language. language. language. language.
language.
AADVT7v ID#AAAADVT7v ID#AAAADVT7vID#AAAADVT7vID#AAAADVT7vID#AAAADVT7vID#AAAADVT7vID#AAAADVT7vID#AAAADVT7vj ID#AAAADVT7v ======
ID#AAAADVT7v A ID#AAAADVT7v 0 kI
pg Yg aw no YU VE do k Zs ID#AAAADVT
ck (2019-08-12 bU (2019-08-12(2019-08-12
9-08-12 (2019-08-12 (2019-08-12(2019-08-12(2019-08-12(2019-08-12(2019-08-12(2019-08-12(2019-08-12 (2019-08-12 dw
(2019-08-12 12:59:01) (2019-08-12 12:59:01) 12:59:01)
01) 12:59:01) 12:59:01) 12:59:01) 12:59:01) 12:59:01) 12:59:01) 12:59:01) 12:59:01) 12:59:01) Dipesh Gupta
12:59:01) DESCRIPTION_ 12:59:01) DESCRIPTION_ DESCRIPTION_
RIPTION_ DESCRIPTION_ DESCRIPTION_DESCRIPTION_DESCRIPTION_DESCRIPTION_DESCRIPTION_DESCRIPTION_DESCRIPTION_ DESCRIPTION_ (2019-08-12
DESCRIPTION_ PTB DESCRIPTION_ ZHS ZHT
PT
Description Description N
Description RO
Description RU
Description S
Description SF
Description SK
Description SL
Description Description TR
Description Description IS VALIDATED 12:59:01)
PL VARCHAR2(240 TH VARCHAR2(240 VARCHAR2(240
HAR2(240 VARCHAR2(240 VARCHAR2(240VARCHAR2(240VARCHAR2(240VARCHAR2(240VARCHAR2(240VARCHAR2(240VARCHAR2(240 VARCHAR2(240 Please do not
VARCHAR2(240 ) VARCHAR2(240 ) )
) ) ) ) ) ) ) ) ) put any value
) )
edit this colum
Segment value Segment valueSegment value
ent value Segment value Segment value
Segment value
Segment value
Segment value
Segment value
Segment value
Segment value Segment value This column is
Segment value description in Segment value description description
in in
ption in description in description description
in description
in description
in description
in description
in description
in in description in for validation
description in Brazilian description in Simplified Traditional
nian Portuguese Norwegian Romanian Russian Swedish Finnish Slovak Slovenian Turkish purposes.
Polish language. Portuguese Thai language. Chinese Chinese
ge. language. language. language. language. language. language. language. language. language.
language. language. language.
 ======
kI
ID#AAAADVT7v
9-08-12(2019-08-12
dw
01) 12:59:01)
Dipesh Gupta
RIPTION_
DESCRIPTION_
(2019-08-12
ZHT
IS VALIDATED 12:59:01)
HAR2(240
VARCHAR2(240
Please do not
)
put any value or
edit this column.
ent value
Segment value
This column is
ption description
in in
for validation
ied Traditional
purposes.
e Chinese
ge. language.
*Value Set Code Value Start Date End Date *Enabled Flag *Summary F*Allow Posti*Allow Budge
FORD_FUTURE 0000 01/01/15 Y N Y Y
Screenshots
Description US Description Description Description DescriptionDescription Description Description
Default
Description Description Description Description Description IDescription Description Description Description Description Description Description Description
Description Description Description Description Description Description Description Description Description Description Description Description IS VALIDATED
IS VALIDATED
Back to Overview
Manage Account Hierarchies
Navigation: Financials > Define Common Applications Configuration

See Account Hierarchy Segment Values tab

Under the “Actions” tab, click on the “CreateTree” icon to open the definition of the tree.

Specify Name, Description and Data Source Parameters for Tree Structure and click Submit
On the “Manage Account Hierarchies” page find the tree. Click on the Tree Structure and Click on the “Create Tree Version” list item
Enter the Name, Description and Effective Start Date for the tree version

Add the Parent and Child values to establish a tree version

Highlight your tree version and Click on the “Actions menu> Audit”.

Click the “Online Audit” button to start the audit process.

Click the “Actions menu > Flatten menu >Column flattening”. Column flattening optimizes parent child information for run-time performance by sto
Click the Actions menu > Flatten menu > Row Flattening. Row flattening optimizes parent-child information for run-time performance by storing additional

Use the Actions menu > Set Status menu > Active to activate the tree
un-time performance by storing an additional column in a table for all parents of a child.
mance by storing additional rows in a table
 ID#AAAADVT7v
====== hQ ====== ======
====== ID#AAAADVT7v TREE_VERSIO ID#AAAADVT7vl ID#AAAADVT7v
====== ======
ID#AAAADVT7v bI N_NAME I Z4
ID#AAAADVT7vl
ID#AAAADVT7vf
ID#AAAADVT7v ID#AAAADVT7vi
======
WE (2019-08-12 (2019-08-12 (2019-08-12 (2019-08-12 ======
8
Q
Uo U ID#AAAADVT7v
Back to Overview VALUE_SET_C 12:59:01) 12:59:01) 12:59:01) 12:59:01) ID#AAA
PARENT5 PARENT2 YE
PARENT4
PARENT3
Segment Value Hierarchies ODE (2019-08-
TREE_CODE VARCHAR2(80) TREE_VERSIO TREE_VERSIO Vg
Navigation: Financials > Define Common Applications Configuration for Financials > Define Enterprise Structures for (2019-08-12(2019-08-12PARENT1
12 12:59:01)
Financials > Define Financial Reporting Structures NOT
> Define NULL
Chart N_START_DATEN_END_DATE_
of Accounts > Manage Account Hierarchies VALUE
12:59:01) 12:59:01) (2019-08-12
VARCHAR2(60) VARCHAR2(30 Enter the tree _ACTIVE ACTIVE 08-12 1
Enter the third
fifth
fourth
Enter the second
12:59:01)
CHAR) version name. DATE DATE Enter th
generation generation Enter the parent
Enter the value Each hierarchy segmen
*Value Set Code *Tree Code *Tree Version Name *Tree Version Start Date Tree Version End Parent2 parent segmentparent segment
Parent1 Valuesegment value.
set code for Enter
the the tree can have Enter the start Enter the end
Date value. value.
segment values.
code name for multiple versions date of the tree date of the tree
the hierarchy. with non- version. version.
overlapping
dates.
=
AADVT7vi
======
======
ID#AAAADVT7v
ID#AAAADVT7v
NT2 YE
Vg
08-12PARENT1
VALUE (2019-
01) (2019-08-12
08-12 12:59:01)
he second
12:59:01)
Enter the child
tion Enter the parent
segment value.
segment
segment value.
 ======
ID#AAAADVT7vl
====== s ====== ======
Back to Overview ====== ID#AAAADVT7v TREE_VERSIO ID#AAAADVT7vj ID#AAAADVT7v
======
ID#AAAADVT7v cs N_NAME U nk
Segment Value Hierarchies oQ ID#AAAADV
(2019-08-12 (2019-08-12 (2019-08-12 (2019-08-12
4
VALUE_SET_C 12:59:01) 12:59:01) 12:59:01)
Navigation: Financials > Define Common Applications Configuration for Financials > Define Enterprise Structures for Fin 12:59:01)
PARENT5
ODE (2019-08-TREE_CODE VARCHAR2(80) TREE_VERSIO TREE_VERSIO
(2019-08-12
12 12:59:01)NOT NULL N_START_DATEN_END_DATE_
12:59:01)
VARCHAR2(60) VARCHAR2(30 Enter the tree _ACTIVE ACTIVE
Enter the fifth
CHAR) version name. DATE DATE
generation
Enter the value Each hierarchy
*Value Set Code *Tree Code *Tree Version Name *Tree Version Start Tree Version End Parent7 Parent6 Parent5 parent segme
set code for Enter
the the tree canDate
have Enter
Datethe start Enter the end value.
segment values.
code name for multiple versions date of the tree date of the tree
the hierarchy. with non- version. version.
overlapping
dates.
 ====== ====== ====== ======
ID#AAAADVT7viID#AAAADVT7vID#AAAADVT7vf
ID#AAAADVT7v
======
======
4 YA o bE ID#AAAADVT7v
ID#AAAADVT7v
PARENT5 PARENT4 PARENT3 PARENT2 co
mw
(2019-08-12(2019-08-12(2019-08-12(2019-08-12PARENT1
VALUE (2019-
12:59:01) 12:59:01) 12:59:01) 12:59:01) (2019-08-12
08-12 12:59:01)
Enter the fifth
Enter the fourth
Enter the third
Enter the second
12:59:01)
Enter the child
generation generation generation generation Enter the parent
segment value.
parent segment
Parent4 parent segment
Parent3 parent segment
Parent2 parent segment
Parent1 segment value.
Value
value. value. value. value.
 ======
ID#AAAADVT7v
====== e8 ====== ======
Back to Overview ====== ID#AAAADVT7v TREE_VERSIO ID#AAAADVT7v ID#AAAADVT7v
====== ====== ====== ======
ID#AAAADVT7v W8 N_NAME mY Xs
Segment Value Hierarchies dA ID#AAAADVT7viID#AAAADVT7vID#AAAADVT7vID#AAAADV
(2019-08-12 (2019-08-12 (2019-08-12 (2019-08-12
c X8 m4 o
VALUE_SET_C
Navigation: Financials > Define Common Applications 12:59:01)
Configuration 12:59:01)
for Financials > Define 12:59:01)
Enterprise Structures for Fin 12:59:01)
PARENT5 PARENT4 PARENT3 PARENT2
ODE (2019-08-TREE_CODE VARCHAR2(80) TREE_VERSIO TREE_VERSIO
(2019-08-12(2019-08-12(2019-08-12(2019-08-12
12 12:59:01)NOT NULL N_START_DATEN_END_DATE_
12:59:01) 12:59:01) 12:59:01) 12:59:01)
VARCHAR2(60) VARCHAR2(30 Enter the tree _ACTIVE ACTIVE
Enter the fifth
Enter the fourth
Enter the third
Enter the sec
CHAR) version name. DATE DATE
generation generation generation generation
Enter the value Each hierarchy
*Value Set Code *Tree Code *Tree Version Name *Tree Version Start Tree Version End Parent4 parent segment
parent segment
Parent3 parent segment
Parent2 parent segme
set code for Enter
the the tree canDate
have Enter
Datethe start Enter the end
value. value. value. value.
segment values.
code name for multiple versions date of the tree date of the tree
the hierarchy. with non- version. version.
overlapping
dates.
= ====== ======
AADVT7v
ID#AAAADVT7vID#AAAADVT7vi
======
======
m4 o ID#AAAADVT7v
ID#AAAADVT7v
NT4 PARENT3 PARENT2 gM
Vo
08-12(2019-08-12(2019-08-12PARENT1
VALUE (2019-
01) 12:59:01) 12:59:01) (2019-08-12
08-12 12:59:01)
he fourth
Enter the third
Enter the second
12:59:01)
Enter the child
tion generation generation Enter the parent
segment value.
segment
parent segment
parent segment
Parent1 segment value.
Value
value. value.
 ======
ID#AAAADVT7v
====== XI ====== ======
====== ID#AAAADVT7vjTREE_VERSIO ID#AAAADVT7vfID#AAAADVT7v
====== ======
ID#AAAADVT7v I N_NAME k Yo
ID#AAAADVT7vf
ID#AAAADVT7v
mc (2019-08-12 (2019-08-12 (2019-08-12(2019-08-12
Y cc
VALUE_SET_C 12:59:01) 12:59:01) 12:59:01) 12:59:01)
Segment Value Hierarchies ODE (2019-08-TREE_CODE VARCHAR2(80) TREE_VERSIO TREE_VERSIO
PARENT4 PARENT3
(2019-08-12 (2019-08-12
12Configuration
Navigation: Financials > Define Common Applications 12:59:01) forNOT NULL> Define Enterprise Structures for
Financials N_START_DATE
FinancialsN_END_DATE_
> Define Financial Reporting Structures > De
12:59:01) 12:59:01)
VARCHAR2(60) VARCHAR2(30 Enter the tree _ACTIVE ACTIVE
Enter the fourth
Enter the third
CHAR) version name. DATE DATE
generation generation
Enter the value Each hierarchy
*Value Set Code *Tree Code *Tree Version *Tree Version Start Tree Parent4 parent segment
Parent3 parent segment
set code for the Enter the tree can have Enter the start
Enter the end
Name Date Version value. value.
segment values. code name for multiple versions Enddate Dateof the tree
date of the tree
the hierarchy. with non- version. version.
overlapping
dates.
=
AADVT7v
====== ====== ======
ID#AAAADVT7vf
ID#AAAADVT7v ID#AAAADVT7v======
9-08-12 ======
Y cc gE ID#AAAADVT7v
01) ID#AAAADVT7v
PARENT4 PARENT3 PARENT2 aA
_VERSIO UI
(2019-08-12 (2019-08-12 (2019-08-12 PARENT1
D_DATE_
ne Financial Reporting Structures > Define Chart VALUE
of Accounts (2019-
> Manage Account Hierarchies
12:59:01) 12:59:01) 12:59:01) (2019-08-12
E 08-12 12:59:01)
Enter the fourth
Enter the third
Enter the second
12:59:01)
Enter the child
generation generation generation Enter the parent
segment value.
parent segment
parent segment
Parent2 parent segment
Parent1 segment value.
Value
he end
value. value. value.
the tree
n.
 ======
ID#AAAADVT7vj
====== o ====== ======
====== ID#AAAADVT7v TREE_VERSIO ID#AAAADVT7vID#AAAADVT7v
====== ====== ======
ID#AAAADVT7vfZg N_NAME Ys Wg
ID#AAAADVT7vID#AAAADVT7v ID#AAAADVT7v
c (2019-08-12 (2019-08-12 (2019-08-12(2019-08-12
k8 ZA nA
VALUE_SET_C 12:59:01) 12:59:01) 12:59:01) 12:59:01)
Segment Value Hierarchies ODE (2019-08-TREE_CODE VARCHAR2(80) TREE_VERSIO TREE_VERSIO
PARENT4 PARENT3 PARENT2
12 Configuration
Navigation: Financials > Define Common Applications 12:59:01) for NOT NULL > Define Enterprise N_START_DATE
Financials Financials >(2019-08-12
N_END_DATE_
Structures for (2019-08-12
Define Financial (2019-08-12
Reporting Structures > De
12:59:01) 12:59:01) 12:59:01)
VARCHAR2(60)VARCHAR2(30 Enter the tree_ACTIVE ACTIVE
Enter the fourth
Enter the third
Enter the second
CHAR) version [Link] DATE
generation generation generation
Enter the value Each hierarchy
*Value Set Code *Tree Code *Tree Version *Tree Tree Parent4 parent segment
Parent3 parent segment
Parent2 parent segment
set code for the Enter the tree canStart
have Version
Enter the start
Enter the end
Name Version value. value. value.
segment [Link] name for Date multiple versions
Enddate
Dateof the tree
date of the tree
the hierarchy. with non- version. version.
overlapping
dates.
= ====== ======
AADVT7v
ID#AAAADVT7vID#AAAADVT7v======
======
ZA nA ID#AAAADVT7v
ID#AAAADVT7v
NT4 PARENT3 PARENT2 Wo
cI
08-12 (2019-08-12 (2019-08-12 PARENT1
e Financial Reporting Structures VALUE
> Define Chart (2019-> Manage Account Hierarchies
of Accounts
01) 12:59:01) 12:59:01) (2019-08-12
08-12 12:59:01)
he fourth
Enter the third
Enter the second
12:59:01)
Enter the child
tion generation generation Enter the parent
segment value.
segment
parent segment
parent segment
Parent1 segment value.
Value
value. value.
 ======
ID#AAAADVT7v
====== dQ ====== ======
Back to Overview ====== ID#AAAADVT7v TREE_VERSIO ID#AAAADVT7v ID#AAAADVT7v
====== ====== ====== ======
ID#AAAADVT7v mQ N_NAME Xc pU
Segment Value Hierarchiesoc ID#AAAADVT7vl
ID#AAAADVT7v
ID#AAAADVT7vj
ID#AAAAD
(2019-08-12 (2019-08-12 (2019-08-12 (2019-08-12
M hE M mI
VALUE_SET_C
Navigation: Financials > Define Common Applications 12:59:01) for Financials12:59:01)
Configuration 12:59:01)
> Define Enterprise Struc 12:59:01)
PARENT5PARENT4PARENT3PARENT2
ODE (2019-08- TREE_CODE VARCHAR2(80) TREE_VERSIO TREE_VERSIO
(2019-08-12
(2019-08-12
(2019-08-12
(2019-08-1
12 12:59:01) NOT NULL N_START_DATE N_END_DATE_
12:59:01)12:59:01)12:59:01)12:59:01)
VARCHAR2(60) VARCHAR2(30 Enter the tree _ACTIVE ACTIVE
Enter theEnter
fifth theEnter
fourththeEnter
third the s
CHAR) version name. DATE DATE
generation
generationgenerationgeneration
Enter the value Each hierarchy
*Value Set Code *Tree Code *Tree Version Name *Tree Version Tree Version Parent7 Parent6 Parent5 Parent4 parentParent3
segment
parentParent2
segment
parent segment
parent seg
set code for the
Enter the tree canDate
have Enter
Datethe startEnter the end
Start End value. value. value. value.
segment [Link] name for multiple versions
date of the treedate of the tree
the hierarchy. with non- version. version.
overlapping
dates.
===== ====== ======
#AAAADVT7v
ID#AAAADVT7vj
ID#AAAADVT7v
======
======
E M mI ID#AAAADVT7v
ID#AAAADVT7v
ARENT4PARENT3PARENT2cY
nE
019-08-12
(2019-08-12
(2019-08-12
PARENT1
VALUE (2019-
2:59:01)12:59:01)12:59:01)(2019-08-12
08-12 12:59:01)
nter theEnter
fourththeEnter
third the12:59:01)
second
Enter the child
eneration
generationgenerationEnter the parent
segment value.
arent segment
parentParent1
segment
parentValue
segment
segment value.
lue. value. value.
 ======
ID#AAAADVT7vl
====== A ====== ======
Back to Overview ====== ID#AAAADVT7v TREE_VERSIO ID#AAAADVT7v ID#AAAADVT7v
ID#AAAADVT7v hU N_NAME es VQ
Segment Value Hierarchiesec (2019-08-12 (2019-08-12 (2019-08-12 (2019-08-12
VALUE_SET_C
Navigation: Financials > Define Common Applications 12:59:01) for Financials
Configuration 12:59:01)
> Define Enterprise12:59:01)
Structure 12:59:01)
ODE (2019-08-TREE_CODE VARCHAR2(80) TREE_VERSIO TREE_VERSIO
12 12:59:01)NOT NULL N_START_DATE N_END_DATE_
VARCHAR2(60) VARCHAR2(30 Enter the tree _ACTIVE ACTIVE
CHAR) version name. DATE DATE
Enter the value Each hierarchy
*Value Set Code *Tree Code *Tree Version Name *Tree Version Start Tree Version Parent6
set code for the
Enter the tree canDate
have Enter
End Datethe startEnter the end
segment values.
code name for multiple versions date of the tree date of the tree
the hierarchy. with non- version. version.
overlapping
dates.
 = ======
AADVT7v
ID#AAAADVT7v
====== ====== ====== ======
VQ
ID#AAAADVT7v
ID#AAAADVT7v
ID#AAAADVT7vi
ID#AAAADVT7vl
======
19-08-12 (2019-08-12 ======
c4 Ws Y c ID#AAAADVT7v
01) 12:59:01) ID#AAAADVT7v
PARENT5PARENT4PARENT3PARENT2aU
_VERSIOTREE_VERSIO aM
(2019-08-12
(2019-08-12
(2019-08-12
(2019-08-12
PARENT1
ART_DATE
N_END_DATE_ VALUE (2019-
12:59:01)12:59:01)12:59:01)12:59:01)(2019-08-12
VE ACTIVE 08-12 12:59:01)
Enter theEnter
fifth theEnter
fourththeEnter
third the12:59:01)
second
DATE Enter the child
generation
generationgenerationgenerationEnter the parent
segment value.
parentParent3
Parent5 Parent4 segment
parentParent2
segment
parentParent1
segment
parentValue
segment
segment value.
he startEnter the end
value. value. value. value.
f the tree
date of the tree
n. version.
 ======
ID#AAAADVT7v
====== eM ====== ======
Back to Overview ====== ID#AAAADVT7v TREE_VERSIO ID#AAAADVT7v ID#AAAADVT7v
====== ====== ====== ======
ID#AAAADVT7v cA N_NAME YI Uc
Segment Value HierarchiesZM ID#AAAADVT7v
ID#AAAADVT7vj
ID#AAAADVT7v
ID#AAAADVT7v
======
(2019-08-12 (2019-08-12 (2019-08-12 (2019-08-12
nc A Uw eg ID#AAAADVT
VALUE_SET_C
Navigation: Financials > Define Common Applications 12:59:01) for Financials12:59:01)
Configuration 12:59:01)
> Define Enterprise Structures 12:59:01)
PARENT5PARENT4PARENT3PARENT2aY
ODE (2019-08- TREE_CODE VARCHAR2(80) TREE_VERSIO TREE_VERSIO
(2019-08-12
(2019-08-12
(2019-08-12
(2019-08-12
PARENT1
12 12:59:01) NOT NULL N_START_DATE N_END_DATE_
12:59:01)12:59:01)12:59:01)12:59:01)(2019-08-12
VARCHAR2(60) VARCHAR2(30 Enter the tree _ACTIVE ACTIVE
Enter theEnter
fifth theEnter
fourththeEnter
third the12:59:01)
second
CHAR) version name. DATE DATE
generation
generationgenerationgenerationEnter the pare
Enter the value Each hierarchy
*Value Set Code *Tree Code *Tree Version Name *Tree Version Start Tree Version Parent5 Parent4 parentParent3
segment
parentParent2
segment
parentParent1
segment
parent segment
segment value
set code for the
Enter the tree canDate
have Enter
Datethe startEnter thevalue.
end
End value. value. value.
segment [Link] name for multiple versions date of the tree date of the tree
the hierarchy. with non- version. version.
overlapping
dates.
===== ======
#AAAADVT7v
ID#AAAADVT7v
======
======
w eg ID#AAAADVT7v
ID#AAAADVT7v
ARENT3PARENT2aY
eU
019-08-12
(2019-08-12
PARENT1
VALUE (2019-
2:59:01)12:59:01)(2019-08-12
08-12 12:59:01)
nter theEnter
third the12:59:01)
second
Enter the child
eneration
generationEnter the parent
segment value.
arent segment
parentValue
segment
segment value.
lue. value.
Back to Overview
Publish Account Hierarchies
Navigation: Financials > Define Common Applications Configurat

Use the Publish Account Hierarchies page to search and publish account hierarchies
Select the “Chart of Accounts” from the list and click on the “Search” button
Select the hierarchy and click on the ‘Publish’

Screenshots
Back to Overview
Manage Cross-Validation Rules
Navigation: Financials > Define Common Applications Configuration for Financials > Define Enterprise Structures for Financial

A cross-validation rule is defined in terms of a condition filter and a validation filter.

·        The condition filter describes the event under which the rule is evaluated. If the event specified in the condition
·        When the event specified in the filter condition is applied, the validation filter condition must be satisfied before
The rule is evaluated using the following logic: If condition is satisfied, then perform specified validations.
Name Description
nterprise Structures for Financials > Define Financial Reporting Structures > Define Chart of Accounts > Manage Cross-Validation Rules

vent specified in the condition filter isn't applicable, then the rule isn't evaluated even if it is enabled.
dition must be satisfied before the account combination can be created.
pecified validations.
From Date To Date Enabled
> Define Chart of Accounts > Manage Cross-Validation Rules

Condition Details
Validation Details Error Message Name
Error Message
Back to Overview
Manage Accounting Calendars
Navigation: Financials > Define Common Applications Configuration for Financials > Define Enterprise Structures for Financials > Define Financial Reporting Structures

Calendars
Name Description Start Date Period Frequency Adj Period
Freq
FORD_GL_CAL Corporate Calender- 1/1/2018 Monthly Once at year
Monthly end
Description Period Name Year Period Number Quarter Start Date
Number
Jan-19 2019 1 1 1/1/2019
Feb-19 2019 2 1 2/1/2019
Mar-19 2019 3 1 3/1/2019
Apr-19 2019 4 2 4/1/2019
May-19 2019 5 2 5/1/2019
Jun-19 2019 6 2 6/1/2019
Jul-19 2019 7 3 7/1/2019
Aug-19 2019 8 3 8/1/2019
Sep-19 2019 9 3 9/1/2019
Oct-19 2019 10 4 10/1/2019
Nov-19 2019 11 4 11/1/2019
Dec-19 2019 12 4 12/1/2019
Adj-19 2019 13 4 12/31/2019
Jan-18 2018 1 1 1/1/2018
Feb-18 2018 2 1 2/1/2018
Mar-18 2018 3 1 3/1/2018
Apr-18 2018 4 2 4/1/2018
May-18 2018 5 2 5/1/2018
Jun-18 2018 6 2 6/1/2018
Jul-18 2018 7 3 7/1/2018
Aug-18 2018 8 3 8/1/2018
Sep-18 2018 9 3 9/1/2018
Oct-18 2018 10 4 10/1/2018
Nov-18 2018 11 4 11/1/2018
Dec-18 2018 12 4 12/1/2018
Adj-18 2018 13 4 12/31/2018
 Calendars
Name Description Start Date Period Frequency Adj Period
Freq
Description Period Name Year Period Number Quarter Start Date
Number
Screenshots
s > Define Financial Reporting Structures > Define Calendars > Manage Accounting Calendars

End Date Adjusting

Period
1/31/2019 0
2/28/2019 0
3/31/2019 0
4/30/2019 0
5/31/2019 0
6/30/2019 0
7/31/2019 0
8/31/2019 0
9/30/2019 0
10/31/2019 0
11/30/2019 0
12/31/2019 0
12/31/2019 1
1/31/2018 0
2/28/2018 0
3/31/2018 0
4/30/2018 0
5/31/2018 0
6/30/2018 0
7/31/2018 0
8/31/2018 0
9/30/2018 0
10/31/2018 0
11/30/2018 0
12/31/2018 0
12/31/2018 1
End Date Adjusting
Period
Back to Overview
Manage Primary Ledgers
Navigation: Financials > Define Common Applications Configuration for Financials > Define Ledgers > Define Accounting Configurations > Manage Primary Ledgers

Select the 'Create' button and create a ledger for each accounting calendar.
Ledger ID Name Description Chart of Accounts Accounting Calendar
FORD_US_PL Ford Primary Ledger USD FORD_COA FORD_GL_CAL
FORD_UK_PL Ford Primary Ledger UK FORD_COA FORD_GL_CAL
Screenshots
ns > Manage Primary Ledgers

Currency Accounting Method

USD Standard Accrual
GBP Standard Accrual
Screenshots
Value Set Chart of Accounts Primary Ledger Secondary Ledgers
FORD_COMPANY FORD_COA FORD_US_PL FORD_US_SL
FORD_COMPANY FORD_COA FORD_UK_PL FORD_UK_SL
Screen
Legal Entity Company Division
Ford Motor Company Value
101
Ford Of Britain 201
Screenshots
Description Start Date End Date
Ford Motor Company
Ford Of Britain
Assign Legal Entities
Navigation: Financials > Define Common Applications Configuration for Financials > Define Ledgers > Define Accounting Configurations > Assign Legal Entities

Ledger Legal Entity Legal Entity

FORD_US_PL Ford Motor Company Identifier
F101
FORD_UK_PL Ford Of Britain F201
Screenshots
ations > Assign Legal Entities
shots
Back to Overview
Specify Ledger Options
Navigation: Financials > Define Common Applications Configuration for Financials > Define Ledgers > Define Accounting Configurations > Specify Ledger Options

General Information Accounting Calendar

Name Description Currency Chart of Accounts Accounting First Number of
Calendar Opened Future
Period Enterable
Periods

FORD_US_PL Ford Primary Ledger US USD FORD_COA FORD_CAL Jan-18 1

FORD_UK_PL Ford Primary Ledger UK GBP FORD_COA FORD_CAL Jan-18 1
Screenshots
fy Ledger Options

Subledger Accounting Period Close Journal Processing

Accounting Method Journal Language Retained Earnings Account Cumulative Default Default Enable Enable
Translation Period End Period Suspense: Suspense:
Adjustment Rate Type Average General Subledger
Account Rate Type Ledger Accounting

Standard Accrual US 35100 35300

Standard Accrual US 35100 35300
Default Suspense Account Rounding Entered Currency Balancing Account Enable Notify Allow mixed Validate
Account Journal when Prior statistical Reference
Approval period and date
journal is monetary
entered journal
 Sequencing
Balancing Intercompany: Import: Reversal: Reversal: Run Reversal: Sequencing By: Enforce
threshold Enable Separate Journal auto Reverse Synchronize Document
percent Intercompany journal by Reversal after open Reversals Sequencin
Accounting accounting Criteria Set period between g
date Primary and
during Secondary
journal Ledgers
import

Yes No Sequencing
Yes No Sequencing
Back to Overview
Manage Secondary Ledgers
Navigation: Financials > Define Common Applications Configuration for Financials > Define Ledgers > Define Accounting Configurations > Define Secondary Ledgers > Man

Select the 'Create' button and create a ledger for each accounting calendar.
Name Description Chart of Accounts Accounting Calendar Currency

Screenshots
ne Secondary Ledgers > Manage Secondary Ledgers

Status Data Conversion Level Conversion Status

Back to Overview
Specify Ledger Options
Navigation: Financials > Define Common Applications Configuration for Financials > Define Ledgers > Define Accounting Configurations > Define Secondary Ledgers > Spec

General Information Accounting Calendar

Name Description Currency AD Accounting First Number of
Calendar Opened Future
Period Enterable
Periods

Screen
e Secondary Ledgers > Specify Ledger Options

Subledger Accounting Period Close Journal Processing

Accounting Method Journal Language Retained Earnings Account Cumulative Default Default Enable Enable
Translation Period End Period Suspense: Suspense:
Adjustment Rate Type Average General Subledger
Account Rate Type Ledger Accounting

Screenshots
Default Suspense Rounding Entered Currency Balancing Account Enable Notify Allow mixed Validate Balancing
Account Account Journal when Prior statistical Reference threshold
Approval period and date percent
journal is monetary
entered journal
 Sequencing
Intercompany: Import: Reversal: Reversal: Run Sequencing By: Enforce
Enable Separate Journal auto Reverse Document
Intercompany journal by Reversal after open Sequencing
Accounting accounting Criteria Set period
date
during
journal
import
Back to Overview
Complete Primary to Secondary Ledger Mapping
Navigation: Financials > Define Common Applications Configuration for Financials > Define Ledgers > Define Accounting Configurations > Define Secondary Ledgers > Com

Primary Ledger
Name Chart of Accounts Accounting Currency Accounting
Calendar Method

Secondary Ledger
Name Chart of Accounts Accounting Currency Accounting Data Conversion
Calendar Method Level

Journal Conversion Rules

Posts Journals Automatically from
Source Ledger
Retain Journal Creator from Source
Ledger
Journal Source Journal Category Transfer Journals
to This Secondary
 Primary Ledger
Name Chart of Accounts Accounting Currency Accounting
Calendar Method

Secondary Ledger
Name Chart of Accounts Accounting Currency Accounting Data Conversion
Calendar Method Level

Journal Conversion Rules

Posts Journals Automatically from
Source Ledger
Retain Journal Creator from Source
Ledger
Journal Source Journal Category Transfer Journals
to This Secondary
Ledger

Primary Ledger
 Name Chart of Accounts Accounting Currency Accounting
Calendar Method

Secondary Ledger
Name Chart of Accounts Accounting Currency Accounting Data Conversion
Calendar Method Level

Journal Conversion Rules

Posts Journals Automatically from
Source Ledger
Retain Journal Creator from Source
Ledger
Journal Source Journal Category Transfer Journals
to This Secondary
Ledger

Primary Ledger
Name Chart of Accounts Accounting Currency Accounting
Calendar Method
 Secondary Ledger
Name Chart of Accounts Accounting Currency Accounting Data Conversion
Calendar Method Level

Journal Conversion Rules

Posts Journals Automatically from
Source
Retain Journal Ledger
Creator from Source
Ledger
Journal Source Journal Category Transfer Journals
to This Secondary
Ledger
Secondary Ledgers > Complete Primary to Secondary Ledger Mapping

Status
Status
Status
Status

Screenshots
Back to Overview
Review and Submit Accounting Configurations
Navigation: Financials > Define Common Applications Configuration for Financials > Define Ledgers > Define Accounting Con

Review and Submit Accounting Configuration must be submitted for ALL LEDGERS. Click the 'Submit' button after going to the task

Screenshots
ots
Back to Overview
Manage Ledger Sets
Navigation: Financials > Define Common Applications Configuration for Financials > Define Ledgers > Define General Ledger Options > Manage Ledger Sets

Select the 'Create' button and create a ledger set for each accounting calendar.
Name Description Chart of Accounts Accounting Calendar Default Ledger

Ledger Set Assignments

Ledger or Ledger Set Type Description

Name Description Chart of Accounts Accounting Calendar Default Ledger

Ledger Set Assignments

Ledger or Ledger Set Type Description
 Name Description Chart of Accounts Accounting Calendar Default Ledger

Ledger Set Assignments

Ledger or Ledger Set Type Description

Name Description Chart of Accounts Accounting Calendar Default Ledger

Ledger Set Assignments

Ledger or Ledger Set Type Description
 Name Description Chart of Accounts Accounting Calendar Default Ledger

Ledger Set Assignments

Ledger or Ledger Set Type Description

Screenshots
Options > Manage Ledger Sets
reenshots
Back to Overview
Manage Data Access Sets
Navigation: Financials > Define Common Applications Configuration for Financials > Define Ledgers > Define General Ledger O

Select the 'Create' button and create a data access set for each accounting calendar.

Name Description Access Set Type

Screenshots
e Ledgers > Define General Ledger Options > Manage Data Access Sets

Chart of Accounts Accounting Calendar Default Ledger Ledger or Ledger Set Type
All Values Privilege
Back to Overview
Run User and Roles Synchronization Process
Navigation: Financials > Define Common Applications Configuration for Financials > Define Synchronization of Users and Roles fr

Screenshots
This process must be run after generating and provisioning roles in order to synchronize them
Go to the task and click 'Submit'. Go to Scheduled Processes in the navigator to confirm that the process has run.
Back to Overview
Open First Period
Navigation: Financials > Define Common Applications Configuration for Financials > Define Ledgers > Define Accounting

When opening the first period, select the data access set, ledger, and accounting period. Data Access Set
and Ledger will be the same. Click Submit and check the Scheduled Processes to confirm that it ran
successfully.

Screenshots
Back to Overview
Manage Journal Sources
Navigation: Financials > Define Common Applications Configuration for Financials > Manage Journal Sources

Name Source Key Description Freeze Journals

Screenshots
Accounting Date Rule Import Journal Require Journal Import Using Key
References Approval
Back to Overview
Manage Journal Categories
Navigation: Financials > Define Common Applications Configuration for Financials > Manage Journal Categories

JE_CATEGORY_NAME JE_CATEGORY_KEY DESCRIPTION

Screenshots
Back to Overview
Manage AutoPost Criteria Sets
Navigation: Tools > Setup and Maintenance > Manage Implementation Projects > Implementation_Project > Financials > Define Common Applications Configuration for Fin

*Name Description Enabled

Auto Post Criteria Posting Submission Options

Priority Ledger/Ledger Set Source Category Accounting Period Process All Criteria

*Name Description Enabled

Auto Post Criteria Posting Submission Options

Priority Ledger/Ledger Set Source Category Accounting Period Process All Criteria

*Name Description Enabled

Auto Post Criteria Posting Submission Options

Priority Ledger/Ledger Set Source Category Accounting Period Process All Criteria

*Name Description Enabled

Auto Post Criteria Posting Submission Options

Priority Ledger/Ledger Set Source Category Accounting Period Process All Criteria
*Name Description Enabled

Auto Post Criteria Posting Submission Options

Priority Ledger/Ledger Set Source Category Accounting Period Process All Criteria

Screenshots
Define Common Applications Configuration for Financials > Define Ledgers > Define General Ledger Options > Manage AutoPost Criteria Sets > Go to Task

Posting Submission Options Accounting Date Ranga

Number of Criteria to Process Number of Days Before Number of Days After
Submission Date Submission Date

Posting Submission Options Accounting Date Ranga

Number of Criteria to Process Number of Days Before Number of Days After
Submission Date Submission Date

Posting Submission Options Accounting Date Ranga

Number of Criteria to Process Number of Days Before Number of Days After
Submission Date Submission Date

Posting Submission Options Accounting Date Ranga

Number of Criteria to Process Number of Days Before Number of Days After
Submission Date Submission Date
 Posting Submission Options Accounting Date Ranga
Number of Criteria to Process Number of Days Before Number of Days After
Submission Date Submission Date

ots
Back to Overview
Manage Journal Reversal Criteria Sets
Navigation: Tools > Setup and Maintenance > Manage Implementation Projects > Implementation_Project > Financials > Define Common Applications Configuration for Fin

*Name Description

Category (L)Reversal Period Reversal Date

Scree
ications Configuration for Financials > Define Ledgers > Define General Ledger Options > Manage Journal Reversal Criteria Sets > Go to Task

(L)Reversal Method (L)Automatic Reversal Option

Screenshots
Back to Overview
Manage Revaluations
Navigation: Financials > Define Common Applications Configuration for Financials > Define Ledgers > Define Period Close Components > Manage Revaluations

Name Description Chart of Accounts Currency Conversion Rate Days to

Type Roll
Screenshots
onents > Manage Revaluations

Income Statement Account Basis

Unrealized Gains Unrealized Loss PTD YTD Post

Automatically
Screenshots
Screenshots
 Revaluation Accounts

Flter Conditions Account Filters

Back to Overview
Manage General Ledger Descriptive Flexfields
Navigation: Tools > Setup and Maintenance > Manage Implementation Projects > Implementation_Project > Financials > Define Common Applications Configuration for Fin

Screenshots
mon Applications Configuration for Financials > Define Ledgers > Define General Ledger Options > Manage General Ledger Descriptive Flexfields > Go to

enshots
Back to Overview
Manage Intercompany Transaction Types
Financials > Define and Maintain Intercompany Processing Rules > Manage Intercompany Transaction Types

Code Transaction Type Name Description Invoicing

Screensh
Manual Approval Enable

Screenshots
Back to Overview
Manage Intercompany System Options
Financials > Define and Maintain Intercompany Processing Rules > Manage Intercompany System Options

Screenshots
Back to Overview
Manage Intercompany Balancing Rules
Financials > Define and Maintain Intercompany Processing Rules > Manage Intercompany Balancing Rules

Chart of Accounts
Rules
Chart of Accounts Receivables Account Payables Account

Ledger Rules
From Ledger
To Ledger
Receivables Account
Payables Account
Start Date
End Date
Source
Category
Transaction Type

Screenshots
g Rules

Start Date End Date Source Category Transaction Type

eenshots
Back to Overview
Manage Additional Intercompany Balancing and Clearing Options
Financials > Define and Maintain Intercompany Processing Rules > Manage Additional Intercompany Balancing and Clearing Options

Ledger Journal Source Journal Category Receivables Account Payables Account

Screensh
 Summarization and Clearing Company Options
Start Date End Date Summarization Condition Source

Screenshots
Value
Back to Overview
Manage Intercompany Period Status
Financials > Define and Maintain Intercompany Processing Rules > Manage Intercompany Period Status

Intercompany Calendar Period Type

Select any one from these

Transaction Type Name

Click 'Search'

Open the Period as required.

Screenshots
Back to Overview
Manage Intercompany Organizations
Financials > Define and Maintain Intercompany Processing Rules > Manage Intercompany Organizations

Organization Name Legal Entity Name

Screenshots
Receivables Business Unit Payables Business Unit Default Organization Contact Enabled Description
Screenshots
Back to Overview
Manage Business Units
Navigation: Navigator > Setup and Maintenance > Implementation Projects > FAS Implementation Project > Financials > Define Common
Applications Configuration for Financials > Define Business Units > Manage Business Units

Business Units
Name Manager Location Default Set
FORD_US FORD_US_LOCATION COMMON
FORD_UK FORD_UK_LOCATION COMMON

Screenshots
 ======
ID#AAAADVT7v
pk
Konica Madan
(2019-08-12
12:59:01)
e Common manage
business unit

Active
Yes
Yes
Back to Overview
Assign Business Units Business Function
Navigation: Navigator > Setup and Maintenance > Implementation Projects > Financials > Define Common Applications Configuration for Financials > Define Business Units >

Assign Business Functions FORD_US FORD_UK

Financial Reporting
Primary Ledger FORD_US_PL FORD_UK_PL
Below Legal Entity Yes Yes
Default Legal Entity

Business Unit Functions

Name Enabled (Yes/No) Enabled (Yes/No)

Payables Invoicing Yes Yes

Payables Payment Yes Yes
Procurement Yes Yes
Billing and Revenue Management Yes Yes
Customer Payments Yes Yes
Service Request Management Yes Yes
Collections Management Yes Yes
Materials Management Yes Yes
Customer Contract Management Yes Yes
Project Accounting Yes Yes
Requisitioning Yes Yes
Receiving Yes Yes
Expense Management Yes Yes
Sales Yes Yes
Procurement Contract Management Yes Yes
Incentive Compensation Yes Yes
Revenue Compliance and Accounting Yes Yes
iguration for Financials > Define Business Units > Assign Business Units Business Function

Enabled (Yes/No) Enabled (Yes/No) Enabled (Yes/No)

Enabled (Yes/No) Enabled (Yes/No) Enabled (Yes/No)

Screenshots
Enabled (Yes/No) Enabled (Yes/No) Enabled (Yes/No)

Screenshots
Enabled (Yes/No) Enabled (Yes/No) Enabled (Yes/No)
Enabled (Yes/No) Enabled (Yes/No) Enabled (Yes/No)
Enabled (Yes/No) Enabled (Yes/No)
Manage Legal Jurisdictions
Navigation: Financials > Define Common Applications Configuration for Financials > Define Enterprise Structures for Financials > Define Legal Jurisdictions

* Name *Territory *Legislative *Identifying Start Date End Date

Category

United States Income Tax United States Income Tax Yes

United Kingdom Income Tax United Kingdom Income Tax Yes
e Structures for Financials > Define Legal Jurisdictions and Authorities for Financials

*Legal Entity Registration Code *Legal Reporting Unit Registration Code

EIN or TIN Legal Reporting Unit Registration Number

Company Number CUIT
Back to
Overview
Manage Legal Addresses
Navigation: Financials > Define Common Applications Configuration for Financials > Define Enterprise Structures for

*(L)Country *Address Line 1 Address Line 2

United States 55 Walter Street
United Kingdom 7 More London Riverside

*(L)Country *Address Line 1 Address Line 2

*(L)Country *Address Line 1 Address Line 2

*(L)Country Postal Code *Province

*(L)Country *Address Line 1 *Address Line 2

*(L)Country *Address Line 1 Address Line 2

*(L)Country *Block or House Number *Street Name

*(L)Country *Address Line 1 Address Line 2

*(L)Country *Address Line 1 Address Line 2

*(L)Country *Address Line 1 Address Line 2

*(L)Country *Address Line 1 Address Line 2

*(L)Country *Address Line 1 Address Line 2

*(L)Country *Address Line 1 Address Line 2

*(L)Country *Address Line 1 Address Line 2

*(L)Country *Address Line 1 Address Line 2

*(L)Country Address Line 1 Address Line 2

*(L)Country City or Town Address Line 1

or Financials > Define Enterprise Structures for Financials > Define Legal Jurisdictions and Authorities for Financials

Address Line 3 *City (L)State Postal Code

NEW YORK NEW YORK 10041
Yarkhill England HR1 3SS

City (L)State Postal Code Time Zone

Address Line 3 City Province Postal Code

Prefecture County or District *Street Address Additional Address Line

Address Line 3 City District Area

Address Line 3 *City *Pin Code State

Level - Unit Number Building Name *Postal Code Time Zone

Address Line 3 *Suburb City *Postal Code

Address Line 3 *City County Postcode

Address Line 3 *City Postal Code County

Address Line 3 Postal Code City Time Zone

Address Line 3 *Post Code *City *State

Address Line 3 *Post Code *City Time Zone

Address Line 3 *City *Postal Code Time Zone

*Postal Code *City Province Time Zone

Address Line 3 Address Line 4 City State

Address Line 2 Postal Code Time Zone

or Financials

Time Zone

Time Zone

Time Zone

Time Zone

India GST No. Time Zone

Time Zone

Time Zone
Time Zone

Time Zone

Postal Code Time Zone

Back to Overview

Navigation: Financials > Define Common Applications Configuration for Financials > Define Enterprise Structures for

* Legal Entity * Segment Description

Segment Value

101 Ford Motor Company

201 Ford Of Britain
 * Legal Entity * Segment Description
Segment Value

GPI GP, INC. (PARENT)

000 DEFAULT INTERCOMPANY
ELM Elim Entities
HPY HEARTLAND PAYMENT SYSTEMS, LLC (PARENT)
 ======
ID#AAAADVT7v
bw
(2019-08-12
12:59:01)
Specifying the
or Financials > Define Enterprise Structures for Financials > DefineLegal
LegalEntiry is for Financials
Entities
not manadatory.
If specified all
the * marked
* Legal Entity Name * Legal Entity *(L)Country
columns
Identifier after
this are
mandatory.
FORD Motor Company US101 United States
Ford of Britain UK201 United Kingdom
 ======
ID#AAAADVT7v
mg
(2019-08-12
12:59:01)
Specifying the
Legal Entiry is
not manadatory.
If specified all
* Legal Entity Name the * marked
* Legal Entity *(L)Country
columns
Identifier after
this are
mandatory.
GP, INC. (PARENT)
DEFAULT INTERCOMPANY
Elim Entities
HEARTLAND PAYMENT SYSTEMS, LLC (PARENT)
Financials

Address
*Address Line (L)City (L)State County

55 Walter Street NEW YORK NEW

7 More London Riverside Yarkhill YORK
England
 Address
*Address Line (L)City (L)State County

Parent
Default
Parent
Parent
 ID#AAAADVT7v
WM
Konica Madan
(2019-08-12
12:59:01)
could not match
Legal Entity
Registration
Number and
legal reporting
Registration *Ledger unit reg no from
Provinc (L)Postal Code *Legal Entity *Legal Reporting this option
e Registration Unit Registration
Number Number

10041 101 101 FORD_US_PL

HR1 3SS 201 201 FORD_UK_PL
 Registration *Ledger
Provinc (L)Postal Code *Legal Entity *Legal Reporting
e Registration Unit Registration
Number Number
AAADVT7v

a Madan
-08-12
:01)
not match
Entity
tration
ber and
reporting
eg no from
ption
Back to Overview
Manage Reference Data Sets
Navigation: Financials > Define Common Applications Configuration for Financials > Define Enterprise Structures for Financials > Define Referen

Set Code Set Name Description

Screenshots
ctures for Financials > Define Reference Data Sharing > Manage Reference Data Sets

ts
Back to Overview
Manage Business Unit Set Assignments
Navigation: Financials > Define Common Applications Configuration for Financials > Define Enterprise Structures for Financials > Define Busines

Reference Data Set Reference Data Object Reference Data Set

Name Code
Screenshots
r Financials > Define Business Units > Manage Business Unit Set Assignments
Create Allocation Rules (Allocation of Fringe Benefits Costs)
Navigation: Home >General Accounting >Journals >Create Allocation Rules

Expand General Ledger Balance Cubes

Expand_COA_SC
Expand db
STEP 1 Create an allocation formula for calculation of Fringe Benefits Costs
Right click on rules and select New from the menu.
Enter the rule name
Click OK
The Rule Designer opens in a new tab. Under New Objects, click, hold, and dra
object. Place it between the Begin and End nodes in the Rule Designer.
Now drag Formula object. Place it between Member Range nodes in the Rule

click on Member Range

under Properties tab enter following information:-

Name:
Caption:
Description:
Application:
Database:
Comments:

Under Point of View tab enter following information:-

Dimension
AccountingPeriod
Ledger

Scenario
Currency
Currency Type

Now click on Formula

under Properties tab enter following information:-

Name:
Caption:
Description:
Application:
 Database:
Comments:

under Formula tab enter following information:-

Offset Member:
Rounding Digits:
Comment

STEP 2 Create an allocation rule for allocation of Fringe Benefits Costs

Right click on rules and select New from the menu.
Enter the rule name
Click OK
The Rule Designer opens in a new tab. Under New Objects, click, hold, and dra
object. Place it between the Begin and End nodes in the Rule Designer.
Now drag Allocation object. Place it between Member Range nodes in the Ru

click on Member Range

under Properties tab enter following information:-

Name:
Caption:
Description:
Application:
Database:
Comments:

Under Point of View tab enter following information:-

Dimension
AccountingPeriod
Ledger

Scenario
Currency
Currency Type

Now click on Allocation

under Properties tab enter following information:-

Name:
 Caption:
Description:
Application:
Database:
Comments:

under Summary tab enter following information:-

Point of View
Dimension
AccountingPeriod
Ledger

Currency
Currency Type

Source
Dimension

Scenario
Balance Amount
Amount Type

Optional-Enter a amount to be allocated instead of the selections above:

If the source amount you want to allocate is equal to zero then:

Allocation Range
Dimension
 Target
Dimension

Offset
Dimension

Exclude
Dimension

Basis
Select an allocation method:

Dimension
AccountingPeriod
Ledger

Scenario
Balance Amount
Amount Type
Currency
Currency Type

Basis-Options
If the basis is negative, what would you like the system to do:

If the basis is equal to zero, what would you like the allocation to do:

Rounding
Enter the number of decimal places to use for this allocation:

Select where to place the rounding difference:

STEP 3 Create an allocation formula for calculation of Fringe Benefits Accruals

Right click on rules and select New from the menu.
Enter the rule name
Click OK
The Rule Designer opens in a new tab. Under New Objects, click, hold, and dra
object. Place it between the Begin and End nodes in the Rule Designer.
Now drag Formula object. Place it between Member Range nodes in the Rule

click on Member Range

under Properties tab enter following information:-

Name:
Caption:
Description:
Application:
Database:
Comments:

Under Point of View tab enter following information:-

Dimension
AccountingPeriod
Ledger

Scenario
Currency
Currency Type

Now click on Formula

under Properties tab enter following information:-

Name:
Caption:
Description:
Application:
Database:
Comments:

under Formula tab enter following information:-

Offset Member:
Rounding Digits:
Comment
 Benefits Costs

bjects, click, hold, and drag the Point of View

the Rule Designer.
Range nodes in the Rule Designer.

Value
bjects, click, hold, and drag the Point of View
the Rule Designer.
er Range nodes in the Rule Designer.

Value
Select Value

Select Value

Select Value
 Select Value

Select Value

Select Value

Select Value

Benefits Accruals
bjects, click, hold, and drag the Point of View
the Rule Designer.
Range nodes in the Rule Designer.

Value