     SO_GrossProfitJournalWrk              SO Gross Profit Journal Work    Rel: 4.40  Bld: 398  8/28/2009
     Bus Obj: SO_SalesJournal_upd
     SQL Def: Y  SysDB: N                       "MAS_"+%C$+"/SO"+%C$+"/SO_GrossProfitJournalWrk"+%S$+".M4T"

     KPRIMARY: SortField

     Fld  Column Name                     M/L TUR  Description/Notes              Class

       1  SortField . . . . . . . . . .   127 SNN  Sort Field. . . . . . . . . . .
       2  GroupField. . . . . . . . . .     2 SNN  Group Field . . . . . . . . . .
       3  InvoiceNo . . . . . . . . . .     7 SNN  Invoice Number. . . . . . . . .INVOICE
       4  LineKey . . . . . . . . . . .     6 SNN  Line Key. . . . . . . . . . . .
       5  LineSeqNo . . . . . . . . . .    14 SNN  Line Sequence Number. . . . . .
       6  BatchNo . . . . . . . . . . .     5 SNN  Batch Number. . . . . . . . . .
       7  InvoiceDate . . . . . . . . .     8 SNN  Invoice Date. . . . . . . . . .DATE
       8  InvoiceType . . . . . . . . .     2 SNN  Invoice Type. . . . . . . . . .
       9  SalesOrderNo. . . . . . . . .     7 SNN  Sales Order Number. . . . . . .
      10  ARDivisionNo. . . . . . . . .     2 SNN  AR Division Number. . . . . . .ARDIVISION
                                                    Mask:00
      11  ARDivisionDesc. . . . . . . .    30 SNN  AR Division Description . . . .
      12  CustomerNo. . . . . . . . . .    20 SNN  Customer Number . . . . . . . .CUSTOMERNO
      13  CustomerName. . . . . . . . .    30 SNN  Customer Name . . . . . . . . .
      14  JobNo . . . . . . . . . . . .     7 SNN  Job Number. . . . . . . . . . .
      15  SalespersonDivisionNo . . . .     2 SNN  Salesperson Division Number . .ARDIVISION
                                                    Mask:00 FmtType:ZEROFILL
      16  SalespersonNo . . . . . . . .     4 SNN  Salesperson Number. . . . . . .SALESPERSONNO
      17  SalespersonName . . . . . . .    30 SNN  Salesperson Name. . . . . . . .NAME
                                                    Notes: {ARD$(7,30)}
      18  SalespersonDivisionNo2. . . .     2 SNN  Salesperson Division Number 2 .ARDIVISION
                                                    Mask:00 FmtType:ZEROFILL
      19  SalespersonNo2. . . . . . . .     4 SNN  Salesperson Number 2. . . . . .SALESPERSONNO
      20  SalespersonNo2Name. . . . . .    30 SNN  Salesperson Number 2 Name . . .NAME
      21  SalespersonDivisionNo3. . . .     2 SNN  Salesperson Division Number 3 .ARDIVISION
                                                    Mask:00 FmtType:ZEROFILL
      22  SalespersonNo3. . . . . . . .     4 SYN  Salesperson Number 3. . . . . .SALESPERSONNO
                                                    FmtType:ALPHANUM
      23  SalespersonNo3Name. . . . . .    30 SNN  Salesperson Number 3  Name. . .NAME
      24  SalespersonDivisionNo4. . . .     2 SNN  Salesperson Division Number 4 .ARDIVISION
                                                    Mask:00 FmtType:ZEROFILL
      25  SalespersonNo4. . . . . . . .     4 SYN  Salesperson Number 4. . . . . .SALESPERSONNO
                                                    FmtType:ALPHANUM
      26  SalespersonNo4Name. . . . . .    30 SNN  Salesperson Number 4 Name . . .NAME
      27  SalespersonDivisionNo5. . . .     2 SNN  Salesperson Division Number 5 .ARDIVISION
                                                    Mask:00 FmtType:ZEROFILL
      28  SalespersonNo5. . . . . . . .     4 SYN  Salesperson Number 5. . . . . .SALESPERSONNO
                                                    FmtType:ALPHANUM
      29  SalespersonNo5Name. . . . . .    30 SNN  Salesperson Number 5 Name . . .NAME
      30  SplitCommissions. . . . . . .     1 SYN  Split Commissions . . . . . . .
                                                    Valid:Y,N,O Notes: Y=Yes,
                                                    N=No, O=Override
      31  SplitCommRate2. . . . . . . .  9.3  NNN  Split Commission Rate 2 . . . .
                                                    Mask:###0.000
      32  SplitCommRate3. . . . . . . .  9.3  NNN  Split Commission Rate 3 . . . .
                                                    Mask:###0.000
      33  SplitCommRate4. . . . . . . .  9.3  NNN  Split Commission Rate 4 . . . .
                                                    Mask:###0.000
      34  SplitCommRate5. . . . . . . .  9.3  NNN  Split Commission Rate 5 . . . .
                                                    Mask:###0.000
      35  PriceOverridden . . . . . . .     1 SYN  Price Overridden. . . . . . . .YESNO
                                                    DfltVal:N Valid:Y,N
      36  CostOverridden. . . . . . . .     1 SYN  Cost Overridden . . . . . . . .YESNO
                                                    DfltVal:N Valid:Y,N
      37  SalesAccount. . . . . . . . .    41 SNN  Sales Account . . . . . . . . .
      38  CostOfGoodsSoldAccount. . . .    41 SNN  Cost Of Goods Sold Account. . .
      39  CostCode. . . . . . . . . . .     9 SNN  Cost Code . . . . . . . . . . .COSTCODE
      40  CostCodeFormatted . . . . . .    11 SNN  Cost Code Formatted . . . . . .
      41  CostType. . . . . . . . . . .     1 SNN  Cost Type . . . . . . . . . . .COSTTYPE
      42  CostTypeDesc. . . . . . . . .    15 SNN  Cost Type Description . . . . .
      43  ItemCode. . . . . . . . . . .    30 SNN  Item Code . . . . . . . . . . .ITEMCODE
      44  Commissionable. . . . . . . .     1 SNN  Commissionable. . . . . . . . .
      45  ExplodedKitItem . . . . . . .     1 SYN  Exploded Kit Item . . . . . . .YESNO
                                                    DfltVal:N Valid:Y,N
      46  TaxableAmt. . . . . . . . . . 13.2  NNN  Taxable Amount. . . . . . . . .
      47  DiscountAmt . . . . . . . . . 13.2  NNN  Discount Amount . . . . . . . .AMOUNT
                                                    Mask:###,###,###.00
      48  NonTaxableAmt . . . . . . . . 13.2  NNN  Non-Taxable Amount. . . . . . .
      49  CostOfGoodsSoldAmt. . . . . . 13.2  NNN  Cost Of Goods Sold Amount . . .AMOUNT
                                                    Mask:###,###,###.00
      50  LineSubjectToComm . . . . . . 13.2  NNN  Line Subject To Commission. . .AMOUNT
                                                    Mask:###,###,###.00
      51  CommissionAmt . . . . . . . . 13.2  NNN  Commission Amount . . . . . . .AMOUNT
                                                    Mask:###,###,###.00
      52  CommissionRate. . . . . . . .  9.3  NNN  Commission Rate . . . . . . . .
      53  FreightAmt. . . . . . . . . . 12.2  NNN  Freight Amount. . . . . . . . .
      54  SalesTaxAmt . . . . . . . . . 12.2  NNN  Sales Tax Amount. . . . . . . .
      55  ExtensionAmt. . . . . . . . . 13.2  NNN  Extension Amount. . . . . . . .