05 vAPI_add_edit_contract_pricing

Add/edit a pricing contract 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 / employee_id	YES	INT	--	references: employee_master.employee_id
				Employee ID of the person Adding/Editing this record
$arg_array / customer_code	YES	STRING	128	references: customer_master.customer_code
$arg_array / item_code	YES	STRING	32	references: item_master.item_code
$arg_array / contract_price	YES	NUMERIC	15.5	references: pricing_contract.contract_price
$arg_array / date_expires	YES	DATE	--	references: pricing_contract.date_expires (inclusive)
				format: YYYY-MM-DD
$arg_array / description	YES	STRING	64	references: pricing_contract.description
$dbconn	YES	DBHANDLE	--	Database Connection

Outputs:

Output Name	Type	Details
$record	ASSOC	Row 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:
Pricing_API Reference