View: Payment Advices

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

Compositions: 0

Title	Fields

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

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