Chapter 111: Generic Item Download API

Chapter 111: Generic Item Download API

Purpose: CWDirect allows you to capture item and SKU information to download to another system, such as a retail store or warehouse management system.

Item and SKU download information flow: This flowchart explains how item and SKU information is downloaded from CWDirect.

In this chapter:

• Item/SKU Download Process

• Identifying Item Download Triggers

• When are Item Download Triggers Created?

• Item/SKU Download Processing

• Item Outbound Trigger Activities

• Item Outbound Trigger Rules

• Item Trigger Cleanup

• Processing Item Delete Triggers

• Item Outbound XML Inclusion

• CWDirect Setup for the Generic Item Download

• System Control Value

• Menu Options

• Periodic Functions

• Item Download XML Message (CWITEMOUT)

• Item Download Message: Sample XML

Item/SKU Download Process

The system creates item download triggers in the IL Outbound Trigger file when an item or SKU is created, updated, or deleted. The Item Outbound job in the Working with Integration Layer Processes (IJCT) menu option monitors the IL Outbound file for item download triggers to process and generates an Item Download XML Message (CWITEMOUT) to send to the remote system.

Identifying Item Download Triggers

You can view all download triggers in the IL Outbound Trigger file at the Work with Outbound Interface Transactions Screen.

Each trigger in the IL Outbound Trigger file contains a:

• File code: indicating the type of information to download and which IL process job processes the trigger. For item download triggers, the File code is SKU, regardless of whether the activity was at the item level or SKU level.

• Key: indicating the specific record to download. For item download triggers, the Key identifies the specific company, item, and SKU associated with the item download trigger. The SKU code is included only if the item is a SKU’ed item. For example the Key 555AB100112 BLUE GRLS SMLL indicates the item and SKU information is located in company 555 for item number AB100112 and SKU code BLUE GRLS SMLL.

• Capture type: indicating the type of activity performed against the record:

• A = the item/SKU was created.

• C = the item/SKU was maintained. Note: The system removes any duplicate change triggers; see Item Trigger Cleanup.

• D = the item/SKU was deleted. Note: The system processes delete triggers immediately; see Processing Item Delete Triggers.

When are Item Download Triggers Created?

The Create Generic Item Download Trigger Records (I15) system control value controls whether the system creates item download triggers in the IL Outbound Trigger file.

• If this system control value is set to Y, certain actions in CWDirect triggers the system to create item download triggers in the IL Outbound Trigger file with a File code of SKU. The IL Outbound Trigger file acts as a “to do” list for the item/SKU information that requires download.

• If this system control value is set to N, the system does not create item download triggers in the IL Outbound Trigger file.

Generating download triggers for all items/SKUs: You can also create an item download trigger for each item/SKU in your company using the Generating Outbound Interface Triggers (GOIT) menu option. Run this process to initially send items/SKUs to the remote system.

When you generate triggers for all items/SKUs, the system generates item download triggers alphabetically by item number and SKU code in Kit type sequence. This way all items that are components of any type of kit are processed before the main kit item is processed.

1. The system generates triggers alphabetically by item number and SKU code for all items/SKUs whose Kit type is blank.

2. The system generates triggers alphabetically by item number and SKU code for all items/SKUs whose Kit type is C (continuity kit).

3. The system generates triggers alphabetically by item number and SKU code for all items/SKUs whose Kit type is F (finished good kit).

4. The system generates triggers alphabetically by item number and SKU code for all items/SKUs whose Kit type is S (set kit).

5. The system generates triggers alphabetically by item number and SKU code for all items/SKUs whose Kit type is V (variable set kit).

Note: When you create new items for which you wish to generate item download triggers, make sure you create the component items first before creating the main kit item. This way the component items are processed before the main kit item is processed.

Example: The system generates item download triggers in the following sequence, based on the item’s Kit type.

Item number	Kit type	Sequence
204I	blank	1
204J	blank	2
204K	blank	3
204A	C	4
204H	C	5
204C	F	6
204F	F	7
204B	S	8
204G	S	9
204D	V	10
204E	V	11

Item/SKU Download Processing

To generate an item download message, the system:

1. During certain activities, evaluates the trigger rules defined for the Item Outbound job to determine if the item download trigger is created. Item Outbound trigger rules define the criteria the item/SKU must meet in order for the system to create an item download trigger. See Item Outbound Trigger Rules.

2. Creates item download triggers, based on CWDirect activities that create, update, or delete items and SKUs. See Item Outbound Trigger Activities for a list of the activities that create item download triggers.

3. When active, the trigger monitor defined for the Item Outbound job looks for unprocessed item download triggers to process at defined intervals, based on the value defined in the Outbound delay time field.

The Item Outbound trigger monitor:

• looks for item download triggers with the File code SKU and a status of ready (R).

• removes duplicate item download triggers. See Item Trigger Cleanup.

• sends each item download trigger to the message builder defined for the Item Outbound job.

Note: The system processes item download triggers with a delete (D) Capture type immediately, regardless of whether the Item Outbound job is active or inactive; see Processing Item Delete Triggers.

4. For each item download trigger, the Item Outbound job creates a CWMessageBuilder xml message and places the message in the outbound queue defined for the Item Outbound configuration. The CWMessageBuilder message contains the item download trigger key and CWDirect database access information required by the Item Outbound message builder to generate an item download message.

5. The Item Outbound message builder monitors the Item Outbound configuration outbound queue for CWMessageBuilder messages to read and process.

For each CWMessageBuilder message, the Item Outbound message builder:

• looks at the User ID and Password defined for the CWMessageBuilder message to determine the iSeries user ID and password used to access the CWDirect database during XML message generation. If the User ID or Password is invalid, the message builder does not generate an item download message.

• determines which item/SKU to download, based on the item download trigger Key included in the CWMessageBuilder message. The Key field for item download triggers consists of company + item number + SKU code. The SKU code is included only if the item is a SKU’ed item. For example, the Key 555AB100112 BLUE GRLS SMLL indicates the item and SKU information is located in company 555 for item number AB100112 and SKU code BLUE GRLS SMLL.

• determines which elements to include in the item download message, based on XML inclusion rules. See Item Outbound XML Inclusion.

• sends the generated item download message to the queues defined for the Item Outbound job that are active (the Enabled field is set to Y). See Outbound Interface Queues.

Item Outbound Trigger Activities

This table indicates:

• which CWDirect activities create an item download trigger.

• which file the item download trigger references.

• the type of activity performed against the item/SKU:

• A = an item or SKU was created.

• C = an item or SKU was maintained.

• D = an item or SKU was deleted.

For SKU’ed items, the system creates a separate item download trigger for each SKU. For example, if you update a SKU’ed item at the item level, the system generates a separate item download message for each SKU.

For non-SKU’ed items, the system displays the SKU element and its attributes in the item download message without the SKU_Code attribute.

Additionally, the system creates an item download trigger if the transaction updates any of the fields associated with item/SKU information, regardless of whether the updated field is included in the item download message. However, the system creates an item download trigger when you update an item warehouse only if the transaction updates an item warehouse field that is included in the item download message.

Note: Each activity may create duplicate triggers; however, the Item Trigger Cleanup will remove any duplicates before generating an Item Download XML Message (CWITEMOUT).

You can review the item download triggers in the IL Outbound Trigger file at the Work with Outbound Interface Transactions Screen.

Note: The system creates an item download trigger for the activities listed below only if the item/SKU meets the criteria defined in the Item Outbound trigger rules; see Item Outbound Trigger Rules.

Activity	Menu Option	Referenced file	Trigger Type
Maintain an item/SKU/offer (if the Create item out triggers flag is selected)	CPIM	Item SKU SKU Offer	C
Copy SKU/Offer records (if the Create item out triggers flag is selected) Note: The system creates a trigger for each SKU of an item, even if you are only copying an offer to one SKU.	CSKO	Item Offer SKU Offer	C
Create SKUs for an item using the SKU Generator Note: The system creates a separate trigger for each SKU generated.	ESKG	SKU	A
Generate item download triggers	GOIT	IL Outbound Trigger	C
Update SKU ABC/velocity codes Note: The system creates a separate trigger for each SKU whose ABC/velocity code has been updated.	MABC	SKU	C
Create an item warehouse by copying an existing warehouse (if the Create item out triggers flag is selected). Note: The system creates a separate trigger for each item warehouse created.	MCIW	Item Warehouse	C
Copy SKU Offer information (if the Create item out triggers flag is selected) Note: The system creates a trigger for each item/SKU assigned to the new offer.	MCSO	Item Offer SKU Offer	C
Delete SKUs for an item Note: The system creates a separate trigger for each SKU deleted.	MDLT	SKU	D
Submit deferred SKU offer updates (if the Create item out triggers flag is selected)	MDSS	SKU Offer	C
Maintain item offers	MIOF	Item Offer Item	C
Create item/SKU offer (if the Create item out triggers flag is selected)	MISO	Item Offer SKU Offer	C
Create an item Note: If you create a SKU’ed item, the system does not create a trigger until you create a SKU.	MITM	Item	A
Create a SKU Note: The system also creates a change trigger when you create a SKU.	MITM	SKU	A
Delete an item	MITM	Item	D
Delete a SKU	MITM	SKU	D
Change an item	MITM	Item	C
Change a SKU	MITM	SKU	C
Create or update item information (at the item level or SKU level) Note: If you update information at the item level, the system creates a separate trigger for each SKU.	MITM	Item Information	C
Create or update item comments	MITM	SKU Comment	C
Create, change, or delete an item coordinate Note: The system creates a separate trigger for each SKU.	MITM	Item Coordinate	C
Define an e-commerce item image Note: The system creates a separate trigger for each SKU.	MITM	E-Commerce Item Image	C
Create, change, or delete an e-commerce upsell/cross-sell Note: The system creates a separate trigger for each SKU.	MITM	E-Commerce Up/Cross-Sell	C
Create or delete an item restriction by country or state Note: The system creates a separate trigger for each SKU.	MITM	Item Restr by Country/State	C
Define or delete an e-commerce item category Note: The system creates a separate trigger for each SKU.	MITM	E-Commerce Category	C
Change or delete a SKU user field	MITM	SKU User Field	C
Change or delete an item user field Note: The system creates a separate trigger for each SKU.	MITM	Item User Field	C
Change or delete an item warehouse user field	MITM	Item Warehouse	C
Assign, change, or delete an item UPC code	MITM	Item UPC	C
Create, change, or delete an item offer	MITM	Item Offer	C
Create, change, or delete an item offer price	MITM	Item Price	C
Create, change, or delete an item offer page letter	MITM	Page Letter Alias	C
Create, change, or delete an item offer alias	MITM	Page Letter Alias	C
Create, change, or delete an item offer accompanying item	MITM	Accompanying Item	C
Create, change, or delete an item offer user defined field	MITM	Item Offer User Field	C
Create, change, or delete a SKU offer	MITM	SKU Offer	C
Create, change, or delete a SKU offer price	MITM	SKU Price	C
Create, change, or delete a SKU offer page	MITM	SKU Offer Page	C
Create, change, or delete a SKU offer accompanying item	MITM	Accompanying Item	C
Change or delete continuity information	MITM WCNT	Continuity Header Continuity Detail	C
Change or delete a finished good component, make-up a finished good, or update the cost of a finished good (periodic function PHR0049)	MITM WFGD	Kit Detail	C
Work with or change item attributes or values	MITM WIAT	Item Attribute	C
Create or delete a keyword Note: The system creates a separate trigger for each SKU.	MITM WKEY	Keyword	C
Add, change, or delete a set or set component	MITM WSET	Set Set Detail	C
Create, change, or delete a special source price Note: The system creates a separate trigger for each SKU.	MITM WSRC	Special Pricing by Source	C
Create, change, or delete a vendor item, vendor item price break, vendor item additional charges, vendor item notes; update the standard cost	MITM WVNI	Vendor Item	C
Create, change, or delete a variable set group; add or delete a variable set component; create or delete a variable set	MITM WVST	Variable Set Group Variable Set Detail Variable Set	C
Create, change, or delete an item warehouse Note: The system creates an item download trigger only if the transaction updates an item warehouse field that is included in the item download message.	MITM WWHS	Item Warehouse	C
Initialize offer (if the Create item out triggers flag is selected)	MOFI	Item Offer SKU Offer	C
Purge SKUs Note: The system creates a separate trigger for each SKU purged.	MPSK	SKU	D
Reset SKU Open Order Quantity	MRSO	SKU file	C
Update standard cost	MSCC	SKU file	C
Update SKU offer prices (if the Create item out triggers flag is selected)	MUSK	SKU Offer	C
Update SKU offers (if the Create item out triggers flag is selected)	MUSO	Item Offer Item Price SKU Offer SKU Price	A, C
Update item prices or SKU prices (if the Create item out triggers flag is selected)	MUSP	Item Price SKU Price	C
Update special handling information for an item or SKU in an offer (if the Create item out triggers flag is selected)	MUSP	Item Offer SKU Offer	C
Update status for an item or SKU (if the Create item out triggers flag is selected)	MUSP	Item SKU	C
Receive inventory Note: The system creates a separate trigger for each SKU received.	PORC	Item Warehouse	C
Create, update, or delete an item, SKU, item offer, SKU offer, item price, SKU price, vendor item, coordinate item, UPC code, or SKU cross reference (if the Create item out triggers flag is selected)	RIIU	Item SKU Item Offer SKU Offer Item Price SKU Price Item UPC Vendor Item Item Coordinate SKU Cross Reference	A, C, D
Resequence the SKU collating sequence number Note: The system creates a separate trigger for each SKU that has been resequenced.	RSCS	SKU	C
Update a harmonize code Note: The system creates a separate trigger for each SKU.	UPHC	Item	C
Work with coordinates by offer	WCIO	Item Coordinate	C
Create, change, or delete a freight exempt item Note: The system creates a separate trigger for each SKU.	WFEI	Freight Exemption	C
Submit an item/SKU offer upload (if the Create item out triggers flag is selected)	WISU	Item Offer SKU Offer	C
Create, change, or delete an item tax exemption Note: The system creates a separate trigger for each SKU.	WITX	Item Tax Exempt	C
Update item warehouse values Note: The system creates a separate trigger for each item warehouse updated.	WIWV	Item Warehouse	C
Update effective dates for item or SKU prices to be consistent with the changed start date of an offer (if the Create item out triggers flag is selected)	WOFR	Item Price SKU Price	C
Create, change, or delete a special format detail or response associated with the custom special handling code that is assigned to an item offer.	WSHF	Special Format Details	C
Submit item offer overrides by class (if the Create item out triggers flag is selected)	WSOI	Item Offer	C
Process a finished good work order	WWOR	Work Order Header Work Order Detail	C

Item Outbound Trigger Rules

Item Outbound trigger rules define the criteria an item/SKU must meet in order for the system to create an item download trigger.

• if the item/SKU meets the Item Outbound trigger rule criteria, the system creates an item download trigger.

• if the item/SKU does not meet the Item Outbound trigger rule criteria, the system does not create an item download trigger.

You can define Item Outbound trigger rules for fields in the Item file and SKU file that are included in the Item Download XML Message (CWITEMOUT). If you define more than one criterion, the item/SKU must meet all of the criteria defined in order to generate a trigger.

Example: You define the following trigger rules for the Item Outbound job:

Item Outbound Trigger Rules
Item file criteria	SKU file criteria	Results
The Company field must equal 27 or 555.	no criteria defined	The system creates an item download trigger only if the item/SKU being created, maintained, or deleted is in company 27 or 555.
The Company field must equal 27 or 555. The Allow SKUs field must equal ’Y’.	The Warehouse field must equal 20.	The system generates an item download trigger only if the item/SKU being created, updated, or deleted is in company 27 or company 555 and the item is SKU’ed and the SKU is located in warehouse 20. If the item/SKU does not meet all of the criteria defined, a trigger is not created.
no criteria defined	The Warehouse field must equal 20.	The system generates an item download trigger only if the item/SKU is located in warehouse 20.

You can define trigger rules for the Item Outbound job at the Outbound Interface Trigger Rules Screen; see Defining Outbound Interface Trigger Rules.

Note: When you create trigger rules, the system does not validate that your entry is a valid value for the field or is within the maximum field positions. Refer to your Field/File Listing to review field attributes for the Item file and SKU file.

Item Trigger Cleanup

Before processing the item download triggers, the Item Outbound job looks for duplicate unprocessed item download triggers.

Duplicate item download triggers exist if more than one trigger has the same:

• File code SKU

• Capture type (C (change) or A (add))

• Key (company + item number + SKU code)

If duplicate item download triggers exist, the system removes the duplicates, leaving only the most recent item download trigger for that capture type.

Example: The following change item download triggers exist in the IL Outbound file:

File	Type	Status	Key	Results
SKU	C	R	555ABC RED GRLS SMLL	The system deletes 2 of these item download triggers, leaving only one change trigger to process.
SKU	C	R	555ABC RED GRLS SMLL
SKU	C	R	555ABC RED GRLS SMLL

Note: If both an add (Capture type A) and a change (Capture type C) item download trigger exists for the same Key, the system generates an Item Download XML Message (CWITEMOUT) for both triggers.

Processing Item Delete Triggers

The system processes item download triggers in the IL Outbound Trigger file with a delete (D) Capture type immediately, regardless of whether the Item Outbound job is active or inactive.

When you delete the item or SKU, the system:

• generates a delete item download trigger.

• generates a CWMessageBuilder xml message containing the trigger key and database access information and places this message in the Item Outbound configuration outbound queue. The system creates the CWMessageBuilder xml message with an expiry time that is 2 times the outbound delay time defined for the Item Outbound process.

• waits 2 times the outbound delay time defined for the Item Outbound process on the interactive screen before processing the delete to give the Item Outbound message builder time to read and process the CWMessageBuilder xml message.

If the Item Outbound message builder:

• reads the CWMessageBuilder xml message within the expiry time, the job generates a delete item download message and updates the associated item download trigger Status field to X (processed). The item download message for delete transactions contains all elements since an item can be identified using fields other than Item number and SKU code.

• does not read the CWMessageBuilder xml message within the expiry time, the job removes the CWMessageBuilder job from the Item Outbound configuration outbound queue, does not generate a delete item download message, and updates the associated item download trigger Status field to E (error), indicating the delete transaction was processed and an item download message was not generated.

If one or more unprocessed item download triggers exist in the IL Outbound Trigger file for the same Key, the system:

• if one of the matching item download triggers is an add (A) Capture type: does not create the delete item download trigger and removes any other matching item download triggers (add and change). Since the point of sale system never received the add trigger, you do not want to send a delete trigger or any other triggers.

Note: However, if an Original processed date and time exist for the add item download trigger (indicating the trigger was previously downloaded and then reset to reprocess again), the system generates an item download message for the delete item download trigger and removes any other matching item download triggers (add and change). Since the point of sale system previously received the add item download trigger, you want to send a delete notification to the system.

• if the matching item download trigger is a change (C) Capture type: generates an item download message for the delete item download trigger and removes any other matching change item download triggers. Since the point of sale system is receiving a delete trigger, you do not need to send any change triggers.

Example 1: When the system processes the delete item download trigger, an unprocessed add and change item download trigger exists in the IL Outbound file:

SKU Key	Type	Status	Results
555AB101	A	R	Since the item/SKU has never been downloaded, the system does not create the delete item download trigger and instead removes the add and change triggers from the IL Outbound Trigger file.
555AB101	C	R

Example 2: When the system processes the delete item download trigger, a change item download trigger exists that has not been processed:

SKU Key	Type	Status	Results
555AB101	C	R	The system immediately generates an item download message for the delete item download trigger. The system removes the change item download trigger from the IL Outbound Trigger file (don’t bother sending the change since the item/SKU has now been deleted).

You can review item download triggers at the Work with Outbound Interface Transactions Screen.

Item Outbound XML Inclusion

For each item download trigger, the Item Outbound message builder determines which elements to include in the item download message, based on XML inclusion rules.

You can define Item Outbound XML inclusion rules at the Outbound Interface XML Inclusion Screen.

XML inclusion defines which elements to include in the item download message.

• If the element is included, that element and its parents are included in the generated item download XML message.

• If the element is excluded, that element and its children are excluded from the generated item download message.

This table indicates which elements in the item download message are included, based on which elements you flag to include or exclude.

Include element in XML message?	Element
Y = Include Item N = Exclude Item and all of its children; the system sends a message with only the Message element and its attributes	Item
Y = Include ItemOffer and its parent Item N = Exclude ItemOffer and its children ItemPrice, PageLetterAlias, IOFAccompanyingItem, IOFUserField, IOFSpecialHandlingDetail and IOFSpecialHandlingResponse		ItemOffer
Y = Include ItemPrice and its parents, ItemOffer and Item N = Exclude ItemPrice			ItemPrice
Y = Include PageLetterAlias and its parents ItemOffer and Item N = Exclude PageLetterAlias			PageLetterAlias
Y = Include IOFAccompanyingItem and its parents ItemOffer and Item N = Exclude IOFAccompanyingItem			IOFAccompanyingItem
Y = Include IOFUserField and its parents ItemOffer and Item N = Exclude IOFUserField			IOFUserField
Y = Include IOFSpecialHandlingDetail and its parents ItemOffer and Item N = Exclude IOFSpecialHandlingDetail and its child IOFSpecialHandlingResponse			IOFSpecialHandlingDetail
Y = Include IOFSpecialHandlingResponse and its parents IOFSpecialHandlingDetail, ItemOffer, and Item N = Exclude IOFSpecialHandlingResponse				IOFSpecialHandlingResponse
Y = Include ItemInformation and its parent Item N = Exclude ItemInformation and its child ItemInformationDetail		ItemInformation
Y = Include ItemInformationDetail and its parents ItemInformation and Item N = Exclude ItemInformationDetail			ItemInformationDetail
Y = Include ItemComment and its parent Item N = Exclude ItemComment		ItemComment
Y = Include ItemAttribute and its parent Item N = Exclude ItemAttribute		ItemAttribute
Y = Include SourcePrice and its parent Item N = Exclude SourcePrice		SourcePrice
Y = Include Coordinate and its parent Item N = Exclude Coordinate		Coordinate
Y = Include Keyword and its parent Item N = Exclude Keyword		Keyword
Y = Include Image and its parent Item N = Exclude Image		Image
Y = Include Upsell and its parent Item N = Exclude Upsell		Upsell
Y = Include Restriction and its parent Item N = Exclude Restriction		Restriction
Y = Include EcommCategory and its parent Item N = Exclude EcommCategory		EcommCategory
Y = Include ITMUserField and its parent Item N = Exclude ITMUserField		ITMUserField
Y = Include TaxExemption and its parent Item N = Exclude TaxExemption		TaxExemption
Y = Include FreightExemption and its parent Item N = Exclude FreightExemption		FreightExemption
Y = Include SKU and its parent Item N = Exclude SKU and all of its children VendorItem, SKUItemInformation, ItemWarehouse, ContinuityItems, FinishedGood, SetItem, VariableSet, SKUComment, SKUAttribute, UPC, SKUUserField		SKU
Y = Include VendorItem and its parents SKU and Item N = Exclude VendorItem and its children VITPriceBreak, VITAdditionalCharge, VITNote, and VITUserField			VendorItem
Y = Include VITPriceBreak and its parents VendorItem, SKU, and Item N = Exclude VITPriceBreak				VITPriceBreak
Y = Include VITAdditionalCharge and its parents VendorItem, SKU, and Item N = Exclude VITAdditionalCharge				VITAdditionalCharges
Y = Include VITNote and its parents VendorItem, SKU, and Item N = Exclude VITNote				VITNote
Y = Include VITUserField and its parents VendorItem, SKU, and Item N = Exclude VITUserField				VITUserField
Y = Include SKUOffer and its parents SKU and Item N = Exclude SKUOffer and its children SKUPrice, SKUOfferPage, SKOAccompanyingItem, SKOUserField, and SKOSpecialHandlingDetail			SKUOffer
Y = Include SKUPrice and its parents SKUOffer, SKU and Item N = Exclude SKUOfferPage				SKUPrice
Y = Include SKUOfferPage and its parents SKUOffer, SKU, and Item N = Exclude SKUOfferPage				SKUOfferPage
Y = Include SKOAccompanyingItem and its parents SKUOffer, SKU, and Item N = Exclude SKOAccompanyingItem				SKOAccompanyingItem
Y = Include SKOUserField and its parents SKUOffer, SKU, and Item N = Exclude SKOUserField				SKOUserField
Y = Include SKOSpecialHandlingDetail and its parents SKUOffer, SKU, and Item N = Exclude SKOSpecialHandlingDetail and its child SKOSpecialHandlingResponse				SKOSpecialHandlingDetail
Y = Include SKOSpecialHandlingResponse and its parents SKOSpecialHandlingDetail, SKUOffer, SKU, and Item N = Exclude SKOSpecialHandlingResponse					SKOSpecialHandlingResponse
Y = Include SKUItemInformation and its parents SKU and Item N = Exclude SKUItemInformation and its child SKUItemInformationDetail			SKUItemInformation
Y = Include SKUItemInformationDetail and its parents SKUItemInformation, SKU, and Item N = Exclude SKUItemInformationDetail				SKUItemInformationDetail
Y = Include ItemWarehouse and its parents SKU and Item N = Exclude ItemWarehouse and its child ITWUserField			ItemWarehouse
Y = Include ITWUserField and its parents ItemWarehouse, SKU, and Item N = Exclude ITWUserField				ITWUserField
Y = Include ContinuityItems and its parents SKU and Item N = Exclude ContinuityItems and its child ContinuityItem			ContinuityItems
Y = Include ContinuityItem and its parents ContinuityItems, SKU, and Item N = Exclude ContinuityItem				ContinuityItem
Y = Include FinishedGood and its parents SKU and Item N = Exclude FinishedGood			FinishedGood
Y = Include SetItem and its parents SKU and Item N = Exclude SetItem			SetItem
Y = Include VariableSet and its parents SKU and Item N = Exclude VariableSet and its children VariableSetGroup and VariableSetItem			VariableSet
Y = Include VariableSetGroup and its parents VariableSet, SKU, and Item N = Exclude VariableSetGroup and its child VariableSetItem				VariableSetGroup
Y = Include VariableSetItem and its parents VariableSetGroup, VariableSet, SKU, and Item N = Exclude VariableSetItem					VariableSetItem
Y = Include SKUComment and its parents SKU and Item N = Exclude SKUComment			SKUComment
Y = Include SKUAttribute and its parents SKU and Item N = Exclude SKUAttribute			SKUAttribute
Y = Include UPC and its parents SKU and Item N = Exclude UPC			UPC
Y = Include SKUUserField and its parents SKU and Item N = Exclude SKUUserField			SKUUserField
Y = Include SKUCrossReference and its parents SKU and Item N = Exclude SKUCrossReference			SKUCrossReference

CWDirect Setup for the Generic Item Download

Before you can generate item download messages, you must perform the necessary CWDirect setup and processing.

Information requiring setup includes:

• System Control Value

• Menu Options

• Periodic Functions

System Control Value

System Control Value	Description
Create Generic Item Download Trigger Records (I15)	Enter Y in this field to create triggers in the IL Outbound Trigger file for certain actions in CWDirect.
Outbound Interface Trigger File Purge Days (I14)	Enter the number of days to retain records in the IL Outbound Trigger file before purging them. Run the PURGIJT periodic function (program name ILR0026) to delete any records if: Last processed date is less than the current system date by the number of purge days and Status is X. Example: Today is 2/06, and you have set this value to 1. Any record whose Last processed date is 2/05 or earlier is purged.
Item Values (I91)	Use this umbrella system control value to specify whether certain fields are required when creating an item: • Require L/S Division with L/S Department (E85) • Require L/S Department (I92) • Require L/S Class (I93) • Require L/S Style (I94) • Require Item Class (F06)

Menu Options

Menu Option	Description
Generating Outbound Interface Triggers (GOIT)	Allows you to create an IL outbound trigger record for each item/SKU in your company. Run this process to initially send item/SKUs to the point of sale system.
Working with Outbound Interface Transactions (WOIT)	Allows you to review, delete, or resend IL outbound trigger records.
Working with Integration Layer Processes (IJCT)	When active, the Item Outbound job creates an Item Download XML Message (CWITEMOUT) for each record in the IL Outbound Trigger file. You can also define: • trigger rules; see Item Outbound Trigger Rules. • configuration options. • XML inclusion rules; see Item Outbound XML Inclusion. • the queues where the item download message are sent; see Work with Integration Layer Process Queues Screen.

Periodic Functions

Periodic Function	Description
Purge IJCT Download (program name ILR0026)	Run this periodic function to purge processed IL outbound triggers, based on the days defined in the Outbound Interface Trigger File Purge Days (I14) system control value: Last processed date is less than the current system date by the number of purge days and Status is X

Item Download XML Message (CWITEMOUT)

The item download message contains item and SKU information to send from CWDirect to another system, such as a retail store or warehouse management system.

Message formatting specific to item download:

• Delete transactions contain all elements (based on XML inclusion rules) since an item can be identified using fields other than Item number and SKU code.

• For non-SKU’ed items, the SKU element does not include the SKU_Code attribute. The following elements are not included for non-SKU’ed items:

• SKUOffer and its children, SKUPrice, SKUOfferPage, SKOAccompanyingItem, SKOUserField, SKOSpecialHandlingDetail, SKOSpecialHandlingResponse.

• SKUItemInformations and its children, SKUItemInformation, SKUItemInformationDetails, and SKUItemInformationDetail.

• SKUComments and its child, SKUComment.

• SKUAttributes and its child, SKUAttribute.

• SKUUserFields and its child, SKUUserField.

• If you exclude the element Item and all of its children (using the Item Outbound XML Inclusion rules), the system sends an item download message including the Message element and Items element with no attributes.

For more information: See:

• Generic Download Message Formatting for more information on how the system formats all download messages.

• XML Messages for a table that provides links to the DTD, schema, and a sample XML layout for each XML message.

• Item Download Message: Sample XML for a sample message.

Attribute Name	Type	Length	Comments
Message
source	alpha	25	Identifies the source of the XML message. RDC indicates the XML message is from CWDirect.
target	alpha	25	Identifies the target of the XML message. IDC indicates the XML message is sent to CWIntegrate.
type	alpha	25	Identifies the type of information in the XML message. CWITEMOUT indicates the message contains item download information.
Item Each item download message contains one Item element and one SKU element. For example, if you update a SKU’ed item, the system generates a separate item download message for each SKU. The Transaction_type attribute defines whether this message is an add, change, or delete of an item/SKU.
Transaction_type	alpha	1	Indicates the type of item/SKU information being downloaded. A (add): new item/SKU. C (change): changed item/SKU. D (delete): deleted item/SKU.
Company	numeric	3	The CWDirect company where the item is located. From the Company field in the Item file.
Item_Number	alpha	12	The item number whose information you are downloading. From the Item number field in the Item file.
Allow_SKUs	alpha	1	Indicates whether the item contains SKUs. Y = The item contains SKUs. N = The item does not contain SKUs. From the Allow SKUs field in the Item file.
Item_average_cost	numeric	11.4	The average cost of the item. From the Average cost field in the Item file. Available in XML version: 2.0 (version 8.5 of CWDirect)
ITM_Cubing_value	numeric	7.1	The cubic volume of the item, indicating the number of units of the item that can fit into a carton. From the Cub val field in the Item file.
Drop_ship_item	alpha	1	Indicates whether you ship the item from your warehouse, or have your vendor ship it to the customer directly. You can flag an item as drop ship at the item level or 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) = When a customer orders the item, you order the item from your vendor and the vendor ships it directly to your customer. If the item is flagged as drop ship, any SKUs for the item can be flagged as drop ship or non-drop ship. N or blank (non-drop ship) = You ship the item from your warehouse.If the item is flagged as non-drop ship, any SKUs for the item must also be flagged as non-drop ship. From the Drop ship field in the Item file.
FIFO_cost	numeric	11.4	The FIFO cost of the item. From the FIFO cost field in the Item file.
Item_height	numeric	3	The height measurement for the item. The Height, Length, and Width values are used to determine the cubic volume of the item. From the Height field in the Item file.
Kit_type	alpha	1	Defines the type of kit or set functionality for the item. C = Continuity program S = Set item F = Finished good item V = Variable set item From the Kit type field in the Item file.
Item_length	numeric	3	The length measurement for the item. The Height, Length, and Width values are used to determine the cubic volume of the item. From the Length field in the Item file.
Long_SKU_style	alpha	20	A user-defined field you can use to further identify the item. From the Long SKU style field in the Item file.
Long_SKU_vendor	alpha	7	A user-defined field you can use to further identify the item. From the Long SKU vendor field in the Item file.
Lot_Nbr_tracking	alpha	1	Indicates if you track the item using a lot number. Y = You track the item by lot number. N or blank = You do not track the item by lot number. From the Lot # tracking field in the Item file. Note: This field is not currently implemented.
Non-inventory	alpha	1	Indicates whether inventory levels are maintained for the item. Y = The item is a non-inventory item. N or blank = The item is a regular item whose inventory levels are maintained. From the Non-inventory field in the Item file.
Partial_units	alpha	1	From the Partial units field in the Item file.
Pieces_per_case	numeric	5	Determines the number of units that fit in a case. From the Pieces per case field in the Item file.
Selling_qty	numeric	5	The required order quantity (or multiple of) for the item. From the Selling qty field in the Item file.
Selling_weight	numeric	7.3	The selling weight of the item, used to calculate the freight charge on an item when the freight method on the order is Freight by weight or Freight by order weight. From the Selling weight field in the Item file.
Serial_Nbr_tracking	alpha	1	Determines whether each unit of the item has a specific serial number that should be tracked. Y = The item uses serial numbers. N or blank = The item does not use serial numbers. From the Serial # tracking field in the Item file.
Ship_alone	alpha	1	Indicates how to ship the item. S = The item must ship by itself, and each unit prints on its own pick slip. M = The item can ship with other items that also have an M in the Ship alone field. L = The item prints on the pick slip in location class sequence along with other items belonging to the same class. U = The item follows special shipping requirements, based on a user-defined code. From the Ship alone field in the Item file.
Ship_weight	numeric	7.3	The actual shipping weight of the item. From the Ship weight field in the Item file.
Standard_cost	numeric	11.4	The standard cost of the item. From the Standard cost field in the Item file.
User_field_1	alpha	10	A user-defined field for the item. From the User field 1 field in the Item file.
User_field_2	alpha	10	A user-defined field for the item. From the User field 2 field in the Item file.
User_field_3	alpha	10	A user-defined field for the item. From the User field 3 field in the Item file.
User_field_4	alpha	10	A user-defined field for the item. From the User field 4 field in the Item file.
Width	numeric	3	The width measurement for the item. The Height, Length, and Width values are used to determine the cubic volume of the item. From the Width field in the Item file.
Expiration_limit	numeric	5	From the Expiration limit field in the Item file.
FIFO_Tracking	alpha	1	Indicates if the item cost is tracked using FIFO costing. Y = The item cost is tracked using FIFO costing. N = The item cost is not tracked using FIFO costing. From the FIFO tracking field in the Item file.
ITM_Allow_Pct_ discount	alpha	1	Determines whether the item is eligible for a discount percent during order entry. Y = The item is eligible for a percent discount. N = The item is not eligible for a percent discount. From the Allow % discount? field in the Item file.
CasePiece	alpha	1	From the C/P field in the Item file.
ITM_Oversize_flag	alpha	1	Determines whether the item is considered an oversized item. Y = The item is oversized. N or blank = The item is not oversized. From the Oversize field in the Item file.
ITM_Description	alpha	40	A description of the item. From the Description field in the Item file.
ITM_Required_truck_item	alpha	1	Indicates if the item is a required truck item (when the item is ordered, the system uses the truck ship via as an override on the order line). Y = The item is a required truck item. N or blank = The item is not a required truck item. From the Required truck item field in the Item file.
ITM_Second_ Language_Desc	alpha	40	The second language description defined for the item. From the Second language desc field in the Item file.
ITM_Exclude_From_Flex_Pay	alpha	1	Determines whether the item is excluded from deferred and installment payment plans. Y = Exclude the item from deferred and installment payment plans. N or blank = Do not exclude the item from deferred and installment payment plans. From the Exclude from flex pay field in the Item file.
ITM_Royalty	alpha	1	Indicates whether sales of the item require royalty payments to an author or owner. Y = This is a royalty item. N = This is not a royalty item. From the Royalty field in the Item file.
ITM_Membership	alpha	1	Indicates the item represents a membership program, which you can use to generate periodic orders to a customer. Y = This is a membership item. You should set the Non-inventory field for a membership item to Y. N or blank = This is not a membership item. From the Membership field in the Item file.
ITM_Generic_ Ecommerce	alpha	20	From the Generic ecommerce field in the Item file.
ITM_Last_Ecomm_ Info_Chg	numeric	7	The date the item was last changed for e-commerce. From the Last ecomm info chg field in the Item file.
ITM_Qty_Threshold	numeric	9	Indicates when to trigger an automatic download of item availability information to the E-Commerce Staging Library; from there, the information is available to the web storefront. From the Qty threshold field in the Item file.
ITM_Create_Date	numeric	7	The date the item was created. From the Create date field in the Item file.
ITM_Retail_Style_ Nbr	alpha	20	A user-defined code used to identify the item. From the Retail style # field in the Item file.
Buyer	alpha	3	A code that represents a person who is authorized to make purchases for your company. From the Buyer field in the Item file.
Buyer_Name	alpha	30	The name of the buyer. From the Name field in the Item file.
CTN_ID_Nbr	numeric	2	The type of carton in which the item must be shipped. From the CTN ID # field in the Item file.
GLA_Account_Nbr	numeric	8	The general ledger account number assigned to the item. From the Account # field in the Item file.
Inventory_value_GLNbr	numeric	8	The general ledger account number to use for inventory transactions. From the Inventory value G/L# field in the Item file.
HAZ_Code	numeric	2	A code used to categorize the item as a hazardous material that requires special storage and handling. From the Code field in the Item file.
HAZ_Description	alpha	40	A description of the hazard code. From the Description field in the Hazard file.
HAZ_Class	alpha	15	A class of hazardous materials such as flammable or radioactive. From the Class field in the Hazard file.
HAZ_Label_type	alpha	15	The type of label that should be produced for the type of hazardous material. The label identifies the hazardous item as flammable or radioactive to warehouse personnel or shippers. From the Label type field in the Hazard file.
Item_class	alpha	3	A code that identifies a group of items. From the Item class field in the Item file.
ICL_Description	alpha	30	A description of the item class. From the Item class description field in the Item Class file.
ICL_Commission_ Pct	numeric	5.2	A percentage used to calculate commissions for sales representatives selling the class of items. From the Comm % field in the Item Class file.
ICL_Estimated_Frt	numeric	7.2	Your "best guess" on the vendor’s freight charges for items defined in the item class. This unit amount is added to an item’s cost to represent the estimated freight charges. From the Estimated frt field in the Item Class file.
ICL_Estimated_Frt_ Pct	numeric	5.2	Your "best guess" on the vendor’s freight charges for items defined in the item class. This percentage amount is added to an item’s cost to represent the estimated freight charges. From the Estimated frt % field in the Item Class file.
ICL_Desired_GM_ Pct	numeric	5.2	The percentage margin % of the item’s price that should exceed the cost of the item, so that the selling price of the item results in a profitable outcome. From the Desired G/M % field in the Item Class file.
ICL_VAT_Exempt	alpha	1	Indicates whether the item class is exempt from VAT. Y = The item class is exempt from VAT. N or blank= The item class is not exempt from VAT. From the VAT exempt? field in the Item Class file.
ICL_Hidden_Tax_ Amount	numeric	11.2	The amount to include in the Hidden tax field for an item class subject to VAT. On orders subject to VAT and tax-inclusive pricing, tax does not accumulate in the Tax bucket for the order; instead, you charge a tax-inclusive price for items, and the tax is "hidden" on the order detail line. From the Hidden tax amount field in the Item Class file.
ICL_Qty_Threshold	numeric	5	Indicates when to trigger an automatic download of item availability information to the E-Commerce Staging Library for the item class; from there, the information is available to the web storefront. From the Qty threshold field in the Item Class file.
ICL_Hidden_Tax_Pct	numeric	5.2	The percent to include in the Hidden tax field for an item class subject to VAT. On orders subject to VAT and tax-inclusive pricing, tax does not accumulate in the Tax bucket for the order; instead, you charge a tax-inclusive price for items, and the tax is "hidden" on the order detail line. From the Hidden tax % field in the Item Class file.
CRV_Code	numeric	3	A code used in forecasting for inventory projection and analysis reporting. The curve determines weekly projections of sales for items within the item class. From the CRV code field in the Item Class file.
ICL_GLA_Account_ Nbr	numeric	8	The general ledger number for posting sales for items in this item class. From the Account # field in the Item Class file.
Discount_GLA_ Account_Nbr	numeric	8	The general ledger number for posting discounts on sales for items in this item class. From the Discount GLA account # field in the Item Class file.
Return_GLA_ Account_Nbr	numeric	8	The general ledger number for posting returns on items in this item class. From the Return GLA account # field in the Item Class file.
Return_Discount_ GLA_Accou	numeric	8	The general ledger number for posting discounts on returns for items in this item class. From the Return discount GLA account # field in the Item Class file.
ICL_Cost_Good_ Sold_GL_Nbr	numeric	8	The general ledger number for posting item cost for sales. From the Cost good sold G/L # field in the Item Class file.
ICL_Cost_Good_ Rtn_GL_Nbr	numeric	8	The general ledger number for posting item cost for returns. From the Cost good Rtn G/L # field in the Item Class file.
Cycle	alpha	2	A code that identifies a physical inventory cycle. From the Cycle field in the Item file.
CYC_Days	numeric	5	The number of days between physical counts of items assigned to this cycle code. From the Days field in the Item Cycle file.
CYC_Description	alpha	30	A description of the item cycle. From the Description field in the Item Cycle file.
SKU_group	numeric	3	A code that represents a group of common characteristics of a SKUed item. From the SKU group field in the Item file.
SKU_group_ description	alpha	40	A description of a SKU group. From the Description field in the Item SKU Group file.
Item_status	alpha	1	A code that represents an item’s status, such as discontinued or active. From the STS field in the Item file.
Item_status_ description	alpha	30	A description of the item status. From the Description field in the Item Status file.
IST_Message_line_1	alpha	50	A message that displays in order entry and maintenance for items with this status code. From the IST message line 1 field in the Item Status file.
IST_Message_line_2	alpha	50	A message that displays in order entry and maintenance for items with this status code. From the IST message line 2 field in the Item Status file.
IST_Return_ disposition	alpha	2	A code that identifies how the returned merchandise will be handled (whether the return updates inventory). From the IST return disposition field in the Item Status file.
LCL_Location_class	alpha	2	A code that represents a location type, such as caged area or carousel area. From the LCL location class field in the Item file.
LCL_Description	alpha	30	A description of the location class. From the Description field in the Location Class file.
LSD_Department	numeric	4	A code used to group items into long SKU departments for reporting purposes. From the Department field in the Item file.
LSD_Description	alpha	30	A description of the long SKU department. From the Description field in the Long SKU Department file.
LSD_Long_Sku_ Division	alpha	3	The division associated with the long SKU department. From the LSD long SKU division field in the Long SKU Department file.
Long_SKU_Div_ Description	alpha	30	A description of the long SKU division. From the Description field in the Long SKU Division file.
Long_SKU_class	numeric	4	A code used to group items into long SKU classes for reporting purposes. From the Class field in the Item file.
LSC_Description	alpha	30	A description of the long SKU class. From the Description field in the Long SKU Class file.
Unit_of_measure	alpha	3	The unit of measure defined for the item, for example each or case of 12. From the UOM field in the Item file.
UOM_Description	alpha	30	A description of the unit of measure. From the UOM description field in the Unit of Measure file.
UOM_Units	numeric	5	The number of units represented by the unit of measure, such as 12 units in a case. From the UOM units field in the Unit of Measure file.
Vendor_Nbr	numeric	7	A code that identifies the vendor, or supplier, of the item. From the Vendor # field in the Item file.
VIA_Ship_via_code	numeric	2	A code that represents the carrier to use when shipping the item. From the VIA ship via code field in the Item file.
VIA_Shipper_name	alpha	30	The name of the carrier used to ship the item. From the VIA shipper name field in the Ship Via file.
Warehouse	numeric	3	A code that represents the primary warehouse where you keep the item. From the Whs field in the Item file.
Warehouse_name	alpha	30	The name of the primary warehouse. From the Name field in the Warehouse file.
Manufacturer_ Vendor	numeric	7	The vendor who manufactured the item. From the Manufacturer vendor VND V field in the Item file.
ITM_ENT_Entity_ Number	numeric	3	The entity, or business unit, associated with the item. From the ITM ENT entity number field in the Item file.
ENT_Description	alpha	25	A description of the entity. From the ENT description field in the Entity file.
ITM_SEA_Season	alpha	3	The season associated with the item, such as spring. From the ITM SEA season field in the Item file.
SEA_description	alpha	30	A description of the season. From the Description field in the Season file.
SEA_Start_date	numeric	7	The date that indicates the beginning of the season. From the SEA start date field in the Season file.
SEA_End_date	numeric	7	The date that indicates the end of the season. From the SEA end date field in the Season file.
ITM_SVC_Type	alpha	1	A code that indicates the item is a stored value card, and whether the stored value card is a physical or virtual card. blank = The item is not a stored value card. P = The item is a physical stored value card. E = The item is a physical stored value card and, as soon as the stored value card is processed through billing, the system sends an email notification to the recipient card holder, notifying the customer that a stored value card has been purchased and is in the process of being delivered. R = The item is a stored value card that is activated and fulfilled by a gift card fulfillment system. When you generate a pick slip for a remote fulfillment stored value card, the system sends a remote fulfillment request message to the gift card system; once the gift card system activates and ships the card, the gift card system sends a remote fulfillment confirmation back to CWDirect. See Stored Value Card Remote Fulfillment for an overview. V = The item is a virtual (non-physical) stored value card. Available in XML version: 5.0 (version 10.5 of CWDirect).
ITM_Virtual_Card_Type	alpha	10	Defines the associated virtual card type for the stored value card item in ValueCard. The card type in ValueCard identifies whether you can define an expiration date for a card when the card is activated in ValueCard. You can only define a virtual card type if the SVC type field for the item is set to V. Available in XML version: 6.0 (version 11.5 of CWDirect).
ItemOffer The ItemOffer element repeats for each item offer record defined for the item in the Item Offer file.
Offer_Number	alpha	3	A code that represents the offer where the item is advertised. From the Offer number field in the Item Offer file.
Cost	numeric	7.2	The cost to include the item in the offer. From the Cost field in the Item Offer file.
Expected_return_pct	numeric	5.2	The percentage of returns you expect to receive for the item/offer. From the Expected return pct field in the Item Offer file.
Gift_wrap_flag	alpha	1	Indicates if gift wrapping is available for the item in the offer. Y = The item can be gift wrapped. N = The item cannot be gift wrapped in this offer. From the G/W flag field in the Item Offer file.
Gift_wrap_price	numeric	7.2	The price in the offer for gift wrapping the item. From the G/W price field in the Item Offer file.
Page_Nbr	numeric	5	The primary page number where the item appears in the offer. From the Page # field in the Item Offer file.
Projected_units	numeric	7	The number of units of the item you expect to sell in the offer. From the Projected units field in the Item Offer file.
SH_price	numeric	7.2	The price to charge the customer for special handling. From the S/H price field in the Item Offer file.
Special_handling	alpha	1	Indicates if the item is eligible for special handling in the offer. Y = The item is eligible for special handling in the offer. N = The item is not eligible for special handling in the offer. From the S/H flag field in the Item Offer file.
Square_inches	numeric	5.2	The square inches that the item occupies in the offer. From the Square inches field in the Item Offer file.
Term_payment_interval	numeric	5	The number of days between payments. From the Term payment interval field in the Item Offer file.
Standard_price	numeric	7.2	The standard price for the item in the offer. From the Standard price field in the Item Offer file.
Freight	numeric	6.2	The freight amount to charge for the item in the offer. From the Freight field in the Item Offer file.
Hidden_freight	numeric	6.2	The hidden freight amount to charge for the item in the offer. From the Hidden freight field in the Item Offer file.
IOF_Spread	alpha	3	From the IOF spread field in the Item Offer file.
IOF_Volume_ Discount_YN	alpha	1	Indicates if the item is eligible for a volume discount in the offer. Y = The item is eligible for a volume discount. N = The item is not eligible for a volume discount. From the IOF volume discount Y/N field in the Item Offer file.
IOF_Coupon_Disc_ dlr	numeric	7.2	The coupon dollar amount subtracted from the price when the item is ordered from the offer. From the IOF coupon disc $ field in the Item Offer file.
IOF_Coupon_ Effective_Date	numeric	7.0	The date the coupon becomes effective. From the IOF coupon effective date field in the Item Offer file.
IOF_Featureoption	alpha	1	A code that indicates if the item is considered a featured or optional item in an advertisement for the offer. F = The item is the featured item in the advertisement. O = The item is an optional item in the advertisement. From the Feature/option field in the Item Offer file.
IOF_Pickupnew	alpha	1	A code that indicates if the item has been carried over from a previous offer or is new to your product offerings. P = Item is a pickup item, previously sold in another offer. N = Item is a new addition in the offer. From the Pickup/new field in the Item Offer file.
IOF_Sale_Book_ Item_Flag	alpha	1	Indicates if the item is on sale. Y = The item is on sale. N = The item is not on sale. From the IOF sale book item flag field in the Item Offer file.
IOF_Qty_Break_ Upsl_Thrshd	numeric	5	From the IOF qty break upsl thrshd field in the Item Offer file.
IOF_Pop_Up_ Message_1	alpha	30	From the IOF pop up message 1 field in the Item Offer file.
IOF_Pop_Up_ Message_2	alpha	30	From the IOF pop up message 2 field in the Item Offer file.
IOF_Pop_Up_ Message_3	alpha	30	From the IOF pop up message 3 field in the Item Offer file.
IOF_Pop_Up_ Message_4	alpha	30	From the IOF pop up message 4 field in the Item Offer file.
IOF_Warranty_Item	alpha	1	Indicates if the item in the offer is a warranty item. Y = The item is a warranty item. N = The item is not a warranty item. From the IOF warranty item? field in the Item Offer file.
IOF_Required_Add_Reason	alpha	1	Indicates if an add reason code is required when the item in the offer is added to an order. Y = An add reason code is required. N = An add reason code is not required. From the IOF required add reason? field in the Item Offer file.
IOF_Included_ Internet_Ofr	alpha	1	From the IOF future use Y/N 1 field in the Item Offer file.
CRV_Code	numeric	3	A code that represents the item’s expected selling pattern in the offer. From the CRV code field in the Item Offer file.
CRV_Description	alpha	30	A description of the curve code. From the Description field in the Curve file.
CRV_Curve_type	alpha	1	A user-defined code used to group projection curves. From the Curve type field in the Curve file.
ADD_Addl_chg_code	alpha	2	The additional charge code associated with the type of special handling you are offering for the item in the offer. From the ADD Add’l chg code field in the Item Offer file.
ADD_Description	alpha	30	A description of the additional charge. From the ADD description field in the Additional Charge file.
SHF_Code	alpha	2	A code that indicates the format of the custom special handling offered for the item in the offer. From the SHF code field in the Additional Charge file.
SHF_Description	alpha	30	A description of the custom special handling. From the Description field in the Special Format file.
IOF_AOC_Add-On_Code	alpha	3	From the IOF AOC add-on code field in the Item Offer file.
ItemPrice The ItemPrice element repeats for each item price record defined for the item in the Item Price file.
Effective_date	numeric	7	The date the price or quantity break discount becomes valid. From the Effective date field in the Item Price file.
Qty	numeric	7	The amount of the item that the customer must order to receive the discounted price. From the Qty field in the Item Price file.
Associate_price	numeric	7.2	The price at which the item will be sold to associate customers. From the Associate price field in the Item Price file.
Price	numeric	7.2	The price at which the item will be sold. From the Price field in the Item Price file.
IPR_Price_column	alpha	1	A code that indicates the pricing column associated with the price. From the Price column field in the Item Price file.
IPR_Associate_tax	numeric	7.2	The price at which the item will be sold to associate customers on orders subject to tax-inclusive pricing and VAT. From the Tax inclusive associate price field in the Item Price file.
IPR_Tax_price	numeric	7.2	The price at which the item will be sold on orders subject to tax-inclusive pricing and VAT. From the Tax incl price field in the Item Price file.
IPR_No_Charge	alpha	1	Indicates if the item will be sold at no charge. Y = The item is sold at no charge. N = The item is sold for a price. From the IPR no charge? field in the Item Price file.
PageLetterAlias The PageLetterAlias element repeats for each page letter alias record defined for the item offer in the Page Letter Alias file.
Seq_Nbr	numeric	3	The sequence number assigned to the page letter alias record. From the Seq # field in the Page Letter Alias file.
Page_letter	alpha	6	The letter assignment for an item in the offer. From the Page letter field in the Page Letter Alias file.
Page_Nbr	numeric	5	The page number where the item displays in the catalog. From the Page # field in the Page Letter Alias file.
Cost	numeric	11.4	The cost to include the item on the page in the offer. From the Cost field in the Page Letter Alias file.
Square_inch	numeric	5.2	The number of square inches that the item occupies on the catalog page. From the Square inch field in the Page Letter Alias file.
Alias_item	alpha	12	The alternate item code for the actual item. From the Alias item field in the Page Letter Alias file.
IOFAccompanyingItem The IOFAccompanyingItem element repeats for each accompanying item record defined for the item offer in the Accompanying Item file.
ACI_Qty_required	numeric	5	The amount of the item that must be ordered to qualify for receiving the accompanying item. From the Qty req’d field in the Accompanying Item file.
ACI_Qty	numeric	5	The number of accompanying items to add to the order. From the Qty field in the Accompanying Item file.
ACI_Free_gift	alpha	1	Indicates if the accompanying item is added to the order free of charge. Y = The accompanying item is being offered free of charge. N = The accompanying item is not free of charge. From the Free gift? field in the Accompanying Item file.
ACI_Use_Ordered_ Qty	alpha	1	Indicates if the accompanying item is ordered in the same quantity as the qualifying item. Y = The accompanying item is ordered in the same quantity as the qualifying item. N = The accompanying item is not ordered in the same quantity as the qualifying item. From the ACI use ordered qty? field in the Accompanying Item file.
ACI_ITM_Number	alpha	12	The accompanying item to add to the order if the customer orders the required quantity of the originating item. From the ACI ITM number field in the Accompanying Item file.
ACI_SKU_Code	alpha	14	The SKU of the accompanying item to add to the order. From the ACI SKU code field in the Accompanying Item file.
IOFUserField The IOFUserField element repeats for each item offer user field record defined for the item offer in the Item Offer User Field file.
IOF_UDF_Sequence_Nbr	numeric	3	The sequence number assigned to the item offer user field. From the Seq# field in the Item Offer User Field file.
IOF_UDF_Text	alpha	30	The text defined for the item offer user field. From the Text field in the Item Offer User Field file.
IOF_UDF_Number	numeric	16	The number defined for the item offer user field. From the Number field in the Item Offer User Field file.
IOF_UDF_Date	numeric	7	The date defined for the item offer user field. From the Date field in the Item Offer User Field file.
IOF_UDF_Display_ sequence	numeric	3	The display sequence number assigned to the item offer user field. From the Display sequence field in the Item Offer User Field file.
IOF_UDF_File_code	alpha	3	The code representing the file to which the user-defined field is linked. For item offer user fields, the file code is IOF. From the IOF UDF file code field in the Item Offer User Field file.
UDD_Field_label	alpha	15	The field label that appears on a screen for the item offer user field. From the Field label field in the User Defined Field Detail file.
UDD_Field_type	alpha	1	A code that identifies the type of field. D = Date field. N = Number field. T = Text field. From the Field type field in the User Defined Field Detail file.
UDD_Field_usage	alpha	1	A code that identifies whether you are collecting the field information for the user-defined field. I (Input): you can enter information in this field. O (output): you cannot enter information in this field. From the Field usage field in the User Defined Field Detail file.
IOFSpecialHandlingDetail The IOFSpecialHandlingDetail element repeats for each special handling detail record defined for the item offer in the Item Offer User Field file.
SFD_Seq_Nbr	numeric	3	The sequence number assigned to the special handling detail. From the SFD seq # field in the Special Format Details file.
SFD_Display_Seq	numeric	3	The display sequence number assigned to the special handling detail. From the SFD display seq field in the Special Format Details file.
SFD_Prompt_Text	alpha	15	The field label name of the special handling detail input field. From the SFD prompt text field in the Special Format Details file.
SFD_Required_field	alpha	1	Indicates if the special handling detail is required. From the SFD required field field in the Special Format Details file.
SFD_Feature_ options	alpha	1	Indicates if the special handling detail is a feature option. A feature option is an extra feature that can be added to the item. Y = The special handling detail is a feature option. N = The special handling detail is not a feature option. From the SFD feature options field in the Special Format Details file.
SFD_Default_value	alpha	45	From the Default value field in the Special Format Details file.
SFD_Default_charge_dlr	numeric	7.2	The price to charge the customer for the special handling detail feature option. From the SFD default charge $ field in the Special Format Details file.
SFD_Default_charge_Pct	numeric	5.2	The percentage used to calculate the price of the special handling detail feature option. From the SFD default charge % field in the Special Format Details file.
SFD_Default_cost_ dlr	numeric	11.4	The cost of the special handling detail feature option. From the SFD default cost $ field in the Special Format Details file.
SFD_Default_cost_ Pct	numeric	5.2	The percentage used to calculate the cost of the special handling detail feature option. From the SFD default cost % field in the Special Format Details file.
SFD_Default_text	alpha	2	A code that allows you to select text from the customer record to default to the custom special handling detail. From the SFD default text field in the Special Format Details file.
SFD_Max_Nbr_ characters	numeric	2	The maximum number of characters allowed for the special handling detail. From the SFD max # characters field in the Special Format Details file.
SFD_Cross_ Reference	alpha	3	A code used to cross reference the special handling detail to the element’s code on the manufacturing system. From the SFD cross reference field in the Special Format Details file.
IOFSpecialHandlingResponse The IOFSpecialHandlingResponse element repeats for each item information record defined for the item’s class in the Item Class Template file.
SFD_Seq_Nbr	numeric	3	The sequence number assigned to the special handling response. From the SFD seq # field in the Special Format Responses file.
SFR_Valid_response	alpha	45	A valid special handling response. From the Valid response field in the Special Format Response file.
SFR_Description	alpha	45	A description of the response. From the SFR description field in the Special Format Response file.
ItemInformation The ItemInformation element repeats for each item information record defined for the item’s class in the Item Class Template file.
Template	alpha	2	The type of template for item information. CS = Customer Service PC = Product Comments PO = Purchase Orders QC = Quality Control RP = Reporting (E-Commerce) From the Template field in the Item Class Template file.
Sequence_Nbr	numeric	3	The sequence number assigned to the template. From the Seq # field in the Item Class Template file.
Heading	alpha	20	A description of the item class template. From the Heading field in the Item Class Template file.
Lines_available	numeric	3	The number of lines available in this template for the entry of information. From the Lines available field in the Item Class Template file.
ItemInformationDetail The ItemInformationDetail element repeats for each item information detail defined for the item in the Item Information file. Note: The system includes ItemInformationDetail only if the Item information field in the Item Information file contains a value.
Sequence_Nbr	numeric	3	The sequence number assigned to the item information line. From the Seq # field in the Item Information file.
Item_information_ Line	alpha	50	The item information defined for the item under a particular template heading. From the Item information field in the Item Information file.
ItemComment The ItemComment element repeats for each item comment defined for the item in the SKU Comments file.
Seq_Nbr	numeric	3	The sequence number assigned to the item comments. From the Seq # field in the SKU Comments file.
Comment_line	alpha	50	The comments defined for the item. From the Comment field in the SKU Comments file.
Print_code	alpha	1	Indicates where to print or display the item comments. B = Print on pick slip and invoice. N = Do not print. P = Print on pick slip. R or blank = Print on Catalog Planning Analysis reports. W = Display on pop-up window when you select an item to add to an order. From the Print code field in the SKU Comments file.
ItemAttribute The ItemAttribute element repeats for each item attribute defined for the item in the Item Attribute file.
IAT_Type	alpha	6	A code that identifies an item attribute. From the Type field in the Item Attribute file.
IAT_Description	alpha	30	A description of the item attribute type. From the Description field in the Item Attribute file.
IAV_Value	alpha	6	A code that identifies an attribute value. From the Value field in the Item Attribute Value file.
IAV_Description	alpha	30	A description of the attribute value. From the Description field in the Item Attribute Value file.
IAA_Affinity_flag	alpha	1	Determines how the system tracks the customer affinity preferences for the item. U = Upsell only. Upsell the item to a customer flagged with the attribute value. C = Capture only. When the customer orders the item, the customer’s affinity preference history is updated. B = Both upsell and capture. N = Neither upsell nor capture. From the Affinity flag field in the Item Attribute Assignment file.
SourcePrice The SourcePrice element repeats for each source price defined for the item in the Special Pricing by Source file.
SRC_Source_code	alpha	9	The source code associated with special price breaks for items by source code. From the SRC source code field in the Special Pricing By Source file.
SPS_Qty	numeric	5	The number of units of the item that the customer must purchase to receive the special price. From the SPS quantity field in the Special Pricing by Source file.
SPS_Price	numeric	7.2	The special price for the item, quantity, and source code. From the SPS price field in the Special Pricing By Source file.
SPS_Associate_ price	numeric	7.2	The special price for the item for associate customers. From the SPS associate price field in the Special Pricing By Source file.
SPS_Tax_price	numeric	7.2	The special price of the item if the order is subject to VAT. From the Tax incl price field in the Special Pricing By Source file.
SPS_Associate_tax_price	numeric	7.2	The special price of the item for associate customers if the order is subject to VAT. From the Tax inclusive associate price field in the Special Pricing By Source file.
Coordinate The Coordinate element repeats for each coordinate defined for the item in the Item Coordinate file.
ICN_Coordinate_ item	alpha	12	The related item coordinated to the primary item for cross-selling purposes. From the Coordinate item field in the Item Coordinate file.
ICN_Message	alpha	70	The persuasive or descriptive message to display for the coordinate item. From the Message field in the Item Coordinate file.
ICN_Sequence	numeric	3	The sequence number assigned to the item coordinate type, indicating the sequence in which coordinate items assigned to this type display on the Display Coordinate Items window in order entry. From the Seq field in the Item Coordinate file. Available in XML version: 3.0 (version 9.0 of CWDirect).
ICN_Coordinate_ type	alpha	2	A code representing a type of item coordinate, such as mandatory or optional. From the Type field in the Item Coordinate file. Available in XML version: 3.0 (version 9.0 of CWDirect).
Keyword The Keyword element repeats for each keyword defined for the item in the Keyword file.
KWD_Type	alpha	1	Indicates whether the word is created as a keyword for the item. I = Include the word as a keyword for the item. E = Do not include the word as a keyword for the item; for example, you may want to exclude words such as “the” and “with.” From the KWD type field in the Keyword file.
KWD_Keyword Exclusion	alpha	20	The word you wish to include or exclude as a keyword, based on the Type field. From the KWD keyword/exclusion field in the Keyword file.
Image
ECI_Thumbfile_ Picture	alpha	255	The path and filename where the thumbnail image of the item is located. From the ECI thumbfile picture field in the E-Commerce Item Image file.
ECI_Regular_Picture	alpha	255	The path and filename where the regular image of the item is located. From the ECI regular picture field in the E-Commerce Item Image file.
ECI_Large_Picture	alpha	255	The path and filename where the large image of the item is located. From the ECI large picture field in the E-Commerce Item Image file.
Upsell The Upsell element repeats for each upsell and cross-sell defined for the item in the E-Commerce Up/Cross-Sell file.
EUC_Up-SellCross-Sell	alpha	1	Indicates whether the item is an e-commerce upsell or cross-sell. C = The item is an e-commerce cross-sell. U = The item is an e-commerce upsell. From the EUC up-sell/cross-sell field in the E-Commerce Up/Cross-Sell file.
Upsell_Item_ECI_ Item_Numb	alpha	12	The item number for the item you wish to upsell or cross-sell. From the Upsell item ECI item numb field in the E-Commerce Up/Cross-Sell file.
ECX_Up-Sell_Desc	alpha	50	A description of the item you wish to upsell or cross-sell. From the ECX up-sell desc field in the E-Commerce Up/Cross-Sell file.
Restriction The Restriction element repeats for each item restriction defined for the item in the Item Restriction by Country/State file.
RPR_Country	alpha	3	A country to which you cannot ship the item, or to which one or more states have shipping restrictions for the item. From the RPR country field in the Item Restriction by Country/State file.
NAM_State	alpha	2	A state which has a shipping restriction for the item. From the NAM state field in the Item Restriction by Country/State file.
EcommCategory The EcommCategory element repeats for each e-commerce category defined for the item in the E-Comm Item Categories file.
ECA_Category	alpha	4	A code representing an e-commerce item category. From the ECA category field in the E-Comm Item Categories file.
ECA_Category_ Description	alpha	30	A description of the e-commerce item category. From the ECA category description field in the E-Commerce Category file.
ITMUserField The ITMUserField element repeats for each item user field defined for the item in the Item User Field file.
ITM_UDF_Sequence_Nbr	numeric	3	The sequence number assigned to the item user field. From the Seq# field in the Item User Field file.
ITM_UDF_Text	alpha	30	The text defined for the item user field. From the Text field in the Item User Field file.
ITM_UDF_Number	numeric	16	The number defined for the item user field. From the Number field in the Item User Field file.
ITM_UDF_Date	numeric	7	The date defined for the item user field. From the Date field in the Item User Field file.
ITM_UDF_Display_ sequence	numeric	3	The sequence number assigned to the item user field, controlling its placement on the screen. From the Display sequence field in the Item User Field file.
ITM_UDF_File_code	alpha	3	The code representing the file to which the user-defined field is linked. For item user fields, the file code is ITM. From the ITM UDF file code field in the Item User Field file.
UDD_Field_label	alpha	15	The field label that appears on a screen for the item user field. From the Field label field in the User Defined Field Detail file.
UDD_Field_type	alpha	1	A code that identifies the type of field. D = Date field. N = Number field. T = Text field. From the Field type field in the User Defined Field Detail file.
UDD_Field_usage	alpha	1	A code that identifies whether you are collecting the field information for the user-defined field. I (Input): you can enter information in this field. O (output): you cannot enter information in this field. From the Field usage field in the User Defined Field Detail file.
TaxExemption The TaxExemption element repeats for each tax exemption defined for the item in the Item Tax Exempt file.
ITE_State	alpha	2	A code that represents the state in which an item tax exemption applies. From the ITE state field in the Item Tax Exempt file.
ITE_Seq_Nbr	numeric	3	The sequence number assigned to the item tax exemption. From the Seq # field in the Item Tax Exempt file.
ITE_Tax_value	numeric	9.2	The dollar value up to which the item is taxable. The portion of the item price above this value is tax exempt. From the ITE tax value field in the Item Tax Exempt file.
ITE_No_tax_value	numeric	9.2	The dollar value that is tax exempt. If the item price is this value or less, the item is tax exempt. If the item price is greater than this value, the item is taxable in full. From the ITE no tax value field in the Item Tax Exempt file.
ITE_Exempt	alpha	1	A code indicating whether the item is tax exempt. Y = the item is tax exempt. N = the item is not tax exempt. From the Exempt? field in the Item Tax Exempt file.
FreightExemption The FreightExemption element repeats for each freight exemption defined for the item in the Freight Exemption file.
FEF_Sequence_ Number	numeric	5	The sequence number assigned to the item freight exemption. From the FEF sequence number field in the Freight Exemption file.
Offer_Number	alpha	3	The offer in which the item is exempt from freight. From the Offer number field in the Freight Exemption file.
SRC_Source_code	alpha	9	The source code in which the item is exempt from freight. From the SRC source code field in the Freight Exemption file.
SKU Each item download message contains one Item element and one SKU element. For example, if you update a SKU’ed item, the system generates a separate item download message for each SKU.
SKU_Code	alpha	14	The SKU code for the item, such as style, color, and/or size. From the SKU code field in the SKU file.
Collating_sequence_Nbr	numeric	5	The collating sequence number assigned to the SKU. From the Collating seq # field in the SKU file.
Compatibility	alpha	3	compatibility code assigned to the SKU; other SKUs that are compatible to this SKU are assigned the same compatibility code. From the Compatibility field in the SKU file.
SKU_Cubing_value_override	numeric	7.1	The cubic volume of the SKU, which overrides the cubic volume defined for the item. From the Cub val field in the SKU file.
SKU_Description	alpha	40	A description of the SKU. From the Description field in the SKU file.
SKU_Subscription	alpha	1	Indicates whether the SKU is a subscription item. Y = this is a subscription item. N = this is not a subscription item. From the Subscription field in the SKU file.
Height_override	numeric	3	The height measurement for the SKU. The Height, Length, and Width values are used to determine the cubic volume of the SKU. From the Height override field in the SKU file.
Length_override	numeric	3	The length measurement for the SKU. The Height, Length, and Width values are used to determine the cubic volume of the SKU. From the Length override field in the SKU file.
List_price	numeric	7.2	The list price defined for the SKU. From the List price field in the SKU file.
Long_SKU_color	numeric	5	A code that represents the color portion of the long SKU code. From the Long SKU color field in the SKU file.
Long_SKU_size	numeric	5	A code that represents the size portion of the long SKU code. From the Long SKU size field in the SKU file.
Long_SKU_width	numeric	5	A code that represents the width portion of the long SKU code. From the Long SKU width field in the SKU file.
Lowest_price	numeric	7.2	The lowest recommended sale price for the SKU. From the Lowest price field in the SKU file.
Max_qty_for_ location	numeric	7	The SKU’s recommended maximum number of units to be stored in the primary pick location. From the Max qty for location field in the SKU file.
Max_qty_for_ warehouse	numeric	7	The SKU’s recommended maximum number of units to be stored in the primary warehouse. From the Max qty for warehouse field in the SKU file.
Min_qty_for_ location	numeric	7	The SKU’s recommended minimum number of units to be stored in the primary pick location. From the Min qty for location field in the SKU file.
Min_qty_for_ warehouse	numeric	7	The SKU’s recommended minimum number of units to be stored in the primary warehouse. From the Min qty for warehouse field in the SKU file.
SKU_Gift_certificate	alpha	1	Determines whether the SKU qualifies as a gift certificate. Y = this SKU is a gift certificate. N or blank = this SKU is not a gift certificate. From the SKU gift certificate field in the SKU file.
Out_of_stock_flag	alpha	1	Indicates whether the SKU is out of stock. Y = the SKU is out of stock. N or blank = the SKU is not out of stock. From the Out of stock flag field in the SKU file.
Qty_order_direct_ ship	numeric	7	From the Qty order direct ship field in the SKU file.
Receipt_date	numeric	7	The last time inventory for the SKU was received. From the Receipt date field in the SKU file.
Reserve_qty_limit	numeric	7	If the order quantity exceeds this amount, the system will not attempt to reserve the item and will display the backorder reason. From the Reserve qty limit field in the SKU file.
Restrict_orders	alpha	1	Defines whether you can accept an order for the SKU and whether demand is captured. Y = you can accept an order for the item/SKU. N or blank = you cannot accept an order for the item/SKU. From the Restrict orders field in the SKU file.
Retail_reference_Nbr	numeric	15	The retail reference number assigned to the SKU. From the Retail ref # field in the SKU file.
Out_of_stock_date	numeric	7	The last date the on hand level for the SKU was zero. From the Out of stock date field in the SKU file.
Selling_weight_ override	numeric	7.3	The selling weight of the SKU, used to calculate the freight charge on the SKU when the freight method on the order is Freight by weight or Freight by order weight. From the Selling weight override field in the SKU file.
Short_SKU	numeric	7	The short SKU number defined for the SKU, used to identify the SKU. From the Short SKU field in the SKU file.
User_field_1	alpha	10	A user-defined field for the SKU. From the User field 1 field in the SKU file.
User_field_2	alpha	10	A user-defined field for the SKU. From the User field 2 field in the SKU file.
User_field_3	alpha	10	A user-defined field for the SKU. From the User field 3 field in the SKU file.
Weight_override	numeric	7.3	The actual shipping weight of the SKU. From the Weight override field in the SKU file.
Width_override	numeric	3	The width measurement for the SKU. The Height, Length, and Width values are used to determine the cubic volume of the SKU. From the Width override field in the SKU file.
Sale_credit_flag	alpha	1	Determines whether a sale credit is generated when the SKU is returned. Y = Generate a sale (merchandise) credit when the SKU is returned. N or blank = Generate a refund type based on the pay type on the order. From the Sale credit flag field in the SKU file.
Harmonize_code	alpha	16	A code that prints on customs documents for international shipments. If you charge duty on international orders, use this field to define the item’s duty rate. From the Harmonize code field in the SKU file.
SKU_Coordinate_ group	numeric	3	A code assigned to the SKU to ensure that certain items ship together when ordered together. Items with the same coordinate group code will ship together through the same shipper. From the Coord group field in the SKU file.
SKU_Open_qty	numeric	7	The total number of units on orders that have not shipped. From the SKU open qty field in the SKU file.
SKU_Future_qty	numeric	7	The total number of units on future orders. From the Future qty field in the SKU file.
SKU_Suspense_qty	numeric	7	The total number of units received against the purchase order that are currently in suspense. From the SKU suspense qty field in the SKU file.
SKU_On_hold_qty	numeric	7	The total number of units on hold. From the On hold qty field in the SKU file.
SKU_Standard_Cost	numeric	11.4	The standard cost of the SKU. The system populates this field only if the Costing Method (A25) system control value is set to STANDARD and a value exists in the SKU standard cost field in the SKU file.
SKU_Average_Cost	numeric	11.4	The average cost of the SKU. The system populates this field only if the Costing Method (A25) system control value is set to AVERAGE and a value exists in the SKU average cost field in the SKU file. Available in XML version: 2.0 (version 8.5 of CWDirect).
SKU_FIFO_cost	numeric	11.4	The FIFO cost of the SKU. From the SKU FIFO cost field in the SKU file. Available in XML version: 4.0 (version 10.0 of CWDirect).
SKU_Second_ Language_Desc	alpha	40	The second language description defined for the SKU. From the Second language desc field in the SKU file.
SKU_VAT_Exempt_ flag	alpha	1	Indicates whether the item is exempt from VAT. Y = The item is exempt from VAT. N or blank = The item is subject to VAT. From the VAT exempt flag field in the SKU file.
SKU_Second_ compatibility	alpha	3	The compatibility code assigned to the SKU; other SKUs that are compatible to this SKU are assigned the same compatibility code. From the Second compatibility field in the SKU file.
SKU_Hidden_tax_ amount	numeric	7.2	The hidden tax amount to include in the price of an item subject to VAT. From the Hidden tax amount field in the SKU file.
SKU_Hidden_tax_ percent	numeric	5.2	The hidden tax percent to include in the price of an item subject to VAT. From the Hidden tax percent field in the SKU file.
SKU_Suppress_BO_Card	alpha	1	Indicates whether to produce a backorder card for the SKU. Y = Suppress normal backorder card generation for the SKU. N or blank = Do not suppress normal backorder card generation. From the SKU suppress B/O card field in the SKU file.
SKU_Projected_ Returns	numeric	7	The number of units you expect to receive in returns for the SKU. From the SKU projected returns field in the SKU file.
SKU_User_field_4	alpha	5	A user-defined field for the SKU. From the SKU user field 4 field in the SKU file.
SKU_User_field_5	alpha	5	A user-defined field for the SKU. From the SKU user field 5 field in the SKU file.
SKU_Book_ Inventory	numeric	7	The expected inventory per catalog or advertisement. From the SKU book inventory field in the SKU file.
SKU_Returnable	alpha	1	Indicates whether the SKU can be returned. Y = The SKU is returnable. N or blank = The SKU is not returnable. From the SKU returnable field in the SKU file.
SKU_Retail_X-Ref_Nbr	numeric	10	The retail reference number assigned to the SKU. From the SKU retail x-ref # field in the SKU file.
SKU_LS_Style	alpha	20	The long SKU style defined for the SKU. From the SKU L/S style field in the SKU file.
SKU_LS_Vendor	alpha	7	The long SKU vendor defined for the SKU. From the SKU L/S vendor field in the SKU file.
SKU_Receiving_ Priority	alpha	2	A number that controls the priority of receiving the SKU. From the SKU receiving priority field in the SKU file.
SKU_Excl_Store_ Restock	alpha	1	Indicates if the SKU is excluded from store restock. Y = the SKU is excluded from store restock. N or blank = the SKU is not excluded from store restock. From the SKU excl store restock? field in the SKU file.
SKU_Generic_ Ecommerce	alpha	10	From the SKU generic ecommerce field in the SKU file.
SKU_Last_ Download_Qty	numeric	5	The inventory quantity that was last downloaded to the e-commerce interface. From the SKU last download qty field in the SKU file.
SKU_Last_Extract	numeric	7	The date when the inventory information for the SKU was last extracted. From the SKU last extract field in the SKU file.
SKU_Last_Ecomm_ Info_Chg	numeric	7	The date when the SKU information was last downloaded to the e-commerce interface. From the SKU last ecomm info chg field in the SKU file.
SKU_SVC_Card_ Reload	alpha	1	From the SKU future use Y/N 1 field in the SKU file.
SKU_Original_Retail_Price	numeric	7.2	The original retail price for the SKU. From the SKU original retail price field in the SKU file.
SKU_Create_Date	numeric	7	The date the SKU was created. From the SKU create date field in the SKU file.
SKU_GTIN_Nbr	numeric	14	The GTIN number defined for the SKU. From the SKU GTIN # field in the SKU file.
SKU_Commodity_ Code	numeric	8	The commodity code defined for the SKU. From the SKU commodity code field in the SKU file.
ABC_Code	alpha	1	A code that classifies an item/SKU based on sales volume. From the ABC code field in the SKU file.
ABC_First_order	numeric	5	The number of days that must pass before an ABC code is assigned to the item. From the First order field in the ABC/Velocity file.
Percentage_of_Sales	numeric	5.2	The monthly percentage of sales required for an item to earn an ABC code. From the Percentage of sales field in the ABC/Velocity file.
New_item_flag	alpha	1	Indicates if the item has been marked as new (N) in the ABC code field. Y = The item is marked as new. N or blank = The item is not marked as new. From the New item flag field in the SKU file.
CTN_ID_Nbr	numeric	2	The carton ID number assigned to the SKU, identifying a particular size box. From the CTN ID # (SKU) field in the SKU file.
Frequency_code	alpha	1	A code that classifies the performance of an item. From the Freq code field in the SKU file.
Percentage_of_picks	numeric	5.2	The percentage of picks generated for the item. From the Pct of picks field in the Frequency file.
Warehouse	numeric	3	The warehouse where the SKU is located. From the Whs field in the SKU file.
Warehouse_name	alpha	30	The name of the warehouse. From the Name field in the Warehouse file.
Location	alpha	7	The primary location where the SKU is located. From the Location field in the SKU file.
SLC_Code	alpha	2	The soldout control code specified for the SKU. From the SLC code field in the SKU file.
SLC_Description	alpha	30	The description of the soldout control code. From the SLC description field in the Soldout Control file.
SLC_Status	alpha	1	Indicates whether the system sells out the SKU immediately. 1 = Sell out immediately, regardless of available on-hand stock. 2 = Include on order quantity in the soldout calculation. 3 = Exclude on order quantity in the soldout calculation. From the Status field in the Soldout Control file.
Unit_of_measure	alpha	3	The unit of measure defined for the SKU. From the UOM field in the SKU file.
UOM_Description	alpha	30	A description of the unit of measure. From the UOM description field in the Unit of Measure file.
UOM_Units	numeric	5	The number of units represented by the unit of measure, such as 12 units in a case. From the UOM units field in the Unit of Measure file.
SKU_Element_1_ Code	alpha	4	A code representing a SKU element, such as blue (color) or small (size). From the Element 1 field in the SKU file.
SKU_Element_1_ Desc	alpha	10	A description of the SKU element, such as navy blue. From the Element 1 desc field in the SKU Element 1 file.
SKU_Element_1_ Name	alpha	10	The name of SKU element 1, such as color, size, or width. From the Split SKU Element Column Headings (A52, A53, A54) system control values.
SKU_Element_2_ Code	alpha	4	A code representing a SKU element, such as blue (color) or small (size). From the Element 2 field in the SKU file.
SKU_Element_2_ Desc	alpha	10	A description of the SKU element, such as navy blue. From the Element 2 desc field in the SKU Element 2 file.
SKU_Element_2_ Name	alpha	10	The name of SKU element 2, such as color, size, or width. From the Split SKU Element Column Headings (A52, A53, A54) system control values.
SKU_Element_3_ Code	alpha	4	A code representing a SKU element, such as blue (color) or small (size). From the Element 3 field in the SKU file.
SKU_Element_3_ Desc	alpha	10	A description of the SKU element, such as navy blue. From the Element 3 desc field in the SKU Element 3 file.
SKU_Element_3_ Name	alpha	10	The name of SKU element 3, such as color, size, or width. From the Split SKU Element Column Headings (A52, A53, A54) system control values.
SKU_IST_Item_ status	alpha	1	The status of the item, such as discontinued. From the SKU IST item status field in the SKU file.
Item_status_ description	alpha	30	A description of the item status. From the Description field in the Item Status file.
IST_Message_line_1	alpha	50	A message to display when ordering an item with this status. From the IST message line 1 field in the Item Status file.
IST_Message_line_2	alpha	50	A message to display when ordering an item with this status. From the IST message line 2 field in the Item Status file.
IST_Return_ disposition	alpha	2	A code that identifies how return merchandise with this item status is handled, in terms of whether the return updates inventory and the warehouse and location to which the merchandise is returned. From the IST return disposition field in the Item Status file.
SKU_ITC_Category	alpha	4	A code assigned to the SKU to classify and group like items for use in item relationships and compatibility. From the ITC category field in the SKU file.
Item_category_ description	alpha	30	A description of the item category. From the Description field in the Item Category file.
SKU_PRP_Prep_ Code	alpha	2	A code that identifies a SKU’s special handling or processing requirements within the warehouse. From the SKU PRP prep code field in the SKU file.
PRP_Description	alpha	40	A description of the prep code. From the PRP description field in the Prep Code file.
SKU_Country_Of_ Origin	alpha	3	A code representing the country where the SKU originated. From the SKU country of origin field in the SKU file.
Country_description	alpha	30	A description of the country of origin. From the Description field in the Country file.
SKU_LSC_LS_Class	numeric	4	The long SKU class defined for the SKU. From the SKU LSC L/S class field in the SKU file.
LSC_Description	alpha	30	A description of the long SKU class. From the Description field in the Long SKU Class file.
SKU_ZRC_Zone_ Reservation	alpha	4	The zone reservation code assigned to the SKU, identifying the item as climate-sensitive. From the SKU ZRC zone reservation field in the SKU file.
SKU_Drop_Ship	alpha	1	Indicates whether you ship the SKU from your warehouse, or have your vendor ship it to the customer directly. 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. Valid values: Y (drop ship) = When a customer orders the SKU, you order the SKU from your vendor and the vendor ships it directly to your customer. You can only flag a SKU as drop ship if the Drop ship flag at the item level is Y. N (non-drop ship) = You ship the SKU from your warehouse.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. From the Drop ship field in the SKU file. Available in XML version: 6.0 (version 11.5 of CWDirect).
VendorItem The VendorItem element repeats for each vendor item defined for the SKU in the Vendor Item file.
Vendor_Nbr	numeric	7	The code the vendor uses to identify the SKU. From the Vendor # field in the Vendor Item file.
Item	alpha	20	The item number, as defined by the vendor. From the Item field in the Vendor Item file.
Cubic_volume	numeric	5	The cubic volume of the item, as defined by the vendor. From the Cubic volume field in the Vendor Item file.
Description	alpha	30	A description of the vendor item. From the Description field in the Vendor Item file.
Lead_days	numeric	3	The number of days it takes the vendor to deliver the item when it is ordered through a purchase order. From the Lead days field in the Vendor Item file.
Message_line_1	alpha	30	Informational message for the vendor item. From the Message line 1 field in the Vendor Item file.
Message_line_2	alpha	30	Informational message for the vendor item. From the Message line 2 field in the Vendor Item file.
Message_line_3	alpha	30	Informational message for the vendor item. From the Message line 3 field in the Vendor Item file.
Minimum_qty	numeric	7	The minimum unit quantity (in retailer’s unit of measure) of merchandise you are required to order from the vendor. From the Min qty field in the Vendor Item file.
Price	numeric	11.4	The vendor’s list price for the item. From the Price field in the Vendor Item file.
Ship_weight	numeric	7.3	The shipping weight of the item, as defined by the vendor. From the Ship weight field in the Vendor Item file.
VIT_Vend_ord_qty_multiple	numeric	5	The number of units (in retailer’s unit of measure) by which your order quantity must be divisible when you order the item from the vendor. From the VIT vend ord qty multiple field in the Vendor Item file.
VIT_Upload_frt_dlr_ limit	numeric	9.2	The maximum dollar value of each detail level freight charge for the item on the PO. From the Upload frt $ limit field in the Vendor Item file.
VIT_Upload_hnd_ dlr_limit	numeric	9.2	The maximum dollar value of each detail level handling charge for the item on the PO. From the Upload hnd $ limit field in the Vendor Item file.
VIT_Upload_other_ dlr_limit	numeric	9.2	The maximum dollar value of each detail level miscellaneous charge for the item on the PO. From the Upload other $ limit field in the Vendor Item file.
Ship_via	numeric	2	A code that represents the carrier used when shipping the item on the PO to your company. From the Ship via field in the Vendor Item file.
POV_Description	alpha	30	A description of the PO ship via. From the Description field in the PO Ship Via file.
POV_Lead_Days	numeric	3	The number of days it takes the shipper to deliver merchandise to your company. From the POV lead days field in the PO Ship Via file.
Unit_of_measure	alpha	3	The vendor’s unit of measure for the item (for example, case of 12). From the UOM field in the Vendor Item file.
UOM_Description	alpha	30	A description of the unit of measure. From the UOM description field in the Unit of Measure file.
UOM_Units	numeric	5	The number of units represented by the unit of measure, such as 12 units in a case. From the UOM units field in the Unit of Measure file.
VIT_Country_Of_Origin	alpha	3	A code representing the country where the vendor item originated. From the VIT country of origin field in the Vendor Item file.
Country_description	alpha	30	A description of the country of origin. From the Description field in the Country file.
VIT_Freight_upload_GLNbr	numeric	8	The general ledger number to use for detail level freight charges on A/P invoices. From the Freight upload GL# field in the Vendor Item file.
VIT_Handling_ upload_GLNbr	numeric	8	The general ledger number to use for detail level handling charges on A/P invoices. From the Handling upload GL# field in the Vendor Item file.
VIT_Other_upload_ GLNbr	numeric	8	The general ledger number to use for miscellaneous charges on A/P invoices. From the Other upload GL# field in the Vendor Item file.
VITPriceBreak The VITPriceBreak element repeats for each vendor price break defined for the vendor item in the Vendor Item Price Break file.
Start_date	numeric	7	The date when the special price promotion or quantity break price begins. From the Start date field in the Vendor Item Price Break file.
Quantity	numeric	7	The quantity (in retailer’s unit of measure), that you must purchase to receive the special promotional price or quantity break price on the item from the vendor. From the Quantity field in the Vendor Item Price Break file.
Price	numeric	11.4	The vendor’s special price, per vendor’s unit of measure, for the item if you order the quantity required (in retailer’s unit of measure). From the Price field in the Vendor Item Price Break file.
Stop_date	numeric	7	The date when the special price promotion or quantity break price ends. From the Stop date field in the Vendor Item Price Break file.
VITAdditionalCharge The VITAdditionalCharge element repeats for each vendor additional charge associated with the vendor item in the Vendor Item Addl Charge file.
Charge_code	alpha	2	A code that identifies an additional charge for the item. From the Charge code field in the Vendor Item Addl Charge file.
VAC_Percent	numeric	5.2	The percent to add to the PO for each unit (in retailer’s unit of measure) of the vendor item. From the Percent field in the Vendor Item Addl Charge file.
VAC_Unit_amount	numeric	11.2	The dollar amount to add to the PO for each unit (in retailer’s unit of measure) of the vendor item. From the Unit amt field in the Vendor Item Addl Charge file.
VITNote The VITNote element repeats for each vendor item note associated with the vendor item in the Vendor Item Notes file.
VIN_Seq_Nbr	numeric	3	The sequence number assigned to the vendor item note. From the Seq # field in the Vendor Item Notes file.
VIN_Print	alpha	1	Indicates whether the vendor item note prints on the PO and/or the receiving worksheet. Valid values are: • B = Print on both PO and worksheet • P = PO only • W = Worksheet only • blank = Do not print From the Print? field in the Vendor Item Notes file.
VIN_Note	alpha	60	The note defined for the vendor item. From the Note field in the Vendor Item Notes file.
VIN_User	alpha	10	The user ID of the user who entered the vendor item note. From the User field in the Vendor Item Notes file.
VIN_Entry_date	numeric	7	The date the vendor item note was entered. From the Entry date field in the Vendor Item Notes file.
VITUserField The VITUserField element repeats for each vendor item user field associated with the vendor item in the Vendor Item User Field file.
VIT_UDF_Sequence_Nbr	numeric	3	The sequence number assigned to the vendor item user field. From the Seq# field in the Vendor Item User Field file.
VIT_UDF_Text	alpha	30	The text defined for the vendor item user field. From the Text field in the Vendor Item User Field file.
VIT_UDF_Number	numeric	16	The number defined for the vendor item user field. From the Number field in the Vendor Item User Field file.
VIT_UDF_Date	numeric	7	The date defined for the vendor item user field. From the Date field in the Vendor Item User Field file.
VIT_UDF_Display_ sequence	numeric	3	The sequence number assigned to the vendor item user field, controlling its placement on the screen. From the Display sequence field in the Vendor Item User Field file.
VIT_UDF_File_code	alpha	3	The code representing the file to which the user-defined field is linked. For vendor item user fields, the file code is VIT. From the VIT UDF file code field in the Vendor Item User Field file.
UDD_Field_label	alpha	15	The field label that appears on a screen for the vendor item user field. From the Field label field in the User Defined Field Detail file.
UDD_Field_type	alpha	1	A code that identifies the type of field. D = Date field. N = Number field. T = Text field. From the Field type field in the User Defined Field Detail file.
UDD_Field_usage	alpha	1	A code that identifies whether you are collecting the field information for the user-defined field. I (Input): you can enter information in this field. O (output): you cannot enter information in this field. From the Field usage field in the User Defined Field Detail file.
SKUOffer The SKUOffer element repeats for each SKU offer record defined for the SKU in the SKU Offer file.
Offer_Number	alpha	3	A code that represents the offer where the SKU is advertised. From the Offer number field in the SKU Offer file.
Cost	numeric	7.2	The cost to include the SKU in the offer. From the Cost field in the SKU Offer file.
Expected_return_pct	numeric	5.2	The percentage of returns you expect to receive for the SKU in the offer. From the Expected return pct field in the SKU Offer file.
Gift_wrap_flag	alpha	1	Indicates if the SKU is eligible for gift wrap. Y = The SKU is eligible for gift wrap. N = The SKU is not eligible for gift wrap. From the G/W flag field in the SKU Offer file.
Page_Nbr	numeric	5	The primary page number where the SKU displays in the offer. From the Page # field in the SKU Offer file.
Projected_units	numeric	7	The number of units of the SKU expected to sell in the offer. From the Projected units field in the SKU Offer file.
SH_price	numeric	7.2	The price to charge the customer for special handling. From the S/H price field in the SKU Offer file.
Special_handling_ flag	alpha	1	Indicates if the SKU is eligible for any type of special handling in the offer. Y = The SKU is eligible for special handling. N = The SKU is not eligible for special handling. From the S/H flag field in the SKU Offer file.
Square_inches	numeric	5.2	The square inches that the SKU occupies on the catalog page in the offer. From the Square inches field in the SKU Offer file.
Term_payment_ interval	numeric	5	The number of days between payments. From the Term payment interval field in the SKU Offer file.
Gift_wrap_price	numeric	7.2	The price for gift wrapping the SKU. From the G/W price field in the SKU Offer file.
Freight	numeric	6.2	The freight amount to charge for the SKU in the offer. From the Freight field in the SKU Offer file.
Hidden_freight	numeric	6.2	The hidden freight amount to charge for the SKU in the offer. From the Hidden freight field in the SKU Offer file.
SKO_Coupon_ discount_dlr	numeric	7.2	The coupon dollar amount that is subtracted from the price when the SKU is ordered in the offer. From the Coupon discount $ field in the SKU Offer file.
SKO_Coupon_ effective_date	numeric	7	The date the coupon becomes effective. From the Coupon effective field in the SKU Offer file.
SKO_Volume_ discountable	alpha	1	Indicates if the SKU is eligible for a volume discount. Y = The SKU is eligible for a volume discount. N = The SKU is not eligible for a volume discount. From the Volume disc? field in the SKU Offer file.
SKO_Spread	alpha	3	The spread of the SKU in the offer. From the SKO spread field in the SKU Offer file.
SKO_Featureoption	alpha	1	A code that indicates if the SKU is considered a featured item in a depiction in the offer. F = The SKU is a featured item in the depiction. O = The SKU is an optional item in the depiction. From the Feature/option field in the SKU Offer file.
SKO_Pickupnew	alpha	1	A code that indicates if the SKU has been carried over from a previous offer or is new to your product offerings. P = The SKU is a pickup item, previously sold in an offer. N = The SKU is a new addition to your offer. From the Pickup/new field in the SKU Offer file.
SKO_Sale_Book_ Item_Flag	alpha	1	Indicates if the SKU is on sale in the offer. Y = The SKU is a sale item. N = The SKU is not a sale item. From the SKO sale book item flag field in the SKU Offer file. This flag controls whether to generate a sale credit when the customer returns the item, based also on the payment method and the setting of the Generate Sale Credit for Orders with Sale Items (I64) system control value. If the Exclude Sale Item When Prorating Discounts (I65) system control value is set to Y, this flag controls whether the item is included in prorated discounts or is included when determining whether an order qualifies for a promotion. See the system control value for more information.
SKO_Qty_Break_Upsl_Thrshd	numeric	7	From the SKO qty break upsl thrshd field in the SKU Offer file.
SKO_Warranty_Item	alpha	1	Indicates if the SKU is a warranty item in the offer. Y = The SKU is a warranty item. N = The SKU is not a warranty item. From the SKO warranty item? field in the SKU Offer file.
SKO_Required_Add_Reason	alpha	1	Indicates if an add reason code is required when the SKU in the offer is added to an order. Y = An add reason code is required. N = An add reason code is not required. From the SKO required add reason? field in the SKU Offer file.
SKO_Included_ Internet_Ofr	alpha	1	From the SKO future use Y/N 1 field in the SKU Offer file.
CRV_Code	numeric	3	A code that represents the SKU’s expected selling pattern in the offer. From the CRV code field in the SKU Offer file.
CRV_Description	alpha	30	A description of the curve. From the Description field in the Curve file.
CRV_Curve_type	alpha	1	A user-defined code used to group projection curves. From the Curve type field in the Curve file.
ADD_Addl_chg_code	alpha	2	The additional charge code associated with the type of special handling you are offering for the SKU. From the ADD add’l chg code field in the SKU Offer file.
ADD_Description	alpha	30	A description of the additional charge. From the ADD description field in the Additional Charge file.
SHF_Code	alpha	2	The special handling format code assigned to the additional charge code. From the SHF code field in the Additional Charge file.
SHF_Description	alpha	30	A description of the special handling format. From the Description field in the Special Format file.
SKO_AOC_Add-On_Code	alpha	3	From the SKO AOC add-on code field in the SKU Offer file.
SKUPrice The SKUPrice element repeats for each SKU price record defined for the SKU in the SKU Price file.
Effective_date	numeric	7	The date the price or quantity break becomes valid. From the Effective date field in the SKU Price file.
Qty	numeric	7	The amount of the SKU the customer must order to receive the discounted price. From the Qty field in the SKU Price file.
Associate_price	numeric	7.2	The price at which the SKU will be sold in the offer to associate customers. From the Associate price field in the SKU Price file.
Price	numeric	7.2	The price at which the SKU will be sold in the offer. From the Price field in the SKU Price file.
SKP_Price_column	numeric	2	The pricing column associated with the price. From the Price column field in the SKU Price file.
SKP_Associate_tax_price	numeric	7.2	The price at which the SKU will be sold to associate customers on orders subject to tax-inclusive pricing and VAT. From the Tax inclusive associate price field in the SKU Price file.
SKP_Tax_price	numeric	7.2	The price at which the SKU will be sold on orders subject to tax-inclusive pricing and VAT. From the Tax incl price field in the SKU Price file.
SKP_No_Charge	alpha	1	Indicates if the SKU is sold at no charge. Y = The SKU is sold at no charge. N = The SKU is sold for a price. From the SKP no charge? field in the SKU Price file.
SKUOfferPage The SKUOfferPage element repeats for each SKU offer page record defined for the SKU in the SKU Offer Page file.
Page_Nbr	numeric	5	The page number where the SKU displays in the catalog. From the Page # field in the SKU Offer Page file.
Alias_item	alpha	12	The alternate item code for the SKU. From the Alias item field in the SKU Offer Page file.
SKOAccompanyingItem The SKOAccompanyingItem element repeats for each accompanying item record defined for the SKU in the Accompanying Item file.
ACI_Qty_required	numeric	5	The amount of the SKU that must be ordered to receive the accompanying item. From the Qty req’d field in the Accompanying Item file.
ACI_Qty	numeric	5	The number of accompanying items to add to the order. From the Qty field in the Accompanying Item file.
ACI_Free_gift	alpha	1	Indicates if the accompanying item is a free gift. Y = The accompanying item is a free gift. N = The accompanying item is not free of charge. From the Free gift? field in the Accompanying Item file.
ACI_Use_Ordered_ Qty	alpha	1	Indicates if the accompanying item is ordered in the same quantity as the qualifying item. Y = The accompanying item is ordered in the same quantity as the qualifying item. N = The accompanying item is not ordered in the same quantity as the qualifying item. From the ACI use ordered qty? field in the Accompanying Item file.
ACI_ITM_Number	alpha	12	The accompanying item to add to the order if the customer orders the required quantity of the qualifying item. From the ACI ITM number field in the Accompanying Item file.
ACI_SKU_Code	alpha	14	The SKU of the accompanying item. From the ACI SKU code field in the Accompanying Item file.
SKOUserField The SKOUserField element repeats for each SKU offer user field record defined for the SKU in the SKU Offer User Field file.
SKO_UDF_ Sequence_Nbr	numeric	3	The sequence number assigned to the SKU offer user field. From the Seq# field in the SKU Offer User Field file.
SKO_UDF_Text	alpha	30	The text defined for the SKU offer user field. From the Text field in the SKU Offer User Field file.
SKO_UDF_Number	numeric	16	The number defined for the SKU offer user field. From the Number field in the SKU Offer User Field file.
SKO_UDF_Date	numeric	7	The date defined for the SKU offer user field. From the Date field in the SKU Offer User Field file.
SKO_UDF_ Display_sequence	numeric	3	The display sequence number assigned to the SKU offer user field. From the Display sequence field in the SKU Offer User Field file.
SKO_UDF_File_ code	alpha	3	The code representing the file to which the user-defined field is linked. For SKU offer user fields, the file code is SKO. From the ITW UDF file code field in the Item Warehouse User Field file.
UDD_Field_label	alpha	15	The field label that appears on a screen for the SKU offer user field. From the Field label field in the User Defined Field Detail file.
UDD_Field_type	alpha	1	A code that identifies the type of field. D = Date field. N = Number field. T = Text field. From the Field type field in the User Defined Field Detail file.
UDD_Field_usage	alpha	1	A code that identifies whether you are collecting the field information for the user-defined field. I (Input): you can enter information in this field. O (output): you cannot enter information in this field. From the Field usage field in the User Defined Field Detail file.
SKOSpecialHandlingDetail The SKOSpecialHandlingDetail element repeats for each special format detail record defined for the SKU offer in the Special Format Details file.
SFD_Seq_Nbr	numeric	3	The sequence number assigned to the special format detail. From the SFD seq # field in the Special Format Details file.
SFD_Display_Seq	numeric	3	The display sequence number assigned to the special format detail. From the SFD display seq field in the Special Format Details file.
SFD_Prompt_Text	alpha	15	The name of the input field for the special format detail. From the SFD prompt text field in the Special Format Details file.
SFD_Required_field	alpha	1	Indicates if the special format detail input field is required. Y = The special format detail is required. N = The special format detail is not required. From the SFD required field field in the Special Format Details file.
SFD_Feature_ options	alpha	1	Indicates if the special format detail input field is a feature option. A feature option is an extra feature that can be added to the item. From the SFD feature options field in the Special Format Details file.
SFD_Default_value	alpha	45	The special format detail default value. From the Default value field in the Special Format Details file.
SFD_Default_charge_dlr	numeric	7.2	The price to charge the customer for the special format detail. From the SFD default charge $ field in the Special Format Details file.
SFD_Default_ charge_Pct	numeric	5.2	The percentage used to calculate the price to charge the customer for the special format detail. From the SFD default charge % field in the Special Format Details file.
SFD_Default_cost_ dlr	numeric	11.4	The cost of the special format detail. From the SFD default cost $ field in the Special Format Details file.
SFD_Default_cost_ Pct	numeric	5.2	The percentage used to calculate the cost of the special format detail. From the SFD default cost % field in the Special Format Details file.
SFD_Default_text	alpha	2	A code that allows you to select text from the customer record to default onto the special format detail. From the SFD default text field in the Special Format Details file.
SFD_Max_Nbr_ characters	numeric	2	The maximum number of characters allowed for the special format detail. From the SFD max # characters field in the Special Format Details file.
SFD_Cross_ Reference	alpha	3	A code used to cross reference the special format detail with the element’s code on the manufacturing system. From the SFD cross reference field in the Special Format Details file.
SKOSpecialHandlingResponse The SKOSpecialHandlingResponse element repeats for each special format response record defined for the SKU offer in the Special Format Responses file.
SFD_Seq_Nbr	numeric	3	The sequence number assigned to the special format response. From the SFD seq # field in the Special Format Responses file.
SFR_Valid_response	alpha	45	A code for a valid special format response. From the Valid response field in the Special Format Response file.
SFR_Description	alpha	45	A description of the special format response. From the SFR description field in the Special Format Response file.
SKUItemInformation The SKUItemInformation element repeats for each SKU item information record defined for the SKU in the Item Information file.
Template	alpha	2	The type of template for item information. CS = Customer Service PC = Product Comments PO = Purchase Orders QC = Quality Control RP = Reporting (E-Commerce) From the Template field in the Item Class Template file.
Sequence_Nbr	numeric	3	The sequence number assigned to the item class template. From the Seq # field in the Item Class Template file.
Heading	alpha	20	A description of the item class template. From the Heading field in the Item Class Template file.
Lines_available	numeric	3	The number of lines available in the template for the entry of information. From the Lines available field in the Item Class Template file.
SKUItemInformationDetail The SKUItemInformationDetails element repeats for each item information detail defined for the SKU in the Item Information file. Note: The system includes SKUItemInformationDetail only if the Item information field in the Item Information file contains a value.
Sequence_Nbr	numeric	3	The sequence number assigned to the item information. From the Seq # field in the Item Information file.
Item_information_ Line	alpha	50	A line of item information. From the Item information field in the Item Information file.
ItemWarehouse The ItemWarehouse element repeats for each item warehouse defined for the SKU in the Item Warehouse file.
Warehouse	numeric	3	A code that represents a warehouse or retail store. From the Whs field in the Item Warehouse file.
Allocation_freeze	alpha	1	Indicates whether the SKU in the warehouse is frozen. Y = The SKU warehouse is frozen. N = The SKU warehouse is not frozen. From the Allocation freeze field in the Item Warehouse file.
Economic_order_qty	numeric	7	The recommended optimum ordering quantity for the SKU. From the Economic order qty field in the Item Warehouse file.
Max_qty	numeric	7	The maximum number of units to be kept on hand in the warehouse. From the Max qty field in the Item Warehouse file.
Min_qty	numeric	7	The minimum number of units to be kept on hand in the warehouse. From the Min qty field in the Item Warehouse file.
Protected_qty	numeric	7	The unit quantity of the SKU protected from reservation. From the Protected qty field in the Item Warehouse file.
Reorder_qty	numeric	7	The quantity of the SKU that should be replenished when the SKU reaches the minimum stock level for the warehouse. From the Reorder qty field in the Item Warehouse file.
ITW_Original_ retail_price	numeric	7.2	The original price of the SKU in the retail store. From the ITW original retail price field in the Item Warehouse file.
ITW_Current_ retail_price	numeric	7.2	The current price of the SKU in the retail store. From the ITW current retail price field in the Item Warehouse file.
ITW_Protect_ current_price	alpha	1	Indicates whether the system overrides the price defined in the Current retail price field when you change the retail price. Y = The system keeps the existing current retail price defined for the item warehouse. N = The system updates the current retail price defined for the item warehouse. From the ITW protect current price field in the Item Warehouse file.
ITW_Protect_ MinMax	alpha	1	Indicates whether the system overrides the minimum or maximum quantity when you change the minimum or maximum quantity in Working with Item Warehouse Values (WIWV). Y = The system does not update the minimum or maximum quantity defined for the item warehouse. N = The system updates the minimum or maximum quantity defined for the item warehouse. From the ITW protect min/max field in the Item Warehouse file.
ITW_User_field_1	alpha	10	A user-defined field for the item warehouse. From the ITW user field 1 field in the Item Warehouse file.
ITW_User_field_2	alpha	10	A user-defined field for the item warehouse. From the ITW user field 2 field in the Item Warehouse file.
ITWUserField The ITWUserField element repeats for each item user field associated with the SKU in the Item Warehouse User Field file.
ITW_UDF_ Sequence_Nbr	numeric	3	The sequence number assigned to the item warehouse user field. From the Seq# field in the Item Warehouse User Field file.
ITW_UDF_Text	alpha	30	The text defined for the item warehouse user field. From the Text field in the Item Warehouse User Field file.
ITW_UDF_Number	numeric	16	The number defined for the item warehouse user field. From the Number field in the Item Warehouse User Field file.
ITW_UDF_Date	numeric	7	The date defined for the item warehouse user field. From the Date field in the Item Warehouse User Field file.
ITW_UDF_ Display_sequence	numeric	3	The sequence number assigned to the item warehouse user field, controlling its placement on the screen. From the Display sequence field in the Item Warehouse User Field file.
ITW_UDF_ File_code	alpha	3	The code representing the file to which the user-defined field is linked. For item warehouse user fields, the file code is ITW. From the ITW UDF file code field in the Item Warehouse User Field file.
UDD_Field_label	alpha	15	The field label that appears on a screen for the vendor item user field. From the Field label field in the User Defined Field Detail file.
UDD_Field_type	alpha	1	A code that identifies the type of field. D = Date field. N = Number field. T = Text field. From the Field type field in the User Defined Field Detail file.
UDD_Field_usage	alpha	1	A code that identifies whether you are collecting the field information for the user-defined field. I (Input): you can enter information in this field. O (output): you cannot enter information in this field. From the Field usage field in the User Defined Field Detail file.
ContinuityItems The ContinuityItems element and its child, ContinuityItem, display only if the item is defined as a continuity item (the Kit_type attribute is set to C).
CNH_Charge_type	alpha	1	A code that represents how the customer is charged. 1 = First shipment only: the order line with the continuity set item on it has the price. 2 = Each shipment: each order line will have a price. From the CNH charge type field in the Continuity Header file.
CNH_Interval_type	alpha	1	A code that represents the interval or time between delivery of continuity component items. D = Days M = Months From the CNH interval type field in the Continuity Header file.
ContinuityItem The ContinuityItem element repeats for each continuity item defined for the SKU in the Continuity Details file.
CND_Seq_Nbr	numeric	3	The sequence number assigned to the continuity detail. From the Seq# field in the Continuity Details file.
CND_Interval_ Nbr	numeric	5	Determines when the item/SKU should be shipped; for example, the first shipment is interval 1, the second shipment is interval 2. From the CND interval # field in the Continuity Details file.
CND_Coordinate_ group	numeric	3	Group number assigned to certain component items in the continuity program to ensure that they ship together. From the CND coordinate group field in the Continuity Details file.
CND_Qty	numeric	5	The number of units of the item that are included in the continuity program. From the CND qty field in the Continuity Details file.
CND_Detail_ITM_ Number	alpha	12	The item to be included as a component of the continuity set item. From the CND detail ITM number field in the Continuity Details file.
SKU_Code	alpha	14	The SKU to be included as a component of the continuity set item. From the SKU code field in the Continuity Details file.
FinishedGood The FinishedGood element displays only if the item is defined as a finished good item (the Kit_type attribute is set to F). The FinishedGood element repeats for each finished good component defined for the SKU in the Kit Details file.
SeqNbr	numeric	5	The sequence number assigned to the kit detail. From the Seq# field in the Kit Detail file.
Qty	numeric	5	The number of items that are used to make up the finished good. From the Qty field in the Kit Detail file.
Kit_Comp_ITM_ Number	alpha	12	A component item that makes up the finished good. From the Kit comp ITM number field in the Kit Detail file.
Kit_Comp_SKU_ Code	alpha	14	The SKU of the component item that makes up the finished good. From the Kit comp SKU code field in the Kit Detail file.
Sets The Set element displays only if the item is defined as a set item (the Kit_type attribute is set to S).
SET_pricing_type	numeric	1	Indicates whether to charge the customer separately for each set component or include the full pricing for the set master. Valid values are: • 1 = Price at set master: Add the set item to orders with the price at the component level, and add the components at “no charge.” • 2 = Price at component: Add the set item to orders with the set master at “no charge,” and with prices for each component, using the Price % indicated. Available in XML version: 4.0 (version 10.0 of CWDirect). See Component Pricing Calculation for Sets for a discussion.
SetItem The SetItem element repeats for each set component defined for the SKU in the Set Details file.
SeqNbr	numeric	3	The sequence number assigned to the set detail. From the Seq# field in the Set Details file.
Coordinate_group	numeric	3	Group number assigned to set component items to ensure that they ship together. From the Coordinate group field in the Set Details file.
Pct_of_price	numeric	5.2	The percentage of the total set price to charge for this item if the set has pricing at the component level. From the % of cost field in the Set Details file. Available in XML version: 4.0 (version 10.0 of CWDirect). Note: Before version 4.0 of this message, this was the pct_of_cost attribute.
Qty	numeric	5	The number of units of the item to include in one set. From the Qty field in the Set Details file.
Set_Comp_ITM_ Number	alpha	12	A component item of the set item. From the Set comp ITM number field in the Set Details file.
Set_Comp_SKU_ Code	alpha	14	The SKU of the component item. From the Set comp SKU code field in the Set Details file.
VariableSet The VariableSet element and its children, VariableSetGroup and VariableSetItem, displays only if the SKU is defined as a variable set (the Kit_type attribute is set to V).
VSE_Create_ coord_group	alpha	1	From the Create coord group? field in the Variable Set file.
VariableSetGroup The VariableSetGroup element repeats for each variable set group defined for the SKU in the Variable Set Group file.
Group	numeric	3	A code that represents a group containing items offered in the variable set. From the Group field in the Variable Set Group file.
Description	alpha	30	A description of the variable set group. From the Description field in the Variable Set Group file.
Nbr_of_items	numeric	3	The number of units the customer must order from the group. From the # of items field in the Variable Set Group file.
VariableSetItem The VariableSetItem element repeats for each variable set component defined for the SKU in the Variable Set Details file.
SeqNbr	numeric	3	The sequence number assigned to the variable set detail. From the Seq# field in the Variable Set Details file.
Var_comp_ITM_ Number	alpha	12	A component item of the variable set item. From the Var comp ITM number field in the Variable Set Details file.
Var_comp_SKU_ Code	alpha	14	The SKU of the component item. From the Var comp SKU code field in the Variable Set Details file.
SKUComment The SKUComment element repeats for each SKU comment defined for the SKU in the SKU Comments file.
Seq_Nbr	numeric	3	The sequence number assigned to the SKU comment. From the Seq # field in the SKU Comments file.
Comment_line	alpha	50	A line of SKU comments. From the Comment field in the SKU Comments file.
Print_code	alpha	1	Indicates where to print or display the SKU comments. B = Both pick slip and invoice. I = Invoice N = Nowhere P = Pick slip R or blank = Catalog planning analysis reports W = pop-up window when you order the item From the Print code field in the SKU Comments file.
SKUAttribute The SKUAttribute element repeats for each SKU attribute defined for the SKU in the Item Attribute file.
IAT_Type	alpha	6	A code that identifies a SKU attribute. From the Type field in the Item Attribute file.
IAT_Description	alpha	30	A description of the SKU attribute type. From the Description field in the Item Attribute file.
IAV_Value	alpha	6	A code that identifies an attribute value. From the Value field in the Item Attribute Value file.
IAV_Description	alpha	30	A description of the attribute value. From the Description field in the Item Attribute Value file.
IAA_Affinity_flag	alpha	1	Determines how the system tracks the customer affinity preferences for the SKU. U = Upsell only. Upsell the SKU to a customer flagged with the attribute value. C = Capture only. When the customer orders the SKU, the customer’s affinity preference history is updated. B = Both upsell and capture. N = Neither upsell nor capture. From the Affinity flag field in the Item Attribute Assignment file.
UPC The UPC element repeats for each UPC code defined for the SKU in the Item UPC file.
UPC_Type	alpha	3	The type of UPC code. The UPC type determines the type of validation performed against the UPC code. E13: EAN-13 E8: EAN-8 UA: UPC-A UE: UPC-E From the UPC type field in the Item UPC file.
UPC	numeric	14	The UPC code defined for the SKU. From the UPC field in the Item UPC file.
UPC_VND_Vendor	numeric	7	The supplier who sells you merchandise. From the UPC VND vendor nbr field in the Item UPC file.
SKUUserField The SKUUserField element repeats for each SKU user field defined for the SKU in the SKU User Field file.
SKU_UDF_ Sequence_Nbr	numeric	3	The sequence number assigned to the SKU user field. From the Seq# field in the SKU User Field file.
SKU_UDF_Text	alpha	30	The text defined for the SKU user field. From the Text field in the SKU User Field file.
SKU_UDF_ Number	numeric	16	The number defined for the SKU user field. From the Number field in the SKU User Field file.
SKU_UDF_Date	numeric	7	The date defined for the SKU user field. From the Date field in the SKU User Field file.
SKU_UDF_ Display_sequence	numeric	3	The sequence number assigned to the SKU user field, controlling its placement on the screen. From the Display sequence field in the SKU User Field file.
SKU_UDF_File_ code	alpha	3	The code representing the file to which the user-defined field is linked. For SKU user fields, the file code is SKU. From the SKU UDF file code field in the SKU User Field file.
UDD_Field_label	alpha	15	The field label that appears on a screen for the SKU user field. From the Field label field in the User Defined Field Detail file.
UDD_Field_type	alpha	1	A code that identifies the type of field. D = Date field. N = Number field. T = Text field. From the Field type field in the User Defined Field Detail file.
UDD_Field_usage	alpha	1	A code that identifies whether you are collecting the field information for the user-defined field. I (Input): you can enter information in this field. O (output): you cannot enter information in this field. From the Field usage field in the User Defined Field Detail file.
SKUCrossReference The SKUCrossReference element repeats for each SKU cross reference for the SKU in the SKU Cross Reference file. Available in XML version: 5.0 (version 10.5 of CWDirect). For more information: See Work with SKU Cross Reference Type Screen for a discussion.
sku_xref_nbr	alpha	30	A cross reference number used to identify the SKU in an external system, such as a retail store. From the SKU Cross Reference file. Available in XML version: 5.0 (version 10.5 of CWDirect).
sku_xref_type	alpha	4	A code used to identify the origin of the SKU cross reference number, and to indicate whether you can add the item/SKU to the order by entering the SKU cross reference number. Available in XML version: 5.0 (version 10.5 of CWDirect).

Item Download Message: Sample XML

A sample of the Item Download XML Message (CWITEMOUT) is presented below.

<Items>

</ItemPrices>

</ItemOffer>

</ItemOffers>

</ItemInformationDetails>

</ItemInformation>

</ItemInformationDetails>

</ItemInformation>

</ItemInformationDetails>

</ItemInformation>

</ItemInformationDetails>

</ItemInformation>

</ItemInformations>

</ItemAttributes>

</VendorItems>

</SKUPrices>

</SKUOffer>

</SKUOffers>

</SKUItemInformationDetails>

</SKUItemInformation>

</SKUItemInformationDetails>

</SKUItemInformation>

</SKUItemInformationDetails>

</SKUItemInformation>

</SKUItemInformationDetails>

</SKUItemInformation>

</SKUItemInformations>

</ItemWarehouses>

<UPCs>

</UPCs>

</SKU>

</Item>

</Items>

</Message>

Chapter 110: Generic Inventory Transaction Upload

Contents

SCVs

Search

Glossary

Reports

XML

Index

Chapter 112: Generic Vendor Download API

ST01_03 CWDirect 18.0 August 2015 OTN