AR_PAYMENT_STATEMENT_LINES

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

Payment Statement Lines

tableFINAR

AR_PAYMENT_STATEMENT_LINES — Payment Statement Lines. FIN table in the standard Ross ERP 8.0 schema: 57 columns, used by 18 programs. Columns, data types, keys, foreign keys and relationships.

Open AR_PAYMENT_STATEMENT_LINES 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	COMPANY_CODE	varchar(10)	PK	Company Code
3	DIVISION	varchar(2)	PK	Division
4	PAY_STATEMENT_RUN_NUMBER	int	PK	Payment Statement Run Number
5	PAY_STATEMENT_NUMBER	int	PK	Payment Statement Number
6	TRANSACTION_TYPE	varchar(2)		Transaction Type
7	TRANSACTION_NUMBER	int		Transaction Number
8	PAY_STATEMENT_ADDR_CODE	varchar(10)		Statement Address Code
9	CUSTOMER_NUMBER	varchar(8)		Customer Number
10	TRANSACTION_DATE	datetime		Transaction Date
11	SYSTEM_DATE	datetime		System Date Transaction Made
12	USERNAME	varchar(20)		Username
13	PERIOD	smallint		Period Number
14	DUE_DATE	datetime		Due Date
15	YEAR	smallint		Year Number
16	DUE_PERIOD	smallint		Period When Transaction Due
17	DUE_YEAR	smallint		Year When Transaction Due
18	TRANSACTION_DESCRIPTION	varchar(60)		Transaction Description
19	CUSTOMER_REFERENCE	varchar(25)		Customer Reference
20	TAX	numeric(20,2)		Transaction Tax
21	DOCUMENT_REFERENCE	varchar(15)		Document Reference (Voucher No, etc.)
22	DISCOUNT	numeric(20,2)		Discount Allowed
23	COST	numeric(20,2)		Cost of Transaction
24	DORC_INDICATOR	smallint		Debit or Credit Indicator
25	CASH_DISCOUNT	numeric(20,2)		Cash Discount Taken
26	DISCOUNT_DATE	datetime		Cash Discount Date
27	COST_CENTER	varchar(3)		Cost Center Code
28	BATCH_SEQUENCE_NUMBER	smallint		Batch Sequence Number
29	STATEMENT_ACCOUNT	varchar(8)		Payment Customer Number
30	INVOICE_METHOD	varchar(2)		Invoicing Method
31	JOURNAL_NUMBER	int		Journal Number
32	JOURNAL_LINE	smallint		Journal Line
33	AR_TRAN_TOTAL_BASE	numeric(20,2)		Total Transaction Value in Base Currency
34	AR_TRAN_TOTAL_CURRENCY	numeric(20,2)		Total Transaction Value in Currency
35	SYS_CURRENCY_CODE	varchar(6)		Currency Code
36	SYS_CURRENCY_RATE	numeric(20,12)		Currency Rate
37	SYS_RATE_AUTHORITY	varchar(6)		Currency Rate Authority
38	SYS_RATE_TYPE	varchar(6)		Currency Rate Type
39	SYS_CURRENCY_FIXED_FLAG	varchar(1)		Currency Rate Fixed Flag
40	SYS_CURRENCY_RATIO_INDIC	varchar(1)		Ratio Indicator
41	SYS_BASE_CURRENCY_CODE	varchar(6)
42	SYS_CURRENCY_DATE	datetime		Currency Date
43	AR_DRAFT_RUN_NUMBER	int		Draft Receipt Run Number
44	CONTROL_SHORT_CODE	varchar(6)
45	CONTROL_ACCOUNT_NUMBER	varchar(50)
46	AR_DRAFT_PAYMENT_TYPE	varchar(3)
47	SYS_CURRENCY_2_FIXED_FLAG	varchar(1)		Currency Rate Fixed
48	SYS_CURRENCY_2_RATE	numeric(20,12)		Second Base Currency Rate
49	SYS_CURRENCY_2_RATIO_INDIC	varchar(1)		Ratio Indicator for Second Base
50	SYS_RATE_2_AUTHORITY	varchar(6)		Second Base Currency Rate Authority
51	SYS_RATE_2_TYPE	varchar(6)		Second Base Currency Rate Type
52	AR_TRAN_TOTAL_2_BASE	numeric(20,2)		Total Transaction Value in Second Base Currency
53	HEAD_OFFICE	varchar(8)
54	STATUS_FLAG	varchar(1)		Status Flag
55	PAY_STAT_SELECTION_CODE	varchar(6)		Statement Selection Code
56	TRANSACTION_SEQUENCE	smallint	PK	Transaction Sequence
57	GEM_ARCHIVE_FLAG	varchar(20)		System flag indicating whether the row has been archived by the GEMBASE archive process.