This appendix lists the tables used by the JD Edwards EnterpriseOne Console and lists prepopulated tables.
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 |
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.
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |