# Table: Payments/Adjustments

Table: APTCR
View: AP0031
Record length: 869
Flags: A R

## Keys: 1

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

## Fields: 67

Field | Type | Title | Presentation
--- | --- | --- | ---
BTCHTYPE | String*2 | Batch Type | Mask: %-2N
CNTBTCH | BCD*5.0 | Batch Number |
CNTENTR | BCD*4.0 | Entry Number |
AUDTDATE | Date |  |
AUDTTIME | Time |  |
AUDTUSER | String*8 |  |
AUDTORG | String*6 |  |
IDRMIT | String*12 | Check Number | Mask: %-12D
IDVEND | String*12 | Vendor Number | Mask: %-12C
DATERMIT | Date | Payment Date |
TEXTRMIT | String*60 | Entry Description |
NAMERMIT | String*60 | Vendor / Payee Name |
AMTRMIT | BCD*10.3 | Check Amount in Bank Curr. |
AMTRMITTC | BCD*10.3 | Check Amount in Vendor Curr. |
RATEEXCHTC | BCD*8.7 | Vendor Exchange Rate |
SWRATETC | Integer | Vendor Rate Overridden | List: 2 entries
0 | = | No
1 | = | Yes
CNTPAYMENT | BCD*3.0 | Number of Payments Entered |
AMTPPAYTC | BCD*10.3 | Total Prepay Vendor Curr. |
AMTDISCTC | BCD*10.3 | Total Discount Vendor Curr. |
CODEPAYM | String*6 | Reserved - Payment Type |
CODECURN | String*3 | Vendor Currency Code | Mask: %-3N
RATETYPEHC | String*2 | Bank Rate Type | Mask: %-2N
RATEEXCHHC | BCD*8.7 | Bank Exchange Rate |
SWRATEHC | Integer | Bank Rate Overridden | List: 2 entries
0 | = | No
1 | = | Yes
RMITTYPE | Integer | Payment Trans. Type | List: 5 entries
1 | = | Payment
2 | = | Prepayment
3 | = | Apply Document
4 | = | Misc. Payment
5 | = | Adjustment
DOCTYPE | Integer | Document Type | List: 6 entries
1 | = | (None)
2 | = | Document No.
3 | = | PO Number
4 | = | Sales Order No.
5 | = | Prepayment
7 | = | Credit Note
CNTLSTLINE | BCD*3.0 | Last Line Number |
FISCYR | String*4 | Fiscal Year | Mask: %04D
FISCPER | String*2 | Fiscal Period | Mask: %02D
DATERATETC | Date | Vendor Rate Date |
RATETYPETC | String*2 | Vendor Rate Type | Mask: %-2N
AMTADJTCUR | BCD*10.3 | Total Payment Adj. Vendor Curr. |
DATERATEHC | Date | Bank Rate Date |
REMREAPLTC | BCD*10.3 | Total Reapply Remaining Vendor C |
ADJTOTDBHC | BCD*10.3 | Adj. Debit Amt. Func. Curr. |
AMTRMITHC | BCD*10.3 | Check Amount Func. Curr. |
DOCNBR | String*22 | Document Number | Mask: %-22C
PAYMSTTS | Integer | Payment Edited | List: 3 entries
0 | = | No
1 | = | Yes
2 | = | Deleted
SWPRNTRMIT | Integer | Check Print Required | List: 2 entries
0 | = | No
1 | = | Yes
IDRMITTO | String*6 | Vendor Remit-To Location | Mask: %-6N
TXTRMITREF | String*60 | Remit Reference Text |
CLASS1099 | String*6 | Reserved |
ADJTOTCRHC | BCD*10.3 | Adj. Credit Amt. Func. Curr. |
AMTADJHCUR | BCD*10.3 | Total Adj. Amt. Func. Curr. |
CNTDEPSSEQ | Long | Check Sequence No. |
SWPRINTED | Integer | Check Printed Status | List: 2 entries
0 | = | Not printed
1 | = | Printed
TEXTSTRE1 | String*60 | Address Line 1 |
TEXTSTRE2 | String*60 | Address Line 2 |
TEXTSTRE3 | String*60 | Address Line 3 |
TEXTSTRE4 | String*60 | Address Line 4 |
NAMECITY | String*30 | City |
CODESTTE | String*30 | State |
CODEPSTL | String*20 | Zip/Postal Code |
CODECTRY | String*30 | Country |
CHECKLANG | String*3 | Payment Language | List: 5 entries
1 | = | ENG
2 | = | FRA
3 | = | ESN
4 | = | AUS
5 | = | MEX
OPERBANK | Integer | Bank Rate Operator | List: 2 entries
1 | = | Multiply
2 | = | Divide
OPERVEND | Integer | Vendor Rate Operator | List: 2 entries
1 | = | Multiply
2 | = | Divide
ADJTOTDBTC | BCD*10.3 | Adj. Debit Amt. Vendor Curr. |
ADJTOTCRTC | BCD*10.3 | Adj. Credit Amt. Vendor Curr. |
DATEACTVPP | Date | Prepay Activation Date |
SWJOB | Integer | Job Related | List: 2 entries
0 | = | No
1 | = | Yes
APPLYMETH | Integer | Job Apply Method | List: 2 entries
0 | = | Prorate by Amount
1 | = | Top Down
ERRBATCH | Long | Error Batch |
ERRENTRY | Long | Error Entry |
IDINVCMTCH | String*22 | Matching Document Number | Mask: %-22C
VALUES | Long | Optional Fields |
SRCEAPPL | String*2 | Source Application | Mask: %-2A

This page was generated on 2004-Oct-28

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