# Table: Payment Advices

Table: ARADV
View: AR0460
Record length: 640
Flags: A R

## Keys: 1

Title | Flags | Fields
--- | --- | ---
Advice Primary Key |  | SRCEAPPL, APPLRUNN, BANKCODE, SORTCODE, PAYEECDE, UNIQCNTR

## Fields: 27

Field | Type | Title | Presentation
--- | --- | --- | ---
SRCEAPPL | String*2 | Source Application | Mask: %-2A
APPLRUNN | String*10 | Application Run Number |
BANKCODE | String*8 | Bank Code | Mask: %-8N
SORTCODE | BCD*10.0 | Sort Code |
PAYEECDE | String*12 | Payee Code |
UNIQCNTR | BCD*4.0 | Unique Counter |
AUDTDATE | Date |  |
AUDTTIME | Time |  |
AUDTUSER | String*8 |  |
AUDTORG | String*6 |  |
REFNUM | String*60 | Reference Number |
INVCDATE | Date | Invoice Date |
GROSSAMT | BCD*10.3 | Gross Amount |
DISCTAKN | BCD*10.3 | Discount Taken |
NETAMTPD | BCD*10.3 | Net Amount Paid |
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 |
CURCODE | String*3 | Currency |
CURDEC | Integer | Currency Decimals |
GLREF | String*60 | G/L Reference |
GLDESC | String*60 | G/L Description |

This page was generated on 2008-May-01

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