View: Payment Advices

RotoID: AP0060
Table: APADV
Protocol: Flat
DLL:APADV

Keys: 1

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

Fields: 25

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

This page was generated on 2022-Aug-18

© 2021 Sage Software, Inc. All rights reserved. Reproduction of part or all of the contents in any form is prohibited unless for personal use. None of the content of this article may be copied or otherwise incorporated into any other document, publication or other work in any form (whether written, electronic or other format).

Sage Software, Inc. makes no warranties, representations or undertakings about any of the content of articles (including, without limitation, any as to the quality, accuracy, completeness or fitness for any particular purpose of such content).