BC_DetailHistory BC Detail History Rel: 4.40 Bld: 398 8/28/2009 Bus Obj: BC_DetailHistory_bus SQL Def: Y SysDB: N "MAS_"+%C$+"/BC"+%C$+"/BC_DetailHistory.M4T"
KPRIMARY: SessionKey+UserID+HeaderKey+DetailKey
Fld Column Name M/L TUR Description/Notes Class
1 SessionKey. . . . . . . . . . 6 SNY Session Key . . . . . . . . . . FmtType:CHARNUM 2 UserID. . . . . . . . . . . . 3 SNY User ID . . . . . . . . . . . . 3 HeaderKey . . . . . . . . . . 6 SNY Header Key. . . . . . . . . . . FmtType:ZEROFILL 4 DetailKey . . . . . . . . . . 6 SNY Detail Key. . . . . . . . . . . FmtType:ZEROFILL 5 LineKey . . . . . . . . . . . 6 SNN Line Key. . . . . . . . . . . . 6 ItemCode. . . . . . . . . . . 30 SYN Item Code . . . . . . . . . . .ITEMCODE DepVal:REQUIRED 7 AlternateWarehouseCode. . . . 3 SYN Alternate Warehouse Code. . . .WAREHOUSE FmtType:CHARNUM 8 PackageNo . . . . . . . . . . 4 SNN Package No. . . . . . . . . . . FmtType:ZEROFILL 9 JobNo . . . . . . . . . . . . 7 SYN Job Number. . . . . . . . . . .JOBNO FmtType:CHARNUM 10 CostCode. . . . . . . . . . . 9 SYN Cost Code . . . . . . . . . . .COSTCODE FmtType:CHARNUM DepVal:REQUIR ED 11 CostType. . . . . . . . . . . 1 SNN Cost Type . . . . . . . . . . . 12 MiscChargeAcctKey . . . . . . 9 SYN B/M Production Entry Misc ChargACCOUNT 13 MiscChargeAccountScanned. . . 41 SYN Miscellaneous Charge Account Sc 14 IMTransAcctKey. . . . . . . . 9 SYN IM Transaction Account Key. . .ACCOUNT 15 IMTransAccountScanned . . . . 41 SYN IM Transaction Account Scanned. 16 TransactionUnitOfMeasure. . . 4 SYN Transaction Unit Of Measure . .UNITOFMEASURE 17 TransactionQuantity . . . . . 16.6 NNN Transaction Quantity. . . . . .QUANTITY Mask:##,###,###.000000- 18 UnitCost. . . . . . . . . . . 16.6 NNN Unit Cost . . . . . . . . . . .COST Mask:##,###,###.000000- 19 UnitPrice . . . . . . . . . . 16.6 NNN Unit Price. . . . . . . . . . .PRICE Mask:##,###,###.000000- 20 Weight. . . . . . . . . . . . 16.6 NNN Weight. . . . . . . . . . . . . Mask:##,###,###.00- 21 AliasItemNo . . . . . . . . . 30 SYN Alias Item Number . . . . . . . DepVal:REQUIRED 22 AliasItemDesc . . . . . . . . 30 SNN Alias Item Description. . . . .DESCRIPTION 23 MD_Line_S1. . . . . . . . . . 30 SNN MD Line String1 . . . . . . . . 24 MD_Line_S2. . . . . . . . . . 30 SNN MD Line String2 . . . . . . . . 25 MD_Line_S3. . . . . . . . . . 30 SNN MD Line String3 . . . . . . . . 26 MD_Line_S4. . . . . . . . . . 30 SNN MD Line String4 . . . . . . . . 27 MD_Line_S5. . . . . . . . . . 30 SNN MD Line String5 . . . . . . . . 28 MD_Line_N1. . . . . . . . . . 16.6 NNN MD Line Number1 . . . . . . . . 29 MD_Line_N2. . . . . . . . . . 16.6 NNN MD Line Number2 . . . . . . . . 30 MD_Line_N3. . . . . . . . . . 16.6 NNN MD Line Number3 . . . . . . . . 31 MD_Line_N4. . . . . . . . . . 16.6 NNN MD Line Number4 . . . . . . . . 32 MD_Line_N5. . . . . . . . . . 16.6 NNN MD Line Number5 . . . . . . . .