     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