Lawson Insight Technical Documentation |
|
ITEMSKU
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 IC598 IC800 ICI8.1 RQID.1
RQIF.1 RQIH.1 RQIJ.1 RQIC.1 RQIG.1
UPDATED BY
ICI7.1 PO150 PO25.6 PO25.7 PO36.2 PO536
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
ISK-ITEM-GROUP Alpha 5 ICI7.1 ICI8.1
Element: Item Group This field contains the identifier for PO150 PO25.6
a group of items that can be shared by PO25.7 PO36.2
one or more companies. PO536 RQID.1
RQIF.1 RQIH.1
RQIJ.1
ISK-ITEM Alpha 32 ICI7.1 ICI8.1
Element: Item Number This field contains the item PO150 PO25.6
identifier. PO25.7 PO36.2
PO536 RQID.1
RQIF.1 RQIH.1
RQIJ.1
ISK-SKU Alpha 15 ICI7.1 ICI8.1
Element: SKU IdentifierSKU identifier. PO150 PO25.6
PO25.7 PO36.2
PO536 RQID.1
RQIF.1 RQIH.1
RQIJ.1
ISK-UOM Alpha 4 ICI7.1 ICI8.1
Element: Unit of MeasurThis field contains the valid stock PO150 PO25.6
unit of measure for this item. PO25.7 PO36.2
PO536 RQID.1
RQIF.1 RQIH.1
RQIJ.1
ISK-UOM-COST Signed 18.5 ICI7.1 ICI8.1
Element: Intl Cost Unit of measure cost. RQID.1 RQIF.1
RQIH.1 RQIJ.1
ISK-SALE-BY-MFG Alpha 1 ICI7.1 ICI8.1
Element: Sale by ManufaSale by manufacturer flag. PO150 PO25.6
N = No PO25.7 PO36.2
Y = Yes PO536 RQID.1
RQIF.1 RQIH.1
RQIJ.1
ISK-SALE-BY-DISTR Alpha 1 ICI7.1 ICI8.1
Element: Sale by DistriSale by distributor flag. PO150 PO25.6
N = No PO25.7 PO36.2
Y = Yes PO536 RQID.1
RQIF.1 RQIH.1
RQIJ.1
ISK-DESCRIPTOR Alpha 12 ICI7.1 ICI8.1
Element: Descriptor RQID.1 RQIF.1
RQIH.1 RQIJ.1
ISK-VEN-CASE-CD Alpha 11 ICI7.1 ICI8.1
Element: Vendor Case CoVendor case code. RQID.1 RQIF.1
RQIH.1 RQIJ.1
ISK-PRODUCT-CD Alpha 2 ICI7.1 ICI8.1
Element: Product Code Product code. RQID.1 RQIF.1
RQIH.1 RQIJ.1
ISK-INVOICE-BREAK Alpha 1 ICI7.1 ICI8.1
Element: Invoice Break Invoice break flag. RQID.1 RQIF.1
RQIH.1 RQIJ.1
ISK-SHELF-LBL-CD Alpha 1 ICI7.1 ICI8.1
Element: Shelf Label CoShelf label code. RQID.1 RQIF.1
RQIH.1 RQIJ.1
ISK-COLOR-CD Alpha 10 ICI7.1 ICI8.1
Element: Color Cd RQID.1 RQIF.1
RQIH.1 RQIJ.1
ISK-SIZE-CD Alpha 10 ICI7.1 ICI8.1
Element: Size Cd RQID.1 RQIF.1
RQIH.1 RQIJ.1
ISK-STYLE-CD Alpha 10 ICI7.1 ICI8.1
Element: Style Cd RQID.1 RQIF.1
RQIH.1 RQIJ.1
ISK-ITEM-TYPE-SKU Derived
Element: Item Type Sku
ITEMSKU FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
ISKSET1 ITEM-GROUP IC11.1 IC11.5
ITEM IC598 IC800
SKU ICI7.1 ICI8.1
PO150 PO25.6
PO25.7 PO36.2
PO536 RQID.1
RQIF.1 RQIH.1
RQIJ.1
ISKSET2 SKU ICI7.1 ICI8.1
ITEM-GROUP PO150 PO25.6
PO25.7 PO36.2
PO536 RQID.1
RQIF.1 RQIH.1
RQIJ.1
ISKSET5 ITEM-GROUP Subset ICI7.1 ICI8.1
SKU Where SKU != Spaces RQIC.1 RQID.1
RQIF.1 RQIG.1
RQIH.1 RQIJ.1
ISKSET6 ITEM-GROUP ICI7.1 ICI8.1
ITEM RQIC.1 RQID.1
UOM RQIF.1 RQIG.1
SKU RQIH.1 RQIJ.1
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
|