Chapter 79: Sending Vendor Information to a Warehouse Management System | Contents | SCVs | Search | Glossary | Reports | XML | Index | Chapter 81: Receiving Inventory Transactions from the Warehouse Management System |
Chapter 80: Sending Purchase Order Information to a Warehouse Management System
Purpose: The PkMS Warehouse Management System contains an Advanced Shipping Notification (ASN) module which allows PkMS to know when to expect an update in inventory. The system sends purchase order information to a warehouse management system, such as PkMS, when you create or maintain a purchase order in CWDirect.
In this chapter:
• PkMS Purchase Order Header File (AHASNFIN)
• PkMS Purchase Order Detail File (ADASNFIN)
• PkMS Notes Master Bridge File (CCCASEIN)
• PkMS PO/ASN Header Interface File (I8INPT00)
• PkMS PO/ASN SKU Detail Interface File (I9INPT00)
• PkMS Case Comments File (CCCASE00)
• PkMS PO XML Message (InboundASN_1_0)
• Generic WMS PO XML Message (CWPurchaseOrder)
• Generic WMS PO Message: Sample XML
Note: This chapter discusses CWDirect functionality only. See the PkMS documentation for more information on the PkMS Warehouse Management System.
To send purchase order information to a warehouse management system:
• Enter Y in the Use PkMS Interface Values (F31) system control value.
• Enter a program name in the PkMS Purchase Order Interface Program (F32) system control value.
• Enter a data transport type in the PkMS Transport Type (G80) system control value.
Purchase order information is sent to a warehouse management system when:
• You create a purchase order in Entering Purchase Orders (MPOE) if the purchase order is in an open status.
• You maintain a purchase order in Maintaining Purchase Orders (MPOE) by:
• releasing the purchase order from hold (the purchase order is placed in an open status).
• changing an open purchase order detail line.
• closing a purchase order detail line.
• creating or changing a purchase order note.
Note: Purchase orders are never placed in a closed status in PkMS. In order to place a purchase order in a closed status, you must manually change the status of the purchase order to closed.
PkMS Purchase Order Header File (AHASNFIN)
This table shows the fields that are updated in the PkMS Purchase Order Header file (AHASNFIN) when you create or maintain a purchase order that contains purchase order lines in an open status.
Field Name |
Field Length |
Description |
Shipment# |
20 |
The purchase order number defined on the purchase order. Example: 0000686 |
Received from |
10 |
The vendor number defined on the purchase order. Example: 0000101 |
To location |
3 |
The warehouse code defined on the purchase order. Example: 040 |
PO# |
20 |
The purchase order number from the purchase order. Example: 0000686 |
Ship via |
4 |
The ship via code defined on the purchase order. Example: 01 |
ASN type |
1 |
P (purchase order) displays in this field. |
Vendor name |
35 |
The name of the vendor on the purchase order. Example: US Vendor |
Address-1 |
35 |
Vendor address line 1. Example: 24 Prime Park Way |
Address-2 |
35 |
Vendor address line 2. Example: Cochituate Place |
Address-3 |
35 |
Vendor address line 3. Example: First floor |
City |
35 |
The city defined for the vendor address. Example: Natick |
State code |
2 |
The state defined for the vendor address. Example: MA |
Zip |
11 |
The postal code defined for the vendor address. Example: 01760 |
Telephone number |
15 |
The vendor’s telephone number. Example: 508 652-9489 |
Buyer code |
3 |
The code for the buyer defined on the purchase order. Example: BTM |
Rep name |
30 |
The vendor contact name. Example: Gene Grella |
Warehouse transfer flag |
1 |
N displays in this field. |
QC hold upon recpt. |
1 |
Y displays in this field. |
Units shipped |
15.5 |
The total order quantity from the purchase order. Example: 200.00000 |
Sch. st recv date |
9 |
The promise date defined on the purchase order in YYYYMMDD format. Example: 20001025 |
Sch. end recv date |
9 |
The due date defined on the purchase order in YYYYMMDD format. Example: 20001022 |
Status code |
2 |
10 = Purchase order created. blank = Purchase order changed. 90 = Purchase order closed. |
DCR |
9 |
The date the purchase order was created, changed, or closed in YYYYMMDD format. Example: 20001020 |
TCR |
7 |
The time the purchase order was created, changed, or closed in HHMMSS format. Example: 122854 |
User ID |
10 |
The program name defined in the PkMS Purchase Order Interface Program (F32) system control value. |
PkMS Purchase Order Detail File (ADASNFIN)
This table shows the fields in the PkMS Purchase Order Detail file (ASASNFIN) the system updates when you create, change or delete a purchase order detail line that is in an open status.
Field Name |
Field Length |
Description |
Shipment# |
20 |
The purchase order number defined on the purchase order. Example: 0000686 |
Company |
3 |
The company where the purchase order was created, changed, or closed. Example: 555 |
Sea |
2 |
CWDirect item/SKU, based on the item cross reference you set up. |
Sea year |
2 |
CWDirect item/SKU, based on the item cross reference you set up. |
Style |
8 |
CWDirect item/SKU, based on the item cross reference you set up. |
Style sfx |
8 |
CWDirect item/SKU, based on the item cross reference you set up. |
Color |
4 |
CWDirect item/SKU, based on the item cross reference you set up. |
Color sfx |
2 |
CWDirect item/SKU, based on the item cross reference you set up. |
Sec dim |
3 |
CWDirect item/SKU, based on the item cross reference you set up. |
Qual code |
1 |
CWDirect item/SKU, based on the item cross reference you set up. |
Size rnge code |
4 |
CWDirect item/SKU, based on the item cross reference you set up. |
Sequence number |
5 |
0 displays in this field. |
Inventory type |
1 |
F displays in this field. |
Units shipped |
15.5 |
The order quantity on the purchase order. Example: 100.00000 |
Proc immd needs? |
1 |
Y displays in this field. |
QC hold upon recpt |
1 |
Y displays in this field. |
PO# |
20 |
The purchase order number. defined on the purchase order. Example: 0000686 |
PO line# |
3 |
The purchase order sequence number. Example: 1 |
DCR |
9 |
The date the purchase order was created, changed, or closed in YYYYMMDD format. Example: 20001020 |
TCR |
7 |
The time the purchase order was created, changed, or closed in HHMMSS format. Example: 122854 |
User ID |
10 |
The program name defined in the PkMS Purchase Order Interface Program (F32) system control value. |
PkMS Notes Master Bridge File (CCCASEIN)
This table shows the fields in the PkMS Notes Master Bridge file (CCCASEIN) the system updates when you create or change a purchase order note.
Field Name |
Field Length |
Description |
Record type |
2 |
PH = This is a purchase order header note. PD = This is a purchase order detail note. |
Reference# |
20 |
The purchase order number associated with this note. Example: 0000686 |
Sequence number |
5 |
The purchase order note sequence number. Example: 1 |
Code type |
3 |
CWDirect print flag for this purchase order note. B = Print on purchase order and worksheet. P = Print on purchase order. W = Print on receiving worksheet. |
Spcl instr desc |
100 |
The purchase order note. Example: Package item carefully. |
DCR |
9 |
The date the purchase order note was created in YYYYMMDD format. Example: 20001020 |
TCR |
7 |
The time the purchase order note was created in HHMMSS format. Example: 133820 |
User ID |
10 |
The program name defined in the PkMS Purchase Order Interface Program (F32) system control value. |
Transport type: You can enter PKMSLOCAL or FTP in the PkMS Transport Type (G80) system control value to indicate the method CWDirect uses to send PO information to a warehouse management system. PKMSLOCAL indicates CWDirect sends the PO files using flat files; FTP indicates CWDirect sends the PO files using FTP processing.
FTP Processing: You can send purchase order information to PkMS using FTP processing if you use version 19 of PkMS; see Sending and Receiving WMS Information using FTP Processing.
PkMS PO/ASN Header Interface File (I8INPT00)
This table shows the fields in the PkMS PO/ASN Header Interface file (I8INPT00) the system updates when you create or maintain a purchase order that contains purchase order lines in an open status.
Field Name |
Field Length |
Description |
Batch control number |
10 |
The next available number defined in the PkMS PO/ASN Control Number number assignment value. |
Date created |
9 |
The date the purchase order was created, changed, or closed in YYYYMMDD format. Example: 20001020 |
Time created |
7 |
The time the purchase order was created, changed, or closed in HHMMSS format. Example: 122854 |
User ID |
10 |
The program name defined in the PkMS Purchase Order Interface Program (F32) system control value. Example: IFR0047 |
Shipment# |
20 |
The purchase order number defined on the purchase order. Example: 0000686 |
Received from |
10 |
The vendor number defined on the purchase order. Example: 0000101 |
To location |
3 |
The PkMS code for the warehouse defined on the purchase order. You can define a cross reference between a CWDirect warehouse and a PkMS warehouse in Working with Warehouse Cross-References (WWXR). Example: P4 |
PO# |
20 |
The purchase order number defined on the purchase order. Example: 0000686 |
Ship via |
4 |
The ship via code defined on the purchase order. Example: 01 |
ASN type |
1 |
P (purchase order) displays in this field. |
Vendor name |
35 |
The name of the vendor on the purchase order. Example: US Vendor |
Address-1 |
35 |
Vendor address line 1. Example: 24 Prime Park Way |
Address-2 |
35 |
Vendor address line 2. Example: Cochituate Place |
Address-3 |
35 |
Vendor address line 3. Example: First floor |
City |
35 |
The city defined for the vendor address. Example: Natick |
State code |
2 |
The state defined for the vendor address. Example: MA |
Zip |
11 |
The postal code defined for the vendor address. Example: 01760 |
Telephone number |
15 |
The vendor’s telephone number. Example: 508 652-9489 |
Buyer code |
3 |
The code for the buyer defined on the purchase order. Example: BTM |
Representative name |
30 |
The vendor contact name. Example: Gene Grella |
Warehouse transfer flag |
1 |
N displays in this field. |
QC hold upon recpt. |
1 |
Y displays in this field. |
Units shipped |
15.5 |
The total order quantity from the purchase order. Example: 200.00000 |
Sch. st recv date |
9 |
The promise date defined on the purchase order in YYYYMMDD format. Example: 20001025 |
Sch. end recv date |
9 |
The due date defined on the purchase order in YYYYMMDD format. Example: 20001022 |
Status code |
2 |
10 = Purchase order created. blank = Purchase order changed. 90 = Purchase order closed. |
System created |
1 |
N displays in this field. |
PkMS PO/ASN SKU Detail Interface File (I9INPT00)
This table shows the fields in the PkMS PO/ASN SKU Detail Interface file (I9INPT00) the system updates when you create, change or delete a purchase order detail line that is in an open status.
Field Name |
Field Length |
Description |
Batch control number |
10 |
The next available number defined in the PkMS PO/ASN Control Number number assignment value. |
Date created |
9 |
The date the purchase order was created, changed, or closed in YYYYMMDD format. Example: 20001020 |
Time created |
7 |
The time the purchase order was created, changed, or closed in HHMMSS format. Example: 122854 |
User ID |
10 |
The program name defined in the PkMS Purchase Order Interface Program (F32) system control value. |
Shipment# |
20 |
The purchase order number defined on the purchase order. Example: 0000686 |
Company |
3 |
The company where the purchase order was created, changed, or closed. Example: 555 |
Sea |
2 |
CWDirect item/SKU, based on the item cross reference you set up. |
Sea year |
2 |
CWDirect item/SKU, based on the item cross reference you set up. |
Style |
8 |
CWDirect item/SKU, based on the item cross reference you set up. |
Style sfx |
8 |
CWDirect item/SKU, based on the item cross reference you set up. |
Color |
4 |
CWDirect item/SKU, based on the item cross reference you set up. |
Color sfx |
2 |
CWDirect item/SKU, based on the item cross reference you set up. |
Sec dim |
3 |
CWDirect item/SKU, based on the item cross reference you set up. |
Qual code |
1 |
CWDirect item/SKU, based on the item cross reference you set up. |
Size rnge code |
4 |
CWDirect item/SKU, based on the item cross reference you set up. |
Sequence number |
5 |
The sequence number defined for this purchase order line. |
Inventory type |
1 |
F displays in this field. |
Units shipped |
15.5 |
The order quantity on the purchase order. Example: 100.00000 |
Proc immd needs? |
1 |
Y displays in this field. |
QC hold upon recpt |
1 |
Y displays in this field. |
PO# |
20 |
The purchase order number. defined on the purchase order. Example: 0000686 |
PO line# |
3 |
The purchase order sequence number. Example: 1 |
KEYREC units received |
13.5 |
The number of units already received on the purchase order. The system only populates this field if program IFR0047 is defined in the PkMS Purchase Order Interface Program (F32) system control value. Example: 25.00000 |
PkMS Case Comments File (CCCASE00)
This table shows the fields in the PkMS Case Comments file (CCASE00) the system updates when you create or change purchase order note.
Field Name |
Field Length |
Description |
Record type |
2 |
CWDirect note type: SK = SKU Comments CS = Customer service comments PC = Product comments PD = Purchase order detail comments PH = Purchase order header comments PO = Purchase order item comments QC = Quality control comments RP = Report control comments VN = Vendor comments |
Reference# |
20 |
The first 6 positions of the item number and 14 positions of the SKU. Example: CT5 |
Sequence number |
5 |
Purchase order sequence number. |
DCR |
9 |
The date this record was created in YYYYMMDD format. |
TCR |
7 |
The time this record was created in HHMMSS format. |
Code type |
3 |
CWDirect print flag. This field displays blank if the note is defined at the item level. B = Print on pick slips and invoices I = Print on invoices only. N (or blank) = Do not print. P = Print on pick slips only. R = Print on reports only. |
Spcl instr desc |
100 |
The purchase order note. Example: Package carefully. |
User ID |
10 |
The program name defined in the PkMS Purchase Order Interface Program (F32) system control value. |
PkMS or generic XML messages? The Purchase Orders XML Message Format (H40) system control value defines the XML message format the system generates when it sends purchase order information to a warehouse management system:
• PKMS generates the PkMS PO XML Message (InboundASN_1_0).
• GENERIC generates the Generic WMS PO XML Message (CWPurchaseOrder).
Transport type: You must enter MQ in the PkMS Transport Type (G80) system control value to indicate the XML message is sent to the warehouse management system using MQ Series. The MQ job used to send PO information to a warehouse management system is PURCHASE ORDERS EXPORT.
Decimals: Decimal points display for a numeric attribute depending on if the number is a whole number or real number. If the number is a whole number, for example 1, decimals do not display (1 instead of 1.00); if the number is a real number, for example 1.55, decimals display (1.55 instead of 155).
PkMS PO XML Message (InboundASN_1_0)
This message is transmitted to PkMS when you create or maintain a purchase order in CWDirect and the Purchase Orders XML Message Format (H40) system control value is set to PKMS.
For more information: See:
• PkMS PO Message: Sample XML for a sample message.
• XML Messages for a table that provides links to the DTD, schema, and a sample XML layout for each XML message.
Attribute Name |
Type |
Length |
Req? |
Comments |
|
||||
version |
alpha |
30 |
Y |
The hard-coded value 1.0 displays. |
timestamp |
alpha |
19 |
Y |
The date and time the XML message was created in YYYY-MM-DDTHH:MM:SS format. |
id |
alpha |
60 |
Y |
PKMS_InboundASN + the date and time the message was created + the next number available from the PO File Transfer # number assignment value. |
|
||||
ShipmentNbr |
alpha |
20 |
Y |
The PO number defined on the purchase order. |
ToLocation |
alpha |
3 |
Y |
The PkMS code for the warehouse defined on the purchase order. You can define a cross reference between a CWDirect warehouse and a PkMS warehouse in Working with Warehouse Cross-References (WWXR). |
AsnType |
alpha |
1 |
Y |
The hard-coded value 1 displays. |
|
||||
ReceivedFrom |
alpha |
10 |
N |
The vendor number defined on the purchase order. |
PONbr |
alpha |
20 |
N |
The PO number defined on the purchase order. |
ShipVia |
alpha |
4 |
N |
The ship via code defined on the purchase order. |
VendorName |
alpha |
35 |
N |
The name of the vendor on the purchase order. |
Address1 |
alpha |
35 |
N |
Vendor address line 1. |
Address2 |
alpha |
35 |
N |
Vendor address line 2. |
Address3 |
alpha |
35 |
N |
Vendor address line 3. |
City |
alpha |
35 |
N |
The city defined for the vendor address. |
StateCode |
alpha |
20 |
N |
The state defined for the vendor address. |
Zip |
alpha |
11 |
N |
The postal code defined for the vendor address. |
TelephoneNumber |
alpha |
30 |
N |
The vendor’s telephone number. |
BuyerCode |
alpha |
3 |
N |
The code for the buyer defined on the PO. |
RepresentativeName |
alpha |
30 |
N |
The vendor contact name. |
WhseTransferFlag |
alpha |
1 |
N |
The hard-coded value N displays. |
QcHoldUponReceipt |
alpha |
1 |
N |
The hard-coded value Y displays. |
UnitsShipped |
signed numeric |
15.5 |
N |
The total order quantity from the purchase order. |
SchedStartRcvDate |
signed numeric |
9.0 |
N |
The promise date and time defined on the PO in YYYY-MM-DDTHH:MM:SS format. |
SchedEndRecvDate |
signed numeric |
9.0 |
N |
The due date and time defined on the PO in YYYY-MM-DDTHH:MM:SS format. |
StatusCode |
alpha |
2 |
N |
10 = PO add or change 90 = PO closed |
Function |
alpha |
1 |
N |
Valid values: 1 = Add 2 = Change 4 = Delete |
|
||||
|
||||
|
||||
Company |
alpha |
10 |
Y |
The company where the PO was created, changed, or closed. |
Division |
alpha |
2 |
Y |
This attribute is blank. |
Season |
alpha |
2 |
N |
CWDirect item/SKU, based on the PkMS item cross reference. |
SeasonYear |
alpha |
2 |
N |
CWDirect item/SKU, based on the PkMS item cross reference. |
Style |
alpha |
8 |
N |
CWDirect item/SKU, based on the PkMS item cross reference. If the PkMS Use SKU Retail Reference (I86) system control value is set to Y, instead of using the PkMS item cross reference you set up at the Work with PkMS Item Cross Reference Screen to identify the CWDirect item and SKU, the system uses the SKU retail reference number field in the SKU file to identify the CWDirect item number and SKU code. Positions 1-8 of the SKU retail reference number field displays in this field. If the SKU retail reference number field is blank, the system defaults 00000000 to the field. |
StyleSuffix |
alpha |
8 |
N |
CWDirect item/SKU, based on the PkMS item cross reference. If the PkMS Use SKU Retail Reference (I86) system control value is set to Y, instead of using the PkMS item cross reference you set up at the Work with PkMS Item Cross Reference Screen to identify the CWDirect item and SKU, the system uses the SKU retail reference number field in the SKU file to identify the CWDirect item number and SKU code. Positions 9-15 of the SKU retail reference number field displays in this field. If the SKU retail reference number field is blank, the system defaults 00000000 to the field. |
Color |
alpha |
4 |
N |
CWDirect item/SKU, based on the PkMS item cross reference. |
ColorSuffix |
alpha |
2 |
N |
CWDirect item/SKU, based on the PkMS item cross reference. |
SecDimension |
alpha |
3 |
N |
CWDirect item/SKU, based on the PkMS item cross reference. |
Quality |
alpha |
1 |
N |
CWDirect item/SKU, based on the PkMS item cross reference. |
SizeRangeCode |
alpha |
4 |
N |
CWDirect item/SKU, based on the PkMS item cross reference. |
SequenceNbr |
signed numeric |
5.0 |
Y |
The sequence number defined for the PO line. |
UnitsShipped |
signed numeric |
15.5 |
Y |
The order quantity on the PO. |
|
||||
InventoryType |
alpha |
1 |
N |
The hard-coded value F (finished good) defaults. |
|
||||
ProcessImmdNeeds |
alpha |
1 |
N |
The hard-coded value Y defaults. |
QcHoldonReceipt |
alpha |
1 |
N |
The hard-coded value Y defaults. |
POLineNbr |
signed numeric |
3.0 |
N |
PO sequence number. |
A sample of the PkMS PO XML Message (InboundASN_1_0) is presented below.
- <InboundASN_1_0 version="1.0" timestamp="2004-08-13T12:03:56" id="PKMS_InboundASN_2004-08-13T12:03:56.000000014">
- <InboundASN>
<ShipmentNbr>1320</ShipmentNbr>
<ToLocation />
<AsnType>1</AsnType>
- <ASNHeaderFields>
<ReceivedFrom>202</ReceivedFrom>
<PONbr>1320</PONbr>
<ShipVia>1</ShipVia>
<VendorName>PET SUPPLIES</VendorName>
<Address1>11 SANFORD STREET</Address1>
<City>MEDWAY</City>
<StateCode>MA</StateCode>
<Zip>02053</Zip>
<TelephoneNumber>508 533-8038</TelephoneNumber>
<BuyerCode>BTM</BuyerCode>
<RepresentativeName>BERNADETTE T MIRANDA</RepresentativeName>
<WhseTransferFlag>N</WhseTransferFlag>
<QcHoldUponReceipt>Y</QcHoldUponReceipt>
<UnitsShipped PurchasingUOM="">25</UnitsShipped>
<SchedStartRcvDate>2004-08-25T12:03:56</SchedStartRcvDate>
<SchedEndRecvDate>2004-08-14T12:03:56</SchedEndRecvDate>
<StatusCode>10</StatusCode>
<Function>1</Function>
</ASNHeaderFields>
- <ListOfASNDetails>
- <ASNDetail>
- <SKUDefinition>
<Company>555</Company>
<Division />
<Style>12345678</Style>
<StyleSuffix>9012345</StyleSuffix>
</SKUDefinition>
<SequenceNbr>1</SequenceNbr>
<UnitsShipped PurchasingUOM="">25</UnitsShipped>
- <SubSKUFields>
<InventoryType>F</InventoryType>
</SubSKUFields>
- <ASNDetailFields>
<ProcessImmdNeeds>Y</ProcessImmdNeeds>
<QcHoldonReceipt>Y</QcHoldonReceipt>
<POLineNbr>1</POLineNbr>
</ASNDetailFields>
</ASNDetail>
</ListOfASNDetails>
</InboundASN>
</InboundASN_1_0>
Generic WMS PO XML Message (CWPurchaseOrder)
This message is transmitted to a warehouse management system when you create or maintain a purchase order in CWDirect and the Purchase Orders XML Message Format (H40) system control value is set to GENERIC. When you cancel a PO, CWDirect only sends the POHeader information.
For more information: See:
• Generic WMS PO Message: Sample XML for a sample message.
• XML Messages for a table that provides links to the DTD, schema, and a sample XML layout for each XML message.
Attribute Name |
Type |
Length |
Comments |
|
|||
source |
alpha |
25 |
Identifies the source of the XML message. CWI indicates the XML message is from MICROS. |
target |
alpha |
25 |
Identifies the target of the XML message. WMS indicates the XML message is sent to a warehouse management system. |
type |
alpha |
25 |
Identifies the type of information in the XML message. CWPurchaseOrder indicates the message contains purchase order information. |
|
|||
type |
alpha |
4 |
Identifies the interface type for the XML message. WMS indicates the XML message is for a warehouse management system. |
message_type |
alpha |
2 |
Identifies the type of information in the XML message. PO indicates the message contains purchase orders. |
company |
numeric |
3.0 |
Value defined in the Company field (C6COMP) in the CWDirect PO Header file. |
file_trans_nbr |
numeric |
9.0 |
The next number available from the PO File Transfer # number assignment value. |
po_nbr |
numeric |
7.0 |
Value defined in the PO # field (C6IGNB) in the CWDirect PO Header file. |
status |
alpha |
1 |
Value defined in the Sts field (C6H1ST) in the CWDirect PO Header file. |
workstation |
alpha |
10 |
Value defined in the Workstation field (C6AOVN) in the CWDirect PO Header file. |
cancel_date |
numeric |
9.0 |
Value defined in the Cancel date field (C6CZDT) in the CWDirect PO Header file, in YYYYMMDD format. |
confirm_po |
alpha |
1 |
Value defined in the Confirming PO field (C6HYST) in the CWDirect PO Header file. |
currency_rate |
numeric |
11.7 |
Value defined in the Currency rate field (C6ETPC) in the CWDirect PO Header file. |
discount_pct |
numeric |
5.2 |
Value defined in the Discount % field (C6EUPC) in the CWDirect PO Header file. |
due_date |
numeric |
8.0 |
Value defined in the Due date field (C6C0DT) in the CWDirect PO Header file, in YYYYMMDD format. |
entry_date |
numeric |
8.0 |
Value defined in the Entry date field (C6C1DT) in the CWDirect PO Header file, in YYYYMMDD format. |
last_trans_date |
numeric |
8.0 |
Value defined in the Last trans date field (C6C2DT) in the CWDirect PO Header file, in YYYYMMDD format. |
negotiate_price |
alpha |
1 |
Value defined in the Negotiate price field (C6HZST) in the CWDirect PO Header file. |
print_date |
numeric |
8.0 |
Value defined in the Print date field (C6C3DT) in the CWDirect PO Header file. |
promise_date |
numeric |
8.0 |
Value defined in the Promise date field (C6C4DT) in the CWDirect PO Header file, in YYYYMMDD format. |
placed_with |
alpha |
30 |
Value defined in the Placed with name field (C6LJTX) in the CWDirect PO Header file. |
recurring_po |
alpha |
1 |
Value defined in the Recurring PO field (C6H0ST) in the CWDirect PO Header file. |
reference_nbr |
alpha |
15 |
Value defined in the Reference # field (C6LKTX) in the CWDirect PO Header file. |
tax_status |
alpha |
15 |
Value defined in the Tax status field (C6LLTX) in the CWDirect PO Header file. |
vendor_ref_nbr |
alpha |
15 |
Value defined in the Vendor reference # field (C6LMTX) in the CWDirect PO Header file. |
ship_instr |
alpha |
20 |
Value defined in the Shipping Instructions field (C6LNTX) in the CWDirect PO Header file. |
revision_nbr |
numeric |
3.0 |
Value defined in the Rev # field (C6QBQT) in the CWDirect PO Header file. |
completed_date |
numeric |
8.0 |
Value defined in the Completed field (C6FIDT) in the CWDirect PO Header file, in YYYYMMDD format. |
prt_worksheet |
alpha |
1 |
Value defined in the Print worksheet field (C6NPST) in the CWDirect PO Header file. |
revised_date |
numeric |
8.0 |
Value defined in the Revised date field (C6F2DT) in the CWDirect PO Header file, in YYYYMMDD format. |
approval_date |
numeric |
8.0 |
Value defined in the Approval field (C6H2DT) in the CWDirect PO Header file, in YYYYMMDD format. |
edi_date |
numeric |
8.0 |
Value defined in the EDI date field (C6H3DT) in the CWDirect PO Header file, in YYYYMMDD format. |
surcharge_pct |
numeric |
5.2 |
Value defined in the Surcharge percent field (C6GMPC) in the CWDirect PO Header file. |
po_type |
alpha |
1 |
Value defined in the PO type field (C6PUSS) in the CWDirect PO Header file. |
user_field1 |
alpha |
10 |
Value defined in the User field 1 field (C6DYTT) in the CWDirect PO Header file. |
user_field2 |
alpha |
10 |
Value defined in the User field 2 field (C6DZTT) in the CWDirect PO Header file. |
user_field3 |
alpha |
10 |
Value defined in the User field 3 field (C6D0TT) in the CWDirect PO Header file. |
user_field4 |
alpha |
10 |
Value defined in the User field 4 field (C6D1TT) in the CWDirect PO Header file. |
unit_disc_amt1 |
numeric |
9.4 |
Value defined in the Unit discount amt 1 field (C6DZNQ) in the CWDirect PO Header file. |
unit_disc_amt2 |
numeric |
9.4 |
Value defined in the Unit discount amt 2 field (C6D0NQ) in the CWDirect PO Header file. |
unit_disc_amt3 |
numeric |
9.4 |
Value defined in the Unit discount amt 3 field (C6D1NQ) in the CWDirect PO Header file. |
unit_disc_pct1 |
numeric |
5.2 |
Value defined in the Unit discount pct 1 field (C6MVPC) in the CWDirect PO Header file. |
unit_disc_pct2 |
numeric |
5.2 |
Value defined in the Unit discount pct 2 field (C6MWPC) in the CWDirect PO Header file. |
unit_disc_pct3 |
numeric |
5.2 |
Value defined in the Unit discount pct 3 field (C6MXPC) in the CWDirect PO Header file. |
fob_frt_terms |
alpha |
10 |
Value defined in the FOB freight terms field (C6SSCG) in the CWDirect PO Header file. |
extract_flag |
alpha |
1 |
Value defined in the Extracted flag field (C6GMSY) in the CWDirect PO Header file. |
future_use_sts1 |
alpha |
2 |
Value defined in the Future use sts 1 field (C6DKSY) in the CWDirect PO Header file. |
future_use_sts2 |
alpha |
2 |
Value defined in the Future use sts 2 field (C6DLSY) in the CWDirect PO Header file. |
processed_by_inter |
alpha |
1 |
Value defined in the Processed by int er field (C6DMSY) in the CWDirect PO Header file. |
future_use_yn2 |
alpha |
1 |
Value defined in the Future use Y/N 2 field (C6DNSY) in the CWDirect PO Header file. |
future_use_val1 |
numeric |
11.2 |
Value defined in the Future use value 1 field (C6NWVD) in the CWDirect PO Header file. |
future_use_val2 |
numeric |
11.2 |
Value defined in the Future use value 2 field (C6NXVD) in the CWDirect PO Header file. |
future_use_code1 |
alpha |
10 |
Value defined in the Future use code 1 field (C6TKCG) in the CWDirect PO Header file. |
future_use_code2 |
alpha |
10 |
Value defined in the Future use code 2 field (C6TLCG) in the CWDirect PO Header file. |
future_use_qty1 |
numeric |
5.0 |
Value defined in the Future use qty 1 field (C6QLQX) in the CWDirect PO Header file. |
future_use_qty2 |
numeric |
5.0 |
Value defined in the Future use qty 2 field (C6QMQX) in the CWDirect PO Header file. |
future_use_date1 |
numeric |
8.0 |
Value defined in the Future use date 1 field (C6XRDT) in the CWDirect PO Header file, in YYYYMMDD format. |
future_use_date2 |
numeric |
8.0 |
Value defined in the Future use date 2 field (C6XSDT) in the CWDirect PO Header file, in YYYYMMDD format. |
future_use_pct1 |
numeric |
5.2 |
Value defined in the Future use percent 1 field (C6O1PC) in the CWDirect PO Header file. |
future_use_pct2 |
numeric |
5.2 |
Value defined in the Future use percent 2 field (C6O2PC) in the CWDirect PO Header file. |
apt_code |
numeric |
2.0 |
Value defined in the Code field (C6HPNB) in the CWDirect PO Header file. |
buyer |
alpha |
3 |
Value defined in the Buyer field (C6CFCD) in the CWDirect PO Header file. |
offer |
alpha |
3 |
Value defined in the Offer number field (C6CACD) in the CWDirect PO Header file. |
user |
alpha |
10 |
Value defined in the User field (C6USER) in the CWDirect PO Header file. |
whse |
numeric |
3.0 |
Value defined in the Whs field (C6WCDE) in the CWDirect PO Header file. |
gla_acct_nbr |
numeric |
8.0 |
Value defined in the Account # field (C6EONB) in the CWDirect PO Header file. |
currency_code |
alpha |
3 |
Value defined in the Currency code field (C6O4CD) in the CWDirect PO Header file. |
customer_nbr |
numeric |
9.0 |
Value defined in the Customer # field (C6JYNB) in the CWDirect PO Header file. |
order_nbr |
numeric |
8.0 |
Value defined in the Order # field (C6JWNB) in the CWDirect PO Header file. |
shipto_nbr |
numeric |
3.0 |
Value defined in the Ship to # field (C6JXNB) in the CWDirect PO Header file. |
vendor_nbr |
numeric |
7.0 |
Value defined in the Vendor # field (C6FYNB) in the CWDirect PO Header file. |
ship_via |
numeric |
2.0 |
Value defined in the Ship via field (C6JQNB) in the CWDirect PO Header file. |
in_use_user |
alpha |
10 |
Value defined in the In use user field (C6WYCD) in the CWDirect PO Header file. |
receipt_user |
alpha |
10 |
Value defined in the Receipt by user field (C6XUCD) in the CWDirect PO Header file. |
approved_by |
alpha |
10 |
Value defined in the Approved by user field (C6AXCE) in the CWDirect PO Header file. |
name |
alpha |
30 |
Value defined in the Name field (BSCUTX) in the CWDirect Vendor file. |
address_line1 |
alpha |
32 |
Value defined in the Address line 1 field (BSCRTX) in the CWDirect Vendor file. |
address_line2 |
alpha |
32 |
Value defined in the Address line 2 field (BSCSTX) in the CWDirect Vendor file. |
address_line3 |
alpha |
32 |
Value defined in the Address line 3 field (BSDPTX) in the CWDirect Vendor file. |
city |
alpha |
25 |
Value defined in the City field (BSCTTX) in the CWDirect Vendor file. |
state |
alpha |
2 |
Value defined in the State field (BSIICD) in the CWDirect Vendor file. |
zip |
alpha |
10 |
Value defined in the Zip field (BSIJCD) in the CWDirect Vendor file. |
telephone |
alpha |
14 |
Value defined in the Telephone number field (BSF2CG) in the CWDirect Vendor file. |
contact_name |
alpha |
30 |
Value defined in the Contact name field (BSP5TX) in the CWDirect Vendor file. |
tot_ord_qty |
numeric |
7.0 |
Sum of order qty for a PO. |
activity_code |
alpha |
1 |
A = add C = change D = delete |
wms_control |
numeric |
9.0 |
The next number available from the PkMS PO/ASN Control Number number assignment value. |
company_designator |
alpha |
10 |
The value defined in the PkMS Company Designator (G61) system control value. |
program_id |
alpha |
10 |
The name of the program that created this XML message. |
date_created |
numeric |
8.0 |
The date this message was created, in YYYYMMDD format. |
time_created |
numeric |
7.0 |
The time this message was created, in HHMMSS format. |
wms_whse |
alpha |
3 |
The PkMS warehouse code based on the warehouse cross reference you set up. |
|
|||
seq |
numeric |
3.0 |
Value defined in the Seq # field (C8IJNB) in the CWDirect PO Messages file. |
alpha |
1 |
Value defined in the Print field (C8H3ST) in the CWDirect PO Messages file. |
|
message |
alpha |
60 |
Value defined in the Message field (C8LOTX) in the CWDirect PO Messages file. |
user |
alpha |
10 |
Value defined in the User field (C8BZVN) in the CWDirect PO Messages file. |
entry_date |
numeric |
8.0 |
Value defined in the Entry date field (C8JUDT) in the CWDirect PO Messages file, in YYYYMMDD format. |
|
|||
seq |
numeric |
5.0 |
Value defined in the Seq # field (ENPCNB) in the CWDirect PO Detail file. |
status |
alpha |
1 |
Value defined in the Sts field (ENHVST) in the CWDirect PO Detail file. |
line |
numeric |
3.0 |
Value defined in the Ln# field (ENIDNB) in the CWDirect PO Detail file. |
cancel_date |
numeric |
8.0 |
Value defined in the Cancel date field (ENCVDT) in the CWDirect PO Detail file, in YYYYMMDD format. |
due_date |
numeric |
8.0 |
Value defined in the Due date field (ENCWDT) in the CWDirect PO Detail file, in YYYYMMDD format. |
intransit_qty |
numeric |
7.0 |
Value defined in the In transit qty field (ENKHQT) in the CWDirect PO Detail file. |
invty_item |
alpha |
1 |
Value defined in the Inventory item field (ENHUST) in the CWDirect PO Detail file. |
order_qty |
numeric |
7.0 |
Value defined in the Order qty field (ENKIQT) in the CWDirect PO Detail file. |
price |
numeric |
11.4 |
Value defined in the Price field (ENSIPR) in the CWDirect PO Detail file. |
promise_date |
numeric |
8.0 |
Value defined in the Promise date field (ENCXDT) in the CWDirect PO Detail file, in YYYYMMDD format. |
rcvd_qty |
numeric |
7.0 |
Value defined in the Rec qty field (ENKJQT) in the CWDirect PO Detail file. |
vend_ord_qty |
numeric |
7.0 |
Value defined in the Vendor order qty field (ENKKQT) in the CWDirect PO Detail file. |
unit_disc_amt |
numeric |
11.4 |
Value defined in the Unit dsc amount field (ENS5PR) in the CWDirect PO Detail file. |
disc_override |
alpha |
1 |
Value defined in the Discount override field (ENUWST) in the CWDirect PO Detail file. |
entry_date |
numeric |
8.0 |
Value defined in the Entry date field (ENINDT) in the CWDirect PO Detail file, in YYYYMMDD format. |
price_method |
alpha |
1 |
Value defined in the Price method field (ENLCSS) in the CWDirect PO Detail file. |
vendor_price |
numeric |
11.4 |
Value defined in the Vendor price field (ENWCPR) in the CWDirect PO Detail file. |
vend_price_curr |
alpha |
1 |
Value defined in the Vnd price curr type field (ENPTSS) in the CWDirect PO Detail file. |
unit_disc_amt1 |
numeric |
9.4 |
Value defined in the Unit discount amt 1 field (ENDRNQ) in the CWDirect PO Detail file. |
unit_disc_amt2 |
numeric |
9.4 |
Value defined in the Unit discount amt 2 field (ENDSNQ) in the CWDirect PO Detail file. |
unit_disc_amt3 |
numeric |
9.4 |
Value defined in the Unit discount amt 3 field (ENDTNQ) in the CWDirect PO Detail file. |
unit_disc_pct1 |
numeric |
5.2 |
Value defined in the Unit discount pct 1 field (ENMSPC) in the CWDirect PO Detail file. |
unit_disc_pct2 |
numeric |
5.2 |
Value defined in the Unit discount pct 2 field (ENMTPC) in the CWDirect PO Detail file. |
unit_disc_pct3 |
numeric |
5.2 |
Value defined in the Unit discount pct 3 field (ENMUPC) in the CWDirect PO Detail file. |
misc_price1 |
numeric |
7.2 |
Value defined in the Misc price 1 field (ENZ1PR) in the CWDirect PO Detail file. |
misc_price2 |
numeric |
7.2 |
Value defined in the Misc price 2 field (ENZ2PR) in the CWDirect PO Detail file. |
vend_disc_amt |
numeric |
9.4 |
Value defined in the Vendor discount amt field (ENDUNQ) in the CWDirect PO Detail file. |
vend_disc_amt1 |
numeric |
11.4 |
Value defined in the Vnd unit disc $ 1 field (ENAZPS) in the CWDirect PO Detail file. |
vend_disc_amt2 |
numeric |
11.4 |
Value defined in the Vnd unit disc $ 2 field (ENA0PS) in the CWDirect PO Detail file. |
vend_disc_amt3 |
numeric |
11.4 |
Value defined in the Vnd unit disc $ 3 field (ENA1PS) in the CWDirect PO Detail file. |
disc_variance |
numeric |
11.4 |
Value defined in the Discount variance field (ENA2PS) in the CWDirect PO Detail file. |
item |
alpha |
12 |
Value defined in the Item number field (ENBECD) in the CWDirect PO Detail file. |
sku |
alpha |
14 |
Value defined in the SKU code field (ENBESK) in the CWDirect PO Detail file. |
uom |
alpha |
3 |
Value defined in the UOM field (ENCDCD) in the CWDirect PO Detail file. |
vend_uom |
alpha |
3 |
Value defined in the Vendor’s unit of measure field (ENPFCD) in the CWDirect PO Detail file. |
buyer |
alpha |
3 |
Value defined in the Buyer field (ENCFCD) in the CWDirect PO Detail file. |
gla_acct_nbr |
numeric |
8.0 |
Value defined in the Account # field (ENEONB) in the CWDirect PO Detail file. |
offer |
alpha |
3 |
Value defined in the Offer number field (ENCACD) in the CWDirect PO Detail file. |
ship_via |
numeric |
2.0 |
Value defined in the Ship via field (ENJQNB) in the CWDirect PO Detail file. |
vendor_nbr |
numeric |
7.0 |
Value defined in the Vendor # field (ENFYNB) in the CWDirect PO Detail file. |
vend_item |
alpha |
20 |
Value defined in the Item field (ENO6CD) in the CWDirect PO Detail file. |
whse |
numeric |
3.0 |
Value defined in the Whs field (ENWCDE) in the CWDirect PO Detail file. |
pkms_season |
alpha |
2 |
CWDirect item/SKU, based on the PkMS item cross reference. |
pkms_season_year |
alpha |
2 |
CWDirect item/SKU, based on the PkMS item cross reference. |
pkms_style |
alpha |
8 |
CWDirect item/SKU, based on the PkMS item cross reference. If the PkMS Use SKU Retail Reference (I86) system control value is set to Y, instead of using the PkMS item cross reference you set up at the Work with PkMS Item Cross Reference Screen to identify the CWDirect item and SKU, the system uses the SKU retail reference number field in the SKU file to identify the CWDirect item number and SKU code. Positions 1-8 of the SKU retail reference number field displays in this field. If the SKU retail reference number field is blank, the system defaults 00000000 to the field. |
pkms_style_suffix |
alpha |
8 |
CWDirect item/SKU, based on the PkMS item cross reference. If the PkMS Use SKU Retail Reference (I86) system control value is set to Y, instead of using the PkMS item cross reference you set up at the Work with PkMS Item Cross Reference Screen to identify the CWDirect item and SKU, the system uses the SKU retail reference number field in the SKU file to identify the CWDirect item number and SKU code. Positions 9-15 of the SKU retail reference number field displays in this field. If the SKU retail reference number field is blank, the system defaults 00000000 to the field. |
pkms_color |
alpha |
4 |
CWDirect item/SKU, based on the PkMS item cross reference. |
pkms_color_suffix |
alpha |
2 |
CWDirect item/SKU, based on the PkMS item cross reference. |
pkms_sec_dimension |
alpha |
3 |
CWDirect item/SKU, based on the PkMS item cross reference. |
pkms_quality |
alpha |
1 |
CWDirect item/SKU, based on the PkMS item cross reference. |
pkms_size_range_code |
alpha |
4 |
CWDirect item/SKU, based on the PkMS item cross reference. |
|
|||
seq |
numeric |
5.0 |
Value defined in the Seq # field (C5PCNB) in the CWDirect PO Detail Message file. |
seq_nbr |
numeric |
3.0 |
Value defined in the Seq # field (C5IFNB) in the CWDirect PO Detail Message file. |
alpha |
1 |
Value defined in the Print field (C5HXST) in the CWDirect PO Detail Message file. |
|
message |
alpha |
60 |
Value defined in the Message field (C5LITX) in the CWDirect PO Detail Message file. |
Generic WMS PO Message: Sample XML
A sample of the Generic WMS PO XML Message (CWPurchaseOrder) is presented below.
- <Message source="CWI" target="WMS" type="CWPurchaseOrder">
- <PO>
- <POHeader type="WMS" message_type="PO" company="555" file_trans_nbr="000000015" po_nbr="1320" status="O" workstation="QPADEV000D" cancel_date="20040820" confirm_po="N" currency_rate="1" due_date="20040814" entry_date="20040813" negotiate_price="N" promise_date="20040825" recurring_po="N" revision_nbr="2" prt_worksheet="N" revised_date="20040813" po_type="I" buyer="BTM" offer="204" user="KBOTTGER" whse="204" currency_code="USD" vendor_nbr="202" ship_via="1" in_use_user="KBOTTGER" name="PET SUPPLIES" address_line1="11 SANFORD STREET" city="MEDWAY" state="MA" zip="02053" telephone="508 533-8038" contact_name="BERNADETTE T MIRANDA" tot_ord_qty="50" activity_code="C" wms_control="38" company_designator="555" program_id="IFR0076" date_created="20040813" time_created="0125228" wms_whse="">
- <PODetails>
<PODetail seq="1" status="O" line="1" cancel_date="20040820" due_date="20040814" invty_item="Y" order_qty="50" price="5.2500" promise_date="20040825" disc_override="N" entry_date="20040813" price_method="S" vendor_price="5.2500" vend_price_curr="S" item="2004SKU1" sku="RED WMNS LRGE" buyer="BTM" offer="204" ship_via="1" vendor_nbr="202" whse="204" pkms_season="" pkms_style="12345678" pkms_style_suffix="9012345" pkms_size_range_code="" />
</PODetails>
</POHeader>
</PO>
</Message>