Connectivity Manual - Payment conditions
Payment conditions
File name: betcd.csv
| 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:
| 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:
- Payment charge
- 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:
- Days to add to invoice date
- Add days from end of month
- Add days from end of next month
- Days to add to invoice date + Add days to end of month
- Days to add to invoice date + Add days from end of next month
- 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:
- Gross
- 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:
- Date + payment term
- Date + end of month -> day of month
- Date -> end of month -> day of month
|
Connectivity Manual - Contents
> Data import > 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: |
01.642.823 |
| Assortment: |
Exact Financials (v3)
|
Date: |
18-01-2007 |
| Release: |
|
Attachment: |
|
| Disclaimer |