ITEMSKU FILE
Item SKU
The Item SKU file contains the SKU information related to an item in the Item
Master file.
REFERENCED BY
IC11.1 IC11.5 ICI8.1
UPDATED BY
ICI7.1
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
ISK-ITEM-GROUP Alpha 5 ICI7.1 ICI8.1
Item Group This field contains the identifier for
a group of items that can be shared by
one or more companies.
ISK-ITEM Alpha 32 ICI7.1 ICI8.1
Item Number This field contains the item
identifier.
ISK-SKU Alpha 15 ICI7.1 ICI8.1
SKU Identifier SKU identifier.
ISK-UOM Alpha 4 ICI7.1 ICI8.1
Unit of Measure This field contains the valid stock
unit of measure for this item.
ISK-UOM-COST Signed 13.5 ICI7.1 ICI8.1
Unit of Measure Cost Unit of measure cost.
ISK-SALE-BY-MFG Alpha 1 ICI7.1 ICI8.1
Sale by Manufacturer Sale by manufacturer flag.
N = No
Y = Yes
ISK-SALE-BY-DISTR Alpha 1 ICI7.1 ICI8.1
Sale by Distributor Sale by distributor flag.
N = No
Y = Yes
ISK-DESCRIPTOR Alpha 12 ICI7.1 ICI8.1
Descriptor
ISK-VEN-CASE-CD Alpha 11 ICI7.1 ICI8.1
Vendor Case Code Vendor case code.
ISK-PRODUCT-CD Alpha 2 ICI7.1 ICI8.1
Product Code Product code.
ISK-INVOICE-BREAK Alpha 1 ICI7.1 ICI8.1
Invoice Break Invoice break flag.
ISK-SHELF-LBL-CD Alpha 1 ICI7.1 ICI8.1
Shelf Label Code Shelf label code.
ISK-COLOR-CD Alpha 10 ICI7.1 ICI8.1
Color Cd
ISK-SIZE-CD Alpha 10 ICI7.1 ICI8.1
Size Cd
ISK-STYLE-CD Alpha 10 ICI7.1 ICI8.1
Style Cd
ITEMSKU FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
ISKSET1 ITEM-GROUP IC11.1 IC11.5
ITEM ICI7.1 ICI8.1
SKU
ISKSET2 SKU ICI7.1 ICI8.1
ISKSET5 ITEM-GROUP Subset ICI7.1 ICI8.1
SKU Where SKU != Spaces
ISKSET6 ITEM-GROUP ICI7.1 ICI8.1
ITEM
UOM
SKU
ITEMSKU FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Itemskutoitem ITEMMAST Required
ISK-ITEM-GROUP -> ITE-ITEM-GROUP
ISK-ITEM -> ITE-ITEM
|
