The data record for purchased invoice entry must contain a minimum of all 18 below defined attributes separated by 17 separators; if not, the "Incorrect Line Structure" error is displayed. If the 19th note attribute is found, it is taken into consideration.
A data record has the following structure:
ID | Importance | Default Value | Type | Max. Length | Note |
---|---|---|---|---|---|
01 |
Line Type |
201 |
Text |
3 |
Invariable identification of the purchased invoice data record |
02 |
MC |
NULL |
Text |
20 |
Matching code. Zeros are cut off from the left during import. If the file contains a matching code tht is more than 20 characters, the program reports an error and the import is not carried out. |
03 |
CC |
NULL |
Text | 4 |
Constant code If the file contains a CC that is more than 4 characters, the 4 characters going from right to left are imported. |
04 |
SC |
NULL |
Text |
10 |
Specific code Zeros are cut off from the left during import. If the file contains a SC that is more than 10 characters, the 10 characters going from right to left are imported. A zero specific code (e.g. "0000") is not transferred to a purchased invoice. |
05 |
Reserved |
NULL |
Text |
1 |
Reserved – empty; IGNORE |
06 |
Issue Date |
NOT NULL |
Date |
8 |
The sending date stated on the invoice |
07 |
VAT Date |
NULL |
Date |
8 |
Tax point date |
08 |
Due date |
NOT NULL |
Date |
8 |
The due date stated on the invoice |
09 |
Amount |
NOT NULL |
Money |
16 |
Invoice issued amount |
10 |
Currency Code |
NOT NULL |
Text |
3 |
Invoice amount currency code |
11 |
The company registration number of the supplier (batch sender) |
NOT NULL |
Text | 35 |
Supplier Co. Reg. No. (Czech resident), who enters the batch into the system The supplier is the party who receives the paid invoice to their account. |
12 |
Supplier Account |
NOT NULL |
Text |
35 |
The common account length is 16. The system checks whether the entered account actually is the supplier account (when the accounts are compared, the initial zeros are supplemented to the normal form). |
13 |
Supplier Bank |
NOT NULL |
Text |
4 |
The bank identification |
14 |
The company registration number of the customer (recipient of goods) |
NOT NULL |
Text |
35 |
Customer Co. Reg. No. (does not have to be in Czech Republic) The system first attempts to bind the Customer via the Customer + Supplier lookup. |
15 |
Customer Account |
NULL |
Text |
35 |
The common account length is 16. |
16 |
Customer Bank |
NULL |
Text |
4 |
Bank identification (0000 is the default bank) If the customer bank is not entered, the system automatically fills in the 0000 default bank into the storage. |
17 |
Financing |
NOT NULL |
Money |
16 |
Customer-requested financing in currency |
18 |
Do/Do not finance |
NULL |
Text |
1 |
Flag indicating whether to finance or not: 0 – finance (it is set YES to financing) 1 – no financing, or finance later (it is set NO to financing) 2 – invoice is not designated for direct debit (it is set invoice for direct debit) |
19 |
Note |
NULL |
Text |
100 |
Optional note |
Copyright © ARBES, 2019