Manufacturing Picking Extract File Format

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.