EEVA ASSET DOCUMENT AND ITEM TABLE EXPORT-IMPORT ...

seasoningalluringΔιαχείριση Δεδομένων

29 Νοε 2012 (πριν από 4 χρόνια και 4 μήνες)

231 εμφανίσεις

-

1

-


EEVA ASSET DOCUMENT AND ITEM
TABLE EXPORT
-
IMPORT FORMATS

This document describes structure of some most common tables.

Most common fields in those tables are described.


Data from those tables can be used in various ways.

Most common transport medias a
re


* PostgreSql DBMS protocol

* dbf files


Formats are used by Eeva ERP using File / Import command.

Data exported from Eeva using File / Export also contains those fields.

File names for dbf format

For dbf All files must be in single directory and must h
ave fixed names:




ldok.dbf



documents



lrid.dbf



document details



ltoode.dbf
-

items


Files must have extension:


.dbf
-

FoxPro dbf


Asset document headers

File: ldok.dbf

Table: firman.dok



Field name

Mandatory

Field type /
PostgreSQL
type

Descr
iption

Typical value
sample(s)

Column validating
foreign key

DOKTYYP

Yes

C(1)

Document type. See table “Asset document
types”.

d


DOKUMNR

Yes

N(7) /
INTEGER


Id of invoice in this file or primary key in
database . In file Must be sequential row number
1
,2, 3,.. and start with 1

1


KUUPAEV

Yes

D

Document date

15.01.2009


OPER

Yes

C(3)

Document kind. Determines which accounting
records are created if this invoice is posted.
Typically this has value 'ASL' for invoice
-
waybill. May be customer
-
specific.

A
SL

Alamdok.oper

KLIENT

Yes

C(12)

Customer id. Cannot contain lowercase letters.

COMPANYX

Klient.kood

LAONR

Yes

N(1)

Must always have value 1 for stock invoices.

1

Prladu.laonr

RAHA

Yes

C(3)

Unit of currency: EUR, USD etc.

EUR

Raha.raha

TASUDOK

Yes

C(2
5)

Document number

12345


KNR

Yes

C(10)

Document accounts number. For invoices this is
13111 , 1311USD

Konto.konto
nr

-

2

-

liability account. Typically different for every
unit of currency Liabilities in different currencies
must have different account numbers.

TASUKUUP


D

Invoice due date

25.01.2009


YKSUS

Yes for
deliver
y

C(10)

Source stock code

STOCK1

Yksus1.yksus

KRDOKUMNR

Yes for

Credit
notes

N(7)

Id for invoice which this credit note credits

1234

Dokumnr in
imported file

ARVENUMBER

Yes for

Credit
n
otes

C(25)

Number of invoice which this note credits


Dok.tasudok

EIMUUDA


L

True if document does not change stock

Should be true if quantity accounting is not
performed by Eeva

.F.


KASUTAJA


C(10)

User id who added this document

MATTIAS

Kasutaja.kasut
aja
(nonexistent user
ids are also
allowed)

GUID

Yes

C(36)

Guid of document. Must be unique over all Eeva
documents in world. Must contain hexadecimal
digits in format XXXXXXX
-
XXXX
-
XXXX
-
XXXX
-
XXXXXXXXXXXX

Must be same if same document is imported
multipl
e times.

0CCC5CED
-
08FF
-
11D5
-
AF8D
-
0000E8D668E8


TIMESTAMP

Yes

C(14)

Date and time when document or document
details were last changed. Format must be
yyyymmddhhmmss

Time must be in 24 hour format.

20030629154234


MASIN

Yes

C(5)

Id of the source system fr
om which document is
imported. Must contain only uppercase English
characters and digits and must start with
uppercase letter. Must be same for every row and
for every import from same source database

MYSOFT


LIIKMESRII

Yes if
intrastat is

Created

C(2)

C
ountry of destination or delivery. Must be EU
member and must be different from program may
country if this document needs included to
intrastat.

DE

Riik.kood

TEHINGULII

Yes if
intrastat is
created

C(2)

Type of transaction according to intrastat
classifi
er. Typically 11 for sale/purchase

11

Tehingul.kood

TARNEKLAUS

Yes if
intrastat is
created

C(10)

Delivery term. First 3 letters must be intrastat
term.

EXWTALLINN

Tarnekla.kood

STATPROTS

Yes if
intrastat is
created

C(2)

Type of transport. Must be two dig
its. First digit
must be according to intrastat classifier

Second digit must be zero.

3

Transpor.kood

MAKSETIN

No

C(5)

Payment term code

10

Maksetin.maksetin

ARVEKONTO

No

C(10)

Bookkeeping account number for bank account.
Used to print own bank account

info to invoice

112

Konto.kontonr

PAIS2OBJ

No

C(10)

Subject (second classifier) code. Subject related
to this document.

LINDA

Yksus.yksus or

(Yksus2.yksus in
server)

EXCHRATE

No

N(11,6)

Exchange rate of invoice curreny in invoice date

15.6466


PAIS7O
BJ

No

C(10)

Partner (seventh classifier) code. Partner related
to this document

COMP1

Yksus.yksus or

(Yksus7.yksus in
server)

KAAL

No

N(7,3)

Weight

12.2





-

3

-

Asset document details

File: lrid.dbf

Table: firman.rid


LRID must contain at least one reco
rd for every LDOK record.



Field name

Mandatory

Field type /
PostgreSQL
type

Description

Typical value
sample

Foreign key
reference

DOKTYYP

Yes

C(1)

Document type. See table “Asset document
types”.

d


DOKUMNR

Yes

N(7) /
INTEGER


Reference to ldok table
record

1


TOODE


C(20)

Product id or predefined two letter id KM
for VAT rows. For product rows length
must have at least 3 characters.

PRODUCT12

Toode.toode

NIMETUS

Yes

C(50)

Row description. Typically is the same as
ltoode.nimetus

My product


HIND


N
(15,5)

Unit sales price in ldok.raha currency

12.50


KOGUS


N(12,4)

Quantity

10


KULUKONTO

No

C(10)

Account number. Typically sales account for
invoices

311

Konto.kontonr

MYYGIKOOD

Yes if sales row in
invoice

C(4)

For invoices: Sales code. Determines sa
les
account number and VAT rate. Is different
for EU delivery, export and for different
VAT rates. Sales codes can be
created/changed by user. Program ships with
default sales code table (myygikoo).
Typically is 311 for normal domestic sales
with normal VA
T.

311

Myygikoo.myygiko
od

KAUBASUMMA


N(15,5)

Cost of unit of product in program's main
currency.

8.2


YHIK


C(6)

Unit code

PCS

Mootyhik.yhik

REAKAAL

Yes if intrastat is
created and if not
filled in product
table

N(16,6)

Weight of whole quantity of prod
ucts in this
row in kilograms.

If wight of product is always the same or not
in product row must be 0 .

For example, can be non
-
zero for wood
products transported in wet conditions.

0


PARITOLURI

Yes if intrastat is
created

C(2)

Country of origin of this
product to be
declared in intrastat

EE

Riik.kood

STATVAARTU

Yes if intrastat is
created and if there
are additional costs

N(10,2)

Additional value to be added to product cost
( kogus*kaubasumma) to get statistical value
in program's main currency

0


Prod
uct table

File: ltoode.dbf

Table: firman.toode


Products are contained in table ltoode.



Field name

Mandatory

Field
type

Description

Typical value
sample

Primary key table
and field

GRUPP

Yes

C(1)

Must be L for stock items

L

Prladu.grupp

TOODE

Yes

C(2
0)

Product Id. Length must be at least 3 characters.
PRODUCT12

Toode.toode

-

4

-

Cannot contain lowercase letters. Must be unique in
file

NIMETUS

Yes

C(50)

Product name

My product


YHIK


C(6)

Unit of quantity measure

PCS

Mootyhik.yhik

PARITOLURI

Yes if intras
tat
is created and
product goes to
intrastat

C(2)

Default country of origin for intrastat

EE

Riik.kood

YHIKUTEISE



N(9,4)

Unit conversion factor for intrastat additional unit
of measurement. 0 if unit conversion should not
performed

0


MASIN

Yes

C(5)

E
very row must contain same value as in
ldok.masin field

MYSOFT


TIMESTAMP

Yes

C(14)

Date and time when row was last changed. Format
is yyyymmddhhmmss. Time must be in 24 hour
format.



KAUBAKOOD

Yes if intrastat
is created and
product goes to
intrastat

C
(10)

Intrastat code. First 8 digits are used for intrastat.
Last two digits must be 00 if there are no special
requirements.

44123110

Nomenkla.kood

NETOMASS

Yes if intrastat
is created and
not specified in
document row

N(12,4)

Weight of product unit in ki
lograms.

12.3


Asset document types


LA

Annuled cash sale

LB

Job schedule

LC

Driving journal

LD

Production

LE

Contract

LF

Stocktaking

LG

Invoice

LH

Offer

LI

Internal sales

LJ

Cash stocktaking

LK

Chargeable

LM

Limit

LN

Calculation

LO

Purchase invoice

LP

Pu
rchase offering

LQ

Bank card bill

LR

Realization act

LS

Receipt

LT

Order

LU

Purchase order

LV

Dispatch

LY

Cash sale