Chapter 77: WMS Background Jobs (WPBJ) | Contents | SCVs | Search | Glossary | Reports | XML | Index | Chapter 79: Sending Vendor Information to a Warehouse Management System |
Chapter 78: Sending Item and SKU Information to a Warehouse Management System
Purpose: CWDirect sends a record to a warehouse management system, such as PkMS, whenever an item is created or maintained.
In this chapter:
• PkMS Style Detail File (STSTYLIN)
• PkMS Notes Master File (CCASEIN)
• PkMS Item Interface File (I5INPT00)
• PkMS Case Comments File (CCCASE00)
• PkMS Item XML Message (ItemMaster_1_0)
• PkMS Item Message: Sample XML
• Generic WMS Item XML Message (CWItem)
• Generic WMS Item Message: Sample XML
• Generic WMS Item Notes XML Message (CWItemNotes)
• Generic WMS Item Notes 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 item and SKU information to a warehouse management system:
• Create a cross reference between a PkMS item and a CWDirect item number and SKU at the Working with PkMS Item Cross Reference (PKIR).
• Enter Y in the Use PkMS Interface Values (F31) system control value.
• Enter a program name in the PkMS Item Interface Program (F33) system control value.
• Enter a program name in the PkMS Item Notes Program (F47) system control value.
• Enter a data transport type in the PkMS Transport Type (G80) system control value.
Item and SKU information is sent to a warehouse management system when:
• You add, change or delete an item or SKU in Work with Item/SKUs or Generate SKUs; see Merchandising Chapter 24: Performing Initial Item Entry (MITM) and Chapter 42: Using the SKU Generator (ESKG).
• You change the average cost for an item or SKU; CWDirect only sends item/SKU information to PkMS when you change the average cost if the Send Average Cost Changes to PkMS (F92) system control value is set to Y.
• You create or change item or SKU product comments or customer service comments in Work with Item/SKUs or Order Entry.
• PkMS Style Detail File (STSTYLIN)
• PkMS Notes Master File (CCASEIN)
PkMS Style Detail File (STSTYLIN)
This table shows the fields in the PkMS Style Detail file (STSTYLIN) CWDirect updates when an item or SKU is created, changed, or deleted and you are using version 18 of PkMS.
Field Name |
Field Length |
Description |
Company |
3 |
The CWDirect company code where you created, changed, or deleted an item or SKU. |
Sea |
2 |
CWDirect item/SKU, based on the item cross reference you set up; see Chapter 73: Working with PkMS Item Cross Reference (PKIR). |
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 |
A number assigned to an item/SKU each time it is sent to PkMS. 0 = The item/SKU has been created. 1 and up = The item/SKU has been changed. |
Product group |
3 |
The CWDirect item class defined for the item/SKU. Example: PNT |
Product sub’group |
3 |
The CWDirect long SKU department defined for the item/SKU. Example: 002 |
Product type |
3 |
The CWDirect long SKU Class defined for the item/SKU. Example: 005 |
Style desc |
35 |
The CWDirect item description. |
Color desc |
35 |
The CWDirect SKU element 1 description. |
Package barcode |
20 |
The first 6 positions of the item number and the first three positions of SKU element 1, SKU element 2, and SKU element 3. Example: CTS093REDBOYLRG |
Price |
9.2 |
The CWDirect item default cost. |
Retl price |
9.2 |
The CWDirect vendor code defined for this item. |
Box qty |
9.2 |
1 displays in this field. |
Std case qty |
9.2 |
CWDirect item pieces per case quantity. |
Std case length |
7.2 |
The CWDirect SKU length if SKUs exist; otherwise CWDirect item length. |
Std case width |
7.2 |
The CWDirect SKU width if SKUs exist; otherwise CWDirect item width. |
Std case height |
7.2 |
The CWDirect SKU height if SKUs exist; otherwise CWDirect item height. |
Unit weight |
9.4 |
The CWDirect SKU shipping weight if SKUs exist; otherwise item shipping weight. |
Unit volume |
9.4 |
The CWDirect SKU cube factor if SKUs exist; otherwise item cube factor. |
Misc1 numeric field |
9.4 |
The vendor number defined for the item. |
Misc1 numeric field |
9.4 |
The average cost of an item. CWDirect populates this field when the average cost for an item or SKU changes and the Send Average Cost Changes to PkMS (F92) system control value is set to Y. |
Specl instr code |
2 |
Positions 1 and 2 of SKU User field 1. |
Specl instr code |
2 |
Positions 3 and 4 of SKU User field 1. |
Status flag |
2 |
Valid values: A = new item/SKU (displays when you create an item or SKU) C = changed item/SKU (displays when you change an item or SKU) P = deleted item/SKU (displays when you delete an item or SKU) |
DCR |
9 |
The date the record was created in YYYYMMDD format. |
TCR |
7 |
The time the record was created in HHMMSS format. |
User ID |
10 |
The program name defined in the PkMS Item Interface Program (F33) system control value. |
PkMS Notes Master File (CCASEIN)
This table shows the fields in the PkMS Notes Master file (CCASEIN) CWDirect updates when you create or change an item or SKU product comment or customer service comment and you are using version 18 of PkMS.
Field Name |
Field Length |
Description |
Record type |
2 |
CWDirect note type: SK = SKU Comments CS = Customer service comments PC = Product comments |
Reference# |
20 |
The first 6 positions of the item number and 14 positions of the SKU. Example: CT5 |
Sequence number |
5 |
SKU comment sequence number if the note is associated with an item's SKU; otherwise item comment sequence number. |
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 item or SKU note. Example: Wash in warm water with like colors; do not use bleach. |
DCR |
9 |
The date this record was created in YYYYMMDD format. |
TCR |
7 |
The time this record was created in HHMMSS format. |
User ID |
10 |
The program name defined in the PkMS Item Interface Program (F33) 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 item/SKU information to a warehouse management system. PKMSLOCAL indicates CWDirect sends the item/SKU files using flat files; FTP indicates CWDirect sends the item/SKU files using FTP processing.
FTP processing: You can send item and SKU information to PkMS using FTP processing if you are using version 19; see Sending and Receiving WMS Information using FTP Processing.
• PkMS Item Interface File (I5INPT00)
• PkMS Case Comments File (CCCASE00)
PkMS Item Interface File (I5INPT00)
This table shows the fields in the PkMS Item Interface file (I5INPT00) CWDirect updates when an item or SKU is created, changed, or deleted and you are using version 19 of PkMS.
Field Name |
Field Length |
Description |
Batch control number |
10 |
The next available number defined in the PkMS Item Control Number number assignment value. |
Date created |
9 |
The date the record was created in YYYYMMDD format. |
Time created |
7 |
The time the record was created in HHMMSS format. |
User ID |
10 |
The program name defined in the PkMS Item Interface Program (F33) system control value. |
Company |
3 |
The CWDirect company code where you created, changed, or deleted an item or SKU. |
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. |
Product group |
3 |
The CWDirect item class defined for the item/SKU. Example: PNT |
Product sub’group |
3 |
The CWDirect long SKU department defined for the item/SKU. Example: 002 |
Product type |
3 |
The CWDirect long SKU Class defined for the item/SKU. Example: 005 |
Style desc |
35 |
The CWDirect item description. |
Color desc |
35 |
The CWDirect SKU element 1 description. |
Package barcode |
20 |
The first 6 positions of the item number and the first three positions of SKU element 1, SKU element 2, and SKU element 3. Example: CTS093REDBOYLRG |
Price |
9.2 |
The CWDirect item default cost. |
Retl price |
9.2 |
The average cost of an item. CWDirect populates this field when the average cost for an item or SKU changes and the Send Average Cost Changes to PkMS (F92) system control value is set to Y. |
Box qty |
9.2 |
1 displays in this field. |
Std case qty |
9.2 |
CWDirect item pieces per case quantity. |
Std case length |
7.2 |
The CWDirect SKU length if SKUs exist; otherwise CWDirect item length. |
Std case width |
7.2 |
The CWDirect SKU width if SKUs exist; otherwise CWDirect item width. |
Std case height |
7.2 |
The CWDirect SKU height if SKUs exist; otherwise CWDirect item height. |
Unit weight |
9.4 |
The CWDirect SKU shipping weight if SKUs exist; otherwise item shipping weight. |
Unit volume |
9.4 |
The CWDirect SKU cube factor if SKUs exist; otherwise item cube factor. |
Misc1 numeric field1 |
9.4 |
The vendor number defined for the item. |
Misc1 numeric field5 |
9.4 |
The average cost of an item. CWDirect populates this field when the average cost for an item or SKU changes. |
Status flag |
2 |
Valid values: 10 = new item/SKU (displays when you create an item or SKU) blank = changed item/SKU (displays when you change an item or SKU) 99 = deleted item/SKU (displays when you delete an item or SKU) |
PkMS Case Comments File (CCCASE00)
This table shows the fields in the PkMS Case Comments file (CCASE00) CWDirect updates when you create or change an item or SKU product comment or customer service comment and you are using version 19 of PkMS.
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 |
SKU comment sequence number if the note is associated with an item's SKU; otherwise item comment 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 item or SKU note. Example: Wash in warm water with like colors; do not use bleach. |
User ID |
10 |
The program name defined in the PkMS Item Interface Program (F33) system control value. |
Version of XML message? The PkMS Item Interface Program (F33) system control value defines the program name CWDirect uses to send item and SKU information to a warehouse management system. The base program name for version 2001 of PkMS is IFR0061.
PkMS or generic XML messages? The Item XML Message Format (H38) system control value defines the XML message format the system generates when it sends item and SKU information to a warehouse management system:
• PKMS generates the PkMS Item XML Message (ItemMaster_1_0).
• GENERIC generates the version 1.0 Generic WMS Item XML Message (CWItem) and Generic WMS Item Notes XML Message (CWItemNotes).
• GENERIC_2 generates the version 2.0 Generic WMS Item XML Message (CWItem) and Generic WMS Item Notes XML Message (CWItemNotes).
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 item/SKU information to a warehouse management system is ITEM EXPORT. The MQ job used to send item notes to a warehouse management system is ITEM NOTES EXPORT. See Chapter 92: Working with WMS MQ Job Control (WMJC).
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 Item XML Message (ItemMaster_1_0)
This message is transmitted to PkMS when you create, change, or delete an item/SKU in CWDirect and the Item XML Message Format (H38) system control value is set to PKMS.
For more information: See:
• PkMS Item 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 defaults. |
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_ItemMaster + the date and time the message was created + the next number available from the Item File Transfer # number assignment value. |
|
||||
|
||||
|
||||
Company |
alpha |
10 |
Y |
The CWDirect company code where you created, changed, or deleted an item or SKU. |
Division |
alpha |
10 |
Y |
A code that represents the division associated with the item/SKU. For messages sent from CWDirect, 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 0000000 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. |
numeric |
5.0 |
Y |
0 displays. |
|
alpha |
10 |
N |
The next number available from the PkMS Item Control Number number assignment value. |
|
|
||||
DateCreated |
numeric |
9.0 |
N |
The date and time the message was created in YYYY-MM-DDTHH:MM:SS format. |
ProductGroup |
alpha |
3 |
N |
The CWDirect item class defined for the item/SKU. |
ProductSubgroup |
alpha |
3 |
N |
The CWDirect long SKU department defined for the item/SKU. |
ProductType |
alpha |
3 |
N |
The CWDirect long SKU class defined for the item/SKU. |
StyleDescription |
alpha |
35 |
N |
The CWDirect item description. |
ColorDescription |
alpha |
35 |
N |
The CWDirect SKU element 1 description. |
PackageBarcode |
alpha |
20 |
N |
The first 6 positions of the item number + the first 3 positions of SKU element 1, SKU element 2, and SKU element 3, for example CTS093REDBOYLRG. |
Price |
numeric |
19.4 |
N |
The CWDirect item default cost. |
RetailPrice |
numeric |
19.4 |
N |
The average cost of the item. |
BoxQuantity |
numeric |
9.2 |
N |
The hard-coded value 1 displays. |
StandardCaseQuantity |
numeric |
9.2 |
N |
CWDirect item pieces per case quantity. |
StandardCaseLength |
numeric |
7.2 |
N |
CWDirect SKU length if SKUs exist; otherwise CWDirect item length. |
StandardCaseWidth |
numeric |
7.2 |
N |
CWDirect SKU width if SKUs exist; otherwise CWDirect item width. |
StandardCaseHeight |
numeric |
7.2 |
N |
CWDirect SKU height if SKUs exist; otherwise CWDirect item height. |
UnitWeight |
numeric |
15.7 |
N |
The CWDirect SKU shipping weight if SKUs exist; otherwise item shipping weight. |
UnitVolume |
numeric |
15.7 |
N |
The CWDirect SKU cube factor if SKUs exist; otherwise item cube factor. |
SpecialInstrCode3 |
alpha |
2 |
N |
Positions 1-2 of SKU user field 1. |
SpecialInstrCode4 |
alpha |
2 |
N |
Positions 3-4 of SKU user field 1. |
MiscNumericField1 |
numeric |
9.4 |
N |
The vendor number defined for the item. |
MiscNumericField2 |
numeric |
9.4 |
N |
The average cost of the item. |
StatusFlag |
alpha |
2 |
N |
Valid values: 10 = Add or change 90 = Delete |
Function |
alpha |
1 |
N |
Valid values: 1 = Add 2 = Change 4 = Delete |
A sample of the PkMS Item XML Message (ItemMaster_1_0) is presented below.
- <ItemMaster_1_0 version="1.0" timestamp="2004-08-13T10:20:14" id="PKMS_ItemMaster_2004-08-13T10:20:14.000000060">
- <ItemMaster>
- <Item>
- <SKUDefinition>
<Company>555</Company>
<Division />
<Style>12345678</Style>
<StyleSuffix>9012345</StyleSuffix>
</SKUDefinition>
<SequenceNbr>0</SequenceNbr>
<BatchCtrlNbr>170</BatchCtrlNbr>
- <ItemMasterFields>
<DateCreated>2004-08-13T10:20:14</DateCreated>
<StyleDescription>2004SKU1 ITEM DESCRIPTION</StyleDescription>
<ColorDescription>MAROON</ColorDescription>
<PackageBarcode>2004SKRED WMNSLRGE</PackageBarcode>
<Price>5</Price>
<RetailPrice>202</RetailPrice>
<BoxQuantity>1</BoxQuantity>
<MiscNumericField1>202</MiscNumericField1>
<MiscNumericField2>.0049</MiscNumericField2>
<StatusFlag>10</StatusFlag>
<Funtion>2</Funtion>
</ItemMasterFields>
</Item>
</ItemMaster>
</ItemMaster_1_0>
Generic WMS Item XML Message (CWItem)
This message is transmitted to a warehouse management system when you create, change, or delete an item/SKU in CWDirect and the Item XML Message Format (H38) system control value is set to GENERIC or GENERIC_2. An abbreviated XML message is sent to the warehouse management system when you delete an item in CWDirect.
For more information: See:
• Generic WMS Item 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. CWItem indicates the message contains item/SKU updates. |
1 item record for each XML message. |
|||
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. IT indicates the message contains item/SKU updates. |
company |
numeric |
3.0 |
Value defined in the Company field (ARCOMP) in the CWDirect Item file. |
file_trans_nbr |
numeric |
9.0 |
The next number available from the Item File Transfer # number assignment value. |
itm_number |
alpha |
12 |
Value defined in the Item number field (ARBECD) in the CWDirect Item file. |
allow_skus |
alpha |
1 |
Value defined in the Allow SKUs field (ARBDST) in the CWDirect Item file. Y = Item contains SKUs N = Item does not contain SKUs |
average_cost |
numeric |
11.4 |
Value defined in the Average cost field (ARACPR) in the CWDirect Item file. |
itm_cubing_value |
numeric |
7.1 |
Value defined in the Cub val field (ARAUNB) in the CWDirect Item file. |
drop_ship |
alpha |
1 |
Value defined in the Drop ship field (ARBEST) in the CWDirect Item file. You can flag an item as drop ship at the item level and SKU level. The setting at the SKU level overrides the setting at the item level. If the setting at the SKU level is blank, the system uses the setting at the item level. Y = Drop ship item. If the item is flagged as drop ship, any SKUs for the item can be flagged as drop ship or non-drop ship. N = Non-drop ship item. If the item is flagged as non-drop ship, any SKUs for the item must also be flagged as non-drop ship. |
fifo_cost |
numeric |
11.4 |
Value defined in the FIFO cost field (ARADPR) in the CWDirect Item file. |
item_height |
numeric |
3.0 |
Value defined in the Height field (ARAIQT) in the CWDirect Item file. |
kit_type |
alpha |
1 |
Value defined in the Kit type field (ARBFST) in the CWDirect Item file. C = continuity item S = set item F = finished good item V = variable set item |
last_physical_date |
numeric |
8.0 |
Value defined in the Last physical date field (ARAEDT) in the CWDirect Item file. This date is in YYYYMMDD format. |
last_purchase_cost |
numeric |
11.4 |
Value defined in the Last purchase cost field (ARAEPR) in the CWDirect Item file. |
item_length |
numeric |
3.0 |
Value defined in the Length field (ARAJQT) in the CWDirect Item file. |
long_sku_style |
alpha |
20 |
Value defined in the Long SKU style field (ARBGCD) in the CWDirect Item file. |
long_sku_vendor |
alpha |
7 |
Value defined in the Long SKU vendor field (ARBHCD) in the CWDirect Item file. |
lot_nbr_tracking |
alpha |
1 |
Value defined in the Lot # tracking field (ARBGST) in the CWDirect Item file. |
lifo_cost |
numeric |
11.4 |
Value defined in the LIFO cost field (ARAFPR) in the CWDirect Item file. |
non-inventory |
alpha |
1 |
Value defined in the Non-inventory field (ARBHST) in the CWDirect Item file. |
partial_units |
alpha |
1 |
Value defined in the Partial units field (ARBIST) in the CWDirect Item file. |
pieces_per_case |
numeric |
5.0 |
Value defined in the Pieces per case field (ARAKQT) in the CWDirect Item file. |
selling_qty |
numeric |
5.0 |
Value defined in the Selling quantity field (ARALQT) in the CWDirect Item file. |
selling_weight |
numeric |
7.3 |
Value defined in the Selling weight field (ARAVNB) in the CWDirect Item file. |
serial_tracking |
alpha |
1 |
Value defined in the Serial # tracking field (ARBJST) in the CWDirect Item file. |
ship_alone |
alpha |
1 |
Value defined in the Ship alone field (ARBKST) in the CWDirect Item file. |
ship_weight |
numeric |
7.3 |
Value defined in the Ship weight field (ARAWNB) in the CWDirect Item file. |
standard_cost |
numeric |
11.4 |
Value defined in the Standard cost field (ARAGPR) in the CWDirect Item file. |
user_field1 |
alpha |
10 |
Value defined in the User field 1 field (ARAVTX) in the CWDirect Item file. |
user_field2 |
alpha |
10 |
Value defined in the User field 2 field (ARAWTX) in the CWDirect Item file. |
user_field3 |
alpha |
10 |
Value defined in the User field 3 field (ARAXTX) in the CWDirect Item file. |
user_field4 |
alpha |
10 |
Value defined in the User field 4 field (ARAYTX) in the CWDirect Item file. |
width |
numeric |
3.0 |
Value defined in the Width field (ARAMQT) in the CWDirect Item file. |
expiration_limit |
numeric |
5.0 |
Value defined in the Expiration limit field (ARFHNB) in the CWDirect Item file. |
fifo_tracking |
alpha |
1 |
Value defined in the FIFO tracking field (ARDEST) in the CWDirect Item file. |
allow_pct_disc |
alpha |
1 |
Value defined in the Allow % discount field (ARDWST) in the CWDirect Item file. |
case_piece |
alpha |
1 |
Value defined in the Cases/piece field (ARECST) in the CWDirect Item file. |
oversize_flag |
alpha |
1 |
Value defined in the Oversize field (AREDST) in the CWDirect Item file. |
description |
alpha |
40 |
Value defined in the Description field (AREOTX) in the CWDirect Item file. |
required_truck_item |
alpha |
1 |
Value defined in the Required truck item field (ARGFST) in the CWDirect Item file. |
second_lang_descr |
alpha |
40 |
Value defined in the Second language description field (ARM8TV) in the CWDirect Item file. |
royalty |
alpha |
1 |
Value defined in the Royalty field (ARX9SW) in the CWDirect Item file. |
membership |
alpha |
1 |
Value defined in the Membership field (ARYASW) in the CWDirect Item file. |
future_use_yn_3 |
alpha |
1 |
Value defined in the Future use Y/N 3 field (ARYBSW) in the CWDirect Item file. |
generic_ecommerce |
alpha |
20 |
Value defined in the Generic Ecommerce field (ARP8CG) in the CWDirect Item file. |
future_use_cde_2 |
alpha |
20 |
Value defined in the Future use cde 2 field (ARP9CG) in the CWDirect Item file. |
future_use_cde_3 |
alpha |
20 |
Value defined in the Future use cde 3 field (ARQACG) in the CWDirect Item file. |
last_change_date |
numeric |
7.0 |
Value defined in the Last change date field (ARCFDT) in the CWDirect Item file, in YYYYMMDD format. |
date_last_extract |
numeric |
7.0 |
Value defined in the Date last extract field (ARCGDT) in the CWDirect Item file, in YYYYMMDD format. |
last_ecomm_info_chg |
numeric |
7.0 |
Value defined in the Last ecomm info chg field (ARCHDT) in the CWDirect Item file, in YYYYMMDD format. |
qty_threshold |
numeric |
9.0 |
Value defined in the Qty threshold field (AROFQX) in the CWDirect Item file. |
future_use_qty2 |
numeric |
9.0 |
Value defined in the Future use qty 2 field (AROGQX) in the CWDirect Item file. |
future_use_qty3 |
numeric |
9.0 |
Value defined in the Future use qty 3 field (AROHQX) in the CWDirect Item file. |
future_use_val1 |
numeric |
15.2 |
Value defined in the Future use val 1 field (ARJ0VD) in the CWDirect Item file. |
future_use_val2 |
numeric |
15.2 |
Value defined in the Future use val 2 field (ARJ1VD) in the CWDirect Item file. |
future_use_val3 |
numeric |
15.2 |
Value defined in the Future use val 3 field (ARJ2VD) in the CWDirect Item file. |
download_processed |
alpha |
1 |
Value defined in the Download processed field (ARYCSW) in the CWDirect Item file. |
future_use_sts_2 |
alpha |
1 |
Value defined in the Future use sts 2 field (ARYDSW) in the CWDirect Item file. |
future_use_sts_3 |
alpha |
2 |
Value defined in the Future use sts 3 field (ARYESW) in the CWDirect Item file. |
future_use_sts_4 |
alpha |
2 |
Value defined in the Future use sts 4 field (ARYFSW) in the CWDirect Item file. |
future_use_yn_1 |
alpha |
1 |
Value defined in the Future use Y/N 1 field (ARTFSY) in the CWDirect Item file. |
future_use_yn_2 |
alpha |
1 |
Value defined in the Future use Y/N 2 field (ARTGSY) in the CWDirect Item file. |
future_use_cde_1 |
alpha |
10 |
Value defined in the Future use cde 1 field (AREECF) in the CWDirect Item file. |
future_use_date1 |
numeric |
7.0 |
Value defined in the Future use date 1 field (ARF4DY) in the CWDirect Item file, in YYYYMMDD format. |
future_use_date2 |
numeric |
7.0 |
Value defined in the Future use date 2 field (ARF5DY) in the CWDirect Item file, in YYYYMMDD format. |
future_use_date3 |
numeric |
7.0 |
Value defined in the Future use date 3 field (ARF6DY) in the CWDirect Item file, in YYYYMMDD format. |
buyer |
alpha |
3 |
Value defined in the Buyer field (ARCFCD) in the CWDirect Item file. |
ctn_id |
numeric |
2.0 |
Value defined in the Carton ID # field (ARCTID) in the CWDirect Item file. |
gla_account |
numeric |
8.0 |
Value defined in the Account # field (AREONB) in the CWDirect Item file. |
inventory_value_gl |
numeric |
8.0 |
Value defined in the Inventory value G/L # field (ARHNNB) in the CWDirect Item file. |
haz_code |
numeric |
2.0 |
Value defined in the Hazardous code field (ARHRNB) in the CWDirect Item file. |
item_class |
alpha |
3 |
Value defined in the Item class field (ARBLCD) in the CWDirect Item file. |
cycle |
alpha |
2 |
Value defined in the Cycle field (ARBNCD) in the CWDirect Item file. |
sku_group |
numeric |
3.0 |
Value defined in the SKU group field (ARBHNB) in the CWDirect Item file. |
item_status |
alpha |
1 |
Value defined in the Item status field (ARBOCD) in the CWDirect Item file. |
location_class |
alpha |
2 |
Value defined in the Location class field (ARBPCD) in the CWDirect Item file. |
long_sku_class |
numeric |
4.0 |
Value defined in the Long SKU class field (ARLCDE) in the CWDirect Item file. |
lsd_department |
numeric |
4.0 |
Value defined in the Long SKU department field (ARFXNB) in the CWDirect Item file. |
uom_type |
alpha |
3 |
Value defined in the UOM field (ARCDCD) in the CWDirect Item file. |
vendor_nbr |
numeric |
7.0 |
Value defined in the Vendor # field (ARFYNB) in the CWDirect Item file. |
ship_via_code |
numeric |
2.0 |
Value defined in the Ship via code field (ARK9NB) in the CWDirect Item file. |
warehouse |
numeric |
3.0 |
Value defined in the Warehouse field (ARWCDE) in the CWDirect Item file. |
mfr_vendor |
numeric |
7.0 |
Value defined in the Manufacturer vendor field (ARKONQ) in the CWDirect Item file. |
entity_nbr |
numeric |
3.0 |
Value defined in the Entity number field (ARRQNQ) in the CWDirect Item file. |
updated_by |
alpha |
10 |
Value defined in the Updated by user field (ARD7CF) in the CWDirect Item file. |
created_by |
alpha |
10 |
Value defined in the Created by field (ARQ5CF) in the CWDirect Item file. |
season |
alpha |
3 |
Value defined in the Season field (ARQ6CF) in the CWDirect Item file. |
activity_code |
alpha |
1 |
A = add C = change D = delete |
wms_control_nbr |
numeric |
9.0 |
The next number available in the PkMS Item 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 program that generated this XML message. |
date_created |
numeric |
8.0 |
The date the message was created in YYYYMMDD format. |
time_created |
numeric |
7.0 |
The time the message was created in HHMMSS format. |
|
|||
vendor_nbr |
numeric |
7.0 |
Value defined in the Vendor # field (DHFYNB) in the CWDirect Vendor Item file. |
vendor_product_nbr |
alpha |
20 |
Value defined in the Item field (DHO6CD) in the CWDirect Vendor Item file. |
vendor_price |
numeric |
11.4 |
Value defined in the Price field (DHSLPR) in the CWDirect Vendor Item file. |
vendor_uom |
alpha |
3 |
Value defined in the UOM field (DHCDCD) in the CWDirect Vendor Item file. |
|
|||
upc_type |
alpha |
3 |
Value defined in the UPC type field (S0YLSY) in the CWDirect Item UPC file. |
upc_code |
numeric |
14.0 |
Value defined in the UPC field (S0MONR) in the CWDirect Item UPC file. |
|
|||
code |
alpha |
14 |
Value defined in the SKU code field (BJBESK) in the CWDirect SKU file. |
collating_sequence |
numeric |
5.0 |
Value defined in the Collating sequence # field (BJAVQT) in the CWDirect SKU file. |
compatibility |
alpha |
3 |
Value defined in the Last purchase cost field (BJBUCD) in the CWDirect SKU file. |
last_purchase_cost |
numeric |
11.4 |
Value defined in the Last purchase cost field (BJAOPR) in the CWDirect SKU file. |
cubing_value_override |
numeric |
7.1 |
Value defined in the Cub value field (BJA0NB) in the CWDirect SKU file. |
description |
alpha |
40 |
Value defined in the Description field (BJBCTX) in the CWDirect SKU file. |
subscription |
alpha |
1 |
Value defined in the Subscription field (BJBOST) in the CWDirect SKU file. |
height_override |
numeric |
3.0 |
Value defined in the Height override field (BJAWQT) in the CWDirect SKU file. |
length_override |
numeric |
3.0 |
Value defined in the Length override field (BJAXQT) in the CWDirect SKU file. |
list_price |
numeric |
7.2 |
Value defined in the List price field (BJAPPR) in the CWDirect SKU file. |
long_sku_color |
numeric |
5.0 |
Value defined in the Long SKU color field (BJAYQT) in the CWDirect SKU file. |
long_sku_size |
numeric |
5.0 |
Value defined in the Long SKU size field (BJAZQT) in the CWDirect SKU file. |
long_sku_width |
numeric |
5.0 |
Value defined in the Long SKU width field (BJA0QT) in the CWDirect SKU file. |
lowest_price |
numeric |
7.2 |
Value defined in the Lowest price field (BJAQPR) in the CWDirect SKU file. |
makeup_date |
numeric |
8 |
Value defined in the Make up date field (BJAIDT) in the CWDirect SKU file, in YYYYMMDD format. |
max_qty_location |
numeric |
7.0 |
Value defined in the Max qty for location field (BJA1QT) in the CWDirect SKU file. |
max_qty_warehouse |
numeric |
7.0 |
Value defined in the Max qty for warehouse field (BJA2QT) in the CWDirect SKU file. |
min_qty_location |
numeric |
7.0 |
Value defined in the Min qty for location field (BJA3QT) in the CWDirect SKU file. |
min_qty_warehouse |
numeric |
7.0 |
Value defined in the Min qty for warehouse field (BJA4QT) in the CWDirect SKU file. |
gift_certificate |
alpha |
1 |
Value defined in the Gift certificate field (BJBPST) in the CWDirect SKU file. |
out_of_stock |
alpha |
1 |
Value defined in the Out of stock flag field (BJBQST) in the CWDirect SKU file. |
qty_order_direct_ship |
numeric |
7.0 |
Value defined in the Qty order direct ship field (BJA5QT) in the CWDirect SKU file. |
receipt_date |
numeric |
7.0 |
Value defined in the Receipt date field (BJAJDT) in the CWDirect SKU file, in YYYYMMDD format. |
reserve_qty_limit |
numeric |
7.0 |
Value defined in the Reserve qty limit field (BJA6QT) in the CWDirect SKU file. |
restrict_orders |
alpha |
1 |
Value defined in the Restrict orders field (BJBRST) in the CWDirect SKU file. |
retail_ref_nbr |
numeric |
15.0 |
Value defined in the Retail ref # field (BJA7QT) in the CWDirect SKU file. |
out_of_stock_date |
numeric |
8 |
Value defined in the Out of stock date field (BJAKDT) in the CWDirect SKU file, in YYYYMMDD format. |
selling_weight_override |
numeric |
7.3 |
Value defined in the Selling weight override field (BJA1NB) in the CWDirect SKU file. |
short_sku |
numeric |
7.0 |
Value defined in the Short SKU field (BJA8QT) in the CWDirect SKU file. |
times_out_of_stock |
numeric |
5.0 |
Value defined in the Times out of stock field (BJA9QT) in the CWDirect SKU file. |
times_picked |
numeric |
7.0 |
Value defined in the Times picked field (BJBAQT) in the CWDirect SKU file. |
user_field_1 |
alpha |
10 |
Value defined in the User field 1 field (BJBDTX) in the CWDirect SKU file. |
user_field_2 |
alpha |
10 |
Value defined in the User field 2 field (BJBETX) in the CWDirect SKU file. |
user_field_3 |
alpha |
10 |
Value defined in the User field 3 field (BJBFTX) in the CWDirect SKU file. |
weight_override |
numeric |
7.3 |
Value defined in the Weight override field (BJA2NB) in the CWDirect SKU file. |
width_override |
numeric |
3.0 |
Value defined in the Width override field (BJBBQT) in the CWDirect SKU file. |
date_of_first_order |
numeric |
7.0 |
Value defined in the Date of first order field (BJBADT) in the CWDirect SKU file, in YYYYMMDD format. |
date_of_last_order |
numeric |
7.0 |
Value defined in the Date of last order field (BJBBDT) in the CWDirect SKU file, in YYYYMMDD format. |
sale_credit |
alpha |
1 |
Value defined in the Sale credit flag field (BJD6ST) in the CWDirect SKU file. |
harmonize_code |
alpha |
16 |
Value defined in the Harmonize code field (BJKXCD) in the CWDirect SKU file. |
sku_coordinate_group |
numeric |
3.0 |
Value defined in the Coordinate group field (BJWWQT) in the CWDirect SKU file. |
orders_avail_pick_gen |
numeric |
7.0 |
Value defined in the Orders avail pick gen field (BJYMQT) in the CWDirect SKU file. |
sku_open_qty |
numeric |
7.0 |
Value defined in the SKU open qty field (BJB4QY) in the CWDirect SKU file. |
sku_future_qty |
numeric |
7.0 |
Value defined in the Future qty field (BJCNQY) in the CWDirect SKU file. |
sku_suspense_qty |
numeric |
7.0 |
Value defined in the SKU suspense qty field (BJC0QY) in the CWDirect SKU file. |
sku_onhold_qty |
numeric |
7.0 |
Value defined in the On hold qty field (BJEXQY) in the CWDirect SKU file. |
sku_average_cost |
numeric |
11.4 |
Value defined in the SKU average cost field (BJWDPR) in the CWDirect SKU file. |
fifo_cost |
numeric |
11.4 |
Value defined in the FIFO cost field (BJWEPR) in the CWDirect SKU file. |
lifo_cost |
numeric |
11.4 |
Value defined in the LIFO cost field (BJWFPR) in the CWDirect SKU file. |
standard_cost |
numeric |
11.4 |
Value defined in the Standard cost field (BJWGPR) in the CWDirect SKU file. |
second_language_desc |
alpha |
40 |
Value defined in the Second language desc field (BJM6TV) in the CWDirect SKU file. |
vat_exempt_flag |
alpha |
1 |
Value defined in the VAT exempt flag field (BJK2SW) in the CWDirect SKU file. |
second_compatibility |
alpha |
3 |
Value defined in the Second compatibility field (BJHPCG) in the CWDirect SKU file. |
hidden_tax_amount |
numeric |
7.2 |
Value defined in the Hidden tax amount field (BJAOVD) in the CWDirect SKU file. |
hidden_tax_percent |
numeric |
5.2 |
Value defined in the Hidden tax percent field (BJN7PC) in the CWDirect SKU file. |
suppress_bo_card |
alpha |
1 |
Value defined in the Suppress B/O card field (BJYN01) in the CWDirect SKU file. |
unused_yn_flag2 |
alpha |
1 |
Value defined in the Unused Y/N flag 2 field (BJYN02) in the CWDirect SKU file. |
projected_returns |
numeric |
7.0 |
Value defined in the Projected returns field (BJLPNQ) in the CWDirect SKU file. |
drop_ship_avail_qty |
numeric |
7.0 |
Value defined in the Drop ship avail qty field (BJLQNQ) in the CWDirect SKU file. |
user_field4 |
alpha |
5 |
Value defined in the User field 4 field (BJIKCG) in the CWDirect SKU file. |
user_field5 |
alpha |
5 |
Value defined in the User field 5 field (BJILCG) in the CWDirect SKU file. |
book_inventory |
numeric |
7.0 |
Value defined in the Book inventory field (BJWFNQ) in the CWDirect SKU file. |
returnable |
alpha |
1 |
Value defined in the Returnable field (BJGNSY) in the CWDirect SKU file. |
retail_xref_nbr |
numeric |
10.0 |
Value defined in the Retail x-ref # field (BJWGNQ) in the CWDirect SKU file. |
ls_style |
alpha |
20 |
Value defined in the L/S style field (BJWTCG) in the CWDirect SKU file. |
ls_vendor |
alpha |
7 |
Value defined in the L/S vendor field (BJWUCG) in the CWDirect SKU file. |
receiving_priority |
alpha |
2 |
Value defined in the Receiving priority field (BJG5SY) in the CWDirect SKU file. |
sku_future_use_sts_2 |
alpha |
2 |
Value defined in the Future use sts 2 field (BJG6SY) in the CWDirect SKU file. |
sku_future_use_sts_3 |
alpha |
2 |
Value defined in the Future use sts 3 field (BJG7SY) in the CWDirect SKU file. |
excl_store_restock |
alpha |
1 |
Value defined in the Excl store restock field (BJHESY) in the CWDirect SKU file. |
sku_future_use_yn_2 |
alpha |
1 |
Value defined in the Future use Y/N 2 field (BJHFSY) in the CWDirect SKU file. |
sku_future_use_yn_3 |
alpha |
1 |
Value defined in the Future use Y/N 3 field (BJHGSY) in the CWDirect SKU file. |
sku_future_use_val1 |
numeric |
11.2 |
Value defined in the Future use value 1 field (BJQKVD) in the CWDirect SKU file. |
sku_future_use_val2 |
numeric |
11.2 |
Value defined in the Future use value 2 field (BJQLVD) in the CWDirect SKU file. |
generic_ecommerce |
alpha |
10 |
Value defined in the Generic ecommerce field (BJWWCG) in the CWDirect SKU file. |
sku_future_use_code2 |
alpha |
10 |
Value defined in the Future use code 2 field (BJWXCG) in the CWDirect SKU file. |
sku_last_download_qty |
numeric |
5.0 |
Value defined in the Last download qty field (BJSXQX) in the CWDirect SKU file. |
sku_future_use_qty2 |
numeric |
5.0 |
Value defined in the Future use qty 2 field (BJSYQX) in the CWDirect SKU file. |
sku_last_extract |
numeric |
7.0 |
Value defined in the Last extract field (BJZJDT) in the CWDirect SKU file, in YYYYMMDD format. |
sku_last_ecomm_date |
numeric |
7.0 |
Value defined in the Last ecomm info chg field (BJZKDT) in the CWDirect SKU file, in YYYYMMDD format. |
sku_future_use_pct1 |
numeric |
5.2 |
Value defined in the Future use percent 1 field (BJPOPC) in the CWDirect SKU file. |
sku_future_use_pct2 |
numeric |
5.2 |
Value defined in the Future use percent 2 field (BJPPPC) in the CWDirect SKU file. |
sku_svc_card_reload |
alpha |
1 |
Value defined in the Future use Y/N 1 field (BJS2SY) in the CWDirect SKU file. |
sku_future_use_code1 |
alpha |
10 |
Value defined in the Future use code 1 field (BJD0CF) in the CWDirect SKU file. |
sku_future_use_date1 |
numeric |
7.0 |
Value defined in the Future use date 1 field (BJFWDY) in the CWDirect SKU file, in YYYYMMDD format. |
sku_future_use_date2 |
numeric |
7.0 |
Value defined in the Future use date 2 field (BJFXDY) in the CWDirect SKU file. |
sku_future_use_date3 |
numeric |
7.0 |
Value defined in the Future use date 3 field (BJFYDY) in the CWDirect SKU file. |
sku_future_use_sts1 |
alpha |
2 |
Value defined in the Future use sts 1 field (BJS3SY) in the CWDirect SKU file. |
sku_orig_retail_prc |
numeric |
7.2 |
Value defined in the Original retail price field (BJSKRP) in the CWDirect SKU file. |
sku_last_change_date |
numeric |
7.0 |
Value defined in the Last changed date field (BJSKLD) in the CWDirect SKU file. |
sku_create_date |
numeric |
7.0 |
Value defined in the Create date field (BJSKCR) in the CWDirect SKU file. |
sku_gtin |
numeric |
14.0 |
Value defined in the GTIN # field (BJFXVE) in the CWDirect SKU file. |
sku_commodity_code |
numeric |
8.0 |
Value defined in the Commodity code field (BJFZQZ) in the CWDirect SKU file. |
sku_abc_code |
alpha |
1 |
Value defined in the ABC code field (BJABCD) in the CWDirect SKU file. |
sku_ctn_id |
numeric |
2.0 |
Value defined in the CTN ID # field (BJCTID) in the CWDirect SKU file. |
sku_frequency_code |
alpha |
1 |
Value defined in the Freq code field (BJFRCD) in the CWDirect SKU file. |
sku_warehouse |
numeric |
3.0 |
Value defined in the Whs field (BJWCDE) in the CWDirect SKU file. |
sku_location |
alpha |
7 |
Value defined in the Location field (BJA4NB) in the CWDirect SKU file. |
sku_slc_code |
alpha |
2 |
Value defined in the SLC code field (BJCECD) in the CWDirect SKU file. |
sku_uom |
alpha |
3 |
Value defined in the UOM field (BJCDCD) in the CWDirect SKU file. |
sku_seo_code |
alpha |
4 |
Value defined in the Element 1 field (BJGUCD) in the CWDirect SKU file. |
sku_seo_desc |
alpha |
10 |
Value defined in the Element 1 desc field (B6B7TX) in the CWDirect SKU Element 1 file. |
sku_sew_code |
alpha |
4 |
Value defined in the Element 2 field (BJGVCD) in the CWDirect SKU file. |
sku_sew_desc |
alpha |
10 |
Value defined in the Element 2 desc field (B7B8TX) in the CWDirect SKU Element 2 file. |
sku_set_code |
alpha |
4 |
Value defined in the Element 3 field (BJGWCD) in the CWDirect SKU file. |
sku_set_desc |
alpha |
10 |
Value defined in the Element 3 desc field (B8B9TX) in the CWDirect SKU Element 3 file. |
sku_item_status |
alpha |
1 |
Value defined in the Item status field (BJMPCD) in the CWDirect SKU file. |
sku_itc_category |
alpha |
4 |
Value defined in the Category field (BJBLCE) in the CWDirect SKU file. |
sku_prep_code |
alpha |
2 |
Value defined in the Prep code field (BJW3CG) in the CWDirect SKU file. |
sku_country_of_origin |
alpha |
3 |
Value defined in the Country of origin field (BJW4CG) in the CWDirect SKU file. |
sku_ls_class |
numeric |
4.0 |
Value defined in the L/S class field (BJWJNQ) in the CWDirect SKU file. |
sku_zone_reservation |
alpha |
4 |
Value defined in the Zone reservation field (BJDZCF) in the CWDirect SKU file. |
sku_drop_ship |
alpha |
1 |
Value defined in the Drop ship (Future use Y/N 2) field (BJHFSY) in the CWDirect SKU file. You can flag an item as drop ship at the item level and SKU level. The setting at the SKU level overrides the setting at the item level. If the setting at the SKU level is blank, the system uses the setting at the item level. Y = Drop ship SKU. You can only flag a SKU as drop ship if the Drop ship flag at the item level is Y. N = Non-drop ship SKU. You can flag a SKU as non-drop ship if the Drop ship flag at the item level is Y, N or blank. blank = The drop ship setting has not been defined at the SKU level; instead, the system uses the drop ship setting defined at the item level to determine if the SKU is a drop ship item. Available in XML version: 2.0 (version 11.5 of CWDirect). Note: To generate the version 2.0 CWItem message, enter GENERIC_2 in the Item XML Message Format (H38) system control value. |
|
|||
vendor_nbr |
numeric |
7.0 |
Value defined in the Vendor # field (DHFYNB) in the CWDirect Vendor SKU file. |
vendor_product_nbr |
alpha |
20 |
Value defined in the Item field (DHO6CD) in the CWDirect Vendor SKU file. |
vendor_price |
numeric |
11.4 |
Value defined in the Price field (DHSLPR) in the CWDirect Vendor SKU file. |
vendor_uom |
alpha |
3 |
Value defined in the UOM field (DHCDCD) in the CWDirect Vendor SKU file. |
|
|||
upc_type |
alpha |
3 |
Value defined in the UPC type field (S0YLSY) in the CWDirect Item UPC file. |
upc_code |
numeric |
14.0 |
Value defined in the UPC field (S0MONR) in the CWDirect Item UPC 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. |
Generic WMS Item Message: Sample XML
A sample of the Generic WMS Item XML Message (CWItem) is presented below.
- <Message source="CWI" target="WMS" type="CWItem">
- <Items>
<Item type="WMS" message_type="IT" company="555" file_trans_nbr="000000061" itm_number="2004SKU1" allow_skus="Y" drop_ship="N" non-inventory="N" serial_tracking="N" standard_cost="5" allow_pct_disc="Y" case_piece="" oversize_flag="N" description="2004SKU1 ITEM DESCRIPTION" royalty="N" last_change_date="20040813" vendor_nbr="202" updated_by="KBOTTGER" created_by="KBOTTGER" activity_code="C" wms_control_nbr="171" company_designator="555" program_id="IFR0062" date_created="20040813" time_created="0103628" />
- <SKUs>
<SKU code="RED WMNS LRGE" last_purchase_cost="2.2200" description="RED WMNS LRGE SKU DESCRIPTION" out_of_stock="N" receipt_date="20040616" retail_ref_nbr="123456789012345" short_sku="1760" date_of_first_order="20040519" date_of_last_order="20040812" sku_open_qty="30" sku_average_cost=".0049" fifo_cost="5" standard_cost="5.2500" suppress_bo_card="N" returnable="N" sku_last_download_qty="10006" sku_orig_retail_prc="5" sku_last_change_date="20040813" sku_create_date="20040202" sku_warehouse="204" sku_location="2040101" sku_seo_code="RED" sku_seo_desc="MAROON" sku_sew_code="WMNS" sku_sew_desc="WOMANS" sku_set_code="LRGE" sku_set_desc="LARGE" sku_zone_reservation="" />
- <PKMSFlds>
<PKMS pkms_season="" pkms_style="12345678" pkms_style_suffix="9012345" pkms_size_range_code="" />
</PKMSFlds>
</SKUs>
</Items>
</Message>
Generic WMS Item Notes XML Message (CWItemNotes)
This message is transmitted to a warehouse management system when you create or change item or SKU customer service comments or product comments in CWDirect and the Item Notes XML Message Format (H39) system control value is set to GENERIC.
For more information: See:
• Generic WMS Item Notes 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. CWItemNotes indicates the message contains item/SKU notes. |
|
|||
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. IN indicates the message contains item/SKU updates. |
company |
numeric |
3.0 |
Value defined in the Company field in the CWDirect Item or SKU Comments file. |
file_trans_nbr |
numeric |
9.0 |
The next number available from the Item File Transfer # number assignment value. |
itm_number |
alpha |
12 |
Value defined in the Item field in the CWDirect Item or SKU Comments file. |
sku_code |
alpha |
14 |
Value defined in the SKU field in the CWDirect Item or SKU Comments file. |
|
|||
item_class |
alpha |
3 |
The item class code associated with the item. From the Item class field in the Item Class Template file. |
template |
alpha |
2 |
The template defined for the item class. From the Template field in the Item Class Template file. |
ict_seq |
numeric |
3.0 |
The item class template sequence number. From the Seq # field in the Item Class Template file. |
iif_seq |
numeric |
3.0 |
The item or SKU comments sequence number. From the Seq # field in the Item or SKU Comments file. |
item_info |
alpha |
50 |
The item or SKU note. From the Comment field in the Item or SKU Comments file. |
company_designator |
alpha |
3 |
The value defined in the PkMS Company Designator (G61) system control value. |
date_created |
numeric |
8 |
The date the item/SKU note was created or updated, in YYYYMMDD format. |
time_created |
numeric |
8 |
The time the item/SKU note was created or updated, in HHMMSS format. |
Generic WMS Item Notes Message: Sample XML
A sample of the Generic WMS Item Notes XML Message (CWItemNotes) is presented below.
- <Message source="CWI" target="WMS" type="CWItemNotes">
- <ItemNotes>
- <Notes type="WMS" message_type="IN" company="555" file_trans_nbr="000000070" item_number="2004SKU1" sku_code="RED WMNS LRGE">
<Note item_class="PNT" template="CS" ict_seq="1" iif_seq="1" item_info="features information" company_designator="555" date_created="20040816" time_created="0112450" />
<Note item_class="PNT" template="CS" ict_seq="1" iif_seq="3" item_info="warranty information" company_designator="555" date_created="20040816" time_created="0112450" />
<Note item_class="PNT" template="CS" ict_seq="1" iif_seq="5" item_info="accessories" company_designator="555" date_created="20040816" time_created="0112450" />
<Note item_class="PNT" template="CS" ict_seq="1" iif_seq="9" item_info="cautions for item" company_designator="555" date_created="20040816" time_created="0112450" />
</Notes>
</ItemNotes>
</Message>
Chapter 77: WMS Background Jobs (WPBJ) | Contents | SCVs | Search | Glossary | Reports | XML | Index | Chapter 79: Sending Vendor Information to a Warehouse Management System |
WH13_07 CWDirect 18.0 August 2015 OTN