View: Miscellaneous Payments

RotoID: AP0032
Table: APTCN
Protocol: Detail, Sequenced revisions, Key auto generate
DLL:APTCN

Compositions: 1

RotoID Tables Title DLL
AP0031 APTCR Payments/Adjustments APTCR

Keys: 1

Title Fields
Miscellaneous Payment Primary Ke BATCHTYPE, CNTBTCH, CNTRMIT, CNTLINE

Fields: 121

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

This page was generated on 2022-Aug-18

© 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).