10 vAPI_build_order_body_from_quote

Build an order body from a quote

Inputs:

Input Name	Required	Type	Max Length	Details
$company_id	YES	INT	--	references: company_master.company_id
$system_order_number	YES	STRING	32	references: system_order_header.system_order_number
$dbconn	YES	DBHANDLE	--	Database Connection

Outputs:

Output Name	Type	Details
$record	ARRAY of ASSOCs	Row details follow:
$record / company_id	INT	references: sales_order_line_items.company_id
$record / line_number	INT	references: sales_order_line_items.line_number
$record / parent_line_number	INT	references: sales_order_line_items.parent_line_number
$record / item_code	STRING	references: sales_order_line_items.item_code
$record / vendor_code	STRING	references: sales_order_line_items.vendor_code
$record / description	STRING	references: sales_order_line_items.description
$record / unit_of_measure	STRING	references: sales_order_line_items.unit_of_measure
$record / warehouse_code	STRING	references: sales_order_line_items.warehouse_code
$record / item_type	STRING	references: sales_order_line_items.item_type
$record / quantity_ordered	NUMERIC	references: sales_order_line_items.quantity_ordered
$record / unit_price	NUMERIC	references: sales_order_line_items.unit_price
$record / unit_cost	NUMERIC	references: sales_order_line_items.unit_cost
$record / labor_employee_code	STRING	references: sales_order_line_items.labor_employee_code
$record / line_disposition	STRING	references: sales_order_line_items.line_disposition
$record / ebay_auction_id	INT	references: ebay_auction_master.ebay_auction_id
$record / ebay_transaction_id	INT	referenecs: ebay_auction_winners.ebay_transaction_id
$record / return_code	STRING	references: sales_order_line_items.return_code
$record / taxable_flag	BOOLEAN	references: sales_order_line_items.taxable_flag
$record / labor_first_name	STRING	First Name of employee refereneced in sales_order_line_items.labor_employee_code
$record / labor_last_name	STRING	Last Name of employee refereneced in sales_order_line_items.labor_employee_code
$record / date_labor_performed	DATE	references: sales_order_line_items.labor_performed
$record / contract_price_flag	BOOLEAN	references: sales_order_line_items.contract_price_flag

Error Codes:

PGQUERY	Failed SQL query
INVALID_ORDER_STATUS	Not all orders for supplied system order number are quotes

Return to:
Sales Order Processing_API Reference