# View: Payments/Adjustments

RotoID: AP0031
Tables: APTCR
DLL: APTCR

## Compositions: 4

RotoID | Title | Tables | DLL
--- | --- | --- | ---
AP0030 | Payment and Adjustment Batches | APBTA | APBTA
AP0032 | Miscellaneous Payments | APTCN | APTCN
AP0033 | Applied Payments | APTCP | APTCP
AP0406 | Payment/Adjustment Optional Fields | APTCRO | APTCRO

## Keys: 1

Title | Fields
--- | ---
Batch Payments Primary Key ds | BTCHTYPE, CNTBTCH, CNTENTR

## Fields: 64

Field | Index | Type | Title | Attributes | Presentation
--- | --- | --- | --- | --- | ---
BTCHTYPE | 1 | String*2 | Batch Type ds | E A K R | Mask: %-2N
CNTBTCH | 2 | BCD*5.0 | Batch Number ds | E A K R |
CNTENTR | 3 | BCD*4.0 | Entry Number ds | E A K R |
IDRMIT | 4 | String*12 | Check Number ds | E A | Mask: %-12D
IDVEND | 5 | String*12 | Vendor Number ds | E A | Mask: %-12C
DATERMIT | 6 | Date | Payment Date ds | E A |
TEXTRMIT | 7 | String*60 | Entry Description ds | E A |
NAMERMIT | 8 | String*60 | Vendor / Payee Name ds | E A |
AMTRMIT | 9 | BCD*10.3 | Check Amount in Bank Curr. ds | E A C |
AMTRMITTC | 10 | BCD*10.3 | Check Amount in Vendor Curr. ds | E A C |
RATEEXCHTC | 11 | BCD*8.7 | Vendor Exchange Rate ds | E A |
SWRATETC | 12 | Integer | Vendor Rate Overridden ds | E A | List: 2 entries
0 | = | No
1 | = | Yes
CNTPAYMENT | 13 | BCD*3.0 | Number of Payments Entered ds | E A C |
AMTPPAYTC | 14 | BCD*10.3 | Total Prepay Vendor Curr. ds | E A |
AMTDISCTC | 15 | BCD*10.3 | Total Discount Vendor Curr. ds | E A C |
CODEPAYM | 16 | String*6 | Reserved - Payment Type ds | E |
CODECURN | 17 | String*3 | Vendor Currency Code ds | E A | Mask: %-3N
RATETYPEHC | 18 | String*2 | Bank Rate Type ds | E A | Mask: %-2N
RATEEXCHHC | 19 | BCD*8.7 | Bank Exchange Rate ds | E A |
SWRATEHC | 20 | Integer | Bank Rate Overridden ds | E A | List: 2 entries
0 | = | No
1 | = | Yes
RMITTYPE | 21 | Integer | Payment Trans. Type ds | E A | List: 5 entries
1 | = | Payment
2 | = | Prepayment
3 | = | Apply Document
4 | = | Misc. Payment
5 | = | Adjustment
DOCTYPE | 22 | Integer | Document Type ds | E A P | List: 6 entries
1 | = | (None)
2 | = | Document No.
3 | = | PO Number
4 | = | Sales Order No.
5 | = | Prepayment
7 | = | Credit Note
CNTLSTLINE | 23 | BCD*3.0 | Last Line Number ds | E A C |
FISCYR | 24 | String*4 | Fiscal Year ds | E A | Mask: %04D
FISCPER | 25 | String*2 | Fiscal Period ds | E A | Mask: %02D
DATERATETC | 26 | Date | Vendor Rate Date ds | E A |
RATETYPETC | 27 | String*2 | Vendor Rate Type ds | E A | Mask: %-2N
AMTADJTCUR | 28 | BCD*10.3 | Total Payment Adj. Vendor Curr. ds | E A C |
DATERATEHC | 29 | Date | Bank Rate Date ds | E A |
REMREAPLTC | 30 | BCD*10.3 | Total Reapply Remaining Vendor Cds | E A C |
ADJTOTDBHC | 31 | BCD*10.3 | Adj. Debit Amt. Func. Curr. ds | E A C |
AMTRMITHC | 32 | BCD*10.3 | Check Amount Func. Curr. ds | E A C |
DOCNBR | 33 | String*22 | Document Number ds | E A | Mask: %-22C
PAYMSTTS | 34 | Integer | Payment Edited ds | E A | List: 3 entries
0 | = | No
1 | = | Yes
2 | = | Deleted
SWPRNTRMIT | 35 | Integer | Check Print Required ds | E A | List: 2 entries
0 | = | No
1 | = | Yes
IDRMITTO | 36 | String*6 | Vendor Remit-To Location ds | E A | Mask: %-6N
TXTRMITREF | 37 | String*60 | Remit Reference Text ds | E A |
CLASS1099 | 38 | String*6 | Reserved ds | E |
ADJTOTCRHC | 39 | BCD*10.3 | Adj. Credit Amt. Func. Curr. ds | E A C |
AMTADJHCUR | 40 | BCD*10.3 | Total Adj. Amt. Func. Curr. ds | E A C |
CNTDEPSSEQ | 41 | Long | Check Sequence No. ds | E A |
SWPRINTED | 42 | Integer | Check Printed Status ds | E A | List: 2 entries
0 | = | Not printed
1 | = | Printed
TEXTSTRE1 | 43 | String*60 | Address Line 1 ds | E A |
TEXTSTRE2 | 44 | String*60 | Address Line 2 ds | E A |
TEXTSTRE3 | 45 | String*60 | Address Line 3 ds | E A |
TEXTSTRE4 | 46 | String*60 | Address Line 4 ds | E A |
NAMECITY | 47 | String*30 | City ds | E A |
CODESTTE | 48 | String*30 | State ds | E A |
CODEPSTL | 49 | String*20 | Zip/Postal Code ds | E A |
CODECTRY | 50 | String*30 | Country ds | E A |
CHECKLANG | 51 | String*3 | Payment Language ds | E A P | List: 5 entries
1 | = | ENG
2 | = | FRA
3 | = | ESN
4 | = | AUS
5 | = | MEX
OPERBANK | 52 | Integer | Bank Rate Operator ds | E A C | List: 2 entries
1 | = | Multiply
2 | = | Divide
OPERVEND | 53 | Integer | Vendor Rate Operator ds | E A C | List: 2 entries
1 | = | Multiply
2 | = | Divide
ADJTOTDBTC | 54 | BCD*10.3 | Adj. Debit Amt. Vendor Curr. ds | E A C |
ADJTOTCRTC | 55 | BCD*10.3 | Adj. Credit Amt. Vendor Curr. ds | E A C |
DATEACTVPP | 56 | Date | Prepay Activation Date ds | E A |
SWJOB | 57 | Integer | Job Related ds | E A | List: 2 entries
0 | = | No
1 | = | Yes
APPLYMETH | 58 | Integer | Job Apply Method ds | E A | List: 2 entries
0 | = | Prorate by Amount
1 | = | Top Down
ERRBATCH | 59 | Long | Error Batch ds | E A C |
ERRENTRY | 60 | Long | Error Entry ds | E A C |
IDINVCMTCH | 61 | String*22 | Matching Document Number ds | E A | Mask: %-22C
VALUES | 62 | Long | Optional Fields ds | E A C |
PROCESSCMD | 63 | Integer | Process Command Code ds | E A C | List: 1 entries
0 | = | Insert Optional Fields
SRCEAPPL | 64 | String*2 | Source Application ds | E A | Mask: %-2A

This page was generated on 2004-Oct-28

Copyright © 2000–2004 ACCPAC International, Inc. All rights reserved.