Table: Payments/Adjustments

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

Keys: 1


Title  Flags  Fields

Batch Payments Primary Key   BTCHTYPE, CNTBTCH, CNTENTR

Fields: 64


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*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.   
CODEPAYM  String*6  Reserved   
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 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 No.
3=PO Number
4=Sales Order No.
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 C   
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*60  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*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: 5 entries
1=ENG
2=FRA
3=ESN
4=AUS
5=MEX
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   

This page was generated on 2003-May-05

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