CI_Item CI Item Master Rel: 6.00 Bld: 1024 3/10/2020 Physical Path: "MAS_"+%C$+"/CI"+%C$+"/CI_Item.M4T" SQL Create: Y SQL Sys DB: N SQL Null Dates: N Exclude V/I: N Create Tbl: N Bus Obj: CI_ItemCode_bus IM_TransactionRegister_upd PO_ReceiptRegister_upd BM_DisassemblyRegister_upd SO_SalesJournal_upd BM_ProductionRegister_upd Record ID Column: ItemType
KPRIMARY: ItemCode KITEMTYPE: ItemType+ItemCode KEXTENDEDDESC: ExtendedDescriptionKey+ItemCode KPRODLINE: ProductLine+ItemCode KPROMOCODE: SalesPromotionCode+ItemCode KDESCRIPTION: ItemCodeDesc+ItemCode+ItemType
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 eBusiness 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 InactiveItem. . . . . . . . . 1 SYY Inactive Item . . . . . . . . .YESNO DfltVal:N Valid:Y,N ValGroup:NotCurrentItemType 19 ConfirmCostIncrInRcptOfGoods. 1 SYY Confirm Cost Increase in ReceipYESNO DfltVal:N Valid:Y,N ValGroup:NotCurrentItemType Notes: {IM1$(271,1)} 20 WarrantyCode. . . . . . . . . 10 SYN Warranty Code . . . . . . . . .WARRANTYCODE ValGroup:NotCurrentItemType Notes: {IM1$(272,10)} 21 SalesUnitOfMeasure. . . . . . 4 SYN Sales Unit of Measure . . . . .UNITOFMEASURE DepVal:REQUIRED ValGroup:NotC urrentItemType Notes: {IM1$(68,4)} {SO7$(59,4)} 22 PurchaseUnitOfMeasure . . . . 4 SYN Purchase Unit of Measure. . . .UNITOFMEASURE DepVal:REQUIRED ValGroup:NotC urrentItemType Notes: {IM1$(64,4)} 23 StandardUnitOfMeasure . . . . 4 SYN Standard Unit of Measure. . . .UNITOFMEASURE DepVal:REQUIRED ValGroup:NotC urrentItemType Notes: {IM1$(60,4)} 24 PostToGLByDivision. . . . . . 1 SYY Post to G/L By Division . . . .YESNO DfltVal:N Valid:Y,N ValGroup:NotCurrentItemType Notes: Used by AR Sales Codes 25 SalesAcctKey. . . . . . . . . 9 SNN Sales Account Key . . . . . . .ACCOUNT ValGroup:NotCurrentItemType Notes: Used by Misc. Charges, Misc. Items and AR Sales Codes {SO7$(46,9)} 26 CostOfGoodsSoldAcctKey. . . . 9 SYN Cost Of Goods Sold Account Key.ACCOUNT ValGroup:NotCurrentItemType Notes: {SO7$(63,9)} 27 InventoryAcctKey. . . . . . . 9 SYN Inventory Account Key . . . . .ACCOUNT ValGroup:NotCurrentItemType Notes: Used by AR Sales Codes, {SO7$(72,9)} 28 PurchaseAcctKey . . . . . . . 9 SYN Purchase Account Key. . . . . .ACCOUNT ValGroup:NotCurrentItemType Notes: Used by Misc. Items. {SO7$(72,9)} 29 ManufacturingCostAcctKey. . . 9 SYN Manufacturing Cost Account Key.ACCOUNT ValGroup:NotCurrentItemType 30 TaxClass. . . . . . . . . . . 2 SYN Tax Class . . . . . . . . . . .TAXCLASS DepVal:REQUIRED ValGroup:NotC urrentItemType Notes: {IM1$(269,2)} {SO7$(81,2)} 31 PurchasesTaxClass . . . . . . 2 SYN Purchases Tax Class . . . . . .TAXCLASS DepVal:REQUIRED ValGroup:NotC urrentItemType 32 ProductLine . . . . . . . . . 4 SYN Product Line. . . . . . . . . .PRODUCTLINE FmtType:CHARNUM DepVal:REQUIR ED ValGroup:NotCurrentItemTyp e Notes: {IM1$(46,4)} 33 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)} 34 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)} 35 DefaultWarehouseCode. . . . . 3 SNN Default Warehouse Code. . . . .WAREHOUSE FmtType:CHARNUM DepVal:REQUIR ED ValGroup:NotCurrentItemTyp e Notes: {IM1$(72,3)} 36 PrimaryAPDivisionNo . . . . . 2 SNN Primary AP Division Number. . .APDIVISION Mask:00 FmtType:ZEROFILL ValGroup:NotCurrentItemType Notes: {IM1$(85,2)} 37 PrimaryVendorNo . . . . . . . 7 SYN Primary Vendor Number . . . . .VENDORNO FmtType:MASTERNUM ValGroup:No tCurrentItemType ChngTag:Repl ace1/PrimaryAPDivisionNo$ Notes: {IM1$(87,7)} 38 ImageFile . . . . . . . . . . 30 SNN Image File. . . . . . . . . . .IMAGE ValGroup:NotCurrentItemType Notes: {IM1$(94,30)} 39 LastSoldDate. . . . . . . . . 8 SNN Last Sold Date. . . . . . . . .DATE ValGroup:NotCurrentItemType ChngTag:CopyMax/LastSoldDate$ Notes: {IM1$ (133,6) }{ IM1$ (133,6) } 40 LastReceiptDate . . . . . . . 8 SNN Last Receipt Date . . . . . . .DATE ValGroup:NotCurrentItemType ChngTag:CopyMax/LastReceiptDa te$ Notes: {IM1$ (139,6) } 41 LastPhysicalCountDate . . . . 8 SNN Last Physical Count Date. . . .DATE 42 Category1 . . . . . . . . . . 10 SYN Category 1. . . . . . . . . . .CATEGORYCODE ValGroup:NotCurrentItemType Notes: {IM1$(145,10)} 43 Category2 . . . . . . . . . . 10 SYN Category 2. . . . . . . . . . .CATEGORYCODE ValGroup:NotCurrentItemType Notes: {IM1$(155,10)} 44 Category3 . . . . . . . . . . 10 SYN Category 3. . . . . . . . . . .CATEGORYCODE ValGroup:NotCurrentItemType Notes: {IM1$(165,10)} 45 Category4 . . . . . . . . . . 10 SYN Category 4. . . . . . . . . . .CATEGORYCODE ValGroup:NotCurrentItemType Notes: {IM1$(175,10)} 46 SalesPromotionCode. . . . . . 10 SYN Sales Promotion Code. . . . . .SALESPROMOCODE DepVal:REQUIRED ValGroup:NotC urrentItemType Notes: {IM1$ (185,10) } 47 SaleStartingDate. . . . . . . 8 SNN Sale Starting Date. . . . . . .DATE ValGroup:NotCurrentItemType Notes: {IM1$ (195,6) } 48 SaleEndingDate. . . . . . . . 8 SNN Sale Ending Date. . . . . . . .DATE ValGroup:NotCurrentItemType Notes: {IM1$ (201,6) } 49 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)} 50 ExplodeKitItems . . . . . . . 1 SYY Explode Kit Items . . . . . . . DfltVal:N Valid:A,N,P ValGroup:NotCurrentItemType Notes: A=Always, N=Never, P=Prompt {IM1$(213,1)} 51 ShipWeight. . . . . . . . . . 10 SNN Ship Weight . . . . . . . . . . ValGroup:NotCurrentItemType Notes: {IM1$(75,10)} 52 CommentText . . . . . . . . . 2048 SNN Comment Text. . . . . . . . . .COMMENT ValGroup:NotCurrentItemType Notes: {SO7$(16,100)} 53 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 54 NextLotSerialNo . . . . . . . 15 SNN Next Lot/Serial Number. . . . .LOTSERIALNO ValGroup:NotCurrentItemType Notes: {IM1$(219,15) } 55 InventoryCycle. . . . . . . . 1 SNN Inventory Cycle . . . . . . . . ValGroup:NotCurrentItemType Notes: {IM1$(234,1) } 56 RoutingNo . . . . . . . . . . 20 SYN Routing Number. . . . . . . . . ValGroup:NotCurrentItemType Notes: {IM1$(235,20) } 57 ProcurementType . . . . . . . 1 SYY Procurement Type. . . . . . . . DfltVal:B Valid:B,M,S ValGroup:NotCurrentItemType Notes: B=Buy, M=Make, S=Subcontract, {IM1$(255,1)} 58 PlannerCode . . . . . . . . . 3 SYN Planner Code. . . . . . . . . .BUYERPLANNERCODE FmtType:CHARNUM ValGroup:NotC urrentItemType Notes: {IM1$(256,3) } 59 BuyerCode . . . . . . . . . . 3 SYN Buyer Code. . . . . . . . . . .BUYERPLANNERCODE FmtType:CHARNUM ValGroup:NotC urrentItemType Notes: {IM1$(259,3) } 60 LowLevelCode. . . . . . . . . 2 SYN Low Level Code. . . . . . . . . Mask:00 ValGroup:NotCurrentIt emType Notes: {IM1$(263,2)} 61 PlannedByMRP. . . . . . . . . 1 SYY Planned By Mrp. . . . . . . . .YESNO DfltVal:N Valid:Y,N ValGroup:NotCurrentItemType Notes: {IM1$ (262,1) } 62 VendorItemCode. . . . . . . . 30 SNN Vendor Item Code. . . . . . . . ValGroup:NotCurrentItemType Notes: {PO7$(60,30)} 63 SetupCharge . . . . . . . . . 1 SYY Setup Charge. . . . . . . . . .YESNO DfltVal:N Valid:Y,N ValGroup:NotCurrentItemType 64 AttachmentFileName. . . . . . 30 SNN Attachment File Name. . . . . . Notes: From SO Only IT3$(67, 30) 65 ItemImageWidthInPixels. . . . 4.0 NNN Item Image Width In Pixels. . . ValGroup:NotCurrentItemType Notes: {IT3[0]} 66 ItemImageHeightInPixels . . . 4.0 NNN Item Image Height In Pixels . . ValGroup:NotCurrentItemType Notes: {IT3[1]} 67 StandardUnitCost. . . . . . . 16.6 NNN Standard Unit Cost. . . . . . .COST Mask:##,###,###.000000- ValGroup:NotCurrentItemType Notes: {IM1[6]} {SO7[0]} 68 StandardUnitPrice . . . . . . 16.6 NNN Standard Unit Price. . . . . .PRICE Mask:##,###,###.000000- ValGroup:NotCurrentItemType Notes: {IM1[5]} {SO7[1]} 69 LastTotalUnitCost . . . . . . 16.6 NNN Last Total Unit Cost. . . . . .COST Mask:##,###,###.000000- ValGroup:NotCurrentItemType ChngTag:CopyMax/LastReceiptDa te$ Notes: {IM1[7]} 70 AverageUnitCost . . . . . . . 16.6 NNN Average Unit Cost . . . . . . .COST Read Only:Y Mask:##,###, ###.000000- ValGroup:NotCurre ntItemType Notes: {IM1[8]} 71 SalesPromotionPrice . . . . . 16.6 NNN Sales Promotion Price . . . . .PRICE Mask:##,###,###.000000- ValGroup:NotCurrentItemType Notes: {IM1[9]} 72 SuggestedRetailPrice. . . . . 16.6 NNN Suggested Retail Price. . . . .PRICE Mask:##,###,###.000000- ValGroup:NotCurrentItemType Notes: {IM1[4]} 73 SalesPromotionDiscountPercent 12.3 NNN Sales Promotion Discount Percen Mask:#######0.000 ValGroup:No tCurrentItemType 74 TotalQuantityOnHand . . . . . 16.6 NNN Total Quantity On Hand. . . . .QUANTITY Read Only:Y Mask:##,###, ###.000000- ValGroup:NotCurre ntItemType ChngTag:Sum Notes: {IM1[10] } 75 AverageBackOrderFillDays. . . 5.0 NNN Average Back Order Fill Days. . Mask:####0 ValGroup:NotCurren tItemType Notes: { IM1 [11] } 76 LastAllocatedUnitCost . . . . 16.6 NNN Last Allocated Unit Cost. . . .COST Mask:##,###,###.000000- ValGroup:NotCurrentItemType Notes: { IM1 [12] } 77 CommissionRate. . . . . . . . 9.3 NNN Commission Rate . . . . . . . .COMMISSIONRATE Mask:###0.000 ValGroup:NotCur rentItemType Notes: {IM1[0]} 78 BaseCommAmt . . . . . . . . . 12.2 NNN Base Commission Amount. . . . .MISCAMOUNT Mask:##,###,###.00- ValGroup:NotCurrentItemType Notes: {IM1[1]} 79 PurchaseUMConvFctr. . . . . . 12.4 NNN Purchase Unit of Measure ConverUMCONVFACTOR Mask:#####0.0000 DepVal:REQUI RED ValGroup:NotCurrentItemTy pe Notes: {IM1[2]} 80 SalesUMConvFctr . . . . . . . 12.4 NNN Sales Unit of Measure ConversioUMCONVFACTOR Mask:#####0.0000 DepVal:REQUI RED ValGroup:NotCurrentItemTy pe Notes: {IM1[3]} 81 Volume. . . . . . . . . . . . 11.4 NNN Volume. . . . . . . . . . . . . Mask:##,##0.0000 ValGroup:Not CurrentItemType Notes: {IM1[13]} 82 RestockingCharge. . . . . . . 11.3 NNN Restocking Charge . . . . . . . Mask:###,##0.000 ValGroup:Not CurrentItemType Notes: {IM1[14]} 83 TotalInventoryValue . . . . . 15.2 NNN Total Inventory Value . . . . . Read Only:Y ValGroup:NotCurre ntItemType ChngTag:Sum 84 DateCreated . . . . . . . . . 8 SNY Creation Date . . . . . . . . .DATE Read Only:Y Notes: YYYYMMDD 85 TimeCreated . . . . . . . . . 8 SNY Creation Time . . . . . . . . .TIME Read Only:Y 86 UserCreatedKey. . . . . . . . 10 SYY Creation User ID. . . . . . . .USER Read Only:Y Mask:0000000000 FmtType:ZEROFILL 87 DateUpdated . . . . . . . . . 8 SNY Last Update Date. . . . . . . .DATE Read Only:Y Notes: YYYYMMDD 88 TimeUpdated . . . . . . . . . 8 SNY Last Update Time. . . . . . . .TIME Read Only:Y 89 UserUpdatedKey. . . . . . . . 10 SYY Last Update User ID . . . . . .USER Read Only:Y Mask:0000000000 FmtType:ZEROFILL 90 CommodityCode . . . . . . . . 12 SNN Commodity Code. . . . . . . . .COMMODITYCODE FmtType:CHARNUM