One moment please...
 
 
Exact Financials   
 

Connectivity Manual - Payment conditions

File name: betcd.csv

Nr Field name Type Form Ref Description Remarks Default
1 Adm-nr INT N6 admdat Company * -
2 Pay-condition CHAR A4 - Payment condition Mandatory -
3 Descr CHAR A30 - Description - -
4 Installments LOG J/N - Payment in installments - N
5 Surch-disc INT N2 - Payment charge/discount * 1
6 Surch-days-1 INT N3 - Number of days 1 - -
7 Surch-days-2 INT N3 - Number of days 2 - -
8 Surch-days-3 INT N3 - Number of days 3 - -
9 Surch-days-4 INT N3 - Number of days 4 - -
10 Surch-days-5 INT N3 - Number of days 5 - -
11 Perc-1 DEC N3,2 - Percentage 1 - -
12 Perc-2 DEC N3,2 - Percentage 2 - -
13 Perc-3 DEC N3,2 - Percentage 3 - -
14 Perc-4 DEC N3,2 - Percentage 4 - -
15 Perc-5 DEC N3,2 - Percentage 5 - -
16 Due-date-term INT N2 - Type of due date calculation * 1
17 Pay-term INT N3 - Payment term - -
18 Day-of-month INT N3 - Day of the month - -
19 Months INT N3 - Months - -
20 Gross-net-inv INT N2 - Gross/net invoicing * -
21 Descr-ml[1] CHAR A30 - Description ML 1 - -
22 Descr-ml[2] CHAR A30 - Description ML 2 - -
23 Descr-ml[3] CHAR A30 - Description ML 3 - -
24 Descr-ml[4] CHAR A30 - Description ML 4 - -
25 Descr-ml[5] CHAR A30 - Description ML 5 - -
26 Install-1 INT N3 - Installment 1 - -
27 Install-2 INT N3 - Installment 2 - -
28 Install-3 INT N3 - Installment 3 - -
29 Install-4 INT N3 - Installment 4 - -
30 Install-5 INT N3 - Installment 5 - -
31 Pay-term-inst1 INT N3 - Payment term installment 1 * 1
32 Pay-term-inst2 INT N3 - Payment term installment 2 * 1
33 Pay-term-inst3 INT N3 - Payment term installment 3 * 1
34 Pay-term-inst4 INT N3 - Payment term installment 4 * 1
35 Pay-term-inst5 INT N3 - Payment term installment 5 * 1

Clarification of the fields:

Field Clarification
1 This field is only a part of the import format, when the option 'Company number' is enabled. When this option is not enabled, this field should be skipped.
5 This field must contain one of the following values:
  1. Payment charge
  2. Payment discount

If this field is left empty, 1 (payment charge) will be entered. If Installments is set to 'J' (Yes) then this field is always set to 1 (payment charge).
16 This field must contain one of the following values:
  1. Days to add to invoice date
  2. Add days from end of month
  3. Add days from end of next month
  4. Days to add to invoice date + Add days to end of month
  5. Days to add to invoice date + Add days from end of next month
  6. Days to add to invoice date + Number of times to end of month + Add days to result of this all
20 This field must contain one of the following values:
  1. Gross
  2. Net

If this field is left empty, the invoicing method defined in [File, Company settings, Financial preferences] is entered in this field.
31-35 This field must contain one of the following values:
  1. Date + payment term
  2. Date + end of month -> day of month
  3. Date -> end of month -> day of month

Connectivity > Data import > Available import formats > Finance > Payment conditions

     
 Main Category: Support Product Know How  Document Type: Support - On-line help
 Category: On-line help files  Security  level: All - 0
 Sub category: Details  Document ID: 18.324.536
 Assortment: Exact Financials  Date: 02-10-2015
 Release:  Attachment:
 Disclaimer