Table: Payments/Adjustments

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

Keys: 1


Title  Flags  Fields

Batch Payments Primary Key   BTCHTYPE, CNTBTCH, CNTENTR

Fields: 60


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   
TEXTRMIT  String*30  Entry Description   
NAMERMIT  String*30  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  Exchange Rate Vendor to Func.   
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.   
CODEPAYM  String*6  Reserved   
CODECURN  String*3  Vendor Currency Code  Mask: %-3N
RATETYPEHC  String*2  Bank Rate Type  Mask: %-2N
RATEEXCHHC  BCD*8.7  Exchange Rate Bank to Func.   
SWRATEHC  Integer  Bank Rate Overridden  List: 2 entries
0=No
1=Yes
RMITTYPE  Integer  Payment Type  List: 5 entries
1=Payment
2=Prepayment
3=Apply Document
4=Misc. Payment
5=Adjustment
DOCTYPE  Integer  Document Type  List: 7 entries
1=None
2=Invoice
3=PO Number
4=Sales Order No.
5=Apply Prepayment
6=Apply Cash On Account
7=Apply Credit Memo
CNTLSTLINE  BCD*3.0  Last Line Number   
FISCYR  String*4  Fiscal Year  Mask: %04D
FISCPER  String*2  Fiscal Period  Mask: %02D
DATERATETC  Date  Rate Date Vendor to Func.   
RATETYPETC  String*2  Vendor Rate Type  Mask: %-2N
AMTADJTCUR  BCD*10.3  Total Payment Adj. Vendor Curr.   
DATERATEHC  Date  Rate Date Bank to Func.   
REMREAPLTC  BCD*10.3  Total Reapply Remaining Vendor   
ADJTOTDBHC  BCD*10.3  Adj. Debit Amt. Func. Curr.   
AMTRMITHC  BCD*10.3  Check Amount Func. Curr.   
DOCNBR  String*22  Document Match Id  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*30  Remit Reference Text   
CLASS1099  String*6  Reserved   
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*30  Address Line 1   
TEXTSTRE2  String*30  Address Line 2   
TEXTSTRE3  String*30  Address Line 3   
TEXTSTRE4  String*30  Address Line 4   
NAMECITY  String*20  City   
CODESTTE  String*20  State   
CODEPSTL  String*15  Zip/Postal Code   
CODECTRY  String*20  Country   
CHECKLANG  String*3  Payment Language  List: 5 entries
1=ENG
2=FRA
3=ESN
4=AUS
5=MEX
OPERBANK  String*1  Bank Rate Operator   
OPERVEND  String*1  Vendor Rate Operator   
ADJTOTDBTC  BCD*10.3  Adj. Debit Amt. Vendor Curr.   
ADJTOTCRTC  BCD*10.3  Adj. Credit Amt. Vendor Curr.   
DATEACTVPP  Date  Prepay Activation Date   

This page was generated on 2003-Apr-12

Copyright © 2002 ACCPAC International, Inc. All rights reserved.