# Table: Payments

Table: ARPYM
View: AR0139
Record length: 480
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: 40

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: 3 entries
1 | = | Cash
2 | = | Check
3 | = | 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*5.0 | Check Number |
LONGSERIAL | Long | Check Serial Number |
IDACCT | String*45 | GL Account to be Credited | Mask: %-45C
NAMERMIT | String*60 | Name on Check |
CHECKLANG | String*3 | Check Language |
CCTYPE | String*12 | Credit Card Type | Mask: %-12N
CCNUMBER | Binary*32 | Credit Card Number |
CCNAME | String*60 | Credit Card Name |
CCAUTHCODE | String*20 | Authorization Code |
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 |

This page was generated on 2006-Sep-07

Copyright © 2001–2005 Sage Accpac International, Inc.