27 vAPI_get_nonstock

Get a non-stock item record

Inputs:

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

Outputs:

Output Name	Type	Details
$record	ASSOC	Details follow:
$record / company_id	INT	references: nonstock_master.company_id
$record / vendor_code	STRING	references: nonstock_master.vendor_code
$record / item_code	STRING	references: nonstock_master.item_code
$record / item_type	STRING	references: nonstock_master.item_type
$record / description	STRING	references: nonstock_master.description
$record / product_class	INT	references: nonstock_master.product_class
$record / unit_of_measure	STRING	references: nonstock_master.unit_of_measure
$record / unit_weight	NUMERIC	references: nonstock_master.unit_weight
$record / retail_price	NUMERIC	references: nonstock_master.retail_price
$record / list_price	NUMERIC	references: nonstock_master.list_price
$record / last_cost	NUMERIC	references: nonstock_master.last_cost
$record / item_matrix	INT	references: nonstock_master.item_matrix
$record / taxable_flag	BOOLEAN	references: nonstock_master.taxable_flag
$record / date_added	DATE	references: nonstock_master.date_added
		format: YYYY-MM-DD H24:MI
$record / added_by	STRING	references: nonstock_master.added_by
$record / date_last_sale	DATE	references: nonstock_master.date_last_sale
		format: YYYY-MM-DD
$record / quantity_sold	INT	Total amount of this item sold
$record / times_sold	STRING	Number of times this nonstock item has been sold

Error Codes:

PGQUERY

Failed SQL query

Return to:
Item_API Reference