# View: Invoice Details

RotoID: AP0022
Table: APIBD
Protocol: Detail, Sequenced revisions, Key auto generate
DLL: APIBD

## Compositions: 3

RotoID | Tables | Title | DLL
--- | --- | --- | ---
AP0021 | APIBH | Invoices | APIBH
AP0020 | APIBC | Invoice Batches | APIBC
AP0401 | APIBDO | Invoice Detail Optional Fields | APIBDO

## Keys: 1

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

## Fields: 184

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 |
DESCOMP | 89 | String*6 | Destination | E A X | Mask: %-6N
ROUTE | 90 | Integer | Route No. | E A X |
IDDIST | 4 | String*6 | Distribution Code | E A | Mask: %-6N
TEXTDESC | 5 | String*60 | Distribution Description | E A |
SWMANLDIST | 6 | Integer | Reserved | E |
AMTTOTTAX | 7 | BCD*10.3 | Tax Total | E A C |
SWMANLTX | 8 | Integer | Manual Tax Entry | E A | List: 2 entries
0 | = | No
1 | = | Yes
BASETAX1 | 9 | BCD*10.3 | Base Tax 1 | E A |
BASETAX2 | 10 | BCD*10.3 | Base Tax 2 | E A |
BASETAX3 | 11 | BCD*10.3 | Base Tax 3 | E A |
BASETAX4 | 12 | BCD*10.3 | Base Tax 4 | E A |
BASETAX5 | 13 | BCD*10.3 | Base Tax 5 | E A |
TAXCLASS1 | 14 | Integer | Tax Class 1 | E A |
TAXCLASS2 | 15 | Integer | Tax Class 2 | E A |
TAXCLASS3 | 16 | Integer | Tax Class 3 | E A |
TAXCLASS4 | 17 | Integer | Tax Class 4 | E A |
TAXCLASS5 | 18 | Integer | Tax Class 5 | E A |
SWTAXINCL1 | 19 | Integer | Tax Inclusive 1 | E A | List: 2 entries
0 | = | No
1 | = | Yes
SWTAXINCL2 | 20 | Integer | Tax Inclusive 2 | E A | List: 2 entries
0 | = | No
1 | = | Yes
SWTAXINCL3 | 21 | Integer | Tax Inclusive 3 | E A | List: 2 entries
0 | = | No
1 | = | Yes
SWTAXINCL4 | 22 | Integer | Tax Inclusive 4 | E A | List: 2 entries
0 | = | No
1 | = | Yes
SWTAXINCL5 | 23 | Integer | Tax Inclusive 5 | E A | List: 2 entries
0 | = | No
1 | = | Yes
RATETAX1 | 24 | BCD*8.5 | Tax Rate 1 | E A |
RATETAX2 | 25 | BCD*8.5 | Tax Rate 2 | E A |
RATETAX3 | 26 | BCD*8.5 | Tax Rate 3 | E A |
RATETAX4 | 27 | BCD*8.5 | Tax Rate 4 | E A |
RATETAX5 | 28 | BCD*8.5 | Tax Rate 5 | E A |
AMTTAX1 | 29 | BCD*10.3 | Tax Amount 1 | E A |
AMTTAX2 | 30 | BCD*10.3 | Tax Amount 2 | E A |
AMTTAX3 | 31 | BCD*10.3 | Tax Amount 3 | E A |
AMTTAX4 | 32 | BCD*10.3 | Tax Amount 4 | E A |
AMTTAX5 | 33 | BCD*10.3 | Tax Amount 5 | E A |
IDGLACCT | 34 | String*45 | G/L Account | E A | Mask: %-45C
IDACCTTAX | 35 | String*45 | Retainage Allocated Tax Account | E A C | Mask: %-45C
ID1099CLAS | 36 | String*6 | Reserved | E |
AMTDIST | 37 | BCD*10.3 | Distributed Amount | E A |
COMMENT | 38 | String*250 | Comment | E A |
SWPRTSTMT | 39 | Integer | Reserved | E |
AMTDISTNET | 40 | BCD*10.3 | Distributed Amount Before Taxes | E A |
AMTINCLTAX | 41 | BCD*10.3 | Tax Amount Included in Price | E A C |
AMTGLDIST | 42 | BCD*10.3 | G/L Distributed Amount | E A C |
AMTTAXREC1 | 43 | BCD*10.3 | Recoverable Tax Amount 1 | E A C |
AMTTAXREC2 | 44 | BCD*10.3 | Recoverable Tax Amount 2 | E A C |
AMTTAXREC3 | 45 | BCD*10.3 | Recoverable Tax Amount 3 | E A C |
AMTTAXREC4 | 46 | BCD*10.3 | Recoverable Tax Amount 4 | E A C |
AMTTAXREC5 | 47 | BCD*10.3 | Recoverable Tax Amount 5 | E A C |
AMTTAXEXP1 | 53 | BCD*10.3 | Expense Sep. Tax Amount 1 | E A C |
AMTTAXEXP2 | 54 | BCD*10.3 | Expense Sep. Tax Amount 2 | E A C |
AMTTAXEXP3 | 55 | BCD*10.3 | Expense Sep. Tax Amount 3 | E A C |
AMTTAXEXP4 | 56 | BCD*10.3 | Expense Sep. Tax Amount 4 | E A C |
AMTTAXEXP5 | 57 | BCD*10.3 | Expense Sep. Tax Amount 5 | E A C |
AMTTAXTOBE | 63 | BCD*10.3 | Tax Allocated Total | E A C |
CONTRACT | 64 | String*16 | Contract Code | E A | Mask: %-16C
PROJECT | 65 | String*16 | Project Code | E A | Mask: %-16N
CATEGORY | 66 | String*16 | Category Code | E A | Mask: %-16N
RESOURCE | 67 | String*24 | Project/Category Resource | E A P | Mask: %-16N
TRANSNBR | 68 | Long | Transaction Number | E A C |
COSTCLASS | 69 | Integer | Cost Class | E A C | List: 7 entries
0 | = |
1 | = | Labor
2 | = | Material
3 | = | Equipment
4 | = | Subcontractor
5 | = | Overhead
6 | = | Miscellaneous
BILLTYPE | 70 | Integer | Billing Type | E A P | List: 1 entries
0 | = |
IDITEM | 71 | String*16 | Item Number | E A | Mask: %-16C
UNITMEAS | 72 | String*10 | Unit of Measure | E A | Mask: %-10C
QTYINVC | 73 | BCD*10.5 | Quantity | E A |
AMTCOST | 74 | BCD*10.6 | Cost | E A |
BILLDATE | 75 | Date | Billing Date | E A |
BILLRATE | 76 | BCD*10.6 | Billing Rate | E A |
BILLCURN | 77 | String*3 | Billing Currency | E A C | Mask: %-3N
SWIBT | 78 | Integer | Comment Attached | E A C | List: 2 entries
0 | = | No
1 | = | Yes
SWDISCABL | 79 | Integer | Discountable | E A | List: 2 entries
0 | = | No
1 | = | Yes
OCNTLINE | 80 | BCD*3.0 | Original Line Identifier | E A |
RTGAMT | 81 | BCD*10.3 | Retainage Amount | E A |
RTGPERCENT | 82 | BCD*5.5 | Percent Retained | E A |
RTGDAYS | 83 | Integer | Days Retained | E A |
RTGDATEDUE | 84 | Date | Retainage Due Date | E A |
SWRTGDDTOV | 85 | Integer | Retainage Due Date Override | E A | List: 2 entries
0 | = | No
1 | = | Yes
SWRTGAMTOV | 86 | Integer | Retainage Amount Override | E A | List: 2 entries
0 | = | No
1 | = | Yes
VALUES | 87 | Long | Optional Fields | E A C |
PROCESSCMD | 88 | Integer | Process Command Code | E A C | List: 1 entries
0 | = | Insert Optional Fields
DESEXIST | 91 | Integer | Dest. Exists | E A C |
DESNAME | 92 | String*60 | Dest. Description | E A C |
DESSTAT | 93 | Integer | Dest. Status | E A C |
DCODEEXIST | 95 | Integer | Dist. Code Exists | E A C |
DCODEDESC | 96 | String*60 | Dist. Code Description | E A C |
DCODESTAT | 97 | Integer | Dist. Code Status | E A C |
ROUTEXIST | 100 | Integer | Route Exists | E A C |
ROUTNAME | 101 | String*60 | Route Description | E A C |
ROUTSTAT | 102 | Integer | Route Status | E A C |
ACTEXIST | 105 | Integer | Acct. Exists | E A C |
ACTDESC | 106 | String*60 | Acct. Description | E A C |
ACTSTAT | 107 | Integer | Acct. Status | E A C |
RTGDISTTC | 110 | BCD*10.3 | Retainage Distribution Amount | E A C |
RTGINVDIST | 111 | BCD*10.3 | Invoiced Retainage Distribution | E A C |
TXAMT1RC | 112 | BCD*10.3 | Tax Reporting Amount 1 | E A |
TXAMT2RC | 113 | BCD*10.3 | Tax Reporting Amount 2 | E A |
TXAMT3RC | 114 | BCD*10.3 | Tax Reporting Amount 3 | E A |
TXAMT4RC | 115 | BCD*10.3 | Tax Reporting Amount 4 | E A |
TXAMT5RC | 116 | BCD*10.3 | Tax Reporting Amount 5 | E A |
TXTOTRC | 117 | BCD*10.3 | Tax Reporting Total | E A C |
TXALLRC | 118 | BCD*10.3 | Tax Reporting Allocated Tax | E A C |
TXEXP1RC | 119 | BCD*10.3 | Tax Reporting Expensed Tax 1 | E A C |
TXEXP2RC | 120 | BCD*10.3 | Tax Reporting Expensed Tax 2 | E A C |
TXEXP3RC | 121 | BCD*10.3 | Tax Reporting Expensed Tax 3 | E A C |
TXEXP4RC | 122 | BCD*10.3 | Tax Reporting Expensed Tax 4 | E A C |
TXEXP5RC | 123 | BCD*10.3 | Tax Reporting Expensed Tax 5 | E A C |
TXREC1RC | 124 | BCD*10.3 | Tax Reporting Recoverable Tax 1 | E A C |
TXREC2RC | 125 | BCD*10.3 | Tax Reporting Recoverable Tax 2 | E A C |
TXREC3RC | 126 | BCD*10.3 | Tax Reporting Recoverable Tax 3 | E A C |
TXREC4RC | 127 | BCD*10.3 | Tax Reporting Recoverable Tax 4 | E A C |
TXREC5RC | 128 | BCD*10.3 | Tax Reporting Recoverable Tax 5 | E A C |
TXBSERT1TC | 129 | BCD*10.3 | Retainage Tax Base 1 | E A |
TXBSERT2TC | 130 | BCD*10.3 | Retainage Tax Base 2 | E A |
TXBSERT3TC | 131 | BCD*10.3 | Retainage Tax Base 3 | E A |
TXBSERT4TC | 132 | BCD*10.3 | Retainage Tax Base 4 | E A |
TXBSERT5TC | 133 | BCD*10.3 | Retainage Tax Base 5 | E A |
TXAMTRT1TC | 134 | BCD*10.3 | Retainage Tax Amount 1 | E A |
TXAMTRT2TC | 135 | BCD*10.3 | Retainage Tax Amount 2 | E A |
TXAMTRT3TC | 136 | BCD*10.3 | Retainage Tax Amount 3 | E A |
TXAMTRT4TC | 137 | BCD*10.3 | Retainage Tax Amount 4 | E A |
TXAMTRT5TC | 138 | BCD*10.3 | Retainage Tax Amount 5 | E A |
TXBSE1HC | 139 | BCD*10.3 | Func. Tax Base 1 | E A C |
TXBSE2HC | 140 | BCD*10.3 | Func. Tax Base 2 | E A C |
TXBSE3HC | 141 | BCD*10.3 | Func. Tax Base 3 | E A C |
TXBSE4HC | 142 | BCD*10.3 | Func. Tax Base 4 | E A C |
TXBSE5HC | 143 | BCD*10.3 | Func. Tax Base 5 | E A C |
TXAMT1HC | 144 | BCD*10.3 | Func. Tax Amount 1 | E A C |
TXAMT2HC | 145 | BCD*10.3 | Func. Tax Amount 2 | E A C |
TXAMT3HC | 146 | BCD*10.3 | Func. Tax Amount 3 | E A C |
TXAMT4HC | 147 | BCD*10.3 | Func. Tax Amount 4 | E A C |
TXAMT5HC | 148 | BCD*10.3 | Func. Tax Amount 5 | E A C |
TXAMTRT1HC | 149 | BCD*10.3 | Func. Retainage Tax Amount 1 | E A C |
TXAMTRT2HC | 150 | BCD*10.3 | Func. Retainage Tax Amount 2 | E A C |
TXAMTRT3HC | 151 | BCD*10.3 | Func. Retainage Tax Amount 3 | E A C |
TXAMTRT4HC | 152 | BCD*10.3 | Func. Retainage Tax Amount 4 | E A C |
TXAMTRT5HC | 153 | BCD*10.3 | Func. Retainage Tax Amount 5 | E A C |
TXREC1HC | 154 | BCD*10.3 | Func. Tax Recoverable Amount 1 | E A C |
TXREC2HC | 155 | BCD*10.3 | Func. Tax Recoverable Amount 2 | E A C |
TXREC3HC | 156 | BCD*10.3 | Func. Tax Recoverable Amount 3 | E A C |
TXREC4HC | 157 | BCD*10.3 | Func. Tax Recoverable Amount 4 | E A C |
TXREC5HC | 158 | BCD*10.3 | Func. Tax Recoverable Amount 5 | E A C |
TXEXP1HC | 159 | BCD*10.3 | Func. Tax Expense Sep. Amount 1 | E A C |
TXEXP2HC | 160 | BCD*10.3 | Func. Tax Expense Sep. Amount 2 | E A C |
TXEXP3HC | 161 | BCD*10.3 | Func. Tax Expense Sep. Amount 3 | E A C |
TXEXP4HC | 162 | BCD*10.3 | Func. Tax Expense Sep. Amount 4 | E A C |
TXEXP5HC | 163 | BCD*10.3 | Func. Tax Expense Sep. Amount 5 | E A C |
TXALLHC | 164 | BCD*10.3 | Func. Tax Allocated Total | E A C |
TXALL1HC | 165 | BCD*10.3 | Func. Tax Allocated Amount 1 | E A C |
TXALL2HC | 166 | BCD*10.3 | Func. Tax Allocated Amount 2 | E A C |
TXALL3HC | 167 | BCD*10.3 | Func. Tax Allocated Amount 3 | E A C |
TXALL4HC | 168 | BCD*10.3 | Func. Tax Allocated Amount 4 | E A C |
TXALL5HC | 169 | BCD*10.3 | Func. Tax Allocated Amount 5 | E A C |
TXALL1TC | 170 | BCD*10.3 | Tax Allocated Amount 1 | E A C |
TXALL2TC | 171 | BCD*10.3 | Tax Allocated Amount 2 | E A C |
TXALL3TC | 172 | BCD*10.3 | Tax Allocated Amount 3 | E A C |
TXALL4TC | 173 | BCD*10.3 | Tax Allocated Amount 4 | E A C |
TXALL5TC | 174 | BCD*10.3 | Tax Allocated Amount 5 | E A C |
AMTCOSTHC | 175 | BCD*10.6 | Func. Cost | E A C |
AMTDISTHC | 176 | BCD*10.3 | Func. Distributed Amount | E A C |
DISTNETHC | 177 | BCD*10.3 | Func. Distribution Net of Taxes | E A C |
RTGAMTHC | 178 | BCD*10.3 | Func. Retainage Amount | E A C |
TXALLRTHC | 179 | BCD*10.3 | Func. Retainage Tax Allocated | E A C |
TXALLRTTC | 180 | BCD*10.3 | Retainage Tax Allocated | E A C |
TXEXPRTHC | 181 | BCD*10.3 | Func. Retainage Tax Expensed | E A C |
TXEXPRTTC | 182 | BCD*10.3 | Retainage Tax Expensed | E A C |
TXTOTRTTC | 183 | BCD*10.3 | Retainage Tax Total | E A C |
TXTOTAMT1 | 184 | BCD*10.3 | Tax Amount 1 Total | E A C |
TXTOTAMT2 | 185 | BCD*10.3 | Tax Amount 2 Total | E A C |
TXTOTAMT3 | 186 | BCD*10.3 | Tax Amount 3 Total | E A C |
TXTOTAMT4 | 187 | BCD*10.3 | Tax Amount 4 Total | E A C |
TXTOTAMT5 | 188 | BCD*10.3 | Tax Amount 5 Total | E A C |
RTGAMTOTC | 189 | BCD*10.3 | Curr. Retainage Amount | E A C |
RTGDISTOTC | 190 | BCD*10.3 | Curr. Retainage Dist. Amount | E A C |
SWFAS | 191 | Integer | Fixed Asset | E A | List: 2 entries
0 | = | No
1 | = | Yes
FAORGID | 192 | String*6 | FAS Orgid | E A |
FADATABASE | 193 | String*32 | FAS Database | E A |
FACOMPANY | 194 | String*32 | FAS Company/Org. | E A |
FATEMPLATE | 195 | String*25 | FAS Template | E A |
FADESC | 196 | String*80 | FAS Asset Description | E A |
FASWSEPQTY | 197 | Integer | Separate Assets | E A | List: 2 entries
0 | = | No
1 | = | Yes
FAQTY | 198 | BCD*10.5 | FAS Quantity | E A |
FAUOM | 199 | String*10 | FAS Unit of Measure | E A |
FAAMTTC | 200 | BCD*10.3 | FAS Asset Value | E A |
FAAMTHC | 201 | BCD*10.3 | FAS Func. Asset Value | E A |

This page was generated on 2009-Nov-19

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