View: Payments/Adjustments

RotoID: AP0031
Table: APTCR
Protocol: Header, Key auto generate
DLL:APTCR

Compositions: 6

RotoID Tables Title DLL
AP0030 APBTA Payment and Adjustment Batches APBTA
AP0032 APTCN Miscellaneous Payments APTCN
AP0033 APTCP Applied Payments APTCP
AP0406 APTCRO Payment/Adjustment Optional Fields APTCRO
AP0170 APTCC Advance Credits APTCC
AP0069 APTCT Payment Tax Withholdings APTCT

Keys: 1

Title Fields
Batch Payments Primary Key BTCHTYPE, CNTBTCH, CNTENTR

Fields: 163

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*18 Check Number E A  Mask: %-18D
IDVEND 5 String*12 Vendor Number E A  Mask: %-12C
DATERMIT 6 Date Payment Date/Adjustment 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 C  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 A C  Mask: %04D
FISCPER 25 String*2 Fiscal Period A C  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 Curr. 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 ??? 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:7 entries
1 = ENG
2 = FRA
3 = ESN
4 = AUS
5 = MEX
6 = CHN
7 = CHT
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:6 entries
0 = Insert Optional Fields
1 = Calculate Taxes
2 = Distribute Taxes
3 = Derive Tax Reporting Exchange Rate
4 = Void Check
5 = Generate Vendor Distribution
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
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 
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. Curr. 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 
APVERSION 148 String*3 A/P Version Created In E A C 
CNTACC 149 Long Number of Advance Credit Claims E A C 
AMTACCTC 150 BCD*10.3 Total Advance Credit Claim E A C 
AMTACCHC 151 BCD*10.3 Func. Total Advance Credit Claim E A C 
ENTEREDBY 152 String*8 Entered By E A C 
DATEBUS 153 Date Posting Date E A 
IDACCTSET 154 String*6 Account Set E A  Mask: %-6N
AMTWHT1TC 155 BCD*10.3 Estimated Tax Withheld Amount 1 E A 
AMTWHT2TC 156 BCD*10.3 Estimated Tax Withheld Amount 2 E A 
AMTWHT3TC 157 BCD*10.3 Estimated Tax Withheld Amount 3 E A 
AMTWHT4TC 158 BCD*10.3 Estimated Tax Withheld Amount 4 E A 
AMTWHT5TC 159 BCD*10.3 Estimated Tax Withheld Amount 5 E A 
AMTCXBS1TC 160 BCD*10.3 Reverse Charges Base 1 E A C 
AMTCXBS2TC 161 BCD*10.3 Reverse Charges Base 2 E A C 
AMTCXBS3TC 162 BCD*10.3 Reverse Charges Base 3 E A C 
AMTCXBS4TC 163 BCD*10.3 Reverse Charges Base 4 E A C 
AMTCXBS5TC 164 BCD*10.3 Reverse Charges Base 5 E A C 
AMTCXTX1TC 165 BCD*10.3 Reverse Charges Amount 1 E A 
AMTCXTX2TC 166 BCD*10.3 Reverse Charges Amount 2 E A 
AMTCXTX3TC 167 BCD*10.3 Reverse Charges Amount 3 E A 
AMTCXTX4TC 168 BCD*10.3 Reverse Charges Amount 4 E A 
AMTCXTX5TC 169 BCD*10.3 Reverse Charges Amount 5 E A 
AMTGROSDST 170 BCD*10.3 Misc Payment Document Total E A C 

This page was generated on 2022-Aug-18

© 2021 Sage Software, Inc. All rights reserved. Reproduction of part or all of the contents in any form is prohibited unless for personal use. None of the content of this article may be copied or otherwise incorporated into any other document, publication or other work in any form (whether written, electronic or other format).

Sage Software, Inc. makes no warranties, representations or undertakings about any of the content of articles (including, without limitation, any as to the quality, accuracy, completeness or fitness for any particular purpose of such content).