# Table: Payments/Adjustments

Table: APTCR
View: AP0031
Record length: 1676
Flags: A R

## Keys: 1

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

## Fields: 155

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*12 | Check Number | Mask: %-12D
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 | Long | 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
CCTYPE | String*12 | C.C. Type | Mask: %-12N
CCNUMBER | Binary*32 | Encrypted C.C. Number |
CCNAME | String*60 | C.C. Name |
CCEXP | Date | C.C. Expiry Date |
CCAUTHCODE | String*20 | C.C. Auth. Code |
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

This page was generated on 2008-May-01

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