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