CI_Item                             CI Item Master                    Rel: 4.40  Bld: 398  8/28/2009
 Bus Obj: CI_ItemCode_bus,IM_TransactionRegister_upd,PO_ReceiptRegister_upd,BM_DisassemblyRegister_upd,S
 SQL Def: Y  SysDB: N                                               "MAS_"+%C$+"/CI"+%C$+"/CI_Item.M4T"

 KPRIMARY: ItemCode
 KITEMTYPE: ItemType+ItemCode
 KEXTENDEDDESC: ExtendedDescriptionKey+ItemCode
 KPRODLINE: ProductLine+ItemCode
 KPROMOCODE: SalesPromotionCode+ItemCode

 Fld  Column Name                     M/L TUR  Description/Notes              Class

   1  ItemCode. . . . . . . . . . .    30 SYY  Item Code . . . . . . . . . . .ITEMCODE
                                                ChngTag:Replace0 Notes:
                                                Previously only used for
                                                Inventory Item Number
                                                {IM1$(1,15)} {SO7$(1,14)}
   2  ItemType. . . . . . . . . . .     1 SYY  Item Type . . . . . . . . . . .
                                                Valid:1,3,4,5 Notes:
                                                1=Regular Item, 3=Charge
                                                Item, 4=Comment Item,
                                                5=Miscellaneous Item
                                                {SO7$(15,1)}
   3  ItemCodeDesc. . . . . . . . .    30 SNN  Item Code Description . . . . .DESCRIPTION
                                                Notes: Previously only used
                                                for Inventory Item Descriptio
                                                n {IM1$(16,30)} {SO7$(16,30)}
   4  ExtendedDescriptionKey. . . .    10 SYN  Extended Description Key. . . .EXTDESCKEY
                                                Read Only:Y ValGroup:NotCurre
                                                ntItemType
   5  UseInAR . . . . . . . . . . .     1 SYY  Use In AR . . . . . . . . . . .YESNO
                                                DfltVal:N Valid:Y,N
                                                ValGroup:NotCurrentItemType
                                                Notes: Always "N" for Item
                                                Type "1"
   6  UseInSO . . . . . . . . . . .     1 SYY  Use In SO . . . . . . . . . . .YESNO
                                                DfltVal:N Valid:Y,N
                                                ValGroup:NotCurrentItemType
   7  UseInPO . . . . . . . . . . .     1 SYY  Use In PO . . . . . . . . . . .YESNO
                                                DfltVal:N Valid:Y,N
                                                ValGroup:NotCurrentItemType
   8  UseInBM . . . . . . . . . . .     1 SYY  Use In BM . . . . . . . . . . .YESNO
                                                DfltVal:N Valid:Y,N
                                                ValGroup:NotCurrentItemType
   9  CalculateCommission . . . . .     1 SYY  Calculate Commission. . . . . .
                                                DfltVal:N Valid:Y,N,S,P,C,G
                                                ValGroup:NotCurrentItemType
                                                Notes: Type 5 valid values
                                                are Y=Yes ,N=No {SO7$(56,
                                                1)}. Type 1 valid values are
                                                N=No, S=Standard, P=% of
                                                Price, C=% of Cost, G=%of
                                                Gross Profit {IM1$(59,1)}
  10  DropShip. . . . . . . . . . .     1 SYY  Drop Ship . . . . . . . . . . .YESNO
                                                DfltVal:N Valid:Y,N
                                                ValGroup:NotCurrentItemType
                                                Notes: Formerly used in SO
                                                Miscellaneous Charge file
                                                for Item Codes. {SO7$(58,1)}
  11  EBMEnabled. . . . . . . . . .     1 SYY  e-Business Manager Enabled. . .YESNO
                                                DfltVal:N Valid:Y,N
                                                ValGroup:NotCurrentItemType
                                                Notes: {IM1$(57,1)} {SO7$(83,
                                                1)}
  12  AllowBackOrders . . . . . . .     1 SYY  Allow Back Orders . . . . . . .YESNO
                                                DfltVal:N Valid:Y,N
                                                ValGroup:NotCurrentItemType
                                                Notes: {IM1$(56,1)}
  13  AllowReturns. . . . . . . . .     1 SYY  Allow Returns . . . . . . . . .YESNO
                                                DfltVal:N Valid:Y,N
                                                ValGroup:NotCurrentItemType
                                                Notes: {IM1$(214,1)}
                                                {SO7$(116,1)}
  14  PriceCode . . . . . . . . . .     4 SYN  Price Code. . . . . . . . . . .PRICECODE
                                                ValGroup:NotCurrentItemType
                                                Notes: {IM1$(52,4)}
  15  AllowTradeDiscount. . . . . .     1 SYY  Allow Trade Discount. . . . . .YESNO
                                                DfltVal:N Valid:Y,N
                                                ValGroup:NotCurrentItemType
                                                Notes: {IM1$(212,1)},
                                                {SO7$(55,1)}
  16  PrintReceiptLabels. . . . . .     1 SYY  Print Receipt Labels. . . . . .
                                                DfltVal:N Valid:Y,N,I
                                                ValGroup:NotCurrentItemType
                                                Notes: Y=Yes, N=No,
                                                I=Item{IM1$(265,1)}
  17  AllocateLandedCost. . . . . .     1 SYY  Allocate Landed Cost. . . . . .YESNO
                                                DfltVal:N Valid:Y,N
                                                ValGroup:NotCurrentItemType
                                                Notes: {IM1$(268,1)}
  18  ConfirmCostIncrInRcptOfGoods.     1 SYY  Confirm Cost Increase in ReceipYESNO
                                                DfltVal:N Valid:Y,N
                                                ValGroup:NotCurrentItemType
                                                Notes: {IM1$(271,1)}
  19  WarrantyCode. . . . . . . . .    10 SYN  Warranty Code . . . . . . . . .WARRANTYCODE
                                                ValGroup:NotCurrentItemType
                                                Notes: {IM1$(272,10)}
  20  SalesUnitOfMeasure. . . . . .     4 SYN  Sales Unit of Measure . . . . .UNITOFMEASURE
                                                DepVal:REQUIRED ValGroup:NotC
                                                urrentItemType Notes:
                                                {IM1$(68,4)} {SO7$(59,4)}
  21  PurchaseUnitOfMeasure . . . .     4 SYN  Purchase Unit of Measure. . . .UNITOFMEASURE
                                                DepVal:REQUIRED ValGroup:NotC
                                                urrentItemType Notes:
                                                {IM1$(64,4)}
  22  StandardUnitOfMeasure . . . .     4 SYN  Standard Unit of Measure. . . .UNITOFMEASURE
                                                DepVal:REQUIRED ValGroup:NotC
                                                urrentItemType Notes:
                                                {IM1$(60,4)}
  23  PostToGLByDivision. . . . . .     1 SYY  Post to G/L By Division . . . .YESNO
                                                DfltVal:N Valid:Y,N
                                                ValGroup:NotCurrentItemType
                                                Notes: Used by AR Sales Codes
  24  SalesAcctKey. . . . . . . . .     9 SNN  Sales Account Key . . . . . . .ACCOUNT
                                                ValGroup:NotCurrentItemType
                                                Notes: Used by Misc. Charges,
                                                 Misc. Items and AR Sales
                                                Codes {SO7$(46,9)}
  25  CostOfGoodsSoldAcctKey. . . .     9 SYN  Cost Of Goods Sold Account Key.ACCOUNT
                                                ValGroup:NotCurrentItemType
                                                Notes: {SO7$(63,9)}
  26  InventoryAcctKey. . . . . . .     9 SYN  Inventory Account Key . . . . .ACCOUNT
                                                ValGroup:NotCurrentItemType
                                                Notes: Used by AR Sales
                                                Codes, {SO7$(72,9)}
  27  PurchaseAcctKey . . . . . . .     9 SYN  Purchases Account Key . . . . .ACCOUNT
                                                ValGroup:NotCurrentItemType
                                                Notes: Used by Misc. Items.
                                                {SO7$(72,9)}
  28  ManufacturingCostAcctKey. . .     9 SYN  Manufacturing Cost Account Key.ACCOUNT
                                                ValGroup:NotCurrentItemType
  29  TaxClass. . . . . . . . . . .     2 SYN  Tax Class . . . . . . . . . . .TAXCLASS
                                                DepVal:REQUIRED ValGroup:NotC
                                                urrentItemType Notes:
                                                {IM1$(269,2)} {SO7$(81,2)}
  30  PurchasesTaxClass . . . . . .     2 SYN  Purchases Tax Class . . . . . .TAXCLASS
                                                DepVal:REQUIRED ValGroup:NotC
                                                urrentItemType
  31  ProductLine . . . . . . . . .     4 SYN  Product Line. . . . . . . . . .PRODUCTLINE
                                                FmtType:CHARNUM DepVal:REQUIR
                                                ED ValGroup:NotCurrentItemTyp
                                                e Notes: {IM1$(46,4)}
  32  ProductType . . . . . . . . .     1 SYN  Product Type. . . . . . . . . .
                                                Valid:F,R,D,K, , DepVal:REQUI
                                                RED ValGroup:NotCurrentItemTy
                                                pe Notes: F=Finished Good,
                                                R=Raw Material, D=Discontinue
                                                d, K=Kit, Space=Blank
                                                {IM1$(50,1)}
  33  Valuation . . . . . . . . . .     1 SYN  Valuation . . . . . . . . . . .
                                                Valid:1,2,3,4,5,6, DepVal:REQ
                                                UIRED ValGroup:NotCurrentItem
                                                Type Notes: 1=Standard,
                                                2=Average, 3=Fifo, 4=Lifo,
                                                5=Lot, 6=Serial, Space=Blank
                                                {IM1$(51,1)}
  34  DefaultWarehouseCode. . . . .     3 SNN  Default Warehouse Code. . . . .WAREHOUSE
                                                FmtType:CHARNUM DepVal:REQUIR
                                                ED ValGroup:NotCurrentItemTyp
                                                e Notes: {IM1$(72,3)}
  35  PrimaryAPDivisionNo . . . . .     2 SNN  Primary AP Division Number. . .APDIVISION
                                                Mask:00 FmtType:ZEROFILL
                                                ValGroup:NotCurrentItemType
                                                Notes: {IM1$(85,2)}
  36  PrimaryVendorNo . . . . . . .     7 SYN  Primary Vendor Number . . . . .VENDORNO
                                                FmtType:MASTERNUM ValGroup:No
                                                tCurrentItemType ChngTag:Repl
                                                ace1/PrimaryAPDivisionNo$
                                                Notes: {IM1$(87,7)}
  37  ImageFile . . . . . . . . . .    30 SNN  Image File. . . . . . . . . . .IMAGE
                                                ValGroup:NotCurrentItemType
                                                Notes: {IM1$(94,30)}
  38  LastSoldDate. . . . . . . . .     8 SNN  Last Sold Date. . . . . . . . .DATE
                                                ValGroup:NotCurrentItemType
                                                ChngTag:CopyMax/LastSoldDate$
                                                 Notes: {IM1$ (133,6) }{
                                                IM1$ (133,6) }
  39  LastReceiptDate . . . . . . .     8 SNN  Last Receipt Date . . . . . . .DATE
                                                ValGroup:NotCurrentItemType
                                                ChngTag:CopyMax/LastReceiptDa
                                                te$ Notes: {IM1$ (139,6) }
  40  Category1 . . . . . . . . . .    10 SYN  Category 1. . . . . . . . . . .CATEGORYCODE
                                                ValGroup:NotCurrentItemType
                                                Notes: {IM1$(145,10)}
  41  Category2 . . . . . . . . . .    10 SYN  Category 2. . . . . . . . . . .CATEGORYCODE
                                                ValGroup:NotCurrentItemType
                                                Notes: {IM1$(155,10)}
  42  Category3 . . . . . . . . . .    10 SYN  Category 3. . . . . . . . . . .CATEGORYCODE
                                                ValGroup:NotCurrentItemType
                                                Notes: {IM1$(165,10)}
  43  Category4 . . . . . . . . . .    10 SYN  Category 4. . . . . . . . . . .CATEGORYCODE
                                                ValGroup:NotCurrentItemType
                                                Notes: {IM1$(175,10)}
  44  SalesPromotionCode. . . . . .    10 SYN  Sales Promotion Code. . . . . .SALESPROMOCODE
                                                DepVal:REQUIRED ValGroup:NotC
                                                urrentItemType Notes: {IM1$
                                                (185,10) }
  45  SaleStartingDate. . . . . . .     8 SNN  Sale Starting Date. . . . . . .DATE
                                                ValGroup:NotCurrentItemType
                                                Notes: {IM1$ (195,6) }
  46  SaleEndingDate. . . . . . . .     8 SNN  Sale Ending Date. . . . . . . .DATE
                                                ValGroup:NotCurrentItemType
                                                Notes: {IM1$ (201,6) }
  47  SaleMethod. . . . . . . . . .     1 SYY  Sale Method . . . . . . . . . .
                                                DfltVal:N Valid:D,P,N
                                                ValGroup:NotCurrentItemType
                                                Notes: D=Sales Discount,
                                                P=Sale Price, N=None
                                                {IM1$(207,1)}
  48  ExplodeKitItems . . . . . . .     1 SYY  Explode Kit Items . . . . . . .
                                                DfltVal:N Valid:A,N,P
                                                ValGroup:NotCurrentItemType
                                                Notes: A=Always, N=Never,
                                                P=Prompt {IM1$(213,1)}
  49  ShipWeight. . . . . . . . . .    10 SNN  Ship Weight . . . . . . . . . .
                                                ValGroup:NotCurrentItemType
                                                Notes: {IM1$(75,10)}
  50  CommentText . . . . . . . . .  2048 SNN  Comment Text. . . . . . . . . .COMMENT
                                                ValGroup:NotCurrentItemType
                                                Notes: {SO7$(16,100)}
  51  RestockingMethod. . . . . . .     1 SYY  Restocking Method . . . . . . .
                                                DfltVal:N Valid:N,F,C,P
                                                ValGroup:NotCurrentItemType
                                                Notes: N=None, F=Fixed, C=%
                                                of Cost, P=% of Price
  52  NextLotSerialNo . . . . . . .    15 SNN  Next Lot/Serial Number. . . . .LOTSERIALNO
                                                ValGroup:NotCurrentItemType
                                                Notes: {IM1$(219,15) }
  53  InventoryCycle. . . . . . . .     1 SNN  Inventory Cycle . . . . . . . .
                                                ValGroup:NotCurrentItemType
                                                Notes: {IM1$(234,1) }
  54  RoutingNo . . . . . . . . . .    20 SYN  Routing Number. . . . . . . . .
                                                ValGroup:NotCurrentItemType
                                                Notes: {IM1$(235,20) }
  55  ProcurementType . . . . . . .     1 SYY  Procurement Type. . . . . . . .
                                                DfltVal:B Valid:B,M,S
                                                ValGroup:NotCurrentItemType
                                                Notes: B=Buy, M=Make,
                                                S=Subcontract, {IM1$(255,1)}
  56  PlannerCode . . . . . . . . .     3 SYN  Planner Code. . . . . . . . . .BUYERPLANNERCODE
                                                FmtType:CHARNUM ValGroup:NotC
                                                urrentItemType Notes:
                                                {IM1$(256,3) }
  57  BuyerCode . . . . . . . . . .     3 SYN  Buyer Code. . . . . . . . . . .BUYERPLANNERCODE
                                                FmtType:CHARNUM ValGroup:NotC
                                                urrentItemType Notes:
                                                {IM1$(259,3) }
  58  LowLevelCode. . . . . . . . .     2 SYN  Low Level Code. . . . . . . . .
                                                Mask:00 ValGroup:NotCurrentIt
                                                emType Notes: {IM1$(263,2)}
  59  PlannedByMRP. . . . . . . . .     1 SYY  Planned By Mrp. . . . . . . . .YESNO
                                                DfltVal:N Valid:Y,N
                                                ValGroup:NotCurrentItemType
                                                Notes: {IM1$ (262,1) }
  60  VendorItemCode. . . . . . . .    30 SNN  Vendor Item Code. . . . . . . .
                                                ValGroup:NotCurrentItemType
                                                Notes: {PO7$(60,30)}
  61  SetupCharge . . . . . . . . .     1 SYY  Setup Charge. . . . . . . . . .YESNO
                                                DfltVal:N Valid:Y,N
                                                ValGroup:NotCurrentItemType
  62  AttachmentFileName. . . . . .    30 SNN  Attachment File Name. . . . . .
                                                Notes: From SO Only IT3$(67,
                                                30)
  63  ItemImageWidthInPixels. . . .  4.0  NNN  Item Image Width In Pixels. . .
                                                ValGroup:NotCurrentItemType
                                                Notes: {IT3[0]}
  64  ItemImageHeightInPixels . . .  4.0  NNN  Item Image Height In Pixels . .
                                                ValGroup:NotCurrentItemType
                                                Notes: {IT3[1]}
  65  StandardUnitCost. . . . . . . 16.6  NNN  Standard Unit Cost. . . . . . .COST
                                                Mask:##,###,###.000000-
                                                ValGroup:NotCurrentItemType
                                                Notes: {IM1[6]} {SO7[0]}
  66  StandardUnitPrice . . . . . . 16.6  NNN  Standard  Unit Price. . . . . .PRICE
                                                Mask:##,###,###.000000-
                                                ValGroup:NotCurrentItemType
                                                Notes: {IM1[5]} {SO7[1]}
  67  LastTotalUnitCost . . . . . . 16.6  NNN  Last Total Unit Cost. . . . . .COST
                                                Mask:##,###,###.000000-
                                                ValGroup:NotCurrentItemType
                                                ChngTag:CopyMax/LastReceiptDa
                                                te$ Notes: {IM1[7]}
  68  AverageUnitCost . . . . . . . 16.6  NNN  Average Unit Cost . . . . . . .COST
                                                Read Only:Y Mask:##,###,
                                                ###.000000- ValGroup:NotCurre
                                                ntItemType Notes: {IM1[8]}
  69  SalesPromotionPrice . . . . . 16.6  NNN  Sales Promotion Price . . . . .PRICE
                                                Mask:##,###,###.000000-
                                                ValGroup:NotCurrentItemType
                                                Notes: {IM1[9]}
  70  SuggestedRetailPrice. . . . . 16.6  NNN  Suggested Retail Price. . . . .PRICE
                                                Mask:##,###,###.000000-
                                                ValGroup:NotCurrentItemType
                                                Notes: {IM1[4]}
  71  SalesPromotionDiscountPercent 12.3  NNN  Sales Promotion Discount Percen
                                                Mask:#######0.000 ValGroup:No
                                                tCurrentItemType
  72  TotalQuantityOnHand . . . . . 16.6  NNN  Total Quantity On Hand. . . . .QUANTITY
                                                Read Only:Y Mask:##,###,
                                                ###.000000- ValGroup:NotCurre
                                                ntItemType ChngTag:Sum
                                                Notes: {IM1[10] }
  73  AverageBackOrderFillDays. . .  5.0  NNN  Average Back Order Fill Days. .
                                                Mask:####0 ValGroup:NotCurren
                                                tItemType Notes: { IM1 [11] }
  74  LastAllocatedUnitCost . . . . 16.6  NNN  Last Allocated Unit Cost. . . .COST
                                                Mask:##,###,###.000000-
                                                ValGroup:NotCurrentItemType
                                                Notes: { IM1 [12] }
  75  CommissionRate. . . . . . . .  9.3  NNN  Commission Rate . . . . . . . .COMMISSIONRATE
                                                Mask:###0.000 ValGroup:NotCur
                                                rentItemType Notes: {IM1[0]}
  76  BaseCommAmt . . . . . . . . . 12.2  NNN  Base Commission Amount. . . . .MISCAMOUNT
                                                Mask:##,###,###.00-
                                                ValGroup:NotCurrentItemType
                                                Notes: {IM1[1]}
  77  PurchaseUMConvFctr. . . . . . 12.4  NNN  Purchase Unit of Measure ConverUMCONVFACTOR
                                                Mask:#####0.0000 DepVal:REQUI
                                                RED ValGroup:NotCurrentItemTy
                                                pe Notes: {IM1[2]}
  78  SalesUMConvFctr . . . . . . . 12.4  NNN  Sales Unit of Measure ConversioUMCONVFACTOR
                                                Mask:#####0.0000 DepVal:REQUI
                                                RED ValGroup:NotCurrentItemTy
                                                pe Notes: {IM1[3]}
  79  Volume. . . . . . . . . . . . 11.4  NNN  Volume. . . . . . . . . . . . .
                                                Mask:##,##0.0000 ValGroup:Not
                                                CurrentItemType Notes:
                                                {IM1[13]}
  80  RestockingCharge. . . . . . . 11.3  NNN  Restocking Charge . . . . . . .
                                                Mask:###,##0.000 ValGroup:Not
                                                CurrentItemType Notes:
                                                {IM1[14]}
  81  TotalInventoryValue . . . . . 12.2  NNN  Total Inventory Value . . . . .
                                                Read Only:Y ValGroup:NotCurre
                                                ntItemType ChngTag:Sum
  82  DateCreated . . . . . . . . .     8 SNY  Creation Date . . . . . . . . .DATE
                                                Read Only:Y Notes: YYYYMMDD
  83  TimeCreated . . . . . . . . .     8 SNY  Creation Time . . . . . . . . .
                                                Read Only:Y
  84  UserCreatedKey. . . . . . . .    10 SYY  Creation User ID. . . . . . . .USER
                                                Read Only:Y Mask:0000000000
                                                FmtType:ZEROFILL
  85  DateUpdated . . . . . . . . .     8 SNY  Last Update Date. . . . . . . .DATE
                                                Read Only:Y Notes: YYYYMMDD
  86  TimeUpdated . . . . . . . . .     8 SNY  Last Update Time. . . . . . . .
                                                Read Only:Y
  87  UserUpdatedKey. . . . . . . .    10 SYY  Last Update User ID . . . . . .USER
                                                Read Only:Y Mask:0000000000
                                                FmtType:ZEROFILL