Picking Plan Extract File Record Definitions
The system generates this optional extract file at the same time that it initiates the picking plan. Its content mimics the data contained within the printed picking plan document and provides an electronic means for the front-end (hand-held or batch) process to validate and enhance data collection. Data in the file is comma-separated.
The picking plan extract file includes five control flags that identify characteristics of the item or component being picked:
Field or Control |
Description |
---|---|
Lot Control Flag |
Set to Y if the item is lot-controlled. Set to N if the item is not lot-controlled. |
Serial Control Flag |
Set to Y if the item is serial-controlled. Set to N if the item is not serial-controlled. |
Staged Date Control Flag |
Set to Y if the item is staged-date controlled. Set to N if the item is not staged-date controlled. |
Actual Cost Control Flag |
Set to Y if the item is actual-costed. Set to N if the item is not actual-costed. |
Shipping Serial Control Flag |
Set to Y if the item is shipping serial-controlled. Set to N if the item is not shipping serial-controlled. The shipping serial control flag is only included in the Inventory picking extract file. |
The system generates the inventory picking extract file at the same time that it initiates the pick plan.
Picking Plan Extract File Field Name |
Format |
---|---|
Business Unit* |
Char 10 |
Extract Source Flag* |
Char 1 |
Pick Batch ID |
Nbr 10 |
Pick List Line Number |
Nbr 5 |
Sequence Number |
Nbr 2 |
Pick Mode Flag* |
Char 1 |
Customer ID |
Char 15 |
Ship To Customer ID |
Char 15 |
Location |
Char 10 |
Demand Source |
Char 2 |
Source Business Unit |
Char 5 |
Order Number |
Char 10 |
Order Int Line Number |
Nbr 5 |
Schedule Line Number |
Nbr 4.2 |
Parent Product ID |
Char 18 |
Item ID* |
Char 40 |
Item Description 30 |
Char 30 |
Item Configuration Code |
Char 50 |
Container ID |
Char 10 |
Storage Area |
Char 5 |
Storage Level 1 |
Char 4 |
Storage Level 2 |
Char 4 |
Storage Level 3 |
Char 4 |
Storage Level 4 |
Char 4 |
Order/Pick Quantity in Standard UOM |
Nbr 11.4 |
Order/Pick Quantity in Order/Pick UOM |
Nbr 11.4 |
Reserved Quantity in Standard UOM |
Nbr 11.4 |
Reserved Quantity in Location UOM |
Nbr 11.4 |
Available Quantity in Standard UOM |
Nbr 11.4 |
Available Quantity in Location UOM |
Nbr 11.4 |
Standard UOM |
Char 3 |
Order/Pick UOM |
Char 3 |
Location UOM |
Char 3 |
Order UOM Conversion Rate |
Nbr 7.8 |
Location UOM Conversion Rate |
Nbr 7.8 |
Lot ID |
Char 15 |
Serial ID |
Char 35 |
Staged Date* |
Char 8 |
Lot Control Flag |
Char 1 |
Serial Control Flag |
Char 1 |
Staged Date Control Flag |
Char 1 |
Ship Serial Control Flag |
Char 1 |
Hard Allocation Flag |
Char 1 |
Partial Quantity Flag |
Char 1 |
Hard Allocation Flag |
Char 1 |
Partial Quantity Flag |
Char 1 |
Substitute Flag |
Char 1 |
Qty Precision for Std UOM |
Char 1 |
Rounding Rule for Std UOM |
Char 1 |
Qty Precision for Loc UOM |
Char 1 |
Rounding Rule for Loc UOM |
Char 1 |
Allow Overpick Flag |
Char 1 |
Maximum Picking Tolerance |
Nbr 3.2 |
Load ID |
Char 10 |
Carrier ID |
Char 10 |
Ship Via |
Char 10 |
Route Code |
Char 6 |
Route Stop Number |
Nbr 5 |
Lot Availability Date CCYYMMDD |
Char 8 |
Lot Retest Date CCYYMMDD |
Char 8 |
Lot Expiration Date CCYYMMDD |
Char 8 |
Scheduled Ship Date CCYYMMDD |
Char 8 |
ASRS ID |
Nbr 15 |
Picking Zone |
Char 6 |
Original Item ID |
Char 40 |
Original or Reprint Flag * |
Char 1 |
Date / Time Stamp* |
Char 14 |
Field-Specific Notes
See the field-specific information that follows.
Business Unit
The Business Unit field permits possible larger sizes to accommodate customer revisions. In general, field sizes should match that within the PeopleSoft COBOL programs. Online pages use the sizes as defined within PeopleSoft Application Designer.
Extract Source Flag
0 = Inventory Pick Plan
1 = Manufacturing Pick Plan
Pick Mode Flag
0 = Push
1 = Pull
Item ID
The Item ID field permits possible larger sizes to accommodate customer revisions. In general, field sizes should match that within the PeopleSoft COBOL programs. Online pages use the sizes defined within PeopleSoft Data Designer.
Staged Date
The format is CCYYMMDD.
Original or Reprint Flag
0 = Original
1 = Reprint
Date / Time Stamp
The format is CCYYMMDDHHMMSS.
The system generates the manufacturing extract file at the same time that the system initiates the pick plan.
Note: For manufacturing extract data, the control flags reflect the requirements for the component ID, not the item ID.
Picking Plan Extract File Field Name |
Format |
---|---|
Business Unit* |
Char 10 |
Extract Source Flag* |
Char 1 |
Pick Batch ID |
Nbr 10 |
Pick List Line Number |
Nbr 5 |
Sequence Number |
Nbr 2 |
Pick Mode Flag* |
Char 1 |
Production Area |
Char 10 |
Production ID |
Char 10 |
Production Type* |
Char 2 |
Issue Method* |
Char 4 |
Item ID* |
Char 40 |
Item Description 30 |
Char 30 |
Item Configuration Code |
Char 50 |
Original Component ID |
Char 40 |
Component ID |
Char 40 |
Component Description 30 |
Char 30 |
Component Configuration Code |
Char 50 |
Operation Sequence |
Nbr 4 |
Quantity Code* |
Char 3 |
Required Date* |
Char 8 |
Required Time* |
Char 6 |
Work Center Code |
Char 10 |
Work Center Description |
Char 30 |
To Container ID |
Char 10 |
To Storage Area |
Char 5 |
To Storage Level 1 |
Char 4 |
To Storage Level 2 |
Char 4 |
To Storage Level 3 |
Char 4 |
To Storage Level 4 |
Char 4 |
Container ID |
Char 10 |
Storage Area |
Char 5 |
Storage Level 1 |
Char 4 |
Storage Level 2 |
Char 4 |
Storage Level 3 |
Char 4 |
Storage Level 4 |
Char 4 |
ASRS ID |
Nbr 15 |
Order/Pick Quantity in Standard UOM |
Nbr 11.4 |
Order/Pick Quantity in Order/Pick UOM |
Nbr 11.4 |
Reserved Quantity in Standard UOM |
Nbr 11.4 |
Reserved Quantity in Location UOM |
Nbr 11.4 |
Available Quantity in Standard UOM |
Nbr 11.4 |
Available Quantity in Location UOM |
Nbr 11.4 |
Standard UOM |
Char 3 |
Order/Pick UOM |
Char 3 |
Location UOM |
Char 3 |
Order/Pick UOM Conversion Rate |
Nbr 7.8 |
Location UOM Conversion Rate |
Nbr 7.8 |
Lot ID |
Char 15 |
Lot Expiration Date |
Char 8 |
Lot Availability Date |
Char 8 |
Serial ID |
Char 35 |
Lot Control Flag |
Char 1 |
Serial Control Flag |
Char 1 |
Staged Date Control Flag |
Char 1 |
Actual Cost Control Flag |
Char 1 |
Maintain Production ID Flag |
Char 1 |
Non Own Flag |
Char 1 |
Original or Reprint Flag* |
Char 1 |
Substitute Flag |
Char 1 |
Date / Time Stamp* |
Char 14 |
Field-Specific Notes
See the field-specific-information that follows.
Business Unit
The Business Unit field permits possible larger sizes to accommodate customer revisions. In general, field sizes should match that within the PeopleSoft COBOL programs. Online pages use the sizes defined within PeopleSoft Data Designer.
Extract Source Flag
0 = Inventory Pick Plan
1 = Manufacturing Pick Plan
Pick Mode Flag
0 = Push
1 = Pull
Production Type
PR = Production
RW = Rework
TD = Teardown
Issue Method
ISS = Issue
REPL = Replenish
KIT = Kit
Item ID
This field permits possible larger sizes to accommodate customer revisions. In general, field sizes should match that within the PeopleSoft COBOL programs. Online pages use the sizes defined within PeopleSoft Data Designer.
Quantity Code
ORD = per Order
ASY = per Assembly
Required Date
The format is CCYYMMDD.
Required Time
The format is HHMMSS.
Original or Reprint Flag
A reprinted extract reflects the current data values in the database. If any pick transactions have been applied between the original and reprinted extract, the data content may differ.
0 = Original
1 = Reprint
Date / Time Stamp
The format is CCYYMMDDHHMMSS.