Company

From the Company field in the PO Header Interface Table (IXPHDP).

PO #

From the PO Number field in the PO Header Interface Table (IXPHDP).

Status

O (Open) defaults. The system creates the PO in an Open status, regardless of the setting of the PO Default Status (A49) system control value.

Workstation

INTERFACE defaults, indicating the purchase order was created through the PO Upload Interface.

Cancel date

From the Cancel Date field in the PO Header Interface Table (IXPHDP).

Confirming PO

From the Confirming PO field in the PO Header Interface Table (IXPHDP).

Currency rate

Defaults to 1.0000000.

Discount %

From the Discount % field in the Vendor table for the vendor defined in the Vendor number field in the PO Header Interface Table (IXPHDP).

See Applying Discounts to a Purchase Order Line for more information on how the system calculates the discounts to apply to a PO line.

Due date

From the Due Date field in the PO Header Interface Table (IXPHDP).

Entry date

From the Entry Date field in the PO Header Interface Table (IXPHDP).

Last transaction date

0 defaults.

Negotiate price

From the Negotiate Price field in the PO Header Interface Table (IXPHDP).

Print date

0 defaults.

Promise date

From the Promise Date field in the PO Header Interface Table (IXPHDP).

Placed with name

From the Placed With field in the PO Header Interface Table (IXPHDP).

Recurring PO

From the Recurring PO field in the PO Header Interface Table (IXPHDP).

Reference #

From the Reference # field in the PO Header Interface Table (IXPHDP).

Tax status

From the Tax Status field in the PO Header Interface Table (IXPHDP).

Vendor reference #

From the Vendor Reference # field in the PO Header Interface Table (IXPHDP).

Shipping instructions

From the Shipping instructions field in the PO Header Interface Table (IXPHDP).

Revision #

1 defaults.

Completed date

0 defaults.

Print worksheet

N defaults.

Revised date

Defaults to the date the PO was created.

Approval date

0 defaults.

EDI date

0 defaults.

Surcharge %

From the Surcharge % field in the Vendor table for the vendor defined in the Vendor number field in the PO Header Interface Table (IXPHDP).

PO Type

From the PO type field in the PO Header Interface Table (IXPHDP).

User field 1

From the PO User Field 1 field in the PO Header Interface Table (IXPHDP).

User field 2

From the PO User Field 2 field in the PO Header Interface Table (IXPHDP).

User field 3

From the PO User Field 3 field in the PO Header Interface Table (IXPHDP).

User field 4

From the PO User Field 4 field in the PO Header Interface Table (IXPHDP).

Unit discount amount 1

From the VDS Unit Discount field for VDS Seq # 1 in the Vendor table for the vendor defined in the Vendor number field in the PO Header Interface Table (IXPHDP).

See Applying Discounts to a Purchase Order Line for more information on how the system calculates the discounts to apply to a PO line.

Unit discount amount 2

From the VDS Unit Discount field for VDS Seq # 2 in the Vendor table for the vendor defined in the Vendor number field in the PO Header Interface Table (IXPHDP).

See Applying Discounts to a Purchase Order Line for more information on how the system calculates the discounts to apply to a PO line.

Unit discount amount 3

From the VDS Unit Discount field for VDS Seq # 3 in the Vendor table for the vendor defined in the Vendor number field in the PO Header Interface Table (IXPHDP).

See Applying Discounts to a Purchase Order Line for more information on how the system calculates the discounts to apply to a PO line.

Unit discount pct 1

From the VDS Discount Pct field for VDS Seq # 1 in the Vendor table for the vendor defined in the Vendor number field in the PO Header Interface Table (IXPHDP).

See Applying Discounts to a Purchase Order Line for more information on how the system calculates the discounts to apply to a PO line.

Unit discount pct 2

From the VDS Discount Pct field for VDS Seq # 2 in the Vendor table for the vendor defined in the Vendor number field in the PO Header Interface Table (IXPHDP).

See Applying Discounts to a Purchase Order Line for more information on how the system calculates the discounts to apply to a PO line.

Unit discount pct 3

From the VDS Discount Pct field for VDS Seq # 3 in the Vendor table for the vendor defined in the Vendor number field in the PO Header Interface Table (IXPHDP).

See Applying Discounts to a Purchase Order Line for more information on how the system calculates the discounts to apply to a PO line.

FOB Freight terms

Remains blank.

Extracted flag?

N defaults.

Processed by Inter

Remains blank.

Apt Code

From the APT Code field in the Vendor table for the vendor defined in the Vendor number field in the PO Header Interface Table (IXPHDP).

Buyer

From the Buyer field in the PO Header Interface Table (IXPHDP).

Offer number

From the Offer field in the PO Header Interface Table (IXPHDP).

User

INTERFACE defaults.

Warehouse

From the Warehouse field in the PO Header Interface Table (IXPHDP).

GLA Account #

From the GLA Account # field for the R Tran code in the Item Transaction Code table if the Default Receipt General Ledger Number (D95) system control value is selected.

Currency code

From the Local Currency Code (A55) system control value.

Customer #

0 defaults.

Order #

0 defaults.

Ship to #

0 defaults.

Vendor #

From the Vendor number field in the PO Header Interface Table (IXPHDP).

Ship via

From the Ship via field in the PO Header Interface Table (IXPHDP); otherwise, from the Default Purchase Order Ship Via for Purchase Order Interface (F85) system control value.

Company

From the Company field in the PO Detail Interface Table (IXPDTP).

P/O #

From the PO Number field in the PO Detail Interface Table (IXPDTP).

Seq #

From the Sequence # field in the PO Detail Interface Table (IXPDTP).

See Determining the Order of PO lines on New POs and Determining the Order of PO lines on Maintained POs.

Status

O (Open) defaults.

Line #

From the Line # field in the PO Detail Interface Table (IXPDTP).

See Determining the Order of PO lines on New POs and Determining the Order of PO lines on Maintained POs.

Cancel date

From the Cancel date field for the associated PO header in the PO Header table.

Due date

From the Due Date field in the PO Detail Interface Table (IXPDTP).

In transit qty

0 defaults.

Inventory item

Y defaults.

Order qty

From the Order qty field in the PO Detail Interface Table (IXPDTP).

Price

From the Price field in the PO Detail Interface Table (IXPDTP).

Promise date

From the Promise date field in the PO Detail Interface Table (IXPDTP).

Received qty

0 defaults.

Vendor order qty

1 defaults.

Unit discount amount

From the Discount % field in the Vendor table for the vendor defined in the Vendor number field in the PO Detail Interface Table (IXPDTP).

See Applying Discounts to a Purchase Order Line for more information on how the system calculates the discounts to apply to a PO line.

Discount override

N defaults.

Entry date

From the Entry date field in the PO Detail Interface Table (IXPDTP).

Price method

O defaults.

Vendor price

From the Price field in the PO Detail Interface Table (IXPDTP).

Vnd price curr type

From the VND price currency type field in the Vendor table for the vendor defined in the Vendor number field in the PO Detail Interface Table (IXPDTP)

Unit discount amt 1

From the Unit discount amount 1 field for the associated PO Header in the PO Header table.

See Applying Discounts to a Purchase Order Line for more information on how the system calculates the discounts to apply to a PO line.

Unit discount amt 2

From the Unit discount amount 2 field for the associated PO Header in the PO Header table.

See Applying Discounts to a Purchase Order Line for more information on how the system calculates the discounts to apply to a PO line.

Unit discount amt 3

From the Unit discount amount 3 field for the associated PO Header in the PO Header table.

See Applying Discounts to a Purchase Order Line for more information on how the system calculates the discounts to apply to a PO line.

Unit discount pct 1

From the Unit discount pct 1 field for the associated PO Header in the PO Header table.

See Applying Discounts to a Purchase Order Line for more information on how the system calculates the discounts to apply to a PO line.

Unit discount pct 2

From the Unit discount pct 2 field for the associated PO Header in the PO Header table.

See Applying Discounts to a Purchase Order Line for more information on how the system calculates the discounts to apply to a PO line.

Unit discount pct 3

From the Unit discount pct 3 field for the associated PO Header in the PO Header table.

See Applying Discounts to a Purchase Order Line for more information on how the system calculates the discounts to apply to a PO line.

Misc price 1

0.00 defaults.

Misc price 2

0.00 defaults.

Vendor discount amt

From the Discount % field in the Vendor table for the vendor defined in the Vendor number field in the PO Detail Interface Table (IXPDTP).

See Applying Discounts to a Purchase Order Line for more information on how the system calculates the discounts to apply to a PO line.

Vnd Unit disc $ 1

0.0000 defaults.

Vnd Unit disc $ 2

0.0000 defaults.

Vnd Unit disc $ 3

0.0000 defaults.

Disc variance

0.0000 defaults.

ITM Number

From the Item number field in the PO Detail Interface Table (IXPDTP).

SKU Code

From the SKU field in the PO Detail Interface Table (IXPDTP).

Unit of measure

From the Unit of Measure field in the PO Detail Interface Table (IXPDTP).

Vendor’s unit of measure

From the Vend ord qty multiple field in the Vendor Item table for the Item number and Vendor number in the PO Detail Interface Table (IXPDTP).

Buyer

From the Buyer field for the associated PO Header in the PO Header table.

GLA Account #

From the GLA Account # field for the associated PO Header in the PO Header table.

Offer number

From the Offer field for the associated PO Header in the PO Header table.

Ship via

From the Ship Via field in the PO Detail Interface Table (IXPDTP).

Vendor #

From the Vendor number field in the PO Detail Interface Table (IXPDTP).

Item

From the Item field in the Vendor Item table for the item and SKU defined in the Item number field and SKU field in the PO Detail Interface Table (IXPDTP).

Warehouse

From the Warehouse field in the PO Detail Interface Table (IXPDTP).

Company

The CWSerenade company number.

Company codes are defined in and validated against the Company table.

Corresponds to the Company field in the PO Header table.

Numeric, 3 positions; Required.

PO Number

The purchase order number that is being created or updated.

Corresponds to the PO # field in the PO Header table.

New Purchase Orders

The system:

• Validates that the PO number does not already exist in the PO Header table.

• Creates the new PO using the PO number provided, regardless of the setting of the System Assigned PO # (B76) system control value.

Maintained Purchase Orders

The system:

• Validates that the PO number exists in the PO Header table. Note: If the PO number does not already exist in the PO Header table, the system creates a new PO.

• Validates that the PO Interface Maintenance (L05) system control value is selected, allowing you to maintain POs through the PO Upload Interface.

• Validates that the status of the PO is Open and all of the lines on the PO have no receipts against them.

Numeric, 7 positions; Required.

Reference #

A reference number you can use if you have the system assign purchase order numbers and you want to track an internal purchase order number or a tracking number on the purchase order. Reference numbers can be used in PO Inquiry to scan for a specific purchase order number.

The reference number may print on the PO, depending on the print program from the PO Print Program (C64) system control value.

Note: The system requires a reference number, regardless of the setting of the PO Reference # Required (A35) system control value.

Corresponds to the Reference # field in the PO Header table.

Alphanumeric, 15 positions; Required.

Processed Status

The status of the PO Header Interface record.

Valid values are:

blank = The record has not yet been processed by the PO Upload Process.

O = The record has been processed by the PO Upload Process and no errors exist.

E = The record has been processed by the PO Upload Process and an error exists. Use the Work with PO Interface Records Screen to review and correct the error.

Alphanumeric, 1 position; Updated by the system.

Cancel Date

The date the purchase order will be marked for cancellation if you do not receive it. See Printing the PO Auto Cancel Report (MPAC).

The cancel date must be greater than the current date.

Corresponds to the Cancel date in the PO Header table.

Numeric, 7 positions (CYYMMDD format); Optional.

Confirming PO

Defines whether this is a confirming purchase order.

If this is a confirming purchase order, you can print confirming purchase orders and the purchase order will indicate that it is a confirming document when you print it; see Printing Purchase Orders.If you are using EDI to transmit orders and follow up with the printed order, the system indicates on the printed document that it is a confirmation of an EDI transmission.

Valid values:

• Y = The order was placed over the phone with a vendor and this is a confirming PO.

• N or blank = This is not a confirming PO.

Corresponds to the Confirming PO field (C6HYST) in the PO Header table.

Alphanumeric, 1 position; Optional.

Due Date

The date the purchase order is due for receipt. This is the date the operator sees in Order Entry.

The due date must be greater than the current date.

Corresponds to the Due Date field (C6C0DT) in the PO Header table.

Numeric, 7 positions (CYYMMDD format); Required.

Entry Date

The date the PO was created.

Corresponds to the Entry Date field (C6D1DT) in the PO Header table.

Numeric, 7 positions (CYYMMDD format); Required.

Negotiate Price

Determines whether the program pulls prices for items entered.

Valid values:

• Y = You must enter a price for each item.

• N or blank = The system will automatically pull prices for each item. Prices will be pulled from:

1. Vendor/Item quantity break table

2. Vendor/Item table

3. Item table

Note: Regardless of this setting, you must enter a price for each item in the PO Detail Interface Table (IXPDTP).

Corresponds to the Negotiate Price field (C6HZST) in the PO Header table.

Alphanumeric, 1 position; Optional.

Promise Date

Represents the expected ship date or promised arrival date.

Corresponds to the Promise Date field (C6C4DT) in the PO Header table.

Numeric, 7 positions (CYYMMDD format); Optional.

Placed With

The name of the person at the vendor site with whom you placed the purchase order.

Corresponds to the Placed with field (C6LJTX) in the PO Header table.

Alphanumeric, 30 positions; Optional.

Recurring PO

Determines whether you are entering a template for a recurring purchase order.

Valid values:

• Y = The system will assign an R (Recurring) status to the order. Any items and quantities on this order will not be placed “on-order.” Orders with an R status are used in the Recurring Purchase Order generation program. See Recurring Purchase Order Screen.

• N or blank = This is not a recurring PO.

Corresponds to the Recurring PO field (C6H0ST) in the PO Header table.

Alphanumeric, 1 position; Optional.

Tax Status

Indicates whether taxes are applied to the order.

Corresponds to the Tax status field (C6LLTX) in the PO Header table.

Alphanumeric, 15 positions; Optional.

Vendor Reference #

An internal reference number that may be stored with the purchase order. For example, the reference number may represent an internal purchase order number from a preprinted purchase order, or an internal control for departmental purchase orders.

Corresponds to the Vendor reference # field (C6LMTX) in the PO Header table.

Alphanumeric, 15 positions; Optional.

Shipping instructions

One line of shipping instructions to print on the purchase order.

Corresponds to the Shipping instructions field (C6LNTX) in the PO Header table.

Alphanumeric, 20 positions; Optional.

PO type

Indicates whether this purchase order is an initial buy (I) or a reorder (R).

Valid values:

I or blank = Initial buy.

R = Reorder.

Corresponds to the PO type field (C6PUSS) in the PO Header table.

Alphanumeric, 1 position; Optional.

Buyer

A code that identifies a person who is authorized to make purchases for your company.

Buyer codes are defined in and validated against the Buyer table; see Working with Buyers (WBUY).

Corresponds to the Buyer field (C6CFCD) in the PO Header table.

Alphanumeric, 3 positions; Required.

Offer

The code for the offer (catalog) you will use to sell the merchandise. See Working with Offers (WOFR).

Required if the Offer Required Entry on Purchase Orders (A36) system control value is selected. The system creates a SKU/Offer record for each item on the purchase order if one does not already exist.

Corresponds to the Offer field (C6CACD) in the PO Header table.

Alphanumeric, 3 positions; Required if SCV A36 is selected.

Warehouse

The warehouse where the items on the purchase order will be shipped.

Corresponds to the Warehouse field (C6WCDE) in the PO Header table.

Numeric, 3 positions; Required.

Vendor number

A code for the vendor (supplier) associated with the purchase order.

Corresponds to the Vendor # field (C6FYNB) in the PO Header table.

Numeric, 7 positions; Required.

Ship via

A code that identifies the shipper to deliver the merchandise to you. This code is validated against the PO Ship Via table. See Working with Purchase Order Ship Via (WPSV). These shippers are defined separately from, and may differ from, those who deliver merchandise to your customers.

The Require Ship Via on Purchase Order Header (E96) system control value controls whether this field is optional or required.

Corresponds to the Ship via code field (C6JQNB) in the PO Header table.

If you leave this field blank, the ship via code from the Default Purchase Order Ship Via for Purchase Order Interface (F85) system control value defaults to the purchase order.

Numeric, 2 positions; Required if SCV E96 is selected.

PO User Field 1

Informational only.

Corresponds to the PO user field 1 field (C6DYTT) in the PO Header table.

Alphanumeric, 10 positions; Optional.

PO User Field 2

Informational only.

Corresponds to the PO user field 1 field (C6DZTT) in the PO Header table.

Alphanumeric, 10 positions; Optional.

PO User Field 3

Informational only.

Corresponds to the PO user field 1 field (C6D0TT) in the PO Header table.

Alphanumeric, 10 positions; Optional.

PO User Field 4

Informational only.

Corresponds to the PO user field 1 field (C6D1TT) in the PO Header table.

Alphanumeric, 10 positions; Optional.

Company

The CWSerenade company code associated with the purchase order.

Company codes are defined in and validated against the Company table.

Corresponds to the Company field (C8COMP) in the PO Message table.

Numeric, 3 positions; Required.

PO Number

The PO number associated with the message. This PO number must exist in the PO Header Interface Table (IXPHDP).

Corresponds to the PO # field (C8IGNB) in the PO Message table.

Numeric, 7 positions; Required.

Sequence #

A unique number assigned to the PO header message.

Corresponds to the Seq # field (C8PCNB) in the PO Message table.

Numeric, 3 positions; Required.

Print

Indicates whether the message prints on the purchase order or receiving worksheet.

Valid values are:

B = The message prints on both the receiving worksheet and purchase order.

P = The message prints on the purchase order.

W = The message prints on the receiving worksheet.

blank = The message does not print on the purchase order or receiving worksheet.

Corresponds to the Print field (C8H3ST) in the PO Message table.

Alphanumeric, 1 position; Optional.

Message

Free form message about the vendor and/or purchase order.

Corresponds to the Message field (C8LOTX) in the PO Message table.

Alphanumeric, 60 positions; Required.

Company

The CWSerenade company code associated with the purchase order.

Company codes are defined in and validated against the Company table.

Corresponds to the Company field (ENCOMP) in the PO Detail table.

Numeric, 3 positions; Required.

PO Number

The purchase order number that is being created or updated.

Corresponds to the PO # field (ENIGNB) in the PO Detail table.

New Purchase Orders

• The system validates that the PO number does not already exist in the PO Detail table.

• Creates the new PO using the PO number provided, regardless of the setting of the System Assigned PO # (B76) system control value.

Maintained Purchase Orders

• The system validates that the PO number exists in the PO Detail table.

• The system validates that the PO Interface Maintenance (L05) system control value is selected.

• The system validates that the status of the PO is Open and all of the lines on the PO have no receipts against them.

Numeric, 7 positions; Required.

Sequence #

A unique number assigned to each PO line. Typically, the first detail line is assigned a sequence number of 1.

Note: You must enter a unique sequence number for each PO line. Also, you should use the same number for the sequence number and line number.

Corresponds to the Seq # field (ENPCNB) in the PO Detail table.

Numeric, 3 positions; Required.

Line #

The purchase order line number. There can be up to 999 lines on one purchase order.

Note: You must enter a unique line number for each PO line. Also, you should use the same number for the sequence number and line number.

Corresponds to the Line # field (ENIDNB) in the PO Detail table.

Numeric, 3 positions; Required.

Processed Status

Indicates the status of the PO Detail Interface record.

Valid values are:

blank or O = The record has not yet been processed by the PO Upload Process.

E = The record contains an error. Use the Work with PO Interface Records Screen to review and correct the error.

Alphanumeric, 1 position; optional, Updated by the system.

Due Date

The date the PO is due to be received. This date is indicated in Order Entry, Order Maintenance, and standard or streamlined Order Inquiry.

Corresponds to the Due Date field (ENCWDT) in the PO Detail table.

Numeric, 7 positions (CYYMMDD format); Required.

Order qty

The quantity of the item (in retailer’s unit of measure) being ordered from the vendor.

Corresponds to the Order qty field (ENKIQT) in the PO Detail table.

Numeric, 7 positions; Required.

Price

The unit price you pay the vendor for this item.

Corresponds to the Price field (ENSIPR) in the PO Detail table.

Numeric, 11 positions with a 4-place decimal; Required.

Promise date

The expected ship date or promised arrival date for the PO line. If you do not define a promise date for the PO line, the system defaults the promise date defined on the purchase order header to the line.

Corresponds to the Promise Date field (ENCXDT) in the PO Detail table.

Numeric, 7 positions (CYYMMMDD format); Optional.

Entry date

The date the PO line was added to the PO.

Corresponds to the Entry date field (ENINDT) in the PO Detail table.

Numeric, 7 positions (CYYMMDD format); Required.

Item number

The item being ordered. Must be a valid item, in retailer’s item code (not vendor item code).

Corresponds to the ITM Number field (ENBECD) in the PO Detail table.

Alphanumeric, 12 positions; Required.

SKU

The SKU code for the item.

Corresponds to the SKU Code field (ENBESK) in the PO Detail table.

Alphanumeric, 14 positions; Required if the item contains SKUs.

Unit of Measure

The unit of measure defined for the item.

Corresponds to the Unit of measure field (ENCDCD) in the PO Detail table.

Alphanumeric, 3 positions; Required.

Vendor number

The code that identifies the vendor or supplier of the item.

Corresponds to the Vendor # field (ENFYNB) in the PO Detail table.

Numeric, 7 positions; Required.

Warehouse

A code that represents the warehouse where the merchandise will be received. On order quantity is increased in this warehouse. Validated against the Warehouse table. See Creating and Maintaining Warehouses (WWHS).

Corresponds to the Warehouse field (ENWCDE) in the PO Detail table.

Numeric, 3 positions; Required.

Ship Via

A code that represents a carrier used for shipping merchandise to your company. This code is validated against the PO Ship Via table. See Working with Purchase Order Ship Via (WPSV).These shippers are defined separately from, and may differ from, those who deliver merchandise to your customers.

Corresponds to the Ship via field (ENJQNB) in the PO Detail table.

Numeric, 2 positions; Required.

Company

The CWSerenade company code.

Company codes are defined in and validated against the Company table.

Corresponds to the Company field (C5COMP) in the PO Detail Message table.

Numeric, 3 positions; Required.

PO number

Corresponds to the PO # field (C5IGNB) in the PO Detail Message table.

Numeric, 7 positions; Required.

Sequence #

The purchase order line sequence number associated with the message.

Corresponds to the Seq # field (C5PCNB) in the PO Detail Message table.

Numeric, 3 positions; Required.

Sequence #

The unique sequence number assigned to the PO line message.

Corresponds to the Message Seq # field (C5PCNB) in the PO Detail Message table.

Numeric, 3 positions; Required.

Print

Indicates whether the message prints on the purchase order or receiving worksheet.

Valid values are:

B = The message prints on both the receiving worksheet and purchase order.

P = The message prints on the purchase order.

W = The message prints on the receiving worksheet.

blank = The message does not print on the purchase order or receiving worksheet.

Corresponds to the Print field (C5HXST) in the PO Detail Message table.

Alphanumeric, 1 position; Optional.

Message

Free form message about the purchase order line.

Corresponds to the Message field (C5LITX) in the PO Detail Message table.

Alphanumeric, 60 positions; Required.