# Table: Posted Payments

Table: APPYM
View: AP0029
Record length: 1077
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: 109

Field | Type | Title | Presentation
--- | --- | --- | ---
IDBANK | String*8 | Bank Code | Mask: %-8N
IDVEND | String*12 | Vendor Number | Mask: %-12C
IDRMIT | String*12 | Check Number | Mask: %-12D
LONGSERIAL | Long | 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
CCTYPE | String*12 | C.C. Type | Mask: %-12N
CCNUMBER | Binary*32 | Encrypted C.C. Number |
CCNAME | String*60 | C.C. Name |
CCAUTHCODE | String*20 | C.C. Auth. Code |
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 |

This page was generated on 2008-May-01

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