Most recent edit on 2007-08-29 15:02:23 by LukeK
Additions:
06 vAPI_add_edit_customer_terms
| 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 |
| $arg_array / customer_terms_code |
YES |
STRING |
8 |
references: customer_terms_master.customer_terms_code |
| $arg_array / customer_terms_type |
YES |
ENUM |
-- |
references: customer_terms_master.customer_terms_type |
|
|
|
|
DPRS: Cash ONLY |
|
|
|
|
CC: Credit card |
|
|
|
|
CASH: Cash |
|
|
|
|
COD: Cash on delivery |
|
|
|
|
ACH: Wire transfer |
|
|
|
|
OPEN: Charge sales |
|
|
|
|
SVC: Service charge |
|
|
|
|
PP: PayPal |
|
|
|
|
AZ: Amazon |
|
|
|
|
INT: Internal charge |
| $arg_array / terms_descr |
YES |
STRING |
32 |
references: customer_terms_master.terms_descr |
| $arg_array / invoice_descr |
YES |
STRING |
75 |
references: customer_terms_master.invoice_descr |
| $arg_array / extended_invoice_descr |
YES |
TEXT |
-- |
references: customer_terms_master.extended_invoice_descr |
| $arg_array / statement_email_txt |
YES |
TEXT |
-- |
references: customer_terms_master.statement_email_txt |
| $arg_array / sort_order |
YES |
INT |
-- |
references: customer_terms_master.sort_order |
| $dbconn |
YES |
DBHANDLE |
-- |
Database Connection |
Deletions:
06 vAPI_add_edit_customer_terms
| Input Name |
Requred |
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 |
| $arg_array / customer_terms_code |
YES |
STRING |
8 |
references: customer_terms_master.customer_terms_code |
| $arg_array / customer_terms_type |
YES |
ENUM |
|
references: customer_terms_master.customer_terms_type |
|
|
|
|
DPRS: Cash ONLY |
|
|
|
|
CC: Credit card |
|
|
|
|
CASH: Cash |
|
|
|
|
COD: Cash on delivery |
|
|
|
|
ACH: Wire transfer |
|
|
|
|
OPEN: Charge sales |
|
|
|
|
SVC: Service charge |
|
|
|
|
PP: PayPal |
|
|
|
|
AZ: Amazon |
|
|
|
|
INT: Internal charge |
| $arg_array / terms_descr |
YES |
STRING |
32 |
references: customer_terms_master.terms_descr |
| $arg_array / invoice_descr |
YES |
STRING |
75 |
references: customer_terms_master.invoice_descr |
| $arg_array / extended_invoice_descr |
YES |
TEXT |
|
references: customer_terms_master.extended_invoice_descr |
| $arg_array / statement_email_txt |
YES |
TEXT |
|
references: customer_terms_master.statement_email_txt |
| $arg_array / sort_order |
YES |
INT |
|
references: customer_terms_master.sort_order |
| $dbconn |
YES |
DBHANDLE |
|
Database Connection |
Oldest known version of this page was edited on 2007-08-27 13:56:49 by LukeK []
Page view:
06 vAPI_add_edit_customer_terms
Add or edit customer terms record
Inputs:
| Input Name |
Requred |
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 |
| $arg_array / customer_terms_code |
YES |
STRING |
8 |
references: customer_terms_master.customer_terms_code |
| $arg_array / customer_terms_type |
YES |
ENUM |
|
references: customer_terms_master.customer_terms_type |
|
|
|
|
DPRS: Cash ONLY |
|
|
|
|
CC: Credit card |
|
|
|
|
CASH: Cash |
|
|
|
|
COD: Cash on delivery |
|
|
|
|
ACH: Wire transfer |
|
|
|
|
OPEN: Charge sales |
|
|
|
|
SVC: Service charge |
|
|
|
|
PP: PayPal |
|
|
|
|
AZ: Amazon |
|
|
|
|
INT: Internal charge |
| $arg_array / terms_descr |
YES |
STRING |
32 |
references: customer_terms_master.terms_descr |
| $arg_array / invoice_descr |
YES |
STRING |
75 |
references: customer_terms_master.invoice_descr |
| $arg_array / extended_invoice_descr |
YES |
TEXT |
|
references: customer_terms_master.extended_invoice_descr |
| $arg_array / statement_email_txt |
YES |
TEXT |
|
references: customer_terms_master.statement_email_txt |
| $arg_array / sort_order |
YES |
INT |
|
references: customer_terms_master.sort_order |
| $dbconn |
YES |
DBHANDLE |
|
Database Connection |
Outputs:
| Output Name |
Type |
Details |
| $record |
ASSOC |
Details follow: |
| $record / action |
STRING |
ADD: A new record was added |
|
|
EDIT: An 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:
Customer_API Reference