View: Applied Payments

RotoID: AP0033
Table: APTCP
Protocol: Detail, Sequenced revisions, Key auto generate
DLL:APTCP

Compositions: 3

RotoID Tables Title DLL
AP0031 APTCR Payments/Adjustments APTCR
AP0034 APTCU Adjustment G/L Distributions APTCU
AP0048 APPOOP Create Open Document List APPOOP

Keys: 3

Title Fields
Batch Number / Entry Number BATCHTYPE, CNTBTCH, CNTRMIT, CNTLINE
Vendor Number / Document Number IDVEND, IDINVC, CNTPAYM
Batch Type / Batch Number BATCHTYPE, CNTBTCH, CNTRMIT, IDINVC, CNTPAYM

Fields: 88

Field Index Type Title Attributes Presentation
BATCHTYPE 1 String*2 Batch Type E A K R  Mask: %-2N
CNTBTCH 2 BCD*5.0 Batch Number E A K R 
CNTRMIT 3 BCD*4.0 Entry Number E A K R 
CNTLINE 4 BCD*3.0 Line Number E A K R 
IDVEND 5 String*12 Vendor Number E A C  Mask: %-12C
IDINVC 6 String*22 Document Number E A  Mask: %-22C
CNTPAYM 7 BCD*3.0 Payment Number E A 
TRXTYPE 8 Integer Transaction Type E A  List:3 entries
51 = Payment - Posted
57 = Prepayment - Posted
81 = Adjustment - Posted
PYMTRESL 9 String*2 Payment Resolution E A  Mask: %-2N
AMTPAYM 10 BCD*10.3 Payment Amount E A 
AMTERNDISC 11 BCD*10.3 Discount Amount Taken E A 
CNTLASTSEQ 12 BCD*3.0 Next Adj. Seq. No. E A C 
AMTADJTOT 13 BCD*10.3 Adjustments Total E A C 
CNTADJ 14 BCD*5.0 Generated Adjustment Number E A C 
TEXTADJ 15 String*60 Description E A 
GLREF 16 String*60 Reference E A 
IDPPD 17 String*22 Generated PP No. E A C  Mask: %-22C
IDDOCMTCH 18 String*22 PP Matching Doc. No. E A  Mask: %-22C
CDAPPLYTO 19 Integer PP Matching Doc. Type E A P  List:4 entries
1 = (None)
2 = Document Number
3 = PO Number
4 = Order Number
DATEACTVPP 20 Date Activation Date E A 
OBSPAYMAMT 21 BCD*10.3 Document Amount Due E A C 
OBSDISCAMT 22 BCD*10.3 Discount Amount Available E A C 
OBSNETBAL 23 BCD*10.3 Document Net Balance E A C 
PNDPAYTOT 24 BCD*10.3 Pending Payment Amount E A C 
PNDDSCTOT 25 BCD*10.3 Pending Discount Amount E A C 
PNDADJTOT 26 BCD*10.3 Pending Adjustment Amount E A C 
ADJTOTDBTC 27 BCD*10.3 Adj. Debit Amt. - Vend. Curr E A C 
ADJTOTCRTC 28 BCD*10.3 Adj. Credit Amt. - Vend. Curr E A C 
SWJOB 29 Integer Job Related E A C  List:2 entries
0 = No
1 = Yes
AMTPAYMTOT 30 BCD*10.3 Job Total Payment Amount E A C 
AMTDISCTOT 31 BCD*10.3 Job Total Discount Amount E A C 
APPLYMETH 32 Integer Job Apply Method E A  List:2 entries
0 = Prorate by Amount
1 = Top Down
RTGTOTDBTC 33 BCD*10.3 Rtg. Debit Amt. - Vend. Curr E A C 
RTGTOTCRTC 34 BCD*10.3 Rtg. Credit Amt. - Vend. Curr E A C 
RTGAMT 35 BCD*10.3 Retainage Amount E A 
RTGDATEDUE 36 Date Retainage Due Date E A 
RTGTERMS 37 String*6 Retainage Terms Code E A  Mask: %-6N
SWRTGRATE 38 Integer Retainage Exchange Rate E A  List:2 entries
0 = Use Original Document Exchange Rate
1 = Use Current Exchange Rate
PROCESSCMD 39 Integer Process Command E A C  List:8 entries
0 = Clear
1 = Allocate
10 = Apply Invoice Document
11 = Warn Invoice Document
12 = Apply & Warn Invoice Document
13 = Apply Matching Document
14 = Warn Matching Document
15 = Apply & Warn Matching Document
UNAPLPAYM 40 BCD*10.3 Unapplied Job Payment Amount E A C 
UNAPLDISC 41 BCD*10.3 Unapplied Job Discount Amount E A C 
CODECURN 42 String*3 Vendor Currency Code E C 
DATERMIT 43 Date Payment Date E C 
DOCTYPE 44 Integer Document Type E A 
RMITTYPE 45 Integer Payment Type E A C  List:5 entries
1 = Payment
2 = Prepayment
3 = Apply Document
4 = Misc. Payment
5 = Adjustment
SWRTG 46 Integer Has Retainage E A C  List:2 entries
0 = No
1 = Yes
RTGBAL 47 BCD*10.3 Retainage Balance E A C 
RTGAPPLYTO 48 String*22 Original Doc. No. E A C  Mask: %-22C
AMTADJNET 49 BCD*10.3 Payables Adjustment Total E A C 
EXCHRATEHC 50 BCD*8.7 Original Exchange Rate E A C 
DATEINVC 51 Date Doc. Date E A C 
AMTPAYMHC 52 BCD*10.3 Func. Payment Amount E A C 
AMTDISCHC 53 BCD*10.3 Func. Discount Amount E A C 
AMTADJHC 54 BCD*10.3 Func. Adjustments Total E A C 
RTGAMTHC 55 BCD*10.3 Func. Retainage Amount E A C 
APVERSION 56 String*3 Doc. Version Created In E A C 
AMTWHD1TC 57 BCD*10.3 Vend. Tax Withheld Amount 1 E A 
AMTWHD2TC 58 BCD*10.3 Vend. Tax Withheld Amount 2 E A 
AMTWHD3TC 59 BCD*10.3 Vend. Tax Withheld Amount 3 E A 
AMTWHD4TC 60 BCD*10.3 Vend. Tax Withheld Amount 4 E A 
AMTWHD5TC 61 BCD*10.3 Vend. Tax Withheld Amount 5 E A 
AMTWHD1HC 62 BCD*10.3 Func. Tax Withheld Amount 1 E A C 
AMTWHD2HC 63 BCD*10.3 Func. Tax Withheld Amount 2 E A C 
AMTWHD3HC 64 BCD*10.3 Func. Tax Withheld Amount 3 E A C 
AMTWHD4HC 65 BCD*10.3 Func. Tax Withheld Amount 4 E A C 
AMTWHD5HC 66 BCD*10.3 Func. Tax Withheld Amount 5 E A C 
AMTWHD1DT 67 BCD*10.3 Job Total Tax Withheld Amt 1 E A C 
AMTWHD2DT 68 BCD*10.3 Job Total Tax Withheld Amt 2 E A C 
AMTWHD3DT 69 BCD*10.3 Job Total Tax Withheld Amt 3 E A C 
AMTWHD4DT 70 BCD*10.3 Job Total Tax Withheld Amt 4 E A C 
AMTWHD5DT 71 BCD*10.3 Job Total Tax Withheld Amt 5 E A C 
CODETAX1 72 String*12 Document Tax Authority 1 E A C 
CODETAX2 73 String*12 Document Tax Authority 2 E A C 
CODETAX3 74 String*12 Document Tax Authority 3 E A C 
CODETAX4 75 String*12 Document Tax Authority 4 E A C 
CODETAX5 76 String*12 Document Tax Authority 5 E A C 
TXAU1DESC 77 String*60 Tax Auth 1 Description E A C 
TXAU2DESC 78 String*60 Tax Auth 2 Description E A C 
TXAU3DESC 79 String*60 Tax Auth 3 Description E A C 
TXAU4DESC 80 String*60 Tax Auth 4 Description E A C 
TXAU5DESC 81 String*60 Tax Auth 5 Description E A C 
PNDWHD1TOT 82 BCD*10.3 Pending Tax Withheld Amount 1 E A C 
PNDWHD2TOT 83 BCD*10.3 Pending Tax Withheld Amount 2 E A C 
PNDWHD3TOT 84 BCD*10.3 Pending Tax Withheld Amount 3 E A C 
PNDWHD4TOT 85 BCD*10.3 Pending Tax Withheld Amount 4 E A C 
PNDWHD5TOT 86 BCD*10.3 Pending Tax Withheld Amount 5 E A C 
PNDWHDTOT 87 BCD*10.3 Pending Tax Withheld Total E A C 
AMTWHDTOT 88 BCD*10.3 Tax Withheld Amount Total E A C 

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