Inventory Picking Extract File Format

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.