Table: Recurring Payable Details

Table: APRPD
View: AP0065
Record Length: 827

Flags: A R 

Keys: 1

Title Flags Fields
Recurring Payable Detail Seq. IDVEND, IDRECURR, CNTLINE

Fields: 60

Field Type Title Presentation
IDVEND String*12 Vendor Number Mask: %-12C
IDRECURR String*16 Recurring Payable Code Mask: %-16C
CNTLINE BCD*3.0 Line Number
AUDTDATE Date
AUDTTIME Time
AUDTUSER String*8
AUDTORG String*6
IDDISTCODE String*6 Distribution Code Mask: %-6N
DESC String*60 Distribution Description
IDGLACCT String*45 G/L Account Mask: %-45C
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
AMTDIST BCD*10.3 Distributed Amount
AMTDISTNET BCD*10.3 Distributed Amount Before Taxes
AMTTAXINCL BCD*10.3 Dist. Tax included in Price
AMTTAXEXCL BCD*10.3 Dist. Tax excluded from Price
AMTTOTTAX BCD*10.3 Tax Amount 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
SWDISCABL Integer Discountable List:2 entries
0 = No
1 = Yes
VALUES Long Optional Fields
COMMENT String*250 Comment
CONTRACT String*16 Contract Code Mask: %-16C
PROJECT String*16 Project Code Mask: %-16N
CATEGORY String*16 Category Code Mask: %-16N
RESOURCE String*24 Project/Category Resource Mask: %-16N
COSTCLASS Integer Cost Class List:7 entries
0 =
1 = Labor
2 = Material
3 = Equipment
4 = Subcontractor
5 = Overhead
6 = Miscellaneous
BILLTYPE Integer Billing Type List:1 entries
0 =
IDITEM String*16 Item Number Mask: %-16C
UNITMEAS String*10 Unit of Measure Mask: %-10C
QTYINVC BCD*10.5 Quantity
AMTCOST BCD*10.6 Cost
BILLRATE BCD*10.6 Billing Rate
BILLCURN String*3 Billing Currency Mask: %-3N
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
AMTCXTX1TC BCD*10.3 Reverse Charge Amount 1
AMTCXTX2TC BCD*10.3 Reverse Charge Amount 2
AMTCXTX3TC BCD*10.3 Reverse Charge Amount 3
AMTCXTX4TC BCD*10.3 Reverse Charge Amount 4
AMTCXTX5TC BCD*10.3 Reverse Charge Amount 5

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