Payment Terms Maintenance Database Information

Data for Payment Terms Maintenance is stored in the payment-terms table.

Fields

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]