# Table: Applied Payments

Table: APTCP
View: AP0033
Record length: 417
Flags: A R

## Keys: 3

Title | Flags | Fields
--- | --- | ---
Batch Number / Entry Number |  | BATCHTYPE, CNTBTCH, CNTRMIT, CNTLINE
Vendor Number / Document Number | D M | IDVEND, IDINVC, CNTPAYM
Batch Type / Batch Number | M | BATCHTYPE, CNTBTCH, CNTRMIT, IDINVC, CNTPAYM

## Fields: 41

Field | Type | Title | Presentation
--- | --- | --- | ---
BATCHTYPE | String*2 | Batch Type | Mask: %-2N
CNTBTCH | BCD*5.0 | Batch Number |
CNTRMIT | BCD*4.0 | Entry Number |
CNTLINE | BCD*3.0 | Line Number |
AUDTDATE | Date |  |
AUDTTIME | Time |  |
AUDTUSER | String*8 |  |
AUDTORG | String*6 |  |
IDVEND | String*12 | Vendor Number | Mask: %-12C
IDINVC | String*22 | Document Number | Mask: %-22C
CNTPAYM | BCD*3.0 | Payment Number |
TRXTYPE | Integer | Transaction Type | List: 3 entries
51 | = | Payment - Posted
57 | = | Prepayment - Posted
81 | = | Adjustment - Posted
PYMTRESL | String*2 | Payment Resolution | Mask: %-2N
AMTPAYM | BCD*10.3 | Payment Amount |
AMTERNDISC | BCD*10.3 | Discount Amount Taken |
CNTLASTSEQ | BCD*3.0 | Next Adj. Seq. No. |
AMTADJTOT | BCD*10.3 | Adjustments Total |
CNTADJ | BCD*5.0 | Generated Adjustment Number |
TEXTADJ | String*60 | Description |
GLREF | String*60 | Reference |
IDPPD | String*22 | Generated PP No. | Mask: %-22C
IDDOCMTCH | String*22 | PP Matching Doc. No. | Mask: %-22C
CDAPPLYTO | Integer | PP Matching Doc. Type | List: 4 entries
1 | = | (None)
2 | = | Document Number
3 | = | PO Number
4 | = | Order Number
DATEACTVPP | Date | Activation Date |
ADJTOTDBTC | BCD*10.3 | Adj. Debit Amt. - Vend. Curr |
ADJTOTCRTC | BCD*10.3 | Adj. Credit Amt. - Vend. Curr |
SWJOB | Integer | Job Related | List: 2 entries
0 | = | No
1 | = | Yes
AMTPAYMTOT | BCD*10.3 | Job Total Payment Amount |
AMTDISCTOT | BCD*10.3 | Job Total Discount Amount |
APPLYMETH | Integer | Job Apply Method | List: 2 entries
0 | = | Prorate by Amount
1 | = | Top Down
RTGTOTDBTC | BCD*10.3 | Rtg. Debit Amt. - Vend. Curr |
RTGTOTCRTC | BCD*10.3 | Rtg. Credit Amt. - Vend. Curr |
RTGAMT | BCD*10.3 | Retainage Amount |
RTGDATEDUE | Date | Retainage Due Date |
RTGTERMS | String*6 | Retainage Terms Code | Mask: %-6N
SWRTGRATE | Integer | Retainage Exchange Rate | List: 2 entries
0 | = | Use Original Document Exchange Rate
1 | = | Use Current Exchange Rate
AMTPAYMHC | BCD*10.3 | Func. Payment Amount |
AMTDISCHC | BCD*10.3 | Func. Discount Amount |
AMTADJHC | BCD*10.3 | Func. Adjustments Total |
RTGAMTHC | BCD*10.3 | Func. Retainage Amount |
DOCTYPE | Integer | Document Type |

This page was generated on 2008-May-01

Copyright © 2001–2008 Sage Software, Inc. All rights reserved.