# Table: Invoice Details

Table: APIBD
View: AP0022
Record length: 1443
Flags: A R

## Keys: 1

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

## Fields: 155

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

This page was generated on 2008-May-01

Copyright © 2001–2008 Sage Software, Inc. All rights reserved.