View: Posted Payments

RotoID: AP0029
Table: APPYM
Protocol: Flat
DLL:APPYM

Keys: 5

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

Fields: 116

Field Index Type Title Attributes Presentation
IDBANK 1 String*8 Bank Code E A K R  Mask: %-8N
IDVEND 2 String*12 Vendor Number E A K R  Mask: %-12C
IDRMIT 3 String*18 Check Number E A K R  Mask: %-18D
LONGSERIAL 4 ??? Check Serial Number E A K R 
DATERMIT 5 Date Check Date E A K R 
DATEBATCH 7 Date Batch Date E A 
AMTRMITTC 8 BCD*10.3 Check Amount Vend. Curr. E A 
AMTPAYM 9 BCD*10.3 Payment Amount E A 
AMTDISC 10 BCD*10.3 Discount Amount E A 
PAYMCODE 11 String*12 Payment Code E A  Mask: %-12N
CODECURN 12 String*3 Currency Code E A  Mask: %-3N
IDRATETYPE 13 String*2 Bank Rate Type E A  Mask: %-2N
RATEEXCHHC 14 BCD*8.7 Bank Exchange Rate E A 
SWOVRDRATE 15 Integer Bank Rate Overridden E A  List:2 entries
0 = No
1 = Yes
TEXTRETRN 16 String*60 Reason for Reversal E A 
AMTROUNDER 19 BCD*10.3 Amount of Rounding Error E A 
DATERATE 20 Date Bank Rate Date E A 
CNTFISCYR 21 String*4 Fiscal Year E A  Mask: %04D
CNTFISCPER 22 String*2 Fiscal Period E A  Mask: %02D
TEXTPAYOR 23 String*60 Remit To E A 
CNTBTCH 24 BCD*5.0 Batch Number E A 
CNTITEM 25 BCD*4.0 Entry Number E A 
SWCHKCLRD 26 Integer Check Cleared E A  List:3 entries
0 = Outstanding
1 = Cleared
2 = Reversed
AMTRMITHC 27 BCD*10.3 Check Amount Func. Curr. E A 
AMTADJ 28 BCD*10.3 Amount Adjusted E A 
DATECLRD 29 Date Date Cleared E A 
DATERVRSD 30 Date Date Reversed E A 
TRXTYPETXT 31 Integer Document Type E A  List:3 entries
5 = Unapplied Cash
10 = Prepayment
11 = Payment
IDINVC 32 String*22 Document No. E A 
RATEOP 33 Integer Rate Operator E A 
PAYMTYPE 34 Integer Payment Type E A  List:4 entries
1 = Cash
2 = Check
3 = Credit Card
4 = Other
CUID 39 Long Client Unique ID E A 
DRILLAPP 40 String*2 Drill Down Application Source E A  Mask: %-2A
DRILLTYPE 41 Integer Drill Down Type E A 
DRILLDWNLK 42 BCD*10.0 Drill Down Link Number E A 
IDACCT 43 String*45 G/L Account E A  Mask: %-45C
SWNONRCVBL 44 Integer Misc. Payment Flag E A 
SWJOB 45 Integer Job Related E A  List:2 entries
0 = No
1 = Yes
IDINVCMTCH 46 String*22 Invoice Number E A 
SWTXAMTCTL 47 Integer Calculate Tax Amount Control E A  List:3 entries
0 = Enter
1 = Calculate
2 = Distribute
SWTXBSECTL 48 Integer Calculate Tax Base Control E A  List:3 entries
0 = Enter
1 = Calculate
2 = Distribute
CODETAXGRP 49 String*12 Tax Group E A  Mask: %-12N
CODETAX1 50 String*12 Tax Authority 1 E A 
CODETAX2 51 String*12 Tax Authority 2 E A 
CODETAX3 52 String*12 Tax Authority 3 E A 
CODETAX4 53 String*12 Tax Authority 4 E A 
CODETAX5 54 String*12 Tax Authority 5 E A 
TAXCLASS1 55 Integer Tax Class 1 E A 
TAXCLASS2 56 Integer Tax Class 2 E A 
TAXCLASS3 57 Integer Tax Class 3 E A 
TAXCLASS4 58 Integer Tax Class 4 E A 
TAXCLASS5 59 Integer Tax Class 5 E A 
TXBSE1TC 60 BCD*10.3 Tax Base 1 E A 
TXBSE2TC 61 BCD*10.3 Tax Base 2 E A 
TXBSE3TC 62 BCD*10.3 Tax Base 3 E A 
TXBSE4TC 63 BCD*10.3 Tax Base 4 E A 
TXBSE5TC 64 BCD*10.3 Tax Base 5 E A 
TXAMT1TC 65 BCD*10.3 Tax Amount 1 E A 
TXAMT2TC 66 BCD*10.3 Tax Amount 2 E A 
TXAMT3TC 67 BCD*10.3 Tax Amount 3 E A 
TXAMT4TC 68 BCD*10.3 Tax Amount 4 E A 
TXAMT5TC 69 BCD*10.3 Tax Amount 5 E A 
TXTOTTC 70 BCD*10.3 Tax Total E A 
AMTNETTC 71 BCD*10.3 Dist. Amount Net of Taxes E A 
TXALLTC 72 BCD*10.3 Tax Allocated Total E A 
TXEXPTC 73 BCD*10.3 Tax Expensed Total E A 
TXRECTC 74 BCD*10.3 Tax Recoverable Total E A 
CODECURNRC 75 String*3 Tax Reporting Currency Code E A  Mask: %-3N
SWTXCTLRC 76 Integer Tax Reporting Calculate Method E A  List:3 entries
0 = Enter
1 = Calculate
2 = Distribute
RATERC 77 BCD*8.7 Tax Reporting Exchange Rate E A 
RATETYPERC 78 String*2 Tax Reporting Rate Type E A  Mask: %-2N
RATEDATERC 79 Date Tax Reporting Rate Date E A 
RATEOPRC 80 Integer Tax Reporting Rate Operator E A 
TXAMT1RC 81 BCD*10.3 Tax Reporting Amount 1 E A 
TXAMT2RC 82 BCD*10.3 Tax Reporting Amount 2 E A 
TXAMT3RC 83 BCD*10.3 Tax Reporting Amount 3 E A 
TXAMT4RC 84 BCD*10.3 Tax Reporting Amount 4 E A 
TXAMT5RC 85 BCD*10.3 Tax Reporting Amount 5 E A 
TXTOTRC 86 BCD*10.3 Tax Reporting Total E A 
TXALLRC 87 BCD*10.3 Tax Reporting Allocated Total E A 
TXEXPRC 88 BCD*10.3 Tax Reporting Expensed Total E A 
TXRECRC 89 BCD*10.3 Tax Reporting Recoverable Total E A 
TXBSE1HC 90 BCD*10.3 Func. Tax Base 1 E A 
TXBSE2HC 91 BCD*10.3 Func. Tax Base 2 E A 
TXBSE3HC 92 BCD*10.3 Func. Tax Base 3 E A 
TXBSE4HC 93 BCD*10.3 Func. Tax Base 4 E A 
TXBSE5HC 94 BCD*10.3 Func. Tax Base 5 E A 
TXAMT1HC 95 BCD*10.3 Func. Tax Amount 1 E A 
TXAMT2HC 96 BCD*10.3 Func. Tax Amount 2 E A 
TXAMT3HC 97 BCD*10.3 Func. Tax Amount 3 E A 
TXAMT4HC 98 BCD*10.3 Func. Tax Amount 4 E A 
TXAMT5HC 99 BCD*10.3 Func. Tax Amount 5 E A 
TXTOTHC 100 BCD*10.3 Func. Tax Total E A 
AMTNETHC 101 BCD*10.3 Func. Dist. Amount Net of Taxes E A 
TXALLHC 102 BCD*10.3 Func. Tax Allocated Total E A 
TXEXPHC 103 BCD*10.3 Func. Tax Expensed Total E A 
TXRECHC 104 BCD*10.3 Func. Tax Recoverable Total E A 
CNTACC 105 Long Number of Advance Credit Claims E A C 
AMTACCTC 106 BCD*10.3 Total Advance Credit Claim E A C 
AMTACCHC 107 BCD*10.3 Func. Total Advance Credit Claim E A C 
DATEBUS 108 Date Posting Date E A 
AMTWHT1TC 109 BCD*10.3 Tax Withheld 1 E A 
AMTWHT2TC 110 BCD*10.3 Tax Withheld 2 E A 
AMTWHT3TC 111 BCD*10.3 Tax Withheld 3 E A 
AMTWHT4TC 112 BCD*10.3 Tax Withheld 4 E A 
AMTWHT5TC 113 BCD*10.3 Tax Withheld 5 E A 
AMTCXBS1TC 114 BCD*10.3 Reverse Charges Base 1 E A 
AMTCXBS2TC 115 BCD*10.3 Reverse Charges Base 2 E A 
AMTCXBS3TC 116 BCD*10.3 Reverse Charges Base 3 E A 
AMTCXBS4TC 117 BCD*10.3 Reverse Charges Base 4 E A 
AMTCXBS5TC 118 BCD*10.3 Reverse Charges Base 5 E A 
AMTCXTX1TC 119 BCD*10.3 Reverse Charges Amount 1 E A 
AMTCXTX2TC 120 BCD*10.3 Reverse Charges Amount 2 E A 
AMTCXTX3TC 121 BCD*10.3 Reverse Charges Amount 3 E A 
AMTCXTX4TC 122 BCD*10.3 Reverse Charges Amount 4 E A 
AMTCXTX5TC 123 BCD*10.3 Reverse Charges Amount 5 E A 

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