Table: Payments

Table: ARPYM
View: AR0139
Record Length: 466

Flags: A R 

Keys: 3

Title Flags Fields
Customer, Doc. No., Seq. No. IDCUST, IDINVC, CNTSEQ
Bank, Check Number D M  IDBANK, CHECKNUM, LONGSERIAL
Customer, Client Unique ID M  IDCUST, CUID

Fields: 44

Field Type Title Presentation
IDCUST String*12 Customer Number Mask: %-12C
IDINVC String*22 Document Number Mask: %-22C
CNTSEQ Long Seq. No.
AUDTDATE Date
AUDTTIME Time
AUDTUSER String*8
AUDTORG String*6
PAYMCODE String*12 Payment Code Mask: %-12N
PAYMTYPE Integer Payment Type List:4 entries
1 = Cash
2 = Check
3 = Credit Card
5 = SPS Credit Card
DOCDATE Date Document Date
FISCYR String*4 Fiscal Year Mask: %04D
FISCPER String*2 Fiscal Period Mask: %02D
IDBANK String*8 Bank Code Mask: %-8N
CHECKNUM BCD*8.0 Check Number
LONGSERIAL ??? Check Serial Number
IDACCT String*45 GL Account to be Credited Mask: %-45C
NAMERMIT String*60 Name on Check
CHECKLANG String*3 Check Language
CODECURN String*3 Payment Currency Mask: %-3N
RATETYPE String*2 Rate Type Mask: %-2N
RATEDATE Date Rate Date
RATEEXCH BCD*8.7 Exchange Rate
RATEOP Integer Rate Operator List:2 entries
1 = Multiply
2 = Divide
SWRATE Integer Rate Override Flag List:2 entries
0 = No
1 = Yes
AMTPC BCD*10.3 Payment Amount
AMTTC BCD*10.3 Customer Amount
AMTHC BCD*10.3 Functional Amount
POSTSEQNBR BCD*5.0 Posting Sequence Number
CNTBTCH BCD*5.0 Batch Number
CNTITEM BCD*4.0 Entry Number
SWSTATUS Integer Payment Status List:3 entries
0 = Outstanding
1 = Cleared
2 = Reversed
DATECLRD Date Date Cleared
DATERVRSD Date Date Reversed
TEXTRETRN String*60 Reason for Return
TRXTYPETXT Integer Document Type List:1 entries
19 = Refund
CUID Long Client Unique ID
DATEBUS Date Posting Date
CCTRANID String*36 Credit Card Transaction Number
PROCESSCOD String*12 Processing Code
AMTWHT1TC BCD*10.3 Tax Withheld 1
AMTWHT2TC BCD*10.3 Tax Withheld 2
AMTWHT3TC BCD*10.3 Tax Withheld 3
AMTWHT4TC BCD*10.3 Tax Withheld 4
AMTWHT5TC BCD*10.3 Tax Withheld 5

This page was generated on 2023-Aug-31

© 2023 Sage Software, Inc. All rights reserved. Reproduction of part or all of the contents in any form is prohibited unless for personal use. None of the content of this article may be copied or otherwise incorporated into any other document, publication or other work in any form (whether written, electronic or other format).

Sage Software, Inc. makes no warranties, representations or undertakings about any of the content of articles (including, without limitation, any as to the quality, accuracy, completeness or fitness for any particular purpose of such content).