# Table: Invoices

Table: APIBH
View: AP0021
Record length: 2052
Flags: A R

## Keys: 4

Title | Flags | Fields
--- | --- | ---
Batch Number/Entry Number |  | CNTBTCH, CNTITEM
Vendor Number/Document Number | D M | IDVEND, IDINVC
Vendor Number/Total Distributed | D M | IDVEND, AMTTOTDIST
Vendor Number/Invoice Date | D M | IDVEND, DATEINVC

## Fields: 141

Field | Type | Title | Presentation
--- | --- | --- | ---
CNTBTCH | BCD*5.0 | Batch Number |
CNTITEM | BCD*4.0 | Entry Number |
AUDTDATE | Date |  |
AUDTTIME | Time |  |
AUDTUSER | String*8 |  |
AUDTORG | String*6 |  |
IDVEND | String*12 | Vendor Number | Mask: %-12C
IDINVC | String*22 | Document Number | Mask: %-22C
IDRMITTO | String*6 | Remit-To Location | Mask: %-6N
TEXTTRX | Integer | Document Type | List: 4 entries
1 | = | Invoice
2 | = | Debit Note
3 | = | Credit Note
4 | = | Interest
IDTRX | Integer | Transaction Type | 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 | Integer | Reserved |
ORDRNBR | String*22 | Order Number | Mask: %-22C
PONBR | String*22 | PO Number | Mask: %-22C
INVCDESC | String*60 | Invoice Description |
SWPRTINVC | Integer | Reserved |
INVCAPPLTO | String*22 | Apply-to Document | Mask: %-22C
IDACCTSET | String*6 | Account Set | Mask: %-6N
DATEINVC | Date | Invoice Date |
DATEASOF | Date | As of Date |
FISCYR | String*4 | Fiscal Year | Mask: %04D
FISCPER | String*2 | Fiscal Period | Mask: %02D
CODECURN | String*3 | Currency Code | Mask: %-3N
RATETYPE | String*2 | Rate Type | Mask: %-2N
SWMANRTE | Integer | Rate Overridden | List: 2 entries
0 | = | No
1 | = | Yes
EXCHRATEHC | BCD*8.7 | Exchange Rate |
ORIGRATEHC | BCD*8.7 | Apply-to Exchange Rate |
TERMCODE | String*6 | Terms | Mask: %-6N
SWTERMOVRD | Integer | Terms Overridden | List: 2 entries
0 | = | No
1 | = | Yes
DATEDUE | Date | Due Date |
DATEDISC | Date | Discount Date |
PCTDISC | BCD*5.5 | Discount Percentage |
AMTDISCAVL | BCD*10.3 | Discount Amount Available |
LASTLINE | BCD*3.0 | Number of Details |
SWTAXBL | Integer | Taxable | List: 2 entries
0 | = | No
1 | = | Yes
SWCALCTX | Integer | Tax Amount Control | List: 3 entries
0 | = | Enter
1 | = | Calculate
2 | = | Distribute
CODETAXGRP | String*12 | Tax Group | Mask: %-12N
CODETAX1 | String*12 | Tax Authority 1 |
CODETAX2 | String*12 | Tax Authority 2 |
CODETAX3 | String*12 | Tax Authority 3 |
CODETAX4 | String*12 | Tax Authority 4 |
CODETAX5 | String*12 | Tax Authority 5 |
TAXCLASS1 | Integer | Tax Class 1 |
TAXCLASS2 | Integer | Tax Class 2 |
TAXCLASS3 | Integer | Tax Class 3 |
TAXCLASS4 | Integer | Tax Class 4 |
TAXCLASS5 | Integer | Tax Class 5 |
BASETAX1 | BCD*10.3 | Tax Base 1 |
BASETAX2 | BCD*10.3 | Tax Base 2 |
BASETAX3 | BCD*10.3 | Tax Base 3 |
BASETAX4 | BCD*10.3 | Tax Base 4 |
BASETAX5 | BCD*10.3 | Tax Base 5 |
AMTTAX1 | BCD*10.3 | Tax Amount 1 |
AMTTAX2 | BCD*10.3 | Tax Amount 2 |
AMTTAX3 | BCD*10.3 | Tax Amount 3 |
AMTTAX4 | BCD*10.3 | Tax Amount 4 |
AMTTAX5 | BCD*10.3 | Tax Amount 5 |
AMT1099 | BCD*10.3 | 1099/CPRS Amount |
AMTDISTSET | BCD*10.3 | Distribution Set Amount |
AMTTAXDIST | BCD*10.3 | Total Distributed Tax |
AMTINVCTOT | BCD*10.3 | Document Total Before Taxes |
AMTALLOCTX | BCD*10.3 | Distributed Allocated Taxes |
CNTPAYMSCH | BCD*3.0 | Number of Scheduled Payments |
AMTTOTDIST | BCD*10.3 | Distributed Total Before Taxes |
AMTGROSDST | BCD*10.3 | Distributed Total Including Tax |
IDPPD | String*22 | Prepayment Number |
TEXTRMIT | String*60 | Location Name |
TEXTSTE1 | String*60 | Address Line 1 |
TEXTSTE2 | String*60 | Address Line 2 |
TEXTSTE3 | String*60 | Address Line 3 |
TEXTSTE4 | String*60 | Address Line 4 |
NAMECITY | String*30 | City |
CODESTTE | String*30 | State/Prov. |
CODEPSTL | String*20 | Zip/Postal Code |
CODECTRY | String*30 | Country |
NAMECTAC | String*60 | Contact Name |
TEXTPHON | String*30 | Phone Number | Mask: (%-3C) %-3C-%-24C
TEXTFAX | String*30 | Fax Number | Mask: (%-3C) %-3C-%-24C
DATERATE | Date | Rate Date |
AMTRECTAX | BCD*10.3 | Recoverable Taxes |
CODEPAYPPD | BCD*3.0 | Reserved |
CODEVNDGRP | String*6 | Vendor Group Code | Mask: %-6N
TERMSDESC | String*60 | Terms Description |
IDDISTSET | String*6 | Distribution Set | Mask: %-6N
ID1099CLAS | String*6 | 1099/CPRS Code | Mask: %-6N
AMTTAXTOT | BCD*10.3 | Total Tax Amount |
AMTGROSTOT | BCD*10.3 | Document Total Including Tax |
SWTAXINCL1 | Integer | Tax Inclusive 1 | List: 2 entries
0 | = | No
1 | = | Yes
SWTAXINCL2 | Integer | Tax Inclusive 2 | List: 2 entries
0 | = | No
1 | = | Yes
SWTAXINCL3 | Integer | Tax Inclusive 3 | List: 2 entries
0 | = | No
1 | = | Yes
SWTAXINCL4 | Integer | Tax Inclusive 4 | List: 2 entries
0 | = | No
1 | = | Yes
SWTAXINCL5 | Integer | Tax Inclusive 5 | List: 2 entries
0 | = | No
1 | = | Yes
AMTEXPTAX | BCD*10.3 | Expensed Separately Taxes |
AMTAXTOBE | BCD*10.3 | Tax Amount to be Allocated |
TAXOUTBAL | BCD*10.3 | Tax Amount out of Balance |
CODEOPER | Integer | Currency Code Operator | List: 2 entries
1 | = | Multiply
2 | = | Divide
ACCTREC1 | String*45 | Recoverable Account 1 | Mask: %-45C
ACCTREC2 | String*45 | Recoverable Account 2 | Mask: %-45C
ACCTREC3 | String*45 | Recoverable Account 3 | Mask: %-45C
ACCTREC4 | String*45 | Recoverable Account 4 | Mask: %-45C
ACCTREC5 | String*45 | Recoverable Account 5 | Mask: %-45C
ACCTEXP1 | String*45 | Expense Sep. Account 1 | Mask: %-45C
ACCTEXP2 | String*45 | Expense Sep. Account 2 | Mask: %-45C
ACCTEXP3 | String*45 | Expense Sep. Account 3 | Mask: %-45C
ACCTEXP4 | String*45 | Expense Sep. Account 4 | Mask: %-45C
ACCTEXP5 | String*45 | Expense Sep. Account 5 | Mask: %-45C
DRILLAPP | String*2 | Drill Down Application Source | Mask: %-2A
DRILLTYPE | Integer | Drill Down Type |
DRILLDWNLK | BCD*10.0 | Drill Down Link Number |
SWJOB | Integer | Job Related | List: 2 entries
0 | = | No
1 | = | Yes
AMTRECDIST | BCD*10.3 | Dist. Recoverable Taxes |
AMTEXPDIST | BCD*10.3 | Dist. Exp. Separately Taxes |
ERRBATCH | Long | Error Batch |
ERRENTRY | Long | Error Entry |
EMAIL | String*50 | E-mail |
CTACPHONE | String*30 | Contact's Phone | Mask: (%-3C) %-3C-%-24C
CTACFAX | String*30 | Contact's Fax | Mask: (%-3C) %-3C-%-24C
CTACEMAIL | String*50 | Contact's E-mail |
AMTPPD | BCD*10.3 | Prepayment Amount |
IDSTDINVC | String*16 | Recurring Payable Code | Mask: %-16C
DATEPRCS | Date | Date Generated |
AMTDSBWTAX | BCD*10.3 | Discount Base With Tax |
AMTDSBNTAX | BCD*10.3 | Discount Base Without Tax |
AMTDSCBASE | BCD*10.3 | Discount Base |
SWRTGINVC | Integer | Retainage Invoice | List: 2 entries
0 | = | No
1 | = | Yes
RTGAPPLYTO | String*22 | Original Doc. No. | Mask: %-22C
SWRTG | Integer | Has Retainage | List: 2 entries
0 | = | No
1 | = | Yes
RTGAMT | BCD*10.3 | Retainage Amount |
RTGPERCENT | BCD*5.5 | Percent Retained |
RTGDAYS | Integer | Days Retained |
RTGDATEDUE | Date | Retainage Due Date |
RTGTERMS | String*6 | Retainage Terms Code | Mask: %-6N
SWRTGDDTOV | Integer | Retainage Due Date Override | List: 2 entries
0 | = | No
1 | = | Yes
SWRTGAMTOV | Integer | Retainage Amount Override | List: 2 entries
0 | = | No
1 | = | Yes
SWRTGRATE | Integer | Retainage Exchange Rate | List: 2 entries
0 | = | Use Original Document Exchange Rate
1 | = | Use Current Exchange Rate
SWTXBSECTL | Integer | Tax Base Control | List: 3 entries
0 | = | Enter
1 | = | Calculate
2 | = | Distribute
VALUES | Long | Optional Fields |
ORIGCOMP | String*6 | Originator | Mask: %-6N
DETAILCNT | Long | Number of Details |
SRCEAPPL | String*2 | Source Application | Mask: %-2A
SWHOLD | Integer | On Hold | List: 2 entries
0 | = | No
1 | = | Yes

This page was generated on 2004-Oct-28

Copyright © 2000–2004 ACCPAC International, Inc. All rights reserved.