Version 2025.01

Modifications in Infor Expense Management 2025.01

CREATE TABLE alpr_vendor_type (
vendor_type_id	int	NOT NULL
user_id	int
vendor_type_name	nvarchar(255)
vendor_type_active_status	smallint	NOT NULL
is_pcard_supported	smallint
ccard_id	int
external_sys_id	nvarchar(255)
marketsite_participant_id	nvarchar(255)
agreement_number	nvarchar(255)
delivery_date_constant	int
payment_term_id	int
response_date_constant	int
punch_out_identity	nvarchar(100)
punch_out_user_id	nvarchar(100)
punch_out_pwd	nvarchar(100)
punch_out_url	nvarchar(250)
order_request_url	nvarchar(250)
change_timestamp	datetime
app_type	int	NOT NULL
vendor_terms_id	int
vendor_id	nvarchar(255)
is_payment_taxable	smallint	DEFAULT 0 NOT NULL
tax_code	nvarchar(255)
tax_id	nvarchar(255)
system_code_1	nvarchar(255)
system_code_2	nvarchar(255)
system_code_3	nvarchar(255)
system_code_4	nvarchar(255)
system_code_5	nvarchar(255)
system_code_6	nvarchar(255)
system_code_7	nvarchar(255)
system_code_8	nvarchar(255)
is_one_time_only	smallint	DEFAULT 0 NOT NULL
default_currency_id	int
CONSTRAINT PK__alp27C3E46E PRIMARY KEY CLUSTERED (vendor_type_id)
)