01 vAPI_add_edit_warehouse

Add/edit warehouse record

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 / warehouse_code	YES	STRING	8	references: warehouse_master.warehouse_code
$arg_array / gld_department	YES	NUMERIC	4.0	references: warehouse_master.gld_department
$arg_array / description	YES	STRING	32	references: warehouse_master.description
$arg_array / name	YES	STRING	32	references: warehouse_master.name
$arg_array / address_1	YES	STRING	32	references: warehouse_master.address_1
$arg_array / address_2	YES	STRING	32	references: warehouse_master.address_2
$arg_array / address_3	YES	STRING	32	references: warehouse_master.address_3
$arg_array / city	YES	STRING	32	references: warehouse_master.city
$arg_array / locality	YES	STRING	32	references: warehouse_master.locality
$arg_array / mailing_code	YES	STRING	16	references: warehouse_master.mailing_code
$arg_array / country	YES	STRING	32	references: warehouse_master.country
$arg_array / phone	YES	STRING	32	references: warehouse_master.phone
$arg_array / fax	YES	STRING	32	references: warehouse_master.fax
$arg_array / comments	YES	TEXT	--	references: warehouse_master.comments
$arg_array / printer_code	YES	STRING	16	references: printer_master.printer_code
$arg_array / ship_from_name	YES	STRING	50	references: warehouse_master.ship_from_name
$arg_array / ship_from_attention	YES	STRING	50	references: warehouse_master.ship_from_attention
$arg_array / ship_from_country	YES	STRING	50	references: warehouse_master.ship_from_country
$dbconn	YES	DBHANDLE	--	Database Connection

Outputs:

Output Name	Type	Details
$record	ASSOC	Details follow:
$record / action	STRING	ADD: New record was added
		EDIT: Existing record was updated

Error Codes:

PGQUERY	Failed SQL query
CHECKPOINT	Error when calling the checkpoint function

Called API Functions:
logAPI:vAPI_checkpoint_table_revision

Return to:
Warehouse_API Reference