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 |