# Table: Open Documents

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

## Keys: 7

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
Retainage Outstanding/Vendor Num | D M | SWRTGOUT, IDVEND, IDINVC

## Fields: 100

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: 7 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
51 | = | Payment - Posted
TXTTRXTYPE | Integer | Document Type | List: 6 entries
1 | = | Invoice
2 | = | Debit Note
3 | = | Credit Note
4 | = | Interest
10 | = | Prepayment
11 | = | Payment
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 | Reserved - Last Payment Number P |
CNTLSTPYST | BCD*3.0 | Payment Number on Last Statement |
AMTREMIT | BCD*10.3 | Reserved - Payment Amount |
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 |
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
SWRTG | Integer | Has Retainage | List: 2 entries
0 | = | No
1 | = | Yes
SWRTGOUT | Integer | Retainage Outstanding | List: 2 entries
0 | = | No
1 | = | Yes
RTGDATEDUE | Date | Date Retainage Due |
RTGOAMTHC | BCD*10.3 | Func. Curr. Orig. Rtng. Amt. |
RTGAMTHC | BCD*10.3 | Func. Curr. Retainage Amount |
RTGOAMTTC | BCD*10.3 | Vend. Curr. Orig. Rtng. Amt. |
RTGAMTTC | BCD*10.3 | Vend. Curr. Retainage Amount |
RTGTERMS | String*6 | Retainage Terms Code | Mask: %-6N
SWRTGRATE | Integer | Retainage Exchange Rate | List: 2 entries
0 | = | Use Original Document Exchange Rate
1 | = | Use Current Exchange Rate
RTGAPPLYTO | String*22 | Original Doc. No. | Mask: %-22C
VALUES | Long | Optional Fields |
SRCEAPPL | String*2 | Source Application | Mask: %-2A
SWPYSTTS | Integer | Payment Status | List: 3 entries
0 | = | Normal
1 | = | On Hold
2 | = | Forced
DATEPYSTTS | Date | Date Payment Status Changed |

This page was generated on 2004-Oct-28

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