Chapter 71: Working with the PO Interface Files (GPOI, RPOI, WPOI)

Chapter 71: Working with the PO Interface Files (GPOI, RPOI, WPOI)

Purpose: The E3 Interface lets you transfer purchase order information from the E3 Forecasting system to CWDirect. Once the purchase order information is received from the E3 system, CWDirect edits the information and, if the information is valid, creates a purchase order using the information provided.

Populate Order Header and Detail Upload files: To create a purchase order using information from the E3 system, you must populate the Order Header Upload File (IXOHUP) and Order Detail Upload File (IXODUP).

Once you populate these files, you use the Load PO Interface Screen to generate the purchase order interface files:

• Purchase Order Header Interface File (IXPHDP)

• Purchase Order Header Interface Message File (IXPHMP)

• Purchase Order Detail Interface File (IXPDTP)

• Purchase Order Detail Interface Message File (IXPDMP)

Process updates: When you generate the Purchase Order Interface files, the system:

• transfers information defined in the Order Header Upload and Order Detail Upload files to the Purchase Order Interface Header, Detail, Header Message, and Detail Message files.

• deletes the transferred records from the Order Header Upload and Order Detail Upload files.

• verifies that:

• an order header upload record does not exist without an associated order detail upload record.

• an order detail upload record does not exist without an associated order header upload record.

• all required fields in the Order Header Upload and Order Detail Upload contain information.

• fields in the Order Header Upload and Order Detail Upload are validated against existing CWDirect files.

If a record passes all of the edits performed, the system:

• creates a CWDirect purchase order. You can review or maintain the purchase order in Purchase Order Inquiry (MPOI). The system defaults the value INTERFACE in the User field to indicate that the purchase order was created through the Purchase Order Interface.

• submits the purchase order to the OTHR_ASYNC job for processing.

• deletes the records from the Purchase Order Interface files.

• prints the purchase order on the PO Interface - Accepted PO Report.

Create IL trigger record? If the Create Generic Inventory Download Triggers (I32) and Include PO Updates (J93) system control values are set to Y, the system creates an inventory download trigger record whenever you create a purchase order for an item whose available quantity is zero or less. See these two system control values for more information.

Send item availability information to web storefront? If any of the items on the purchase order have been downloaded to the web storefront, and their current available quantity is zero or less, the OTHR_ASYNC job sends updated availability information job when it processes the PO maintenance updates. See E-Commerce Item Availability Processing for an overview.

Purchase order held automatically? When it creates the purchase order, the system puts it in held status if:

• the PO Default Status (A49) system control value is set to HELD, or

• the purchase order total meets or exceeds the Total Purchase Order Entry Dollar Limit (J91) system control value

See those system control values for more information.

If a record does not pass all of the edits, the system:

• prints the record on the PO Interface - Error Report.

• retains the record in the Purchase Order Interface files in an error status until the record is fixed or deleted. You can work with purchase order interface records that are in an error status using Working with Purchase Order Interface Records (WPOI).

E3 PO Interface Process:

Note: The Auto-Generate Item Warehouse Records (J45) system control value does not apply to purchase order interface processing. If there is not already a record of the item in the warehouse indicated, the purchase order interface record will be in error.

In this chapter:

• Order Header Upload File (IXOHUP)

• Order Detail Upload File (IXODUP)

• Generating the PO Interface Files (GPOI)

• Edits Performed

• PO Interface - Accepted PO Report

• PO Interface - Error Report

• Purchase Order Header Interface File (IXPHDP)

• Purchase Order Header Interface Message File (IXPHMP)

• Purchase Order Detail Interface File (IXPDTP)

• Purchase Order Detail Interface Message File (IXPDMP)

• Working with Purchase Order Interface Records (WPOI)

• Work with PO Interface Records Screen

• Change PO Header Interface Screen

• Display Purchase Order Header Interface Screen

• Change PO Header Interface Messages Screen

• First PO Interface - Maintain Detail Screen

• Second PO Interface Maintain Detail Screen (Changing)

• Display Purchase Order Detail Interface Screen

• Change PO Detail Interface Message Screen

• Rerun Purchase Order Interface File Edit (RPOI)

• Rerun PO Interface Edit Screen

Order Header Upload File (IXOHUP)

Purpose: The system uses this file to generate the Purchase Order Header Interface File (IXPHDP) and Purchase Order Header Interface Message File (IXPHMP) when you use Generating the PO Interface Files (GPOI).

E3 Field Name	E3 Attributes	CWDirect Field Name	CWDirect Attributes	Field Description
OHVNDR	Alphanumeric, 8 positions	Vendor number	Numeric, 7 positions	CWDirect vendor number. The first 7 positions of the E3 vendor number is in the Vendor number field. The system assigns the currency rate, terms code, and any discounts defined for this vendor to the purchase order.
OHWHSE	Alphanumeric, 3 positions	Warehouse	Numeric, 3 positions	The system uses the warehouse cross-reference code defined in Working with Warehouse Cross-References (WWXR) to determine the CWDirect warehouse.
OHPOID	Numeric, 7 positions	Reference number	Alphanumeric, 15 positions	A unique identifier for the header, detail, and message records. This field links the E3 Order Header Upload and E3 Order Detail Upload files.
OHPKUP	Alphanumeric, 1 position	OHPKUP does not map to a CWDirect field.	Alphanumeric, 1 position	This field is blank.
OHORDD	Numeric, 8 positions (YYYYMMDD format)	Entry date	Numeric, 6 positions (YYMMDD format)	The CWDirect purchase order header entry date.
OHDUED	Numeric, 8 positions (YYYYMMDD format)	Due date	Numeric, 6 positions (YYMMDD format)	The CWDirect purchase order header due date.
OHBUYR	Alphanumeric, 3 positions	Buyer	Alphanumeric, 3 positions	The CWDirect purchase order header buyer code.
OHCOM1	Alphanumeric, 78 positions	PO Header Message	Alphanumeric, 60 positions	A CWDirect purchase order header message. The first 60 positions of the E3 comment 1 is in the first available purchase order header message field.
OHCOM2	Alphanumeric, 78 positions	PO Header Message	Alphanumeric, 60 positions	A CWDirect purchase order header message. The first 60 positions of the E3 comment 2 is in the first available purchase order header message field.
OHCOM3	Alphanumeric, 78 positions	PO Header Message	Alphanumeric, 60 positions	A CWDirect purchase order header message. The first 60 positions of the E3 comment 3 is in the first available purchase order header message field.
OHCOM4	Alphanumeric, 78 positions	PO Header Message	Alphanumeric, 60 positions	A CWDirect purchase order header message. The first 60 positions of the E3 comment 4 is in the first available purchase order header message field.
OHCOM5	Alphanumeric, 78 positions	PO Header Message	Alphanumeric, 60 positions	A CWDirect purchase order header message. The first 60 positions of the E3 comment 5 is in the first available purchase order header message field.
OHCOM6	Alphanumeric, 78 positions	PO Header Message	Alphanumeric, 60 positions	A CWDirect purchase order header message. The first 60 positions of the E3 comment 6 is in the first available purchase order header message field.
OHFAXF	Alphanumeric, 1 position	No map to this field.	Alphanumeric, 1 position	This field is informational only.
OHCONF	Alphanumeric, 1 position	Confirming PO	Alphanumeric, 1 position	Defines whether this purchase order represents a confirmation copy because it was previously communicated to the vendor by phone. When you print or email a purchase order that is flagged as a confirming PO, the system includes the statement Confirming PO Only. Y = The purchase order represents a confirmation copy because it was previously communicated to the vendor by phone. N or blank = This is not a confirming purchase order.
OHCAND	Numeric, 8 positions (YYYYMMDD format)	Cancel date	Numeric, 6 positions (YYMMDD format)	The CWDirect purchase order header cancel date. If a cancel date is passed, the system uses this date; if a cancel date is not passed, the system calculates the cancel date by adding 7 days to the due date: due date + 7 days = cancel date.
OHUDT1	Numeric, 8 positions (YYYYMMDD format)	No map		This field is set to 0.
OHUDT2	Numeric, 8 positions (YYYYMMDD format)	No map		This field is set to 0.
OHFIL1	Alphanumeric, 200 positions	No map		This field is blank.

Order Detail Upload File (IXODUP)

Purpose: The system uses this file to generate the Purchase Order Detail Interface File (IXPDTP) and Purchase Order Detail Interface Message File (IXPDMP) when you use Generating the PO Interface Files (GPOI).

E3 Field Name	E3 Attributes	CWDirect Field Name	CWDirect Attributes	Field Description
ODVNDR	Alphanumeric, 8 positions	Vendor number	Numeric, 7 positions	The CWDirect vendor number.
ODITEM	Alphanumeric, 18 positions	Item number SKU code	Alphanumeric, 12 positions Alphanumeric, 14 positions	The first 5 positions of the item from the E3 file map to the Item number, and positions 6 through 14 map to the SKU. If the CWDirect item code exceeds 5 positions, or if the SKU code exceeds 9 positions, the purchase order upload record will be in error.
ODWHSE	Alphanumeric, 3 positions	Warehouse	Numeric, 3 positions	The system uses the warehouse cross-reference code defined in Working with Warehouse Cross-References (WWXR) to determine the CWDirect warehouse. Note: If there is not already a record of the item in this warehouse, the purchase order interface record will be in error.
ODINAM	Alphanumeric, 35 positions	No map		The CWDirect item description defaults in this field when the CWDirect purchase order is created.
ODORDQ	Numeric, 7 positions	Quantity	Numeric, 7 positions	The CWDirect order quantity.
ODORDD	Numeric, 8 positions (YYYYMMDD format)	Entry date	Numeric, 6 positions (YYMMDD format)	The CWDirect purchase order detail entry date.
ODDUED	Numeric, 8 positions (YYYYMMDD format)	Due date	Numeric, 6 positions (YYMMDD format)	The CWDirect purchase order detail due date.
ODPCHP	Numeric, 9 positions with a 4-place decimal	Price	Numeric, 11 positions with a 4-place decimal	The CWDirect price (the CWDirect price represents the Cost field in Purchase Order Entry).
ODPOID	Numeric, 7 positions	No map		A unique identifier for the header, detail, and message records. This field is the link between the E3 Order Header Upload and E3 Order Detail Upload files.
ODUOM	Alphanumeric, 2 positions	UOM	Alphanumeric, 3 positions	The CWDirect unit of measure.
ODDBBK	Numeric, 9 positions with a 4-place decimal	No map		This field is set to 0.
ODDOIN	Numeric, 9 positions with a 4-place decimal	No map		This field is set to 0.
ODFWBQ	Numeric, 7 positions	No map		This field is set to 0.
ODFWBD	Numeric, 3 positions	No map		This field is set to 0.
ODXDYS	Numeric, 3 positions	No map		This field is set to 0.
ODCOM1	Alphanumeric, 78 positions	PO detail message	Alphanumeric, 60 positions	A CWDirect purchase order detail message. The first 60 positions of the E3 comment 1 is in the first available purchase order detail message field.
ODCOM2	Alphanumeric, 78 positions	PO detail message	Alphanumeric, 60 positions	A CWDirect purchase order detail message. The first 60 positions of the E3 comment 2 is in the first available purchase order detail message field.
ODCOM3	Alphanumeric, 78 positions	PO detail message	Alphanumeric, 60 positions	A CWDirect purchase order detail message. The first 60 positions of the E3 comment 3 is in the first available purchase order detail message field.
ODFIL1	Alphanumeric, 100 positions	No map		This field is set to 0.

Generating the PO Interface Files (GPOI)

Purpose: Use this screen to generate the following files using information defined in the Order Header Upload File (IXOHUP) and Order Detail Upload File (IXODUP):

• Purchase Order Header Interface File (IXPHDP)

• Purchase Order Header Interface Message File (IXPHMP)

• Purchase Order Detail Interface File (IXPDTP)

• Purchase Order Detail Interface Message File (IXPDMP)

Load PO Interface Screen

If there are no errors in any on the Purchase Order Interface files, the system automatically creates a CWDirect purchase order.

How to display this screen: Enter GPOI in the Fast path field at the top of any menu or select Generate PO Interface Files from a menu.

POR0493 ENTER Load PO Interface 12/04/98 8:12:28

KAL Co.

** Pressing Enter will Submit a job to load the PO Interface Files.**

F3=Exit F12=Cancel F24=Select Company

Step-by-step instructions: Press Enter to generate the Purchase Order Interface files. The system submits the job LODPOINTER.

You can also generate the Purchase Order Interface files by submitting the RUNPOINTR batch job in Rerun Purchase Order Interface File Edit (RPOI) or the EDTCRTPOIN batch job in Working with Purchase Order Interface Records (WPOI).

Note: The system creates purchase order interface files from the data in the company where you submitted the batch job.

Edits Performed

The LODPOINTER, RUNPOINTR, and EDTCRTPOIN batch programs verify that:

• an order header upload record does not exist without an associated order detail upload record.

• an order detail upload record does not exist without an associated order header upload record.

• the Reference number, Vendor number, Buyer, Due date, and Warehouse fields in the Order Header Upload File (IXOHUP) contain information.

• the Sequence number, Item, SKU, Quantity, Price, and Due date fields in the Order Detail Upload File (IXODUP) contain information.

• the Vendor, Buyer, and Warehouse fields in the Order Header Upload are validated against the appropriate CWDirect file.

• the Vendor, Item, and SKU fields in the Order Detail Upload are validated against the appropriate CWDirect file.

If a record passes all of the edits performed, the system:

• submits the purchase order to the OTHR_ASYNC job for processing.

• deletes the records from the Purchase Order Interface files.

• prints the purchase order on the PO Interface - Accepted PO Report. This report lists CWDirect purchase order numbers and the associated interface reference numbers that have been accepted.

Purchase order held automatically? When it creates the purchase order, the system puts it in held status if:

• the PO Default Status (A49) system control value is set to HELD, or

• the purchase order total meets or exceeds the Total Purchase Order Entry Dollar Limit (J91) system control value

See those system control values for more information.

If a record does not pass all of the edits performed, the system:

• prints the record on the PO Interface - Error Report. This report lists CWDirect purchase order numbers and the associated interface reference numbers that are in error.

• retains the record in the Purchase Order Interface files in an error status until the record is fixed or deleted. You can work with purchase order interface records that are in an error status in Working with Purchase Order Interface Records (WPOI).

Purchase Order Header Interface File (IXPHDP)

Purpose: The system produces this file when you use the Generating the PO Interface Files (GPOI) to generate the Purchase Order Header file.

PO Interface Field Name	CWDirect PO Field Name	CWDirecte Attributes	E3 Upload Field Name	E3 Upload Attributes	Field Description
Company	C6COMP	Numeric, 3 positions; key field	No map		CWDirect company number.
PO number	C6IGNB	Numeric, 7 positions; key field	No map		The system assigns the next purchase order number based on the current value in the Last number field for the Purchase Order Header counter in the Number Assignment file.
Reference number	C6LKTX	Alphanumeric, 15 positions	OHPOID	Numeric, 7 positions	A unique identifier for the header, detail, and message records. This number is the link between the E3 Order Header Upload and E3 Order Detail Upload files.
Processed status	No map	Alphanumeric, 1 position	No map		The status of the PO Interface Header record. Valid values are: O = open E = error
Cancel date	C6CZDT	Numeric, 6 positions (CYYMMDD format)	OHCAND	Numeric, 8 positions (YYYYMMDD format)	The CWDirect purchase order header cancel date. The system calculates the cancel date by adding 7 days to the due date: due date + 7 days = cancel date.
Confirming PO	C6HYST	Alphanumeric, 1 position	OHCONF	Alphanumeric, 1 position	The CWDirect Confirming PO value. Valid values are: Y = This is a confirming purchase order. N (or blank) = This is not a confirming purchase order.
Due date	C6C0DT	Numeric, 6 positions	OHDUED	Numeric, 8 positions	The CWDirect purchase order header due date.
Entry date	C6D1DT	Numeric, 6 positions (CYYMMDD format)	OHORDD	Numeric, 8 positions (YYYYMMDD format)	The CWDirect purchase order header entry date.
Negotiate Price	C6HZST	Alphanumeric, 1 position	No map		N defaults in this field.
Promise date	C6C4DT	Numeric, 6 positions (CYYMMDD format)	No map		This field is set to 0.
Placed with	C6LJTX	Alphanumeric, 30 positions	No map		This field is blank.
Recurring PO	C6H0ST	Alphanumeric, 1 position	No map		N is in this field.
Tax status	C6LLTX	Alphanumeric, 15 positions	No map		This field is blank.
Vendor reference #	C6LMTX	Alphanumeric, 15 positions	No map		This field is blank.
Shipping instructions	C6LNTX	Alphanumeric, 20 positions	No map		This field is blank.
PO type	C6PUSS	Alphanumeric, 1 position	No map		I is in this field, representing an initial buy.
Buyer	C6CFCD	Alphanumeric, 3 position	OHBUYR	Alphanumeric, 3 positions	The CWDirect purchase order header buyer code.
Offer	C6CACD	Alphanumeric, 3 positions	No map		The offer number associated with this purchase order.
Warehouse	C6WCDE	Numeric, 3 positions	OHWHSE	Alphanumeric, 3 positions	The warehouse code associated with the warehouse cross reference code defined in Working with Warehouse Cross-References (WWXR).
Vendor number	C6FYNB	Numeric, 7 positions	OHVNDR	Alphanumeric, 8 positions	The CWDirect vendor number.
Ship via	C6JQNB	Numeric, 2 positions	No map		The ship via code defined in the Default Purchase Order Ship Via for Purchase Order Interface (F85) system control value defaults in this field.
PO user field 1	C6DYTT	Alphanumeric, 10 positions	No map		This field is informational only.
PO user field 2	C6DZTT	Alphanumeric, 10 positions	No map		This field is informational only.
PO user field 3	C6D0TT	Alphanumeric, 10 positions	No map		This field is informational only.
PO user field 4	C6D1TT	Alphanumeric, 10 positions	No map		This field is informational only.
PO future use sts 1	C6DKSY	Alphanumeric, 2 positions	No map		This field is informational only.
PO future use Y/N 1	C6DMSY	Alphanumeric, 1 position	No map		This field is informational only.
PO future use value 1	C6NWVD	Numeric, 11 positions with a 2-place decimal	No map		This field is informational only.
PO future use code 1	C6TKCG	Alphanumeric, 10 positions	No map		This field is informational only.
PO future use qty 1	C6QLQX	Numeric, 5 positions	No map		This field is informational only.
PO future use date 1	C6XRDT	Numeric, 7 positions (CYYMMDD format)	No map		This field is informational only.
PO future use percent 1	C601PC	Numeric, 5 positions with a 2-place decimal	No map		This field is informational only.

Purchase Order Header Interface Message File (IXPHMP)

Purpose: The system produces this file when you use the Generating the PO Interface Files (GPOI) to generate the Purchase Order Message file.

PO Interface Field Name	CWDirect PO Field Name	CWDirect Attributes	E3 Upload Field Name	E3 Upload Attributes	Field Description
Company	C8COMP	Numeric, 3 positions; key field	No map		The CWDirect company code.
PO number	C8IGNB	Numeric, 7 positions; key field	No map		The system assigns the next purchase order number based on the current value in the Last number field for the Purchase Order Header counter in the Number Assignment file.
Sequence #	C8PCNB	Numeric, 3 positions; key field	No map		A unique number used to identify multiple E3 header comment messages.
Print	C8H3ST	Alphanumeric, 1 position	No map		This value indicates whether the message prints on the purchase order. Valid values are: P = Print this message on the purchase order. blank = Do not print this message on the purchase order.
Message	C8LOTX	Alphanumeric, 60 positions	OHCOM1 OHCOM2 OHCOM3 OHCOM4 OHCOM5 OHCOM6	Alphanumeric, 78 positions	The first 60 positions of the purchase order message.

Purchase Order Detail Interface File (IXPDTP)

Purpose: The system produces this file when you use the Generating the PO Interface Files (GPOI) to generate the Purchase Order Detail file.

PO Interface Field Name	CWDirect PO Field Name	CWDirect Attributes	E3 Upload Field Name	E3 Upload Attributes	Field Description
Company	ENCOMP	Numeric, 3 positions; key field	No map		CWDirect company code.
PO number	ENIGNB	Numeric, 7 positions; key field	No map		The system assigns the next purchase order number based on the current value in the Last number field for the Purchase Order Header counter in the Number Assignment file.
Sequence #	ENPCNB	Numeric, 5 positions; key field	No map		A unique number to identify each detail line on the purchase order when multiple detail records are sent from the E3 system. The first detail line is assigned a sequence number of 1.
Line #	ENIDNB	Numeric, 3 positions	No map		The CWDirect purchase order detail line number.
Processed status	No map	Alphanumeric, 1 position	No map		This value indicates the status of the Purchase Order Detail Interface record. Valid values are: O = open E = error
Due date	ENCWDT	Numeric, 6 positions (CYYMMDD format)	ODDUED	Numeric, 8 positions (YYYYMMDD format)	The CWDirect purchase order detail due date.
Order qty	ENKIQT	Numeric, 7 positions	ODORDQ	Numeric, 7 positions	The CWDirect order quantity.
Price	ENSIPR	Numeric, 11 positions with a 4-place decimal	ODPCHP	Numeric, 9 positions with a 4-place decimal	The CWDirect price (the CWDirect price represents the Cost field in Purchase Order Entry).
Promise date	ENCXDT	Numeric, 6 positions	No map		The promise date defined on the purchase order header defaults.
Entry date	ENINDT	Numeric, 6 positions	ODORDD	Numeric, 8 positions (YYYYMMDD format)	The CWDirect purchase order detail entry date.
Item number	ENBECD	Alphanumeric, 12 positions	ODITEM	Alphanumeric, 18 positions	The first 5 positions of the E3 item number.
SKU	ENBESK	Alphanumeric, 14 positions	ODITEM		Positions 6-9 of the E3 item number.
Unit of measure	ENCDCD	Alphanumeric, 3 positions	ODUOM	Alphanumeric, 2 positions	The CWDirect unit of measure for this item.
Vendor number	ENFYNB	Numeric, 7 positions	ODVNDR	Alphanumeric, 8 positions	The CWDirect vendor number.
Warehouse	ENWCDE	Numeric, 3 positions	ODWHSE	Alphanumeric, 3 positions	The warehouse code associated with the warehouse cross-reference code defined in Work with Warehouse Cross Reference (fast path = WWXR).
Ship via	ENJQNB	Numeric, 2 positions	No map		The CWDirect ship via code.

Purchase Order Detail Interface Message File (IXPDMP)

Purpose: The system produces this file when you use the Generating the PO Interface Files (GPOI) to generate the Purchase Order Detail Message file.

PO Interface Field Name	CWDirect PO Field Name	CWDirect Attributes	E3 Upload Field Name	E3 Upload Attributes	Field Description
Company	C5COMP	Numeric, 3 positions; key field	No map		The CWDirect company code.
PO number	C5IGNB	Numeric, 7 positions; key field	No map		The system assigns the next purchase order number based on the current value in the Last number field for the Purchase Order Header counter in the Number Assignment file.
Sequence #	C5PCNB	Numeric, 3 positions; key field	No map		A unique number used to identify multiple E3 detail comment messages.
Sequence #	C5PCNB	Numeric, 3 positions; key field	No map		This value identifies the multiple E3 header comment messages.
Print	C5HXST	Alphanumeric, 1 position	No map		This value indicates whether the message prints on the purchase order. Valid values are: P = Print this message on the purchase order. blank = Do not print this message on the purchase order.
Message	C5LITX	Alphanumeric, 60 positions	OHCOM1 OHCOM2 OHCOM3	Alphanumeric, 78 positions	The first 60 positions of the purchase order message.

Working with Purchase Order Interface Records (WPOI)

Purpose: Use this screen to review, change, or delete purchase order interface records that are in an error status. Once you correct the errors on the purchase order interface records, you can submit the LODPOINTER, RUNPOINTR or EDTCRTPOIN batch programs to validate the information and create CWDirect purchase orders.

Work with PO Interface Records Screen

How to display this screen: Enter WPOI in the Fast path field at the top of any menu or select Work with PO Interface Records from a menu.

POX0519 DISPLAY Work With PO Interface records 12/04/98 13:22:22

KAL Co.

Opt PO # STS Reference# Due Date Vendor #

Type options, press Enter.

2=Change 4=Delete 5=Display 8=Details 23=Message

565 E 0005554 11/19/98 101

569 E 0005551 12/11/98 100000

570 E 0005552 12/11/98 100000

571 O 0005553 12/11/98 101

F3=Exit F9=Submit F12=Cancel F24=Select Company

Field	Description
PO#	The CWDirect purchase order number assigned to this Purchase Order Interface Header record. If the System Assigned PO # (B76) system control value is set to Y, the system assigns the next purchase order number based on the current value in the Last number field for the Purchase Order Header counter in the Number Assignment file. Numeric, 7 positions; optional.
STS (Purchase order interface record status)	This value indicates the status of the purchase order interface record. Valid values are: O = Open. The purchase order interface record does not contain errors. E = Error. The purchase order interface record contains errors. Alphanumeric, 1 position; display-only.
Reference# (Purchase order interface record reference number)	A unique number assigned to each purchase order interface record. The reference number links the purchase order interface records together: • purchase order header interface record • purchase order header interface message record • purchase order detail interface record • purchase order detail interface message record In order to create a CWDirect purchase order, you must assign the same reference number to a purchase order header interface record and a purchase order detail interface record. Numeric, 15 positions; optional.
Due date	The date this purchase order is due. Numeric, 6 positions (MMDDYY format); optional.
Vendor #	A code that identifies the vendor or supplier of an item. Numeric, 7 positions; optional.

Screen Option	Procedure
Change a purchase order interface record	Enter 2 next to a purchase order interface record to advance to the Change PO Header Interface Screen.
Delete a purchase order interface record	Enter 4 next to a purchase order interface record to delete it. Note: When you delete a purchase order header interface record, the system also deletes the associated purchase order header interface messages, purchase order detail interface records, and purchase order detail interface messages.
Display a purchase order interface record	Enter 5 next to a purchase order interface record to advance to the Display Purchase Order Detail Interface Screen.
Work with purchase order interface detail records	Enter 8 next to a purchase order interface record to advance to the First PO Interface - Maintain Detail Screen.
Change a purchase order interface header message	Enter 23 next to a purchase order interface record to advance to the Change PO Header Interface Screen.
Submit the EDTCRTPOIN batch job to edit the purchase order interface records	Press F9. See Edits Performed for more information on the edits the system performs to create a CWDirect purchase order.

Change PO Header Interface Screen

Purpose: Use this screen to correct any errors that may exist on the purchase order header interface record. When you press Enter on this screen, the system highlights the fields that are in error so that you can correct them.

How to display this screen: On the Work with PO Interface Records Screen, enter 2 next to a purchase order interface record.

POX0521 CHANGE Change PO Header Interface 12/04/98 15:08:02

KAL Co.

PO Number . . . . : 565

Reference # . . . : 0005554

PO Header Status . . . . . .: O

Cancel Date . . . . 112698 Confirming PO Y

Due Date . . . . . 111998 Entry Date . . 111798

Negotiate Price . . N Promise Date .

Placed With . . . .

Recurring PO . . . N Tax Status . .

Vendor Reference # Shipping Instrc

PO Type . . . . . . I

Buyer . . . . . . . BTM BERNADETTE T MIRANDA

Offer . . . . . . .

Warehouse . . . . . 40 WAREHOUSE 40

Vendor # . . . . . 101 US VENDOR

Ship Via . . . . . 1 BEST WAY SHIPPER

PO User Field 1 . . PO User Field 2

PO User Field 3 . . PO User Field 4

F3=Exit F12=Cancel F23=Message

Field	Description
PO number	The CWDirect purchase order number assigned to this Purchase Order Interface Header record. If the System Assigned PO # (B76) system control value is set to Y, the system assigns the next purchase order number based on the current value in the Last number field for the Purchase Order Header counter in the Number Assignment file. Numeric, 7 positions; display-only.
Reference #	A unique number assigned to each purchase order interface record. The reference number links the purchase order interface records together: • purchase order header interface record • purchase order header interface message record • purchase order detail interface record • purchase order detail interface message record In order to create a CWDirect purchase order, you must specify the same reference number for a purchase order header interface record and a purchase order detail interface record. Numeric, 15 positions; display-only.
PO header status	This value indicates the status of the purchase order header interface record. Valid values are: O = Open. The purchase order header interface record does not contain errors. E = Error. The purchase order header interface record contains errors. Alphanumeric, 1 position; display-only.
Cancel date	The date that the purchase order should be flagged for cancellation. This date must be greater than the current date. The system uses the following calculation to determine the cancel date: due date + 7 days = cancel date. Numeric, 6 positions (MMDDYY format); required.
Confirming PO	This value determines whether this is a confirming purchase order. If this is a confirming purchase order, during PO print, you can print confirming purchase orders and the purchase order will indicate that it is a confirming document. Valid values are: Y = This is a confirming purchase order. N (default) = This is not a confirming purchase order. Alphanumeric, 1 position; required.
Due date	The date when the item is due from the vendor. Numeric, 6 positions (MMDDYY format); required.
Entry date	The date the purchase order was entered. Numeric, 6 positions (MMDDYY format); required.
Negotiate price	This value determines whether the system pulled prices for each item entered. Valid values are: Y = You must enter a price for each item. N (default) = The system automatically pulled a price for each item. Prices are pulled from: • Vendor/Item Price Break file • Vendor/Item file • Item file Alphanumeric, 1 position; required.
Promise date	The date after which the item can be committed to customers. Numeric, 6 positions (MMDDYY format); optional.
Placed with	The name of the person at the vendor site with whom the purchase order was placed. Alphanumeric, 30 positions; optional.
Recurring PO	This value determines whether you are entering a template for a recurring purchase order. Valid values are: Y = The system assigns an R (recurring) status to the order. Any items and quantities on this order are not placed “on-order.” Orders with an R status are used in the Recurring PO generation program. N (default) = This is not a recurring purchase order. Alphanumeric, 1 position; required.
Tax status	The tax exempt number for the purchase order. Alphanumeric, 15 positions; optional.
Vendor reference #	The vendor's reference number for printing on the purchase order. Alphanumeric, 15 positions; optional.
Shipping instrc (Shipping instructions)	One line of shipping information to print on the purchase order. Alphanumeric, 20 positions; optional.
PO type	Indicates whether this purchase order is an initial buy or a recurring purchase order. Valid values are: I (default) = This purchase order is an initial buy. R = This purchase order is a recurring purchase order. Alphanumeric, 1 position; required.
Buyer	A code to identify a buyer. The buyer description displays to the right of this field. The system validates the buyer code against the Buyer file; see Chapter 17: Working with Buyers (WBUY). Alphanumeric, 3 positions; required.
Offer	The code for the offer (catalog) you will use to sell the merchandise to your customers. This field is required if the Offer Required Entry on Purchase Orders (A36) system control value is set to Y. The system validates the offer code against the Offer file. Alphanumeric, 3 positions; optional.
Warehouse	A code to identify the warehouse. The warehouse description displays to the right of this field. The system validates the warehouse code against the Warehouse file. Numeric, 3 positions; required.
Vendor #	A code to identify the vendor or supplier of an item. The vendor number displays to the right of this field. The system validates the vendor code against the Vendor file; see Chapter 19: Working with Vendors (WVEN). Numeric, 7 positions; required.
Ship via	A code that identifies the shipper to deliver the merchandise. The ship via code is validated against the PO Ship Via file. This field is required if the Require Ship Via on Purchase Order Header (E96) system control value is set to Y. The system validates the ship via code against the PO Ship Via file; see Chapter 18: Working with Purchase Order Ship Via (WPSV). Numeric, 2 positions; optional.
PO user field 1	This field is informational only. Alphanumeric, 10 positions; optional.
PO user field 2	This field is informational only. Alphanumeric, 10 positions; optional.
PO user field 3	This field is informational only. Alphanumeric, 10 positions; optional.
PO user field 4	This field is informational only. Alphanumeric, 10 positions; optional.

Step-by-step instructions:

1. Enter any changes you wish to make. The system validates your entries and highlights any fields that you need to correct. Correct any errors.

2. You advance to the First PO Interface - Maintain Detail Screen, where you can work with the detail records associated with the header record you just changed.

Screen Option	Procedure
Review purchase order header interface messages	Press F23 to advance to the Change PO Header Interface Messages Screen.

Display Purchase Order Header Interface Screen

To display: Enter 5 next to a header record at the Work with PO Interface Records Screen to advance to the Display Purchase Order Header Interface screen. You cannot change any information on this screen. See Change PO Header Interface Screen for field descriptions.

Change PO Header Interface Messages Screen

Purpose: Use this screen to review and change purchase order header interface messages.

How to display this screen:

• enter 23 next to a header record on the Work with PO Interface Records Screen.

• press F23 on the Change PO Header Interface Screen.

POX0522 CHANGE Change PO Interface Header Messages 12/08/98 11:59:40

KAL Co.

PO Number : 572

Reference # 0005554

PO Header Status . : E

Message Print

PLEASE DELIVER TO BACK WAREHOUSE DOOR P

RECEIVERS DOUBLE CHECK THE PACKING P

WHEN DELIVERING, ASK FOR RAUL FOR SIGNATURE ON SLIP P

FRAGILE ITEMS ARE BUBBLE WRAPPED P

HANDLE WITH CARE P

IF RAUL NOT AVAILABLE, ASK FOR JONAS P

F3=Exit F12=Cancel

Field	Description
PO number	The CWDirect purchase order number assigned to this Purchase Order Interface Header Message record. Numeric, 7 positions; display-only.
Reference #	A unique number assigned to each purchase order interface record. The reference number links the purchase order interface records together: • purchase order header interface record • purchase order header interface message record • purchase order detail interface record • purchase order detail interface message record In order to create a CWDirect purchase order, you must specify the same reference number for a purchase order header interface record and a purchase order detail interface record. Numeric, 15 positions; display-only.
Status	This value indicates the status of the purchase order interface record. Valid values are: O = Open. The purchase order interface record does not contain errors. E = Error. The purchase order interface record contains errors. Alphanumeric, 1 position; display-only.
Message	The message text for this purchase order header interface record. Alphanumeric, six 60 position lines; optional.
Print	This value indicates whether this message text will print, and the form on which it will print. Valid values are: blank = Do not print. B = Print on both the Purchase Order and the PO Receiving Worksheet (POR0167) or PO Receiving Worksheet (POR0740). P = Print on the purchase order only. W = Print on the receiver's worksheet only. Alphanumeric, 1 position; optional.

Completing this screen: You advance to the First PO Interface - Maintain Detail Screen.

First PO Interface - Maintain Detail Screen

Purpose: Use this screen to change, delete, and display purchase order detail interface records.

How to display this screen:

• Enter 8 next to a header record on the Work with PO Interface Records Screen.

• Press Enter, F3 or F12 on the Change PO Header Interface Messages Screen.

POX0523 DISPLAY PO Interface - Maintain Detail 12/08/98 14:21:52

KAL Co.

PO Number . : 573

Reference # : 0005559

PO Header Status . . .: E

Type options, press Enter.

2=Change 4=Delete 5=Display 23=Message

Opt Ln# Sts Item SKU UOM Qty Ord Item description

1 E BICYC LE EA 1

2 E ITEM EA 2 4 PACK DISH TOWELS

3 E MITTE BRNS EA 1

4 E SK89 GREY EA 1 POWER VAC

F3=Exit F12=Cancel

Field	Description
PO number	The CWDirect purchase order number assigned to this Purchase Order Detail Interface record. Numeric, 7 positions; display-only.
Reference #	A unique number assigned to each purchase order interface record. The reference number links the purchase order interface records together: • purchase order header interface record • purchase order header interface message record • purchase order detail interface record • purchase order detail interface message record In order to create a CWDirect purchase order, you must specify the same reference number for a purchase order header interface record and a purchase order detail interface record. Numeric, 15 positions; display-only.
PO header status	This value indicates the status of the purchase order header interface record. Valid values are: O = Open. The purchase order header interface record does not contain errors. E = Error. The purchase order header interface record contains errors. Alphanumeric, 1 position; display-only.
Ln# (Purchase order line number)	The purchase order line number. Up to 999 lines can exist on one purchase order. Numeric, 3 positions; display-only.
Sts (Purchase order detail interface status)	This value indicates the status of the purchase order interface detail line. Valid values are: O = Open. The purchase order interface detail line does not contain errors. E = Error. The purchase order interface detail line contains errors. Alphanumeric, 1 position; display-only.
Item	An item ordered on the purchase order. The system displays only the first 5 positions of the item code. Alphanumeric, 12 positions; display-only.
SKU	The SKU for the ordered item. The system displays only the first 4 positions of the SKU code. Alphanumeric, 14 positions; display-only.
UOM (Unit of measure)	A code that represents the vendor's unit of measure for an item; see Chapter 10: Working with Units of Measure (WUOM). Alphanumeric, 3 positions; display-only.
Qty ord (Quantity ordered)	The purchase order quantity ordered for an item. Numeric, 7 positions; display-only.
Item description	The description of the item on the purchase order. Alphanumeric, 40 positions; display-only.

Screen Option	Procedure
Change a purchase order detail interface record	Enter 2 next to a detail record to advance to the First PO Interface - Maintain Detail Screen.
Delete a purchase order detail interface record	Enter 4 next to a purchase order detail interface record to delete it.
Display a purchase order detail interface record	Enter 5 next to a detail record to advance to the Display Purchase Order Detail Interface Screen.
Change a purchase order detail interface message	Enter 23 next to a detail record to advance to the Change PO Detail Interface Message Screen.

Second PO Interface Maintain Detail Screen (Changing)

Purpose: Use this screen to review and change purchase order detail interface information. When you press Enter on this screen, the system highlights the fields that are in error so that you can correct them.

How to display this screen: On the First PO Interface - Maintain Detail Screen, enter 2 next to a detail record.

POX0536 CHANGE PO Interface - Maintain Detail 12/22/98 17:01:56

KAL Co.

PO Number . : 573

Reference # : 0005559

Status . . .: O

Line # . . .: 3

Due Date . . . . . . 122398

Order Qty . . . . . . 1

Price . . . . . . . . 6.0000

Promise Date . . . .

Entry Date . . . . . 120898

Item Number . . . . . MITTENS HOMEMADE MITTENS

SKU . . . . . . . . . BRN SMLL

Unit Of Measure . . . EA

Vendor Number . . . . 101 US VENDOR

Warehouse . . . . . . 40 WAREHOUSE 40

Ship Via 1 BEST WAY SHIPPER

F3=Exit F12=Cancel F23=Message

Field	Description
PO number	The CWDirect purchase order number assigned to this purchase order detail interface record. Numeric, 7 positions; display-only.
Reference #	A unique number assigned to each purchase order interface record. The reference number links the purchase order interface records together: • purchase order header interface record • purchase order header interface message record • purchase order detail interface record • purchase order detail interface message record In order to create a CWDirect purchase order, you must specify the same reference number for a purchase order header interface record and a purchase order detail interface record. Numeric, 15 positions; display-only.
Status	This value indicates the status of the purchase order interface detail line. Valid values are: O = Open. The purchase order interface detail line does not contain errors. E = Error. The purchase order interface detail line contains errors. Alphanumeric, 1 position; display-only.
Line #	The purchase order line number you are currently changing. Numeric, 3 positions; display-only.
Due date	The date on which the item is due from the vendor. Numeric, 6 positions (MMDDYY format); required.
Order qty (Order quantity)	The quantity ordered for the item you are changing. Numeric, 7 positions; required.
Price	The price for this item. The item price represents the Cost field in Purchase Order Entry. Numeric, 11 positions with a 4-place decimal; required.
Promise date	The date after which the item can be committed to customers. Numeric, 6 positions (MMDDYY format); optional.
Entry date	The date the purchase order was entered. Numeric, 6 positions (MMDDYY format); required.
Item number	The item defined on the purchase order detail line that you are currently changing. The system validates the item number against the Item file. Alphanumeric, 12 positions; required.
SKU	The SKU for the item on the purchase order detail line that you are currently changing. This field is required if the item contains SKUs. The system validates the SKU codes against the SKU file. Alphanumeric, 14 positions; optional.
Unit of measure	A code that represents the vendor's unit of measure for the item on the purchase order detail line that you are currently changing. The system validates the unit of measure code against the Unit of Measure file; see Chapter 10: Working with Units of Measure (WUOM). Alphanumeric, 3 positions; required.
Vendor number	A code to identify the vendor or supplier of an item. The vendor number displays to the right of this field. An error message similar to the following displays if the vendor number on this detail line does not match the vendor number defined on the associated purchase order header interface record: PO Header Vendor # is 101 and PO Detail Vendor is 2. The system validates vendor numbers against the Vendor file; see Chapter 19: Working with Vendors (WVEN). Numeric, 7 positions; required.
Warehouse	A code to identify the warehouse. The warehouse description displays to the right of this field. Warehouse codes are defined in and validated against the Warehouse file. If there is not already a record of the item in this warehouse, the purchase order interface record will be in error. Numeric, 3 positions; required.
Ship via	A code that identifies the shipper to deliver the merchandise. The value defined in the Default Purchase Order Ship Via for Purchase Order Interface (F85) system control value defaults. This field is required if the Require Ship Via on Purchase Order Header (E96) system control value is set to Y. The system validates the ship via code against the PO Ship Via file; see Chapter 18: Working with Purchase Order Ship Via (WPSV). Numeric, 2 positions; required.

Completing this screen: The system highlights any fields that are in error. Enter any changes you wish to make. You return to the First PO Interface - Maintain Detail Screen once all of the errors have been corrected. The record status changes from E (error) to O (open).

Screen Option	Procedure
Change a purchase order detail interface message	Press F23 to advance to the Change PO Detail Interface Message Screen.

Display Purchase Order Detail Interface Screen

To display: Enter 5 next to a detail record at First PO Interface - Maintain Detail Screen to advance to the Display Purchase Order Detail Interface screen. You cannot change any information on this screen. See Second PO Interface Maintain Detail Screen (Changing) for field descriptions.

Change PO Detail Interface Message Screen

Purpose: Use this screen to change an existing message for a purchase order interface detail line.

How to display this screen:

• enter 23 next to a detail line on the First PO Interface - Maintain Detail Screen.

• press F23 on the Second PO Interface Maintain Detail Screen (Changing).

POX0538 CHANGE Change PO Detail Interface Message 12/08/98 16:34:43

KAL Co.

PO Number . : 573

Reference # : 0005559

PO Header Status . . .: E

Message Print

FRAGILE ITEMS ARE BUBBLE WRAPPED P

SHIP IN CASES OF 12. DO NOT SPLIT CASES. P

F3=Exit F12=Cancel

Field	Description
PO number	The CWDirect purchase order number assigned to this Purchase Order Detail Interface message. Numeric, 7 positions; display-only.
Reference #	A unique number assigned to each purchase order interface record. The reference number links the purchase order interface records together: • purchase order header interface record • purchase order header interface message record • purchase order detail interface record • purchase order detail interface message record In order to create a CWDirect purchase order, you must specify the same reference number for a purchase order header interface record and a purchase order detail interface record. Numeric, 15 positions; display-only.
PO header status	This value indicates the status of the purchase order header interface record. Valid values are: O = Open. The purchase order header interface record does not contain errors. E = Error. The purchase order header interface record contains errors. Alphanumeric, 1 position; display-only.
Message	The message text for this purchase order detail interface record. Alphanumeric, three 60 position lines; optional.
Print	This value indicates whether this message text will print, and the form on which it will print. Valid values are: blank = Do not print. B = Print on both the Purchase Order and the PO Receiving Worksheet (POR0167). P = Print on the purchase order only. W = Print on the receiver's worksheet only. Alphanumeric, 1 position; optional.

Rerun Purchase Order Interface File Edit (RPOI)

Purpose: Once you correct any errors in the purchase order interface files, you can submit a batch program to verify that:

• an order header upload record does not exist without an associated order detail upload record, and vice versa.

• all required fields in the Order Header Upload and Order Detail Upload contain information.

• fields in the Order Header Upload and Order Detail Upload are validated against existing CWDirect files.

For more information: See Working with the PO Interface Files (GPOI, RPOI, WPOI).

Rerun PO Interface Edit Screen

How to display this screen: Enter RPOI in the Fast path field at the top of any menu or select Rerun Purchase Order Interface File Edit from a menu.

Note: You can also submit the edit program by pressing F9 in Working with Purchase Order Interface Records (WPOI) or by pressing Enter in Generating the PO Interface Files (GPOI).

POR0518 ENTER Rerun PO Interface Edit 12/11/98 8:33:17

KAL Co.

** Pressing Enter will Submit a job to rerun the PO Interface Files Edit.**

F3=Exit F12=Cancel F24=Select Company

Press Enter to resubmit the purchase order interface file edit. The system submits the batch program RUNPOINTR to validate the purchase order interface records defined in the purchase order interface files; see Working with the PO Interface Files (GPOI, RPOI, WPOI).

The RUNPOINTR job produces the PO Interface - Accepted PO Report and the PO Interface - Error Report.

Chapter 70: Entering Purchase Orders (MPOE)

Contents

SCVs

Search

Glossary

Reports

XML

Index

PO Interface - Accepted PO Report

ME07_02 CWDirect 18.0 August 2015 OTN