Oldest known version of this page was edited on 2007-08-30 12:30:22 by LukeK []
Page view:
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