Data for Payment Terms Maintenance is stored in the payment-terms table.
Field |
Field Name |
Terms Code |
terms-code |
Field |
Field Name |
Description |
description |
Credit Hold Term |
credit-hold-term |
Exclude Shipping Charge |
discount-exclude-shipping |
Ignore Credit Check |
ignore-credit-check |
Exclude Tax |
discount-exclude-tax |
Guaranteed Funds |
guaranteed-funds |
Finance |
finance-terms |
Terms Type |
term-type |
Discount Mask |
discount-acct-mask |
Discount % |
discount-percent |
Discount Days |
discount-days-due |
Net Days |
days |
Day-of-month |
day-of-month |
Institution |
billing-customer-key |
Factor Client Code |
factor-client-code |
Factor Terms Code |
factor-terms-code |
Credit Hold Required Date Threshold |
factor-threshold-days |
Approval Export Program |
terms-approval-export-pgm |
Approval Import Program |
terms-approval-import-pgm |
Approval Expiration Days |
approval-expiration-days |
Credit Card Authorization Valid for |
cc-reauth-in-x-days |
Percent |
percent |
Provider Charge |
provider-charge |
This tab is only available if you select the Prox Terms radio button.
Field |
Field Name |
End Day (Range 1) |
prox-end-date |
Determine Due Date Using Net Days (Range 1) |
prox-net-days[1] |
Discount # of Months Forward (Range 1) |
prox-discount-day[1] |
Discount % (Range 1) |
prox-discount-amount[1] |
Due # of Months Forward (Range 1) |
prox-due-date[1] |
Due Day of Month (Range 1) |
prox-due-date[1] |
Due Net Days (Range 1) |
prox-due-date[1] |
Discount Day of Month (Range 1) |
prox-discount-day[1] |
Determine Due Date Using Net Days (Range 2) |
prox-net-days[2] |
Discount # of Months Forward (Range 2) |
prox-discount-day[2] |
Discount % (Range 2) |
prox-discount-amount[2] |
Due # of Months Forward (Range 2) |
prox-due-date[2] |
Due Day of Month (Range 2) |
prox-due-date[2] |
Due Net Days (Range 2) |
prox-due-date[2] |
Discount Day of Month (Range 2) |
prox-discount-day[2] |
This tab is only available if you select the Split Terms radio button.
Field |
Field Name |
Payment % |
percent[1]-percent[12] |
Payment Amount |
amt[1]-amt[12] |
Net Due Days |
days[1]-days[12] |
Discount % |
discount-percent[1]-discount-percent[12] |
Discount Due Days |
discount-days-due[1]-discount-days-due[12] |
This tab is only available if you select the Calendar Terms radio button.
Field |
Field Name |
From Date |
cycl-date-from[1]-cycl-date-from[13] |
To Date |
cycl-date-to[1]-cycl-date-to[13] |
Pay Date |
cycl-pay-date[1]-cycl-pay-date[13] |
Disc Date |
cycl-discount-date[1]-cycl-discount-date[13] |
Disc Percent |
cycl-discount-percent[1]-cycl-discount-percent[13] |