Table: Open Documents

Table: APOBL
View: AP0025
Record length: 833
Flags: A R 

Keys: 6


Title  Flags  Fields

Vendor Number/Document Number   IDVEND, IDINVC
Paid Indicator/Sales Order Num.   D M  SWPAID, IDORDERNBR, IDVEND, IDINVC
Paid Indicator/PO Number   D M  SWPAID, IDPONBR, IDVEND, IDINVC
Due Date   D M  DATEINVCDU, IDVEND, IDINVC
Paid Indicator/Vendor Number   D M  SWPAID, IDVEND, IDPREPAY
Vendor Number/Invoice Date   D M  IDVEND, DATEINVC

Fields: 94


Field  Type  Title  Presentation 

IDVEND  String*12  Vendor Number  Mask: %-12C
IDINVC  String*22  Document Number  Mask: %-22C
AUDTDATE  Date     
AUDTTIME  Time     
AUDTUSER  String*8     
AUDTORG  String*6     
IDRMIT  String*12  Check number  Mask: %-12D
IDORDERNBR  String*22  Sales Order Number  Mask: %-22C
IDPONBR  String*22  PO Number  Mask: %-22C
DATEINVCDU  Date  Due Date   
IDRMITTO  String*6  Remit-To Location  Mask: %-6N
IDTRXTYPE  Integer  Transaction Type  List: 6 entries
12=Invoice - Summary Entered
13=Invoice - Recurring Charge
22=Debit Note - Summary Entered
32=Credit Note - Summary Entered
40=Interest Charge
50=Prepayment - Posted
TXTTRXTYPE  Integer  Document Type  List: 5 entries
1=Invoice
2=Debit Note
3=Credit Note
4=Interest
10=Prepayment
DATEBTCH  Date  Batch Date   
CNTBTCH  BCD*5.0  Batch Number   
CNTITEM  BCD*4.0  Entry Number   
IDVENDGRP  String*6  Group Code  Mask: %-6N
DESCINVC  String*60  Doc. Description   
DATEINVC  Date  Doc. Date   
DATEASOF  Date  Invoice as-of Date   
CODETERM  String*6  Terms  Mask: %-6N
DATEDISC  Date  Discount Date   
CODECURN  String*3  Currency Code  Mask: %-3N
IDRATETYPE  String*2  Rate Type  Mask: %-2N
SWRATEOVRD  Integer  Rate Overridden  List: 2 entries
0=No
1=Yes
EXCHRATEHC  BCD*8.7  Exchange Rate   
AMTINVCHC  BCD*10.3  Func. Currency Invoice Amount   
AMTDUEHC  BCD*10.3  Func. Currency Amount Due   
AMTTXBLHC  BCD*10.3  Func. Currency Taxable Amount   
AMTNONTXHC  BCD*10.3  Func. Currency Non-Taxable Amt.   
AMTTAXHC  BCD*10.3  Func. Currency Tax Amount   
AMTDISCHC  BCD*10.3  Func. Currency Discount Amount   
AMTINVCTC  BCD*10.3  Vend. Currency Invoice Amount   
AMTDUETC  BCD*10.3  Vend. Currency Amount Due   
AMTTXBLTC  BCD*10.3  Vend. Currency Taxable Amount   
AMTNONTXTC  BCD*10.3  Vend. Currency Non-Taxable Amt.   
AMTTAXTC  BCD*10.3  Vend. Currency Tax Amount   
AMTDISCTC  BCD*10.3  Vend. Currency Discount Amount   
SWPAID  Integer  Fully Paid  List: 2 entries
0=No
1=Yes
DATELSTACT  Date  Last Activity Date   
DATELSTSTM  Date  Last Statement Date   
CNTTOTPAYM  BCD*3.0  Number of Scheduled Payments   
CNTLSTPAYM  BCD*3.0  Last Payment Number Paid   
CNTLSTPYST  BCD*3.0  Payment Number on Last Statement   
AMTREMIT  BCD*10.3  Payment Amount Applied   
CNTLASTSCH  BCD*3.0  Last Applied Payment Seq. No.   
SWTAXOVRD  Integer  Tax Amount Control  List: 3 entries
0=Enter
1=Calculate
2=Distribute
CODETAX1  String*12  Tax Auth. 1  Mask: %-12N
CODETAX2  String*12  Tax Auth. 2  Mask: %-12N
CODETAX3  String*12  Tax Auth. 3  Mask: %-12N
CODETAX4  String*12  Tax Auth. 4  Mask: %-12N
CODETAX5  String*12  Tax Auth. 5  Mask: %-12N
AMTBASE1HC  BCD*10.3  Func. Base Amount 1   
AMTBASE2HC  BCD*10.3  Func. Base Amount 2   
AMTBASE3HC  BCD*10.3  Func. Base Amount 3   
AMTBASE4HC  BCD*10.3  Func. Base Amount 4   
AMTBASE5HC  BCD*10.3  Func. Base Amount 5   
AMTTAX1HC  BCD*10.3  Func. Tax Amount 1   
AMTTAX2HC  BCD*10.3  Func. Tax Amount 2   
AMTTAX3HC  BCD*10.3  Func. Tax Amount 3   
AMTTAX4HC  BCD*10.3  Func. Tax Amount 4   
AMTTAX5HC  BCD*10.3  Func. Tax Amount 5   
AMTBASE1TC  BCD*10.3  Vend. Base Amount 1   
AMTBASE2TC  BCD*10.3  Vend. Base Amount 2   
AMTBASE3TC  BCD*10.3  Vend. Base Amount 3   
AMTBASE4TC  BCD*10.3  Vend. Base Amount 4   
AMTBASE5TC  BCD*10.3  Vend. Base Amount 5   
AMTTAX1TC  BCD*10.3  Vend. Tax Amount 1   
AMTTAX2TC  BCD*10.3  Vend. Tax Amount 2   
AMTTAX3TC  BCD*10.3  Vend. Tax Amount 3   
AMTTAX4TC  BCD*10.3  Vend. Tax Amount 4   
AMTTAX5TC  BCD*10.3  Vend. 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   
DATEOPFL  Date  Optional Date Field   
AMTOPFL  BCD*10.3  Optional Amount Field   
FISCYR  String*4  Fiscal Year  Mask: %04D
FISCPER  String*2  Fiscal Period  Mask: %02D
IDPREPAY  String*22  Prepay Invoice Number  Mask: %-22C
DATEBUS  Date  Business Date   
ID1099CLAS  String*6  1099/CPRS Code  Mask: %-6N
AMT1099ORG  BCD*10.3  1099/CPRS Original Amount   
AMT1099REM  BCD*10.3  1099/CPRS Remaining Amount   
RATEDATE  Date  Rate Date   
RATEOP  Integer  Rate Operator   
YPLASTACT  String*6  Last Activity Year/Period   
IDBANK  String*8  Bank Code  Mask: %-8N
LONGSERIAL  Long  Check Serial Number   
POSTSEQNCE  BCD*5.0  Posting Sequence No.   
SWJOB  Integer  Job Related  List: 2 entries
0=No
1=Yes

This page was generated on 2003-May-05

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