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