Purchased Invoice

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:

IDImportanceDefault ValueTypeMax. LengthNote

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