## Appendix: Appendix: JD Edwards EnterpriseOne Plant Manager's Dashboard Table Mappings

This appendix lists the table mappings for JD Edwards EnterpriseOne Plant Manager's Dashboard (PMD):

See Also

Monitoring Operational Metrics

### Table Mappings for JD Edwards EnterpriseOne Plant Manager's Dashboard

Tables from other JD Edwards EnterpriseOne systems are the source tables for many of the JD Edwards EnterpriseOne Plant Manager's Dashboard tables.

#### Sales Order Fact Table

This table lists the Sales Order Fact table (F80D010) Data Dictionary (DD) items, the source tables and fields, and additional information about the DD items:

DD Item | DD Item Description | Key | Source Table | Source Table DD Item | Additional Information
DOCO | Order Number | Y | Sales Order Detail File (F4211) | DOCO |
DCTO | Order Type | Y | Sales Order Detail File (F4211) | DCTO |
KCOO | Order Company | Y | Sales Order Detail File (F4211) | KCOO |
LNID | Line Number | Y | Sales Order Detail File (F4211) | LNID |
AN8 | Address Number |  | Sales Order Detail File (F4211) | AN8 |
ITM | Short Item Number |  | Sales Order Detail File (F4211) | ITM |
MCU | Business Unit |  | Sales Order Detail File (F4211) | MCU |
EMCU | Header Business Unit |  | Sales Order Detail File (F4211) | EMCU |
CO | Company |  |  |  | Lookup to the Business Unit Master table (F0006) for DD Item EMCU then get associated company.
SHAN | Ship To Number |  | Sales Order Detail File (F4211) | SHAN |
AEXP | Extended Price |  | Sales Order Detail File (F4211) | AEXP |
CAEXP | Extended Amount |  |  |  | Calculated field which will include additional charges such as detached adjustments.
CBACK | Backorder Amount |  |  |  | Calculated field which will not include additional charges.
CADTC | Additional Charge |  |  |  | Calculated field which will include additional charges. CADTC is for information only.
SOQS | Quantity Shipped |  | Sales Order Detail File (F4211) | SOQS |
SOBK | Quantity Backordered |  | Sales Order Detail File (F4211) | SOBK |
UOM | Transaction Unit of Measure |  | Sales Order Detail File (F4211) | UOM |
UOM1 | Primary Unit of Measure |  | Sales Order Detail File (F4211) | UOM1 |
TRDJ | Order Date |  | Sales Order Detail File (F4211) | TRDJ |
DRQJ | Request Date |  | Sales Order Detail File (F4211) | DRQJ |
PDDJ | Scheduled Pick Date |  | Sales Order Detail File (F4211) | PDDJ |
RSDJ | Promised Delivery Date |  | Sales Order Detail File (F4211) | RSDJ |
IVD | Invoice Date |  | Sales Order Detail File (F4211) | IVD |
PPDJ | Promised Ship Date |  | Sales Order Detail File (F4211) | PPDJ |
ADDJ | Actual Ship Date |  | Sales Order Detail File (F4211) | ADDJ |
CNDJ | Cancel Date |  | Sales Order Detail File (F4211) | CNDJ |
DGL | GL Date |  | Sales Order Detail File (F4211) | DGL |
LTTR | Last Status |  | Sales Order Detail File (F4211) | LTTR |
NXTR | Next Status |  | Sales Order Detail File (F4211) | NXTR |
CRCD | Currency Code |  | Sales Order Detail File (F4211) | CRCD | Calculated field which will be converted to the default data currency code.
USER | User ID |  |  |  | Calculated field for audit information.
PID | Program ID |  |  |  | Calculated field for audit information.
MKEY | Machine Key |  |  |  | Calculated field for audit information.
UTIME | Update Date and Time |  |  |  | Calculated field for audit information.
URCD | User Reserve Code |  |  |  |
URDT | User Reserve Date |  |  |  |
URAT | User Reserve Amount |  |  |  |
URAB | User Reserve Number |  |  |  |
URRF | User Reserve Reference |  |  |  |

#### Days Sales Outstanding Aggregate Table

This table lists the Days Sales Outstanding Aggregate table (F80D200) Data Dictionary (DD) items, the source tables and fields, and information about DD items:

DD Item | DD Item Description | Key | Source Table | Source Table DD Item | Additional Information
PRDJ | Processing Date | Y |  |  | Current date
MCU | Business Unit | Y | Customer Ledger (F03B11) | MCU |
AN8 | Address Number | Y | Customer Ledger (F03B11) | AN8 |
AAP | Open Amount |  |  |  | Calculated field which can require currency conversion.
PDSO | Days Sales Outstanding |  |  |  | Calculated field
ADS | Average Daily Sales |  |  |  | Calculated field
USER | User ID |  |  |  | Calculated field for audit information.
PID | Program ID |  |  |  | Calculated field for audit information.
MKEY | Machine Key |  |  |  | Calculated field for audit information.
UTIME | Update Date and Time |  |  |  | Calculated field for audit information.
URCD | User Reserved Code |  |  |  |
URDT | User Reserved Date |  |  |  |
URAT | User Reserved Amount |  |  |  |
URAB | User Reserved Number |  |  |  |
URRF | User Reserved Reference |  |  |  |

#### Days Payable Outstanding Aggregate Table

This table lists the Days Payable Outstanding Aggregate table (F80D201) Data Dictionary (DD) items, the source tables and fields, and information about DD items:

DD Item | DD Item Description | Key | Source Table | Source Table DD Item | Additional Information
PRDJ | Processing Date | Y | Accounts Payable Ledger (F0411) | DGJ |
MCU | Business Unit | Y | Accounts Payable Ledger (F0411) | MCU |
ITM | Short Item Number | Y | Accounts Payable Ledger (F0411) | ITM |
COGS | Cost of Goods Sold |  | General Ledger Aggregate (F80D221) | AA | Calculated field is the total amount for the selected accounts over the last 12 months.
PDPO | Days Payable Outstanding |  |  |  | Calculated field
USER | User ID |  |  |  | Calculated field for audit information.
PID | Program ID |  |  |  | Calculated field for audit information.
MKEY | Machine Key |  |  |  | Calculated field for audit information.
UTIME | Update Date and Time |  |  |  | Calculated field for audit information.
URCD | User Reserved Code |  |  |  |
URDT | User Reserved Date |  |  |  |
URAT | User Reserved Amount |  |  |  |
URAB | User Reserved Number |  |  |  |
URRF | User Reserved Reference |  |  |  |

#### Cash to Cash Cycle Time Aggregate Table

This table lists the Cash to Cash Cycle Time Aggregate table (F80D202) Data Dictionary (DD) items, the source tables and fields, and information about DD items:

DD Item | DD Item Description | Key | Source Table | Source Table DD Item | Additional Information
PRDJ | Processing Date | Y |  |  | Current date
MCU | Business Unit | Y | Days Sales Outstanding Aggregate (F80D200) | MCU |
PDSO | Days Sales Outstanding |  | Days Sales Outstanding Aggregate (F80D200) | PDSO | Average aggregated
PDSI | Days Sales in Inventory |  | Inventory Aggregate (F80D220) | PDSI | Average aggregated
PDPO | Days Payable Outstanding |  | Days Payable Outstanding Aggregate (F80D201) | PDPO | Average aggregated
CCCT | Cash to Cash Cycle Time |  |  |  | Calculated field
USER | User ID |  |  |  | Calculated field for audit information.
PID | Program ID |  |  |  | Calculated field for audit information.
MKEY | Machine Key |  |  |  | Calculated field for audit information.
UTIME | Update Date and Time |  |  |  | Calculated field for audit information.
URCD | User Reserved Code |  |  |  |
URDT | User Reserved Date |  |  |  |
URAT | User Reserved Amount |  |  |  |
URAB | User Reserved Number |  |  |  |
URRF | User Reserved Reference |  |  |  |

#### On Time Shipment Customer Request Date Aggregate Table

This table lists the On Time Shipment Customer Request Date Aggregate table (F80D210) Data Dictionary (DD) items, the source tables and fields, and information about DD items:

DD Item | DD Item Description | Key | Source Table | Source Table DD Item | Additional Information
PRDJ | Processing Date | Y | Sales Order Fact (F80D010) | ADDJ |
MCU | Business Unit | Y | Sales Order Fact (F80D010) | MCU |
AN8 | Address Number | Y | Sales Order Fact (F80D010) | AN8 |
ITM | Short Item Number | Y | Sales Order Fact (F80D010) | ITM |
EYCT | Early Sales Order Count |  |  |  | Calculated field
OTCT | On Time Sakes Order Count |  |  |  | Calculated field
LATECT | Late Sales Order Count |  |  |  | Calculated field
USER | User ID |  |  |  | Calculated field for audit information.
PID | Program ID |  |  |  | Calculated field for audit information.
MKEY | Machine Key |  |  |  | Calculated field for audit information.
UTIME | Update Date and Time |  |  |  | Calculated field for audit information.
URCD | User Reserve Code |  |  |  |
URDT | User Reserve Date |  |  |  |
URAT | User Reserve Amount |  |  |  |
URAB | User Reserve Number |  |  |  |
URRF | User Reserve Reference |  |  |  |

#### On Time Shipment Promise Ship Date Aggregate Table

This table lists the On Time Shipment Promise Ship Date Aggregate table (F80D211) Data Dictionary (DD) items, the source tables and fields, and information about DD items:

DD Item | DD Item Description | Key | Source Table | Source Table DD Item | Additional Information
PRDJ | Processing Date | Y | Sales Order Fact (F80D010) | ADDJ |
MCU | Business Unit | Y | Sales Order Fact (F80D010) | MCU |
AN8 | Address Number | Y | Sales Order Fact (F80D010) | AN8 |
ITM | Short Item Number | Y | Sales Order Fact (F80D010) | ITM |
EYCT | Early Sales Order Count |  |  |  | Calculated field
OTCT | On Time Sales Order Count |  |  |  | Calculated field
LATECT | Late Sales Order Count |  |  |  | Calculated field
USER | User ID |  |  |  | Calculated field for audit information.
PID | Program ID |  |  |  | Calculated field for audit information.
MKEY | Machine Key |  |  |  | Calculated field for audit information.
UTIME | Update Date and Time |  |  |  | Calculated field for audit information.
URCD | User Reserve Code |  |  |  |
URDT | User Reserve Date |  |  |  |
URAT | User Reserve Amount |  |  |  |
URAB | User Reserve Number |  |  |  |
URRF | User Reserve Reference |  |  |  |

#### Past Due Aggregate Table

This table lists the Past Due Aggregate table (F80D212) Data Dictionary (DD) items, the source tables and fields, and information about DD items:

DD Item | DD Item Description | Key | Source Table | Source Table DD Item | Additional Information
PRDJ | Processing Date | Y | Sales Order Fact (F80D010) | ADDJ |
MCU | Business Unit | Y | Sales Order Fact (F80D010) | MCU |
ITM | Short Item Number | Y | Sales Order Fact (F80D010) | ITM |
PDUEAA | Past Due Amount |  |  |  | Calculated field
PDUECT | Past Due Line Count |  |  |  | Calculated field
USER | User ID |  |  |  | Calculated field for audit information.
PID | Program ID |  |  |  | Calculated field for audit information.
MKEY | Machine Key |  |  |  | Calculated field for audit information.
UTIME | Update Date and Time |  |  |  | Calculated field for audit information.
URCD | User Reserve Code |  |  |  |
URDT | User Reserve Date |  |  |  |
URAT | User Reserve Amount |  |  |  |
URAB | User Reserve Number |  |  |  |
URRF | User Reserve Reference |  |  |  |

#### Back Order Aggregate Table

This table lists the Back Order Aggregate table (F80D213) Data Dictionary (DD) items, the source tables and fields, and information about DD items:

DD Item | DD Item Description | Key | Source Table | Source Table DD Item | Additional Information
PRDJ | Processing Date | Y |  |  | Current date
MCU | Business Unit | Y | Sales Order Fact (F80D010) | MCU |
ITM | Short Item Number | Y | Sales Order Fact (F80D010) | ITM |
BOAA | BackOrder Amount |  |  |  | Calculated field
BOCN | BackOrder Count |  |  |  | Calculated field
USER | User ID |  |  |  | Calculated field for audit information.
PID | Program ID |  |  |  | Calculated field for audit information.
MKEY | Machine Key |  |  |  | Calculated field for audit information.
UTIME | Update Date and Time |  |  |  | Calculated field for audit information.
URCD | User Reserve Code |  |  |  |
URDT | User Reserve Date |  |  |  |
URAT | User Reserve Amount |  |  |  |
URAB | User Reserve Number |  |  |  |
URRF | User Reserve Reference |  |  |  |

#### Variance Table

This table lists the Variance table (F80D214) Data Dictionary (DD) items, the source tables and fields, and information about DD items:

DD Item | DD Item Description | Key | Source Table | Source Table DD Item | Additional Information
PRDJ | Processing Date | Y |  |  | Current date
MCU | Business Unit | Y | Sales Order Fact (F80D010) | MCU |
ITM | Short Item Number | Y | Sales Order Fact (F80D010) | ITM |
VARN | Sales Variance |  |  |  | Calculated field
BORDCT | Order Lines Booked Count |  |  |  | Calculated field
USER | User ID |  |  |  | Calculated field for audit information.
PID | Program ID |  |  |  | Calculated field for audit information.
MKEY | Machine Key |  |  |  | Calculated field for audit information.
UTIME | Update Date and Time |  |  |  | Calculated field for audit information.
URCD | User Reserve Code |  |  |  |
URDT | User Reserve Date |  |  |  |
URAT | User Reserve Amount |  |  |  |
URAB | User Reserve Number |  |  |  |
URRF | User Reserve Reference |  |  |  |

#### Book to Ship Aggregate Table

This table lists the Book to Ship Aggregate table (F80D215) Data Dictionary (DD) items, the source tables and fields, and information about DD items:

DD Item | DD Item Description | Key | Source Table | Source Table DD Item | Additional Information
PRDJ | Processing Date | Y | Sales Order Fact (F80D010) | ADDJ |
ITM | Short Item Number | Y | Sales Order Fact (F80D010) | ITM |
BSHDY | Book to Ship Days |  |  |  | Calculated field
ORDSH | Number of Orders Shipped |  |  |  | Calculated field
USER | User ID |  |  |  | Calculated field for audit information.
PID | Program ID |  |  |  | Calculated field for audit information.
MKEY | Machine Key |  |  |  | Calculated field for audit information.
UTIME | Update Date and Time |  |  |  | Calculated field for audit information.
URCD | User Reserve Code |  |  |  |
URDT | User Reserve Date |  |  |  |
URAT | User Reserve Amount |  |  |  |
URAB | User Reserve Number |  |  |  |
URRF | User Reserve Reference |  |  |  |

#### Inventory Aggregate Table

This table lists the Inventory Aggregate table (F80D220) Data Dictionary (DD) items, the source tables and fields, and information about DD items:

DD Item | DD Item Description | Key | Source Table | Source Table DD Item | Additional Information
PRDJ | Processing Date | Y |  |  | Current date
MCU | Business Unit | Y | Item Location File (F41021) | MCU |
ITM | Short Item Number | Y | Item Location File (F41021) | ITM |
COGS | Cost of Goods Sold |  | General Ledger Aggregate (F80D221) | AA | Calculated field is the sum of the amounts from the F80D221.
PDSI | Days Sales in Inventory |  |  |  | Calculated field which can require currency conversion and unit of measure conversion.
ITU | Inventory Turns |  |  |  | Calculated field which can require currency conversion and unit of measure conversion.
USER | User ID |  |  |  | Calculated field for audit information.
PID | Program ID |  |  |  | Calculated field for audit information.
MKEY | Machine Key |  |  |  | Calculated field for audit information.
UTIME | Update Date and Time |  |  |  | Calculated field for audit information.
URCD | User Reserve Code |  |  |  |
URDT | User Reserve Date |  |  |  |
URAT | User Reserve Amount |  |  |  |
URAB | User Reserve Number |  |  |  |
URRF | User Reserve Reference |  |  |  |

#### General Ledger Aggregate Table

This table lists the General Ledger Aggregate table (F80D221) Data Dictionary (DD) items, the source tables and fields, and information about DD items:

DD Item | DD Item Description | Key | Source Table | Source Table DD Item | Additional Information
PRDJ | Processing Date | Y |  |  | Current date
MCU | Business Unit | Y | Item Ledger (F4111) or Sales Order Detail File (F4211) | MCU | The system uses the F4111 table when you run the R80D221A program and the F4211 table when you run the R80D221B program.
ITM | Short Item Number | Y | Item Ledger (F4111) or Sales Order Detail File (F4211) | ITM | The system uses the F4111 table when you run the R80D221A program and the F4211 table when you run the R80D221B program.
AA | Amount |  | Item Ledger (F4111) or Sales Order Detail File (F4211) |  | The system uses the F4111 table when you run the R80D221A program and the F4211 table when you run the R80D221B program. The system uses the PAID data item if you run the R80D221A program and the ESCT data item if you run the R80D221B program. Calculated field which will be converted to the default data currency code.
USER | User ID |  |  |  | Calculated field for audit information.
PID | Program ID |  |  |  | Calculated field for audit information.
MKEY | Machine Key |  |  |  | Calculated field for audit information.
UTIME | Update Date and Time |  |  |  | Calculated field for audit information.
URCD | User Reserve Code |  |  |  |
URDT | User Reserve Date |  |  |  |
URAT | User Reserve Amount |  |  |  |
URAB | User Reserve Number |  |  |  |
URRF | User Reserve Reference |  |  |  |

#### On Time Manufacturing Production Completions Table

This table lists the On Time Manufacturing Production Completions table (F80D230) Data Dictionary (DD) items, the source tables and fields, and information about DD items:

DD Item | DD Item Description | Key | Source Table | Source Table DD Item | Additional Information
DRQJ | Request Date | Y | Work Order Master File (F4801) | STRX | Processing date
ITM | Short Item Number | Y | Work Order Master File (F4801) | ITM |
MCU | Business Unit | Y | Work Order Master File (F4801) | MCU |
LWOC | Late Work Order Count |  |  |  | Calculated field.
EWOC | Early Work Order Count |  |  |  | Calculated field.
OTWOC | On Time Work Order Count |  |  |  | Calculated field.
USER | User ID |  |  |  | Calculated field for audit information.
PID | Program ID |  |  |  | Calculated field for audit information.
MKEY | Machine Key |  |  |  | Calculated field for audit information.
UPMJ | Date Updated |  |  |  | Calculated field for audit information.
TDAY | Time of Day |  |  |  | Calculated field for audit information.
URCD | User Reserve Code |  |  |  |
URDT | User Reserve Date |  |  |  |
URAT | User Reserve Amount |  |  |  |
URAB | User Reserve Number |  |  |  |
URRF | User Reserve Reference |  |  |  |

#### Manufacturing Production Costings Table

This table lists the Manufacturing Production Costings table (F80D231) Data Dictionary (DD) items, the source tables and fields, and information about DD items:

DD Item | DD Item Description | Key | Source Table | Source Table DD Item | Additional Information
DRQJ | Request Date | Y | Work Order Master File (F4801) | DRQJ | Processing date
MCU | Business Unit | Y | Work Order Master File (F4801) | MCU |
ITM | Short Item Number | Y | Work Order Master File (F4801) | ITM |
AN8 | Address Number |  | Work Order Master File (F4801) | AN8 |
DFCC | Default Currency |  | Work Order Master File (F4801) | DFCC |
PLAT | Planned Amount |  |  |  | Calculated field.
CPAT | Completed Amount |  |  |  | Calculated field.
USER | User ID |  |  |  | Calculated field for audit information.
PID | Program ID |  |  |  | Calculated field for audit information.
MKEY | Machine Key |  |  |  | Calculated field for audit information.
UPMJ | Date Updated |  |  |  | Calculated field for audit information.
TDAY | Time of Day |  |  |  | Calculated field for audit information.
URCD | User Reserve Code |  |  |  |
URDT | User Reserve Date |  |  |  |
URAT | User Reserve Amount |  |  |  |
URAB | User Reserve Number |  |  |  |
URRF | User Reserve Reference |  |  |  |

#### Booked Orders Aggregate Table

This table lists the Booked Orders Aggregate table (F80D240) Data Dictionary (DD) items, the source tables and fields, and information about DD items:

DD Item | DD Item Description | Key | Source Table | Source Table DD Item | Additional Information
PRDJ | Processing Date | Y | Sales Order Fact (F80D010) | TRDJ |
EMCU | Header Business Unit | Y | Sales Order Fact (F80D010) | EMCU |
AN8 | Address Number | Y | Sales Order Fact (F80D010) | AN8 |
ITM | Short Item Number | Y | Sales Order Fact (F80D010) | ITM |
BORV | Booked Order Revenue |  |  |  | Calculated field.
USER | User ID |  |  |  | Calculated field for audit information.
PID | Program ID |  |  |  | Calculated field for audit information.
MKEY | Machine Key |  |  |  | Calculated field for audit information.
UTIME | Update Date and Time |  |  |  | Calculated field for audit information.
URCD | User Reserve Code |  |  |  |
URDT | User Reserve Date |  |  |  |
URAT | User Reserve Amount |  |  |  |
URAB | User Reserve Number |  |  |  |
URRF | User Reserve Reference |  |  |  |

#### Shipped Orders Aggregate Table

This table lists the Shipped Orders Aggregate table (F80D241) Data Dictionary (DD) items, the source tables and fields, and information about DD items:

DD Item | DD Item Description | Key | Source Table | Source Table DD Item | Additional Information
PRDJ | Processing Date | Y | Sales Order Fact (F80D010) | ADDJ |
EMCU | Header Business Unit | Y | Sales Order Fact (F80D010) | EMCU |
AN8 | Address Number | Y | Sales Order Fact (F80D010) | AN8 |
ITM | Short Item Number | Y | Sales Order Fact (F80D010) | ITM |
SHRV | Shipped Order Revenue |  |  |  | Calculated field.
USER | User ID |  |  |  | Calculated field for audit information.
PID | Program ID |  |  |  | Calculated field for audit information.
MKEY | Machine Key |  |  |  | Calculated field for audit information.
UTIME | Update Date and Time |  |  |  | Calculated field for audit information.
URCD | User Reserve Code |  |  |  |
URDT | User Reserve Date |  |  |  |
URAT | User Reserve Amount |  |  |  |
URAB | User Reserve Number |  |  |  |
URRF | User Reserve Reference |  |  |  |

#### Projected Revenue Aggregate Table

This table lists the Projected Revenue Aggregate table (F80D242) Data Dictionary (DD) items, the source tables and fields, and information about DD items:

DD Item | DD Item Description | Key | Source Table | Source Table DD Item | Additional Information
PRDJ | Processing Date | Y | Sales Order Fact (F80D010) | PPDJ |
EMCU | Header Business Unit | Y | Sales Order Fact (F80D010) | EMCU |
AN8 | Address Number | Y | Sales Order Fact (F80D010) | AN8 |
ITM | Short Item Number | Y | Sales Order Fact (F80D010) | ITM |
PRRV | Projected Revenue |  |  |  | Calculated field.
USER | User ID |  |  |  | Calculated field for audit information.
PID | Program ID |  |  |  | Calculated field for audit information.
MKEY | Machine Key |  |  |  | Calculated field for audit information.
UTIME | Update Date and Time |  |  |  | Calculated field for audit information.
URCD | User Reserve Code |  |  |  |
URDT | User Reserve Date |  |  |  |
URAT | User Reserve Amount |  |  |  |
URAB | User Reserve Number |  |  |  |
URRF | User Reserve Reference |  |  |  |

#### Backlog Aggregate Table

This table lists the Backlog Aggregate table (F80D243) Data Dictionary (DD) items, the source tables and fields, and information about DD items:

DD Item | DD Item Description | Key | Source Table | Source Table DD Item | Additional Information
PRDJ | Processing Date | Y | Sales Order Fact (F80D010) | TRDJ |
EMCU | Header Business Unit | Y | Sales Order Fact (F80D010) | EMCU |
ITM | Short Item Number | Y | Sales Order Fact (F80D010) | ITM |
BCKV | Backlog Value |  |  |  | Calculated field.
USER | User ID |  |  |  | Calculated field for audit information.
PID | Program ID |  |  |  | Calculated field for audit information.
MKEY | Machine Key |  |  |  | Calculated field for audit information.
UTIME | Update Date and Time |  |  |  | Calculated field for audit information.
URCD | User Reserve Code |  |  |  |
URDT | User Reserve Date |  |  |  |
URAT | User Reserve Amount |  |  |  |
URAB | User Reserve Number |  |  |  |
URRF | User Reserve Reference |  |  |  |

#### Supplier On-Time Delivery Aggregate Table

This table lists the Supplier On-Time Delivery Aggregate table (F80D250) Data Dictionary (DD) items, the source tables and fields, and information about DD items:

DD Item | DD Item Description | Key | Source Table | Source Table DD Item | Additional Information
PRDJ | Processing Date | Y | Purchase Order Detail File (F4311) | ADDJ |
MCU | Business Unit | Y | Purchase Order Detail File (F4311) | MCU |
AN8 | Address Number | Y | Purchase Order Detail File (F4311) | AN8 |
RECVE | Number of Receipts Received Early |  |  |  | Calculated field.
RECVOT | Number of Receipts Received On Time |  |  |  | Calculated field.
RECVL | Number of Receipts Received Late |  |  |  | Calculated field.
USER | User ID |  |  |  | Calculated field for audit information.
PID | Program ID |  |  |  | Calculated field for audit information.
MKEY | Machine Key |  |  |  | Calculated field for audit information.
UTIME | Update Date and Time |  |  |  | Calculated field for audit information.
URCD | User Reserve Code |  |  |  |
URDT | User Reserve Date |  |  |  |
URAT | User Reserve Amount |  |  |  |
URAB | User Reserve Number |  |  |  |
URRF | User Reserve Reference |  |  |  |

#### Material Lead Time Exception Aggregate Table

This table lists the Material Lead Time Exception Aggregate table (F80D251) Data Dictionary (DD) items, the source tables and fields, and information about DD items:

DD Item | DD Item Description | Key | Source Table | Source Table DD Item | Additional Information
PRDJ | Processing Date | Y | Purchase Order Detail File (F4311) | ADDJ |
MCU | Business Unit | Y | Purchase Order Detail File (F4311) | MCU |
ITM | Short Item Number | Y | Purchase Order Detail File (F4311) | ITM |
AN8 | Address Number | Y | Purchase Order Detail File (F4311) | AN8 |
RLTD | Received Lead Time |  |  |  | Calculated field.
RECLTE | Number of Lead Time Exceptions - Longer |  |  |  | Calculated field.
RECSTE | Number of Lead Time Exceptions - Shorter |  |  |  | Calculated field.
RECV | Number of Receipts Received |  |  |  | Calculated field.
USER | User ID |  |  |  | Calculated field for audit information.
PID | Program ID |  |  |  | Calculated field for audit information.
MKEY | Machine Key |  |  |  | Calculated field for audit information.
UTIME | Update Date and Time |  |  |  | Calculated field for audit information.
URCD | User Reserve Code |  |  |  |
URDT | User Reserve Date |  |  |  |
URAT | User Reserve Amount |  |  |  |
URAB | User Reserve Number |  |  |  |
URRF | User Reserve Reference |  |  |  |

#### Supplier Pass Quality Aggregate Table

This table lists the Supplier Pass Quality Aggregate table (F80D252) Data Dictionary (DD) items, the source tables and fields, and information about DD items:

DD Item | DD Item Description | Key | Source Table | Source Table DD Item | Additional Information
PRDJ | Processing Date | Y | Purchase Order Receiver File (F43121) | RCDJ |
MCU | Business Unit | Y | Purchase Order Receiver File (F43121) | MCU |
AN8 | Address Number | Y | Purchase Order Receiver File (F43121) | AN8 |
ITM | Short Item Number | Y | Purchase Order Receiver File (F43121) | ITM |
TNRC | Total Number of Receipts |  |  |  | Calculated field
NFRC | Number of Failed Receipts |  |  |  | Calculated field
USER | User ID |  |  |  | Calculated field for audit information.
PID | Program ID |  |  |  | Calculated field for audit information.
MKEY | Machine Key |  |  |  | Calculated field for audit information.
UTIME | Update Date and Time |  |  |  | Calculated field for audit information.
URCD | User Reserved Code |  |  |  |
URDT | User Reserved Date |  |  |  |
URAT | User Reserved Amount |  |  |  |
URAB | User Reserved Number |  |  |  |
URRF | User Reserved Reference |  |  |  |