# View: Applied Payments

RotoID: AP0033
Table: APTCP
DLL: APTCP

## Compositions: 3

RotoID | Table | 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: 56

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 P |
DATERMIT | 43 | Date | Payment Date | E C P |
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 |
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 |

This page was generated on 2006-Sep-07

Copyright © 2001–2005 Sage Accpac International, Inc.