Oldest known version of this page was edited on 2007-08-30 12:40:50 by LukeK []

06 vAPI_build_assembly_item_components

Build components with quantities from assembly code

Inputs:

Input Name	Required	Type	Max Length	Details
$arg_array	YES	ASSOC	--	Details follow:
$arg_array / company_id	YES	INT	--	references: company_master.company_id
$arg_array / item_code	YES	STRING	32	references: item_master.item_code
$arg_array / customer_code	YES	STRING	128	references: customer_master.customer_code
$arg_array / warehouse_code	YES	STRING	8	references: warehouse_master.warehouse_code
$arg_array / quantity_ordered	YES	NUMERIC	15.3	Number of Assemblies ordered
$dbconn	YES	DBHANDLE	--	Database Connection

Outputs:

Output Name	Type	Details
$record	ARRAY of ASSOCs	Row details follow:
$record / item_code	STRING	references: item_master.item_code
$record / vendor_code	STRING	references: item_master.vendor_code
$record / item_type	STRING	references: item_master.item_type
$record / manufacturer	STRING	references: item_master.manufacturer
$record / description	STRING	references: item_master.description
$record / unit_of_measure	STRING	references: item_master.unit_of_measure
$record / unit_weight	NUMERIC	references: item_master.unit_weight
$record / last_cost	NUMERIC	references: item_master.last_cost
$record / standard_cost	NUMERIC	references: item_master.standard_cost
$record / average_cost	NUMERIC	references: item_master.average_cost
$record / margin_cost	NUMERIC	references: item_master.(standard/last)_cost
$record / quantity_required	NUMERIC	references: item_assembly.quantity_required
$record / quantity_backordered	NUMERIC	Calculated Quantity that will be backordered
$record / quantity_shipped	NUMERIC	Calculated Quantity Shippable

Error Codes:

PGQUERY	Failed SQL query
ITEM_CODE_ALIAS	Cannot Check Item Code Alias
NO_COMPONENTS	Assembly Has No Components

Return to:
Sales Order Processing_API Reference