ITEMSKU

Item SKU

The Item SKU file contains the SKU information related to an item in the Item Master file.
UPDATED BY
IC11.1 IC11.5 IC511 IC598 IC800 ICI7.1
ICI8.1 PO150 PO25.6 PO25.7 PO26.4 PO26.5
PO26.8 PO28.2 PO36.2 PO536 RQIC.1 RQID.1
RQIF.1 RQIG.1 RQIH.1 RQIJ.1

FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
ISK-ITEM-GROUP
Element: Item Group		Alpha 5
This field contains the identifier for a group of items that can be shared by one or more companies.
ICI7.1 ICI8.1
PO150 PO25.6
PO25.7 PO26.4
PO26.5 PO26.8
PO28.2 PO36.2
PO536 RQID.1
RQIF.1 RQIH.1
RQIJ.1
ISK-ITEM
Element: Item		Alpha 32
This field contains the item identifier.
ICI7.1 ICI8.1
PO150 PO25.6
PO25.7 PO26.4
PO26.5 PO26.8
PO28.2 PO36.2
PO536 RQID.1
RQIF.1 RQIH.1
RQIJ.1
ISK-SKU
Element: Sku		Alpha 15
SKU identifier.
ICI7.1 ICI8.1
PO150 PO25.6
PO25.7 PO26.4
PO26.5 PO26.8
PO28.2 PO36.2
PO536 RQID.1
RQIF.1 RQIH.1
RQIJ.1
ISK-UOM
Element: Uom		Alpha 4
This field contains the valid stock unit of measure for this item.
ICI7.1 ICI8.1
PO150 PO25.6
PO25.7 PO26.4
PO26.5 PO26.8
PO28.2 PO36.2
PO536 RQID.1
RQIF.1 RQIH.1
RQIJ.1
ISK-UOM-COST
Element: Intl Cost		Signed 18.5
ICI7.1 ICI8.1
RQID.1 RQIF.1
RQIH.1 RQIJ.1
ISK-SALE-BY-MFG
Element: Sale By Mfg		Alpha 1
Sale by manufacturer flag.
N = No
Y = Yes
ICI7.1 ICI8.1
PO150 PO25.6
PO25.7 PO26.4
PO26.5 PO26.8
PO28.2 PO36.2
PO536 RQID.1
RQIF.1 RQIH.1
RQIJ.1
ISK-SALE-BY-DISTR
Element: Sale By Distr		Alpha 1
Sale by distributor flag.
N = No
Y = Yes
ICI7.1 ICI8.1
PO150 PO25.6
PO25.7 PO26.4
PO26.5 PO26.8
PO28.2 PO36.2
PO536 RQID.1
RQIF.1 RQIH.1
RQIJ.1
ISK-DESCRIPTOR
Element: Descriptor		Alpha 12
ICI7.1 ICI8.1
RQID.1 RQIF.1
RQIH.1 RQIJ.1
ISK-VEN-CASE-CD
Element: Ven Case Cd		Alpha 11
Vendor case code.
ICI7.1 ICI8.1
RQID.1 RQIF.1
RQIH.1 RQIJ.1
ISK-PRODUCT-CD
Element: Product Cd		Alpha 2
Product code.
ICI7.1 ICI8.1
RQID.1 RQIF.1
RQIH.1 RQIJ.1
ISK-INVOICE-BREAK
Element: Invoice Break		Alpha 1
Invoice break flag.
ICI7.1 ICI8.1
RQID.1 RQIF.1
RQIH.1 RQIJ.1
ISK-SHELF-LBL-CD
Element: Shelf Lbl Cd		Alpha 1
Shelf label code.
ICI7.1 ICI8.1
RQID.1 RQIF.1
RQIH.1 RQIJ.1
ISK-COLOR-CD
Element: Color Cd		Alpha 10
ICI7.1 ICI8.1
RQID.1 RQIF.1
RQIH.1 RQIJ.1
ISK-SIZE-CD
Element: Size Cd		Alpha 10
ICI7.1 ICI8.1
RQID.1 RQIF.1
RQIH.1 RQIJ.1
ISK-STYLE-CD
Element: Style Cd		Alpha 10
ICI7.1 ICI8.1
RQID.1 RQIF.1
RQIH.1 RQIJ.1
ISK-ITEM-TYPE-SKU
Element: Item Type Sku		Derived


ITEMSKU FILE INDEX

NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
ISKSET1 ITEM-GROUP
ITEM
SKU
IC11.1 IC11.5
IC511 IC598
IC800 ICI7.1
ICI8.1 PO150
PO25.6 PO25.7
PO26.4 PO26.5
PO28.2 PO36.2
PO536 RQID.1
RQIF.1 RQIH.1
RQIJ.1
ISKSET2 SKU
ITEM-GROUP
ICI7.1 ICI8.1
PO150 PO25.6
PO25.7 PO26.4
PO26.5 PO26.8
PO28.2 PO36.2
PO536 RQID.1
RQIF.1 RQIH.1
RQIJ.1
ISKSET5 ITEM-GROUP
SKU
Subset
WhereSKU !=Spaces
ICI7.1 ICI8.1
RQID.1 RQIF.1
RQIH.1 RQIJ.1
ISKSET6 ITEM-GROUP
ITEM
UOM
SKU
IC11.1 ICI7.1
ICI8.1 RQIC.1
RQID.1 RQIF.1
RQIG.1 RQIH.1
RQIJ.1


ITEMSKU FILE RELATIONS


ONE TO ONE RELATIONS

RELATION
NAME		 RELATED FILE INTEGRITY RULES / FIELD MATCH
Itemskutoitem ITEMMAST Required
ISK-ITEM-GROUP->ITE-ITEM-GROUP
ISK-ITEM->ITE-ITEM

File created: Thu Jun 09 11:17:23 2016

Home
Contact Us



All trademarks and registered trademarks are the property of their respective owners.