Most recent edit on 2007-08-29 15:06:06 by LukeK
Additions:
14 vAPI_add_edit_customer_shipto
| 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 / customer_code |
YES |
STRING |
128 |
references: customer_master.customer_code |
| $arg_array / shipto_code |
YES |
STRING |
32 |
references: customer_shipto.shipto_code |
| $arg_array / name |
YES |
STRING |
64 |
references: customer_shipto.name |
| $arg_array / address_1 |
YES |
STRING |
64 |
references: customer_shipto.address_1 |
| $arg_array / address_2 |
YES |
STRING |
64 |
references: customer_shipto.address_2 |
| $arg_array / address_3 |
YES |
STRING |
64 |
references: customer_shipto.address_3 |
| $arg_array / city |
YES |
STRING |
32 |
references: customer_shipto.city |
| $arg_array / locality |
YES |
STRING |
32 |
references: customer_shipto.locality |
| $arg_array / mailing_code |
YES |
STRING |
16 |
references: customer_shipto.mailing_code |
| $arg_array / country |
YES |
STRING |
32 |
references: customer_shipto.country |
| $arg_array / phone |
YES |
STRING |
32 |
references: customer_shipto.phone |
| $arg_array / tax_jurisdiction_code |
YES |
STRING |
16 |
references: tax_jurisdicition_master.tax_jurisdiction_code |
| $arg_array / tax_exempt_flag |
YES |
BOOLEAN |
|
references: customer_shipto.tax_exempt_flag |
| $dbconn |
YES |
DBHANDLE |
-- |
Database Connection |
Deletions:
14 vAPI_add_edit_customer_shipto
| 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 / customer_code |
YES |
STRING |
128 |
references: customer_master.customer_code |
| $arg_array / shipto_code |
YES |
STRING |
32 |
references: customer_shipto.shipto_code |
| $arg_array / name |
YES |
STRING |
64 |
references: customer_shipto.name |
| $arg_array / address_1 |
YES |
STRING |
64 |
references: customer_shipto.address_1 |
| $arg_array / address_2 |
YES |
STRING |
64 |
references: customer_shipto.address_2 |
| $arg_array / address_3 |
YES |
STRING |
64 |
references: customer_shipto.address_3 |
| $arg_array / city |
YES |
STRING |
32 |
references: customer_shipto.city |
| $arg_array / locality |
YES |
STRING |
32 |
references: customer_shipto.locality |
| $arg_array / mailing_code |
YES |
STRING |
16 |
references: customer_shipto.mailing_code |
| $arg_array / country |
YES |
STRING |
32 |
references: customer_shipto.country |
| $arg_array / phone |
YES |
STRING |
32 |
references: customer_shipto.phone |
| $arg_array / tax_jurisdiction_code |
YES |
STRING |
16 |
references: tax_jurisdicition_master.tax_jurisdiction_code |
| $arg_array / tax_exempt_flag |
YES |
BOOLEAN |
|
references: customer_shipto.tax_exempt_flag |
| $dbconn |
YES |
DBHANDLE |
— |
Database Connection |
Edited on 2007-08-27 17:04:32 by LukeK
Additions:
| PGQUERY |
Failed SQL query |
| INVALID_TAX_CODE |
Tax code supplied is invalid |
| CHECKPOINT |
Error when calling the checkpoint function |
Deletions:
| PGQUERY |
Failed SQL queryINVALID_TAX_CODE |
| Tax code supplied is invalid |
CHECKPOINT |
| Error when calling the checkpoint function |
Oldest known version of this page was edited on 2007-08-27 17:04:17 by LukeK []
Page view:
14 vAPI_add_edit_customer_shipto
Add/edit customer ship-to record
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 / customer_code |
YES |
STRING |
128 |
references: customer_master.customer_code |
| $arg_array / shipto_code |
YES |
STRING |
32 |
references: customer_shipto.shipto_code |
| $arg_array / name |
YES |
STRING |
64 |
references: customer_shipto.name |
| $arg_array / address_1 |
YES |
STRING |
64 |
references: customer_shipto.address_1 |
| $arg_array / address_2 |
YES |
STRING |
64 |
references: customer_shipto.address_2 |
| $arg_array / address_3 |
YES |
STRING |
64 |
references: customer_shipto.address_3 |
| $arg_array / city |
YES |
STRING |
32 |
references: customer_shipto.city |
| $arg_array / locality |
YES |
STRING |
32 |
references: customer_shipto.locality |
| $arg_array / mailing_code |
YES |
STRING |
16 |
references: customer_shipto.mailing_code |
| $arg_array / country |
YES |
STRING |
32 |
references: customer_shipto.country |
| $arg_array / phone |
YES |
STRING |
32 |
references: customer_shipto.phone |
| $arg_array / tax_jurisdiction_code |
YES |
STRING |
16 |
references: tax_jurisdicition_master.tax_jurisdiction_code |
| $arg_array / tax_exempt_flag |
YES |
BOOLEAN |
|
references: customer_shipto.tax_exempt_flag |
| $dbconn |
YES |
DBHANDLE |
— |
Database Connection |
Outputs:
| Output Name |
Type |
Details |
| $record |
ASSOC |
Row Details follow: |
| $record / action |
STRING |
ADD: New record added |
|
|
EDIT: Existing record edited |
Error Codes:
| PGQUERY |
Failed SQL queryINVALID_TAX_CODE |
| Tax code supplied is invalid |
CHECKPOINT |
| Error when calling the checkpoint function |
Called API Functions:
logAPI:vAPI_checkpoint_table_revision
Return to:
Customer_API Reference