Table: Miscellaneous Payments

Table: APTCN
View: AP0032
Record Length: 1259

Flags: A R 

Keys: 1

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

Fields: 125

Field Type Title Presentation
BATCHTYPE String*2 Batch Type Mask: %-2N
CNTBTCH BCD*5.0 Batch Number
CNTRMIT BCD*4.0 Entry Number
CNTLINE BCD*3.0 Line Number
AUDTDATE Date
AUDTTIME Time
AUDTUSER String*8
AUDTORG String*6
IDDISTCODE String*6 Distribution Code Mask: %-6N
IDACCT String*45 Account Number Mask: %-45C
GLREF String*60 G/L Reference
GLDESC String*60 G/L Description
TAXCLASS1 Integer Tax Class 1
TAXCLASS2 Integer Tax Class 2
TAXCLASS3 Integer Tax Class 3
TAXCLASS4 Integer Tax Class 4
TAXCLASS5 Integer Tax Class 5
SWTAXINCL1 Integer Tax Included 1 List:2 entries
0 = No
1 = Yes
SWTAXINCL2 Integer Tax Included 2 List:2 entries
0 = No
1 = Yes
SWTAXINCL3 Integer Tax Included 3 List:2 entries
0 = No
1 = Yes
SWTAXINCL4 Integer Tax Included 4 List:2 entries
0 = No
1 = Yes
SWTAXINCL5 Integer Tax Included 5 List:2 entries
0 = No
1 = Yes
TXBSE1TC BCD*10.3 Tax Base 1
TXBSE2TC BCD*10.3 Tax Base 2
TXBSE3TC BCD*10.3 Tax Base 3
TXBSE4TC BCD*10.3 Tax Base 4
TXBSE5TC BCD*10.3 Tax Base 5
RATETAX1 BCD*8.5 Tax Rate 1
RATETAX2 BCD*8.5 Tax Rate 2
RATETAX3 BCD*8.5 Tax Rate 3
RATETAX4 BCD*8.5 Tax Rate 4
RATETAX5 BCD*8.5 Tax Rate 5
TXAMT1TC BCD*10.3 Tax Amount 1
TXAMT2TC BCD*10.3 Tax Amount 2
TXAMT3TC BCD*10.3 Tax Amount 3
TXAMT4TC BCD*10.3 Tax Amount 4
TXAMT5TC BCD*10.3 Tax Amount 5
TXTOTTC BCD*10.3 Tax Total
AMTDISTTC BCD*10.3 Dist. Amount
AMTNETTC BCD*10.3 Dist. Amount Net of Taxes
AMTDISTHC BCD*10.3 Func. Dist. Amount
AMTNETHC BCD*10.3 Func. Dist. Amount Net of Taxes
TXALLTC BCD*10.3 Tax Allocated Total
TXALL1TC BCD*10.3 Tax Allocated Amount 1
TXALL2TC BCD*10.3 Tax Allocated Amount 2
TXALL3TC BCD*10.3 Tax Allocated Amount 3
TXALL4TC BCD*10.3 Tax Allocated Amount 4
TXALL5TC BCD*10.3 Tax Allocated Amount 5
TXREC1TC BCD*10.3 Tax Recoverable 1
TXREC2TC BCD*10.3 Tax Recoverable 2
TXREC3TC BCD*10.3 Tax Recoverable 3
TXREC4TC BCD*10.3 Tax Recoverable 4
TXREC5TC BCD*10.3 Tax Recoverable 5
TXEXP1TC BCD*10.3 Tax Expensed 1
TXEXP2TC BCD*10.3 Tax Expensed 2
TXEXP3TC BCD*10.3 Tax Expensed 3
TXEXP4TC BCD*10.3 Tax Expensed 4
TXEXP5TC BCD*10.3 Tax Expensed 5
TXAMT1RC BCD*10.3 Tax Reporting Amount 1
TXAMT2RC BCD*10.3 Tax Reporting Amount 2
TXAMT3RC BCD*10.3 Tax Reporting Amount 3
TXAMT4RC BCD*10.3 Tax Reporting Amount 4
TXAMT5RC BCD*10.3 Tax Reporting Amount 5
TXTOTRC BCD*10.3 Tax Reporting Total
TXALLRC BCD*10.3 Tax Reporting Allocated Amount
TXREC1RC BCD*10.3 Tax Reporting Recoverable Amt 1
TXREC2RC BCD*10.3 Tax Reporting Recoverable Amt 2
TXREC3RC BCD*10.3 Tax Reporting Recoverable Amt 3
TXREC4RC BCD*10.3 Tax Reporting Recoverable Amt 4
TXREC5RC BCD*10.3 Tax Reporting Recoverable Amt 5
TXEXP1RC BCD*10.3 Tax Reporting Expensed Amount 1
TXEXP2RC BCD*10.3 Tax Reporting Expensed Amount 2
TXEXP3RC BCD*10.3 Tax Reporting Expensed Amount 3
TXEXP4RC BCD*10.3 Tax Reporting Expensed Amount 4
TXEXP5RC BCD*10.3 Tax Reporting Expensed Amount 5
TXBSE1HC BCD*10.3 Func. Tax Base 1
TXBSE2HC BCD*10.3 Func. Tax Base 2
TXBSE3HC BCD*10.3 Func. Tax Base 3
TXBSE4HC BCD*10.3 Func. Tax Base 4
TXBSE5HC BCD*10.3 Func. Tax Base 5
TXAMT1HC BCD*10.3 Func. Tax Amount 1
TXAMT2HC BCD*10.3 Func. Tax Amount 2
TXAMT3HC BCD*10.3 Func. Tax Amount 3
TXAMT4HC BCD*10.3 Func. Tax Amount 4
TXAMT5HC BCD*10.3 Func. Tax Amount 5
TXALLHC BCD*10.3 Func. Tax Allocated Total
TXALL1HC BCD*10.3 Func. Tax Allocated Amount 1
TXALL2HC BCD*10.3 Func. Tax Allocated Amount 2
TXALL3HC BCD*10.3 Func. Tax Allocated Amount 3
TXALL4HC BCD*10.3 Func. Tax Allocated Amount 4
TXALL5HC BCD*10.3 Func. Tax Allocated Amount 5
TXREC1HC BCD*10.3 Func. Tax Recoverable 1
TXREC2HC BCD*10.3 Func. Tax Recoverable 2
TXREC3HC BCD*10.3 Func. Tax Recoverable 3
TXREC4HC BCD*10.3 Func. Tax Recoverable 4
TXREC5HC BCD*10.3 Func. Tax Recoverable 5
TXEXP1HC BCD*10.3 Func. Tax Expensed 1
TXEXP2HC BCD*10.3 Func. Tax Expensed 2
TXEXP3HC BCD*10.3 Func. Tax Expensed 3
TXEXP4HC BCD*10.3 Func. Tax Expensed 4
TXEXP5HC BCD*10.3 Func. Tax Expensed 5
TXTOTHC BCD*10.3 Func. Tax Total
CONTRACT String*16 Contract Code Mask: %-16C
PROJECT String*16 Project Code Mask: %-16N
CATEGORY String*16 Category Code Mask: %-16N
RESOURCE String*24 Project/Category Resource Mask: %-16N
COSTCLASS Integer Cost Class List:7 entries
0 =
1 = Labor
2 = Material
3 = Equipment
4 = Subcontractor
5 = Overhead
6 = Miscellaneous
BILLTYPE Integer Billing Type List:1 entries
0 =
IDITEM String*16 Item Number Mask: %-16C
UNITMEAS String*10 Unit of Measure Mask: %-10C
QTYINVC BCD*10.5 Quantity
AMTCOST BCD*10.6 Cost
BILLDATE Date Billing Date
BILLRATE BCD*10.6 Billing Rate
BILLCURN String*3 Billing Currency Mask: %-3N
AMTWHT1TC BCD*10.3 Estimated Tax Withheld Amount 1
AMTWHT2TC BCD*10.3 Estimated Tax Withheld Amount 2
AMTWHT3TC BCD*10.3 Estimated Tax Withheld Amount 3
AMTWHT4TC BCD*10.3 Estimated Tax Withheld Amount 4
AMTWHT5TC BCD*10.3 Estimated Tax Withheld Amount 5
AMTCXTX1TC BCD*10.3 Reverse Charge Amount 1
AMTCXTX2TC BCD*10.3 Reverse Charge Amount 2
AMTCXTX3TC BCD*10.3 Reverse Charge Amount 3
AMTCXTX4TC BCD*10.3 Reverse Charge Amount 4
AMTCXTX5TC BCD*10.3 Reverse Charge Amount 5

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