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: 199

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 Sage Fixed Assets Orgid E A 
FADATABASE 193 String*32 Sage Fixed Assets Database E A 
FACOMPANY 194 String*32 Sage Fixed Assets Company/Org. E A 
FATEMPLATE 195 String*25 Sage Fixed Assets Template E A 
FADESC 196 String*80 Sage Fixed Assets Asset Description E A 
FASWSEPQTY 197 Integer Separate Assets E A  List:2 entries
0 = No
1 = Yes
FAQTY 198 BCD*10.5 Sage Fixed Assets Quantity E A 
FAUOM 199 String*10 Sage Fixed Assets Unit of Measure E A 
FAAMTTC 200 BCD*10.3 Sage Fixed Assets Asset Value E A 
FAAMTHC 201 BCD*10.3 Sage Fixed Assets Func. Asset Value E A 
AMTWHT1TC 202 BCD*10.3 Estimated Tax Withheld Amount 1 E A C 
AMTWHT2TC 203 BCD*10.3 Estimated Tax Withheld Amount 2 E A C 
AMTWHT3TC 204 BCD*10.3 Estimated Tax Withheld Amount 3 E A C 
AMTWHT4TC 205 BCD*10.3 Estimated Tax Withheld Amount 4 E A C 
AMTWHT5TC 206 BCD*10.3 Estimated Tax Withheld Amount 5 E A C 
AMTCXTX1TC 207 BCD*10.3 Reverse Charge Amount 1 E A 
AMTCXTX2TC 208 BCD*10.3 Reverse Charge Amount 2 E A 
AMTCXTX3TC 209 BCD*10.3 Reverse Charge Amount 3 E A 
AMTCXTX4TC 210 BCD*10.3 Reverse Charge Amount 4 E A 
AMTCXTX5TC 211 BCD*10.3 Reverse Charge Amount 5 E A 
SWCAXABLE1 212 Integer Reverse Chargeable 1 A C  List:2 entries
0 = No
1 = Yes
SWCAXABLE2 213 Integer Reverse Chargeable 2 A C  List:2 entries
0 = No
1 = Yes
SWCAXABLE3 214 Integer Reverse Chargeable 3 A C  List:2 entries
0 = No
1 = Yes
SWCAXABLE4 215 Integer Reverse Chargeable 4 A C  List:2 entries
0 = No
1 = Yes
SWCAXABLE5 216 Integer Reverse Chargeable 5 A C  List:2 entries
0 = No
1 = Yes

This page was generated on 2023-Aug-31

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