AR_SalespersonCommissionWrk AR Salesperson Commission Work Rel: 4.40 Bld: 398 8/28/2009 Bus Obj: AR_SalespersonCommission_rpt SQL Def: Y SysDB: N "MAS_"+%C$+"/AR"+%C$+"/AR_SalespersonCommissionWrk"+%S$+".M4T"
KPRIMARY: SortField
Fld Column Name M/L TUR Description/Notes Class
1 SortField . . . . . . . . . . 127 SNN SortField . . . . . . . . . . . 2 GroupField. . . . . . . . . . 30 SNN Group Field . . . . . . . . . . 3 SalespersonDivisionNo . . . . 2 SNN Salesperson Division Number . . 4 SalespersonNo . . . . . . . . 4 SNN Salesperson Number. . . . . . . 5 SalespersonName . . . . . . . 30 SNN Salesperson Name. . . . . . . . 6 ARDivisionNo. . . . . . . . . 2 SNN AR Division Number. . . . . . . 7 ARDivisionDesc. . . . . . . . 30 SNN AR Division Description . . . . 8 CustomerNo. . . . . . . . . . 20 SNN Customer Number . . . . . . . . 9 CustomerName. . . . . . . . . 30 SNN Customer Name . . . . . . . . . 10 InvoiceNo . . . . . . . . . . 7 SNN Invoice Number. . . . . . . . . 11 InvoiceType . . . . . . . . . 2 SNN Invoice Type. . . . . . . . . . 12 InvoiceDate . . . . . . . . . 8 SNN Invoice Date. . . . . . . . . .DATE 13 PayDate . . . . . . . . . . . 8 SNN Pay Date. . . . . . . . . . . .DATE 14 ApplyToNo . . . . . . . . . . 7 SNN Apply To Credit Memo/Debit Memo 15 CommissionRate. . . . . . . . 9.3 NNN Commission Rate . . . . . . . . 16 InvoiceTotal. . . . . . . . . 14.2 NNN Invoice Total . . . . . . . . . 17 SalesSubjectToComm. . . . . . 14.2 NNN Sales Subject To Commission . . 18 CostSubjectToComm . . . . . . 14.2 NNN Cost Subject To Commission. . . 19 CommissionAmt . . . . . . . . 13.2 NNN Commission Amount . . . . . . . 20 InvoiceAmountPaid . . . . . . 14.2 NNN Invoice Amount Paid . . . . . . 21 SplitCommPercent. . . . . . . 7.2 NNN Split Commission Percent. . . . 22 CommissionPayable . . . . . . 14.2 NNN Commission Payable. . . . . . . 23 Balance . . . . . . . . . . . 14.2 NNN Balance . . . . . . . . . . . .