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
| PO229 | TE200 |
| 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. |
|
||
| TMS-DESC Element: Description | Alpha 30 (Lower Case) Occurs 2 Times The description of the terms code. |
|
||
| TMS-DISC-PCT Element: Disc Pct | Percent 7.5 (Percent) Occurs 3 Times The discount percent defined for the terms code. |
|
||
| 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. |
|
||
| 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. |
|
||
| 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. |
|
||
| 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). |
|
||
| 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. |
|
||
| 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. |
|
||
| 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. |
|
||
| TMS-SPLIT-DISC-DAY Element: Split Discount Day | Numeric 2 Occurs 5 Times The discount day used for the defined split invoice date range. |
|
||
| 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. |
|
||
| 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 |
|
||
| 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. |
|
||
| 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 |
|
||
| 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. |
|
||
| 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 |
|
||
| 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 |
|
||
| TMS-FIRST-NET-MO Element: First Net Due Month | Alpha 2 The month the first payment is due. Used for multiple payment terms. |
|
||
| 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. |
|
||
| 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. |
|
||
| TMS-DAYS-INCR Element: Increment by Days | Numeric 2 The number of days between scheduled payments. Used for multiple payment terms. |
|
||
| TMS-MONTH-INCR Element: Increment by Months | Numeric 1 The number of months between scheduled payments. Used for multiple payment terms. |
|
||
| 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 |
|
||
| 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 |
|
||
| 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. |
|||
| TMS-ANTICIPATION Element: Anticipation | Alpha 1 Indicates whether the terms code is eligible for anticipation discount in the Lawson Accounts Payable system. |
|
||
| 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 |
|
||
| TMS-ACTIVE-STATUS Element: Status | Alpha 1 Indicates whether the terms code is active or inactive. |
|
||
| 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. |
|||
| 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. |
|
| NAME | KEY FIELDS | DESCRIPTION / SUBSET CONDITION | USED IN | ||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|
| TMSSET1 |
TERMS-CD |
|
|||||||||
| TMSSET2 |
PROC-INDIC TERMS-CD |
|
| ||||||||
All trademarks and registered trademarks are the property of their
respective owners.