While creating CSV-files for import into Nexus, the following requirements must be met regarding structure- und datatypes.
Data structure CSV-Format
The transfer file has the following basic structure:
•file name: freely selectable (File can also be zipped)
•structure: line-by-line
•line end symbol: CRLF (#10#13)
•header: in line 1
•field delimiters: ;(semicolon)
•field definers: " (quotation marks, applies to All fields)
•character set: ANSI (Codepage 1252)
•decimal separator: ,(comma)
•Thousands separator: none, information invalid
Data types CSV-format
AN alphanumeric, string (blank value = " "), max. 255 characters
N numeric, whole number (blank value = "0")
T date, DD.MM.YYYY (blank value = " ")
D Decimal number, two digits after decimal point (blank value = "0")
Header
Independent of the filling, every field (even optional fields) has to be in the header line.
If the field has no filling, the fitting blank value of the data-type has to be transferred.
A Nexus importable CSV-File can be divided in different branches.
If the branch is NOT stated in the data description, the abbreviation “A” generally applies.
Branch information
Abbreviation |
Meaning |
A |
All branches, the information has to be repeated in every invoice-line |
K |
Head-data: Only the bits of information in the first line of the bill will be evaluated. Information in this area, starting from the second line, will no longer be evaluated. Head-data lines must not contain position information (P1 or P2). |
P1 |
Position-data mode 1 Inactive – is only allowed to be filled with blank values |
P2 |
Position-data mode 2 (Bill-position-information) The handover of the to be processed data happens as invoice line item information, which means for every position of the invoice there will be a new line generated.
|
You would like to know more about dekodi? Please visit our Website!
Or call us: +49 911 310 429 - 10
Alternatively you can send an email to: info@dekodi.de