Table: Applied Payments

Table: APTCP
View: AP0033
Record length: 332
Flags: A R 

Keys: 3


Title  Flags  Fields
Batch Number / Entry Number   BATCHTYPE, CNTBTCH, CNTRMIT, CNTLINE
Vendor Number / Document Number   D M  IDVEND, IDINVC, CNTPAYM
Batch Type / Batch Number   M  BATCHTYPE, CNTBTCH, CNTRMIT, IDINVC, CNTPAYM

Fields: 30


Field  Type  Title  Presentation 
BATCHTYPE  String*2  Batch Type  Mask: %-2N
CNTBTCH  BCD*5.0  Batch Number   
CNTRMIT  BCD*4.0  Entry Number   
CNTLINE  BCD*3.0  Line Number   
AUDTDATE  Date     
AUDTTIME  Time     
AUDTUSER  String*8     
AUDTORG  String*6     
IDVEND  String*12  Vendor Number  Mask: %-12C
IDINVC  String*22  Document Number  Mask: %-22C
CNTPAYM  BCD*3.0  Payment Number   
TRXTYPE  Integer  Transaction Type  List: 3 entries
51=Payment - Posted
57=Prepayment - Posted
81=Adjustment - Posted
PYMTRESL  String*2  Payment Resolution  Mask: %-2N
AMTPAYM  BCD*10.3  Payment Amount   
AMTERNDISC  BCD*10.3  Discount Amount Taken   
CNTLASTSEQ  BCD*3.0  Next Adj. Seq. No.   
AMTADJTOT  BCD*10.3  Adjustments Total   
CNTADJ  BCD*5.0  Generated Adjustment Number   
TEXTADJ  String*60  G/L Description   
GLREF  String*60  G/L Reference   
IDPPD  String*22  Generated PP No.  Mask: %-22C
IDDOCMTCH  String*22  PP Matching Doc. No.  Mask: %-22C
CDAPPLYTO  Integer  PP Matching Doc. Type  List: 4 entries
1=(None)
2=Document No.
3=PO Number
4=Sales Order No.
DATEACTVPP  Date  Activation Date   
ADJTOTDBTC  BCD*10.3  Adj. Debit Amt. - Vend. Curr   
ADJTOTCRTC  BCD*10.3  Adj. Credit Amt. - Vend. Curr   
SWJOB  Integer  Job Related  List: 2 entries
0=No
1=Yes
AMTPAYMTOT  BCD*10.3  Job Total Payment Amount   
AMTDISCTOT  BCD*10.3  Job Total Discount Amount   
APPLYMETH  Integer  Job Apply Method  List: 2 entries
0=Prorate by Amount
1=Top Down

This page was generated on 2003-May-05

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