Generic Item Download API

Generic Item Download API

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

Integration with Oracle Retail Order Broker: You would typically use the Oracle Retail Order Broker’s Product, Product Location, and Incremental Inventory Import Process as an efficient means to send item and SKU information from Order Management System to Oracle Retail Order Broker; however, it is also possible to use the generic item download API.

The generic item download API does not check an item’s OROB eligible flag when determining whether to download information on the item.

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

• Order Management System Setup for the Item Download API

- 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 table 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 table 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 table at the Work with Outbound Interface Transactions Screen.

Each trigger in the IL Outbound Trigger table 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 table.

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

• If this system control value is unselected, the system does not create item download triggers in the IL Outbound Trigger table.

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 F (finished good kit).

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

4. 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
204C	F	4
204F	F	5
204B	S	6
204G	S	7
204D	V	8
204E	V	9

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 Order Management System 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 Outbound delay time.

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 Order Management System 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 Order Management System user ID and password to access the Order Management System 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 selected). See Outbound Interface Queues.

Item Outbound Trigger Activities

This table indicates:

• which Order Management System activities create an item download trigger.

• which table 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’d items, the system includes 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 removes any duplicates before generating an Item Download XML Message (CWItemOut).

You can review the item download triggers in the IL Outbound Trigger table 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 from the Item Outbound trigger rules; see Item Outbound Trigger Rules.

Activity	Menu Option	Referenced table	Trigger Type
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
Create SKUs for an item using the SKU Generator Note: The system creates a separate trigger for each SKU generated.	ESKG	SKU	A
Delete an item	MITM	Item	D
Delete a SKU	MITM	SKU	D
Delete SKUs for an item Note: The system creates a separate trigger for each SKU deleted.	MDLT	SKU	D
Purge SKUs Note: The system creates a separate trigger for each SKU purged.	MPSK	SKU	D
Change an item	MITM	Item	C
Change a SKU	MITM	SKU	C
Create or update item comments	MITM	SKU Comment	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 an item coordinate Note: The system creates a separate trigger for each SKU.	MITM	Item Coordinate	C
Create or delete a keyword Note: The system creates a separate trigger for each SKU.	MITM WKEY	Keyword	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
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
Create, change, or delete an item tax exemption Note: The system creates a separate trigger for each SKU.	WITX	Item Tax Exempt	C
Create, change, or delete a freight exempt item Note: The system creates a separate trigger for each SKU.	WFEI	Freight Exemption	C
Resequence the SKU collating sequence number Note: The system creates a separate trigger for each SKU that has been resequenced.	RSCS	SKU	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
Create an item warehouse by copying an existing warehouse Note: The system creates a separate trigger for each item warehouse created.	MCIW	Item Warehouse	C
Update item warehouse values Note: The system creates a separate trigger for each item warehouse updated.	WIWV	Item Warehouse	C
Receive inventory Note: The system creates a separate trigger for each SKU received.	PORC	Item Warehouse	C
Change or delete an item warehouse user field	MITM	Item Warehouse	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
Add, change, or delete a set or set component	MITM WSET	Set Set Detail	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
Assign, change, or delete an item UPC code	MITM	Item UPC	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
Generate item download triggers	GOIT	IL Outbound Trigger	C
Update a harmonize code Note: The system creates a separate trigger for each SKU.	UPHC	Item	C
Process a finished good work order	WWOR	Work Order Header Work Order Detail	C
Reset SKU Open Order Quantity	MRSO	SKU table	C
Update Standard Cost	MSCC	SKU table	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 special format detail or response associated with the custom special handling code that is assigned to an item offer.	WSHF	Special Format Details	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
Maintain an item/SKU/offer	CPIM	Item SKU SKU Offer	C
Copy SKU/Offer records 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
Copy SKU Offer information Note: The system creates a trigger for each item/SKU assigned to the new offer.	MCSO	Item Offer SKU Offer	C
Maintain item offers	MIOF	Item Offer Item	C
Create item/SKU offer	MISO	Item Offer SKU Offer	C
Initialize offer	MOFI	Item Offer SKU Offer	C
Update SKU offer prices	MUSK	SKU Offer	C
Work with coordinates by offer	WCIO	Item Coordinate	C
Submit an item/SKU offer upload	WISU	Item Offer SKU Offer	C
Submit item offer overrides by class	WSOI	Item Offer	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 table and SKU table 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 table criteria	SKU table 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/Table Listing to review field attributes for the Item table and SKU table.

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 table:

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 table 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 table 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 table:

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 table.
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 table (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
Selected = Include Item Unselected = Exclude Item and all of its children; the system sends a message with only the Message element and its attributes	Item
Selected = Include ItemOffer and its parent Item Unselected = Exclude ItemOffer and its children ItemPrice, PageLetterAlias, IOFAccompanyingItem, IOFUserField, IOFSpecialHandlingDetail and IOFSpecialHandlingResponse		ItemOffer
Selected = Include ItemPrice and its parents, ItemOffer and Item Unselected = Exclude ItemPrice			ItemPrice
Selected = Include PageLetterAlias and its parents ItemOffer and Item Unselected = Exclude PageLetterAlias			PageLetterAlias
Selected = Include IOFAccompanyingItem and its parents ItemOffer and Item Unselected = Exclude IOFAccompanyingItem			IOFAccompanyingItem
Selected = Include IOFUserField and its parents ItemOffer and Item Unselected = Exclude IOFUserField			IOFUserField
Selected = Include IOFSpecialHandlingDetail and its parents ItemOffer and Item Unselected = Exclude IOFSpecialHandlingDetail and its child IOFSpecialHandlingResponse			IOFSpecialHandlingDetail
Selected = Include IOFSpecialHandlingResponse and its parents IOFSpecialHandlingDetail, ItemOffer, and Item Unselected = Exclude IOFSpecialHandlingResponse				IOFSpecialHandlingResponse
Selected = Include ItemComment and its parent Item Unselected = Exclude ItemComment		ItemComment
Selected = Include ItemAttribute and its parent Item Unselected = Exclude ItemAttribute		ItemAttribute
Selected = Include SourcePrice and its parent Item Unselected = Exclude SourcePrice		SourcePrice
Selected = Include Coordinate and its parent Item Unselected = Exclude Coordinate		Coordinate
Selected = Include Keyword and its parent Item Unselected = Exclude Keyword		Keyword
Selected = Include Image and its parent Item Unselected = Exclude Image		Image
Selected = Include Restriction and its parent Item Unselected = Exclude Restriction		Restriction
Selected = Include ITMUserField and its parent Item Unselected = Exclude ITMUserField		ITMUserField
Selected = Include TaxExemption and its parent Item Unselected = Exclude TaxExemption		TaxExemption
Selected = Include FreightExemption and its parent Item Unselected = Exclude FreightExemption		FreightExemption
Selected = Include SKU and its parent Item Unselected = Exclude SKU and all of its children VendorItem, SKUItemInformation, ItemWarehouse, FinishedGood, SetItem, VariableSet, SKUComment, SKUAttribute, UPC, SKUUserField		SKU
Selected = Include VendorItem and its parents SKU and Item Unselected = Exclude VendorItem and its children VITPriceBreak, VITAdditionalCharge, VITNote, and VITUserField			VendorItem
Selected = Include VITPriceBreak and its parents VendorItem, SKU, and Item Unselected = Exclude VITPriceBreak				VITPriceBreak
Selected = Include VITAdditionalCharge and its parents VendorItem, SKU, and Item Unselected = Exclude VITAdditionalCharge				VITAdditionalCharges
Selected = Include VITNote and its parents VendorItem, SKU, and Item Unselected = Exclude VITNote				VITNote
Selected = Include VITUserField and its parents VendorItem, SKU, and Item Unselected = Exclude VITUserField				VITUserField
Selected = Include SKUOffer and its parents SKU and Item Unselected = Exclude SKUOffer and its children SKUPrice, SKUOfferPage, SKOAccompanyingItem, SKOUserField, and SKOSpecialHandlingDetail			SKUOffer
Selected = Include SKUPrice and its parents SKUOffer, SKU and Item Unselected = Exclude SKUOfferPage				SKUPrice
Selected = Include SKUOfferPage and its parents SKUOffer, SKU, and Item Unselected = Exclude SKUOfferPage				SKUOfferPage
Selected = Include SKOAccompanyingItem and its parents SKUOffer, SKU, and Item Unselected = Exclude SKOAccompanyingItem				SKOAccompanyingItem
Selected = Include SKOUserField and its parents SKUOffer, SKU, and Item Unselected = Exclude SKOUserField				SKOUserField
Selected = Include SKOSpecialHandlingDetail and its parents SKUOffer, SKU, and Item Unselected = Exclude SKOSpecialHandlingDetail and its child SKOSpecialHandlingResponse				SKOSpecialHandlingDetail
Selected = Include SKOSpecialHandlingResponse and its parents SKOSpecialHandlingDetail, SKUOffer, SKU, and Item Unselected = Exclude SKOSpecialHandlingResponse					SKOSpecialHandlingResponse
Selected = Include SKUItemInformation and its parents SKU and Item Unselected = Exclude SKUItemInformation and its child SKUItemInformationDetail			SKUItemInformation
Selected = Include SKUItemInformationDetail and its parents SKUItemInformation, SKU, and Item Unselected = Exclude SKUItemInformationDetail				SKUItemInformationDetail
Selected = Include ItemWarehouse and its parents SKU and Item Unselected = Exclude ItemWarehouse and its child ITWUserField			ItemWarehouse
Selected = Include ITWUserField and its parents ItemWarehouse, SKU, and Item Unselected = Exclude ITWUserField				ITWUserField
Selected = Include FinishedGood and its parents SKU and Item Unselected = Exclude FinishedGood			FinishedGood
Selected = Include SetItem and its parents SKU and Item Unselected = Exclude SetItem			SetItem
Selected = Include VariableSet and its parents SKU and Item Unselected = Exclude VariableSet and its children VariableSetGroup and VariableSetItem			VariableSet
Selected = Include VariableSetGroup and its parents VariableSet, SKU, and Item Unselected = Exclude VariableSetGroup and its child VariableSetItem				VariableSetGroup
Selected = Include VariableSetItem and its parents VariableSetGroup, VariableSet, SKU, and Item Unselected = Exclude VariableSetItem					VariableSetItem
Selected = Include SKUComment and its parents SKU and Item Unselected = Exclude SKUComment			SKUComment
Selected = Include SKUAttribute and its parents SKU and Item Unselected = Exclude SKUAttribute			SKUAttribute
Selected = Include UPC and its parents SKU and Item Unselected = Exclude UPC			UPC
Selected = Include SKUUserField and its parents SKU and Item Unselected = Exclude SKUUserField			SKUUserField

Order Management System Setup for the Item Download API

Before you can generate item download messages, you must perform the necessary Order Management System 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)	Select this field to create triggers in the IL Outbound Trigger table for certain actions in Order Management System.
Outbound Interface Trigger File Purge Days (I14)	Enter the number of days to retain records in the IL Outbound Trigger table 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. You can also use the Purge option at the Work with Outbound Interface Transactions Screen to purge records. Example: Today is 2/07, and you have set this value to 1. Any record whose Last processed date is 2/06 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 table. 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 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 Order Management System to another system, such as a retail store or warehouse management system. See Generic Item Download API for an overview.

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’d items, the SKU element does not include the SKU_Code attribute. The following elements are not included for non-SKU’d 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.

• Explicit decimal points are included in numeric fields.

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

Item elements:

SKU elements:

Item download message: See 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 Order Management System.
target	alpha	25	Identifies the target of the XML message.
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 Order Management System company where the item is located. From the Company field in the Item table.
Item_Number	alpha	12	The item number whose information you are downloading. From the Item number field in the Item table.
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 table.
Item_average_cost	numeric	11.4	The average cost of the item. From the Average cost field in the Item table.
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 table.
Drop_ship_item	alpha	1	Indicates whether you ship the item from your warehouse, or have your vendor ship it to the customer directly. • 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. • N or blank (non-drop ship) = You ship the item from your warehouse. From the Drop ship field in the Item table.
FIFO_cost	numeric	11.4	The FIFO cost of the item. From the FIFO cost field in the Item table.
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 table.
Kit_type	alpha	1	Defines the type of kit or set functionality for the item. • S = Set item • F = Finished good item • V = Variable set item From the Kit type field in the Item table.
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 table.
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 table.
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 table.
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 table. 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 table.
Partial_units	alpha	1	From the Partial units field in the Item table.
Pieces_per_case	numeric	5	Determines the number of units that fit in a case. From the Pieces per case field in the Item table.
Selling_qty	numeric	5	The required order quantity (or multiple of) for the item. From the Selling qty field in the Item table.
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 table.
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 table.
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 table.
Ship_weight	numeric	7.3	The actual shipping weight of the item. From the Ship weight field in the Item table.
Standard_cost	numeric	11.4	The standard cost of the item. From the Standard cost field in the Item table.
User_field_1	alpha	10	A user-defined field for the item. From the User field 1 field in the Item table.
User_field_2	alpha	10	A user-defined field for the item. From the User field 2 field in the Item table.
User_field_3	alpha	10	A user-defined field for the item. From the User field 3 field in the Item table.
User_field_4	alpha	10	A user-defined field for the item. From the User field 4 field in the Item table.
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 table.
Expiration_limit	numeric	5	From the Expiration limit field in the Item table.
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 table.
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 table.
CasePiece	alpha	1	From the C/P field in the Item table.
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 table.
ITM_Description	alpha	40	A description of the item. From the Description field in the Item table.
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 table.
ITM_Second_Language_Desc	alpha	40	The second language description defined for the item. From the Second language desc field in the Item table.
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 table.
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 table.
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 table.
ITM_Generic_Ecommerce	alpha	20	From the Generic ecommerce field in the Item table.
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 table.
ITM_Qty_Threshold	numeric	9	Indicates when to trigger an automatic download of item availability information to the e-commerce staging tables; from there, the information is available to the web storefront. From the Qty threshold field in the Item table.
ITM_Create_Date	numeric	7	The date the item was created. From the Create date field in the Item table.
ITM_Retail_Style_Nbr	alpha	20	A user-defined code used to identify the item. From the Retail style # field in the Item table.
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 table.
Buyer_Name	alpha	30	The name of the buyer. From the Name field in the Item table.
CTN_ID_Nbr	numeric	2	The type of carton in which the item must be shipped. From the CTN ID # field in the Item table.
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 table.
HAZ_Description	alpha	40	A description of the hazard code. From the Description field in the Hazard table.
HAZ_Class	alpha	15	A class of hazardous materials such as flammable or radioactive. From the Class field in the Hazard table.
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 table.
Item_class	alpha	3	A code that identifies a group of items. From the Item class field in the Item table.
ICL_Description	alpha	30	A description of the item class. From the Item class description field in the Item Class table.
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 table.
ICL_Estimated_Frt	numeric	7.2	Your “best guess” on the vendor’s freight charges for items 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 table.
ICL_Estimated_Frt_Pct	numeric	5.2	Your “best guess” on the vendor’s freight charges for items 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 table.
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 table.
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 table.
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 table.
ICL_Qty_Threshold	numeric	5	Indicates when to trigger an automatic download of item availability information to the e-commerce staging tables for the item class; from there, the information is available to the web storefront. From the Qty threshold field in the Item Class table.
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 table.
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 table.
SKU_group_description	alpha	40	A description of a SKU group. From the Description field in the Item SKU Group table.
Item_status	alpha	1	A code that represents an item’s status, such as discontinued or active. From the STS field in the Item table.
Item_status_description	alpha	30	A description of the item status. From the Description field in the Item Status table.
IST_Message_line_1	alpha	50	A message displayed in order entry and maintenance for items with this status code. From the IST message line 1 field in the Item Status table.
IST_Message_line_2	alpha	50	A message displayed in order entry and maintenance for items with this status code. From the IST message line 2 field in the Item Status table.
IST_Return_disposition	alpha	2	A code that identifies how to handle the returned merchandise (whether the return updates inventory). From the IST return disposition field in the Item Status table.
LCL_Location_class	alpha	2	A code that represents a location type, such as caged area. From the LCL location class field in the Item table.
LCL_Description	alpha	30	A description of the location class. From the Description field in the Location Class table.
LSD_Department	numeric	4	A code used to group items into long SKU departments for reporting purposes. From the Department field in the Item table.
LSD_Description	alpha	30	A description of the long SKU department. From the Description field in the Long SKU Department table.
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 table.
Long_SKU_Div_Description	alpha	30	A description of the long SKU division. From the Description field in the Long SKU Division table.
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 table.
LSC_Description	alpha	30	A description of the long SKU class. From the Description field in the Long SKU Class table.
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 table.
UOM_Description	alpha	30	A description of the unit of measure. From the UOM description field in the Unit of Measure table.
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 table.
Vendor_Nbr	numeric	7	A code that identifies the vendor, or supplier, of the item. From the Vendor # field in the Item table.
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 table.
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 table.
Warehouse	numeric	3	A code that represents the primary warehouse where you keep the item. From the Whs field in the Item table.
Warehouse_name	alpha	30	The name of the primary warehouse. From the Name field in the Warehouse table.
Manufacturer_Vendor	numeric	7	The vendor who manufactured the item. From the Manufacturer vendor VND V field in the Item table.
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 table.
ENT_Description	alpha	25	A description of the entity. From the ENT description field in the Entity table.
ITM_SEA_Season	alpha	3	The season associated with the item, such as spring. From the ITM SEA season field in the Item table.
SEA_description	alpha	30	A description of the season. From the Description field in the Season table.
SEA_Start_date	numeric	7	The date that indicates the beginning of the season. From the SEA start date field in the Season table.
SEA_End_date	numeric	7	The date that indicates the end of the season. From the SEA end date field in the Season table.
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 (default) = 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. • V = The item is a virtual (non-physical) stored value card.
ItemOffer			The ItemOffer element repeats for each item offer record defined for the item in the Item Offer table.
Offer_Number	alpha	3	A code that represents the offer where the item is advertised. From the Offer number field in the Item Offer table.
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 table.
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 table.
SH_price	numeric	7.2	The price to charge the customer for special handling. From the S/H price field in the Item Offer table.
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 table.
Term_payment_interval	numeric	5	The number of days between payments. From the Term payment interval field in the Item Offer table.
Standard_price	numeric	7.2	The standard price for the item in the offer. From the Standard price field in the Item Offer table.
Freight	numeric	6.2	The freight amount to charge for the item in the offer. From the Freight field in the Item Offer table.
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 table.
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 table.
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 table.
IOF_Coupon_Effective_Date	numeric	7.0	The date the coupon becomes effective. From the IOF coupon effective date field in the Item Offer table.
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 table.
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 table.
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 table.
IOF_Qty_Break_Upsl_Thrshd	numeric	5	From the IOF qty break upsl thrshd field in the Item Offer table.
IOF_Pop_Up_Message_1	alpha	30	From the IOF pop up message 1 field in the Item Offer table.
IOF_Pop_Up_Message_2	alpha	30	From the IOF pop up message 2 field in the Item Offer table.
IOF_Pop_Up_Message_3	alpha	30	From the IOF pop up message 3 field in the Item Offer table.
IOF_Pop_Up_Message_4	alpha	30	From the IOF pop up message 4 field in the Item Offer table.
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 table.
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 table.
IOF_Included_Internet_Ofr	alpha	1	From the IOF future use Y/N 1 field in the Item Offer table.
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 table.
ADD_Description	alpha	30	A description of the additional charge. From the ADD description field in the Additional Charge table.
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 table.
SHF_Description	alpha	30	A description of the custom special handling. From the Description field in the Special Format table.
IOF_AOC_Add-On_Code	alpha	3	From the IOF AOC add-on code field in the Item Offer table.
ItemPrice			The ItemPrice element repeats for each item price record defined for the item in the Item Price table.
Effective_date	numeric	7	The date the price or quantity break discount becomes valid. From the Effective date field in the Item Price table.
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 table.
Associate_price	numeric	7.2	The price at which the item is sold to associate customers. From the Associate price field in the Item Price table.
Price	numeric	7.2	The price at which the item is sold. From the Price field in the Item Price table.
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 table.
IPR_Associate_tax	numeric	7.2	The price at which the item is sold to associate customers on orders subject to tax-inclusive pricing and VAT. From the Tax inclusive associate price field in the Item Price table.
IPR_Tax_price	numeric	7.2	The price at which the item is sold on orders subject to tax-inclusive pricing and VAT. From the Tax incl price field in the Item Price table.
IPR_No_Charge	alpha	1	Indicates if the item is 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 table.
PageLetterAlias			The PageLetterAlias element repeats for each page letter alias record defined for the item offer in the Page Letter Alias table.
Seq_Nbr	numeric	3	The sequence number assigned to the page letter alias record. From the Seq # field in the Page Letter Alias table.
Page_letter	alpha	6	The letter assignment for an item in the offer. From the Page letter field in the Page Letter Alias table.
Alias_item	alpha	12	The alternate item code for the actual item. From the Alias item field in the Page Letter Alias table.
IOFAccompanyingItem			The IOFAccompanyingItem element repeats for each accompanying item record defined for the item offer in the Accompanying Item table.
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 table.
ACI_Qty	numeric	5	The number of accompanying items to add to the order. From the Qty field in the Accompanying Item table.
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 table.
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 table.
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 table.
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 table.
IOFUserField			The IOFUserField element repeats for each item offer user field record defined for the item offer in the Item Offer User Field table.
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 table.
IOF_UDF_Text	alpha	30	The text defined for the item offer user field. From the Text field in the Item Offer User Field table.
IOF_UDF_Number	numeric	16	The number defined for the item offer user field. From the Number field in the Item Offer User Field table.
IOF_UDF_Date	numeric	7	The date defined for the item offer user field. From the Date field in the Item Offer User Field table.
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 table.
IOF_UDF_File_code	alpha	3	The code representing the table 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 table.
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 table.
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 table.
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 table.
IOFSpecialHandlingDetail			The IOFSpecialHandlingDetail element repeats for each special handling detail record defined for the item offer in the Item Offer User Field table.
SFD_Seq_Nbr	numeric	3	The sequence number assigned to the special handling detail. From the SFD seq # field in the Special Format Details table.
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 table.
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 table.
SFD_Required_field	alpha	1	Indicates if the special handling detail is required. From the SFD required field in the Special Format Details table.
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 table.
SFD_Default_value	alpha	45	From the Default value field in the Special Format Details table.
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 table.
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 table.
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 table.
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 table.
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 table.
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 table.
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 table.
IOFSpecialHandlingResponse			The IOFSpecialHandlingResponse element repeats for each item information record defined for the item’s class in the Item Class Template table.
SFD_Seq_Nbr	numeric	3	The sequence number assigned to the special handling response. From the SFD seq # field in the Special Format Responses table.
SFR_Valid_response	alpha	45	A valid special handling response. From the Valid response field in the Special Format Response table.
SFR_Description	alpha	45	A description of the response. From the SFR description field in the Special Format Response table.
ItemComment			The ItemComment element repeats for each item comment defined for the item in the SKU Comments table.
Seq_Nbr	numeric	3	The sequence number assigned to the item comments. From the Seq # field in the SKU Comments table.
Comment_line	alpha	50	The comments entered for the item. From the Comment field in the SKU Comments table.
Print_code	alpha	1	Indicates where to print or display the item comments. • B = Print on the pick slip and on the invoice, if supported by your unique invoice print program. • N = Do not print. • P = Print on pick slip. • R or blank = Print on reports. This option is not currently implemented. • I = Print on the invoice, if your unique invoice print program supports it. • 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 table.
ItemAttribute			The ItemAttribute element repeats for each item attribute defined for the item in the Item Attribute table.
IAT_Type	alpha	6	A code that identifies an item attribute. From the Type field in the Item Attribute table.
IAT_Description	alpha	30	A description of the item attribute type. From the Description field in the Item Attribute table.
IAV_Value	alpha	6	A code that identifies an attribute value. From the Value field in the Item Attribute Value table.
IAV_Description	alpha	30	A description of the attribute value. From the Description field in the Item Attribute Value table.
SourcePrice			The SourcePrice element repeats for each source price for the item in the Special Pricing by Source table.
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 table.
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 table.
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 table.
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 table.
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 table.
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 table.
Coordinate			The Coordinate element repeats for each coordinate for the item in the Item Coordinate table.
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 table.
ICN_Message	alpha	70	The persuasive or descriptive message to display for the coordinate item. From the Message field in the Item Coordinate table.
ICN_Sequence	numeric	3	The sequence number assigned to the item coordinate type, indicating the sequence in which the Display Coordinate Items window displays coordinate items assigned to this type in order entry. From the Seq field in the Item Coordinate table.
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 table.
Keyword			The Keyword element repeats for each keyword for the item in the Keyword table.
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 table.
KWD_KeywordExclusion	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 table.
Image
ECI_Thumbfile_Picture	alpha	255	Not implemented.
ECI_Regular_Picture	alpha	255	Not implemented.
ECI_Large_Picture	alpha	255	Not implemented.
Restriction			The Restriction element repeats for each item restriction defined for the item in the Item Restriction by Country/State table.
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 table.
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 table.
ITMUserField			The ITMUserField element repeats for each item user field defined for the item in the Item User Field table.
ITM_UDF_Sequence_Nbr	numeric	3	The sequence number assigned to the item user field. From the Seq# field in the Item User Field table.
ITM_UDF_Text	alpha	30	The text defined for the item user field. From the Text field in the Item User Field table.
ITM_UDF_Number	numeric	16	The number defined for the item user field. From the Number field in the Item User Field table.
ITM_UDF_Date	numeric	7	The date defined for the item user field. From the Date field in the Item User Field table.
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 table.
ITM_UDF_File_code	alpha	3	The code representing the table 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 table.
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 table.
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 table.
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 table.
TaxExemption			The TaxExemption element repeats for each tax exemption defined for the item in the Item Tax Exempt table.
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 table.
ITE_Seq_Nbr	numeric	3	The sequence number assigned to the item tax exemption. From the Seq # field in the Item Tax Exempt table.
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 table.
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 table.
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 table.
FreightExemption			The FreightExemption element repeats for each freight exemption defined for the item in the Freight Exemption table.
FEF_Sequence_Number	numeric	5	The sequence number assigned to the item freight exemption. From the FEF sequence number field in the Freight Exemption table.
Offer_Number	alpha	3	The offer in which the item is exempt from freight. From the Offer number field in the Freight Exemption table.
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 table.
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 table.
Collating_sequence_Nbr	numeric	5	The collating sequence number assigned to the SKU. From the Collating seq # field in the SKU table.
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 table.
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 table.
SKU_Description	alpha	40	A description of the SKU. From the Description field in the SKU table.
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 table.
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 table.
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 table.
List_price	numeric	7.2	The list price defined for the SKU. From the List price field in the SKU table.
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 table.
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 table.
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 table.
Lowest_price	numeric	7.2	The lowest recommended sale price for the SKU. From the Lowest price field in the SKU table.
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 table.
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 table.
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 table.
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 table.
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 table.
Qty_order_direct_ship	numeric	7	From the Qty order direct ship field in the SKU table.
Receipt_date	numeric	7	The last time inventory for the SKU was received. From the Receipt date field in the SKU table.
Reserve_qty_limit	numeric	7	If the order quantity exceeds this amount, the system does not attempt to reserve the item and displays the backorder reason. From the Reserve qty limit field in the SKU table.
Restrict_orders	alpha	1	Defines whether you can accept an order for the SKU and whether demand is captured. • Y = you cannot accept an order for the item/SKU. • N or blank = you can accept an order for the item/SKU. From the Restrict orders field in the SKU table.
Retail_reference_Nbr	numeric	15	The retail reference number assigned to the SKU. From the Retail ref # field in the SKU table.
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 table.
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 table.
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 table.
User_field_1	alpha	10	A user-defined field for the SKU. From the User field 1 field in the SKU table.
User_field_2	alpha	10	A user-defined field for the SKU. From the User field 2 field in the SKU table.
User_field_3	alpha	10	A user-defined field for the SKU. From the User field 3 field in the SKU table.
Weight_override	numeric	7.3	The actual shipping weight of the SKU. From the Weight override field in the SKU table.
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 table.
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 table.
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 ship together through the same shipper. From the Coord group field in the SKU table.
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 table.
SKU_Future_qty	numeric	7	The total number of units on future orders. From the Future qty field in the SKU table.
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 table.
SKU_On_hold_qty	numeric	7	The total number of units on hold. From the On hold qty field in the SKU table.
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 table.
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 table.
SKU_Second_Language_Desc	alpha	40	The second language description defined for the SKU. From the Second language desc field in the SKU table.
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 table.
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 table.
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 table.
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 table.
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 table.
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 table.
SKU_User_field_4	alpha	5	A user-defined field for the SKU. From the SKU user field 4 field in the SKU table.
SKU_User_field_5	alpha	5	A user-defined field for the SKU. From the SKU user field 5 field in the SKU table.
SKU_Book_Inventory	numeric	7	The expected inventory per catalog or advertisement. From the SKU book inventory field in the SKU table.
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 table.
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 table.
SKU_LS_Style	alpha	20	The long SKU style defined for the SKU. From the SKU L/S style field in the SKU table.
SKU_LS_Vendor	alpha	7	The long SKU vendor defined for the SKU. From the SKU L/S vendor field in the SKU table.
SKU_Receiving_Priority	alpha	2	A number that controls the priority of receiving the SKU. From the SKU receiving priority field in the SKU table.
SKU_Generic_Ecommerce	alpha	10	From the SKU generic ecommerce field in the SKU table.
SKU_Last_Download_Qty	numeric	5	The inventory quantity that was last downloaded through the e-commerce interface. From the SKU last download qty field in the SKU table.
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 table.
SKU_Last_Ecomm_Info_Chg	numeric	7	The date when the SKU information was last downloaded through the e-commerce interface. From the SKU last ecomm info chg field in the SKU table.
SKU_SVC_Card_Reload	alpha	1	From the SKU future use Y/N 1 field in the SKU table.
SKU_Original_Retail_Price	numeric	7.2	The original retail price for the SKU. From the SKU original retail price field in the SKU table.
SKU_Create_Date	numeric	7	The date the SKU was created. From the SKU create date field in the SKU table.
SKU_GTIN_Nbr	numeric	14	The GTIN number defined for the SKU. From the SKU GTIN # field in the SKU table.
SKU_Commodity_Code	numeric	8	The commodity code defined for the SKU. From the SKU commodity code field in the SKU table.
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 table.
Frequency_code	alpha	1	A code that classifies the performance of an item. From the Freq code field in the SKU table.
Percentage_of_picks	numeric	5.2	The percentage of picks generated for the item. From the Pct of picks field in the Frequency table.
Warehouse	numeric	3	The warehouse where the SKU is located. From the Whs field in the SKU table.
Warehouse_name	alpha	30	The name of the warehouse. From the Name field in the Warehouse table.
Location	alpha	7	The primary location where the SKU is located. From the Location field in the SKU table.
SLC_Code	alpha	2	The soldout control code specified for the SKU. From the SLC code field in the SKU table.
SLC_Description	alpha	30	The description of the soldout control code. From the SLC description field in the Soldout Control table.
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 table.
Unit_of_measure	alpha	3	The unit of measure defined for the SKU. From the UOM field in the SKU table.
UOM_Description	alpha	30	A description of the unit of measure. From the UOM description field in the Unit of Measure table.
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 table.
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 table.
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 table.
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 table.
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 table.
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 table.
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 table.
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 table.
Item_status_description	alpha	30	A description of the item status. From the Description field in the Item Status table.
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 table.
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 table.
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 table.
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 table.
Item_category_description	alpha	30	A description of the item category. From the Description field in the Item Category table.
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 table.
PRP_Description	alpha	40	A description of the prep code. From the PRP description field in the Prep Code table.
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 table.
Country_description	alpha	30	A description of the country of origin. From the Description field in the Country table.
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 table.
LSC_Description	alpha	30	A description of the long SKU class. From the Description field in the Long SKU Class table.
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 table.
VendorItem			The VendorItem element repeats for each vendor item defined for the SKU in the Vendor Item table.
Vendor_Nbr	numeric	7	The code the vendor uses to identify the SKU. From the Vendor # field in the Vendor Item table.
Item	alpha	20	The item number, as defined by the vendor. From the Item field in the Vendor Item table.
Cubic_volume	numeric	5	The cubic volume of the item, as defined by the vendor. From the Cubic volume field in the Vendor Item table.
Description	alpha	30	A description of the vendor item. From the Description field in the Vendor Item table.
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 table.
Message_line_1	alpha	30	Informational message for the vendor item. From the Message line 1 field in the Vendor Item table.
Message_line_2	alpha	30	Informational message for the vendor item. From the Message line 2 field in the Vendor Item table.
Message_line_3	alpha	30	Informational message for the vendor item. From the Message line 3 field in the Vendor Item table.
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 table.
Price	numeric	11.4	The vendor’s list price for the item. From the Price field in the Vendor Item table.
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 table.
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 table.
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 table.
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 table.
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 table.
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 table.
POV_Description	alpha	30	A description of the PO ship via. From the Description field in the PO Ship Via table.
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 table.
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 table.
UOM_Description	alpha	30	A description of the unit of measure. From the UOM description field in the Unit of Measure table.
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 table.
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 table.
Country_description	alpha	30	A description of the country of origin. From the Description field in the Country table.
VITPriceBreak			The VITPriceBreak element repeats for each vendor price break defined for the vendor item in the Vendor Item Price Break table.
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 table.
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 table.
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 table.
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 table.
VITAdditionalCharge			The VITAdditionalCharge element repeats for each vendor additional charge associated with the vendor item in the Vendor Item Addl Charge table.
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 table.
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 table.
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 table.
VITNote			The VITNote element repeats for each vendor item note associated with the vendor item in the Vendor Item Notes table.
VIN_Seq_Nbr	numeric	3	The sequence number assigned to the vendor item note. From the Seq # field in the Vendor Item Notes table.
VIN_Print	alpha	1	Indicates whether the vendor item note prints on the PO. Valid values are: • B or P = Print on PO • blank = Do not print From the Print? field in the Vendor Item Notes table.
VIN_Note	alpha	60	The note defined for the vendor item. From the Note field in the Vendor Item Notes table.
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 table.
VIN_Entry_date	numeric	7	The date the vendor item note was entered. From the Entry date field in the Vendor Item Notes table.
VITUserField			The VITUserField element repeats for each vendor item user field associated with the vendor item in the Vendor Item User Field table.
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 table.
VIT_UDF_Text	alpha	30	The text defined for the vendor item user field. From the Text field in the Vendor Item User Field table.
VIT_UDF_Number	numeric	16	The number defined for the vendor item user field. From the Number field in the Vendor Item User Field table.
VIT_UDF_Date	numeric	7	The date defined for the vendor item user field. From the Date field in the Vendor Item User Field table.
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 table.
VIT_UDF_File_code	alpha	3	The code representing the table 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 table.
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 table.
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 table.
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 table.
SKUOffer			The SKUOffer element repeats for each SKU offer record defined for the SKU in the SKU Offer table.
Offer_Number	alpha	3	A code that represents the offer where the SKU is advertised. From the Offer number field in the SKU Offer table.
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 table.
SH_price	numeric	7.2	The price to charge the customer for special handling. From the S/H price field in the SKU Offer table.
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 table.
Term_payment_interval	numeric	5	The number of days between payments. From the Term payment interval field in the SKU Offer table.
Gift_wrap_price	numeric	7.2	The price for gift wrapping the SKU. From the G/W price field in the SKU Offer table.
Freight	numeric	6.2	The freight amount to charge for the SKU in the offer. From the Freight field in the SKU Offer table.
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 table.
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 table.
SKO_Coupon_effective_date	numeric	7	The date the coupon becomes effective. From the Coupon effective field in the SKU Offer table.
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 table.
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 table.
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 table.
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 table. If the Exclude Sale Item When Prorating Discounts (I65) system control value is selected, 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 table.
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 table.
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 table.
SKO_Included_Internet_Ofr	alpha	1	From the SKO future use Y/N 1 field in the SKU Offer table.
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 table.
ADD_Description	alpha	30	A description of the additional charge. From the ADD description field in the Additional Charge table.
SHF_Code	alpha	2	The special handling format code assigned to the additional charge code. From the SHF code field in the Additional Charge table.
SHF_Description	alpha	30	A description of the special handling format. From the Description field in the Special Format table.
SKO_AOC_Add-On_Code	alpha	3	From the SKO AOC add-on code field in the SKU Offer table.
SKUPrice			The SKUPrice element repeats for each SKU price record defined for the SKU in the SKU Price table.
Effective_date	numeric	7	The date the price or quantity break becomes valid. From the Effective date field in the SKU Price table.
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 table.
Associate_price	numeric	7.2	The price at which the SKU is sold in the offer to associate customers. From the Associate price field in the SKU Price table.
Price	numeric	7.2	The price at which the SKU is sold in the offer. From the Price field in the SKU Price table.
SKP_Price_column	numeric	2	The pricing column associated with the price. From the Price column field in the SKU Price table.
SKP_Associate_tax_price	numeric	7.2	The price at which the SKU is sold to associate customers on orders subject to tax-inclusive pricing and VAT. From the Tax inclusive associate price field in the SKU Price table.
SKP_Tax_price	numeric	7.2	The price at which the SKU is sold on orders subject to tax-inclusive pricing and VAT. From the Tax incl price field in the SKU Price table.
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 table.
SKUOfferPage			The SKUOfferPage element repeats for each SKU offer page record defined for the SKU in the SKU Offer Page table.
Alias_item	alpha	12	The alternate item code for the SKU. From the Alias item field in the SKU Offer Page table.
SKOAccompanyingItem			The SKOAccompanyingItem element repeats for each accompanying item record defined for the SKU in the Accompanying Item table.
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 table.
ACI_Qty	numeric	5	The number of accompanying items to add to the order. From the Qty field in the Accompanying Item table.
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 table.
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 table.
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 table.
ACI_SKU_Code	alpha	14	The SKU of the accompanying item. From the ACI SKU code field in the Accompanying Item table.
SKOUserField			The SKOUserField element repeats for each SKU offer user field record defined for the SKU in the SKU Offer User Field table.
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 table.
SKO_UDF_Text	alpha	30	The text defined for the SKU offer user field. From the Text field in the SKU Offer User Field table.
SKO_UDF_Number	numeric	16	The number defined for the SKU offer user field. From the Number field in the SKU Offer User Field table.
SKO_UDF_Date	numeric	7	The date defined for the SKU offer user field. From the Date field in the SKU Offer User Field table.
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 table.
SKO_UDF_File_code	alpha	3	The code representing the table 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 table.
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 table.
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 table.
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 table.
SKOSpecialHandlingDetail			The SKOSpecialHandlingDetail element repeats for each special format detail record defined for the SKU offer in the Special Format Details table.
SFD_Seq_Nbr	numeric	3	The sequence number assigned to the special format detail. From the SFD seq # field in the Special Format Details table.
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 table.
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 table.
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 in the Special Format Details table.
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 table.
SFD_Default_value	alpha	45	The special format detail default value. From the Default value field in the Special Format Details table.
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 table.
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 table.
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 table.
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 table.
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 table.
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 table.
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 table.
SKOSpecialHandlingResponse			The SKOSpecialHandlingResponse element repeats for each special format response record defined for the SKU offer in the Special Format Responses table.
SFD_Seq_Nbr	numeric	3	The sequence number assigned to the special format response. From the SFD seq # field in the Special Format Responses table.
SFR_Valid_response	alpha	45	A code for a valid special format response. From the Valid response field in the Special Format Response table.
SFR_Description	alpha	45	A description of the special format response. From the SFR description field in the Special Format Response table.
ItemWarehouse			The ItemWarehouse element repeats for each item warehouse defined for the SKU in the Item Warehouse table.
Warehouse	numeric	3	A code that represents a warehouse or retail store. From the Whs field in the Item Warehouse table.
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 table.
Economic_order_qty	numeric	7	The recommended optimum ordering quantity for the SKU. From the Economic order qty field in the Item Warehouse table.
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 table.
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 table.
Protected_qty	numeric	7	The unit quantity of the SKU protected from reservation. From the Protected qty field in the Item Warehouse table.
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 table.
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 table.
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 table.
ITW_Protect_current_price	alpha	1	Indicates whether the system overrides 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 table.
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 table.
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 table.
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 table.
ITWUserField			The ITWUserField element repeats for each item user field associated with the SKU in the Item Warehouse User Field table.
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 table.
ITW_UDF_Text	alpha	30	The text defined for the item warehouse user field. From the Text field in the Item Warehouse User Field table.
ITW_UDF_Number	numeric	16	The number defined for the item warehouse user field. From the Number field in the Item Warehouse User Field table.
ITW_UDF_Date	numeric	7	The date defined for the item warehouse user field. From the Date field in the Item Warehouse User Field table.
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 table.
ITW_UDF_File_code	alpha	3	The code representing the table 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 table.
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 table.
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 table.
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 table.
FinishedGood			The FinishedGood element is included 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 table.
SeqNbr	numeric	5	The sequence number assigned to the kit detail. From the Seq# field in the Kit Detail table.
Qty	numeric	5	The number of items that are used to make up the finished good. From the Qty field in the Kit Detail table.
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 table.
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 table.
SetItem			The SetItem element is included only if the item is defined as a set item (the Kit_type attribute is set to S). The SetItem element repeats for each set component defined for the SKU in the Set Details table.
SeqNbr	numeric	3	The sequence number assigned to the set detail. From the Seq# field in the Set Details table.
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 table.
Pct_of_cost	numeric	5.2	The percentage of the set’s cost that the item comprises. From the % of cost field in the Set Details table.
Qty	numeric	5	The number of units of the item to include in one set. From the Qty field in the Set Details table.
Set_Comp_ITM_Number	alpha	12	A component item of the set item. From the Set comp ITM number field in the Set Details table.
Set_Comp_SKU_Code	alpha	14	The SKU of the component item. From the Set comp SKU code field in the Set Details table.
VariableSet			The VariableSet element and its children, VariableSetGroup and VariableSetItem, is included 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 table.
VariableSetGroup			The VariableSetGroup element repeats for each variable set group defined for the SKU in the Variable Set Group table.
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 table.
Description	alpha	30	A description of the variable set group. From the Description field in the Variable Set Group table.
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 table.
VariableSetItem			The VariableSetItem element repeats for each variable set component defined for the SKU in the Variable Set Details table.
SeqNbr	numeric	3	The sequence number assigned to the variable set detail. From the Seq# field in the Variable Set Details table.
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 table.
Var_comp_SKU_Code	alpha	14	The SKU of the component item. From the Var comp SKU code field in the Variable Set Details table.
SKUComment			The SKUComment element repeats for each SKU comment defined for the SKU in the SKU Comments table.
Seq_Nbr	numeric	3	The sequence number assigned to the SKU comment. From the Seq # field in the SKU Comments table.
Comment_line	alpha	50	A line of SKU comments. From the Comment field in the SKU Comments table.
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 (Not currently implemented) • W = pop-up window when you order the item From the Print code field in the SKU Comments table.
SKUAttribute			Not implemented.
IAT_Type	alpha	6	Not implemented.
IAT_Description	alpha	30	Not implemented.
IAV_Value	alpha	6	Not implemented.
IAV_Description	alpha	30	Not implemented.
IAA_Affinity_flag	alpha	1	Not implemented.
UPC			The UPC element repeats for each UPC code defined for the SKU in the Item UPC table.
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; 13 position UPC code. • E8 = EAN-8; 8 position UPC code. • UA = UPC-A; 12 position UPC code. • UE = UPC-E; 6 position UPC code. From the UPC type field in the Item UPC table.
UPC	alpha	14	The UPC code defined for the SKU. From the UPC field in the Item UPC table.
UPC_VND_Vendor	numeric	7	The supplier who sells you merchandise. From the UPC VND vendor nbr field in the Item UPC table.
SKUUserField			The SKUUserField element repeats for each SKU user field defined for the SKU in the SKU User Field table.
SKU_UDF_Sequence_Nbr	numeric	3	The sequence number assigned to the SKU user field. From the Seq# field in the SKU User Field table.
SKU_UDF_Text	alpha	30	The text defined for the SKU user field. From the Text field in the SKU User Field table.
SKU_UDF_Number	numeric	16	The number defined for the SKU user field. From the Number field in the SKU User Field table.
SKU_UDF_Date	numeric	7	The date defined for the SKU user field. From the Date field in the SKU User Field table.
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 table.
SKU_UDF_File_code	alpha	3	The code representing the table 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 table.
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 table.
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 table.
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 table.