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