Table: Posted Payments

Table: APPYM
View: AP0029
Record Length: 1113

Flags: A R 

Keys: 5

Title Flags Fields
Payment Master Primary Key IDBANK, IDVEND, IDRMIT, LONGSERIAL, DATERMIT
Bank Code / Batch Number D M  IDBANK, CNTBTCH, CNTITEM
Vendor Number / Check Number D M  IDVEND, IDRMIT, DATEBATCH
Bank Code / Check Number D M  IDBANK, IDRMIT, LONGSERIAL
Vendor Number / Check Date D M  IDVEND, DATERMIT, IDRMIT

Fields: 120

Field Type Title Presentation
IDBANK String*8 Bank Code Mask: %-8N
IDVEND String*12 Vendor Number Mask: %-12C
IDRMIT String*18 Check Number Mask: %-18D
LONGSERIAL ??? Check Serial Number
DATERMIT Date Check Date
AUDTDATE Date
AUDTTIME Time
AUDTUSER String*8
AUDTORG String*6
DATEBATCH Date Batch Date
AMTRMITTC BCD*10.3 Check Amount Vend. Curr.
AMTPAYM BCD*10.3 Payment Amount
AMTDISC BCD*10.3 Discount Amount
PAYMCODE String*12 Payment Code Mask: %-12N
CODECURN String*3 Currency Code Mask: %-3N
IDRATETYPE String*2 Bank Rate Type Mask: %-2N
RATEEXCHHC BCD*8.7 Bank Exchange Rate
SWOVRDRATE Integer Bank Rate Overridden List:2 entries
0 = No
1 = Yes
TEXTRETRN String*60 Reason for Reversal
AMTROUNDER BCD*10.3 Amount of Rounding Error
DATERATE Date Bank Rate Date
CNTFISCYR String*4 Fiscal Year Mask: %04D
CNTFISCPER String*2 Fiscal Period Mask: %02D
TEXTPAYOR String*60 Remit To
CNTBTCH BCD*5.0 Batch Number
CNTITEM BCD*4.0 Entry Number
SWCHKCLRD Integer Check Cleared List:3 entries
0 = Outstanding
1 = Cleared
2 = Reversed
AMTRMITHC BCD*10.3 Check Amount Func. Curr.
AMTADJ BCD*10.3 Amount Adjusted
DATECLRD Date Date Cleared
DATERVRSD Date Date Reversed
TRXTYPETXT Integer Document Type List:3 entries
5 = Unapplied Cash
10 = Prepayment
11 = Payment
IDINVC String*22 Document No.
RATEOP Integer Rate Operator
PAYMTYPE Integer Payment Type List:4 entries
1 = Cash
2 = Check
3 = Credit Card
4 = Other
CUID Long Client Unique ID
DRILLAPP String*2 Drill Down Application Source Mask: %-2A
DRILLTYPE Integer Drill Down Type
DRILLDWNLK BCD*10.0 Drill Down Link Number
IDACCT String*45 G/L Account Mask: %-45C
SWNONRCVBL Integer Misc. Payment Flag
SWJOB Integer Job Related List:2 entries
0 = No
1 = Yes
IDINVCMTCH String*22 Invoice Number
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
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
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
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
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
CNTACC Long Number of Advance Credit Claims
AMTACCTC BCD*10.3 Total Advance Credit Claim
AMTACCHC BCD*10.3 Func. Total Advance Credit Claim
DATEBUS Date Posting Date
AMTWHT1TC BCD*10.3 Tax Withheld 1
AMTWHT2TC BCD*10.3 Tax Withheld 2
AMTWHT3TC BCD*10.3 Tax Withheld 3
AMTWHT4TC BCD*10.3 Tax Withheld 4
AMTWHT5TC BCD*10.3 Tax Withheld 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

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