|
|
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
PO150 PO229 PO25.1 PO25.6 PO25.7 PO536
TE200
UPDATED BY
AC42.1 AC42.2 AP10.1 AP10.2 AP10.5 AP10.6
AP110 AP125 AP126 AP131 AP210 AP25.1
AP25.2 AP26.1 AP27.1 AP30.4 AP510 AP520
API1.1 API2.1 API3.1 AR08.1 AR09.1 AR10.1
AR115 AR190 AR258 AR301 AR31.5 AR33.5
AR42.1 AR42.2 AR42.6 AR42.7 AR42.8 AR43.1
AR44.3 AR48.3 AR501 AR502 AR550 AR560
ARLL.1 BL02.1 BL120 BL122 BL123 BL130
BL20.1 BL20.3 BL20.5 BL20.6 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 BL91.1 BL92.1 BR11.1 BRIP.1
DT92.1 IC28.1 MA180 MA530 MA531 MA540
MA60.2 MA60.3 MA60.5 MA61.1 MA66.2 MA66.3
MA67.1 MA67.2 MA70.1 MA75.1 MA80.1 MAI1.1
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 OE111 OE112 OE113 OE114 OE116
OE129 OE13.2 OE13.3 OE13.5 OE13.6 OE14.1
OE14.2 OE14.4 OE30.1 OE30.2 OE30.3 OE30.4
OE30.5 OE30.6 OE30.7 OE30.9 OE510 OE530
OE80.1 OE80.2 OE80.3 OE80.4 OE80.5 OE81.1
OE810 OE830 OE90.1 OE90.2 PBIP.1 PO100
PO101 PO122 PO130 PO131 PO20.1 PO21.2
PO21.3 PO21.4 PO21.5 PO22.1 PO220 PO23.1
PO29.1 PO295 PO30.1 PO30.2 PO30.3 PO300
PO31.1 PO31.2 PO32.2 PO33.1 PO34.1 PO35.1
PO38.1 PO39.1 PO39.2 PO44.1 PO50.1 PO52.1
PO520 POED.1 POI3.1 POI7.1 POIE.1 POII.1
POIJ.1 PR05.1 PR05.3 PR198 PR226 PR247
PR26.1 PR47.1 UK47.1 RQ10.1 RQ10.2 SA100
TE01.2 TE01.3 WH20.2 WH20.7
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
TMS-TERMS-CD Alpha 5 TE01.2
Element: 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
Element: Description Occurs 2 Times
The description of the terms code.
TMS-DISC-PCT Percent 7.5 (Percent) Occurs 3 Times TE01.2
Element: Discount PerceThe discount percent defined for the
terms code.
TMS-DISCOUNT-DAY Numeric 3 Occurs 3 Times TE01.2
Element: 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
Element: Discount MonthThe 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
Element: 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
Element: Additional MonThe number of additional months to be
added to the calculated discount date.
TMS-CUT-OFF-DAY Numeric 2 TE01.2
Element: 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
Element: 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
Element: Split From DayThe beginning day of the invoice date
range. Used for split terms.
TMS-SPLIT-END-DAY Numeric 2 Occurs 5 Times TE01.2
Element: 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
Element: Split DiscountThe discount day used for the defined
split invoice date range.
TMS-SPLIT-NET-DAY Numeric 2 Occurs 5 Times TE01.2
Element: 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
Element: Months ForwardThe 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
Element: End of Month FIndicates 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
Element: 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
Element: First Net DaysThe 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
Indicator date 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
Element: First Net Due 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
Element: First Net Due The month the first payment is due.
Used for multiple payment terms.
TMS-FIRST-PERCENT Percent 7.5 (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
Element: Total PaymentsThe total number of payments to be
scheduled for an invoice assigned this
multiple payment terms code.
TMS-DAYS-INCR Numeric 2 TE01.2
Element: Increment by DThe number of days between scheduled
payments. Used for multiple payment
terms.
TMS-MONTH-INCR Numeric 1 TE01.2
Element: Increment by MThe number of months between scheduled
payments. Used for multiple payment
terms.
TMS-FIXED-DAYS-MO Numeric 2 Occurs 5 Times TE01.2
Element: Fixed Days of 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
Element: Fixed Days of 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 AC42.1 AC42.2
Element: Days for AdjusThe number of adjustment days defined AP10.1 AP10.2
for a fixed days terms code. Used to AP10.5 AP10.6
adjust a payment due date when the AP25.1 AP25.2
defined days between payments falls AP30.4 AR08.1
between fixed payment days. AR09.1 AR10.1
AR31.5 AR33.5
AR42.1 AR42.2
AR42.6 AR42.7
AR42.8 AR43.1
AR44.3 AR48.3
BL02.1 BL20.1
BL20.3 BL20.5
BL20.6 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
MA60.2 MA60.3
MA60.5 MA61.1
MA66.2 MA66.3
MA67.1 MA67.2
OE10.1 OE10.2
OE10.3 OE10.4
OE10.5 OE10.6
...
TMS-ANTICIPATION Alpha 1 TE01.2
Element: Anticipation FIndicates whether the terms code is
eligible for anticipation discount in
the Lawson Accounts Payable system.
TMS-PROC-INDIC Alpha 1 TE01.2
Element: Terms Code TypIndicates 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
Element: Status Indicates whether the terms code is
active or inactive.
TMS-USED-FL Alpha 1 AC42.1 AC42.2
Element: Used Flag Indicates whether the terms code has AP10.1 AP10.2
been used. A terms code can be deleted AP10.5 AP10.6
only if it has not been used. AP110 AP125
AP126 AP131
AP210 AP25.1
AP25.2 AP26.1
AP27.1 AP30.4
AP510 AP520
API1.1 API2.1
API3.1 AR08.1
AR09.1 AR10.1
AR115 AR190
AR258 AR301
AR31.5 AR33.5
AR42.1 AR42.2
AR42.6 AR42.7
AR42.8 AR43.1
AR44.3 AR48.3
AR501 AR502
AR550 AR560
ARLL.1 BL02.1
BL120 BL122
BL123 BL130
BL20.1 BL20.3
BL20.5 BL20.6
BL202 BL21.2
BL21.5 BL29.1
BL29.2 BL30.1
BL30.2 BL30.3
...
TMS-DESC-1 Derived
Element: Description LiThe first line of description defined
for the terms code.
TMS-DESC-2 Derived
Element: Description LiThe 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 AC42.1 AC42.2
code file by terms code. AP10.1 AP10.2
AP10.5 AP10.6
AP110 AP125
AP126 AP131
AP210 AP25.1
AP25.2 AP26.1
AP27.1 AP30.4
AP510 AP520
API1.1 API2.1
API3.1 AR08.1
AR09.1 AR10.1
AR115 AR190
AR258 AR301
AR31.5 AR33.5
...
TMSSET2 PROC-INDIC This path is used to access the terms TE200
TERMS-CD code file by a specific type.
|
