TERMS – Payment Terms Maintenance

System
Terms (TE)
Prefix
TMS
Primary key
TERMS-CD
Fields
34
Updated by
256 programs
Referenced by
1 program

TERMS is the Payment Terms Maintenance table in Lawson Terms (prefix TMS). It is indexed by TERMS-CD (TMSSET1); alternate indexes: TMSSET2. It is updated by AC42.1, AC42.2, AP10.1, AP10.2, AP10.5, AP10.6, AP110, AP125 and 248 more and referenced by TE200. The table has 34 fields, 2 indexes and 0 documented relations.

About 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.

Fields (34)

Column = COBOL field name without the TMS- prefix, hyphens → underscores. Derived fields are computed by the application and are not stored.

Field / columnTypeDescription & valuesUpdated by
TMS-TERMS-CD PK
TERMS_CD		Alpha 5A user-defined code associated with user-defined payment terms. Used to calculate due date and discount information for an invoice.TE01.2
TMS-DESC
DESC		Alpha 30 (Lower Case)Occurs 2 Times The description of the terms code.TE01.2
TMS-DISC-PCT
DISC_PCT		Percent 7.5 (Percent) Occurs 3 Times ×3The discount percent defined for the terms code.TE01.2
TMS-DISCOUNT-DAY
DISCOUNT_DAY		Numeric 3 Occurs 3 Times ×3The 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
DISC_MONTH		Alpha 2 Occurs 3 Times ×3The discount month defined for the terms code. Identifies the month in which the discount will be taken.TE01.2
TMS-DISC-DAY
DISC_DAY		Numeric 2 Occurs 3 Times ×3The 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
DISC_DUE_MNTH		Numeric 2The number of additional months to be added to the calculated discount date.—
TMS-CUT-OFF-DAY
CUT_OFF_DAY		Numeric 2The 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
PROX_DAY		Numeric 2 Occurs 2 Times ×2The day of the month used to calculate the discount date and, optionally, the net due date.TE01.2
TMS-SPLIT-BEG-DAY
SPLIT_BEG_DAY		Numeric 2 Occurs 5 Times ×5The beginning day of the invoice date range. Used for split terms.TE01.2
TMS-SPLIT-END-DAY
SPLIT_END_DAY		Numeric 2 Occurs 5 Times ×5The ending date of the invoice date range. Used for split terms.TE01.2
TMS-SPLIT-DISC-DAY
SPLIT_DISC_DAY		Numeric 2 Occurs 5 Times ×5The discount day used for the defined split invoice date range.TE01.2
TMS-SPLIT-NET-DAY
SPLIT_NET_DAY		Numeric 2 Occurs 5 Times ×5The net due day used for the defined split invoice date range.TE01.2
TMS-SPLIT-EOM-FLAG
SPLIT_EOM_FLAG		Alpha 1 Occurs 5 Times ×5Indicates 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
SPLIT_MO_FORW		Numeric 2 Occurs 5 Times ×5The 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
EOM_INDIC		Alpha 1Indicates 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
FINAL_DUE_DAY		Numeric 2This 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
FIRST_NET_DAYS		Numeric 3The 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_FROM		Alpha 1Indicates 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
FIRST_NET_DAY		Numeric 2The day of the month the first payment is due. Used for multiple payment terms. 01 31 03TE01.2
TMS-FIRST-NET-MO
FIRST_NET_MO		Alpha 2The month the first payment is due. Used for multiple payment terms.TE01.2
TMS-FIRST-PERCENT
FIRST_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
TOTAL_NBR_PMTS		Numeric 2The total number of payments to be scheduled for an invoice assigned this multiple payment terms code.TE01.2
TMS-DAYS-INCR
DAYS_INCR		Numeric 2The number of days between scheduled payments. Used for multiple payment terms.TE01.2
TMS-MONTH-INCR
MONTH_INCR		Numeric 1The number of months between scheduled payments. Used for multiple payment terms.TE01.2
TMS-FIXED-DAYS-MO
FIXED_DAYS_MO		Numeric 2 Occurs 5 Times ×5A 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 31TE01.2
TMS-FIXED-DAYS-WK
FIXED_DAYS_WK		Numeric 1 Occurs 2 Times ×2A 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
ADJUST_DAYS		Numeric 2The 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 +52 more (list truncated in source)
TMS-ANTICIPATION
ANTICIPATION		Alpha 1Indicates whether the terms code is eligible for anticipation discount in the Lawson Accounts Payable system.TE01.2
TMS-PROC-INDIC
PROC_INDIC		Alpha 1Indicates 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
ACTIVE_STATUS		Alpha 1Indicates whether the terms code is active or inactive.TE01.2
TMS-USED-FL
USED_FL		Alpha 1Indicates 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 +52 more (list truncated in source)
TMS-DESC-1
DESC_1		DerivedThe first line of description defined for the terms code.—
TMS-DESC-2
DESC_2		DerivedThe second line of description defined for the terms code.—

Indexes (2)

Keys marked * are descending. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.

IndexKeysFlagsConditionUsed in
TMSSET1TERMS-CDPrimaryAC42.1, AC42.2, AP10.1, AP10.2, AP10.5, AP10.6, AP110, AP125 +22 more (list truncated in source)
TMSSET2PROC-INDIC, TERMS-CDTE200

Programs

Updated by (256)

Referenced by (1)