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