|
|
TERMS FILE
Payment Terms
The Payment Terms file contains terms codes. Terms codes are used to calculate
due date and discount information for an invoice. Terms codes can be used in
various Lawson systems. Non-Lawson systems can use the terms compute logic
via an application program interface program.
REFERENCED BY
TE200
UPDATED BY
AP10.1 AP10.2 AP10.5 AP10.6 AP110 AP20.1
AP20.2 AP20.5 AP20.7 AP210 AP23.1 AP510
AP520 AR08.1 AR10.1 AR115 AR258 AR31.5
AR42.1 AR42.2 AR42.6 AR42.7 AR42.8 AR43.1
AR44.3 AR501 AR502 AR550 AR560 AR970
AR973 BL02.1 BL120 BL122 BL130 BL20.1
BL20.3 BL202 BL21.2 BL21.5 BL29.1 BL29.2
BL30.1 BL30.2 BL30.3 BL30.5 BL31.1 BL31.2
BL31.3 BL31.5 BL31.7 BL32.1 BL32.2 BL32.3
BL32.4 BL520 BL80.1 BL802 BL820 BL902
BL91.1 BL92.1 BL940 DT92.1 IN20.1 MA40.1
MA40.2 MA41.1 MA41.2 MA41.4 MA41.5 MA41.6
MA43.1 MA43.2 MA43.3 MA43.4 MA52.1 MA520
MA530 MA540 OE10.1 OE10.2 OE10.3 OE10.4
OE10.5 OE10.6 OE10.7 OE10.8 OE11.1 OE11.4
OE11.8 OE11.9 OE110 OE112 OE113 OE114
OE129 OE14.1 OE14.2 OE14.4 OE15.1 OE15.2
OE15.3 OE15.4 OE15.5 OE15.7 OE30.1 OE30.2
OE30.3 OE30.4 OE30.5 OE30.6 OE30.7 OE30.9
OE510 OE80.1 OE80.2 OE80.3 OE80.4 OE80.5
OE810 OE830 OE920 OE950 PBIP.1 PO100
PO120 PO123 PO130 PO20.1 PO21.5 PO21.6
PO22.2 PO22.3 PO220 PO31.1 PO820 PR150
PR195 PR199 PR82.1 PR85.1 RQ20.1 RQ20.3
RQ20.4 SA100 TE01.2 TE01.3 WH20.2 WH20.7
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
TMS-TERMS-CD Alpha 5 TE01.2
Terms Code A user-defined code associated with
user-defined payment terms. Used to
calculate due date and discount
information for an invoice.
TMS-DESC Alpha 30 (Lower Case) TE01.2
Description Occurs 2 Times
The description of the terms code.
TMS-DISC-PCT Percent 5.3 (Percent) Occurs 3 Times TE01.2
Discount Percent The discount percent defined for the
terms code.
TMS-DISCOUNT-DAY Numeric 3 Occurs 3 Times TE01.2
Discount Day The discount days defined for the terms
code. Indicates the number of days
following the invoice date that a
discount can be taken.
TMS-DISC-MONTH Alpha 2 Occurs 3 Times TE01.2
Discount Month The discount month defined for the terms
code. Identifies the month in which the
discount will be taken.
TMS-DISC-DAY Numeric 2 Occurs 3 Times TE01.2
Discount Day The discount day defined for the terms
code. Identifies the day of the month
through which the discount can be taken.
TMS-DISC-DUE-MNTH Numeric 2
Additional Months The number of additional months to be
added to the calculated discount date.
TMS-CUT-OFF-DAY Numeric 2 TE01.2
Cut Off Day The invoice cutoff day used to determine
the due date month. If the invoice day
falls on or before the cutoff day you
define, the invoice will be due in the
month following invoice month. If the
invoice day falls after the cutoff day
you define, the first day of the month
following the invoice date is used to
calculate the due date month (two months
following the invoice month).
TMS-PROX-DAY Numeric 2 Occurs 2 Times TE01.2
Prox Day The day of the month used to calculate
the discount date and, optionally, the
net due date.
TMS-SPLIT-BEG-DAY Numeric 2 Occurs 5 Times TE01.2
Split From Day The beginning day of the invoice date
range. Used for split terms.
TMS-SPLIT-END-DAY Numeric 2 Occurs 5 Times TE01.2
Split To Day The ending date of the invoice date
range. Used for split terms.
TMS-SPLIT-DISC-DAY Numeric 2 Occurs 5 Times TE01.2
Split Discount Day The discount day used for the defined
split invoice date range.
TMS-SPLIT-NET-DAY Numeric 2 Occurs 5 Times TE01.2
Split Net Day The net due day used for the defined
split invoice date range.
TMS-SPLIT-EOM-FLAG Alpha 1 Occurs 5 Times TE01.2
Split End of Month Indicates whether the net due day for
Flag the defined invoice date range will be
the last day of the month.
Valid values are
Blank = End of month is not used
Y = Yes; end of month is net due day
TMS-SPLIT-MO-FORW Numeric 2 Occurs 5 Times TE01.2
Months Forward The number of months to be added to the
invoice month that the due date defined
for the split invoice date range will be
applied. Valid values are 00 and 01.
TMS-EOM-INDIC Alpha 1 TE01.2
End of Month Flag Indicates whether the net due date will
be the end of the month.
Valid values are
N = No
Y = Yes
TMS-FINAL-DUE-DAY Numeric 2
Final Due Day This field contains the net due day
defined for the terms code if the net
due day is a specific day of the month
and is a different day than the discount
day.
TMS-FIRST-NET-DAYS Numeric 3 TE01.2
First Net Days The number of days to be added to the
invoice date or last discount date to
calculate the due date of the first
payment.
TMS-FIRST-FROM Alpha 1 TE01.2
First Payment From Indicates whether the first net due date
Indicator is calculated using the invoice date or
the last discount date calculated. Valid
for first days only.
Valid values are
D = Last discount date calculated
I = Invoice date
TMS-FIRST-NET-DAY Numeric 2 TE01.2
First Net Due Day The day of the month the first payment
is due. Used for multiple payment terms.
01
31
03
TMS-FIRST-NET-MO Alpha 2 TE01.2
First Net Due Month The month the first payment is due. Used
for multiple payment terms.
TMS-FIRST-PERCENT Percent 5.3 (Percent) TE01.2
First Payment The percent of the invoice amount to be
Percent included in the first scheduled payment.
Used for multiple payment terms. The
remaining invoice amount is divided
equally among remaining scheduled
payments. Any odd amount is included in
the last scheduled payment.
TMS-TOTAL-NBR-PMTS Numeric 2 TE01.2
Total Payments The total number of payments to be
scheduled for an invoice assigned this
multiple payment terms code.
TMS-DAYS-INCR Numeric 2 TE01.2
Increment by Days The number of days between scheduled
payments. Used for multiple payment
terms.
TMS-MONTH-INCR Numeric 1 TE01.2
Increment by Months The number of months between scheduled
payments. Used for multiple payment
terms.
TMS-FIXED-DAYS-MO Numeric 2 Occurs 5 Times TE01.2
Fixed Days of Month A fixed day of the month that scheduled
payments will be due. Up to five fixed
days can be defined for a fixed days
terms code.
01
31
TMS-FIXED-DAYS-WK Numeric 1 Occurs 2 Times TE01.2
Fixed Days of Week A fixed day of the week that scheduled
payments will be due. Up to 2 fixed days
of the week can be defined for a fixed
day terms code.
Valid values are
1 = Sunday
2 = Monday
3 = Tuesday
4 = Wednesday
5 = Thursday
6 = Friday
7 = Saturday
TMS-ADJUST-DAYS Numeric 2 AP10.1 AP10.2
Days for Adjustment The number of adjustment days defined AP10.5 AP10.6
for a fixed days terms code. Used to AP20.1 AP20.2
adjust a payment due date when the AP20.5 AP20.7
defined days between payments falls AR08.1 AR10.1
between fixed payment days. AR31.5 AR42.1
AR42.2 AR42.6
AR42.7 AR42.8
AR44.3 BL02.1
BL20.1 BL20.3
BL21.2 BL21.5
BL29.1 BL29.2
BL30.1 BL30.2
BL30.3 BL30.5
BL31.1 BL31.2
BL31.3 BL31.5
BL31.7 BL32.1
BL32.2 BL32.3
BL32.4 BL80.1
DT92.1 MA40.1
MA40.2 MA41.1
MA41.2 MA41.4
MA41.5 MA41.6
MA43.1 MA43.2
MA43.3 MA43.4
OE10.1 OE10.2
OE10.3 OE10.4
OE10.5 OE10.6
OE10.7 OE10.8
OE11.1 OE11.4
...
TMS-ANTICIPATION Alpha 1 TE01.2
Anticipation Flag Indicates whether the terms code is
eligible for anticipation discount in
the Lawson Accounts Payable system.
TMS-PROC-INDIC Alpha 1 TE01.2
Terms Code Type Indicates the type of terms code.
Valid values are
P = Prox
S = Split
N = Net
C = Prepayment
M = Multiple Payment
F = Fixed Days
TMS-ACTIVE-STATUS Alpha 1 TE01.2
Status Indicates whether the terms code is
active or inactive.
TMS-USED-FL Alpha 1 AP10.1 AP10.2
Used Flag Indicates whether the terms code has AP10.5 AP10.6
been used. A terms code can be deleted AP110 AP20.1
only if it has not been used. AP20.2 AP20.5
AP20.7 AP210
AP23.1 AP510
AP520 AR08.1
AR10.1 AR115
AR258 AR31.5
AR42.1 AR42.2
AR42.6 AR42.7
AR42.8 AR43.1
AR44.3 AR501
AR502 AR550
AR560 AR970
AR973 BL02.1
BL120 BL122
BL130 BL20.1
BL20.3 BL202
BL21.2 BL21.5
BL29.1 BL29.2
BL30.1 BL30.2
BL30.3 BL30.5
BL31.1 BL31.2
BL31.3 BL31.5
BL31.7 BL32.1
BL32.2 BL32.3
BL32.4 BL520
BL80.1 BL802
BL820 BL902
...
TMS-DESC-1 Derived
Description Line 1 The first line of description defined
for the terms code.
TMS-DESC-2 Derived
Description Line 2 The second line of description defined
for the terms code.
TERMS FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
TMSSET1 TERMS-CD This path is used to access the terms AP10.1 AP10.2
code file by terms code. AP10.5 AP10.6
AP110 AP20.1
AP20.2 AP20.5
AP20.7 AP210
AP23.1 AP510
AP520 AR08.1
AR10.1 AR115
AR258 AR31.5
AR42.1 AR42.2
AR42.6 AR42.7
AR42.8 AR43.1
AR44.3 AR501
AR502 AR550
AR560 AR970
...
TMSSET2 PROC-INDIC This path is used to access the terms TE200
TERMS-CD code file by a specific type.
|