This appendix contains the following topic:
This table lists the tables used by JD Edwards EnterpriseOne In-Memory Planning Advisor in alphanumeric order:
| Table | Description |
|---|---|
| Planning Advisor Message Type Configuration (F34X001) | Contains information about message type configuration, such as configuration name, configuration description, message type, message type description, originator, message sequence, medium message count threshold, high message count threshold, and future use fields. |
| Planning Advisor Critical Component Items Table (F34X010) | Contains information about critical component items, such as business unit and item numbers. |
| Message Summary Work Table (F34X100W) | Contains information about the message summary in the Planning Advisor Summary program, such as message priority, message code, message type description, message type count, and message type notification. |
| Item Summary Work Table (F34X101W) | Contains information about the item summary in the Planning Advisor Summary program, such as item number, sequence, planner, master planning family, planning code, buyer, supplier, safety stock, quantity on hand, message type count columns 1 through 17, stocking type, current days of supply, days of supply after 1st receipt, days of supply after 2nd receipt, days of supply status, inventory on hand, days until 1st receipt, days until 2nd receipt, inventory on hand alert, days until 1st receipt alert, days until 2nd receipt alert, and ending available negative information and critical component information. |
| Item List Work Table (F34X110W) | Contains a list of all items based on the filter criteria and configuration name, and stores information, such as item number, date updated, and critical component information. |
| Planning Details Supply/Demand Worktable (F34X200W) | Contains supply, demand, and MRP processing information for the Planning Advisor Console program, such as business unit, dates, supply/demand code, supply/demand description, order information, quantities, project number, production number, and critical component information. |
| Planning Advisor BOM Component Detail Table (F34X310W) | Contains information about critical component items on bills of materials, such as business unit, BOM level, indented BOM level, item numbers, type of BOM, batch quantity, branch, component branch, BOM component quantity, extended BOM component quantity, adjusted BOM component quantity, unit of measure, stocking type, line type, percent scrap, shrink factor, operation sequence number, type code (operation type), effective dates, and revision levels. |