Table: Payment Advices

Table: APADV
View: AP0060
Record length: 691
Flags: A R 

Keys: 1

Title  Flags  Fields

Advice Primary Key  SRCEAPPL, APPLRUNN, BANKCODE, SORTCODE, PAYEECDE, UNIQCNTR

Fields: 29

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   
GLACCT  String*45  G/L Account  Mask: %-45C
IDRMITTO  String*6  Remit-To Location  Mask: %-6N

This page was generated on 2008-May-01

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