CI_ItemTransactionHistory CI Item Transaction History Rel: 4.40 Bld: 398 8/28/2009
Bus Obj: CI_ItemTransactionHistory_bus,PO_ReturnRegister_upd,PO_ReceiptRegister_upd,BM_ProductionRegist
SQL Def: Y SysDB: N "MAS_"+%C$+"/CI"+%C$+"/CI_ItemTransactionHistory.M4T"
kPRIMARY: ItemCode+TransactionDate+TransactionCode+EntryNo+SequenceNo
kITEMYEARPER: ItemCode+FiscalCalYear+FiscalCalPeriod+TransactionDate+TransactionCode+EntryNo+SequenceNo
kTRANDATE: TransactionDate+ItemCode+TransactionCode+EntryNo+SequenceNo
kVENDOR: APDivisionNo+VendorNo+ItemCode+FiscalCalYear+FiscalCalPeriod+ShipToCode+TransactionDate+Transa
ctionCode+EntryNo+SequenceNo
kCUSTOMER: ARDivisionNo+CustomerNo+ItemCode+FiscalCalYear+FiscalCalPeriod+ShipToCode+TransactionDate+Tr
ansactionCode+EntryNo+SequenceNo
Fld Column Name M/L TUR Description/Notes Class
1 ItemCode. . . . . . . . . . . 30 SYY Item Code . . . . . . . . . . .ITEMCODE
ChngTag:Replace0 Notes:
{IM5$(1,15)}
2 TransactionDate . . . . . . . 8 SNY Transaction Date. . . . . . . .DATE
Notes: {IM5$(19,6)}
3 TransactionCode . . . . . . . 2 SYY Transaction Code. . . . . . . .
Valid:AR,IC,BC,WC,BI,BR,BZ,
IA,II,IN,IP,IR,IS,IT,IX,IZ,
PM,PO,SI,SO,SK,WI,WR,PS,SP,
SR,SS,PA,PZ,SZ,WZ Notes:
{IM5$(25,2)}
4 EntryNo . . . . . . . . . . . 10 SYY Entry Number. . . . . . . . . .
FmtType:ZEROFILL Notes:
{IM5$(27,10)}
5 SequenceNo. . . . . . . . . . 6 SNY Sequence Number . . . . . . . .
Mask:000000 FmtType:ZEROFILL
Notes: {IM5$(37,3)}
6 ItemType. . . . . . . . . . . 1 SNY Item Type . . . . . . . . . . .
Read Only:Y Valid:2,3,5
Notes: 2=Special Item,
3=Charge Item, 5=Miscellaneou
s Item
7 APDivisionNo. . . . . . . . . 2 SNN AP Division Number. . . . . . .APDIVISION
Mask:00 Notes: {IM5$(55,2)}
8 VendorNo. . . . . . . . . . . 7 SNN Vendor Number . . . . . . . . .VENDORNO
ChngTag:Replace1/APDivisionNo
$ Notes: {IM5$(57,7)}
9 ARDivisionNo. . . . . . . . . 2 SNN AR Division Number. . . . . . .ARDIVISION
Mask:00 Notes: {IM5$(55,2)}
10 CustomerNo. . . . . . . . . . 20 SNN Customer Number . . . . . . . .CUSTOMERNO
ChngTag:Replace1/ARDivisionNo
$ Notes: {IM5$(57,7)}
11 ReferenceDate . . . . . . . . 8 SNN Reference Date. . . . . . . . .DATE
Notes: {IM5$(64,6)}
12 FiscalCalYear . . . . . . . . 4 SNN Fiscal Calendar Year. . . . . .YEAR
Mask:0000 Notes: {IM5$(70,4)}
13 FiscalCalPeriod . . . . . . . 2 SNN Fiscal Calendar Period. . . . .FISCALPERIOD
Mask:00 Notes: {IM5$(74,2)}
14 ShipToCode. . . . . . . . . . 4 SNN Ship To Code. . . . . . . . . .SHIPTO
Notes: {IM5$(76,4)}
15 InvoiceType . . . . . . . . . 2 SNN Invoice Type. . . . . . . . . .
Valid:CM,DM,IN,CA,AD
16 TransactionQty. . . . . . . . 16.6 NNN Transaction Quantity. . . . . .QUANTITY
Read Only:Y Mask:##,###,
###.000000- ChngTag:Sum
Notes: {IM5[0]}
17 UnitCost. . . . . . . . . . . 16.6 NNN Unit Cost . . . . . . . . . . .COST
Read Only:Y Mask:##,###,
###.000000- Notes: {IM5[1]}
18 AllocatedCost . . . . . . . . 16.6 NNN Allocated Cost. . . . . . . . .COST
Read Only:Y Mask:##,###,
###.000000- Notes: {IM5[2]}
19 UnitPrice . . . . . . . . . . 16.6 NNN Unit Price. . . . . . . . . . .PRICE
Read Only:Y Mask:##,###,
###.000000- Notes: {IM5[3]}
20 ExtendedPrice . . . . . . . . 15.2 NNN Extended Price. . . . . . . . .
Read Only:Y Mask:##,###,###,
###.00- ChngTag:Sum
21 ExtendedCost. . . . . . . . . 15.2 NNN Extended Cost . . . . . . . . .IMCOST
Read Only:Y ChngTag:Sum
22 DateUpdated . . . . . . . . . 8 SNY Last Update Date. . . . . . . .DATE
Read Only:Y Notes: YYYYMMDD
23 TimeUpdated . . . . . . . . . 8 SNY Last Update Time. . . . . . . .
Read Only:Y
24 UserUpdatedKey. . . . . . . . 10 SYY Last Update User ID . . . . . .USER
Read Only:Y Mask:0000000000
FmtType:ZEROFILL