IM_DataEntryCostCalcCommit IM Cost Tiers Committed During Cost CalcuRel: 4.40 Bld: 398 8/28/2009 Bus Obj: N/A SQL Def: Y SysDB: N "MAS_"+%C$+"/IM"+%C$+"/IM_DataEntryCostCalcCommit.M4T"
KPRIMARY: DataEntryType+DataEntryHeaderKey+DataEntryDetailLineKey+ItemCode+WarehouseCode+TierType+Group Sort(**) **=Case Sensitive KBATCH: BatchNo+DataEntryType+DataEntryHeaderKey+DataEntryDetailLineKey+ItemCode+WarehouseCode+TierType +GroupSort(**) **=Case Sensitive KSOURCEJOURNAL: SourceJournal+RegisterNo+DataEntryType+DataEntryHeaderKey+DataEntryDetailLineKey+ItemCo de+WarehouseCode+TierType+GroupSort
Fld Column Name M/L TUR Description/Notes Class
1 DataEntryType . . . . . . . . 2 SYY Data Entry Type . . . . . . . . Valid:11,12,14,15,16,18,21, 32,38 Notes: 11=I/M Sale, 12=I/M Iss, 14=I/M Trans Out, 15=Trans In, 16=I/M Adj, 18=I/M Rcpt, 21=S/O Sale, 32=B/M Comp Relieve, 38-B/M Item Produced 2 DataEntryHeaderKey. . . . . . 50 SNY Data Entry Header Key . . . . . 3 DataEntryDetailLineKey. . . . 6 SNY Data Entry Detail Line Key. . . 4 ItemCode. . . . . . . . . . . 30 SYY Item Code . . . . . . . . . . .ITEMCODE 5 WarehouseCode . . . . . . . . 3 SYY Warehouse Code. . . . . . . . .WAREHOUSE FmtType:CHARNUM 6 TierType. . . . . . . . . . . 1 SNN Tier Type . . . . . . . . . . . Valid:0,1,2,3,4 Notes: 0=Average, 1=fifo, 2=lifo, 3=Lot, 4=Ser 7 GroupSort . . . . . . . . . . 16 SNY Group Sort. . . . . . . . . . . FmtType:CHARNUM Notes: ReceiptDate+ReceiptNo 8 ReceiptDate . . . . . . . . . 8 SNN Receipt Date. . . . . . . . . .DATE 9 ReceiptNo . . . . . . . . . . 8 SNN Receipt Number. . . . . . . . . 10 LotSerialNo . . . . . . . . . 15 SNN Lot Serial Number . . . . . . . 11 BatchNo . . . . . . . . . . . 5 SYY Batch Number. . . . . . . . . .BATCHNO 12 Committed . . . . . . . . . . 1 SYN Committed . . . . . . . . . . .YESNO DfltVal:N Valid:Y,N 13 SourceJournal . . . . . . . . 2 SNN Source Journal. . . . . . . . .SOURCEJOURNAL 14 RegisterNo. . . . . . . . . . 6 SNN Register Number . . . . . . . . FmtType:ZEROFILL 15 QuantityCommitted . . . . . . 16.6 NNN Quantity Committed. . . . . . .QUANTITY Mask:##,###,###.000000- 16 CostCommitted . . . . . . . . 12.2 NNN Cost Committed. . . . . . . . .COST Mask:##,###,###.00- 17 AllocationCommitted . . . . . 12.2 NNN Allocatiion Committed . . . . .COST Mask:##,###,###.00- 18 DateCreated . . . . . . . . . 8 SNY Date Created. . . . . . . . . .DATE Read Only:Y Notes: YYYYMMDD 19 TimeCreated . . . . . . . . . 8 SNY Time Created. . . . . . . . . . Read Only:Y 20 UserCreatedKey. . . . . . . . 10 SYY User Created Key. . . . . . . .USER Read Only:Y Mask:0000000000