Label Extract File Record Definitions

The label extract file record definitions define the format for each label extract file. The label extract file is the output that the PeopleSoft application sends to the label printing software that you use to print the bar-coded labels.

The label extract files contain many field values that you can use in your label print process.

The label extract files are in comma-delimited format.

Each label extract file that contains an item ID also includes control flags that identify characteristics of that item. The control flags can be concatenated to various key fields that are printed as bar codes. For example, suppose that you concatenate the control flags to the item ID on the item storage labels, your electronic data collection system knows what other keys for which to prompt.

Here are the five control flags:

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 on the shipping carton and shipping container transactions.

Note: The Format ID is an optional field on all of the label extract file records. It is in the first position only if the Include Format check box is selected for the specified format ID.

The label extract file record definitions define the format for the label extract file.

Storage Location Label Field Name

Format

Label Format ID

Char 30

Business Unit

Char 10

Location Code/Par Location Code

Char 15

Location Description/Par Location Description

Char 30

Item ID

Char 40

Item Description

Char 30

Quantity

Nbr 11.4

Unit of Measure

Char 3

Standard Unit of Measure

Char 3

The label extract file record definitions define the format for the label extract file.

Item Storage Label Field Name

Format

Desc./Com.

Label Format ID

Char 30

N/A

Business Unit

Char 10

N/A

Item ID

Char 40

N/A

Item Description

Char 30

N/A

Lot Control Flag

Char 1

N/A

Lot ID

Char 15

N/A

Serial Control Flag

Char 1

N/A

Serial ID

Char 35

N/A

Staged Date Flag

Char 1

N/A

Staged Date

Date 10

N/A

Actual Cost Flag

Char 1

This field is set to Y if the item is actual-costed.

Unit of Measure

Char 3

N/A

Quantity

Nbr 11.4

N/A

Standard Unit of Measure

Char 3

N/A

Standard Quantity

Nbr 11.4

N/A

Reference Number

Char 30

N/A

The label extract file record definitions define the format for the label extract file.

Storage Container Label Field Name

Format

Label Format ID

Char 30

Container Number

Nbr 18

The label extract file record definitions define the format for the label extract file.

Storage Location Label Field Name

Format

Label Format ID

Char 30

Business Unit

Char 10

Storage Location

Char 5

Storage Level 1

Char 4

Storage Level 2

Char 4

Storage Level 3

Char 4

Storage Level 4

Char 4

The label extract file record definitions define the format for the label extract file.

Shipping Carton Label Field Name

Format

Desc./Com.

Label Format ID

Char 30

N/A

Ship From Location

Char 30

N/A

Ship From Address1

Char 55

N/A

Ship From Address2

Char 55

N/A

Ship From Address3

Char 55

N/A

Ship From Address4

Char 55

N/A

Ship From Num1

Char 6

N/A

Ship From Num2

Char 4

N/A

Ship From House Type

Char 2

N/A

Ship From City

Char 30

N/A

Ship From Country

Char 30

N/A

Ship From Addr field1

Char 2

N/A

Ship From Addr field2

Char 4

N/A

Ship From Addr field3

Char 4

N/A

Ship From Geo Code

Char 11

N/A

Ship From In City Limit

Char 1

N/A

Ship From State

Char 4

N/A

Ship From Postal

Char 12

N/A

Ship From Country

Char 3

N/A

Customer Name

Char 40

N/A

Customer Name1

Char 40

N/A

Customer Name2

Char 40

N/A

Address1

Char 55

N/A

Address2

Char 55

N/A

Address3

Char 55

N/A

Address4

Char 55

N/A

Num1

Char 6

N/A

Num2

Char 4

N/A

House Type

Char 2

N/A

City

Char 30

N/A

County

Char 30

N/A

State

Char 4

N/A

Postal

Char 12

N/A

Country

Char 3

N/A

Addr field1

Char 2

N/A

Addr field2

Char 4

N/A

Addr field3

Char 4

N/A

Geo Code

Char 11

N/A

In City Limit

Char 1

N/A

Carrier

Char 30

N/A

Ship To Customer ID/or Location

Char 15

This field contains either the ship to customer ID or the location, depending on the field that you used when you created the order.

Route Code

Char 6

N/A

Route Stop Number

Number 5

N/A

Customer PO

Char 25

N/A

Customer PO Line

Char 11

N/A

Customer Contract Number

Char 25

N/A

Customer Contract Line Number

Char 3

N/A

Customer Item Number

Char 40

N/A

Business Unit

Char 10

N/A

Demand Source

Char 2

N/A

Source Business Unit

Char 5

N/A

Order Number

Char 10

N/A

Order Line Number

Nbr 5

N/A

Schedule Line Number

Nbr 7

N/A

Inventory Item ID

Char 40

N/A

Demand Line Number

Nbr 4

N/A

Product ID

Char 40

N/A

Parent Product ID

Char 40

N/A

Lot Control Flag

Char 1

N/A

Standard Serial Control Flag

Char 1

N/A

Staged Date Control Flag

Char 1

N/A

Actual Cost Flag

Char 1

This field is set to Y if the item is actual-costed.

Ship Serial Control Flag

Char 1

N/A

Pick Batch ID

Nbr 10

N/A

Pick Batch Line Number

Nbr 5

N/A

Carton Qty in Ordering UOM

Nbr 11.4

N/A

Ordering UOM

Char 3

N/A

Carton Qty in Standard UOM

Nbr 11.4

N/A

Standard UOM

Char 3

N/A

Carton Qty in Standard Pack UOM

Nbr 11.4

N/A

Standard Pack UOM

Char 3

N/A

Carton Sequence

Char 10

N/A

The label extract file record definitions define the format for the label extract file.

Shipping Container Label Field Name

Format

Desc./Com.

Label Format ID

Char 30

N/A

Ship From Location

Char 30

N/A

Ship From Address1

Char 55

N/A

Ship From Address2

Char 55

N/A

Ship From Address3

Char 55

N/A

Ship From Address4

Char 55

N/A

Ship From Num1

Char 6

N/A

Ship From Num2

Char 4

N/A

Ship From House Type

Char 2

N/A

Ship From City

Char 30

N/A

Ship From County

Char 30

N/A

Ship From State

Char 4

N/A

Ship From Postal

Char 12

N/A

Ship From Country

Char 3

N/A

Ship From Addr field1

Char 2

N/A

Ship From Addr field2

Char 4

N/A

Ship From Addr field3

Char 4

N/A

Ship From Geo Code

Char 11

N/A

Ship From In City Limit

Char 1

N/A

Customer Name

Char 40

N/A

Customer Name1

Char 40

N/A

Customer Name2

Char 40

N/A

Address1

Char 55

N/A

Address2

Char 55

N/A

Address3

Char 55

N/A

Address4

Char 55

N/A

Num1

Char 6

N/A

Num2

Char 4

N/A

House Type

Char 2

N/A

City

Char 30

N/A

County

Char 30

N/A

State

Char 4

N/A

Postal

Char 12

N/A

Country

Char 3

N/A

Carrier

Char 30

N/A

Ship To Customer ID or Location

Char 15

This field contains either the ship to customer ID or the location, depending on the field that you used when you created the order.

Manufacturer ID Number

Char 7

N/A

Shipping Container Serial Number

Nbr 9

N/A

Carton Sequence

Char 10

N/A

Business Unit

Char 10

N/A

The label extract file record definitions define the format for the label extract file.

Serial Number Label Field Name

Format

Label Format ID

Char 30

Serial ID

Nbr 35

The label extract file record definitions define the format for the label extract file.

Production Completion Label Field Name

Format

Desc./Com.

Label Format ID

Char 30

N/A

Business Unit

Char 10

See note.

Production ID

Char 10

N/A

Production Area

Char 10

N/A

Item ID

Char 40

See note.

Item Description 30

Char 30

N/A

Configuration Code

Char 50

N/A

Revision

Char 4

N/A

Production Type

Char 2

N/A

Lot Control Flag

Char 1

N/A

Serial Control Flag

Char 1

N/A

Staged Date Flag

Char 1

N/A

Actual Cost Flag

Char 1

N/A

Lot ID

Char 15

N/A

Standard Unit of Measure

Char 3

N/A

Standard Pack Quantity

Nbr 11.4

N/A

Std Pack Unit of Measure

Char 3

N/A

Quantity in Std Pack UOM

Nbr 11.4

N/A

Date

Date

CCYYMMDD

Op Sequence

Number 4.0

N/A

Output Type

Char 2

N/A

Note: Certain fields allow for 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. A size mismatch between the file and the definition may result in an error when data is retrieved through the flat file.

The label extract file record definitions define the format for the label extract file.

Receiving Label Field Name

Format

Label Format ID

Char 30

Inventory Business Unit

Char 10

Item ID

Char 40

Item Description

Char 30

Lot Control Flag

Char 1

Lot ID

Char 15

Serial Control Flag

Char 1

Serial ID

Char 35

Receipt Date

Date 10

Actual Cost Flag

Char 1

Receiving Business Unit

Char 5

Receiver ID

Char 10

Receiver Line Number

Nbr 5

Unit of Measure

Char 3

Quantity

Nbr 11.4

Standard Unit of Measure

Char 3

Standard Quantity

Nbr 11.4

Production ID

Char 10

Production Sequence Number

Nbr 2

Staged Date Flag

Char 1

The label extract file record definitions define the format for the label extract file.

Kanban Field Name

Type

Label Format ID

Char 30

Business Unit

Char 10

Report Type

  • 2 = Pull Ticket

  • 3 = Kanban Card

Char 1

Replenishment Source

  • 1 = Inventory

  • 2 = Supplier

  • 3 = Feeder Line

Char 1

Kanban ID

Char 15

Item ID

Char 40

Item Description

Char 30

WIP Storage Area

Char 5

WIP StorageLevel 1

Char 4

WIP StorageLevel 2

Char 4

WIP StorageLevel 3

Char 4

WIP StorageLevel 4

Char 4

Source Storage Area

Blank if Replenishment Source <> INV

Char 5

Source StorageLevel 1

Blank if Repl Source <> INV

Char 4

Source StorageLevel 2

Blank if Repl Source <> INV

Char 4

Source StorageLevel 3

Blank if Repl Source <> INV

Char 4

Source StorageLevel 4

Blank if Repl Source <> INV

Char 4

Production Area

Blank if Repl Source <> Feeder

Char 10

Supplier ID

Blank if Repl Source <> Supplier

Char 10

Supplier Name

Blank if Repl Source <> Supplier

Char 40

Supplier Location

Blank if Repl Source <> Supplier

Char 10

Supplier Location Desc

Blank if Repl Source <> Supplier

Char 30

Supplier Item ID

Blank if Repl Source <> Supplier

Char 20

Supplier Qty

Blank if Repl Source <> Supplier

Number 11.4

Supplier UOM

Blank if Repl Source <> Supplier

Char 3

Qty Standard UOM

Number 11.4

Standard UOM

Char 3

Lot Control Flag

Char 1

Serial Control Flag

Char 1

Print Count

Number 3

DateTime Stamp

Datetime 14