Table: Invoices

Table: APIBH
View: AP0021
Record length: 2023
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: 129


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  Tax Base Control  List: 3 entries
0=Enter
1=Calculate
2=Distribute
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  Last Detail Seq. No.   
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   
TEXTOPFL1  String*2  Optional Field 1   
TEXTOPFL2  String*3  Optional Field 2   
TEXTOPFL3  String*4  Optional Field 3   
TEXTOPFL4  String*12  Optional Field 4   
TEXTOPFL5  String*15  Optional Field 5   
TEXTOPFL6  String*30  Optional Field 6   
OPFLDATE  Date  Optional Date   
OPFLAMT  BCD*10.3  Optional Amount   
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   

This page was generated on 2003-May-05

Copyright © 2003 ACCPAC International, Inc. All rights reserved.