# View: Documents

RotoID: AP0025
Table: APOBL
DLL: APOBL

## Compositions: 0

## Keys: 7

Title | Fields
--- | ---
Vendor Number/Document Number | IDVEND, IDINVC
Paid/Order Number | SWPAID, IDORDERNBR, IDVEND, IDINVC
Paid/PO Number | SWPAID, IDPONBR, IDVEND, IDINVC
Due Date | DATEINVCDU, IDVEND, IDINVC
Paid/Vendor Number | SWPAID, IDVEND, IDPREPAY
Vendor Number/Invoice Date | IDVEND, DATEINVC
Retainage Outstanding/Vendor Num | SWRTGOUT, IDVEND, IDINVC

## Fields: 130

Field | Index | Type | Title | Attributes | Presentation
--- | --- | --- | --- | --- | ---
IDVEND | 1 | String*12 | Vendor Number | E A K R | Mask: %-12C
IDINVC | 2 | String*22 | Document Number | E A K R | Mask: %-22C
IDRMIT | 3 | String*12 | Check Number | E A | Mask: %-12D
IDORDERNBR | 4 | String*22 | Order Number | E A | Mask: %-22C
IDPONBR | 5 | String*22 | PO Number | E A | Mask: %-22C
DATEINVCDU | 6 | Date | Due Date | E A |
IDRMITTO | 7 | String*6 | Remit-To Location | E A | Mask: %-6N
IDTRXTYPE | 8 | Integer | Transaction Type | E A | 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 | 9 | Integer | Document Type | E A | List: 6 entries
1 | = | Invoice
2 | = | Debit Note
3 | = | Credit Note
4 | = | Interest
10 | = | Prepayment
11 | = | Payment
DATEBTCH | 10 | Date | Batch Date | E A |
CNTBTCH | 11 | BCD*5.0 | Batch Number | E A |
CNTITEM | 12 | BCD*4.0 | Entry Number | E A |
IDVENDGRP | 13 | String*6 | Group Code | E A | Mask: %-6N
DESCINVC | 14 | String*60 | Doc. Description | E A |
DATEINVC | 15 | Date | Doc. Date | E A |
DATEASOF | 16 | Date | Invoice as-of Date | E A |
CODETERM | 17 | String*6 | Terms | E A | Mask: %-6N
DATEDISC | 18 | Date | Discount Date | E A |
CODECURN | 19 | String*3 | Currency Code | E A | Mask: %-3N
IDRATETYPE | 20 | String*2 | Rate Type | E A | Mask: %-2N
SWRATEOVRD | 21 | Integer | Rate Overridden | E A | List: 2 entries
0 | = | No
1 | = | Yes
EXCHRATEHC | 22 | BCD*8.7 | Exchange Rate | E A |
AMTINVCHC | 23 | BCD*10.3 | Func. Currency Invoice Amount | E A |
AMTDUEHC | 24 | BCD*10.3 | Func. Currency Amount Due | E A |
AMTTXBLHC | 25 | BCD*10.3 | Func. Currency Taxable Amount | E A |
AMTNONTXHC | 26 | BCD*10.3 | Func. Currency Non-Taxable Amt. | E A |
AMTTAXHC | 27 | BCD*10.3 | Func. Currency Tax Amount | E A |
AMTDISCHC | 28 | BCD*10.3 | Func. Currency Discount Amount | E A |
AMTINVCTC | 29 | BCD*10.3 | Vend. Currency Invoice Amount | E A |
AMTDUETC | 30 | BCD*10.3 | Vend. Currency Amount Due | E A |
AMTTXBLTC | 31 | BCD*10.3 | Vend. Currency Taxable Amount | E A |
AMTNONTXTC | 32 | BCD*10.3 | Vend. Currency Non-Taxable Amt. | E A |
AMTTAXTC | 33 | BCD*10.3 | Vend. Currency Tax Amount | E A |
AMTDISCTC | 34 | BCD*10.3 | Vend. Currency Discount Amount | E A |
SWPAID | 35 | Integer | Fully Paid | E A | List: 2 entries
0 | = | No
1 | = | Yes
DATELSTACT | 36 | Date | Last Activity Date | E A |
DATELSTSTM | 37 | Date | Last Statement Date | E A |
CNTTOTPAYM | 38 | BCD*3.0 | Number of Scheduled Payments | E A |
CNTLSTPAYM | 39 | BCD*3.0 | Reserved - Last Payment Number P | E |
CNTLSTPYST | 40 | BCD*3.0 | Payment Number on Last Statement | E A |
AMTREMIT | 41 | BCD*10.3 | Reserved - Payment Amount | E |
CNTLASTSCH | 42 | BCD*3.0 | Last Applied Payment Seq. No. | E A |
SWTAXOVRD | 43 | Integer | Tax Amount Control | E A | List: 3 entries
0 | = | Enter
1 | = | Calculate
2 | = | Distribute
CODETAX1 | 44 | String*12 | Tax Auth. 1 | E A | Mask: %-12N
CODETAX2 | 45 | String*12 | Tax Auth. 2 | E A | Mask: %-12N
CODETAX3 | 46 | String*12 | Tax Auth. 3 | E A | Mask: %-12N
CODETAX4 | 47 | String*12 | Tax Auth. 4 | E A | Mask: %-12N
CODETAX5 | 48 | String*12 | Tax Auth. 5 | E A | Mask: %-12N
AMTBASE1HC | 49 | BCD*10.3 | Func. Base Amount 1 | E A |
AMTBASE2HC | 50 | BCD*10.3 | Func. Base Amount 2 | E A |
AMTBASE3HC | 51 | BCD*10.3 | Func. Base Amount 3 | E A |
AMTBASE4HC | 52 | BCD*10.3 | Func. Base Amount 4 | E A |
AMTBASE5HC | 53 | BCD*10.3 | Func. Base Amount 5 | E A |
AMTTAX1HC | 54 | BCD*10.3 | Func. Tax Amount 1 | E A |
AMTTAX2HC | 55 | BCD*10.3 | Func. Tax Amount 2 | E A |
AMTTAX3HC | 56 | BCD*10.3 | Func. Tax Amount 3 | E A |
AMTTAX4HC | 57 | BCD*10.3 | Func. Tax Amount 4 | E A |
AMTTAX5HC | 58 | BCD*10.3 | Func. Tax Amount 5 | E A |
AMTBASE1TC | 59 | BCD*10.3 | Vend. Base Amount 1 | E A |
AMTBASE2TC | 60 | BCD*10.3 | Vend. Base Amount 2 | E A |
AMTBASE3TC | 61 | BCD*10.3 | Vend. Base Amount 3 | E A |
AMTBASE4TC | 62 | BCD*10.3 | Vend. Base Amount 4 | E A |
AMTBASE5TC | 63 | BCD*10.3 | Vend. Base Amount 5 | E A |
AMTTAX1TC | 64 | BCD*10.3 | Vend. Tax Amount 1 | E A |
AMTTAX2TC | 65 | BCD*10.3 | Vend. Tax Amount 2 | E A |
AMTTAX3TC | 66 | BCD*10.3 | Vend. Tax Amount 3 | E A |
AMTTAX4TC | 67 | BCD*10.3 | Vend. Tax Amount 4 | E A |
AMTTAX5TC | 68 | BCD*10.3 | Vend. Tax Amount 5 | E A |
FISCYR | 77 | String*4 | Fiscal Year | E A | Mask: %04D
FISCPER | 78 | String*2 | Fiscal Period | E A | Mask: %02D
IDPREPAY | 79 | String*22 | Prepay Invoice Number | E A | Mask: %-22C
DATEBUS | 80 | Date | Business Date | E A |
ID1099CLAS | 81 | String*6 | 1099/CPRS Code | E A | Mask: %-6N
AMT1099ORG | 82 | BCD*10.3 | 1099/CPRS Original Amount | E A |
AMT1099REM | 83 | BCD*10.3 | 1099/CPRS Remaining Amount | E A |
RATEDATE | 84 | Date | Rate Date | E A |
RATEOP | 85 | Integer | Rate Operator | E A |
YPLASTACT | 86 | String*6 | Last Activity Year/Period | E A |
IDBANK | 87 | String*8 | Bank Code | E A | Mask: %-8N
LONGSERIAL | 88 | Long | Check Serial Number | E A |
POSTSEQNCE | 89 | BCD*5.0 | Posting Sequence No. | E A |
SWJOB | 90 | Integer | Job Related | E A | List: 2 entries
0 | = | No
1 | = | Yes
SWRTG | 91 | Integer | Has Retainage | E A | List: 2 entries
0 | = | No
1 | = | Yes
SWRTGOUT | 92 | Integer | Retainage Outstanding | E A | List: 2 entries
0 | = | No
1 | = | Yes
RTGDATEDUE | 93 | Date | Date Retainage Due | E A |
RTGOAMTHC | 94 | BCD*10.3 | Func. Curr. Orig. Rtng. Amt. | E A |
RTGAMTHC | 95 | BCD*10.3 | Func. Curr. Retainage Amount | E A |
RTGOAMTTC | 96 | BCD*10.3 | Vend. Curr. Orig. Rtng. Amt. | E A |
RTGAMTTC | 97 | BCD*10.3 | Vend. Curr. Retainage Amount | E A |
RTGTERMS | 98 | String*6 | Retainage Terms Code | E A | Mask: %-6N
SWRTGRATE | 99 | Integer | Retainage Exchange Rate | E A | List: 2 entries
0 | = | Use Original Document Exchange Rate
1 | = | Use Current Exchange Rate
RTGAPPLYTO | 100 | String*22 | Original Doc. No. | E A | Mask: %-22C
VALUES | 101 | Long | Optional Fields | E A |
SRCEAPPL | 102 | String*2 | Source Application | E A | Mask: %-2A
SWPYSTTS | 103 | Integer | Payment Status | E A | List: 3 entries
0 | = | Normal
1 | = | On Hold
2 | = | Forced
DATEPYSTTS | 104 | Date | Date Payment Status Changed | E A |
APVERSION | 105 | String*3 | A/P Version Created In | E A |
TYPEBTCH | 106 | String*2 | Batch Type | E A | Mask: %-2N
CNTOBLJ | 107 | Long | Number of OBLJ Details | E A |
CODECURNRC | 108 | String*3 | Tax Reporting Currency Code | E A |
RATERC | 109 | BCD*8.7 | Tax Reporting Exchange Rate | E A |
RATETYPERC | 110 | String*2 | Tax Reporting Rate Type | E A |
RATEDATERC | 111 | Date | Tax Reporting Rate Date | E A |
RATEOPRC | 112 | Integer | Tax Reporting Rate Operator | E A |
SWRATERC | 113 | Integer | Tax Reporting Rate Override | E A | List: 2 entries
0 | = | No
1 | = | Yes
SWTXRTGRPT | 114 | Integer | Report Retainage Tax | E A |
CODETAXGRP | 115 | String*12 | Tax Group | E A |
TAXVERSION | 116 | Long | Tax State Version | E A |
SWTXBSECTL | 117 | Integer | Tax Base Calculate Method | E A |
SWTXCTLRC | 118 | Integer | Tax Reporting Calculate Method | E A |
TAXCLASS1 | 119 | Integer | Tax Class 1 | E A |
TAXCLASS2 | 120 | Integer | Tax Class 2 | E A |
TAXCLASS3 | 121 | Integer | Tax Class 3 | E A |
TAXCLASS4 | 122 | Integer | Tax Class 4 | E A |
TAXCLASS5 | 123 | Integer | Tax Class 5 | E A |
SWTAXINCL1 | 124 | Integer | Tax Included 1 | E A | List: 2 entries
0 | = | No
1 | = | Yes
SWTAXINCL2 | 125 | Integer | Tax Included 2 | E A | List: 2 entries
0 | = | No
1 | = | Yes
SWTAXINCL3 | 126 | Integer | Tax Included 3 | E A | List: 2 entries
0 | = | No
1 | = | Yes
SWTAXINCL4 | 127 | Integer | Tax Included 4 | E A | List: 2 entries
0 | = | No
1 | = | Yes
SWTAXINCL5 | 128 | Integer | Tax Included 5 | E A | List: 2 entries
0 | = | No
1 | = | Yes
TXBSERT1TC | 129 | BCD*10.3 | Tax Base 1 | E A |
TXBSERT2TC | 130 | BCD*10.3 | Tax Base 2 | E A |
TXBSERT3TC | 131 | BCD*10.3 | Tax Base 3 | E A |
TXBSERT4TC | 132 | BCD*10.3 | Tax Base 4 | E A |
TXBSERT5TC | 133 | BCD*10.3 | Tax Base 5 | E A |
TXAMTRT1TC | 134 | BCD*10.3 | Tax Amount 1 | E A |
TXAMTRT2TC | 135 | BCD*10.3 | Tax Amount 2 | E A |
TXAMTRT3TC | 136 | BCD*10.3 | Tax Amount 3 | E A |
TXAMTRT4TC | 137 | BCD*10.3 | Tax Amount 4 | E A |
TXAMTRT5TC | 138 | BCD*10.3 | Tax Amount 5 | E A |

This page was generated on 2006-Sep-07

Copyright © 2001–2005 Sage Accpac International, Inc.