| Input Name |
Required |
Type |
Max Length |
Details |
| $arg_array |
YES |
ASSOC |
-- |
Details follow: |
| $arg_array / company_id |
YES |
INT |
-- |
references: sales_order_header.company_id |
| $arg_array / is_quote_lookup |
NO |
BOOLEAN |
-- |
TRUE: Searches for Quotes Only |
|
|
|
|
FALSE: Removes Quotes from Search Results |
| $arg_array / query_rules |
YES |
ARRAY of ASSOCs |
-- |
Row Details Follow: |
| $arg_array / query_rules / column |
YES |
STRING |
-- |
Query Rule Column - Table Column this rule is referencing |
| $arg_array / query_rules / value |
YES |
STRING |
-- |
Query Rule Value - Value to search for in table row |
| $arg_array / query_rules / type |
NO |
STRING |
-- |
Query Rule Type - Type of operation to search with: |
|
|
|
|
LIKE: LIKE Operation (wild card on either side) |
|
|
|
|
NOTLIKE: NOT LIKE Operation (wild card on either side) |
|
|
|
|
GTHAN: Greater-Than Operation |
|
|
|
|
LTHAN: Less-Than Operation |
|
|
|
|
BETWEEN: Between Operation (Value: 'startval|||endval') |
|
|
|
|
NOTEXACT: Is Not Equal-to operation (for non-strings) |
|
|
|
|
NOTEXACTSTR: Is Not Equal-to operation (for strings) |
|
|
|
|
EXACT: Is Not Equal-to operation (for non-strings) |
|
|
|
|
EXACTSTR: Is Equal-to operation (for strings) |
|
|
|
|
- defaults to 'EXACTSTR' |
| $dbconn |
YES |
DBHANDLE |
-- |
Database Connection |
| Output Name |
Type |
Details |
| $record |
ARRAY of ASSOCs |
Row Details follow: |
| $record / sales_order_header_id |
INT |
references: sales_order_header.sales_order_header_id |
| $record / system_order_number |
STRING |
references: sales_order_header.system_order_number |
| $record / warehouse_code |
STRING |
references: sales_order_header.warehouse_code |
| $record / suborder_counter |
INT |
references: sales_order_header.suborder_counter |
| $record / customer_code |
STRING |
references: sales_order_header.customer_code |
| $record / customer_po |
STRING |
references: sales_order_header.customer_po |
| $record / original_order_status |
STRING |
references: sales_order_header.original_order_status |
| $record / last_order_status |
STRING |
references: sales_order_header.last_order_status |
| $record / order_status |
STRING |
references: sales_order_header.order_status |
| $record / cc_number |
STRING |
references: sales_order_header.cc_number |
| $record / cc_verified |
STRING |
references: sales_order_header.cc_verified |
| $record / cc_avs |
STRING |
references: sales_order_header.cc_avs |
| $record / cc_db_loc |
STRING |
customer: Credit Card info from the customer_master table or blank |
|
|
order: Credit Card info from the sales_order_header table |
| $record / billing_name |
STRING |
references: sales_order_header.billing_name |
| $record / billing_city |
STRING |
references: sales_order_header.billing_city |
| $record / date_ordered |
DATE |
references: sales_order_header.date_ordered |
|
|
Format: YYYY-MM-DD HH24:MI |
| $record / freight_in |
NUMERIC |
references: sales_order_header.freight_in |
| $record / freight_out |
NUMERIC |
references: sales_order_header.freight_out |
| $record / freight_out_actual |
STRING |
references: sales_order_header.freight_out_actual |
| $record / freight_tracking_number |
STRING |
references: sales_order_header.freight_tracking_number |
| $record / notes_count |
STRING |
Number of notes that reference this order |
| $record / sales_value |
STRING |
Total Sales Value for this order |
| $record / customer_terms_type |
STRING |
references: customer_terms_master.customer_terms_type |