# View: Invoice Details

RotoID: AR0033
Table: ARIBD
DLL: ARIBD

## Compositions: 3

RotoID | Table | Title | DLL
--- | --- | --- | ---
AR0032 | ARIBH | Invoices | ARIBH
AR0031 | ARIBC | Invoice Batches | ARIBC
AR0401 | ARIBDO | Invoice Detail Optional Fields | ARIBDO

## Keys: 1

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

## Fields: 120

Field | Index | Type | Title | Attributes | Presentation
--- | --- | --- | --- | --- | ---
CNTBTCH | 1 | BCD*5.0 | Batch Number | E A K R |
CNTITEM | 2 | BCD*4.0 | Entry Number | E A K R |
CNTLINE | 3 | BCD*3.0 | Line Number | E A K R |
IDINVC | 4 | String*22 | Reserved | E |
IDITEM | 5 | String*16 | Item Number | E A | Mask: %-16C
IDDIST | 6 | String*6 | Distribution Code | E A | Mask: %-6N
TEXTDESC | 7 | String*60 | Description | E A |
SWMANLITEM | 8 | Integer | Reserved | E |
UNITMEAS | 9 | String*10 | Unit of Measure | E A | Mask: %-10C
QTYINVC | 10 | BCD*10.5 | Quantity | E A |
AMTCOST | 11 | BCD*10.6 | Cost | E A |
AMTPRIC | 12 | BCD*10.6 | Price | E A |
AMTEXTN | 13 | BCD*10.3 | Extended Amount w/ TIP | E A |
AMTCOGS | 14 | BCD*10.3 | COGS Amount | E A |
AMTTXBL | 15 | BCD*10.3 | Extended Amount w/o TIP | E A C |
TOTTAX | 16 | BCD*10.3 | Tax Total | E A C |
SWMANLTX | 17 | Integer | Reserved | E |
BASETAX1 | 18 | BCD*10.3 | Tax Base 1 | E A |
BASETAX2 | 19 | BCD*10.3 | Tax Base 2 | E A |
BASETAX3 | 20 | BCD*10.3 | Tax Base 3 | E A |
BASETAX4 | 21 | BCD*10.3 | Tax Base 4 | E A |
BASETAX5 | 22 | BCD*10.3 | Tax Base 5 | E A |
TAXSTTS1 | 23 | Integer | Tax Class 1 | E A |
TAXSTTS2 | 24 | Integer | Tax Class 2 | E A |
TAXSTTS3 | 25 | Integer | Tax Class 3 | E A |
TAXSTTS4 | 26 | Integer | Tax Class 4 | E A |
TAXSTTS5 | 27 | Integer | Tax Class 5 | E A |
SWTAXINCL1 | 28 | Integer | Tax Included 1 | E A | List: 2 entries
0 | = | No
1 | = | Yes
SWTAXINCL2 | 29 | Integer | Tax Included 2 | E A | List: 2 entries
0 | = | No
1 | = | Yes
SWTAXINCL3 | 30 | Integer | Tax Included 3 | E A | List: 2 entries
0 | = | No
1 | = | Yes
SWTAXINCL4 | 31 | Integer | Tax Included 4 | E A | List: 2 entries
0 | = | No
1 | = | Yes
SWTAXINCL5 | 32 | Integer | Tax Included 5 | E A | List: 2 entries
0 | = | No
1 | = | Yes
RATETAX1 | 33 | BCD*8.5 | Tax Rate 1 | E A C |
RATETAX2 | 34 | BCD*8.5 | Tax Rate 2 | E A C |
RATETAX3 | 35 | BCD*8.5 | Tax Rate 3 | E A C |
RATETAX4 | 36 | BCD*8.5 | Tax Rate 4 | E A C |
RATETAX5 | 37 | BCD*8.5 | Tax Rate 5 | E A C |
AMTTAX1 | 38 | BCD*10.3 | Tax Amount 1 | E A |
AMTTAX2 | 39 | BCD*10.3 | Tax Amount 2 | E A |
AMTTAX3 | 40 | BCD*10.3 | Tax Amount 3 | E A |
AMTTAX4 | 41 | BCD*10.3 | Tax Amount 4 | E A |
AMTTAX5 | 42 | BCD*10.3 | Tax Amount 5 | E A |
IDACCTREV | 43 | String*45 | Revenue Account | E A | Mask: %-45C
IDACCTINV | 44 | String*45 | Inventory Account | E A | Mask: %-45C
IDACCTCOGS | 45 | String*45 | COGS Account | E A | Mask: %-45C
IDJOBPROJ | 46 | String*30 | Reserved | E |
COMMENT | 47 | String*250 | Comments | E A |
SWPRTSTMT | 48 | Integer | Print Comment | E A |
ITEMCOST | 49 | BCD*10.3 | Item Cost | E A |
CONTRACT | 50 | String*16 | Contract | E A | Mask: %-16C
PROJECT | 51 | String*16 | Project | E A | Mask: %-16N
CATEGORY | 52 | String*16 | Category | E A | Mask: %-16N
RESOURCE | 53 | String*24 | Project/Category Resource | E A P | Mask: %-16N
TRANSNBR | 54 | Long | Transaction Number | E A C |
COSTCLASS | 55 | Integer | Cost Class | E A C | List: 7 entries
0 | = |
1 | = | Labor
2 | = | Material
3 | = | Equipment
4 | = | Subcontractor
5 | = | Overhead
6 | = | Miscellaneous
BILLDATE | 56 | Date | Billing Date | E A |
SWIBT | 57 | Integer | Comment Attached | E A C | List: 2 entries
0 | = | No
1 | = | Yes
SWDISCABL | 58 | Integer | Discountable | E A | List: 2 entries
0 | = | No
1 | = | Yes
OCNTLINE | 59 | BCD*3.0 | Original Line Identifier | E A |
RTGAMT | 60 | BCD*10.3 | Retainage Amount | E A |
RTGPERCENT | 61 | BCD*5.5 | Percent Retained | E A |
RTGDAYS | 62 | Integer | Days Retained | E A |
RTGDATEDUE | 63 | Date | Retainage Due Date | E A |
SWRTGDDTOV | 64 | Integer | Retainage Due Date Override | E A | List: 2 entries
0 | = | No
1 | = | Yes
SWRTGAMTOV | 65 | Integer | Retainage Amount Override | E A | List: 2 entries
0 | = | No
1 | = | Yes
VALUES | 66 | Long | Values | E A C |
PROCESSCMD | 67 | Integer | Process Command Code | E A C | List: 1 entries
0 | = | Insert Optional Fields
RTGDISTTC | 68 | BCD*10.3 | Retainage Distribution Amount | E A C |
RTGCOGSTC | 69 | BCD*10.3 | Retainage COGS Amount | E A C |
RTGALTBTC | 70 | BCD*10.3 | Retainage Alternate Base Amount | E A C |
RTGINVDIST | 71 | BCD*10.3 | Invoiced Retainage Distribution | E A C |
RTGINVCOGS | 72 | BCD*10.3 | Invoiced Retainage COGS | E A C |
RTGINVALTB | 73 | BCD*10.3 | Invoiced Retainage Alternate Bas | E A C |
TXAMT1RC | 74 | BCD*10.3 | Tax Reporting Amount 1 | E A |
TXAMT2RC | 75 | BCD*10.3 | Tax Reporting Amount 2 | E A |
TXAMT3RC | 76 | BCD*10.3 | Tax Reporting Amount 3 | E A |
TXAMT4RC | 77 | BCD*10.3 | Tax Reporting Amount 4 | E A |
TXAMT5RC | 78 | BCD*10.3 | Tax Reporting Amount 5 | E A |
TXTOTRC | 79 | BCD*10.3 | Tax Reporting Total | E A C |
TXBSERT1TC | 80 | BCD*10.3 | Retainage Tax Base 1 | E A |
TXBSERT2TC | 81 | BCD*10.3 | Retainage Tax Base 2 | E A |
TXBSERT3TC | 82 | BCD*10.3 | Retainage Tax Base 3 | E A |
TXBSERT4TC | 83 | BCD*10.3 | Retainage Tax Base 4 | E A |
TXBSERT5TC | 84 | BCD*10.3 | Retainage Tax Base 5 | E A |
TXAMTRT1TC | 85 | BCD*10.3 | Retainage Tax Amount 1 | E A |
TXAMTRT2TC | 86 | BCD*10.3 | Retainage Tax Amount 2 | E A |
TXAMTRT3TC | 87 | BCD*10.3 | Retainage Tax Amount 3 | E A |
TXAMTRT4TC | 88 | BCD*10.3 | Retainage Tax Amount 4 | E A |
TXAMTRT5TC | 89 | BCD*10.3 | Retainage Tax Amount 5 | E A |
TXBSE1HC | 90 | BCD*10.3 | Func. Tax Base 1 | E A C |
TXBSE2HC | 91 | BCD*10.3 | Func. Tax Base 2 | E A C |
TXBSE3HC | 92 | BCD*10.3 | Func. Tax Base 3 | E A C |
TXBSE4HC | 93 | BCD*10.3 | Func. Tax Base 4 | E A C |
TXBSE5HC | 94 | BCD*10.3 | Func. Tax Base 5 | E A C |
TXAMT1HC | 95 | BCD*10.3 | Func. Tax Amount 1 | E A C |
TXAMT2HC | 96 | BCD*10.3 | Func. Tax Amount 2 | E A C |
TXAMT3HC | 97 | BCD*10.3 | Func. Tax Amount 3 | E A C |
TXAMT4HC | 98 | BCD*10.3 | Func. Tax Amount 4 | E A C |
TXAMT5HC | 99 | BCD*10.3 | Func. Tax Amount 5 | E A C |
TXAMTRT1HC | 100 | BCD*10.3 | Func. Retainage Tax Amount 1 | E A C |
TXAMTRT2HC | 101 | BCD*10.3 | Func. Retainage Tax Amount 2 | E A C |
TXAMTRT3HC | 102 | BCD*10.3 | Func. Retainage Tax Amount 3 | E A C |
TXAMTRT4HC | 103 | BCD*10.3 | Func. Retainage Tax Amount 4 | E A C |
TXAMTRT5HC | 104 | BCD*10.3 | Func. Retainage Tax Amount 5 | E A C |
DISTNETHC | 105 | BCD*10.3 | Func. Distribution Net of Taxes | E A C |
RTGAMTHC | 106 | BCD*10.3 | Func. Retainage Amount | E A C |
AMTCOGSHC | 107 | BCD*10.3 | Func. COGS Amount | E A C |
AMTCOSTHC | 108 | BCD*10.6 | Func. Cost | E A C |
AMTPRICHC | 109 | BCD*10.6 | Func. Price | E A C |
AMTEXTNHC | 110 | BCD*10.3 | Func. Extended Amount w/ TIP | E A C |
TXTOTRTTC | 111 | BCD*10.3 | Retainage Tax Total | E A C |
TXTOTAMT1 | 112 | BCD*10.3 | Tax Amount 1 Total | E A C |
TXTOTAMT2 | 113 | BCD*10.3 | Tax Amount 2 Total | E A C |
TXTOTAMT3 | 114 | BCD*10.3 | Tax Amount 3 Total | E A C |
TXTOTAMT4 | 115 | BCD*10.3 | Tax Amount 4 Total | E A C |
TXTOTAMT5 | 116 | BCD*10.3 | Tax Amount 5 Total | E A C |
RTGAMTOTC | 117 | BCD*10.3 | Curr. Retainage Amount | E A C |
RTGDISTOTC | 118 | BCD*10.3 | Curr. Retainage Dist. Amount | E A C |
RTGCOGSOTC | 119 | BCD*10.3 | Curr. COGS Amount | E A C |
RTGALTBOTC | 120 | BCD*10.3 | Curr. Alternate Base Amount | E A C |

This page was generated on 2006-Sep-07

Copyright © 2001–2005 Sage Accpac International, Inc.