ALEX_PR_VENDOR_TERMS (Staging table)

Column name	Data type	Required	Default update able	Data target	Comments
EXTERNAL_KEY**	VARCHAR (255)	Yes*	No	ALCO_EXTERNAL_KEY.EXTERNAL_KEY	External key – primary key
NAME	VARCHAR (255)	Yes*	Yes	ALPR_VENDOR_TERMS.NAME	Description of these terms with discount, Example: 2/10 Net 30 means 2 percent discount if paid within 10 days, otherwise net 30 days
TERM_NAME	VARCHAR (255)	No	Yes	ALPR_VENDOR_TERMS.TERM_NAME	Description of these terms, example Net 30 means due within 30 days
TERM_DAYS	INTEGER	No	Yes	ALPR_VENDOR_TERMS.TERM_DAYS	How many days after receipt of an invoice is the amount due. Using the example 2/10 Net 30, this value would be 30
DISCOUNT_AMOUNT_TYPE	SMALLINT	Yes*	Yes	ALPR_VENDOR_TERMS.DISCOUNT_AMOUNT_TYPE	Discount amount type valid values are 0 or 1 where 0 - percentage and 1 - amount
DISCOUNT_AMOUNT_PERCENTAGE	NUMERIC (20, 10)	No	Yes	ALPR_VENDOR_TERMS.DISCOUNT_AMOUNT_PERCENTAGE	The discount percentage applied. Using the example 2/10 Net 30, this value would be 2. This column is applicable when discount amount type is 0. If discount amount type is 1, this column is ignored.
DISCOUNT_AMOUNT	NUMERIC (20, 10)	No	Yes	ALPR_VENDOR_TERMS.DISCOUNT_AMOUNT	The discount amount. This column is applicable when the discount amount type is 1. When the discount amount type is 0, this column is ignored.
DISCOUNT_AMOUNT_EKEY	VARCHAR (255)	No	Yes	ALPR_VENDOR_TERMS.DISCOUNT_AMOUNT_ID	External key identifying currency of discount amount
DISCOUNT_TERM_DAYS	INTEGER	No	Yes	ALPR_VENDOR_TERMS.DISCOUNT_TERM_DAYS	How many days after receipt of an invoice is the amount due with the discount. Using the example 2/10 Net30, this value would be 10
IS_GLOBAL_DEFAULT	SMALLINT	Yes*	Yes	ALPR_VENDOR_TERMS.IS_GLOBAL_DEFAULT	Is this term global default? There can only be one that is the global default. 1 = Yes 0 = No
ACTIVE_STATUS	SMALLINT	Yes*	Yes	ALPR_VENDOR_TERMS.ACTIVE_STATUS	Is this active/inactive? 1 = Yes 0 = No

* System required field

** Value must be unique