# 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: 231

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: 11 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
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 |
DATEBUS | 325 | Date | Posting Date | E A |
ASETDESC | 326 | String*60 | Acct Set Description | E A C |

This page was generated on 2008-May-01

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