# View: Posted Payments

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

## Compositions: 0

## 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: 105

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*12 | Check Number | E A K R | Mask: %-12D
LONGSERIAL | 4 | Long | 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
CCTYPE | 35 | String*12 | C.C. Type | E A | Mask: %-12N
CCNUMBER | 36 | Binary*32 | Encrypted C.C. Number | E A |
CCNAME | 37 | String*60 | C.C. Name | E A |
CCAUTHCODE | 38 | String*20 | C.C. Auth. Code | E A |
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 |

This page was generated on 2008-May-01

Copyright © 2001–2008 Sage Software, Inc. All rights reserved.