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$