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. . . . . . . .