SO_SalesOrderRecap SO Sales Order Recap Rel: 4.40 Bld: 398 8/28/2009 Bus Obj: SO_SalesOrder_bus:CO SQL Def: N SysDB: N "MAS_"+%C$+"/SO"+%C$+"/SO_SalesOrderRecap.M4T"
KPRIMARY: SalesOrderNo
Fld Column Name M/L TUR Description/Notes Class
1 SalesOrderNo. . . . . . . . . 7 SYY Sales Order Number. . . . . . .SALESORDERNO FmtType:CHARNUM Notes: {SON$(1,7)} 2 OrderDate . . . . . . . . . . 8 SNN Order Date. . . . . . . . . . .DATE Notes: {SON$(8,6)} 3 OrderType . . . . . . . . . . 1 SYN Order Type. . . . . . . . . . . Valid:S,B,M,R,Q,P Notes: S=Standard, B=Backorder, M=Master, R=Repeating, Q=Quote, P=Prospect Quote {SON$(14,1)} 4 ARDivisionNo. . . . . . . . . 2 SNN AR Division Number. . . . . . .ARDIVISION Mask:00 FmtType:ZEROFILL Notes: {SON$(15,2)} 5 CustomerNo. . . . . . . . . . 20 SYN Customer Number . . . . . . . .CUSTOMERNO FmtType:MASTERNUMC ChngTag:Re place1/ARDivisionNo$ Notes: {SON$(17,7)} 6 BillToName. . . . . . . . . . 30 SNN Bill To Name. . . . . . . . . .NAME Notes: {SON$(24,30)} 7 OrderStatus . . . . . . . . . 1 SYN OrderStatus . . . . . . . . . . Valid:N,O,C,H,Z Notes: N=New, O=Open, C=Completed, H=on Hold, Z=Deleted {SON$(54,1)} 8 ShipExpireDate. . . . . . . . 8 SNN Ship ExpirationDate . . . . . .DATE Notes: {SON$(55,6)} 9 Comment . . . . . . . . . . . 30 SNN Comment . . . . . . . . . . . .COMMENT30 Notes: {SON$(61,30)} 10 LastInvoiceOrderDate. . . . . 8 SNN Last Invoice Order Date . . . .DATE Notes: {SON$(91,6)} 11 LastInvoiceOrderNo. . . . . . 7 SYN Last InvoiceOrder Number. . . .SALESORDERNO Notes: {SON$(97,7)} 12 RMANo . . . . . . . . . . . . 7 SNN RMA Number. . . . . . . . . . . 13 CRMCompanyID. . . . . . . . . 11 SNN CRM Company ID. . . . . . . . . 14 CRMCompanyName. . . . . . . . 40 SNN CRM Company Name. . . . . . . . 15 OrderTotal. . . . . . . . . . 13.2 NNN Order Total . . . . . . . . . .AMOUNT Mask:###,###,###.00 Notes: {SON[0]} 16 DateUpdated . . . . . . . . . 8 SNN Last Update Date. . . . . . . .DATE Read Only:Y Notes: YYYYMMDD 17 TimeUpdated . . . . . . . . . 8 SNN Last Update Time. . . . . . . . Read Only:Y 18 UserUpdatedKey. . . . . . . . 10 SYN Last Update User ID . . . . . .USER Read Only:Y Mask:0000000000 FmtType:ZEROFILL