A_BACS_TRANSACTION_LINES

Name: A_BACS_TRANSACTION_LINES
Creator: Ryan Brents
License: https://creativecommons.org/licenses/by/4.0/

Archive BACS Transaction Lines

tableFINBACS

A_BACS_TRANSACTION_LINES — Archive BACS Transaction Lines. FIN table in the standard Ross ERP 8.0 schema: 22 columns, used by 2 programs. Columns, data types, keys, foreign keys and relationships.

Open A_BACS_TRANSACTION_LINES in the interactive Data Dictionary →

Part of BACS tables & objects · all tables, views & procedures

Columns

#	Column	Type	Description
1	GEM_DBKEY	int	GEMBASE internal surrogate primary key: a system-generated unique row identifier (the database key). Not a business field; every table carries one.
2	ARCHIVE_ID	varchar(1)	Prefix Fields for Archive Tables
3	BACS_NUMBER	varchar(6)	BACS Number
4	SYSTEM_ID	varchar(4)	System Identifier
5	USER_REFERENCE	varchar(6)	User Applications Reference
6	TAPE_NUMBER	varchar(6)	Transaction Tape Number
7	DESTINATION_BANK_SORT_CODE	varchar(6)	Destination Bank Sort Code
8	DESTINATION_BANK_ACCOUNT	varchar(8)	Destination Bank Account Number
9	BACS_ACCOUNT_TYPE	varchar(1)	BACS Account Type
10	TRANSACTION_CODE	varchar(2)	BACS Transaction Code
11	BACS_AMOUNT	varchar(11)	Amount in pence
12	DESTINATION_ACCOUNT_NAME	varchar(18)	Destination Account Name
13	REDIRECTION_FLAG	varchar(1)	Redirection Flag
14	RECIPIENTS_REFERENCE	varchar(18)	Recipients Reference
15	RECIPIENTS_ACCOUNT_NAME	varchar(18)	Recipient Account Name
16	PAYMENT_DATE	datetime	Payment Date
17	BACS_PAYMENT_DATE	varchar(11)	A text field written to the BACS tape creation program
18	USERNAME	varchar(20)	Username
19	SYSTEM_DATE	datetime	System Date Transaction Made
20	ARCHIVE_DATE	datetime	Archive Date
21	ARCHIVE_USERNAME	varchar(20)	Username recorded when the row was moved to the archive.
22	GEM_ARCHIVE_FLAG	varchar(20)	System flag indicating whether the row has been archived by the GEMBASE archive process.