Table: Applied Receipts/Adjustments

Table: ARTCP
View: AR0044
Record length: 412
Flags: A R 

Keys: 3

Title  Flags  Fields
Receipt Applied Seq. Number  CODEPAYM, CNTBTCH, CNTITEM, CNTLINE
Customer, Doc. and Payment No.  D M  IDCUST, IDINVC, CNTPAYM
Batch/Entry/Doc. No./Pmt. No.  M  CODEPAYM, CNTBTCH, CNTITEM, IDINVC, CNTPAYM

Fields: 40

Field  Type  Title  Presentation 
CODEPAYM  String*2  Batch Type  Mask: %-2N
CNTBTCH  BCD*5.0  Batch Number   
CNTITEM  BCD*4.0  Entry Number   
CNTLINE  BCD*3.0  Line Number   
AUDTDATE  Date     
AUDTTIME  Time     
AUDTUSER  String*8     
AUDTORG  String*6     
IDCUST  String*12  Customer Number  Mask: %-12C
IDINVC  String*22  Document Number  Mask: %-22C
CNTPAYM  BCD*3.0  Payment Number   
TRXTYPE  Integer  Transaction Type  List: 5 entries
2=Unapplied Cash - Posted
51=Receipt - Posted
57=Prepayment - Posted
81=Adjustment - Posted
80=Write-Off - Posted
PYMTRESL  String*2  Payment Resolution   
AMTPAYM  BCD*10.3  Cust. Receipt Amount   
AMTERNDISC  BCD*10.3  Cust. Discount Amount Taken   
CNTLASTSEQ  BCD*3.0  Next Adj. Seq. No.   
AMTADJTOT  BCD*10.3  Cust. Adjustment Total   
CNTADJ  BCD*5.0  Adjustment Number   
TEXTADJ  String*60  Description   
GLREF  String*60  Reference   
IDPPD  String*22  Generated PP/UC No.   
IDDOCMTCH  String*22  PP Matching Doc. No.   
CDAPPLYTO  Integer  PP Matching Doc. Type  List: 5 entries
1=(None)
2=Document Number
3=PO Number
4=Order Number
9=Shipment Number
AMTDBADJTC  BCD*10.3  Total Cust. Debit Amount   
AMTCRADJTC  BCD*10.3  Total Cust. Credit Amount   
DOCTYPE  Integer  Document Type   
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
RTGTOTDBTC  BCD*10.3  Rtg. Debit Amt. - Cust. Curr   
RTGTOTCRTC  BCD*10.3  Rtg. Credit Amt. - Cust. Curr   
RTGAMT  BCD*10.3  Retainage Amount   
RTGDATEDUE  Date  Retainage Due Date   
RTGTERMS  String*6  Retainage Terms Code  Mask: %-6N
SWRTGRATE  Integer  Retainage Exchange Rate  List: 2 entries
0=Use Original Document Exchange Rate
1=Use Current Exchange Rate
AMTPAYMHC  BCD*10.3  Func. Receipt Amount   
AMTDISCHC  BCD*10.3  Func. Total Discount Amount   
AMTADJHC  BCD*10.3  Func. Total Adjustment Amount   
RTGAMTHC  BCD*10.3  Func. Retainage Amount   

This page was generated on 2008-May-01

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