View: Payment G/L Distributions

RotoID: AP0037
Table: APTRK
Protocol: Flat
DLL:APTRK

Keys: 2

Title Fields
Bank / Batch / Entry IDBANK, CNTBTCH, CNTENTRY, CNTLINE, CNTSEQ
Vendor / Document IDVEND, IDINVC, CNTPAYM, IDRMIT, LONGSERIAL, TRXTYPE, CNTSEQOBP

Fields: 141

Field Index Type Title Attributes Presentation
IDBANK 1 String*8 Bank Code E A K R  Mask: %-8N
CNTBTCH 2 BCD*5.0 Batch Number E A K R 
CNTENTRY 3 BCD*4.0 Entry Number E A K R 
CNTLINE 4 BCD*3.0 Line Number E A K R 
CNTSEQ 5 BCD*3.0 Sequence No. E A K R 
IDVEND 6 String*12 Vendor Number E A  Mask: %-12C
IDINVC 7 String*22 Document Number E A  Mask: %-22C
CNTPAYM 8 BCD*3.0 Payment Number E A 
IDRMIT 9 String*18 Check Number E A  Mask: %-18D
TRXTYPE 10 Integer Document Type E A 
CNTSEQOBP 11 BCD*3.0 Applied Payment Sequence No. E A 
DATEBTCH 12 Date Batch Date E A 
AMTDISTTC 13 BCD*10.3 Vend. Distributed Amount E A 
AMTDISTHC 14 BCD*10.3 Func. Distributed Amount E A 
IDDISTCODE 15 String*6 Distribution Code E A  Mask: %-6N
IDACCT 16 String*45 G/L Account E A  Mask: %-45C
TEXTGLREF 17 String*60 G/L Reference E A 
TEXTGLDESC 18 String*60 G/L Description E A 
CNTADJREF 19 BCD*5.0 Adjustment Number E A 
LONGSERIAL 20 ??? Check Serial Number E A 
TAXCLASS1 21 Integer Tax Class 1 E A 
TAXCLASS2 22 Integer Tax Class 2 E A 
TAXCLASS3 23 Integer Tax Class 3 E A 
TAXCLASS4 24 Integer Tax Class 4 E A 
TAXCLASS5 25 Integer Tax Class 5 E A 
SWTAXINCL1 26 Integer Tax Included 1 E A  List:2 entries
0 = No
1 = Yes
SWTAXINCL2 27 Integer Tax Included 2 E A  List:2 entries
0 = No
1 = Yes
SWTAXINCL3 28 Integer Tax Included 3 E A  List:2 entries
0 = No
1 = Yes
SWTAXINCL4 29 Integer Tax Included 4 E A  List:2 entries
0 = No
1 = Yes
SWTAXINCL5 30 Integer Tax Included 5 E A  List:2 entries
0 = No
1 = Yes
TXBSE1TC 31 BCD*10.3 Tax Base 1 E A 
TXBSE2TC 32 BCD*10.3 Tax Base 2 E A 
TXBSE3TC 33 BCD*10.3 Tax Base 3 E A 
TXBSE4TC 34 BCD*10.3 Tax Base 4 E A 
TXBSE5TC 35 BCD*10.3 Tax Base 5 E A 
RATETAX1 36 BCD*8.5 Tax Rate 1 E A 
RATETAX2 37 BCD*8.5 Tax Rate 2 E A 
RATETAX3 38 BCD*8.5 Tax Rate 3 E A 
RATETAX4 39 BCD*8.5 Tax Rate 4 E A 
RATETAX5 40 BCD*8.5 Tax Rate 5 E A 
TXAMT1TC 41 BCD*10.3 Tax Amount 1 E A 
TXAMT2TC 42 BCD*10.3 Tax Amount 2 E A 
TXAMT3TC 43 BCD*10.3 Tax Amount 3 E A 
TXAMT4TC 44 BCD*10.3 Tax Amount 4 E A 
TXAMT5TC 45 BCD*10.3 Tax Amount 5 E A 
TXTOTTC 46 BCD*10.3 Tax Total E A 
AMTNETTC 47 BCD*10.3 Dist. Amount Net of Taxes E A 
AMTNETHC 48 BCD*10.3 Func. Dist. Amount Net of Taxes E A 
TXALLTC 49 BCD*10.3 Tax Allocated Total E A 
TXALL1TC 50 BCD*10.3 Tax Allocated Amount 1 E A 
TXALL2TC 51 BCD*10.3 Tax Allocated Amount 2 E A 
TXALL3TC 52 BCD*10.3 Tax Allocated Amount 3 E A 
TXALL4TC 53 BCD*10.3 Tax Allocated Amount 4 E A 
TXALL5TC 54 BCD*10.3 Tax Allocated Amount 5 E A 
TXREC1TC 55 BCD*10.3 Tax Recoverable 1 E A 
TXREC2TC 56 BCD*10.3 Tax Recoverable 2 E A 
TXREC3TC 57 BCD*10.3 Tax Recoverable 3 E A 
TXREC4TC 58 BCD*10.3 Tax Recoverable 4 E A 
TXREC5TC 59 BCD*10.3 Tax Recoverable 5 E A 
TXEXP1TC 60 BCD*10.3 Tax Expensed 1 E A 
TXEXP2TC 61 BCD*10.3 Tax Expensed 2 E A 
TXEXP3TC 62 BCD*10.3 Tax Expensed 3 E A 
TXEXP4TC 63 BCD*10.3 Tax Expensed 4 E A 
TXEXP5TC 64 BCD*10.3 Tax Expensed 5 E A 
TXAMT1RC 65 BCD*10.3 Tax Reporting Amount 1 E A 
TXAMT2RC 66 BCD*10.3 Tax Reporting Amount 2 E A 
TXAMT3RC 67 BCD*10.3 Tax Reporting Amount 3 E A 
TXAMT4RC 68 BCD*10.3 Tax Reporting Amount 4 E A 
TXAMT5RC 69 BCD*10.3 Tax Reporting Amount 5 E A 
TXTOTRC 70 BCD*10.3 Tax Reporting Total E A 
TXALLRC 71 BCD*10.3 Tax Reporting Allocated Amount E A 
TXREC1RC 72 BCD*10.3 Tax Reporting Recoverable Amt 1 E A 
TXREC2RC 73 BCD*10.3 Tax Reporting Recoverable Amt 2 E A 
TXREC3RC 74 BCD*10.3 Tax Reporting Recoverable Amt 3 E A 
TXREC4RC 75 BCD*10.3 Tax Reporting Recoverable Amt 4 E A 
TXREC5RC 76 BCD*10.3 Tax Reporting Recoverable Amt 5 E A 
TXEXP1RC 77 BCD*10.3 Tax Reporting Expensed Amount 1 E A 
TXEXP2RC 78 BCD*10.3 Tax Reporting Expensed Amount 2 E A 
TXEXP3RC 79 BCD*10.3 Tax Reporting Expensed Amount 3 E A 
TXEXP4RC 80 BCD*10.3 Tax Reporting Expensed Amount 4 E A 
TXEXP5RC 81 BCD*10.3 Tax Reporting Expensed Amount 5 E A 
TXBSE1HC 82 BCD*10.3 Func. Tax Base 1 E A 
TXBSE2HC 83 BCD*10.3 Func. Tax Base 2 E A 
TXBSE3HC 84 BCD*10.3 Func. Tax Base 3 E A 
TXBSE4HC 85 BCD*10.3 Func. Tax Base 4 E A 
TXBSE5HC 86 BCD*10.3 Func. Tax Base 5 E A 
TXAMT1HC 87 BCD*10.3 Func. Tax Amount 1 E A 
TXAMT2HC 88 BCD*10.3 Func. Tax Amount 2 E A 
TXAMT3HC 89 BCD*10.3 Func. Tax Amount 3 E A 
TXAMT4HC 90 BCD*10.3 Func. Tax Amount 4 E A 
TXAMT5HC 91 BCD*10.3 Func. Tax Amount 5 E A 
TXALLHC 92 BCD*10.3 Func. Tax Allocated Total E A 
TXALL1HC 93 BCD*10.3 Func. Tax Allocated Amount 1 E A 
TXALL2HC 94 BCD*10.3 Func. Tax Allocated Amount 2 E A 
TXALL3HC 95 BCD*10.3 Func. Tax Allocated Amount 3 E A 
TXALL4HC 96 BCD*10.3 Func. Tax Allocated Amount 4 E A 
TXALL5HC 97 BCD*10.3 Func. Tax Allocated Amount 5 E A 
TXREC1HC 98 BCD*10.3 Func. Tax Recoverable 1 E A 
TXREC2HC 99 BCD*10.3 Func. Tax Recoverable 2 E A 
TXREC3HC 100 BCD*10.3 Func. Tax Recoverable 3 E A 
TXREC4HC 101 BCD*10.3 Func. Tax Recoverable 4 E A 
TXREC5HC 102 BCD*10.3 Func. Tax Recoverable 5 E A 
TXEXP1HC 103 BCD*10.3 Func. Tax Expensed 1 E A 
TXEXP2HC 104 BCD*10.3 Func. Tax Expensed 2 E A 
TXEXP3HC 105 BCD*10.3 Func. Tax Expensed 3 E A 
TXEXP4HC 106 BCD*10.3 Func. Tax Expensed 4 E A 
TXEXP5HC 107 BCD*10.3 Func. Tax Expensed 5 E A 
TXTOTHC 108 BCD*10.3 Func. Tax Total E A 
CONTRACT 109 String*16 Contract Code E A  Mask: %-16C
PROJECT 110 String*16 Project Code E A  Mask: %-16N
CATEGORY 111 String*16 Category Code E A  Mask: %-16N
RESOURCE 112 String*24 Project/Category Resource E A P  Mask: %-16N
COSTCLASS 113 Integer Cost Class E A  List:7 entries
0 =
1 = Labor
2 = Material
3 = Equipment
4 = Subcontractor
5 = Overhead
6 = Miscellaneous
BILLTYPE 114 Integer Billing Type E A  List:4 entries
0 =
1 = Non-billable
2 = Billable
3 = No Charge
IDITEM 115 String*16 Item Number E A  Mask: %-16C
UNITMEAS 116 String*10 Unit of Measure E A  Mask: %-10C
QTYINVC 117 BCD*10.5 Quantity E A 
AMTCOST 118 BCD*10.6 Cost E A 
BILLDATE 119 Date Billing Date E A 
BILLRATE 120 BCD*10.6 Billing Rate E A 
BILLCURN 121 String*3 Billing Currency E A  Mask: %-3N
AMTWHT1TC 122 BCD*10.3 Tax Withheld 1 E A 
AMTWHT2TC 123 BCD*10.3 Tax Withheld 2 E A 
AMTWHT3TC 124 BCD*10.3 Tax Withheld 3 E A 
AMTWHT4TC 125 BCD*10.3 Tax Withheld 4 E A 
AMTWHT5TC 126 BCD*10.3 Tax Withheld 5 E A 
AMTCXTX1TC 127 BCD*10.3 Reverse Charge Amount 1 E A 
AMTCXTX2TC 128 BCD*10.3 Reverse Charge Amount 2 E A 
AMTCXTX3TC 129 BCD*10.3 Reverse Charge Amount 3 E A 
AMTCXTX4TC 130 BCD*10.3 Reverse Charge Amount 4 E A 
AMTCXTX5TC 131 BCD*10.3 Reverse Charge Amount 5 E A 
AMTWHT1HC 132 BCD*10.3 Func. Tax Withheld 1 E A 
AMTWHT2HC 133 BCD*10.3 Func. Tax Withheld 2 E A 
AMTWHT3HC 134 BCD*10.3 Func. Tax Withheld 3 E A 
AMTWHT4HC 135 BCD*10.3 Func. Tax Withheld 4 E A 
AMTWHT5HC 136 BCD*10.3 Func. Tax Withheld 5 E A 
AMTWHT1RC 137 BCD*10.3 Tax Reporting Tax Withheld 1 E A 
AMTWHT2RC 138 BCD*10.3 Tax Reporting Tax Withheld 2 E A 
AMTWHT3RC 139 BCD*10.3 Tax Reporting Tax Withheld 3 E A 
AMTWHT4RC 140 BCD*10.3 Tax Reporting Tax Withheld 4 E A 
AMTWHT5RC 141 BCD*10.3 Tax Reporting Tax Withheld 5 E A 

This page was generated on 2021-Nov-24

© 2021 Sage Software, Inc. All rights reserved. Reproduction of part or all of the contents in any form is prohibited unless for personal use. None of the content of this article may be copied or otherwise incorporated into any other document, publication or other work in any form (whether written, electronic or other format).

Sage Software, Inc. makes no warranties, representations or undertakings about any of the content of articles (including, without limitation, any as to the quality, accuracy, completeness or fitness for any particular purpose of such content).