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.