IM_TransactionHeader IM Transaction Entry Header Rel: 4.40 Bld: 398 8/28/2009
Bus Obj: IM_Transaction_bus,BC_CommonImport
SQL Def: Y SysDB: N "MAS_"+%C$+"/IM"+%C$+"/IM_TransactionHeader.M4T"
KPRIMARY: TransactionType+EntryNo
KBATCH: BatchNo+TransactionType+EntryNo
Fld Column Name M/L TUR Description/Notes Class
1 TransactionType . . . . . . . 1 SNY Transaction Type. . . . . . . .
Valid:1,2,4,6,8 Notes:
{IMG$(1,1)}1=Sale, 2=Issue,
4=Transfer, 6=Adjustment,
8=Receipt
2 EntryNo . . . . . . . . . . . 8 SYY Entry Number. . . . . . . . . .
FmtType:CHARNUM Next:Transact
ionType$+SEP+EntryNo$ Notes:
{IMG$(2,10)}This an 8 byte
Account Type field.The
last 2 bytes are always
blank.
3 TransactionDate . . . . . . . 8 SNY Transaction Date. . . . . . . .DATE
DfltVal: Notes:
{IMG$(12,8)}
4 Comment . . . . . . . . . . . 30 SNN Comment . . . . . . . . . . . .COMMENT30
Notes: {IMG$(62,30)}
5 DefaultFromWhseCode . . . . . 3 SYY Default From Warehouse Code . .WAREHOUSE
FmtType:CHARNUM Notes:
{IMG$(101,3)}
6 ToWhseCode. . . . . . . . . . 3 SYN To Warehouse Code . . . . . . .WAREHOUSE
FmtType:CHARNUM DepVal:REQUIR
ED Notes: {IMG$(104,3)}
7 BatchNo . . . . . . . . . . . 5 SYY Batch Number. . . . . . . . . .BATCHNO
8 DateCreated . . . . . . . . . 8 SNY Creation Date . . . . . . . . .DATE
Read Only:Y Notes: YYYYMMDD
9 TimeCreated . . . . . . . . . 8 SNY Creation Time . . . . . . . . .
Read Only:Y
10 UserCreatedKey. . . . . . . . 10 SYY Creation User ID. . . . . . . .USER
Read Only:Y Mask:0000000000
11 DateUpdated . . . . . . . . . 8 SNN Last Update Date. . . . . . . .DATE
Read Only:Y Notes: YYYYMMDD
12 TimeUpdated . . . . . . . . . 8 SNN Last Update Time. . . . . . . .
Read Only:Y
13 UserUpdatedKey. . . . . . . . 10 SYN Last Update User ID . . . . . .USER
Read Only:Y Mask:0000000000
FmtType:ZEROFILL