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 2009-Nov-19

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