# View: Payments/Adjustments

RotoID: AP0031
Table: APTCR
DLL: APTCR

## Compositions: 4

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

## Keys: 1

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

## Fields: 146

Field | Index | Type | Title | Attributes | Presentation
--- | --- | --- | --- | --- | ---
BTCHTYPE | 1 | String*2 | Batch Type | E A K R | Mask: %-2N
CNTBTCH | 2 | BCD*5.0 | Batch Number | E A K R |
CNTENTR | 3 | BCD*4.0 | Entry Number | E A K R |
IDRMIT | 4 | String*12 | Check Number | E A | Mask: %-12D
IDVEND | 5 | String*12 | Vendor Number | E A | Mask: %-12C
DATERMIT | 6 | Date | Payment Date | E A |
TEXTRMIT | 7 | String*60 | Entry Description | E A |
NAMERMIT | 8 | String*60 | Vendor / Payee Name | E A X |
AMTRMIT | 9 | BCD*10.3 | Check Amount in Bank Curr. | E A C |
AMTRMITTC | 10 | BCD*10.3 | Check Amount in Vendor Curr. | E A C |
RATEEXCHTC | 11 | BCD*8.7 | Vendor Exchange Rate | E A |
SWRATETC | 12 | Integer | Vendor Rate Overridden | E A | List: 2 entries
0 | = | No
1 | = | Yes
CNTPAYMENT | 13 | BCD*3.0 | Number of Payments Entered | E A C |
AMTPPAYTC | 14 | BCD*10.3 | Total Prepay Vendor Curr. | E A |
AMTDISCTC | 15 | BCD*10.3 | Total Discount Vendor Curr. | E A C |
PAYMCODE | 16 | String*12 | Payment Code | E A | Mask: %-12N
CODECURN | 17 | String*3 | Vendor Currency Code | E A | Mask: %-3N
RATETYPEHC | 18 | String*2 | Bank Rate Type | E A | Mask: %-2N
RATEEXCHHC | 19 | BCD*8.7 | Bank Exchange Rate | E A |
SWRATEHC | 20 | Integer | Bank Rate Overridden | E A | List: 2 entries
0 | = | No
1 | = | Yes
RMITTYPE | 21 | Integer | Payment Trans. Type | E A P | List: 5 entries
1 | = | Payment
2 | = | Prepayment
3 | = | Apply Document
4 | = | Misc. Payment
5 | = | Adjustment
DOCTYPE | 22 | Integer | Document Type | E A P | List: 6 entries
1 | = | (None)
2 | = | Document Number
3 | = | PO Number
4 | = | Order Number
5 | = | Prepayment
7 | = | Credit Note
CNTLSTLINE | 23 | BCD*3.0 | Last Line Number | E A C |
FISCYR | 24 | String*4 | Fiscal Year | E A | Mask: %04D
FISCPER | 25 | String*2 | Fiscal Period | E A | Mask: %02D
DATERATETC | 26 | Date | Vendor Rate Date | E A |
RATETYPETC | 27 | String*2 | Vendor Rate Type | E A | Mask: %-2N
AMTADJTCUR | 28 | BCD*10.3 | Total Payment Adj. Vendor Curr. | E A C |
DATERATEHC | 29 | Date | Bank Rate Date | E A |
REMREAPLTC | 30 | BCD*10.3 | Total Reapply Remaining Vendor C | E A C |
ADJTOTDBHC | 31 | BCD*10.3 | Adj. Debit Amt. Func. Curr. | E A C |
AMTRMITHC | 32 | BCD*10.3 | Check Amount Func. Curr. | E A C |
DOCNBR | 33 | String*22 | Document Number | E A | Mask: %-22C
PAYMSTTS | 34 | Integer | Payment Edited | E A | List: 3 entries
0 | = | No
1 | = | Yes
2 | = | Deleted
SWPRNTRMIT | 35 | Integer | Check Print Required | E A | List: 2 entries
0 | = | No
1 | = | Yes
IDRMITTO | 36 | String*6 | Vendor Remit-To Location | E A | Mask: %-6N
TXTRMITREF | 37 | String*60 | Entry Reference | E A |
ADJTOTCRHC | 39 | BCD*10.3 | Adj. Credit Amt. Func. Curr. | E A C |
AMTADJHCUR | 40 | BCD*10.3 | Total Adj. Amt. Func. Curr. | E A C |
CNTDEPSSEQ | 41 | Long | Check Sequence No. | E A |
SWPRINTED | 42 | Integer | Check Printed Status | E A | List: 2 entries
0 | = | Not printed
1 | = | Printed
TEXTSTRE1 | 43 | String*60 | Address Line 1 | E A X |
TEXTSTRE2 | 44 | String*60 | Address Line 2 | E A X |
TEXTSTRE3 | 45 | String*60 | Address Line 3 | E A X |
TEXTSTRE4 | 46 | String*60 | Address Line 4 | E A X |
NAMECITY | 47 | String*30 | City | E A X |
CODESTTE | 48 | String*30 | State | E A X |
CODEPSTL | 49 | String*20 | Zip/Postal Code | E A X |
CODECTRY | 50 | String*30 | Country | E A X |
CHECKLANG | 51 | String*3 | Payment Language | E A P | List: 5 entries
1 | = | ENG
2 | = | FRA
3 | = | ESN
4 | = | AUS
5 | = | MEX
OPERBANK | 52 | Integer | Bank Rate Operator | E A C | List: 2 entries
1 | = | Multiply
2 | = | Divide
OPERVEND | 53 | Integer | Vendor Rate Operator | E A C | List: 2 entries
1 | = | Multiply
2 | = | Divide
ADJTOTDBTC | 54 | BCD*10.3 | Adj. Debit Amt. Vendor Curr. | E A C |
ADJTOTCRTC | 55 | BCD*10.3 | Adj. Credit Amt. Vendor Curr. | E A C |
DATEACTVPP | 56 | Date | Prepay Activation Date | E A |
SWJOB | 57 | Integer | Job Related | E A | List: 2 entries
0 | = | No
1 | = | Yes
APPLYMETH | 58 | Integer | Job Apply Method | E A | List: 2 entries
0 | = | Prorate by Amount
1 | = | Top Down
ERRBATCH | 59 | Long | Error Batch | E A C |
ERRENTRY | 60 | Long | Error Entry | E A C |
IDINVCMTCH | 61 | String*22 | Matching Document Number | E A | Mask: %-22C
VALUES | 62 | Long | Optional Fields | E A C |
PROCESSCMD | 63 | Integer | Process Command Code | E A C | List: 5 entries
0 | = | Insert Optional Fields
1 | = | Calculate Taxes
2 | = | Distribute Taxes
3 | = | Derive Tax Reporting Exchange Rate
4 | = | Incorrect procedure. Vendor cannot be changed for an existing payment.
SRCEAPPL | 64 | String*2 | Source Application | E A | Mask: %-2A
IDBANK | 65 | String*8 | Bank Code | E A | Mask: %-8N
CODECURNBC | 66 | String*3 | Bank Currency Code | E A | Mask: %-3N
PAYMTYPE | 67 | Integer | Payment Type | E A C | List: 5 entries
0 | = |
1 | = | Cash
2 | = | Check
3 | = | Credit Card
4 | = | Other
CCTYPE | 68 | String*12 | C.C. Type | E A | Mask: %-12N
CCNUMBER | 69 | Binary*32 | Encrypted C.C. Number | E A C X |
CCNAME | 70 | String*60 | C.C. Name | E A |
CCEXP | 71 | Date | C.C. Expiry Date | E A |
CCAUTHCODE | 72 | String*20 | C.C. Auth. Code | E A |
CASHACCT | 73 | String*45 | Cash Account | E A | Mask: %-45C
DRILLAPP | 74 | String*2 | Drill Down Application Source | E A C | Mask: %-2A
DRILLTYPE | 75 | Integer | Drill Down Type | E A C |
DRILLDWNLK | 76 | BCD*10.0 | Drill Down Link Number | E A C |
CODE1099 | 77 | String*6 | 1099/CPRS Code | E A | Mask: %-6N
AMT1099 | 78 | BCD*10.3 | 1099/CPRS Amount | E A |
SWTXAMTCTL | 79 | Integer | Calculate Tax Amount Control | E A | List: 3 entries
0 | = | Enter
1 | = | Calculate
2 | = | Distribute
SWTXBSECTL | 80 | Integer | Calculate Tax Base Control | E A | List: 3 entries
0 | = | Enter
1 | = | Calculate
2 | = | Distribute
CODETAXGRP | 81 | String*12 | Tax Group | E A | Mask: %-12N
TAXVERSION | 82 | Long | Tax State Version | E A C |
CODETAX1 | 83 | String*12 | Tax Authority 1 | E A C |
CODETAX2 | 84 | String*12 | Tax Authority 2 | E A C |
CODETAX3 | 85 | String*12 | Tax Authority 3 | E A C |
CODETAX4 | 86 | String*12 | Tax Authority 4 | E A C |
CODETAX5 | 87 | String*12 | Tax Authority 5 | E A C |
TAXCLASS1 | 88 | Integer | Tax Class 1 | E A |
TAXCLASS2 | 89 | Integer | Tax Class 2 | E A |
TAXCLASS3 | 90 | Integer | Tax Class 3 | E A |
TAXCLASS4 | 91 | Integer | Tax Class 4 | E A |
TAXCLASS5 | 92 | Integer | Tax Class 5 | E A |
SWTAXINCL1 | 93 | Integer | Tax Included 1 | E A | List: 2 entries
0 | = | No
1 | = | Yes
SWTAXINCL2 | 94 | Integer | Tax Included 2 | E A | List: 2 entries
0 | = | No
1 | = | Yes
SWTAXINCL3 | 95 | Integer | Tax Included 3 | E A | List: 2 entries
0 | = | No
1 | = | Yes
SWTAXINCL4 | 96 | Integer | Tax Included 4 | E A | List: 2 entries
0 | = | No
1 | = | Yes
SWTAXINCL5 | 97 | Integer | Tax Included 5 | E A | List: 2 entries
0 | = | No
1 | = | Yes
TXBSE1TC | 98 | BCD*10.3 | Tax Base 1 | E A |
TXBSE2TC | 99 | BCD*10.3 | Tax Base 2 | E A |
TXBSE3TC | 100 | BCD*10.3 | Tax Base 3 | E A |
TXBSE4TC | 101 | BCD*10.3 | Tax Base 4 | E A |
TXBSE5TC | 102 | BCD*10.3 | Tax Base 5 | E A |
TXAMT1TC | 103 | BCD*10.3 | Tax Amount 1 | E A |
TXAMT2TC | 104 | BCD*10.3 | Tax Amount 2 | E A |
TXAMT3TC | 105 | BCD*10.3 | Tax Amount 3 | E A |
TXAMT4TC | 106 | BCD*10.3 | Tax Amount 4 | E A |
TXAMT5TC | 107 | BCD*10.3 | Tax Amount 5 | E A |
TXTOTTC | 108 | BCD*10.3 | Tax Total | E A C |
AMTNETTC | 109 | BCD*10.3 | Dist. Amount Net of Taxes | E A C |
TXALLTC | 110 | BCD*10.3 | Tax Allocated Total | E A C |
TXEXPTC | 111 | BCD*10.3 | Tax Expensed Total | E A C |
TXRECTC | 112 | BCD*10.3 | Tax Recoverable Total | E A C |
CODECURNRC | 113 | String*3 | Tax Reporting Currency Code | E A | Mask: %-3N
SWTXCTLRC | 114 | Integer | Tax Reporting Calculate Method | E A | List: 3 entries
0 | = | Enter
1 | = | Calculate
2 | = | Distribute
RATERC | 115 | BCD*8.7 | Tax Reporting Exchange Rate | E A |
RATETYPERC | 116 | String*2 | Tax Reporting Rate Type | E A | Mask: %-2N
RATEDATERC | 117 | Date | Tax Reporting Rate Date | E A |
RATEOPRC | 118 | Integer | Tax Reporting Rate Operator | E A C | List: 2 entries
1 | = | Multiply
2 | = | Divide
SWRATERC | 119 | Integer | Tax Reporting Rate Override | E A C | List: 2 entries
0 | = | No
1 | = | Yes
TXAMT1RC | 120 | BCD*10.3 | Tax Reporting Amount 1 | E A |
TXAMT2RC | 121 | BCD*10.3 | Tax Reporting Amount 2 | E A |
TXAMT3RC | 122 | BCD*10.3 | Tax Reporting Amount 3 | E A |
TXAMT4RC | 123 | BCD*10.3 | Tax Reporting Amount 4 | E A |
TXAMT5RC | 124 | BCD*10.3 | Tax Reporting Amount 5 | E A |
TXTOTRC | 125 | BCD*10.3 | Tax Reporting Total | E A C |
TXALLRC | 126 | BCD*10.3 | Tax Reporting Allocated Total | E A C |
TXEXPRC | 127 | BCD*10.3 | Tax Reporting Expensed Total | E A C |
TXRECRC | 128 | BCD*10.3 | Tax Reporting Recoverable Total | E A C |
XCCNUMBER | 129 | String*32 | C.C. Number | E A | Mask: %-32D
AMTPPAYHC | 130 | BCD*10.3 | Total Prepay Func. Curr. | E A C |
AMTDISCHC | 131 | BCD*10.3 | Total Discount Func. Curr. | E A C |
REMREAPLHC | 132 | BCD*10.3 | Total Reapply Remaining Func. Cu | E A C |
TXBSE1HC | 133 | BCD*10.3 | Func. Tax Base 1 | E A C |
TXBSE2HC | 134 | BCD*10.3 | Func. Tax Base 2 | E A C |
TXBSE3HC | 135 | BCD*10.3 | Func. Tax Base 3 | E A C |
TXBSE4HC | 136 | BCD*10.3 | Func. Tax Base 4 | E A C |
TXBSE5HC | 137 | BCD*10.3 | Func. Tax Base 5 | E A C |
TXAMT1HC | 138 | BCD*10.3 | Func. Tax Amount 1 | E A C |
TXAMT2HC | 139 | BCD*10.3 | Func. Tax Amount 2 | E A C |
TXAMT3HC | 140 | BCD*10.3 | Func. Tax Amount 3 | E A C |
TXAMT4HC | 141 | BCD*10.3 | Func. Tax Amount 4 | E A C |
TXAMT5HC | 142 | BCD*10.3 | Func. Tax Amount 5 | E A C |
TXTOTHC | 143 | BCD*10.3 | Func. Tax Total | E A C |
AMTNETHC | 144 | BCD*10.3 | Func. Dist. Amount Net of Taxes | E A C |
TXALLHC | 145 | BCD*10.3 | Func. Tax Allocated Total | E A C |
TXEXPHC | 146 | BCD*10.3 | Func. Tax Expensed Total | E A C |
TXRECHC | 147 | BCD*10.3 | Func. Tax Recoverable Total | E A C |

This page was generated on 2006-Sep-07

Copyright © 2001–2005 Sage Accpac International, Inc.