     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