This article provides you with an overview of the use and default configuration of the VEIS tables. You cannot change the default configuration for the VEIS tables. However, you can add your own configurations in some cases.
VEIS_INVOICE table
The table is the header data table of VEIS. One record is created per invoice. The following fields are automatically filled in by edoc invoice link for IGF when the data is exported:
-
REQNUMBER: Contains the consecutive activity ID (activity_id).
-
PK_VEIS_INVOICE: Contains the primary key of the table. Is automatically filled in an Oracle database by the sequence hibernate_sequence . To call further sequences, hibernate_sequence.nextval is used.
You can define additional fields in the column configuration if required.
VEIS_INVOICE_TAX table
The table is the VEIS tax rate table. The line items are totaled by tax code and one line is written per tax code.
The written columns are fixed and cannot be configured:
-
PK_VEIS_INVOICE_TAX: Contains the primary key.
-
FK_VEIS_INVOICE: Contains the primary key of VEIS_INVOICE.
-
TAXCODEID: Contains the code of the tax rate key.
-
TAXAMOUNTBASECURRENCY: Contains the converted local currency amount if you export an invoice that contains a currency other than the local currency.
-
TAXAMOUNTFOREIGNCURRENCY: Contains the original invoice amount based on the currency on an invoice (foreign currency amount) or the invoice amount in the local currency.
-
ISCREDITNOTE: Used to determine whether an invoice amount should be posted as an invoice or as a credit memo.
VEIS_INVOICE_NL_SPLIT table
The table contains the G/L account breakdown from VEIS. The line items from edoc invoice are adopted without changes. There is no grouping or totaling by G/L account.
-
PK_VEIS_INVOICE_NL_SPLIT: Contains the primary key and is used in VEIS_INVOICE_COSTING_SPLIT.
-
FK_VEIS_INVOICE: Contains the primary key of VEIS_INVOICE.
You can define additional fields in the column configuration if required.
VEIS_INVOICE_COSTING_SPLIT table
The table contains the cost center breakdown per G/L account of VEIS. If a cost center or cost object is filled, this line is written to the G/L account item.
-
FK_VEIS_INVOICE_NL_SPLIT: Contains the foreign key of the G/L account breakdown.