Interface: DEBI - Documents Version 2017.00

Modifications compared to version 2011.00
Automatically define new switch (CreatePaymentReferenceLine) to the reference line (PaymentReferenceLine) based on the ESR method (PaymentOrderProcedure)
New field (ContractualRelationshipNumber) for document: REMS contractual relationship
Diverse new fields on document item level:
- Delivery type code for German recapitulatory messages
- Accrual data for accrual entries in the G/L
- only as export field: Target division for cross-divisional entries (import takes place via the 'Division' field)
- Commissioning field for commission determination / calculation
New field (ApplicationID) for document: Application can be set via the interface
Modifications compared to version 2012.00:
Person responsible for visas has been increased from 4 to 10 jobs (int. ->long)

Document type, the document type must already exist

Customer number, the customer number must already exist

Document number, must be unique, it is also possible to enter 0

External document number

Document reference

Unique reference, required for replies if no fixed document number is specified

Remark

A/R document date

G/L document date, must lie within an open financial year

Disposition date, the payment condition deadlines are calculated from this date

Currency, the currency must have been opened for the customer

Amount in document currency. The amount must correspond to the sum of all item amounts

Amount in key currency. The amount must correspond to the sum of all item amounts

Open amount in document currency

Open amount in key currency

Business case number, mandatory for business case document types

Division, the division must already exist

Person in charge, must already exist

Cost group, the cost group must already exist

Reminder range, must already exist

Cash management group, the cash management group must already exist

Reminder procedure, the reminder procedure must already exist

Free document group 1, the free document group must already exist in the company base, depending on the definition

Free document group 2, the free document group must already exist in the company base, depending on the definition

Free document group 3, the free document group must already exist in the company base, depending on the definition

Free document code A, the free document code must already exist in the company base, depending on the definition

Free document code B, the free document code must already exist in the company base, depending on the definition

Free document code C, the free document code must already exist in the company base, depending on the definition

Collection or outpayment method, the payment method must exist for the customer

ESR procedure, the ESR procedure must already exist

Determination of reference line type: ESR, IPI, LSV

Reference line, must be unique

Collective account, if the General Ledger is installed, the account must already exist

Collective cost centre 1, if the General Ledger is installed, the cost centre must already exist

Collective cost centre 2, if the General Ledger is installed, the cost centre must already exist

Invoice address, the address number must already exist

Reminder address, the address number must already exist

Reminder contact, the contact for the reminder address must already exist

Flag indicating that this document should be entered explicitly without VAT, although it would be subject to VAT due to the G/L document date and the client definition.

Processing instruction with multiple processings within a transaction: if "false", the processing is aborted immediately at the first error and the remaining processings no longer validated.

Processing instruction: Instead of specifying the VAT amounts, you can define that the VAT is always calculated by the interface program.

1=Open
5=Neutralised
6=Cancelled
7=Completed
9=Blocked

The reference line is flagged based on the definitions set via ESR procedure. Allow automatic generation in a second call in order to query again.

Contractual relationship number from Real Estate Management

Sub-element single address: For a collective customer, the document-specific address must be supplied

Address number, must be unique. If the address number is bigger than 0, the address is duplicated from the address file

Short name

Name

First name

Address line 1

Address line 2

Address line 3

Address line 4

Address line 5

Country

Postal code

Location

Language code

Sub-element items for this document. A maximum number of 5000 items per document may be entered

Item number, must be unique within the document

Item amount in document currency!! Credit notes have negative amounts!!

Item amount in key currency!! Credit notes have negative amounts!!

Credit account, if the General Ledger is installed, the account must already exist

Project, the project must already exist, Project Management must be installed

Credit cost centre 1, if the General Ledger is installed, the cost centre must already exist

Credit cost centre 2, if the General Ledger is installed, the cost centre must already exist

VAT method: 0 = None 1 = Agreed 2 = Collected

VAT code, mandatory if there is a VAT liability due to the G/L document date and the client definition

When importing, only VAT inclusive is possible.
2 = VAT inclusive

VAT validity date for this item

VAT amount in document currency!! Opposite sign vis-à-vis the item amount!!

VAT amount in key currency!! Opposite sign vis-à-vis the item amount!!

Item text

Quantity, if the General Ledger is installed, the credit account must allow quantities
Field size to Version 2007: 8.4
Field size from Version 2008: 12.4

Quantity code, if the General Ledger is installed, this code needs to correspond to the quantity code on the credit account

G/L code

Division, the division must already exist

True if the division of the item has been booked as cross-divisional in the G/L

Consolidation code

External order

External item

External reference

0 = no commission information
1 = commission information style A/P
2 = commission information style EXTERNAL
A/P: All parameters will be returned that are necessary for the determination of the commission recipients; the program can then determine the commission.
EXTERNAL: In addition to the commission recipients, the calculated commission is returned. The program returns this data only for the settlement.

Commissioning values for provision 1
The values must be set in relation to the 'CommissionFlag' element.

Commissioning values for provision 2
The values must be set in relation to the 'CommissionFlag' element.

Values for commissioning field 1
The content will be determined by the element 'CommissionFieldContent' and must be available in the file.

Content for commissioning field 1
1 = commission recipient
2 = product commission group
9 = no entry (field or commissioning active)
20 = article (only from ODRE)
30 = service (only from ODRE)

Commission recipient
for element 'CommissionDetermination' = 3 (manual): mandatory entry
for element 'CommissionFlag' = 2 (style EXTERNAL): mandatory entry

Control of the type of commission recipient determination for the commissioning field.
0 = via product commission group or product
1 = via customer commission group or customer
2 = via commission recipient determination matrix
3 = manual
for element 'CommissionFlag' = 2 (style EXTERNAL): Value 3 is mandatory here

Control of the type of rate determination for the commissioning field 1:
0 = based on field 1
1 = based on customer group(s) and field 1
2 = none (only in combination with field 2)
5 = none (statistical value)
for element 'CommissionFlag' = 2 (style EXTERNAL): Value 5 is mandatory here

The calculation scheme must be opened in the corresponding file and must have the value 'Settlement only' as calculation source.
Import: only for the element 'CommissionFlag' = 2 (type EXTERNAL) is a value allowed.

Commission amount in document currency.
Import: only for the element 'CommissionFlag' = 2 (type EXTERNAL) is a value allowed.

Commission amount in key currency
Import: only for the element 'CommissionFlag' = 2 (type EXTERNAL) is a value allowed.

Commissioning amount in document currency
Import: only for the element 'CommissionFlag' = 2 (type EXTERNAL) is a value allowed.

Commissioning amount in key currencyImport: only for the element 'CommissionFlag' = 2 (type EXTERNAL) is a value allowed.

Commission rate (information only)
Import: only for the element 'CommissionFlag' = 2 (type EXTERNAL) is a value allowed.

Values for commissioning field 2
The content will be determined by the element 'CommissionFieldContent' and must be available in the file.

Content for commissioning field 2
1 = commission recipient
2 = product commission group
9 = no entry (field or commissioning active)
20 = article (only from ODRE)
30 = service (only from ODRE)

Commission recipient
for element 'CommissionDetermination' = 3 (manual): mandatory entry
for element 'CommissionFlag' = 2 (style EXTERNAL): mandatory entry

Control of the type of commission recipient determination for the commissioning field.
0 = via product commission group or product
1 = via customer commission group or customer
2 = via commission recipient determination matrix
3 = manual
for element 'CommissionFlag' = 2 (style EXTERNAL): Value 3 is mandatory here

Control of the type of rate determination for the commissioning field 2:
0 = based on field 1
1 = based on customer group(s) and field1
2 = based on field 1 and field 2
3 = based on customer group(s) and field1 and field 2
4 = none (as info field for commission recipient)
5 = none (statistical value)
for element 'CommissionFlag' = 2 (style EXTERNAL): Value 5 is mandatory here

The calculation scheme must be opened in the corresponding file and must have the value 'Settlement only' as calculation source.
Import: only for the element 'CommissionFlag' = 2 (type EXTERNAL) is a value allowed.

Commission amount in document currency.
Import: only for the element 'CommissionFlag' = 2 (type EXTERNAL) is a value allowed.

Commission amount in key currency
Import: only for the element 'CommissionFlag' = 2 (type EXTERNAL) is a value allowed.

Commissioning amount in document currency
Import: only for the element 'CommissionFlag' = 2 (type EXTERNAL) is a value allowed.

Commissioning amount in key currency
Import: only for the element 'CommissionFlag' = 2 (type EXTERNAL) is a value allowed.

Commission rate (information only)
Import: only for the element 'CommissionFlag' = 2 (type EXTERNAL) is a value allowed.

Sub-element payment term: Only one payment containing up to 99 partial payment terms can be defined per document

Payment condition number, the payment condition number must already exist!! If the document is individual, 0 must be specified - see "Copy from condition table" !!

Flag whether the condition should be copied from the condition file

Definition of the payment term type: 0 = Standard (one payment term, 3 discount levels) 1 = Partial payments (several payment terms, one discount level each) 2 = Combination (Overall payment term or partial payment terms)