# View: Recurring Payables

RotoID: AP0064
Table: APRPH
Protocol: Header
DLL: APRPH

## Compositions: 2

RotoID | Tables | Title | DLL
--- | --- | --- | ---
AP0065 | APRPD | Recurring Payable Details | APRPD
AP0405 | APRPHO | Recurring Payable Optional Fields | APRPHO

## Keys: 3

Title | Fields
--- | ---
Vendor No./Recur. Payable Code | IDVEND, IDRECURR
Recur. Payable Code/Vendor No. | IDRECURR, IDVEND
Schedule/Schedule Link | SCHEDKEY, SCHEDLINK

## Fields: 79

Field | Index | Type | Title | Attributes | Presentation
--- | --- | --- | --- | --- | ---
IDVEND | 1 | String*12 | Vendor Number | E A K R | Mask: %-12C
IDRECURR | 2 | String*16 | Recurring Payable Code | E A K R | Mask: %-16C
DESC | 3 | String*60 | Description | E A |
SWACTV | 4 | Integer | Status | E A | List: 2 entries
0 | = | Inactive
1 | = | Active
DATEINACTV | 5 | Date | Inactive Date | A C |
DATELSTMTN | 6 | Date | Date Last Maintained | E A C |
DATEEFF | 7 | Date | Effective Date | E A |
EXPIRETYPE | 8 | Integer | Expiration Type | E A | List: 4 entries
0 | = | No Expiration
1 | = | Specific Date
2 | = | Maximum Amount
3 | = | Number of Invoices
DATEEXPIRE | 9 | Date | Expiration Date | E A |
MAXCOUNT | 10 | Integer | Maximum Number of Invoices | E A |
MAXAMT | 11 | BCD*10.3 | Maximum Total Invoice Amount | E A |
LASTDATE | 12 | Date | Last Invoice Date Posted | E A C |
LASTAMT | 13 | BCD*10.3 | Last Invoice Amount Posted | E A C |
YTDCOUNT | 14 | Integer | YTD Number of Invoices | E A C |
YTDAMT | 15 | BCD*10.3 | YTD Total Invoice Amount | E A C |
ORDERNBR | 16 | String*22 | Order Number | E A | Mask: %-22C
PONBR | 17 | String*22 | PO Number | E A | Mask: %-22C
INVCDESC | 18 | String*60 | Invoice Description | E A |
IDRMITTO | 19 | String*6 | Remit-To Location | E A | Mask: %-6N
CODECURN | 20 | String*3 | Currency Code | A C | Mask: %-3N
RATETYPE | 21 | String*2 | Rate Type | E A | Mask: %-2N
TERMSCODE | 22 | String*6 | Terms | E A | Mask: %-6N
DISTMETHOD | 23 | Integer | Reserved | E |
IDDISTSET | 24 | String*6 | Distribution Set | E A | Mask: %-6N
AMTDISTSET | 25 | BCD*10.3 | Distribution Amount | E A |
TAXGRP | 26 | String*12 | Tax Group | E A | Mask: %-12N
SWCALCTAX | 27 | Integer | Tax Amount Control | E A | List: 3 entries
0 | = | Enter
1 | = | Calculate
2 | = | Distribute
TAXAUTH1 | 36 | String*12 | Tax Authority 1 | A C |
TAXAUTH2 | 37 | String*12 | Tax Authority 2 | A C |
TAXAUTH3 | 38 | String*12 | Tax Authority 3 | A C |
TAXAUTH4 | 39 | String*12 | Tax Authority 4 | A C |
TAXAUTH5 | 40 | String*12 | Tax Authority 5 | A C |
TAXCLASS1 | 41 | Integer | Tax Class 1 | E A |
TAXCLASS2 | 42 | Integer | Tax Class 2 | E A |
TAXCLASS3 | 43 | Integer | Tax Class 3 | E A |
TAXCLASS4 | 44 | Integer | Tax Class 4 | E A |
TAXCLASS5 | 45 | Integer | Tax Class 5 | E A |
SWTAXINCL1 | 46 | Integer | Tax Inclusive 1 | E A | List: 2 entries
0 | = | No
1 | = | Yes
SWTAXINCL2 | 47 | Integer | Tax Inclusive 2 | E A | List: 2 entries
0 | = | No
1 | = | Yes
SWTAXINCL3 | 48 | Integer | Tax Inclusive 3 | E A | List: 2 entries
0 | = | No
1 | = | Yes
SWTAXINCL4 | 49 | Integer | Tax Inclusive 4 | E A | List: 2 entries
0 | = | No
1 | = | Yes
SWTAXINCL5 | 50 | Integer | Tax Inclusive 5 | E A | List: 2 entries
0 | = | No
1 | = | Yes
AMTTAX1 | 51 | BCD*10.3 | Tax Amount 1 | E A |
AMTTAX2 | 52 | BCD*10.3 | Tax Amount 2 | E A |
AMTTAX3 | 53 | BCD*10.3 | Tax Amount 3 | E A |
AMTTAX4 | 54 | BCD*10.3 | Tax Amount 4 | E A |
AMTTAX5 | 55 | BCD*10.3 | Tax Amount 5 | E A |
AMTDISTNET | 56 | BCD*10.3 | Distributed Total Before Taxes | E A C |
AMTDIST | 57 | BCD*10.3 | Invoice Subtotal | E A C |
CODE1099 | 58 | String*6 | 1099/CPRS Code | E A | Mask: %-6N
AMT1099 | 59 | BCD*10.3 | 1099/CPRS Amount | E A |
LASTLINE | 60 | BCD*3.0 | Last Detail Seq. No. | E A C |
SCHEDKEY | 61 | String*12 | Schedule | E A | Mask: %-12N
SCHEDLINK | 62 | BCD*10.0 | Schedule Link | E A C |
AMTTOTAL | 63 | BCD*10.3 | Document Total | A C |
BASETAX1 | 64 | BCD*10.3 | Tax Base 1 | E A |
BASETAX2 | 65 | BCD*10.3 | Tax Base 2 | E A |
BASETAX3 | 66 | BCD*10.3 | Tax Base 3 | E A |
BASETAX4 | 67 | BCD*10.3 | Tax Base 4 | E A |
BASETAX5 | 68 | BCD*10.3 | Tax Base 5 | E A |
SWTAXBL | 69 | Integer | Invoice Taxable | E A C | List: 2 entries
0 | = | No
1 | = | Yes
SWTXBSECTL | 70 | Integer | Tax Base Control | E A | List: 3 entries
0 | = | Enter
1 | = | Calculate
2 | = | Distribute
AMTTAXINCL | 76 | BCD*10.3 | Total Dist. Tax incl. in Price | E A C |
AMTTAXEXCL | 77 | BCD*10.3 | Total Dist. Tax excl. from Price | E A C |
AMTTAXTOT | 78 | BCD*10.3 | Total Tax Amount | E A C |
VALUES | 84 | Long | Optional Fields | E A C |
PROCESSCMD | 85 | Integer | Process Command | E A C | List: 3 entries
3 | = | Insert Optional Fields
0 | = | Create Distributions
6 | = | Generate Vendor Distribution
SWJOB | 86 | Integer | Job Related | E A | List: 2 entries
0 | = | No
1 | = | Yes
DATENEXT | 87 | Date | Next Scheduled Date | E A C |
DATELSTGEN | 88 | Date | Last Invoice Date Generated | E A C |
OPENCOUNT | 89 | Integer | Unposted Number of Invoices | E A C |
OPENAMOUNT | 90 | BCD*10.3 | Unposted Total Invoice Amount | E A C |
POSTCOUNT | 91 | Integer | Posted Number of Invoices | E A C |
POSTAMOUNT | 92 | BCD*10.3 | Posted Total Invoice Amount | E A C |
LSTIDINVC | 93 | String*22 | Last Invoice Number Posted | E A C |
LSTCNTBTCH | 94 | BCD*5.0 | Last Batch Number Posted | E A C |
LSTCNTITEM | 95 | BCD*4.0 | Last Entry Number Posted | E A C |
LSTPOSTSEQ | 96 | BCD*5.0 | Last Posting Sequence Number | E A C |
IDACCTSET | 97 | String*6 | Account Set | E A | Mask: %-6N

This page was generated on 2008-May-01

Copyright © 2001–2008 Sage Software, Inc. All rights reserved.