View: Payment Advices

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

Keys: 1

Title Fields

Advice Primary Key SRCEAPPLAPPLRUNNBANKCODESORTCODEPAYEECDEUNIQCNTR

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