| 1
| Adm-nr
| INT
| N6
| admdat
| Company
|
|
| Field must be filled
| 100001
| F
|
|
|
|
|
|
|
|
|
| A company with this number must exist
| 100002
| F
|
| 2
| Pay-condition
| CHAR
| A4
|
| Payment condition
|
|
| Field must be filled
| 201401
| F
|
|
|
|
|
|
|
|
|
| Can not be more than 4.
| 201404
| F
|
| 3
| Descr
| CHAR
| A30
|
| Description
|
|
| If ? then set to ""; otherwise can not be more than 30.
| 20001
| W
|
| 4
| Installments
| LOG
| True/False
|
| Payment in installments
|
| False
| If option BOE is off then set to false
| -
|
|
|
|
|
|
|
|
|
|
| If ? then set to false
| -
|
|
| 5
| Surch-disc
| INT
| N2
|
| Payment charge/discount
| Credit surcharge: 1 or {T-PAY-CONDITION-SURCHARGE}
Settlement discount: 2 or {T-PAY-CONDITION-DISCOUNT}
| 1 or {T-PAY-CONDITION-SURCHARGE}
| If installments = true then set to payment charge.
| -
|
|
|
|
|
|
|
|
|
|
| If ? then set to payment charge.
| -
|
|
|
|
|
|
|
|
|
|
| Must be a valid value
| 20003
| W
|
| 6
| Surch-days-1
| INT
| N3
|
| Number of days 1
|
|
| If installments = true then set to 0
| -
|
|
|
|
|
|
|
|
|
|
| If ? then set to 0
| -
|
|
|
|
|
|
|
|
|
|
| If < 0
| 20003
| W
|
|
|
|
|
|
|
|
|
| If > 999
| 20003
| W
|
| 7
| Surch-days-2
| INT
| N3
|
| Number of days 2
|
|
| If ? then set to 0
|
|
|
|
|
|
|
|
|
|
|
| If surch-disc = payment charge (1) then set to 0
| -
|
|
|
|
|
|
|
|
|
|
| If > 0 and < surch-days-1
| 20003
| W
|
|
|
|
|
|
|
|
|
| If > 999
| 20003
| W
|
| 8
| Surch-days-3
| INT
| N3
|
| Number of days 3
|
|
| If ? then set to 0
|
|
|
|
|
|
|
|
|
|
|
| If surch-disc = payment charge (1) then set to 0
| -
|
|
|
|
|
|
|
|
|
|
| If > 0 and < surch-days-2
| 20003
| W
|
|
|
|
|
|
|
|
|
| If > 999
| 20003
| W
|
| 9
| Surch-days-4
| INT
| N3
|
| Number of days 4
|
|
| If ? then set to 0
|
|
|
|
|
|
|
|
|
|
|
| If surch-disc = payment charge (1) then set to 0
| -
|
|
|
|
|
|
|
|
|
|
| If > 0 and < surch-days-3
| 20003
| W
|
|
|
|
|
|
|
|
|
| If > 999
| 20003
| W
|
| 10
| Surch-days-5
| INT
| N3
|
| Number of days 5
|
|
| If ? then set to 0
|
|
|
|
|
|
|
|
|
|
|
| If surch-disc = payment charge (1) then set to 0
| -
|
|
|
|
|
|
|
|
|
|
| If > 0 and < surch-days-5
| 20003
| W
|
|
|
|
|
|
|
|
|
| If > 999
| 20003
| W
|
| 11
| Perc-1
| DEC
| N3,2
|
| Percentage 1
|
|
| If ? then set to 0
| -
|
|
|
|
|
|
|
|
|
|
| If Surch-day-1 = 0 then set to 0
| -
|
|
|
|
|
|
|
|
|
|
| If < -999.99
| 20003
| W
|
|
|
|
|
|
|
|
|
| If > 999.99
| 20003
| W
|
| 12
| Perc-2
| DEC
| N3,2
|
| Percentage 2
|
|
| If ? then set to 0
| -
|
|
|
|
|
|
|
|
|
|
| If Surch-day-2 = 0 then set to 0
| -
|
|
|
|
|
|
|
|
|
|
| If < -999.99
| 20003
| W
|
|
|
|
|
|
|
|
|
| If > 999.99
| 20003
| W
|
| 13
| Perc-3
| DEC
| N3,2
|
| Percentage 3
|
|
| If ? then set to 0
| -
|
|
|
|
|
|
|
|
|
|
| If Surch-day-3 = 0 then set to 0
| -
|
|
|
|
|
|
|
|
|
|
| If < -999.99
| 20003
| W
|
|
|
|
|
|
|
|
|
| If > 999.99
| 20003
| W
|
| 14
| Perc-4
| DEC
| N3,2
|
| Percentage 4
|
|
| If ? then set to 0
| -
|
|
|
|
|
|
|
|
|
|
| If Surch-day-4 = 0 then set to 0
| -
|
|
|
|
|
|
|
|
|
|
| If < -999.99
| 20003
| W
|
|
|
|
|
|
|
|
|
| If > 999.99
| 20003
| W
|
| 15
| Perc-5
| DEC
| N3,2
|
| Percentage 5
|
|
| If ? then set to 0
| -
|
|
|
|
|
|
|
|
|
|
| If Surch-day-5 = 0 then set to 0
| -
|
|
|
|
|
|
|
|
|
|
| If < -999.99
| 20003
| W
|
|
|
|
|
|
|
|
|
| If > 999.99
| 20003
| W
|
| 16
| Due-date-term
| INT
| N2
|
| Type of due date calculation
|
|
| If installments = true then set to 0
| -
|
|
|
|
|
|
|
|
|
|
| If ? then set to 1
| -
|
|
|
|
|
|
|
|
| 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
|
| Must be a valid value.
.
| 20003
| W
|
| 17
| Pay-term
| INT
| N3
|
| Payment term
|
|
| If due-date-term = 0 then set to 0.
| -
|
|
|
|
|
|
|
|
|
|
| If due-date-term = 2 then set to 0.
| -
|
|
|
|
|
|
|
|
|
|
| If due-date-term = 3 then set to 0
| -
|
|
|
|
|
|
|
|
|
|
| If ? then set to 0
| -
|
|
|
|
|
|
|
|
|
|
| If < -999
| 20003
| W
|
|
|
|
|
|
|
|
|
| If > 999
| 20003
| W
|
| 18
| Day-of-month
| INT
| N3
|
| Day of the month
|
|
| If due-date-term = 0 then set to 0.
| -
|
|
|
|
|
|
|
|
|
|
| If due-date-term = 1 then set to 0.
| -
|
|
|
|
|
|
|
|
|
|
| If ? then set to 0
| -
|
|
|
|
|
|
|
|
|
|
| If < 0
| 20003
| W
|
|
|
|
|
|
|
|
|
| If > 999
| 20003
| W
|
| 19
| Months
| INT
| N3
|
| Months
|
|
| If due-date-term = 0 then set to 0.
| -
|
|
|
|
|
|
|
|
|
|
| If due-date-term = 1 then set to 0.
| -
|
|
|
|
|
|
|
|
|
|
| If due-date-term = 2 then set to 1.
| -
|
|
|
|
|
|
|
|
|
|
| If due-date-term = 3 then set to 1.
| -
|
|
|
|
|
|
|
|
|
|
| If due-date-term = 4 then set to 1.
| -
|
|
|
|
|
|
|
|
|
|
| If due-date-term = 5 then set to 1.
| -
|
|
|
|
|
|
|
|
|
|
| If ? then set to 0
| -
|
|
|
|
|
|
|
|
|
|
| If < -999
| 20003
| W
|
|
|
|
|
|
|
|
|
| If > 999
| 20003
| W
|
| 20
| Gross-net-inv
| INT
| N2
|
| Gross/net invoicing
|
|
| If ? or 0 then get the value from the financial preference
| -
|
|
|
|
|
|
|
|
| Gross: 1 or {T-PAY-GROSS}
Net: 2 or {T-PAY-NET}
|
| Must be a valid value.
| 20003
| W
|
| 21
| Descr-ml[1]
| CHAR
| A30
|
| Description ML 1
|
|
| If ? then set to ""; otherwise can not be more than 30.
| 20001
| W
|
| 22
| Descr-ml[2]
| CHAR
| A30
|
| Description ML 2
|
|
| If ? then set to ""; otherwise can not be more than 30.
| 20001
| W
|
| 23
| Descr-ml[3]
| CHAR
| A30
|
| Description ML 3
|
|
| If ? then set to ""; otherwise can not be more than 30.
| 20001
| W
|
| 24
| Descr-ml[4]
| CHAR
| A30
|
| Description ML 4
|
|
| If ? then set to ""; otherwise can not be more than 30.
| 20001
| W
|
| 25
| Descr-ml[5]
| CHAR
| A30
|
| Description ML 5
|
|
| If ? then set to ""; otherwise can not be more than 30.
| 20001
| W
|
| 26
| Install-1
| INT
| N3
|
| Installment 1
|
|
| If installments = false then set to 0
| -
|
|
|
|
|
|
|
|
|
|
| If ? then set to 0
| -
|
|
|
|
|
|
|
|
|
|
| If < 0
| 20003
| W
|
|
|
|
|
|
|
|
|
| If > 999
| 20003
| W
|
| 27
| Install-2
| INT
| N3
|
| Installment 2
|
|
| If install-1 = 0 then set to 0
| -
|
|
|
|
|
|
|
|
|
|
| If ? then set to 0
| -
|
|
|
|
|
|
|
|
|
|
| If < 0
| 20003
| W
|
|
|
|
|
|
|
|
|
| If > 999
| 20003
| W
|
| 28
| Install-3
| INT
| N3
|
| Installment 3
|
|
| If install-2 = 0 then set to 0
| -
|
|
|
|
|
|
|
|
|
|
| If ? then set to 0
| -
|
|
|
|
|
|
|
|
|
|
| If < 0
| 20003
| W
|
|
|
|
|
|
|
|
|
| If > 999
| 20003
| W
|
| 29
| Install-4
| INT
| N3
|
| Installment 4
|
|
| If install-3 = 0 then set to 0
| -
|
|
|
|
|
|
|
|
|
|
| If ? then set to 0
| -
|
|
|
|
|
|
|
|
|
|
| If < 0
| 20003
| W
|
|
|
|
|
|
|
|
|
| If > 999
| 20003
| W
|
| 30
| Install-5
| INT
| N3
|
| Installment 5
|
|
| If install-4 = 0 then set to 0
| -
|
|
|
|
|
|
|
|
|
|
| If ? then set to 0
| -
|
|
|
|
|
|
|
|
|
|
| If < 0
| 20003
| W
|
|
|
|
|
|
|
|
|
| If > 999
| 20003
| W
|
| 31
| Pay-term-inst1
| INT
| N3
|
| Payment term installment 1
|
|
| If install-1 = 0 then set to 0
| -
|
|
|
|
|
|
|
|
|
|
| If ? or 0 then set to 1
| -
|
|
|
|
|
|
|
|
| Date + payment term: 1or T-BOE-DUE-CALC-DATE-P-TERM
Date + end of month -> day of month: 2 or T-BOE-DUE-CALC-DATE-P-END-T-DAY
Date -> end of month -> day of month: 3 or T-BOE-DUE-CALC-DATE-T-END-T-DAY
| 1or T-BOE-DUE-CALC-DATE-P-TERM
| Must be a valid value.
| 20003
| W
|
| 32
| Pay-term-inst2
| INT
| N3
|
| Payment term installment 2
|
|
| If install-2 = 0 then set to 0
| -
|
|
|
|
|
|
|
|
|
|
| If ? or 0 then set to 1
| -
|
|
|
|
|
|
|
|
| Date + payment term: 1or T-BOE-DUE-CALC-DATE-P-TERM
Date + end of month -> day of month: 2 or T-BOE-DUE-CALC-DATE-P-END-T-DAY
Date -> end of month -> day of month: 3 or T-BOE-DUE-CALC-DATE-T-END-T-DAY
| 1or T-BOE-DUE-CALC-DATE-P-TERM
| Must be a valid value.
| 20003
| W
|
| 33
| Pay-term-inst3
| INT
| N3
|
| Payment term installment 3
|
|
| If install-3 = 0 then set to 0
| -
|
|
|
|
|
|
|
|
|
|
| If ? or 0 then set to 1
| -
|
|
|
|
|
|
|
|
| Date + payment term: 1or T-BOE-DUE-CALC-DATE-P-TERM
Date + end of month -> day of month: 2 or T-BOE-DUE-CALC-DATE-P-END-T-DAY
Date -> end of month -> day of month: 3 or T-BOE-DUE-CALC-DATE-T-END-T-DAY
| 1or T-BOE-DUE-CALC-DATE-P-TERM
| Must be a valid value.
| 20003
| W
|
| 34
| Pay-term-inst4
| INT
| N3
|
| Payment term installment 4
|
|
| If install-4 = 0 then set to 0
| -
|
|
|
|
|
|
|
|
|
|
| If ? or 0 then set to 1
| -
|
|
|
|
|
|
|
|
| Date + payment term: 1or T-BOE-DUE-CALC-DATE-P-TERM
Date + end of month -> day of month: 2 or T-BOE-DUE-CALC-DATE-P-END-T-DAY
Date -> end of month -> day of month: 3 or T-BOE-DUE-CALC-DATE-T-END-T-DAY
| 1or T-BOE-DUE-CALC-DATE-P-TERM
| Must be a valid value.
| 20003
| W
|
| 35
| Pay-term-inst5
| INT
| N3
|
| Payment term installment 5
|
|
| If install-5 = 0 then set to 0
| -
|
|
|
|
|
|
|
|
|
|
| If ? or 0 then set to 1
| -
|
|
|
|
|
|
|
|
| Date + payment term: 1or T-BOE-DUE-CALC-DATE-P-TERM
Date + end of month -> day of month: 2 or T-BOE-DUE-CALC-DATE-P-END-T-DAY
Date -> end of month -> day of month: 3 or T-BOE-DUE-CALC-DATE-T-END-T-DAY
| 1or T-BOE-DUE-CALC-DATE-P-TERM
| Must be a valid value.
| 20003
| W |