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