Exact Financials

Data dictionary atrss - entry lines - 7.20

#	Field name	Data type	Format	Dec	Default	Label
1	adm_nr	integer	>>>>>9		?	Company
2	fin_yr	integer	9999		?	Financial year
3	period	integer	>>9		?	Period
4	journal_nr	integer	>>9		?	Journal
5	project_linknr	int64	>>>>>>>>>9		0	Project linknumber
6	seqnr_atrsh	integer	>>>>>>9		?	Sequence number
7	linenr_atrss	integer	>>>>>9		?	Line
8	linenr_atrss_user	integer	>>>>>9		0	Line number (User)
9	date	date	99/99/9999			Date
10	entry_nr_type	integer	>>>>>9		1	Entry type
11	entry_nr	int64	>>>>>>>>>>>9		0	Entry number
12	entry_nr_col	int64	>>>>>>>>>>>9		0	Entry number totalled entries
13	acc_nr	character	x(12)			Account
14	descr	character	X(60)			Description
15	debtor	int64	>>>>>>>>>9		0	Debtor
16	creditor	int64	>>>>>>>>>9		0	Creditor
17	invoice_nr_type	integer	>>>>>9		1	Invoice type
18	invoice_nr	int64	>>>>>>>>>>>9		0	Invoice number
19	due_date_invoice	date	99/99/9999			Due date invoice
20	due_date_surch_1	date	99/99/9999			Due date PayCh/Disc 1
21	due_date_surch_2	date	99/99/9999			Due date payment charge/discount
22	vat_code	character	x(3)		0	VAT code
23	amt	decimal	->>>,>>>,>>>,>>>,>>9.99	4	0	Amount
24	vat_amt	decimal	->>>,>>>,>>>,>>>,>>9.99	4	0	VAT amount
25	vat_basis	decimal	->>>,>>>,>>>,>>>,>>9.99	4	0	VAT basis amount
26	curr_code	character	x(3)			Currency
27	exch_rate	decimal	>>>>9.999999	6	0	Exchange rate
28	amt_curr	decimal	->>>,>>>,>>>,>>>,>>9.99	4	0	Currency amount
29	vat_amt_curr	decimal	->>>,>>>,>>>,>>>,>>9.99	4	0	Currency VAT amount
30	diff_code	integer	>>>>>9		1	Difference code
31	asset_code	character	x(12)			Asset
32	XXXarchitect_bytes	character	x(2)			Architect bytes
33	vat_amt_atrsh_curr	decimal	->>>,>>>,>>>,>>>,>>9.99	4	0	Amount revenue
34	amt_atrsh_curr	decimal	->>>,>>>,>>>,>>>,>>9.99	4	0	Amount expenses
35	XXXproject_qty_revenue	decimal	->>>>>>>>>9.99	4	0	Number of revenues
36	XXXproject_qty_cost	decimal	->>>>>>>>>9.99	4	0	Number of expenses
37	XXXproject_posting	character	x(1)			Project entry posted
38	XXXproject_cost_center	character	x(8)			Cost center
39	ca_curr_code	character	x(3)			IC Currency
40	cost_center	character	x(12)			Cost center
41	cost_unit	character	x(12)			Cost unit
42	qty	decimal	->>>>>>>>>9.99	4	0	Quantity
43	week_nr	integer	>9		0	Week
44	pay_ref	character	X(32)			Payment reference
45	pay_method	integer	>>>>>9		0	Payment method
46	surch_disc	integer	>>>>>9		0	Payment charge/discount
47	amt_credit_surch_1	decimal	->>>,>>>,>>>,>>>,>>9.99	4	0	Amount PayCh/Disc 1
48	amt_credit_surch_2	decimal	->>>,>>>,>>>,>>>,>>9.99	4	0	Amount PayCh/Disc 2
49	fin_yr_transit	integer	9999		0	Transit financial year
50	outst_item_created	logical	yes/no		no	Outstanding item created
51	rev_entry	logical	yes/no		no	Reversal entry
52	curr_code_extra	character	x(3)			Extra currency
53	exch_rate_2	decimal	>>>>9.999999	6	0	Exchange rate
54	exch_rate3	decimal	>>>>9.999999	6	0	Exchange rate outstanding items
55	amt_curr_extra	decimal	->>>,>>>,>>>,>>>,>>9.99	4	0	Extra currency amount
56	amt_outst_def_curr	decimal	->>>,>>>,>>>,>>>,>>9.99	4	0	Outstanding Amount DC
57	amt_outst_curr	decimal	->>>,>>>,>>>,>>>,>>9.99	4	0	Outstanding amount in currency
58	amt_cur_wo_code_1	decimal	->>>,>>>,>>>,>>>,>>9.99	4	0	Amount WO code FC 1
59	amt_cur_wo_code_2	decimal	->>>,>>>,>>>,>>>,>>9.99	4	0	Amount WO code FC 2
60	amt_cur_wo_code_3	decimal	->>>,>>>,>>>,>>>,>>9.99	4	0	Amount WO code FC 3
61	amt_cur_wo_code_4	decimal	->>>,>>>,>>>,>>>,>>9.99	4	0	Amount WO code FC 4
62	amt_cur_wo_code_5	decimal	->>>,>>>,>>>,>>>,>>9.99	4	0	Amount WO code FC 5
63	vat_rep_nr	character	x(2)			VAT fiscal representative
64	del_acq	integer	>>>>>9		0	Supply/acquisition
65	pay_condition	character	X(4)			Payment condition
66	XXXprepayment	logical	yes/no		no	Prepayment
67	mcode1	character	x(12)			Mdim 1
68	mcode2	character	x(12)			Mdim 2
69	mcode3	character	x(12)			Mdim 3
70	mcode4	character	x(12)			Mdim 4
71	mcode5	character	x(12)			Mdim 5
72	ca_acc_nr	character	x(12)			Account
73	ca_cost_center	character	x(12)			Cost center
74	ca_cost_unit	character	x(12)			Cost unit
75	ca_qty	decimal	->>>>>>>>>9.99	4	0	Quantity
76	source_lc	character	x(12)
77	time_lc	integer	->,>>>,>>9		?
78	date_lc	date	99/99/9999
79	euserid_lc	character	X(12)
80	type_lc	character	x(8)
81	commitment_nr	int64	>>>>>>>>>>>9		0	Commitment number
82	line_nr_lis	integer	>>>9		0	Commitment line
83	x_flm_amt_costs	decimal	->>>,>>>,>>>,>>>,>>9.99	4	0	Amount costs
84	x_flm_amt_corr	decimal	->>>,>>>,>>>,>>>,>>9.99	4	0	Amount correction
85	XXXdelacq_code	integer	99		0	Delivery or acquisition
86	due_date_surch_3	date	99/99/9999			Due date PayCh/Disc 3
87	due_date_surch_4	date	99/99/9999			Due date PayCh/Disc 4
88	due_date_surch_5	date	99/99/9999			Due date PayCh/Disc 5
89	amt_credit_surch_3	decimal	->>>,>>>,>>>,>>>,>>9.99	4	0	Amount PayCh/Disc 3
90	amt_credit_surch_4	decimal	->>>,>>>,>>>,>>>,>>9.99	4	0	Amount PayCh/Disc 4
91	amt_credit_surch_5	decimal	->>>,>>>,>>>,>>>,>>9.99	4	0	Amount PayCh/Disc 5
92	period_res	integer	>>9		0	Period reserves
93	nr_periods_allocation	integer	>>>>		0	Allocation: Periods
94	start_year_allocation	integer	>>>>		0	Allocation: Start year
95	XXXdate_rec	date	99/99/9999			Date of reconciliation
96	ca_amt_cur_wo_code_1	decimal	->>>,>>>,>>>,>>>,>>9.99	4	0	Amount WO code FC 1
97	ca_debtor	int64	>>>>>>>>>9		0	IC debtor
98	ca_amt_cur_wo_code_2	decimal	->>>,>>>,>>>,>>>,>>9.99	4	0	Amount WO code FC 2
99	ca_credit	int64	>>>>>>>>>9		0	IC creditor
100	ca_amt_cur_wo_code_3	decimal	->>>,>>>,>>>,>>>,>>9.99	4	0	Amount WO code FC 3
101	ca_invoice_nr	int64	>>>>>>>>>>>9		0	IC invoice number
102	ca_amt_cur_wo_code_4	decimal	->>>,>>>,>>>,>>>,>>9.99	4	0	Amount WO code FC 4
103	ca_invoice_nr_type	integer	>>>>>9		1	IC invoice type
104	ca_amt_cur_wo_code_5	decimal	->>>,>>>,>>>,>>>,>>9.99	4	0	Amount WO code FC 5
105	ca_diff_code	integer	>>>>>9		1	Difference code

Indexes

atrssix - primary - unique

#	Field name	Data type	Format	Description
1	adm_nr	integer	>>>>>9	Company
2	fin_yr	integer	9999	Financial year
3	period	integer	>>9	Period
4	journal_nr	integer	>>9	Journal
5	seqnr_atrsh	integer	>>>>>>9	Sequence number
6	linenr_atrss	integer	>>>>>9	Line

atrss09ix

#	Field name	Data type	Format	Description
1	adm_nr	integer	>>>>>9	Company
2	fin_yr	integer	9999	Financial year
3	period	integer	>>9	Period
4	journal_nr	integer	>>9	Journal
5	seqnr_atrsh	integer	>>>>>>9	Sequence number
6	linenr_atrss_user	integer	>>>>>9	Line number (User)

atrss2ix

#	Field name	Data type	Format	Description
1	adm_nr	integer	>>>>>9	Company
2	acc_nr	character	x(12)	Account
3	fin_yr	integer	9999	Financial year
4	period	integer	>>9	Period

atrss3ix

#	Field name	Data type	Format	Description
1	adm_nr	integer	>>>>>9	Company
2	debtor	int64	>>>>>>>>>9	Debtor
3	fin_yr	integer	9999	Financial year
4	period	integer	>>9	Period

atrss4ix

#	Field name	Data type	Format	Description
1	adm_nr	integer	>>>>>9	Company
2	creditor	int64	>>>>>>>>>9	Creditor
3	fin_yr	integer	9999	Financial year
4	period	integer	>>9	Period

atrss5ix

#	Field name	Data type	Format	Description
1	adm_nr	integer	>>>>>9	Company
2	commitment_nr	int64	>>>>>>>>>>>9	Commitment number
3	line_nr_lis	integer	>>>9	Commitment line

atrss6ix

#	Field name	Data type	Format	Description
1	adm_nr	integer	>>>>>9	Company
2	fin_yr	integer	9999	Financial year
3	period	integer	>>9	Period
4	journal_nr	integer	>>9	Journal
5	seqnr_atrsh	integer	>>>>>>9	Sequence number
6	commitment_nr	int64	>>>>>>>>>>>9	Commitment number
7	line_nr_lis	integer	>>>9	Commitment line

atrss7ix

#	Field name	Data type	Format	Description
1	adm_nr	integer	>>>>>9	Company
2	debtor	int64	>>>>>>>>>9	Debtor
3	invoice_nr_type	integer	>>>>>9	Invoice type
4	invoice_nr	int64	>>>>>>>>>>>9	Invoice number

atrss8ix

#	Field name	Data type	Format	Description
1	adm_nr	integer	>>>>>9	Company
2	creditor	int64	>>>>>>>>>9	Creditor
3	invoice_nr_type	integer	>>>>>9	Invoice type
4	invoice_nr	int64	>>>>>>>>>>>9	Invoice number

Contents > atrss

Main Category:	Support Product Know How	Document Type:	Support - On-line help
Category:	On-line help files	Security level:	All - 0
Sub category:	Details	Document ID:	26.936.150
Assortment:	Exact Financials	Date:	27-01-2016
Release:		Attachment:
Disclaimer

Tags	Support Product Know How-On-line help files-Details