     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