AR_OpenInvoiceSplitCommissions AR Open Invoice Split CommissionRel: 4.40 Bld: 398 8/28/2009
Bus Obj: SO_SalesJournal_upd,AR_CommissionEditRegister_upd
SQL Def: N SysDB: N "MAS_"+%C$+"/AR"+%C$+"/AR_OpenInvoiceSplitCommissions.M4T"
KPRIMARY: ARDivisionNo+CustomerNo+InvoiceNo+InvoiceType+SequenceNo
Fld Column Name M/L TUR Description/Notes Class
1 ARDivisionNo. . . . . . . . . 2 SNY AR Division Number. . . . . . .ARDIVISION
Mask:00 FmtType:ZEROFILL
Notes: {ARI$(1,2)}
2 CustomerNo. . . . . . . . . . 20 SYY Customer Number . . . . . . . .CUSTOMERNO
FmtType:MASTERNUMC ChngTag:Re
place1/ARDivisionNo$ Notes:
{ARI$(3,7)}
3 InvoiceNo . . . . . . . . . . 7 SYY Invoice Number. . . . . . . . .INVOICE
FmtType:MASTERNUM Notes:
{ARI$(10,7)}
4 InvoiceType . . . . . . . . . 2 SYY Invoice Type. . . . . . . . . .
Valid:CM,DM,IN,AD,FC,CA,XD
Notes: CM=Credit Memo,
DM=Debit Memo, IN=Invoice,
AD=Adjustment., FC=Finance
Charge, CA=Cash, XD=Deleted
{ARI$(17,2)}
5 SequenceNo. . . . . . . . . . 6 SNY Sequence Number . . . . . . . .
Mask:000000 FmtType:ZEROFILL
ChngTag:KeySeq Notes:
{ARI$(19,2)}
6 SalespersonDivisionNo . . . . 2 SNN Salesperson Division Number . .ARDIVISION
Mask:00 FmtType:ZEROFILL
Notes: {ARI$(21,2)}
7 SalespersonNo . . . . . . . . 4 SYN Salesperson Number. . . . . . .SALESPERSONNO
FmtType:CHARNUM Notes:
{ARI$(23,4)}
8 SalespersonDivisionNo2. . . . 2 SNN Salesperson Division Number 2 .ARDIVISION
Mask:00 FmtType:ZEROFILL
Notes: {ARI$(34,2)}
9 SalespersonNo2. . . . . . . . 4 SYN Salesperson Number 2. . . . . .SALESPERSONNO
FmtType:CHARNUM Notes:
{ARI$(36,4)}
10 SalespersonDivisionNo3. . . . 2 SNN Salesperson Division Number 3 .ARDIVISION
Mask:00 FmtType:ZEROFILL
Notes: {ARI$(47,2)}
11 SalespersonNo3. . . . . . . . 4 SYN Salesperson Number 3. . . . . .SALESPERSONNO
FmtType:CHARNUM Notes:
{ARI$(49,4)}
12 SalespersonDivisionNo4. . . . 2 SNN Salesperson Division Number 4 .ARDIVISION
Mask:00 FmtType:ZEROFILL
Notes: {ARI$(60,2)}
13 SalespersonNo4. . . . . . . . 4 SYN Salesperson Number 4. . . . . .SALESPERSONNO
FmtType:CHARNUM Notes:
{ARI$(62,4)}
14 SalespersonDivisionNo5. . . . 2 SNN Salesperson Division Number 5 .ARDIVISION
Mask:00 FmtType:ZEROFILL
Notes: {ARI$(73,2)}
15 SalespersonNo5. . . . . . . . 4 SYN Salesperson Number 5. . . . . .SALESPERSONNO
FmtType:CHARNUM Notes:
{ARI$(75,4)}
16 SplitCommRate2. . . . . . . . 9.3 NNN Split Commission Rate 2 . . . .COMMISSIONRATE
Mask:###0.000 Notes:
{ARI$(40,7)}
17 SplitCommRate3. . . . . . . . 9.3 NNN Split Commission Rate 3 . . . .COMMISSIONRATE
Mask:###0.000 Notes:
{ARI$(53,7)}
18 SplitCommRate4. . . . . . . . 9.3 NNN Split Commission Rate 4 . . . .COMMISSIONRATE
Mask:###0.000 Notes:
{ARI$(66,7)}
19 SplitCommRate5. . . . . . . . 9.3 NNN Split Commission Rate 5 . . . .COMMISSIONRATE
Mask:###0.000 Notes:
{ARI$(79,7)}
20 OverrideCommAmt . . . . . . . 10.2 NNN Override Commission Amount. . .
Mask:######.00- Notes:
{ARI$(86,10)}
21 DateCreated . . . . . . . . . 8 SNY Creation Date . . . . . . . . .DATE
Read Only:Y
22 TimeCreated . . . . . . . . . 8 SNY Creation Time . . . . . . . . .
Read Only:Y
23 UserCreatedKey. . . . . . . . 10 SNY Creation User ID. . . . . . . .USER
Read Only:Y Mask:0000000000
FmtType:ZEROFILL
24 DateUpdated . . . . . . . . . 8 SNN Last Update Date. . . . . . . .DATE
Read Only:Y
25 TimeUpdated . . . . . . . . . 8 SNN Last Update Time. . . . . . . .
Read Only:Y
26 UserUpdatedKey. . . . . . . . 10 SNN Last Update User ID . . . . . .USER
Read Only:Y Mask:0000000000
FmtType:ZEROFILL