Table: Invoice Entries

Table: ZIAPIBH
View: ZI0017
Record length: 1360
Flags: A R 

Keys: 3


Title  Flags  Fields

Entry   CNTBTCH, CNTITEM
Source Comp, Entry   D M  SRCCOMPID, CNTBTCH, CNTITEM
Vendor, Document Number   D M  IDVEND, IDINVC

Fields: 107


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 ID  Mask: %-6N
TEXTTRX  Integer  Document Type  List: 3 entries
1=Invoice
2=Debit Note
3=Credit Note
IDTRX  Integer  Transaction Type   
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  Invoice Date as of   
FISCYR  String*4  Fiscal Year  Mask: %04D
FISCPERD  String*2  Fiscal Period  Mask: %02D
TERMCODE  String*6  Terms Code  Mask: %-6N
SWTERMOVRD  Integer  Terms Override  List: 2 entries
0=No
1=Yes
DATEDUE  Date  Due Date   
LASTLINE  BCD*3.0  Last Detail Seq. No.   
SWTAXBL  Integer  Taxable  List: 2 entries
0=No
1=Yes
SWCALCTX  Integer  Calculate Tax  List: 2 entries
0=No
1=Yes
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   
AMTDISTSET  BCD*10.3  Distribution Set Amount   
AMTTOTDIST  BCD*10.3  Distributed Total Before Tax   
TEXTRMIT  String*60  Remit-To 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   
NAMESTTE  String*30  State   
CODEPSTL  String*20  Postal Code/Zip   
CODECTRY  String*30  Country   
NAMECTAC  String*60  Contact Name   
TEXTPHON  String*30  Phone Number   
TEXTFAX  String*30  Fax Number   
CODEVNDGRP  String*6  Vendor Group  Mask: %-6N
TERMDESC  String*60  Terms Description   
IDDISTSET  String*6  Distribution Set  Mask: %-6N
AMTGROSTOT  BCD*10.3  Document Total Including Tax   
AMTDUE  BCD*10.3  Amount Due   
CREATEDIST  Integer  Create Distribution Entries   
AMTUNDISTR  BCD*10.3  Undistributed Amount   
SRCCOMPID  String*6  Source Company ID  Mask: %-6N
CURNCODE  String*3  Currency Code  Mask: %-3N
RATETYPE  String*2  Rate Type  Mask: %-2N
SWMANRTE  Integer  Rate Override  List: 2 entries
0=No
1=Yes
EXCHRATEHC  BCD*8.7  Exchange Rate   
ORIGRATEHC  BCD*8.7  Apply-To Exchange Rate   
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   
RATETAX1  BCD*8.7  Tax Rate 1   
RATETAX2  BCD*8.7  Tax Rate 2   
RATETAX3  BCD*8.7  Tax Rate 3   
RATETAX4  BCD*8.7  Tax Rate 4   
RATETAX5  BCD*8.7  Tax Rate 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   
AMTTAXDIST  BCD*10.3  Total Distributed Tax   
AMTALLOCTX  BCD*10.3  Distributed Allocated Tax   
AMTGROSDST  BCD*10.3  Distributed Total Including Tax   
DATERATE  Date  Rate Date   
AMTRECTAX  BCD*10.3  Distributed Recoverable Tax   
AMTTAXTOT  BCD*10.3  Total Tax Amount   
SWTAXINCL1  Integer  Tax Inclusive 1   
SWTAXINCL2  Integer  Tax Inclusive 2   
SWTAXINCL3  Integer  Tax Inclusive 3   
SWTAXINCL4  Integer  Tax Inclusive 4   
SWTAXINCL5  Integer  Tax Inclusive 5   
AMTEXPTAX  BCD*10.3  Distributed Expense Sep. Tax   
AMTTAXTOBE  BCD*10.3  Tax Amount to be Allocated   
TAXOUTBAL  BCD*10.3  Tax Amount out of Balance   
CODEOPER  Integer  Currency Code Operator   
SWPROCTAX  Integer  Process and Calculate Taxes   
ORATETYPE  String*2  Prev Rate Type   
OEXCHRTEHC  BCD*8.7  Prev Exchange Rate   
ODATERATE  Date  Prev Rate Date   
OCODEOPER  Integer  Prev Currency Code Operator   
FLD1  String*10  Reserved   
FLD2  Integer  Reserved   
USE1099  Boolean  Subject to 1099/CPRS Reporting   
AMT1099  BCD*10.3  1099/CPRS Amount   
ID1099CLAS  String*6  1099/CPRS Code  Mask: %-6N
VENDNAME  String*60  Vendor Name   

This page was generated on 2003-May-05

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