Most recent edit on 2007-08-29 15:48:05 by LukeK
No differences.
Edited on 2007-08-29 15:47:55 by LukeK
Additions:
| Output Name |
Type |
Details |
| $record |
ARRAY of ASSOCs |
Details follow: |
| $record[0] / return_code |
STRING |
Empty on success, ERROR on error |
| $record[0] / return_string |
STRING |
Human readable results string |
| $record[n] / line_number |
INT |
Line number |
| $record[n] / item_code |
STRING |
Item code |
| $record[n] / delta |
NUMERIC |
Delta percent |
| $record[n] / result_code |
STRING |
Result code |
| $record[n] / result_string |
STRING |
Result string |
Deletions:
| Output Name |
Type |
Details |
| $record |
ARRAY of ASSOCs |
Details follow: |
| $record[0] / return_code |
STRING |
Empty on success, ERROR on error |
| $record[0] / return_string |
STRING |
Human readable results string |
| $record[n] / line_number |
INT |
$record[n] / item_code |
| STRING |
$record[n] / delta |
NUMERIC |
| $record[n] / result_code |
STRING |
$record[n] / result_string |
| STRING |
Edited on 2007-08-29 14:11:08 by LukeK
Additions:
07 vAPI_approve_count_sheet
| Input Name |
Required |
Type |
Max Length |
Details |
| $arg_array |
YES |
ASSOC |
-- |
Argument Array - Details Follow: |
| $arg_array / company_id |
YES |
INT |
-- |
references: company_master.company_id |
| $arg_array / count_sheet_header_id |
YES |
INT |
-- |
references: count_sheet_header.count_sheet_header_id |
| $dbconn |
YES |
DBHANDLE |
-- |
Database Connection |
| Output Name |
Type |
Details |
| $record |
ARRAY of ASSOCs |
Details follow: |
| $record[0] / return_code |
STRING |
Empty on success, ERROR on error |
| $record[0] / return_string |
STRING |
Human readable results string |
| $record[n] / line_number |
INT |
$record[n] / item_code |
| STRING |
$record[n] / delta |
NUMERIC |
| $record[n] / result_code |
STRING |
$record[n] / result_string |
| STRING |
| PGQUERY |
Failed SQL query |
| INVALID_STATUS |
Status of count sheet not |
Deletions:
07 vAPI_approve_count_sheet
| Input Name |
Requred |
Type |
Max Length |
Details |
| $arg_array |
YES |
ASSOC |
— |
Argument Array - Details Follow: |
| $arg_array / company_id |
YES |
INT |
— |
references: company_master.company_id |
| $arg_array / count_sheet_header_id |
YES |
INT |
— |
references: count_sheet_header.count_sheet_header_id |
| $dbconn |
YES |
DBHANDLE |
— |
Database Connection |
| Output Name |
Type |
Details |
| $record |
ARRAY of ASSOCs |
Details follow: |
| $record[0] / return_code |
STRING |
Empty on success, ERROR on error |
| $record[0] / return_string |
STRING |
Human readable results string |
| $record[n] / line_number |
INT |
|
| $record[n] / item_code |
STRING |
|
| $record[n] / delta |
NUMERIC |
|
| $record[n] / result_code |
STRING |
|
| $record[n] / result_string |
STRING |
|
| PGQUERY |
Failed SQL query |
| INVALID_STATUS |
Status of count sheet not “C” |
| INVALID_FIELD |
Warehouse update field is invalid |
Oldest known version of this page was edited on 2007-08-24 11:04:19 by LukeK []
Page view:
07 vAPI_approve_count_sheet
Approve a count sheet
Inputs:
| Input Name |
Requred |
Type |
Max Length |
Details |
| $arg_array |
YES |
ASSOC |
— |
Argument Array - Details Follow: |
| $arg_array / company_id |
YES |
INT |
— |
references: company_master.company_id |
| $arg_array / count_sheet_header_id |
YES |
INT |
— |
references: count_sheet_header.count_sheet_header_id |
| $dbconn |
YES |
DBHANDLE |
— |
Database Connection |
Outputs:
| Output Name |
Type |
Details |
| $record |
ARRAY of ASSOCs |
Details follow: |
| $record[0] / return_code |
STRING |
Empty on success, ERROR on error |
| $record[0] / return_string |
STRING |
Human readable results string |
| $record[n] / line_number |
INT |
|
| $record[n] / item_code |
STRING |
|
| $record[n] / delta |
NUMERIC |
|
| $record[n] / result_code |
STRING |
|
| $record[n] / result_string |
STRING |
|
Error Codes:
| PGQUERY |
Failed SQL query |
| INVALID_STATUS |
Status of count sheet not “C” |
| INVALID_FIELD |
Warehouse update field is invalid |
Called API Functions:
warehouseAPI: vAPI_update_item_warehouse
Return to:
CountSheet_API Reference