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
|
Char 1 |
Replenishment Source
|
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 |