EndPoint Get Purchase Orders

Contents

1 Label
2 Description
3 Parameters
4 Output Columns
5 Input Columns

Name

get_purchase_orders

Description

No description available

Parameters

Parameter	Label	Required	Options	Description
There are no parameters

Output Columns

Label	Data Type (SSIS)	Data Type (SQL)	Length	Raw
id	`DT_WSTR`	`nvarchar(100)`	100	False
owner_email_id	`DT_WSTR`	`nvarchar(100)`	100	False
owner_is_technician	`DT_BOOL`	`bit`		False
owner_sms_mail	`DT_WSTR`	`nvarchar(1020)`	1020	False
owner_mobile	`DT_WSTR`	`nvarchar(50)`	50	False
owner_last_name	`DT_WSTR`	`nvarchar(50)`	50	False
owner_user_scope	`DT_WSTR`	`nvarchar(100)`	100	False
owner_sms_mail_id	`DT_WSTR`	`nvarchar(1020)`	1020	False
owner_phone	`DT_WSTR`	`nvarchar(1020)`	1020	False
owner_employee_id	`DT_WSTR`	`nvarchar(50)`	50	False
owner_name	`DT_WSTR`	`nvarchar(50)`	50	False
owner_id	`DT_WSTR`	`nvarchar(100)`	100	False
owner_photo_url	`DT_WSTR`	`nvarchar(500)`	500	False
owner_is_vip_user	`DT_BOOL`	`bit`		False
owner_department	`DT_WSTR`	`nvarchar(1020)`	1020	False
owner_first_name	`DT_WSTR`	`nvarchar(50)`	50	False
owner_job_title	`DT_WSTR`	`nvarchar(1020)`	1020	False
template_inactive	`DT_BOOL`	`bit`		False
template_name	`DT_WSTR`	`nvarchar(100)`	100	False
template_id	`DT_WSTR`	`nvarchar(100)`	100	False
required_date_display_value	`DT_WSTR`	`nvarchar(50)`	50	False
required_date_value	`DT_WSTR`	`nvarchar(100)`	100	False
total_price_display_value	`DT_WSTR`	`nvarchar(50)`	50	False
total_price_currency_symbol	`DT_WSTR`	`nvarchar(50)`	50	False
total_price_value	`DT_R8`	`float`		False
total_price_secondary_currency_display_value	`DT_R8`	`float`		False
total_price_secondary_currency_currency_symbol	`DT_WSTR`	`nvarchar(50)`	50	False
total_price_secondary_currency_value	`DT_R8`	`float`		False
custom_id	`DT_WSTR`	`nvarchar(50)`	50	False
sites	`DT_WSTR`	`nvarchar(500)`	500	False
requested_by_email_id	`DT_WSTR`	`nvarchar(100)`	100	False
requested_by_is_technician	`DT_BOOL`	`bit`		False
requested_by_sms_mail	`DT_WSTR`	`nvarchar(1020)`	1020	False
requested_by_mobile	`DT_WSTR`	`nvarchar(50)`	50	False
requested_by_last_name	`DT_WSTR`	`nvarchar(50)`	50	False
requested_by_user_scope	`DT_WSTR`	`nvarchar(100)`	100	False
requested_by_sms_mail_id	`DT_WSTR`	`nvarchar(1020)`	1020	False
requested_by_phone	`DT_WSTR`	`nvarchar(1020)`	1020	False
requested_by_employee_id	`DT_WSTR`	`nvarchar(50)`	50	False
requested_by_name	`DT_WSTR`	`nvarchar(50)`	50	False
requested_by_id	`DT_WSTR`	`nvarchar(100)`	100	False
requested_by_photo_url	`DT_WSTR`	`nvarchar(500)`	500	False
requested_by_is_vip_user	`DT_BOOL`	`bit`		False
requested_by_department	`DT_WSTR`	`nvarchar(1020)`	1020	False
requested_by_first_name	`DT_WSTR`	`nvarchar(50)`	50	False
requested_by_job_title	`DT_WSTR`	`nvarchar(1020)`	1020	False
vendor_name	`DT_WSTR`	`nvarchar(50)`	50	False
vendor_description	`DT_WSTR`	`nvarchar(100)`	100	False
vendor_currency_symbol	`DT_WSTR`	`nvarchar(50)`	50	False
vendor_currency_code	`DT_WSTR`	`nvarchar(50)`	50	False
vendor_currency_exchange_rate	`DT_WSTR`	`nvarchar(50)`	50	False
vendor_currency_name	`DT_WSTR`	`nvarchar(50)`	50	False
vendor_currency_id	`DT_WSTR`	`nvarchar(100)`	100	False
vendor_id	`DT_WSTR`	`nvarchar(100)`	100	False
name	`DT_WSTR`	`nvarchar(50)`	50	False
currency_symbol	`DT_WSTR`	`nvarchar(50)`	50	False
currency_code	`DT_WSTR`	`nvarchar(50)`	50	False
currency_exchange_rate	`DT_WSTR`	`nvarchar(50)`	50	False
currency_name	`DT_WSTR`	`nvarchar(50)`	50	False
currency_id	`DT_WSTR`	`nvarchar(100)`	100	False
created_date_display_value	`DT_WSTR`	`nvarchar(50)`	50	False
created_date	`DT_DBTIMESTAMP`	`datetime`		False
status_name	`DT_WSTR`	`nvarchar(100)`	100	False
status_id	`DT_WSTR`	`nvarchar(100)`	100	False
required_date	`DT_WSTR`	`nvarchar(1020)`	1020	False

Input Columns

Label	Data Type (SSIS)	Data Type (SQL)	Length	Raw	Description
There are no Static columns defined for this endpoint. This endpoint detects columns dynamically at runtime.