A_AR_TRANSACTIONS

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

Archive Accounts Receivable Transactions

tableFINAR

A_AR_TRANSACTIONS — Archive Accounts Receivable Transactions. FIN table in the standard Ross ERP 8.0 schema: 102 columns, used by 8 programs. Columns, data types, keys, foreign keys and relationships.

Open A_AR_TRANSACTIONS in the interactive Data Dictionary →

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

Columns

#	Column	Type	Key	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)	PK	Prefix Fields for Archive Tables
3	COMPANY_CODE	varchar(10)	PK	Company Code
4	DIVISION	varchar(2)	PK	Division
5	TRANSACTION_NUMBER	int	PK	Transaction Number
6	TRANSACTION_TYPE	varchar(2)	PK	Transaction Type
7	CUSTOMER_NUMBER	varchar(8)		Customer Number
8	TRANSACTION_DATE	datetime		Transaction Date
9	SYSTEM_DATE	datetime		System Date Transaction Made
10	PERIOD	smallint		Period Number
11	DUE_DATE	datetime		Due Date
12	YEAR	smallint		Year Number
13	DUE_PERIOD	smallint		Period When Transaction Due
14	DUE_YEAR	smallint		Year When Transaction Due
15	TRANSACTION_DESCRIPTION	varchar(60)		Transaction Description
16	CUSTOMER_REFERENCE	varchar(25)		Customer Reference
17	CREDIT_TERMS_CODE	varchar(6)		Credit Terms Code
18	TAX	numeric(20,2)		Transaction Tax
19	DOCUMENT_REFERENCE	varchar(15)		Document Reference (Voucher No, etc.)
20	DISCOUNT	numeric(20,2)		Discount Allowed
21	FREIGHT	numeric(20,2)		Freight Value
22	COST	numeric(20,2)		Cost of Transaction
23	DORC_INDICATOR	smallint		Debit or Credit Indicator
24	ALLOCATION_DATE	datetime		Date of Last Allocation
25	CASH_DISCOUNT	numeric(20,2)		Cash Discount Taken
26	DISCOUNT_DATE	datetime		Cash Discount Date
27	DISCOUNT_ALLOCATED_TO_DATE	numeric(20,2)
28	DEBT_LETTER	varchar(6)		Debt Letter
29	DEBT_LETTER_LEVEL	varchar(1)		Debt Letter Level
30	COST_CENTER	varchar(3)		Cost Center Code
31	BANK_CODE	varchar(6)		Bank Code
32	BATCH_NUMBER	int		Run Number
33	BATCH_SEQUENCE_NUMBER	smallint		Batch Sequence Number
34	STATEMENT_ACCOUNT	varchar(8)		Payment Customer Number
35	ORIG_INVOICE_DIVISION	varchar(2)		Originating Invoice Division
36	PID	varchar(8)		Processor Identification
37	TEMP_ALLOC_AMOUNT	numeric(20,2)		Temporary Cash Allocation Amount
38	TEMP_ALLOC_DISC	numeric(20,2)		Temporary Cash Discount Allocation Amount
39	WORK_CR_NUMBER	int
40	DL_RUN_NUMBER	varchar(9)		Debt Letter Run Number
41	LAST_DL_RUN_DATE	datetime		Last DL Run Date
42	TAX_UPDATE_COMPLETE	varchar(1)		Tax Updated to Tax Details
43	MATCHED	varchar(1)		Bank Reconciliation Matched Indicator
44	LAST_ALLOCATION_YEAR	smallint
45	LAST_ALLOCATION_PERIOD	smallint
46	INTERNAL_COMMENTS	text		Internal Comments for narative diary
47	CREDIT_STATUS_CODE	varchar(6)		Credit Status Code
48	USERNAME	varchar(20)		Username
49	INVOICE_METHOD	varchar(2)		Invoicing Method
50	CR_SEARCH_KEY	int
51	GL_POSTINGS_IN_BATCH	varchar(1)		Gl Postings included in a batch
52	JOURNAL_NUMBER	int		Journal Number
53	JOURNAL_LINE	smallint		Journal Line
54	LAST_DL_LEVEL	varchar(1)
55	ARCHIVE_DATE	datetime		Archive Date
56	ARCHIVE_USERNAME	varchar(20)		Username recorded when the row was moved to the archive.
57	AR_SOURCE_TRANSACTION	int		Source transaction number
58	AR_TRAN_TOTAL_BASE	numeric(20,2)		Total Transaction Value in Base Currency
59	AR_TRAN_TOTAL_CURRENCY	numeric(20,2)		Total Transaction Value in Currency
60	AR_ALLOCATED_BASE	numeric(20,2)		Allocated to Date in Base Currency
61	AR_ALLOCATED_CURRENCY	numeric(20,2)		Allocated to Date in Currency
62	SYS_CURRENCY_CODE	varchar(6)		Currency Code
63	SYS_CURRENCY_RATE	numeric(20,12)		Currency Rate
64	SYS_RATE_AUTHORITY	varchar(6)		Currency Rate Authority
65	SYS_RATE_TYPE	varchar(6)		Currency Rate Type
66	SYS_CURRENCY_FIXED_FLAG	varchar(1)		Currency Rate Fixed Flag
67	SYS_CURRENCY_RATIO_INDIC	varchar(1)		Ratio Indicator
68	SYS_BASE_CURRENCY_CODE	varchar(6)
69	SYS_CURRENCY_GAIN_REALISED	numeric(20,2)		Difference gained during currency conversion.
70	SYS_CURRENCY_LOSS_REALISED	numeric(20,2)		Difference Lost during currency conversion.
71	AR_DISCOUNT_ALLOCATED	numeric(20,2)
72	SYS_CURRENCY_DATE	datetime		Currency Date
73	SALESPERSON_CODE	varchar(8)		Salesperson Code
74	CONTROL_SHORT_CODE	varchar(6)
75	CONTROL_ACCOUNT_NUMBER	varchar(50)
76	SYS_CURRENCY_2_FIXED_FLAG	varchar(1)		Currency Rate Fixed
77	SYS_CURRENCY_2_RATE	numeric(20,12)		Second Base Currency Rate
78	SYS_CURRENCY_2_RATIO_INDIC	varchar(1)		Ratio Indicator for Second Base
79	SYS_RATE_2_AUTHORITY	varchar(6)		Second Base Currency Rate Authority
80	SYS_RATE_2_TYPE	varchar(6)		Second Base Currency Rate Type
81	AR_ALLOCATED_2_BASE	numeric(20,2)		Allocated to Date in Second Base Currency
82	AR_TRAN_TOTAL_2_BASE	numeric(20,2)		Total Transaction Value in Second Base Currency
83	PAY_STATEMENT_RUN_NUMBER	int		Payment Statement Run Number
84	PAY_STATEMENT_NUMBER	int		Payment Statement Number
85	AR_DRAFT_RUN_NUMBER	int		Draft Receipt Run Number
86	SYS_CURR_UNREALISED_GAIN	numeric(20,2)		Unrealized Currency Gain
87	SYS_CURR_UNREALISED_LOSS	numeric(20,2)		Unrealized Currency Loss
88	FROM_TRANS_NUMBER	int
89	TO_TRANS_NUMBER	int
90	AR_DRAFT_PAYMENT_TYPE	varchar(3)
91	CI_TRANSACTION_NUMBER	int
92	CI_CUTOFF_DATE	datetime
93	BB_STATUS_FLAG	varchar(1)		Billback Status Flag
94	REASON_CODE	varchar(6)		Reason Code
95	BANK_STATEMENT_NUMBER	varchar(6)		Bank Statement Number
96	BANK_STATEMENT_SEQ	int		Bank Statement Number Sequence
97	GEM_ARCHIVE_FLAG	varchar(20)		System flag indicating whether the row has been archived by the GEMBASE archive process.
98	SYS_CURRENCY_DIFF_REALISED	computed
99	AR_OS_BALANCE_BASE	computed
100	AR_OS_BALANCE_CURRENCY	computed
101	AR_OS_BALANCE_2_BASE	computed
102	SYS_CURR_VAR_UNREALISED	computed