Table Mappings for JD Edwards EnterpriseOne Plant Manager's Dashboard
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 |