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