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

Main Tab Fields

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

Prox Terms Tab Fields

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]

Split Terms Tab Fields

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]

Calendar Terms Tab Fields

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]