# Table: Invoice Details

Table: ARIBD
View: AR0033
Record length: 1099
Flags: A R

## Keys: 1

Title | Flags | Fields
--- | --- | ---
Invoice Detail Seq. Number |  | CNTBTCH, CNTITEM, CNTLINE

## Fields: 110

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 |  |
IDINVC | String*22 | Reserved |
IDITEM | String*16 | Item Number | Mask: %-16C
IDDIST | String*6 | Distribution Code | Mask: %-6N
TEXTDESC | String*60 | Description |
SWMANLITEM | Integer | Reserved |
UNITMEAS | String*10 | Unit of Measure | Mask: %-10C
QTYINVC | BCD*10.5 | Quantity |
AMTCOST | BCD*10.6 | Cost |
AMTPRIC | BCD*10.6 | Price |
AMTEXTN | BCD*10.3 | Extended Amount w/ TIP |
AMTCOGS | BCD*10.3 | COGS Amount |
AMTTXBL | BCD*10.3 | Extended Amount w/o TIP |
TOTTAX | BCD*10.3 | Tax Total |
SWMANLTX | Integer | Reserved |
BASETAX1 | BCD*10.3 | Tax Base 1 |
BASETAX2 | BCD*10.3 | Tax Base 2 |
BASETAX3 | BCD*10.3 | Tax Base 3 |
BASETAX4 | BCD*10.3 | Tax Base 4 |
BASETAX5 | BCD*10.3 | Tax Base 5 |
TAXSTTS1 | Integer | Tax Class 1 |
TAXSTTS2 | Integer | Tax Class 2 |
TAXSTTS3 | Integer | Tax Class 3 |
TAXSTTS4 | Integer | Tax Class 4 |
TAXSTTS5 | 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
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 |
IDACCTREV | String*45 | Revenue Account | Mask: %-45C
IDACCTINV | String*45 | Inventory Account | Mask: %-45C
IDACCTCOGS | String*45 | COGS Account | Mask: %-45C
IDJOBPROJ | String*30 | Reserved |
CONTRACT | String*16 | Contract | Mask: %-16C
PROJECT | String*16 | Project | Mask: %-16N
CATEGORY | String*16 | Category | 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
BILLDATE | Date | Billing Date |
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 | Values |
RTGDISTTC | BCD*10.3 | Retainage Distribution Amount |
RTGCOGSTC | BCD*10.3 | Retainage COGS Amount |
RTGALTBTC | BCD*10.3 | Retainage Alternate Base Amount |
RTGINVDIST | BCD*10.3 | Invoiced Retainage Distribution |
RTGINVCOGS | BCD*10.3 | Invoiced Retainage COGS |
RTGINVALTB | BCD*10.3 | Invoiced Retainage Alternate Bas |
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 |
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 |
DISTNETHC | BCD*10.3 | Func. Distribution Net of Taxes |
RTGAMTHC | BCD*10.3 | Func. Retainage Amount |
AMTCOGSHC | BCD*10.3 | Func. COGS Amount |
AMTCOSTHC | BCD*10.6 | Func. Cost |
AMTPRICHC | BCD*10.6 | Func. Price |
AMTEXTNHC | BCD*10.3 | Func. Extended Amount w/ TIP |

This page was generated on 2006-Sep-07

Copyright © 2001–2005 Sage Accpac International, Inc.