TERMS

Payment Terms Maintenance

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
AC42.1 AC42.2 AP10.1 AP10.2 AP10.5 AP10.6
AP110 AP125 AP126 AP131 AP20.1 AP20.2
AP20.3 AP20.4 AP20.5 AP20.7 AP21.1 AP210
AP23.1 AP25.1 AP25.2 AP26.1 AP27.1 AP30.4
AP510 AP520 API1.1 API2.1 API3.1 AR08.1
AR09.1 AR10.1 AR301 AR501 AR550 ARLL.1
BR11.1 BRIP.1 CX100 CX20.1 CX20.2 CX20.4
CX20.5 CX220 CX30.1 CX300 CX506 CXCP.1
DR100 IC12.1 IC140 IC141 IC142 IC145
IC243 IC330 IC64.1 IC64.2 IC64.3 IC64.4
IC64.5 IC64.6 IC64.7 IC64.8 IC64.9 IC66.1
IC83.1 MA180 MA278 MA41.1 MA41.2 MA41.4
MA41.7 MA42.2 MA43.2 MA43.7 MA44.1 MA44.2
MA53.1 MA530 MA531 MA540 MA60.2 MA60.3
MA60.5 MA61.1 MA66.2 MA67.2 MA67.3 MA68.2
MA68.3 MA68.5 MA70.1 MA75.1 MA80.1 MAI1.1
PD10.1 PD10.2 PD130 PD20.1 PD20.2 PD20.3
PD570 PO04.1 PO04.2 PO10.1 PO10.2 PO100
PO101 PO115 PO120 PO122 PO130 PO131
PO132 PO136 PO15.1 PO15.2 PO15.4 PO150
PO17.1 PO190 PO20.1 PO20.6 PO20.9 PO204
PO21.1 PO21.2 PO21.3 PO21.4 PO21.5 PO22.1
PO22.3 PO22.4 PO220 PO222 PO224 PO225
PO229 PO23.1 PO230 PO234 PO24.1 PO25.1
PO25.5 PO25.6 PO25.7 PO251 PO26.3 PO26.7
PO26.9 PO27.2 PO27.3 PO27.4 PO275 PO276
PO277 PO28.2 PO280 PO29.1 PO295 PO30.1
PO30.2 PO30.3 PO30.4 PO300 PO31.1 PO31.2
PO32.2 PO32.4 PO33.1 PO34.1 PO35.1 PO36.1
PO36.2 PO38.1 PO39.1 PO39.2 PO44.1 PO50.1
PO52.1 PO520 PO536 PO54.5 POCP.1 POED.1
POI3.1 POI7.1 POID.1 POII.1 POIJ.1 PR05.1
PR05.3 PR198 PR226 PR247 PR26.1 PR47.1
PR514 RQ01.1 RQ10.1 RQ10.2 RQ10.3 RQ10.4
RQ10.5 RQ11.1 RQ12.1 RQ13.1 RQ13.2 RQ35.1
RQ44.1 RQ500 RQ810 RQIB.1 RQIF.1 RQII.1
RQIJ.1 TE01.2 TE01.3 TEI1.1 TX140 WH130
WH132 WH190 WH20.2 WH20.7 WH222 WH30.1
WH30.2 WH30.3 WH30.4 WH31.1 WH31.2 WH31.3
WH31.4 WH32.1 WH32.2 WH32.3 WH32.4 WH32.5
WH33.1 WH33.2 WH33.3 WH33.4 WH33.5 WH33.6
WH33.8 WH33.9 WH34.1 WH34.2 WH34.3 WH34.4
WH40.1 WH40.2 WH520 WH830

FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
TMS-TERMS-CD
Element: Terms Code
Alpha 5
A user-defined code associated with user-defined payment terms. Used to calculate due date and discount information for an invoice.
TE01.2
TMS-DESC
Element: Description
Alpha 30 (Lower Case)
Occurs 2 Times
The description of the terms code.
TE01.2
TMS-DISC-PCT
Element: Disc Pct
Percent 7.5 (Percent) Occurs 3 Times
The discount percent defined for the terms code.
TE01.2
TMS-DISCOUNT-DAY
Element: Discount Day
Numeric 3 Occurs 3 Times
The discount days defined for the terms code. Indicates the number of days following the invoice date that a discount can be taken.
TE01.2
TMS-DISC-MONTH
Element: Discount Month
Alpha 2 Occurs 3 Times
The discount month defined for the terms code. Identifies the month in which the discount will be taken.
TE01.2
TMS-DISC-DAY
Element: Discount Day
Numeric 2 Occurs 3 Times
The discount day defined for the terms code. Identifies the day of the month through which the discount can be taken.
TE01.2
TMS-DISC-DUE-MNTH
Element: Additional Months
Numeric 2
The number of additional months to be added to the calculated discount date.
TMS-CUT-OFF-DAY
Element: Cut Off Day
Numeric 2
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).
TE01.2
TMS-PROX-DAY
Element: Prox Day
Numeric 2 Occurs 2 Times
The day of the month used to calculate the discount date and, optionally, the net due date.
TE01.2
TMS-SPLIT-BEG-DAY
Element: Split From Day
Numeric 2 Occurs 5 Times
The beginning day of the invoice date range. Used for split terms.
TE01.2
TMS-SPLIT-END-DAY
Element: Split To Day
Numeric 2 Occurs 5 Times
The ending date of the invoice date range. Used for split terms.
TE01.2
TMS-SPLIT-DISC-DAY
Element: Split Discount Day
Numeric 2 Occurs 5 Times
The discount day used for the defined split invoice date range.
TE01.2
TMS-SPLIT-NET-DAY
Element: Split Net Day
Numeric 2 Occurs 5 Times
The net due day used for the defined split invoice date range.
TE01.2
TMS-SPLIT-EOM-FLAG
Split End of Month
Flag
Alpha 1 Occurs 5 Times
Indicates whether the net due day for 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
TE01.2
TMS-SPLIT-MO-FORW
Element: Months Forward
Numeric 2 Occurs 5 Times
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.
TE01.2
TMS-EOM-INDIC
Element: End of Month Flag
Alpha 1
Indicates whether the net due date will be the end of the month. Valid values are N = No Y = Yes
TE01.2
TMS-FINAL-DUE-DAY
Element: Final Due Day
Numeric 2
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
Element: First Net Days
Numeric 3
The number of days to be added to the invoice date or last discount date to calculate the due date of the first payment.
TE01.2
TMS-FIRST-FROM
First Payment From
Indicator
Alpha 1
Indicates whether the first net due 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
TE01.2
TMS-FIRST-NET-DAY
Element: First Net Due Day
Numeric 2
The day of the month the first payment is due. Used for multiple payment terms.
01
31
03
TE01.2
TMS-FIRST-NET-MO
Element: First Net Due Month
Alpha 2
The month the first payment is due. Used for multiple payment terms.
TE01.2
TMS-FIRST-PERCENT
First Payment
Percent
Percent 7.5 (Percent)
The percent of the invoice amount to be 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.
TE01.2
TMS-TOTAL-NBR-PMTS
Element: Total Payments
Numeric 2
The total number of payments to be scheduled for an invoice assigned this multiple payment terms code.
TE01.2
TMS-DAYS-INCR
Element: Increment by Days
Numeric 2
The number of days between scheduled payments. Used for multiple payment terms.
TE01.2
TMS-MONTH-INCR
Element: Increment by Months
Numeric 1
The number of months between scheduled payments. Used for multiple payment terms.
TE01.2
TMS-FIXED-DAYS-MO
Element: Fixed Days of Month
Numeric 2 Occurs 5 Times
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
TE01.2
TMS-FIXED-DAYS-WK
Element: Fixed Days of Week
Numeric 1 Occurs 2 Times
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
TE01.2
TMS-ADJUST-DAYS
Element: Days for Adjustment
Numeric 2
The number of adjustment days defined for a fixed days terms code. Used to adjust a payment due date when the defined days between payments falls between fixed payment days.
...
AC42.1 AC42.2
AP10.1 AP10.2
AP10.5 AP10.6
AP20.1 AP20.2
AP20.3 AP20.4
AP20.5 AP20.7
AP25.1 AP25.2
AP30.4 AR08.1
AR09.1 AR10.1
CX20.1 CX20.2
CX20.4 CX20.5
IC12.1 IC64.1
IC64.2 IC64.3
IC64.4 IC64.5
IC64.6 IC64.7
IC64.8 IC64.9
IC66.1 MA41.1
MA41.2 MA41.4
MA41.7 MA42.2
MA43.2 MA43.7
MA44.1 MA44.2
MA53.1 MA60.2
MA60.3 MA60.5
MA61.1 MA66.2
MA67.2 MA67.3
MA68.2 MA68.3
MA68.5 PD10.1
PD10.2 PD20.1
PD20.2 PD20.3
PO04.1 PO04.2
TMS-ANTICIPATION
Element: Anticipation
Alpha 1
Indicates whether the terms code is eligible for anticipation discount in the Lawson Accounts Payable system.
TE01.2
TMS-PROC-INDIC
Element: Terms Code Type
Alpha 1
Indicates the type of terms code. Valid values are P = Prox S = Split N = Net C = Prepayment M = Multiple Payment F = Fixed Days
TE01.2
TMS-ACTIVE-STATUS
Element: Status
Alpha 1
Indicates whether the terms code is active or inactive.
TE01.2
TMS-USED-FL
Element: Used Flag
Alpha 1
Indicates whether the terms code has been used. A terms code can be deleted only if it has not been used.
...
AC42.1 AC42.2
AP10.1 AP10.2
AP10.5 AP10.6
AP110 AP125
AP126 AP131
AP20.1 AP20.2
AP20.3 AP20.4
AP20.5 AP20.7
AP21.1 AP210
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.4
AP510 AP520
API1.1 API2.1
API3.1 AR08.1
AR09.1 AR10.1
AR301 AR501
AR550 ARLL.1
BR11.1 BRIP.1
CX100 CX20.1
CX20.2 CX20.4
CX20.5 CX220
CX30.1 CX300
CX506 CXCP.1
DR100 IC12.1
IC140 IC141
IC142 IC145
IC243 IC330
IC64.1 IC64.2
IC64.3 IC64.4
TMS-DESC-1
Element: Description Line 1
Derived
The first line of description defined for the terms code.
TMS-DESC-2
Element: Description Line 2
Derived
The second line of description defined for the terms code.


TERMS FILE INDEX

NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
TMSSET1 TERMS-CD
...
AC42.1 AC42.2
AP10.1 AP10.2
AP10.5 AP10.6
AP110 AP125
AP126 AP131
AP20.1 AP20.2
AP20.3 AP20.4
AP20.5 AP20.7
AP21.1 AP210
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.4
AP510 AP520
API1.1 API2.1
API3.1 AR08.1
TMSSET2 PROC-INDIC
TERMS-CD
TE200


File created: Thu Jun 09 02:33:00 2016

Home
Contact Us



All trademarks and registered trademarks are the property of their respective owners.