Table: Invoice Details

Table: APIBD
View: AP0022
Record Length: 1553

Flags: A R 

Keys: 1

Title Flags Fields
Batch Number / Entry Number CNTBTCH, CNTITEM, CNTLINE

Fields: 170

Field Type Title Presentation
CNTBTCH BCD*5.0 Batch Number
CNTITEM BCD*4.0 Entry Number
CNTLINE BCD*3.0 Line Number
AUDTDATE Date
AUDTTIME Time
AUDTUSER String*8
AUDTORG String*6
IDDIST String*6 Distribution Code Mask: %-6N
TEXTDESC String*60 Distribution Description
SWMANLDIST Integer Reserved
AMTTOTTAX BCD*10.3 Tax Total
SWMANLTX Integer Manual Tax Entry List:2 entries
0 = No
1 = Yes
BASETAX1 BCD*10.3 Base Tax 1
BASETAX2 BCD*10.3 Base Tax 2
BASETAX3 BCD*10.3 Base Tax 3
BASETAX4 BCD*10.3 Base Tax 4
BASETAX5 BCD*10.3 Base Tax 5
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 Inclusive 1 List:2 entries
0 = No
1 = Yes
SWTAXINCL2 Integer Tax Inclusive 2 List:2 entries
0 = No
1 = Yes
SWTAXINCL3 Integer Tax Inclusive 3 List:2 entries
0 = No
1 = Yes
SWTAXINCL4 Integer Tax Inclusive 4 List:2 entries
0 = No
1 = Yes
SWTAXINCL5 Integer Tax Inclusive 5 List:2 entries
0 = No
1 = Yes
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
AMTTAX1 BCD*10.3 Tax Amount 1
AMTTAX2 BCD*10.3 Tax Amount 2
AMTTAX3 BCD*10.3 Tax Amount 3
AMTTAX4 BCD*10.3 Tax Amount 4
AMTTAX5 BCD*10.3 Tax Amount 5
IDGLACCT String*45 G/L Account Mask: %-45C
IDACCTTAX String*45 Retainage Allocated Tax Account Mask: %-45C
ID1099CLAS String*6 Reserved
AMTDIST BCD*10.3 Distributed Amount
AMTDISTNET BCD*10.3 Distributed Amount Before Taxes
AMTINCLTAX BCD*10.3 Tax Amount Included in Price
AMTGLDIST BCD*10.3 G/L Distributed Amount
AMTTAXREC1 BCD*10.3 Recoverable Tax Amount 1
AMTTAXREC2 BCD*10.3 Recoverable Tax Amount 2
AMTTAXREC3 BCD*10.3 Recoverable Tax Amount 3
AMTTAXREC4 BCD*10.3 Recoverable Tax Amount 4
AMTTAXREC5 BCD*10.3 Recoverable Tax Amount 5
AMTTAXEXP1 BCD*10.3 Expense Sep. Tax Amount 1
AMTTAXEXP2 BCD*10.3 Expense Sep. Tax Amount 2
AMTTAXEXP3 BCD*10.3 Expense Sep. Tax Amount 3
AMTTAXEXP4 BCD*10.3 Expense Sep. Tax Amount 4
AMTTAXEXP5 BCD*10.3 Expense Sep. Tax Amount 5
AMTTAXTOBE BCD*10.3 Tax Allocated 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
TRANSNBR Long Transaction Number
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
SWIBT Integer Comment Attached List:2 entries
0 = No
1 = Yes
SWDISCABL Integer Discountable List:2 entries
0 = No
1 = Yes
OCNTLINE BCD*3.0 Original Line Identifier
RTGAMT BCD*10.3 Retainage Amount
RTGPERCENT BCD*5.5 Percent Retained
RTGDAYS Integer Days Retained
RTGDATEDUE Date Retainage Due Date
SWRTGDDTOV Integer Retainage Due Date Override List:2 entries
0 = No
1 = Yes
SWRTGAMTOV Integer Retainage Amount Override List:2 entries
0 = No
1 = Yes
VALUES Long Optional Fields
DESCOMP String*6 Destination Mask: %-6N
ROUTE Integer Route No.
RTGDISTTC BCD*10.3 Retainage Distribution Amount
RTGINVDIST BCD*10.3 Invoiced Retainage Distribution
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 Tax
TXEXP1RC BCD*10.3 Tax Reporting Expensed Tax 1
TXEXP2RC BCD*10.3 Tax Reporting Expensed Tax 2
TXEXP3RC BCD*10.3 Tax Reporting Expensed Tax 3
TXEXP4RC BCD*10.3 Tax Reporting Expensed Tax 4
TXEXP5RC BCD*10.3 Tax Reporting Expensed Tax 5
TXREC1RC BCD*10.3 Tax Reporting Recoverable Tax 1
TXREC2RC BCD*10.3 Tax Reporting Recoverable Tax 2
TXREC3RC BCD*10.3 Tax Reporting Recoverable Tax 3
TXREC4RC BCD*10.3 Tax Reporting Recoverable Tax 4
TXREC5RC BCD*10.3 Tax Reporting Recoverable Tax 5
TXBSERT1TC BCD*10.3 Retainage Tax Base 1
TXBSERT2TC BCD*10.3 Retainage Tax Base 2
TXBSERT3TC BCD*10.3 Retainage Tax Base 3
TXBSERT4TC BCD*10.3 Retainage Tax Base 4
TXBSERT5TC BCD*10.3 Retainage Tax Base 5
TXAMTRT1TC BCD*10.3 Retainage Tax Amount 1
TXAMTRT2TC BCD*10.3 Retainage Tax Amount 2
TXAMTRT3TC BCD*10.3 Retainage Tax Amount 3
TXAMTRT4TC BCD*10.3 Retainage Tax Amount 4
TXAMTRT5TC BCD*10.3 Retainage Tax 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
TXAMTRT1HC BCD*10.3 Func. Retainage Tax Amount 1
TXAMTRT2HC BCD*10.3 Func. Retainage Tax Amount 2
TXAMTRT3HC BCD*10.3 Func. Retainage Tax Amount 3
TXAMTRT4HC BCD*10.3 Func. Retainage Tax Amount 4
TXAMTRT5HC BCD*10.3 Func. Retainage Tax Amount 5
TXREC1HC BCD*10.3 Func. Tax Recoverable Amount 1
TXREC2HC BCD*10.3 Func. Tax Recoverable Amount 2
TXREC3HC BCD*10.3 Func. Tax Recoverable Amount 3
TXREC4HC BCD*10.3 Func. Tax Recoverable Amount 4
TXREC5HC BCD*10.3 Func. Tax Recoverable Amount 5
TXEXP1HC BCD*10.3 Func. Tax Expense Sep. Amount 1
TXEXP2HC BCD*10.3 Func. Tax Expense Sep. Amount 2
TXEXP3HC BCD*10.3 Func. Tax Expense Sep. Amount 3
TXEXP4HC BCD*10.3 Func. Tax Expense Sep. Amount 4
TXEXP5HC BCD*10.3 Func. Tax Expense Sep. 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
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
AMTCOSTHC BCD*10.6 Func. Cost
AMTDISTHC BCD*10.3 Func. Distributed Amount
DISTNETHC BCD*10.3 Func. Distribution Net of Taxes
RTGAMTHC BCD*10.3 Func. Retainage Amount
TXALLRTHC BCD*10.3 Func. Retainage Tax Allocated
TXALLRTTC BCD*10.3 Retainage Tax Allocated
TXEXPRTHC BCD*10.3 Func. Retainage Tax Expensed
TXEXPRTTC BCD*10.3 Retainage Tax Expensed
SWFAS Integer Fixed Asset List:2 entries
0 = No
1 = Yes
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
SWCAXABLE1 Integer Reverse Chargeable 1 List:2 entries
0 = No
1 = Yes
SWCAXABLE2 Integer Reverse Chargeable 2 List:2 entries
0 = No
1 = Yes
SWCAXABLE3 Integer Reverse Chargeable 3 List:2 entries
0 = No
1 = Yes
SWCAXABLE4 Integer Reverse Chargeable 4 List:2 entries
0 = No
1 = Yes
SWCAXABLE5 Integer Reverse Chargeable 5 List:2 entries
0 = No
1 = Yes

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