Table: Payments/Adjustments

Table: APTCR
View: AP0031
Record Length: 1717

Flags: A R 

Keys: 1

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

Fields: 166

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*18 Check Number Mask: %-18D
IDVEND String*12 Vendor Number Mask: %-12C
DATERMIT Date Payment Date/Adjustment 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.
PAYMCODE String*12 Payment Code Mask: %-12N
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 Number
3 = PO Number
4 = Order Number
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 Curr.
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 Entry Reference
ADJTOTCRHC BCD*10.3 Adj. Credit Amt. Func. Curr.
AMTADJHCUR BCD*10.3 Total Adj. Amt. Func. Curr.
CNTDEPSSEQ ??? 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:7 entries
1 = ENG
2 = FRA
3 = ESN
4 = AUS
5 = MEX
6 = CHN
7 = CHT
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
IDBANK String*8 Bank Code Mask: %-8N
CODECURNBC String*3 Bank Currency Code Mask: %-3N
PAYMTYPE Integer Payment Type List:5 entries
0 =
1 = Cash
2 = Check
3 = Credit Card
4 = Other
CASHACCT String*45 Cash Account Mask: %-45C
DRILLAPP String*2 Drill Down Application Source Mask: %-2A
DRILLTYPE Integer Drill Down Type
DRILLDWNLK BCD*10.0 Drill Down Link Number
CODE1099 String*6 1099/CPRS Code Mask: %-6N
AMT1099 BCD*10.3 1099/CPRS Amount
SWTXAMTCTL Integer Calculate Tax Amount Control List:3 entries
0 = Enter
1 = Calculate
2 = Distribute
SWTXBSECTL Integer Calculate Tax Base Control List:3 entries
0 = Enter
1 = Calculate
2 = Distribute
CODETAXGRP String*12 Tax Group Mask: %-12N
TAXVERSION Long Tax State Version
CODETAX1 String*12 Tax Authority 1
CODETAX2 String*12 Tax Authority 2
CODETAX3 String*12 Tax Authority 3
CODETAX4 String*12 Tax Authority 4
CODETAX5 String*12 Tax Authority 5
TAXCLASS1 Integer Tax Class 1
TAXCLASS2 Integer Tax Class 2
TAXCLASS3 Integer Tax Class 3
TAXCLASS4 Integer Tax Class 4
TAXCLASS5 Integer Tax Class 5
SWTAXINCL1 Integer Tax Included 1 List:2 entries
0 = No
1 = Yes
SWTAXINCL2 Integer Tax Included 2 List:2 entries
0 = No
1 = Yes
SWTAXINCL3 Integer Tax Included 3 List:2 entries
0 = No
1 = Yes
SWTAXINCL4 Integer Tax Included 4 List:2 entries
0 = No
1 = Yes
SWTAXINCL5 Integer Tax Included 5 List:2 entries
0 = No
1 = Yes
TXBSE1TC BCD*10.3 Tax Base 1
TXBSE2TC BCD*10.3 Tax Base 2
TXBSE3TC BCD*10.3 Tax Base 3
TXBSE4TC BCD*10.3 Tax Base 4
TXBSE5TC BCD*10.3 Tax Base 5
TXAMT1TC BCD*10.3 Tax Amount 1
TXAMT2TC BCD*10.3 Tax Amount 2
TXAMT3TC BCD*10.3 Tax Amount 3
TXAMT4TC BCD*10.3 Tax Amount 4
TXAMT5TC BCD*10.3 Tax Amount 5
TXTOTTC BCD*10.3 Tax Total
AMTNETTC BCD*10.3 Dist. Amount Net of Taxes
TXALLTC BCD*10.3 Tax Allocated Total
TXEXPTC BCD*10.3 Tax Expensed Total
TXRECTC BCD*10.3 Tax Recoverable Total
CODECURNRC String*3 Tax Reporting Currency Code Mask: %-3N
SWTXCTLRC Integer Tax Reporting Calculate Method List:3 entries
0 = Enter
1 = Calculate
2 = Distribute
RATERC BCD*8.7 Tax Reporting Exchange Rate
RATETYPERC String*2 Tax Reporting Rate Type Mask: %-2N
RATEDATERC Date Tax Reporting Rate Date
RATEOPRC Integer Tax Reporting Rate Operator List:2 entries
1 = Multiply
2 = Divide
SWRATERC Integer Tax Reporting Rate Override List:2 entries
0 = No
1 = Yes
TXAMT1RC BCD*10.3 Tax Reporting Amount 1
TXAMT2RC BCD*10.3 Tax Reporting Amount 2
TXAMT3RC BCD*10.3 Tax Reporting Amount 3
TXAMT4RC BCD*10.3 Tax Reporting Amount 4
TXAMT5RC BCD*10.3 Tax Reporting Amount 5
TXTOTRC BCD*10.3 Tax Reporting Total
TXALLRC BCD*10.3 Tax Reporting Allocated Total
TXEXPRC BCD*10.3 Tax Reporting Expensed Total
TXRECRC BCD*10.3 Tax Reporting Recoverable Total
AMTPPAYHC BCD*10.3 Total Prepay Func. Curr.
AMTDISCHC BCD*10.3 Total Discount Func. Curr.
REMREAPLHC BCD*10.3 Total Reapply Remaining Func. Curr.
TXBSE1HC BCD*10.3 Func. Tax Base 1
TXBSE2HC BCD*10.3 Func. Tax Base 2
TXBSE3HC BCD*10.3 Func. Tax Base 3
TXBSE4HC BCD*10.3 Func. Tax Base 4
TXBSE5HC BCD*10.3 Func. Tax Base 5
TXAMT1HC BCD*10.3 Func. Tax Amount 1
TXAMT2HC BCD*10.3 Func. Tax Amount 2
TXAMT3HC BCD*10.3 Func. Tax Amount 3
TXAMT4HC BCD*10.3 Func. Tax Amount 4
TXAMT5HC BCD*10.3 Func. Tax Amount 5
TXTOTHC BCD*10.3 Func. Tax Total
AMTNETHC BCD*10.3 Func. Dist. Amount Net of Taxes
TXALLHC BCD*10.3 Func. Tax Allocated Total
TXEXPHC BCD*10.3 Func. Tax Expensed Total
TXRECHC BCD*10.3 Func. Tax Recoverable Total
APVERSION String*3 A/P Version Created In
CNTACC Long Number of Advance Credit Claims
AMTACCTC BCD*10.3 Total Advance Credit Claim
AMTACCHC BCD*10.3 Func. Total Advance Credit Claim
ENTEREDBY String*8 Entered By
DATEBUS Date Posting Date
IDACCTSET String*6 Account Set Mask: %-6N
AMTWHT1TC BCD*10.3 Estimated Tax Withheld Amount 1
AMTWHT2TC BCD*10.3 Estimated Tax Withheld Amount 2
AMTWHT3TC BCD*10.3 Estimated Tax Withheld Amount 3
AMTWHT4TC BCD*10.3 Estimated Tax Withheld Amount 4
AMTWHT5TC BCD*10.3 Estimated Tax Withheld Amount 5
AMTCXBS1TC BCD*10.3 Reverse Charges Base 1
AMTCXBS2TC BCD*10.3 Reverse Charges Base 2
AMTCXBS3TC BCD*10.3 Reverse Charges Base 3
AMTCXBS4TC BCD*10.3 Reverse Charges Base 4
AMTCXBS5TC BCD*10.3 Reverse Charges Base 5
AMTCXTX1TC BCD*10.3 Reverse Charges Amount 1
AMTCXTX2TC BCD*10.3 Reverse Charges Amount 2
AMTCXTX3TC BCD*10.3 Reverse Charges Amount 3
AMTCXTX4TC BCD*10.3 Reverse Charges Amount 4
AMTCXTX5TC BCD*10.3 Reverse Charges Amount 5
AMTGROSDST BCD*10.3 Misc Payment Document Total

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).