PeopleSoft Enterprise Supply Chain Management Integration 9.1 PeopleBook

Understanding Record Layouts for the Electronic Data Collection System

This chapter discusses:

Par location count and physical accounting file formats.
Label extract file record definitions.
Picking plan extract file record definitions.

Note. The information in this chapter is formatted so that a field-specific notes section follows each table. The field-specific notes section includes further details about the fields in the preceding table that are marked with an asterisk (*).

PeopleSoft currently does not support the creation of extract files for labels, paperless picking, par location replenishment, or physical accounting from processes on MVS servers. For these environments, the system supports the extract files by running processes using an application server.

Par Location Count and Physical Accounting File Formats

PeopleSoft Inventory provides two transactions that can be processed using batch flat files that are downloaded and uploaded using SQR programs.

The system uses batch processes to generate a flat file containing the item to be counted for either of the transactions. The flat file is passed to a third-party electronic data collection system that performs the count. The flat file must then be returned to PeopleSoft in the same format.

The files that you download to and upload from electronic data collection devices must conform to these rules:

The file name must be eight characters or less.

An extension of .upl is automatically appended to upload file names. An extension of .dwn is automatically appended to download file names.
The first field must start in column one.
There must be a single blank space between each field.
All fields must be left-justified.
The system expects the file that is read by the upload process to have a .upl extension.

Par Location Count

You can download par location count information for use in a hand-held bar code device. You can select the following options to download:

One par location at a time.
All par locations for a par location group.
All par locations for a specified business unit.
All par locations.

Below is the layout of the par location download and upload file.

The download process creates a .dwn file of 404 characters per record from the par location definition tables (CART_ATTRIB_INV and CART_TEMPL_INV). The upload expects the same file layout, 404 characters per record as a .upl file. The upload process updates the par location count tables (CART_CT_INF_INV). Each par location is created with an unprocessed status, and you can view them on the Par Location Count Inquiry page.

Contents	Format
BUSINESS_UNIT	5
INV_CART_ID	15
CART_GROUP	5
CART_REPLEN_OPT *	2
SHADOW_FLAG *	1
QTY_OPTION *	2
INV_ITEM_ID	18
DESCR	30
COMPARTMENT	10
COUNT_ORDER	4
COUNT_REQUIRED *	1
SUFFICIENT_STOCK *	1
CART_REPLEN_CTRL *	2
CART_COUNT_QTY *	16
DEFAULT_QTY	16
QTY_OPTIMAL	16
FOQ (Fixed Order Qty)	16
QTY_MAXIMUM	16
UNIT_OF_MEASURE	3
DISTRIB_TYPE	10
DEPTID	10
TRANSFER_COST	15
PRICE_MARKUP_PCT	15
CHARGE_CODE	20
ACCOUNT	10
ALTACCT	10
OPERATING_UNIT	8
PRODUCT	6
PROJECT_ID	15
CONS_NON_STOCK	1
BCKORDR_CNCL_FLAG	1
CHANGE_MARKUP_AMT	16
CHANGE_MARKUP_PCNT	15
MATERIAL_RECON_FLG	1
USG_TRCKNG_METHOD	2
LAST_OPRID	8
LAST_DTTM_UPDATE	26

Field-Specific Notes

See the field-specific information that follows.

CART_REPLEN_OPT

Specifies the way in which an item is to be replenished.

01 [Symbol_Wingdings_224] "stk" or "stock" (creates an MSR).

02 [Symbol_Wingdings_224] "less" or "stockless" (creates a staged purchase order).

03 [Symbol_Wingdings_224] "nons" or "non-stock" (creates a requisition).

04 [Symbol_Wingdings_224] "not replenished" (item is not to be replenished).

Note. The system uses stockless and non-stock replenishment options only if PeopleSoft Purchasing is installed.

SHADOW_FLAG

The shadow par location flag, which has an online label of not replenished, appears on the hand-held bar code device. This informs the user that this par location is not to be replenished.

QTY_OPTION

A hand-held bar code device can modify this field.

The quantity options for each par location count appears by default based on the default quantity option that you defined on the Par Location Group Definition page.

If the default quantity option is count, the system prompts the user to enter the quantity on hand on the par location. If the default quantity is request, the system prompts the user to enter the requested quantity.

Values are:

01 [Symbol_Wingdings_224] "c" or "count qty."

02 [Symbol_Wingdings_224] "r" or "request qty."

COUNT_REQUIRED

The COUNT_REQUIRED flag is evaluated to determine whether a count must be entered for an item. This flag is defined per item on the Par Location Group Definition page.

SUFFICIENT_STOCK

A hand-held bar code device can modify this field.

The SUFFICIENT_STOCK flag is available for entry on the hand-held bar code device if the quantity option is count qty. PeopleSoft provides this field, so that the user does not need to enter a count for that item if it is not necessary.

CART_REPLEN_CTRL

Identifies how the order quantity is to be calculated if the quantity option is set to count quantity.

01 [Symbol_Wingdings_224] "Par"

02 [Symbol_Wingdings_224] "FOQ" or "Fixed Order Qty"

03 [Symbol_Wingdings_224] "Min/Max"

CART_COUNT_QTY

A hand-held bar code device can modify this field.

The quantity options for each par location count appears by default based on the default quantity option that you defined on the Par Location Group Definition page.

See Also

Managing Par Inventory

Physical Accounting

You can use a hand-held bar code device to conduct your physical counting event. To ensure data transfer accuracy, first configure the download and upload file formats for the counting sheet according to the layout presented in the next table. All fields must be left-justified, with a space between each field.

Field	Comments	Format
INV_ITEM_ID	Required.	Char 18
STORAGE_AREA	Required.	Char 5
STOR_LEVEL_1	Required, if set up for the storage area.	Char 4
STOR_LEVEL_2	Required, if set up for the storage area.	Char 4
STOR_LEVEL_3	Required, if set up for the storage area.	Char 4
STOR_LEVEL_4	Required, if set up for the storage area.	Char 4
UNIT_OF_MEASURE	Required. Must contain the stocking unit of measure (UOM) at the location.	Char 3
STAGED_DATE	Required. If the item is staged-date controlled, this field must contain the appropriate staged date. If the item is not staged-date controlled, include the filler default value that you established on the Installation Options - Inventory page in the Installation Options component.	MMDDYYYY
SERIAL_ID	Required. If the item is serial-controlled, this field must contain the appropriate serial ID. If the item is not serial-controlled, include the filler default value that you established on the Installation Options - Inventory page in the Installation Options component.	Char 20
INV_LOT_ID	Required. If the item is lot-controlled, this field must contain the appropriate lot ID. If the item is not lot-controlled, include the filler default value that you established on the Installation Options - Inventory page in the Installation Options component.	Char 15
CONTAINER_ID	Optional.	Char 10
QTY	Required. Must contain a quantity; zero is valid.	Nbr 16
UNIT_OF_MEASURE_COUNT	Required. Must contain a valid UOM for the item. If this UOM is different than the stocking UOM noted above, then the quantity is converted to the stocking UOM before updating the database.	Char 3
ITEM_DESCR	Optional. For informational purposes only.	Char 30
COUNT_DTTM	Must contain a date. If the field is blank then the system does not update the row.	MM/DD/YYYY HH:MI:SS

See Also

Counting Inventory Stock

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:

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.

Item Usage Label

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

Item Storage Label

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

Storage Container Label

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

Storage Location Label

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

Shipping Carton Label

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

Shipping Container Label

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

Shipping Serial Number Label

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

Production Completion Label

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.

Purchasing Receipt Label

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

Kanban Card and Pull Ticket Label

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 = Vendor 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
Vendor ID Blank if Repl Source <> Vendor	Char 10
Vendor Name Blank if Repl Source <> Vendor	Char 40
Vendor Location Blank if Repl Source <> Vendor	Char 10
Vendor Location Descr Blank if Repl Source <> Vendor	Char 30
Vendor Item ID Blank if Repl Source <> Vendor	Char 20
Vendor Qty Blank if Repl Source <> Vendor	Number 11.4
Vendor UOM Blank if Repl Source <> Vendor	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

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:

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.

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.

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

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.