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