View: Bank Entries Journal Header

RotoID: BK0665
Table: BKJENTH
Protocol: Header
DLL: BKJENTH

Compositions: 2

RotoID	Tables	Title	DLL

BK0020	BKJCTL	Bank Posting Journal Control	BKJCTL
BK0660	BKJENTD	Bank Entries Journal Detail	BKJENTD

Keys: 1

Title	Fields

Bank Entry by Posting Sequence	PSTSEQ, SEQUENCENO

Fields: 53

Field	Index	Type	Title	Attributes	Presentation

PSTSEQ	1	BCD*5.0	Posting Sequence	E A K R
SEQUENCENO	2	Long	Sequence Number	E A K R
ENTRYNBR	3	String*22	Bank Entry Number	E A	Mask: %-22C
BANK	4	String*8	Bank Code	E A	Mask: %-8N
TRANSDATE	5	Date	Date Created	E A
TRANSTYPE	6	Integer	Bank Entry Type	E A
REFERENCE	7	String*60	Entry Description	E A
COMMENT	8	String*60	Comment(Reserved)	E A
TOTSRCEAMT	9	BCD*10.3	Total Source Amount	E A
TOTFUNCAMT	10	BCD*10.3	Total Functional Amount	E A
TOTSRCEGRO	11	BCD*10.3	Total Gross Source Amt	E A
TOTFUNCGRO	12	BCD*10.3	Total Gross Functional Amt	E A
RATETYPE	13	String*2	Exchange Rate Type	E A
SRCECURN	14	String*3	Bank Entry Currency	E A
RATEDATE	15	Date	Exchange Rate Date	E A
RATE	16	BCD*8.7	Exchange Rate	E A
RATESPREAD	17	BCD*8.7	Rate Spread	E A
RATEOP	18	Integer	Rate Operation	E A
POSTDATE	19	Date	Bank Entry Date	E A
POSTYEAR	20	String*4	Bank Entry Year	E A
POSTPERIOD	21	Integer	Bank Entry Period	E A
COMPLETED	22	Integer	Completed Status	E A
BIGCOMMENT	23	String*250	Comments	E A
STATUS	24	Integer	Status	E A
RECDATE	25	Date	Reconcilation Date	E A
RECYEAR	26	String*4	Reconcilation Year	E A	Mask: %04D
RECPERIOD	27	Integer	Reconcilation Period	E A
LINES	28	Long	Number of Lines	E A
SERIAL	29	Long	Bank Entry Serial Number	E A
RUNID	30	Long	Run Id	E A
TYPE	31	Integer	Payment Type	E A
CCTYPE	32	String*12	Credit Card Type	E A	Mask: %-12N
CCNUMBER	33	Binary*32	Credit Card Number	E A
CCNAME	34	String*60	Cardholder Name	E A
CCAUTHCODE	35	String*20	Authorization Code	E A
CCEXP	36	Date	Expiry Date	E A
OFXTID	37	String*50	OFX Transaction ID	E A
ENTRYTYPE	38	Integer	Entry Type	E A
DSETCODE	39	String*6	Distribution Set	E A	Mask: %-6N
BANKD	40	String*60	Bank Name	E A
BKACCT	41	String*22	Bank Account	E A
BKSTMTCUR	42	String*3	Bank Statement Currency	E A
DSETCODED	43	String*60	Distribution Set Desc	E A
TOTSTMTAMT	44	BCD*10.3	Total Statement Amount	E A
TRANSCUR	45	String*3	Bank Entry Currency	E A
RECPENT	46	BCD*10.3	Fiscal Entry Amount	E A
RECPENTREC	47	BCD*10.3	Reconciled Entry Amount	E A
DEFENTNUM	48	String*22	Default New Document Number	E A
PROCESSCMD	49	Integer	Process Command	E A
AGERECLD	50	Integer	Aging Recon. days	E A
CCTYPED	51	String*60	Credit Card Type Description	E A
XCCNUMBER	52	String*32	Decrypted Credit Card Number	E A	Mask: %-32D
RETENTNO	53	Integer	Keep Input Entry No.	E A

This page was generated on 2009-Nov-19