Exact Financials

Data dictionary atrss - entry lines

#	Field name	Data type	Format	Dec	Default	Label
1	adm-nr	integer	>>>>>9		?	Company
2	fin-yr	integer	9999		0	Financial year
3	period	integer	>>9		0	Period
4	journal-nr	integer	>>9		0	Journal
5	project-linknr	int64	>>>>>>>>>9		0	Project linknumber
6	seq-nr-5	integer	>>>>>>9		0	Sequence number
7	line-nr	integer	>>>>>9		0	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(9)			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(8)			Cost center
41	cost-unit	character	x(8)			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(8)			Mdim 1
68	mcode2	character	X(8)			Mdim 2
69	mcode3	character	X(8)			Mdim 3
70	mcode4	character	X(8)			Mdim 4
71	mcode5	character	X(8)			Mdim 5
72	ca-acc-nr	character	X(9)			Account
73	ca-cost-center	character	X(8)			Cost center
74	ca-cost-unit	character	X(8)			Cost unit
75	ca-qty	decimal	->>>>>>>>>9.99	4	0	Quantity
76	source-lc	character	x(8)
77	time-lc	integer	->,>>>,>>9		0
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	XXXrecon-stat	integer	99		0	Reconciliation status
94	XXXrec-seq-nr	integer	>>>>9		0	Reconciliation SeqNr
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	seq-nr-5	integer	>>>>>>9	Sequence number
6	line-nr	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	seq-nr-5	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(9)	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	seq-nr-5	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:	25.809.105
Assortment:	Exact Financials	Date:	30-04-2014
Release:		Attachment:
Disclaimer

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