# View: Payment Advices

RotoID: AR0460
Table: ARADV
Protocol: Flat
DLL: ARADV

## Compositions: 0

## Keys: 1

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

## Fields: 23

Field | Index | Type | Title | Attributes | Presentation
--- | --- | --- | --- | --- | ---
SRCEAPPL | 1 | String*2 | Source Application | E A K R | Mask: %-2A
APPLRUNN | 2 | String*10 | Application Run Number | E A K R |
BANKCODE | 3 | String*8 | Bank Code | E A K R | Mask: %-8N
SORTCODE | 4 | BCD*10.0 | Sort Code | E A K R |
PAYEECDE | 5 | String*12 | Payee Code | E A K R |
UNIQCNTR | 6 | BCD*4.0 | Unique Counter | E A K R |
REFNUM | 7 | String*60 | Reference Number | E A |
INVCDATE | 8 | Date | Invoice Date | E A |
GROSSAMT | 9 | BCD*10.3 | Gross Amount | E A |
DISCTAKN | 10 | BCD*10.3 | Discount Taken | E A |
NETAMTPD | 11 | BCD*10.3 | Net Amount Paid | E A |
TEXTSTRE1 | 12 | String*60 | Address Line 1 | E A |
TEXTSTRE2 | 13 | String*60 | Address Line 2 | E A |
TEXTSTRE3 | 14 | String*60 | Address Line 3 | E A |
TEXTSTRE4 | 15 | String*60 | Address Line 4 | E A |
NAMECITY | 16 | String*30 | City | E A |
CODESTTE | 17 | String*30 | State | E A |
CODEPSTL | 18 | String*20 | Zip/Postal Code | E A |
CODECTRY | 19 | String*30 | Country | E A |
CURCODE | 20 | String*3 | Currency | E A |
CURDEC | 21 | Integer | Currency Decimals | E A |
GLREF | 22 | String*60 | G/L Reference | E A |
GLDESC | 23 | String*60 | G/L Description | E A |

This page was generated on 2008-May-01

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