View: Invoices

RotoID: AP0021
Table: APIBH
Protocol: Header, Key auto generate
DLL:APIBH

Compositions: 4

RotoID Tables Title DLL
AP0020 APIBC Invoice Batches APIBC
AP0022 APIBD Invoice Details APIBD
AP0023 APIBS Invoice Payment Schedules APIBS
AP0402 APIBHO Invoice Optional Fields APIBHO

Keys: 4

Title Fields
Batch Number/Entry Number CNTBTCH, CNTITEM
Vendor Number/Document Number ORIGCOMP, IDVEND, IDINVC
Vendor Number/Total Distributed ORIGCOMP, IDVEND, AMTTOTDIST
Vendor Number/Document Date ORIGCOMP, IDVEND, DATEINVC

Fields: 253

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 
ORIGCOMP 155 String*6 Originator E A X  Mask: %-6N
IDVEND 3 String*12 Vendor Number E A R  Mask: %-12C
IDINVC 4 String*22 Document Number E A R  Mask: %-22C
IDRMITTO 5 String*6 Remit-To Location E A  Mask: %-6N
TEXTTRX 6 Integer Document Type E A  List:4 entries
1 = Invoice
2 = Debit Note
3 = Credit Note
4 = Interest
IDTRX 7 Integer Transaction Type E A C  List:5 entries
12 = Invoice - Summary Entered
13 = Invoice - Recurring Charge
22 = Debit Note - Summary Entered
32 = Credit Note - Summary Entered
40 = Interest Charge
INVCSTTS 8 Integer Reserved E 
ORDRNBR 9 String*22 Order Number E A  Mask: %-22C
PONBR 10 String*22 PO Number E A  Mask: %-22C
INVCDESC 11 String*60 Invoice Description E A 
SWPRTINVC 12 Integer Reserved E 
INVCAPPLTO 13 String*22 Apply-to Document E A  Mask: %-22C
IDACCTSET 14 String*6 Account Set E A  Mask: %-6N
DATEINVC 15 Date Document Date E A 
DATEASOF 16 Date As of Date E A 
FISCYR 17 String*4 Fiscal Year A C  Mask: %04D
FISCPER 18 String*2 Fiscal Period A C  Mask: %02D
CODECURN 19 String*3 Currency Code E A  Mask: %-3N
RATETYPE 20 String*2 Rate Type E A  Mask: %-2N
SWMANRTE 21 Integer Rate Overridden E A  List:2 entries
0 = No
1 = Yes
EXCHRATEHC 22 BCD*8.7 Exchange Rate E A 
ORIGRATEHC 23 BCD*8.7 Apply-to Exchange Rate E A 
TERMCODE 24 String*6 Terms E A  Mask: %-6N
SWTERMOVRD 25 Integer Terms Overridden E A  List:2 entries
0 = No
1 = Yes
DATEDUE 26 Date Due Date E A 
DATEDISC 27 Date Discount Date E A 
PCTDISC 28 BCD*5.5 Discount Percentage E A 
AMTDISCAVL 29 BCD*10.3 Discount Amount Available E A 
LASTLINE 30 BCD*3.0 Number of Details E A C 
SWTAXBL 31 Integer Taxable E A C  List:2 entries
0 = No
1 = Yes
SWCALCTX 32 Integer Tax Amount Control E A  List:3 entries
0 = Enter
1 = Calculate
2 = Distribute
CODETAXGRP 33 String*12 Tax Group E A  Mask: %-12N
CODETAX1 34 String*12 Tax Authority 1 E A C 
CODETAX2 35 String*12 Tax Authority 2 E A C 
CODETAX3 36 String*12 Tax Authority 3 E A C 
CODETAX4 37 String*12 Tax Authority 4 E A C 
CODETAX5 38 String*12 Tax Authority 5 E A C 
TAXCLASS1 39 Integer Tax Class 1 E A 
TAXCLASS2 40 Integer Tax Class 2 E A 
TAXCLASS3 41 Integer Tax Class 3 E A 
TAXCLASS4 42 Integer Tax Class 4 E A 
TAXCLASS5 43 Integer Tax Class 5 E A 
BASETAX1 44 BCD*10.3 Tax Base 1 E A 
BASETAX2 45 BCD*10.3 Tax Base 2 E A 
BASETAX3 46 BCD*10.3 Tax Base 3 E A 
BASETAX4 47 BCD*10.3 Tax Base 4 E A 
BASETAX5 48 BCD*10.3 Tax Base 5 E A 
AMTTAX1 54 BCD*10.3 Tax Amount 1 E A 
AMTTAX2 55 BCD*10.3 Tax Amount 2 E A 
AMTTAX3 56 BCD*10.3 Tax Amount 3 E A 
AMTTAX4 57 BCD*10.3 Tax Amount 4 E A 
AMTTAX5 58 BCD*10.3 Tax Amount 5 E A 
AMT1099 67 BCD*10.3 1099/CPRS Amount E A 
AMTDISTSET 68 BCD*10.3 Distribution Set Amount E A 
AMTTAXDIST 69 BCD*10.3 Total Distributed Tax E A C 
AMTINVCTOT 70 BCD*10.3 Document Total Before Taxes E A C 
AMTALLOCTX 71 BCD*10.3 Distributed Allocated Taxes E A C 
CNTPAYMSCH 72 BCD*3.0 Number of Scheduled Payments E A C 
AMTTOTDIST 73 BCD*10.3 Distributed Total Before Taxes E A C 
AMTGROSDST 74 BCD*10.3 Distributed Total Including Tax E A C 
IDPPD 75 String*22 Prepayment Number E A C 
TEXTRMIT 76 String*60 Location Name E A 
TEXTSTE1 77 String*60 Address Line 1 E A 
TEXTSTE2 78 String*60 Address Line 2 E A 
TEXTSTE3 79 String*60 Address Line 3 E A 
TEXTSTE4 80 String*60 Address Line 4 E A 
NAMECITY 81 String*30 City E A 
CODESTTE 82 String*30 State/Prov. E A 
CODEPSTL 83 String*20 Zip/Postal Code E A 
CODECTRY 84 String*30 Country E A 
NAMECTAC 85 String*60 Contact Name E A 
TEXTPHON 86 String*30 Phone Number E A P  Mask: (%-3C) %-3C-%-24C
TEXTFAX 87 String*30 Fax Number E A P  Mask: (%-3C) %-3C-%-24C
DATERATE 88 Date Rate Date E A 
AMTRECTAX 89 BCD*10.3 Recoverable Taxes E A C 
CODEPAYPPD 90 BCD*3.0 Reserved E 
CODEVNDGRP 91 String*6 Vendor Group Code E A C  Mask: %-6N
TERMSDESC 92 String*60 Terms Description E A C 
IDDISTSET 93 String*6 Distribution Set E A  Mask: %-6N
ID1099CLAS 94 String*6 1099/CPRS Code E A  Mask: %-6N
AMTDUE 95 BCD*10.3 Amount Due E A C 
CREATESCHD 96 Integer Generate Payment Schedule E A C 
AMTTAXTOT 97 BCD*10.3 Tax Total E A C 
AMTGROSTOT 98 BCD*10.3 Document Total Including Tax E A 
CREATEDIST 99 Integer Reserved E 
AMTUNDISTR 100 BCD*10.3 Undistributed Amount E A C 
SWTAXINCL1 101 Integer Tax Inclusive 1 E A  List:2 entries
0 = No
1 = Yes
SWTAXINCL2 102 Integer Tax Inclusive 2 E A  List:2 entries
0 = No
1 = Yes
SWTAXINCL3 103 Integer Tax Inclusive 3 E A  List:2 entries
0 = No
1 = Yes
SWTAXINCL4 104 Integer Tax Inclusive 4 E A  List:2 entries
0 = No
1 = Yes
SWTAXINCL5 105 Integer Tax Inclusive 5 E A  List:2 entries
0 = No
1 = Yes
AMTEXPTAX 106 BCD*10.3 Expensed Separately Taxes E A C 
AMTAXTOBE 107 BCD*10.3 Tax Amount to be Allocated E A C 
TAXOUTBAL 108 BCD*10.3 Reserved E 
SWPROCTAX 109 Integer Reserved E 
CODEOPER 110 Integer Currency Code Operator E A C  List:2 entries
1 = Multiply
2 = Divide
ACCTREC1 111 String*45 Recoverable Account 1 E A C  Mask: %-45C
ACCTREC2 112 String*45 Recoverable Account 2 E A C  Mask: %-45C
ACCTREC3 113 String*45 Recoverable Account 3 E A C  Mask: %-45C
ACCTREC4 114 String*45 Recoverable Account 4 E A C  Mask: %-45C
ACCTREC5 115 String*45 Recoverable Account 5 E A C  Mask: %-45C
ACCTEXP1 116 String*45 Expense Sep. Account 1 E A C  Mask: %-45C
ACCTEXP2 117 String*45 Expense Sep. Account 2 E A C  Mask: %-45C
ACCTEXP3 118 String*45 Expense Sep. Account 3 E A C  Mask: %-45C
ACCTEXP4 119 String*45 Expense Sep. Account 4 E A C  Mask: %-45C
ACCTEXP5 120 String*45 Expense Sep. Account 5 E A C  Mask: %-45C
DRILLAPP 121 String*2 Drill Down Application Source E A C  Mask: %-2A
DRILLTYPE 122 Integer Drill Down Type E A C 
DRILLDWNLK 123 BCD*10.0 Drill Down Link Number E A C 
PRPTYCODE 124 Integer Property Code E A C  List:1 entries
1 = Mode: Normal(1), Batch(2)
PRPTYVALUE 125 Long Property Value E A C 
PROCESSCMD 126 Integer Process Command Code E A C  List:12 entries
0 = Calculate Taxes
1 = Distribute Taxes
2 = Sum and Check Taxes
3 = Generate Distribution List
4 = Insert Optional Fields
6 = Derive Tax Reporting Exchange Rate
7 = Generate Vendor Distribution
8 = Enable Rate Lookup
9 = Disable Rate Lookup
10 = Enable Tax Reporting Rate Lookup
11 = Disable Tax Reporting Rate Lookup
12 = Process PO invoice for DEP
SWJOB 127 Integer Job Related E A  List:2 entries
0 = No
1 = Yes
AMTRECDIST 128 BCD*10.3 Dist. Recoverable Taxes E A C 
AMTEXPDIST 129 BCD*10.3 Dist. Exp. Separately Taxes E A C 
ERRBATCH 130 Long Error Batch E A C 
ERRENTRY 131 Long Error Entry E A C 
EMAIL 132 String*50 E-mail E A 
CTACPHONE 133 String*30 Contact's Phone E A P  Mask: (%-3C) %-3C-%-24C
CTACFAX 134 String*30 Contact's Fax E A P  Mask: (%-3C) %-3C-%-24C
CTACEMAIL 135 String*50 Contact's E-mail E A 
AMTPPD 136 BCD*10.3 Prepayment Amount E A C 
IDSTDINVC 137 String*16 Recurring Payable Code E A C  Mask: %-16C
DATEPRCS 138 Date Date Generated E A C 
AMTDSBWTAX 139 BCD*10.3 Discount Base With Tax E A C 
AMTDSBNTAX 140 BCD*10.3 Discount Base Without Tax E A C 
AMTDSCBASE 141 BCD*10.3 Discount Base E A 
SWRTGINVC 142 Integer Retainage Invoice E A  List:2 entries
0 = No
1 = Yes
SWRTG 143 Integer Has Retainage E A  List:2 entries
0 = No
1 = Yes
RTGAPPLYTO 144 String*22 Original Doc. No. E A  Mask: %-22C
RTGAMT 145 BCD*10.3 Retainage Amount E A 
RTGPERCENT 146 BCD*5.5 Percent Retained E A 
RTGDAYS 147 Integer Days Retained E A 
RTGDATEDUE 148 Date Retainage Due Date E A 
RTGTERMS 149 String*6 Retainage Terms Code E A  Mask: %-6N
SWRTGDDTOV 150 Integer Retainage Due Date Override E A  List:2 entries
0 = No
1 = Yes
SWRTGAMTOV 151 Integer Retainage Amount Override E A  List:2 entries
0 = No
1 = Yes
SWRTGRATE 152 Integer Retainage Exchange Rate E A  List:2 entries
0 = Use Original Document Exchange Rate
1 = Use Current Exchange Rate
SWTXBSECTL 153 Integer Tax Base Control E A  List:3 entries
0 = Enter
1 = Calculate
2 = Distribute
VALUES 154 Long Optional Fields E A C 
DETAILCNT 156 Long Number of Details E A C 
SRCEAPPL 157 String*2 Source Application E A  Mask: %-2A
SWHOLD 158 Integer On Hold E A  List:2 entries
0 = No
1 = Yes
ORIGEXIST 200 Integer Orig Exists E A C 
ORIGNAME 201 String*60 Orig Name E A C 
ORIGSTAT 202 Integer Orig Status E A C 
VENEXIST 210 Integer Vendor Exists E A C 
VENNAME 211 String*60 Vendor Name E A C 
VENDISTBY 212 Integer Vendor Dist Type E A C 
VENDISTCOD 213 String*6 Vendor Dist Code E A C 
VENACCT 214 String*45 Vendor Account E A C 
VENTXRPTSW 215 Integer Vendor Tax Report Type E A C 
RMTEXIST 220 Integer Remit Exists E A C 
RMTNAME 221 String*60 Remit Name E A C 
CLSEXIST 225 Integer 1099/CPRS Exists E A C 
CLSDESC 226 String*60 1099/CPRS Description E A C 
DSETEXIST 230 Integer Dist Set Exists E A C 
DSETDESC 231 String*60 Dist Set Description E A C 
DSETMETH 232 Integer Dist Set Method E A C 
TERMEXIST 235 Integer Term Exists E A C 
TERMMULPAY 236 Integer Term Use Payment Schedule E A C 
RTERMEXIST 240 Integer RTG Term Exists E A C 
RTERMDESC 241 String*60 RTG Term Description E A C 
PMLEV1NAME 245 String*30 PM Level 1 Name E A C 
PMLEV2NAME 246 String*30 PM Level 2 Name E A C 
PMLEV3NAME 247 String*30 PM Level 3 Name E A C 
TXGRPDESC 251 String*60 Tax Group Description E A C 
TXAU1DESC 260 String*60 Tax Auth 1 Description E A C 
TXAU2DESC 261 String*60 Tax Auth 2 Description E A C 
TXAU3DESC 262 String*60 Tax Auth 3 Description E A C 
TXAU4DESC 263 String*60 Tax Auth 4 Description E A C 
TXAU5DESC 264 String*60 Tax Auth 5 Description E A C 
APVERSION 270 String*3 A/P Version Created In E A C 
TAXVERSION 271 Long Tax State Version E A C 
SWTXRTGRPT 272 Integer Report Retainage Tax E A C 
CODECURNRC 273 String*3 Tax Reporting Currency Code E A  Mask: %-3N
SWTXCTLRC 274 Integer Tax Reporting Calculate Method E A  List:3 entries
0 = Enter
1 = Calculate
2 = Distribute
RATERC 275 BCD*8.7 Tax Reporting Exchange Rate E A 
RATETYPERC 276 String*2 Tax Reporting Rate Type E A  Mask: %-2N
RATEDATERC 277 Date Tax Reporting Rate Date E A 
RATEOPRC 278 Integer Tax Reporting Rate Operator E A C  List:2 entries
1 = Multiply
2 = Divide
SWRATERC 279 Integer Tax Reporting Rate Override E A C  List:2 entries
0 = No
1 = Yes
TXAMT1RC 280 BCD*10.3 Tax Reporting Amount 1 E A 
TXAMT2RC 281 BCD*10.3 Tax Reporting Amount 2 E A 
TXAMT3RC 282 BCD*10.3 Tax Reporting Amount 3 E A 
TXAMT4RC 283 BCD*10.3 Tax Reporting Amount 4 E A 
TXAMT5RC 284 BCD*10.3 Tax Reporting Amount 5 E A 
TXTOTRC 285 BCD*10.3 Tax Reporting Total E A C 
TXALLRC 286 BCD*10.3 Tax Reporting Allocated Tax E A C 
TXEXPRC 287 BCD*10.3 Tax Reporting Expensed Tax E A C 
TXRECRC 288 BCD*10.3 Tax Reporting Recoverable Tax E A C 
TXBSERT1TC 289 BCD*10.3 Retainage Tax Base 1 E A 
TXBSERT2TC 290 BCD*10.3 Retainage Tax Base 2 E A 
TXBSERT3TC 291 BCD*10.3 Retainage Tax Base 3 E A 
TXBSERT4TC 292 BCD*10.3 Retainage Tax Base 4 E A 
TXBSERT5TC 293 BCD*10.3 Retainage Tax Base 5 E A 
TXAMTRT1TC 294 BCD*10.3 Retainage Tax Amount 1 E A 
TXAMTRT2TC 295 BCD*10.3 Retainage Tax Amount 2 E A 
TXAMTRT3TC 296 BCD*10.3 Retainage Tax Amount 3 E A 
TXAMTRT4TC 297 BCD*10.3 Retainage Tax Amount 4 E A 
TXAMTRT5TC 298 BCD*10.3 Retainage Tax Amount 5 E A 
TXBSE1HC 299 BCD*10.3 Func. Tax Base 1 E A C 
TXBSE2HC 300 BCD*10.3 Func. Tax Base 2 E A C 
TXBSE3HC 301 BCD*10.3 Func. Tax Base 3 E A C 
TXBSE4HC 302 BCD*10.3 Func. Tax Base 4 E A C 
TXBSE5HC 303 BCD*10.3 Func. Tax Base 5 E A C 
TXAMT1HC 304 BCD*10.3 Func. Tax Amount 1 E A C 
TXAMT2HC 305 BCD*10.3 Func. Tax Amount 2 E A C 
TXAMT3HC 306 BCD*10.3 Func. Tax Amount 3 E A C 
TXAMT4HC 307 BCD*10.3 Func. Tax Amount 4 E A C 
TXAMT5HC 308 BCD*10.3 Func. Tax Amount 5 E A C 
AMTGROSHC 309 BCD*10.3 Func. Distribution w/ Tax Total E A C 
RTGAMTHC 310 BCD*10.3 Func. Retainage Amount E A C 
AMTDISCHC 311 BCD*10.3 Func. Discount Amount E A C 
AMT1099HC 312 BCD*10.3 Func. 1099/CPRS Amount E A C 
AMTPPDHC 313 BCD*10.3 Func. Prepayment Amount E A C 
AMTDUETC 314 BCD*10.3 Amount Due E A C 
AMTDUEHC 315 BCD*10.3 Func. Amount Due E A C 
TEXTVEN 316 String*60 Vendor Name E A 
TXTOTRTTC 317 BCD*10.3 Retainage Tax Total E A C 
TXTOTAMT1 318 BCD*10.3 Tax Amount 1 Total E A C 
TXTOTAMT2 319 BCD*10.3 Tax Amount 2 Total E A C 
TXTOTAMT3 320 BCD*10.3 Tax Amount 3 Total E A C 
TXTOTAMT4 321 BCD*10.3 Tax Amount 4 Total E A C 
TXTOTAMT5 322 BCD*10.3 Tax Amount 5 Total E A C 
RTGAMTDTL 323 BCD*10.3 Retainage Amount from Details E A C 
ENTEREDBY 324 String*8 Entered By E A C 
DATEBUS 325 Date Posting Date E A 
ASETDESC 326 String*60 Acct Set Description E A C 
IDN 327 String*30 Import Declaration Number E A 
AMTWHT1TC 328 BCD*10.3 Estimated Tax Withheld Amount 1 E A C 
AMTWHT2TC 329 BCD*10.3 Estimated Tax Withheld Amount 2 E A C 
AMTWHT3TC 330 BCD*10.3 Estimated Tax Withheld Amount 3 E A C 
AMTWHT4TC 331 BCD*10.3 Estimated Tax Withheld Amount 4 E A C 
AMTWHT5TC 332 BCD*10.3 Estimated Tax Withheld Amount 5 E A C 
AMTCXBS1TC 333 BCD*10.3 Reverse Charges Base 1 E A C 
AMTCXBS2TC 334 BCD*10.3 Reverse Charges Base 2 E A C 
AMTCXBS3TC 335 BCD*10.3 Reverse Charges Base 3 E A C 
AMTCXBS4TC 336 BCD*10.3 Reverse Charges Base 4 E A C 
AMTCXBS5TC 337 BCD*10.3 Reverse Charges Base 5 E A C 
AMTCXTX1TC 338 BCD*10.3 Reverse Charges Amount 1 E A 
AMTCXTX2TC 339 BCD*10.3 Reverse Charges Amount 2 E A 
AMTCXTX3TC 340 BCD*10.3 Reverse Charges Amount 3 E A 
AMTCXTX4TC 341 BCD*10.3 Reverse Charges Amount 4 E A 
AMTCXTX5TC 342 BCD*10.3 Reverse Charges Amount 5 E A 
AMTCXTXTCN 343 BCD*10.3 Negative Reverse Charges Amount E A C 
AMTTXNETCX 344 BCD*10.3 Net Vendor Tax Amount E A C 
AMTCXTXTC 345 BCD*10.3 Reverse Charges Amount E A C 
TXTOTWHT 346 BCD*10.3 Total Tax Withholding E A C 
AMTDUEWHT 347 BCD*10.3 Amount Due with Tax Withholding E A C 
AMTDUEWHDS 348 BCD*10.3 Amt Due Disc/Withhold Adjusted E A C 

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