This appendix lists the tables used by the JD Edwards EnterpriseOne Console and lists prepopulated tables.
Tables Used by the JD Edwards EnterpriseOne Console
This table lists the tables that the JD Edwards EnterpriseOne Console uses or populates:
|
Table |
Description |
|
F0006 |
Business Unit Master |
|
F0008 |
Date Fiscal Patterns |
|
F0009 |
General Constants |
|
F0010 |
Company Constants |
|
F0012 |
Automatic Accounting Instructions Master |
|
F03012 |
Customer Master by Line of Business |
|
F03B11 |
Customer Ledger |
|
F03B13 |
Receipts Header |
|
F03B14 |
Receipts Detail |
|
F03B16 |
A/R Statistical History |
|
F0411 |
Accounts Payable Ledger |
|
F0413 |
Accounts Payable - Matching Document |
|
F0414 |
Accounts Payable Matching Document Detail |
|
F0902 |
Account Balances |
|
F0911 |
Account Ledger |
|
F09521 |
Cash Type Rules |
|
F09522 |
Cash Forecast Data |
|
F09E108 |
Policy Edit Rules |
|
F1602 |
Cost Analyzer Balances |
|
F1603 |
Cost Analyzer View Structure |
|
F3102 |
Production Cost |
|
F4101 |
Item Master |
|
F4102 |
Item Branch File |
|
F41021 |
Item Location File |
|
F4105 |
Item Cost |
|
F4201 |
Sales Order Header File |
|
F4211 |
Sales Order Detail File |
|
F42119 |
Sales Order History File |
|
F4301 |
Purchase Order Header |
|
F43090 |
Supplier/Item Relationships |
|
F4311 |
Purchase Order Detail File |
|
F43121 |
Purchase Order Receiver File |
|
F4322 |
Purchasing Tolerance Rules |
|
F4801 |
Work Order Master File |
|
F80D010 |
Sales Order Fact |
|
F80D020 |
GL Account Balances Fact |
|
F80D021 |
Financial Ratios Amount Dimensions Table |
|
F80D100 |
PMD - Date Dimension |
|
F80D101 |
PMD - UBE Timestamp |
|
F80D104 |
Address Book List |
|
F80D105 |
Business Unit List |
|
F80D106 |
Product Group List |
|
F80D107 |
Goals Definition |
|
F80D107A |
Goals Definition Tag |
|
F80D108 |
Goals Definition Cross Reference |
|
F80D110 |
PMD Search By Saved Query |
|
F80D111 |
FMD Search By Saved Query |
|
F80D112 |
SOD Rules |
|
F80D113 |
SOD Process Master |
|
F80D114 |
SOD Group Master |
|
F80D120 |
SOD Violations |
|
F80D130 |
Compliance Master |
|
F80D131 |
Compliance Instance Detail |
|
F80D135 |
SOD Alert Master |
|
F80D136 |
SOD Alert Detail |
|
F80D150 |
Whistle Blower Recipient List |
|
F80D200 |
Days Sales Outstanding Aggregate Table |
|
F80D201 |
Days Payable Outstanding Aggregate |
|
F80D202 |
Cash to Cash Cycle Time Aggregate |
|
F80D203 |
Forecasted Cash Flow Aggregate |
|
F80D210 |
On Time Shipment Customer Request Date Aggregate Table |
|
F80D211 |
On Time Shipment Promise Ship Date Aggregate Table |
|
F80D212 |
Past Due Aggregate Table |
|
F80D213 |
Back Order Aggregate Table |
|
F80D214 |
Variance Table |
|
F80D215 |
Book to Ship Aggregate Table |
|
F80D220 |
Inventory Aggregate Table |
|
F80D221 |
General Ledger Aggregate Table |
|
F80D230 |
On Time Manufacturing Production Completions |
|
F80D231 |
Manufacturing Production Costings |
|
F80D240 |
Booked Orders Aggregate |
|
F80D241 |
Shipped Order Revenue |
|
F80D242 |
Projected Revenue Aggregate |
|
F80D243 |
Backlog Aggregate |
|
F80D250 |
Supplier On-Time Delivery Aggregate |
|
F80D251 |
Material Lead Time Exception Aggregate |
|
F80D252 |
Supplier Pass Quality Aggregate |
|
F80D253 |
AP Daily Counts and Amounts |
|
F80D254 |
AP Discount Information Aggregate |
|
F80D255 |
AP Open Payables Aggregate |
|
F80D256 |
AP Voucher Paid Late Aggregate |
|
F80D272 |
Most Profitable Customers Aggregate |
|
F80D273 |
Most Profitable Products Aggregate |
|
F80D274 |
Most Profitable Brands Aggregate |
|
F80D280 |
AR Daily Counts and Amts Aggr |
|
F80D281 |
AR Delinquency Info Aggregate |
|
F80D282 |
AR Discount Information Aggregate |
|
F80D283 |
AR Open Chargeback Aggregate |
|
F80D284 |
AR Open Receivables Aggregate |
|
F80D285 |
AR Total Chargeback Aggregate |
|
F80D300 |
Dashboard Constants |
|
F80D301 |
Dashboard Code Metric Cross Reference |
|
F80D302 |
Metric ID Time Dimension Cross Reference |
|
F80D303 |
Metric Definition |
|
F80D304 |
Variant Definition |
|
F80D305 |
Hierarchy Definition |
|
F80D306 |
Action Definition |
|
F80D307 |
Metric Action Cross Reference |
|
F80D309 |
Metric Series Cross Ref |
|
F80D310 |
Alert Definition |
|
F80D310A |
Alert Definition Tag Table |
|
F80D311 |
Alert Instance |
|
F80D311A |
Alert Instance Tag Table |
|
F80D312 |
Alert Subscription |
|
F80D315 |
Alert Instance Status |
|
F80D320 |
Dashboard Configuration |
|
F80D321 |
UI Metric Group Definition |
|
F80D322 |
UI Metric Group Detail |
|
F80D323 |
GroupID Email Address |
|
F80D701 |
Unposted Transactions Aggregate |
Prepopulated Tables
Specific tables in the JD Edwards EnterpriseOne Console are prepopulated with data. The prepopulated data in the tables enables a quick implementation of the JD Edwards EnterpriseOne Console.

Financial Ratios Amount Dimensions Table
This table lists the data that is prepopulated in the Financial Ratios Amount Dimensions table (F80D021):
|
Metric Identifier |
Financial Ratios Range Code 1 |
Financial Ratios Range Code 2 |
Financial Ratios Range Code 3 |
Financial Ratios Range Code 4 |
|
F01 |
NW |
TA |
CA |
None |
|
F02 |
NW |
TA |
CA |
None |
|
F03 |
NW |
TA |
CA |
None |
|
F04 |
NW |
TA |
CA |
IV |
|
F05 |
NW |
TA |
CA |
None |
|
F06 |
NW |
TA |
None |
None |
|
F07 |
NW |
TA |
FA |
None |
|
F08 |
NW |
TA |
None |
None |
|
F09 |
NW |
None |
None |
None |
|
F10 |
NW |
CL |
None |
None |
|
F11 |
NW |
None |
None |
None |
|
F12 |
NW |
LD |
None |
None |
|
F13 |
NW |
None |
None |
None |
|
F14 |
None |
None |
None |
None |
|
F15 |
IN |
SA |
None |
None |
|
F16 |
IN |
None |
None |
None |
|
F17 |
IN |
CG |
OE |
None |
|
F18 |
IN |
None |
OE |
None |
|
F19 |
IN |
None |
None |
None |
|
F20 |
IN |
IT |
None |
None |
|
F21 |
IN |
None |
None |
None |
|
F22 |
IN |
None |
None |
None |
|
F23 |
IN |
None |
None |
None |
|
F24 |
IN |
None |
None |
None |
|
F25 |
IN |
None |
None |
None |
|
F26 |
IN |
TX |
None |
None |
|
F27 |
IN |
None |
None |
None |
|
F28 |
None |
None |
None |
None |

Goals Definition Cross Reference Table
This table lists the data that is prepopulated in the Goals Definition Cross Reference table (F80D108):
|
Metric Identifier |
Goal DD Alias 1 |
Goal DD Alias 2 |
Goal DD Alias 3 |
Goal DD Alias 4 |
|
2000 |
CO |
MCU |
AN8 |
None |
|
2010 |
CO |
MCU |
PRP4 |
None |
|
2020 |
CO |
MCU |
None |
None |
|
2100 |
CO |
MCU |
AN8 |
PRP4 |
|
2110 |
CO |
MCU |
AN8 |
PRP4 |
|
2121 |
CO |
MCU |
PRP4 |
None |
|
2131 |
CO |
MCU |
PRP4 |
None |
|
2150 |
PRP4 |
None |
None |
None |
|
2200 |
CO |
MCU |
PRP4 |
None |
|
2201 |
CO |
MCU |
PRP4 |
None |
|
2300 |
CO |
MCU |
ITM |
None |
|
3502 |
CO |
MCU |
None |
None |
|
3503 |
CO |
MCU |
None |
None |
|
3504 |
CO |
MCU |
None |
None |
|
3505 |
CO |
MCU |
None |
None |
|
3506 |
CO |
MCU |
None |
None |
|
3507 |
CO |
MCU |
None |
None |
|
3508 |
CO |
MCU |
None |
None |
|
3509 |
CO |
MCU |
None |
None |
|
3510 |
CO |
MCU |
None |
None |
|
3511 |
CO |
MCU |
None |
None |
|
3512 |
CO |
MCU |
None |
None |

Dashboard Code Metric Cross Reference Table
This table lists the data that is prepopulated in the Dashboard Code Metric Cross Reference table (F80D301):
|
Dashboard Code |
Metric Identifier |
|
FMDB |
3301 |
|
FMDB |
3302 |
|
FMDB |
3303 |
|
FMDB |
3304 |
|
FMDB |
3305 |
|
FMDB |
3306 |
|
FMDB |
3307 |
|
FMDB |
3308 |
|
FMDB |
3309 |
|
FMDB |
3310 |
|
FMDB |
3311 |
|
FMDB |
3312 |
|
FMDB |
3313 |
|
FMDB |
3314 |
|
FMDB |
3344 |
|
FMDB |
3402 |
|
FMDB |
3403 |
|
FMDB |
3404 |
|
FMDB |
3405 |
|
FMDB |
3406 |
|
FMDB |
3407 |
|
FMDB |
3501 |
|
FMDB |
3502 |
|
FMDB |
3503 |
|
FMDB |
3504 |
|
FMDB |
3505 |
|
FMDB |
3506 |
|
FMDB |
3507 |
|
FMDB |
3508 |
|
FMDB |
3509 |
|
FMDB |
3510 |
|
FMDB |
3511 |
|
FMDB |
3512 |
|
FMDB |
3513 |
|
FMDB |
3514 |
|
FMDB |
3515 |
|
FMDB |
3516 |
|
FMDB |
3517 |
|
FMDB |
3518 |
|
PMDB |
2000 |
|
PMDB |
2010 |
|
PMDB |
2020 |
|
PMDB |
2100 |
|
PMDB |
2110 |
|
PMDB |
2111 |
|
PMDB |
2120 |
|
PMDB |
2121 |
|
PMDB |
2130 |
|
PMDB |
2131 |
|
PMDB |
2140 |
|
PMDB |
2150 |
|
PMDB |
2200 |
|
PMDB |
2201 |
|
PMDB |
2300 |
|
PMDB |
2310 |
|
PMDB |
2400 |
|
PMDB |
2410 |
|
PMDB |
2420 |
|
PMDB |
2430 |
|
PMDB |
2500 |
|
PMDB |
2510 |
|
PMDB |
2520 |

Metric Definition Table
This table lists the data that is prepopulated in the Metric Definition table (F80D303):
|
Metric Identifier |
Search By Code |
Presentation Type Code |
Chart ID |
Default Variant |
Being Updated (0 = No, 1 = Yes) |
Continuous Time Dimension (0 = No, 1 = Yes) |
Goal Yes/No (0 = No, 1 = Yes) |
Display Goal Yes/No (0 = No, 1 = Yes) |
|
2000 |
CBPA |
1 |
00108 |
2 |
0 |
0 |
1 |
1 |
|
2010 |
CBPA |
1 |
00108 |
27 |
0 |
0 |
1 |
1 |
|
2020 |
CBPA |
1 |
00108 |
12 |
0 |
1 |
1 |
1 |
|
2100 |
CBPA |
1 |
00107 |
3 |
0 |
1 |
1 |
1 |
|
2110 |
CBPA |
1 |
00107 |
3 |
0 |
0 |
1 |
1 |
|
2111 |
CBPA |
1 |
00105 |
0 |
0 |
0 |
0 |
0 |
|
2120 |
CBPA |
1 |
00100 |
11 |
0 |
1 |
0 |
0 |
|
2121 |
CBPA |
1 |
00108 |
11 |
0 |
1 |
1 |
1 |
|
2130 |
CBPA |
1 |
00100 |
11 |
0 |
1 |
0 |
0 |
|
2131 |
CBPA |
1 |
00108 |
11 |
0 |
1 |
1 |
1 |
|
2140 |
CBPA |
2 |
None |
4 |
0 |
0 |
0 |
0 |
|
2150 |
CBPA |
1 |
00108 |
10 |
0 |
1 |
1 |
1 |
|
2200 |
CBPA |
1 |
00108 |
27 |
0 |
0 |
1 |
1 |
|
2201 |
CBPA |
2 |
None |
27 |
0 |
0 |
1 |
1 |
|
2300 |
CBPA |
1 |
00107 |
14 |
0 |
0 |
1 |
1 |
|
2310 |
CBPA |
1 |
00103 |
11 |
0 |
0 |
0 |
0 |
|
2400 |
CBPA |
1 |
00100 |
13 |
0 |
1 |
0 |
0 |
|
2410 |
CBPA |
1 |
00100 |
1 |
0 |
1 |
0 |
0 |
|
2420 |
CBPA |
1 |
00100 |
1 |
0 |
1 |
0 |
0 |
|
2430 |
CBPA |
1 |
00100 |
14 |
0 |
1 |
0 |
0 |
|
2500 |
CBPA |
2 |
None |
6 |
0 |
0 |
0 |
0 |
|
2510 |
CBPA |
2 |
None |
7 |
0 |
0 |
0 |
0 |
|
2520 |
CBPA |
2 |
None |
8 |
0 |
0 |
0 |
0 |
|
3301 |
CBPA |
1 |
00102 |
31 |
0 |
1 |
0 |
0 |
|
3302 |
CBPA |
1 |
00102 |
31 |
0 |
1 |
0 |
0 |
|
3303 |
CBPA |
1 |
00102 |
31 |
0 |
1 |
0 |
0 |
|
3305 |
DCB |
1 |
00100 |
41 |
0 |
1 |
0 |
0 |
|
3306 |
DCB |
1 |
00100 |
61 |
0 |
1 |
0 |
0 |
|
3307 |
DCB |
1 |
00100 |
71 |
0 |
1 |
0 |
0 |
|
3308 |
DCB |
1 |
00100 |
81 |
0 |
1 |
0 |
0 |
|
3309 |
DCB |
1 |
00102 |
41 |
0 |
1 |
0 |
0 |
|
3310 |
DCB |
1 |
00102 |
41 |
0 |
1 |
0 |
0 |
|
3311 |
DCB |
1 |
00100 |
41 |
0 |
1 |
0 |
0 |
|
3312 |
DCB |
1 |
00100 |
41 |
0 |
1 |
0 |
0 |
|
3313 |
DCB |
1 |
00106 |
31 |
0 |
1 |
1 |
1 |
|
3314 |
DCB |
1 |
00105 |
0 |
0 |
1 |
0 |
0 |
|
3344 |
DCB |
1 |
00102 |
41 |
0 |
1 |
0 |
0 |
|
3402 |
DCB |
1 |
00102 |
41 |
0 |
0 |
0 |
0 |
|
3403 |
DCB |
1 |
00102 |
41 |
0 |
0 |
0 |
0 |
|
3404 |
CBPA |
1 |
00100 |
31 |
0 |
1 |
0 |
0 |
|
3405 |
CBPA |
1 |
00100 |
31 |
0 |
1 |
0 |
0 |
|
3406 |
DCB |
1 |
00100 |
31 |
0 |
1 |
0 |
0 |
|
3407 |
CBPA |
1 |
00100 |
31 |
0 |
1 |
0 |
0 |
|
3501 |
DCB |
1 |
00103 |
31 |
0 |
1 |
1 |
0 |
|
3502 |
DCB |
1 |
00108 |
91 |
0 |
1 |
1 |
1 |
|
3503 |
DCB |
1 |
00108 |
91 |
0 |
1 |
1 |
1 |
|
3504 |
DCB |
1 |
00108 |
91 |
0 |
1 |
1 |
1 |
|
3505 |
DCB |
1 |
00108 |
91 |
0 |
1 |
1 |
1 |
|
3506 |
DCB |
1 |
00108 |
91 |
0 |
1 |
1 |
1 |
|
3507 |
DCB |
1 |
00108 |
91 |
0 |
1 |
1 |
1 |
|
3508 |
DCB |
1 |
00108 |
91 |
0 |
1 |
1 |
1 |
|
3509 |
DCB |
1 |
00108 |
91 |
0 |
1 |
1 |
1 |
|
3510 |
DCB |
1 |
00108 |
91 |
0 |
1 |
1 |
1 |
|
3511 |
DCB |
1 |
00108 |
91 |
0 |
1 |
1 |
1 |
|
3512 |
DCB |
1 |
00108 |
91 |
0 |
1 |
1 |
1 |
|
3513 |
DCB |
1 |
00103 |
91 |
0 |
1 |
0 |
0 |
|
3514 |
DCB |
1 |
00103 |
91 |
0 |
1 |
0 |
0 |
|
3515 |
DCB |
1 |
00103 |
91 |
0 |
1 |
0 |
0 |
|
3516 |
DCB |
1 |
00103 |
91 |
0 |
1 |
0 |
0 |
|
3517 |
DCB |
1 |
00103 |
91 |
0 |
1 |
0 |
0 |
|
3518 |
DCB |
1 |
00103 |
91 |
0 |
1 |
0 |
0 |

Variant Definition Table
This table lists the data that is prepopulated in the Variant Definition table (F80D304):
|
Variant ID |
Line Number |
Hierarchy ID |
Line Number |
Group By Alias Code |
Default Group By |
Time Dimension |
|
1 |
0.001 |
100 |
1 |
DATE |
1 |
5 |
|
1 |
0.002 |
101 |
1 |
CO |
0 |
5 |
|
1 |
0.003 |
102 |
1 |
MCU |
0 |
5 |
|
1 |
0.004 |
103 |
1 |
AN8 |
0 |
5 |
|
1 |
0.005 |
104 |
1 |
PRP4 |
0 |
5 |
|
1 |
0.006 |
150 |
1 |
ITM |
0 |
5 |
|
2 |
0.001 |
200 |
1 |
DATE |
1 |
4 |
|
2 |
0.002 |
210 |
1 |
CO |
0 |
4 |
|
2 |
0.003 |
211 |
1 |
MCU |
0 |
4 |
|
2 |
0.004 |
212 |
1 |
AN8 |
0 |
4 |
|
3 |
0.001 |
300 |
1 |
DATE |
1 |
5 |
|
3 |
0.002 |
110 |
1 |
CO |
0 |
5 |
|
3 |
0.003 |
120 |
1 |
MCU |
0 |
5 |
|
3 |
0.004 |
130 |
1 |
AN8 |
0 |
5 |
|
3 |
0.005 |
140 |
1 |
PRP4 |
0 |
5 |
|
4 |
0.001 |
0 |
1 |
DATE |
1 |
5 |
|
4 |
0.002 |
0 |
1 |
CO |
0 |
5 |
|
4 |
0.003 |
0 |
1 |
MCU |
0 |
5 |
|
4 |
0.004 |
0 |
1 |
PRP4 |
0 |
5 |
|
4 |
0.005 |
0 |
1 |
ITM |
0 |
5 |
|
6 |
0.001 |
0 |
1 |
AN8 |
1 |
0 |
|
7 |
0.001 |
400 |
1 |
ITM |
1 |
0 |
|
7 |
0.002 |
212 |
1 |
AN8 |
0 |
0 |
|
8 |
0.001 |
800 |
1 |
AN8 |
1 |
0 |
|
8 |
0.002 |
150 |
1 |
ITM |
0 |
0 |
|
10 |
0.001 |
0 |
1 |
PRP4 |
1 |
0 |
|
11 |
0.001 |
900 |
1 |
DATE |
1 |
5 |
|
11 |
0.002 |
901 |
1 |
CO |
0 |
5 |
|
11 |
0.003 |
902 |
1 |
MCU |
0 |
5 |
|
11 |
0.004 |
140 |
1 |
PRP4 |
0 |
5 |
|
12 |
0.001 |
1000 |
1 |
DATE |
1 |
4 |
|
12 |
0.002 |
1101 |
1 |
CO |
0 |
4 |
|
12 |
0.003 |
1102 |
1 |
MCU |
0 |
4 |
|
13 |
0.001 |
1100 |
1 |
DATE |
1 |
5 |
|
13 |
0.002 |
1103 |
1 |
CO |
0 |
5 |
|
13 |
0.003 |
1810 |
1 |
MCU |
0 |
5 |
|
13 |
0.004 |
1820 |
1 |
PRP4 |
0 |
5 |
|
13 |
0.005 |
800 |
1 |
AN8 |
0 |
5 |
|
13 |
0.006 |
150 |
1 |
ITM |
0 |
5 |
|
14 |
0.001 |
600 |
1 |
DATE |
1 |
5 |
|
14 |
0.002 |
601 |
1 |
CO |
0 |
5 |
|
14 |
0.003 |
602 |
1 |
MCU |
0 |
5 |
|
14 |
0.004 |
104 |
1 |
PRP4 |
0 |
5 |
|
14 |
0.005 |
150 |
1 |
ITM |
0 |
5 |
|
17 |
0.001 |
1600 |
1 |
DATE |
1 |
4 |
|
17 |
0.002 |
211 |
1 |
MCU |
0 |
4 |
|
17 |
0.003 |
212 |
1 |
AN8 |
0 |
4 |
|
18 |
0.001 |
1700 |
1 |
DATE |
1 |
5 |
|
18 |
0.002 |
120 |
1 |
MCU |
0 |
5 |
|
18 |
0.003 |
130 |
1 |
AN8 |
0 |
5 |
|
18 |
0.004 |
140 |
1 |
PRP4 |
0 |
5 |
|
19 |
0.001 |
0 |
1 |
DATE |
1 |
5 |
|
19 |
0.002 |
0 |
1 |
MCU |
0 |
5 |
|
19 |
0.003 |
0 |
1 |
PRP4 |
0 |
5 |
|
19 |
0.004 |
0 |
1 |
ITM |
0 |
5 |
|
20 |
0.001 |
1800 |
1 |
DATE |
1 |
5 |
|
20 |
0.002 |
1810 |
1 |
MCU |
0 |
5 |
|
20 |
0.003 |
1820 |
1 |
PRP4 |
0 |
5 |
|
20 |
0.004 |
800 |
1 |
AN8 |
0 |
5 |
|
20 |
0.005 |
150 |
1 |
ITM |
0 |
5 |
|
21 |
0.001 |
1500 |
1 |
DATE |
1 |
5 |
|
21 |
0.002 |
102 |
1 |
MCU |
0 |
5 |
|
21 |
0.003 |
103 |
1 |
AN8 |
0 |
5 |
|
21 |
0.004 |
104 |
1 |
PRP4 |
0 |
5 |
|
21 |
0.005 |
150 |
1 |
ITM |
0 |
5 |
|
22 |
0.001 |
1900 |
1 |
DATE |
1 |
5 |
|
22 |
0.002 |
902 |
1 |
MCU |
0 |
5 |
|
22 |
0.003 |
140 |
1 |
PRP4 |
0 |
5 |
|
23 |
0.001 |
2000 |
1 |
DATE |
1 |
4 |
|
23 |
0.002 |
1102 |
1 |
MCU |
0 |
4 |
|
25 |
0.001 |
500 |
1 |
DATE |
1 |
5 |
|
25 |
0.002 |
602 |
1 |
MCU |
0 |
5 |
|
25 |
0.003 |
104 |
1 |
PRP4 |
0 |
5 |
|
25 |
0.004 |
150 |
1 |
ITM |
0 |
5 |
|
26 |
0.001 |
700 |
1 |
DATE |
1 |
4 |
|
26 |
0.002 |
902 |
1 |
MCU |
0 |
4 |
|
26 |
0.003 |
140 |
1 |
PRP4 |
0 |
4 |
|
27 |
0.001 |
1400 |
1 |
DATE |
1 |
4 |
|
27 |
0.002 |
901 |
1 |
CO |
0 |
4 |
|
27 |
0.003 |
902 |
1 |
MCU |
0 |
4 |
|
27 |
0.004 |
140 |
1 |
PRP4 |
0 |
4 |
|
28 |
0.001 |
1100 |
1 |
DATE |
1 |
3 |
|
28 |
0.002 |
0 |
1 |
CO |
0 |
3 |
|
28 |
0.003 |
0 |
1 |
MCU |
0 |
3 |
|
28 |
0.004 |
0 |
1 |
PRP4 |
0 |
3 |
|
28 |
0.005 |
0 |
1 |
AN8 |
0 |
3 |
|
28 |
0.006 |
0 |
1 |
ITM |
0 |
3 |
|
31 |
0.001 |
301 |
1 |
DATE |
1 |
5 |
|
31 |
0.002 |
302 |
2 |
CO |
0 |
0 |
|
31 |
0.003 |
303 |
3 |
MCU |
0 |
0 |
|
41 |
0.001 |
401 |
1 |
DATE |
1 |
5 |
|
41 |
0.002 |
302 |
1 |
CO |
0 |
0 |
|
41 |
0.003 |
303 |
1 |
MCU |
0 |
0 |
|
91 |
0.001 |
910 |
1 |
DATE |
1 |
3 |
|
91 |
0.002 |
911 |
2 |
CO |
0 |
0 |
|
91 |
0.003 |
912 |
3 |
MCU |
0 |
0 |

Hierarchy Definition Table
This table lists the data that is prepopulated in the Hierarchy Definition table (F80D305):
|
Hierarchy ID |
Line Number |
Data Dictionary Alias Lookup |
Time Dimension |
|
100 |
1 |
DATE |
5 |
|
100 |
2 |
CO |
0 |
|
100 |
3 |
MCU |
0 |
|
100 |
4 |
AN8 |
0 |
|
100 |
5 |
PRP4 |
0 |
|
100 |
6 |
ITM |
0 |
|
101 |
1 |
CO |
0 |
|
101 |
2 |
MCU |
0 |
|
101 |
3 |
AN8 |
0 |
|
101 |
4 |
PRP4 |
0 |
|
101 |
5 |
ITM |
0 |
|
102 |
1 |
MCU |
0 |
|
102 |
2 |
AN8 |
0 |
|
102 |
3 |
PRP4 |
0 |
|
102 |
4 |
ITM |
0 |
|
103 |
1 |
AN8 |
0 |
|
103 |
2 |
PRP4 |
0 |
|
103 |
3 |
ITM |
0 |
|
104 |
1 |
PRP4 |
0 |
|
104 |
2 |
ITM |
0 |
|
110 |
1 |
CO |
0 |
|
110 |
2 |
MCU |
0 |
|
110 |
3 |
AN8 |
0 |
|
110 |
4 |
PRP4 |
0 |
|
120 |
1 |
MCU |
0 |
|
120 |
2 |
AN8 |
0 |
|
120 |
3 |
PRP4 |
0 |
|
130 |
1 |
AN8 |
0 |
|
130 |
2 |
PRP4 |
0 |
|
140 |
1 |
PRP4 |
0 |
|
150 |
1 |
ITM |
0 |
|
200 |
1 |
DATE |
4 |
|
200 |
2 |
CO |
0 |
|
200 |
3 |
MCU |
0 |
|
200 |
4 |
AN8 |
0 |
|
210 |
1 |
CO |
0 |
|
210 |
2 |
MCU |
0 |
|
210 |
3 |
AN8 |
0 |
|
211 |
1 |
MCU |
0 |
|
211 |
2 |
AN8 |
0 |
|
212 |
1 |
AN8 |
0 |
|
300 |
1 |
DATE |
5 |
|
300 |
2 |
CO |
0 |
|
300 |
3 |
MCU |
0 |
|
300 |
4 |
AN8 |
0 |
|
300 |
5 |
PRP4 |
0 |
|
301 |
1 |
DATE |
5 |
|
301 |
2 |
CO |
0 |
|
301 |
3 |
MCU |
0 |
|
302 |
1 |
CO |
0 |
|
302 |
2 |
MCU |
0 |
|
303 |
1 |
MCU |
0 |
|
400 |
1 |
ITM |
0 |
|
400 |
2 |
AN8 |
0 |
|
401 |
1 |
DATE |
1 |
|
401 |
2 |
CO |
0 |
|
401 |
3 |
MCU |
0 |
|
500 |
1 |
DATE |
5 |
|
500 |
2 |
MCU |
0 |
|
500 |
3 |
PRP4 |
0 |
|
500 |
4 |
ITM |
0 |
|
600 |
1 |
DATE |
5 |
|
600 |
2 |
CO |
0 |
|
600 |
3 |
MCU |
0 |
|
600 |
4 |
PRP4 |
0 |
|
600 |
5 |
ITM |
0 |
|
601 |
1 |
CO |
0 |
|
601 |
2 |
MCU |
0 |
|
601 |
3 |
PRP4 |
0 |
|
601 |
4 |
ITM |
0 |
|
602 |
1 |
MCU |
0 |
|
602 |
2 |
PRP4 |
0 |
|
602 |
3 |
ITM |
0 |
|
700 |
1 |
DATE |
4 |
|
700 |
2 |
MCU |
0 |
|
700 |
3 |
PRP4 |
0 |
|
800 |
1 |
AN8 |
0 |
|
800 |
2 |
ITM |
0 |
|
900 |
1 |
DATE |
5 |
|
900 |
2 |
CO |
0 |
|
900 |
3 |
MCU |
0 |
|
900 |
4 |
PRP4 |
0 |
|
901 |
1 |
CO |
0 |
|
901 |
2 |
MCU |
0 |
|
901 |
3 |
PRP4 |
0 |
|
902 |
1 |
MCU |
0 |
|
902 |
2 |
PRP4 |
0 |
|
1000 |
1 |
DATE |
4 |
|
1000 |
2 |
CO |
0 |
|
1000 |
3 |
MCU |
0 |
|
1100 |
1 |
DATE |
5 |
|
1100 |
2 |
CO |
0 |
|
1100 |
3 |
MCU |
0 |
|
1100 |
4 |
PRP4 |
0 |
|
1100 |
5 |
AN8 |
0 |
|
1100 |
6 |
ITM |
0 |
|
1101 |
1 |
CO |
0 |
|
1101 |
2 |
MCU |
0 |
|
1102 |
1 |
MCU |
0 |
|
1103 |
1 |
CO |
0 |
|
1103 |
2 |
MCU |
0 |
|
1103 |
3 |
PRP4 |
0 |
|
1103 |
4 |
AN8 |
0 |
|
1103 |
5 |
ITM |
0 |
|
1200 |
1 |
DATE |
4 |
|
1200 |
2 |
MCU |
0 |
|
1200 |
3 |
PRP4 |
0 |
|
1400 |
1 |
DATE |
4 |
|
1400 |
2 |
CO |
0 |
|
1400 |
3 |
MCU |
0 |
|
1400 |
4 |
PRP4 |
0 |
|
1500 |
1 |
DATE |
5 |
|
1500 |
2 |
MCU |
0 |
|
1500 |
3 |
AN8 |
0 |
|
1500 |
4 |
PRP4 |
0 |
|
1500 |
5 |
ITM |
0 |
|
1600 |
1 |
DATE |
4 |
|
1600 |
2 |
MCU |
0 |
|
1600 |
3 |
AN8 |
0 |
|
1700 |
1 |
DATE |
5 |
|
1700 |
2 |
MCU |
0 |
|
1700 |
3 |
AN8 |
0 |
|
1700 |
4 |
PRP4 |
0 |
|
1800 |
1 |
DATE |
5 |
|
1800 |
2 |
MCU |
0 |
|
1800 |
3 |
PRP4 |
0 |
|
1800 |
4 |
AN8 |
0 |
|
1800 |
5 |
ITM |
0 |
|
1810 |
1 |
MCU |
0 |
|
1810 |
2 |
PRP4 |
0 |
|
1810 |
3 |
AN8 |
0 |
|
1810 |
4 |
ITM |
0 |
|
1820 |
1 |
PRP4 |
0 |
|
1820 |
2 |
AN8 |
0 |
|
1820 |
3 |
ITM |
0 |
|
1900 |
1 |
DATE |
5 |
|
1900 |
2 |
MCU |
0 |
|
1900 |
3 |
PRP4 |
0 |
|
2000 |
1 |
DATE |
4 |
|
2000 |
2 |
MCU |
0 |

Action Definition Table
This table lists the data that is prepopulated in the Action Definition table (F80D306):
|
Action ID |
Object Name |
Form Name |
I M |
Version |
|
4 |
P4210 |
W4210H |
1 |
ZJDE0001 |
|
5 |
P31022 |
W31022A |
1 |
ZJDE0001 |
|
6 |
P41112 |
W41112A |
1 |
ZJDE0001 |
|
7 |
P31225 |
W31225D |
1 |
ZJDE0001 |
|
8 |
P42117 |
W42117M |
1 |
ZJDE0001 |
|
9 |
P43250 |
W43250K |
1 |
ZJDE0001 |
|
10 |
P03B16 |
W03B16E |
1 |
None |
|
11 |
P0411 |
W0411G |
1 |
ZJDE0001 |
|
203 |
P03B2002 |
W03B2002A |
1 |
ZJDE0001 |
|
220 |
P0411 |
W0411G |
1 |
ZJDE0001 |
|
246 |
P0413M |
W0413MB |
1 |
ZJDE0001 |
|
271 |
P01012 |
W01012B |
1 |
ZJDE0001 |
|
297 |
P0801 |
W0801A |
1 |
None |

Metric Action Cross Reference Table
This table lists the data that is prepopulated in the Metric Action Cross Reference table (F80D307):
|
Action ID |
Metric Identifier |
|
4 |
2000 |
|
10 |
2000 |
|
11 |
2010 |
|
4 |
2020 |
|
6 |
2020 |
|
10 |
2020 |
|
11 |
2020 |
|
4 |
2100 |
|
5 |
2100 |
|
4 |
2110 |
|
4 |
2111 |
|
4 |
2120 |
|
4 |
2121 |
|
8 |
2130 |
|
8 |
2131 |
|
4 |
2140 |
|
4 |
2150 |
|
6 |
2200 |
|
6 |
2201 |
|
7 |
2300 |
|
5 |
2310 |
|
4 |
2400 |
|
4 |
2410 |
|
4 |
2430 |
|
8 |
2430 |
|
9 |
2500 |
|
9 |
2510 |
|
9 |
2520 |
|
203 |
3311 |
|
203 |
3312 |
|
220 |
3404 |
|
246 |
3404 |
|
11 |
3405 |
|
246 |
3405 |

Alert Definition Table
This table lists the data that is prepopulated in the Alert Definition table (F80D310):
|
Alert Identifier |
Alert Source |
Alert Type |
Active Status |
|
1000 |
1 |
3 |
0 |
|
2010 |
1 |
5 |
0 |
|
2020 |
1 |
5 |
0 |
|
2030 |
1 |
5 |
0 |
|
2040 |
1 |
5 |
0 |
|
2050 |
1 |
5 |
0 |

Dashboard Configuration Table
This table lists the data that is prepopulated in the Dashboard Configuration table (F80D320):
|
Configuration ID |
Dashboard Code |
Subscription ID |
|
FMDDEFAULT |
FMDB |
0 |
|
PMDDEFAULT |
PMBD |
0 |

UI Metric Group Definition Table
This table lists the data that is prepopulated in the UI Metric Group Definition table (F80D321):
|
Configuration ID |
Metric Group ID |
Default Yes No |
|
FMDDEFAULT |
ACAPF |
0 |
|
FMDDEFAULT |
ACTR |
0 |
|
FMDDEFAULT |
APACT |
0 |
|
FMDDEFAULT |
ARCLA |
1 |
|
FMDDEFAULT |
LEVLQ |
0 |
|
FMDDEFAULT |
PROFR |
0 |
|
FMDDEFAULT |
PROFT |
0 |
|
FMDDEFAULT |
REVRN |
0 |
|
PMDDEFAULT |
CASHC |
1 |
|
PMDDEFAULT |
CUSTS |
0 |
|
PMDDEFAULT |
INVEF |
0 |
|
PMDDEFAULT |
MANUP |
0 |
|
PMDDEFAULT |
REVMG |
0 |
|
PMDDEFAULT |
SUPPP |
0 |

UI Metric Group Detail Table
This table lists the data that is prepopulated in the UI Metric Group Detail table (F80D322):
|
Metric Group ID |
Display Seq |
Metric Identifier |
Variant ID |
Continuous Time Dimension |
Display Goal Yes/No |
|
ACAPF |
1 |
3516 |
35 |
1 |
0 |
|
ACAPF |
2 |
3517 |
36 |
1 |
0 |
|
ACAPF |
3 |
3518 |
37 |
1 |
0 |
|
ACTR |
1 |
3511 |
31 |
1 |
0 |
|
ACTR |
2 |
3510 |
31 |
1 |
0 |
|
ACTR |
3 |
3512 |
31 |
1 |
0 |
|
APACT |
1 |
3402 |
41 |
1 |
0 |
|
APACT |
2 |
3406 |
41 |
1 |
0 |
|
APACT |
3 |
3404 |
31 |
1 |
0 |
|
APACT |
4 |
3400 |
31 |
1 |
0 |
|
APACT |
5 |
3407 |
41 |
1 |
0 |
|
APACT |
6 |
3403 |
41 |
1 |
0 |
|
APACT |
7 |
3405 |
31 |
1 |
0 |
|
APACT |
8 |
3401 |
31 |
1 |
0 |
|
ARCLA |
1 |
3316 |
33 |
1 |
0 |
|
ARCLA |
2 |
3315 |
32 |
1 |
0 |
|
ARCLA |
3 |
3301 |
31 |
1 |
0 |
|
ARCLA |
4 |
3302 |
31 |
1 |
0 |
|
ARCLA |
5 |
3303 |
31 |
1 |
0 |
|
ARCLA |
6 |
3309 |
41 |
1 |
0 |
|
ARCLA |
7 |
3310 |
41 |
1 |
0 |
|
ARCLA |
8 |
3311 |
31 |
1 |
0 |
|
ARCLA |
9 |
3312 |
0 |
1 |
0 |
|
ARCLA |
10 |
3313 |
51 |
1 |
0 |
|
ARCLA |
11 |
3314 |
61 |
1 |
0 |
|
ARCLA |
12 |
3305 |
71 |
1 |
0 |
|
ARCLA |
13 |
3306 |
41 |
1 |
0 |
|
ARCLA |
14 |
3307 |
71 |
1 |
0 |
|
ARCLA |
15 |
3308 |
41 |
1 |
0 |
|
CASHC |
1 |
2000 |
2 |
1 |
0 |
|
CASHC |
2 |
2010 |
27 |
1 |
0 |
|
CASHC |
3 |
2200 |
27 |
1 |
0 |
|
CASHC |
4 |
2020 |
12 |
1 |
0 |
|
CUSTS |
1 |
2111 |
0 |
1 |
0 |
|
CUSTS |
2 |
2110 |
3 |
1 |
0 |
|
CUSTS |
3 |
2140 |
4 |
1 |
0 |
|
CUSTS |
4 |
2100 |
3 |
1 |
0 |
|
CUSTS |
5 |
2121 |
11 |
1 |
0 |
|
CUSTS |
6 |
2120 |
11 |
1 |
0 |
|
CUSTS |
7 |
2131 |
11 |
1 |
0 |
|
CUSTS |
8 |
2130 |
11 |
1 |
0 |
|
CUSTS |
9 |
2150 |
10 |
1 |
0 |
|
INVEF |
1 |
2201 |
27 |
1 |
0 |
|
LEVLQ |
1 |
3506 |
31 |
1 |
0 |
|
LEVLQ |
2 |
3507 |
31 |
1 |
0 |
|
LEVLQ |
3 |
3509 |
31 |
1 |
0 |
|
LEVLQ |
4 |
3508 |
31 |
1 |
0 |
|
MANUP |
1 |
2300 |
14 |
1 |
0 |
|
MANUP |
2 |
2310 |
11 |
1 |
0 |
|
PROFR |
1 |
3503 |
31 |
1 |
0 |
|
PROFR |
2 |
3502 |
31 |
1 |
0 |
|
PROFR |
3 |
3505 |
31 |
1 |
0 |
|
PROFR |
4 |
3504 |
31 |
1 |
0 |
|
PROFT |
1 |
3501 |
31 |
1 |
0 |
|
PROFT |
2 |
3513 |
91 |
1 |
0 |
|
PROFT |
3 |
3514 |
91 |
1 |
0 |
|
PROFT |
4 |
3515 |
91 |
1 |
0 |
|
REVMG |
1 |
2400 |
13 |
1 |
0 |
|
REVMG |
2 |
2410 |
1 |
1 |
0 |
|
REVMG |
3 |
2430 |
14 |
1 |
0 |
|
REVMG |
4 |
2420 |
1 |
1 |
0 |
|
SUPPP |
1 |
2500 |
6 |
1 |
0 |
|
SUPPP |
2 |
2520 |
8 |
1 |
0 |
|
SUPPP |
3 |
2510 |
7 |
1 |
0 |