     AR_CommissionRegisterWrk              AR Commission Register Work     Rel: 4.40  Bld: 398  8/28/2009
     Bus Obj: AR_CommissionEditRegister_upd
     SQL Def: Y  SysDB: N                       "MAS_"+%C$+"/AR"+%C$+"/AR_CommissionRegisterWrk"+%S$+".M4T"

     KPRIMARY: SortField

     Fld  Column Name                     M/L TUR  Description/Notes              Class

       1  SortField . . . . . . . . . .   127 SNN  SortField . . . . . . . . . . .
       2  SalespersonDivisionNo . . . .     2 SNN  Salesperson Division Number . .
       3  SalespersonNo . . . . . . . .     4 SNN  Salesperson Number. . . . . . .
       4  ARDivisionDesc. . . . . . . .    30 SNN  AR Division Description . . . .
       5  SalespersonName . . . . . . .    30 SNN  Salesperson Name. . . . . . . .
       6  LinkToCode. . . . . . . . . .     1 SNN  Link To Code. . . . . . . . . .
       7  APDivisionNo. . . . . . . . .     2 SNN  AP Division Number. . . . . . .
       8  VendorNo. . . . . . . . . . .     7 SNN  Vendor Number . . . . . . . . .
       9  PRDepartmentNo. . . . . . . .     2 SNN  PR Department Number. . . . . .
      10  EmployeeNo. . . . . . . . . .     7 SNN  Employee Number . . . . . . . .
      11  AccrualAcctKey. . . . . . . .     9 SNN  Accrual Account Key . . . . . .
      12  AccrualAccount. . . . . . . .    41 SNN  Accrual Account . . . . . . . .
      13  LinkUpdated . . . . . . . . .     1 SNN  Link Updated. . . . . . . . . .YESNO
                                                    DfltVal:N Valid:Y,N
      14  ARDivisionNo. . . . . . . . .     2 SNN  AR Division Number. . . . . . .
      15  CustomerNo. . . . . . . . . .    20 SNN  Customer Number . . . . . . . .
      16  CustomerName. . . . . . . . .    30 SNN  Customer Name . . . . . . . . .
      17  InvoiceNo . . . . . . . . . .     7 SNN  Invoice Number. . . . . . . . .
      18  InvoiceType . . . . . . . . .     2 SNN  Invoice Type. . . . . . . . . .
      19  InvoiceDate . . . . . . . . .     8 SNN  Invoice Date. . . . . . . . . .DATE
      20  PayDate . . . . . . . . . . .     8 SNN  Pay Date. . . . . . . . . . . .DATE
      21  ApplyToNo . . . . . . . . . .     7 SNN  Apply To CreditMemo/Debit Memo
      22  HasCommRecordBeenEdited . . .     1 SNN  Has Commission Record Been Edit
      23  InvoiceTotal. . . . . . . . . 14.2  NNN  Invoice Total . . . . . . . . .
      24  SplitCommPercent. . . . . . .  7.2  NNN  Split Commission Percentage . .
      25  CommissionRate. . . . . . . .  9.3  NNN  Commission Rate . . . . . . . .
      26  SalesSubjectToComm. . . . . . 14.2  NNN  Sales Subject To Commission . .
      27  CostSubjectToComm . . . . . . 14.2  NNN  Cost Subject to Commission. . .
      28  CommissionAmt . . . . . . . . 14.2  NNN  Commission Amount . . . . . . .
      29  InvoiceAmountPaid . . . . . . 14.2  NNN  Invoice Amount Paid . . . . . .
      30  CommissionPayable . . . . . . 14.2  NNN  Commission Payable. . . . . . .
      31  Balance . . . . . . . . . . . 14.2  NNN  Balance . . . . . . . . . . . .