SO_SalesHistory SO Sales History Rel: 4.40 Bld: 398 8/28/2009 Bus Obj: SO_SalesJournal_upd,SO_SalesHistory_bus SQL Def: Y SysDB: N "MAS_"+%C$+"/SO"+%C$+"/SO_SalesHistory.M4T"
KPRIMARY: ARDivisionNo+CustomerNo+ItemCode+ItemType+ProductLine+WarehouseCode+PostingDate+InvoiceDate KITEM: ItemCode KPRODUCTLINE: ProductLine KWAREHOUSE: WarehouseCode KWHSEITEM: WarehouseCode+ItemCode KWHSEPRODLINE: WarehouseCode+ProductLine KTRANSDATE: InvoiceDate KPOSTINGDATE: PostingDate KITEMPLWHSE: ItemCode+ProductLine+WarehouseCode KPRODLNWHSE: ProductLine+WarehouseCode KITEMTYPE: ItemType KCUSTOMER: ARDivisionNo+CustomerNo KDIVISION: ARDivisionNo KCUSTPRODLINE: ARDivisionNo+CustomerNo+ProductLine
Fld Column Name M/L TUR Description/Notes Class
1 ARDivisionNo. . . . . . . . . 2 SNY AR Division Number. . . . . . .ARDIVISION Mask:00 FmtType:ZEROFILL 2 CustomerNo. . . . . . . . . . 20 SYY Customer Number . . . . . . . .CUSTOMERNO FmtType:MASTERNUMC ChngTag:Re place1/ARDivisionNo$ 3 ItemCode. . . . . . . . . . . 30 SYY Item Code . . . . . . . . . . .ITEMCODE ChngTag:Replace0 4 ItemType. . . . . . . . . . . 1 SNY Item Type . . . . . . . . . . . Valid:1,2,3,4,5 Notes: 1=Regular Item, 2=Special Item, 3=Charge Item, 4=Comment Item, 5=Miscellaneo us Item 5 ProductLine . . . . . . . . . 4 SYN Product Line. . . . . . . . . .PRODUCTLINE FmtType:CHARNUM 6 WarehouseCode . . . . . . . . 3 SYN Warehouse Code. . . . . . . . .WAREHOUSE FmtType:CHARNUM 7 PostingDate . . . . . . . . . 8 SNN Posting Date. . . . . . . . . .DATE 8 InvoiceDate . . . . . . . . . 8 SNN Invoice Date. . . . . . . . . .DATE 9 DollarsSold . . . . . . . . . 15.2 NNN Dollars Sold. . . . . . . . . . Mask:##,###,###,###.00- ChngTag:Sum 10 CostOfGoodsSold . . . . . . . 15.2 NNN Cost Of Goods Sold. . . . . . .AMOUNT Mask:##,###,###,###.00 ChngTag:Sum 11 QuantityShipped . . . . . . . 16.6 NNN Quantity Shipped. . . . . . . .QUANTITY Mask:##,###,###.000000- ChngTag:Sum 12 QuantityReturned. . . . . . . 16.6 NNN Quantity Returned . . . . . . .QUANTITY Mask:##,###,###.000000- ChngTag:Sum 13 DateUpdated . . . . . . . . . 8 SNN Last Update Date. . . . . . . .DATE Read Only:Y ChngTag:Max Notes: YYYYMMDD 14 TimeUpdated . . . . . . . . . 8 SNN Last Update Time. . . . . . . . Read Only:Y ChngTag:CopyMax/D ateUpdated$ 15 UserUpdatedKey. . . . . . . . 10 SYN Last Update User ID . . . . . .USER Read Only:Y Mask:0000000000 FmtType:ZEROFILL ChngTag:Copy Max/DateUpdated$