Table: Recurring Payables

Table: APRPH
View: AP0064
Record Length: 845

Flags: A R 

Keys: 3

Title Flags Fields
Vendor No./Recur. Payable Code IDVEND, IDRECURR
Recur. Payable Code/Vendor No. IDRECURR, IDVEND
Schedule/Schedule Link D M  SCHEDKEY, SCHEDLINK

Fields: 97

Field Type Title Presentation
IDVEND String*12 Vendor Number Mask: %-12C
IDRECURR String*16 Recurring Payable Code Mask: %-16C
AUDTDATE Date
AUDTTIME Time
AUDTUSER String*8
AUDTORG String*6
DESC String*60 Description
SWACTV Integer Status List:2 entries
0 = Inactive
1 = Active
DATEINACTV Date Inactive Date
DATELSTMTN Date Date Last Maintained
DATEEFF Date Effective Date
EXPIRETYPE Integer Expiration Type List:4 entries
0 = No Expiration
1 = Specific Date
2 = Maximum Amount
3 = Number of Invoices
DATEEXPIRE Date Expiration Date
MAXCOUNT Integer Maximum Number of Invoices
MAXAMT BCD*10.3 Maximum Total Invoice Amount
LASTDATE Date Last Invoice Date Posted
LASTAMT BCD*10.3 Last Invoice Amount Posted
YTDCOUNT Integer YTD Number of Invoices
YTDAMT BCD*10.3 YTD Total Invoice Amount
ORDERNBR String*22 Order Number Mask: %-22C
PONBR String*22 PO Number Mask: %-22C
INVCDESC String*60 Invoice Description
IDRMITTO String*6 Remit-To Location Mask: %-6N
CODECURN String*3 Currency Code Mask: %-3N
RATETYPE String*2 Rate Type Mask: %-2N
TERMSCODE String*6 Terms Mask: %-6N
DISTMETHOD Integer Reserved
IDDISTSET String*6 Distribution Set Mask: %-6N
AMTDISTSET BCD*10.3 Distribution Amount
TAXGRP String*12 Tax Group Mask: %-12N
SWCALCTAX Integer Tax Amount Control List:3 entries
0 = Enter
1 = Calculate
2 = Distribute
TAXAUTH1 String*12 Tax Authority 1
TAXAUTH2 String*12 Tax Authority 2
TAXAUTH3 String*12 Tax Authority 3
TAXAUTH4 String*12 Tax Authority 4
TAXAUTH5 String*12 Tax Authority 5
TAXCLASS1 Integer Tax Class 1
TAXCLASS2 Integer Tax Class 2
TAXCLASS3 Integer Tax Class 3
TAXCLASS4 Integer Tax Class 4
TAXCLASS5 Integer Tax Class 5
SWTAXINCL1 Integer Tax Inclusive 1 List:2 entries
0 = No
1 = Yes
SWTAXINCL2 Integer Tax Inclusive 2 List:2 entries
0 = No
1 = Yes
SWTAXINCL3 Integer Tax Inclusive 3 List:2 entries
0 = No
1 = Yes
SWTAXINCL4 Integer Tax Inclusive 4 List:2 entries
0 = No
1 = Yes
SWTAXINCL5 Integer Tax Inclusive 5 List:2 entries
0 = No
1 = Yes
AMTTAX1 BCD*10.3 Tax Amount 1
AMTTAX2 BCD*10.3 Tax Amount 2
AMTTAX3 BCD*10.3 Tax Amount 3
AMTTAX4 BCD*10.3 Tax Amount 4
AMTTAX5 BCD*10.3 Tax Amount 5
AMTDISTNET BCD*10.3 Distributed Total Before Taxes
AMTDIST BCD*10.3 Invoice Subtotal
CODE1099 String*6 1099/CPRS Code Mask: %-6N
AMT1099 BCD*10.3 1099/CPRS Amount
LASTLINE BCD*3.0 Last Detail Seq. No.
SCHEDKEY String*12 Schedule Mask: %-12N
SCHEDLINK BCD*10.0 Schedule Link
AMTTOTAL BCD*10.3 Document Total
BASETAX1 BCD*10.3 Tax Base 1
BASETAX2 BCD*10.3 Tax Base 2
BASETAX3 BCD*10.3 Tax Base 3
BASETAX4 BCD*10.3 Tax Base 4
BASETAX5 BCD*10.3 Tax Base 5
SWTAXBL Integer Invoice Taxable List:2 entries
0 = No
1 = Yes
SWTXBSECTL Integer Tax Base Control List:3 entries
0 = Enter
1 = Calculate
2 = Distribute
AMTTAXINCL BCD*10.3 Total Dist. Tax incl. in Price
AMTTAXEXCL BCD*10.3 Total Dist. Tax excl. from Price
AMTTAXTOT BCD*10.3 Total Tax Amount
VALUES Long Optional Fields
SWJOB Integer Job Related List:2 entries
0 = No
1 = Yes
DATENEXT Date Next Scheduled Date
DATELSTGEN Date Last Invoice Date Generated
OPENCOUNT Integer Unposted Number of Invoices
OPENAMOUNT BCD*10.3 Unposted Total Invoice Amount
POSTCOUNT Integer Posted Number of Invoices
POSTAMOUNT BCD*10.3 Posted Total Invoice Amount
LSTIDINVC String*22 Last Invoice Number Posted
LSTCNTBTCH BCD*5.0 Last Batch Number Posted
LSTCNTITEM BCD*4.0 Last Entry Number Posted
LSTPOSTSEQ BCD*5.0 Last Posting Sequence Number
IDACCTSET String*6 Account Set Mask: %-6N
AMTWHT1TC BCD*10.3 Estimated Tax Withheld Amount 1
AMTWHT2TC BCD*10.3 Estimated Tax Withheld Amount 2
AMTWHT3TC BCD*10.3 Estimated Tax Withheld Amount 3
AMTWHT4TC BCD*10.3 Estimated Tax Withheld Amount 4
AMTWHT5TC BCD*10.3 Estimated Tax Withheld Amount 5
AMTCXBS1TC BCD*10.3 Reverse Charges Base 1
AMTCXBS2TC BCD*10.3 Reverse Charges Base 2
AMTCXBS3TC BCD*10.3 Reverse Charges Base 3
AMTCXBS4TC BCD*10.3 Reverse Charges Base 4
AMTCXBS5TC BCD*10.3 Reverse Charges Base 5
AMTCXTX1TC BCD*10.3 Reverse Charges Amount 1
AMTCXTX2TC BCD*10.3 Reverse Charges Amount 2
AMTCXTX3TC BCD*10.3 Reverse Charges Amount 3
AMTCXTX4TC BCD*10.3 Reverse Charges Amount 4
AMTCXTX5TC BCD*10.3 Reverse Charges Amount 5

This page was generated on 2022-Aug-18

© 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).