This appendix contains the following topics:
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 |