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: 96

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
AMTWHT1TC 98 BCD*10.3 Estimated Tax Withheld Amount 1 E A C 
AMTWHT2TC 99 BCD*10.3 Estimated Tax Withheld Amount 2 E A C 
AMTWHT3TC 100 BCD*10.3 Estimated Tax Withheld Amount 3 E A C 
AMTWHT4TC 101 BCD*10.3 Estimated Tax Withheld Amount 4 E A C 
AMTWHT5TC 102 BCD*10.3 Estimated Tax Withheld Amount 5 E A C 
AMTCXBS1TC 103 BCD*10.3 Reverse Charges Base 1 E A C 
AMTCXBS2TC 104 BCD*10.3 Reverse Charges Base 2 E A C 
AMTCXBS3TC 105 BCD*10.3 Reverse Charges Base 3 E A C 
AMTCXBS4TC 106 BCD*10.3 Reverse Charges Base 4 E A C 
AMTCXBS5TC 107 BCD*10.3 Reverse Charges Base 5 E A C 
AMTCXTX1TC 108 BCD*10.3 Reverse Charges Amount 1 E A 
AMTCXTX2TC 109 BCD*10.3 Reverse Charges Amount 2 E A 
AMTCXTX3TC 110 BCD*10.3 Reverse Charges Amount 3 E A 
AMTCXTX4TC 111 BCD*10.3 Reverse Charges Amount 4 E A 
AMTCXTX5TC 112 BCD*10.3 Reverse Charges Amount 5 E A 
AMTCXTXTC 113 BCD*10.3 Reverse Charges Total E A C 
AMTWHTTOT 114 BCD*10.3 Estimated Tax Withheld Total E A C 

This page was generated on 2021-Nov-24

© 2021 Sage Software, Inc. All rights reserved. Reproduction of part or all of the contents in any form is prohibited unless for personal use. None of the content of this article may be copied or otherwise incorporated into any other document, publication or other work in any form (whether written, electronic or other format).

Sage Software, Inc. makes no warranties, representations or undertakings about any of the content of articles (including, without limitation, any as to the quality, accuracy, completeness or fitness for any particular purpose of such content).