PAYMENTTERM (4.0SP23)

ID

uniqueidentifier

ADDEDBYID

uniqueidentifier

false

FK to CHANGEAGENT.

CHANGEDBYID

uniqueidentifier

false

FK to CHANGEAGENT.

NAME

nvarchar(20)

false

Name of the payment term

DESCRIPTION

nvarchar(100)

false

Description of the payment term

INCLUDEDISCOUNT

bit

false

True if the payment term includes a discount

DISCOUNTPERCENT

decimal(20, 4)

false

Discount applied when discount terms are met

DISCOUNTDAYS

smallint

false

Number of days the payment needs to be made for the discount terms to be applied

PAYMENTDUECODE

tinyint

false

Selects how the due date of the payment is represented

PAYMENTDUE

nvarchar(12) (Computed)

true

Provides a translation for the 'PAYMENTDUECODE' field.

DAYSDUE

smallint

false

Number of days in which a payment is due. PaymentDueCode must be 'Days'

DAYOFMONTHDUE

smallint

false

Day of month on which a payment is due. PaymentDue must be 'Day of month'

MONTHDUECODE

tinyint

false

Month in which a payment is due

MONTHDUE

nvarchar(7) (Computed)

true

Provides a translation for the 'MONTHDUECODE' field.

DATEADDED

datetime

false

Indicates the date this record was added.

DATECHANGED

datetime

false

Indicates the date this record was last changed.

TS

timestamp

false

Timestamp.

TSLONG

bigint (Computed)

true

Numeric representation of the timestamp.

IX_PAYMENTTERM_DATEADDED

False

False

True

IX_PAYMENTTERM_DATECHANGED

False

False

False

PK_PAYMENTTERM

True

True

False

UIX_PAYMENTTERM_NAME

True

False

False

TR_PAYMENTTERM_AUDIT_UPDATE

TR_PAYMENTTERM_AUDIT_DELETE

VENDOR

PAYMENTTERMID