| Name | Description | Type | Additional information |
|---|---|---|---|
| id | integer |
None. |
|
| ordertype | integer |
None. |
|
| companyid | integer |
None. |
|
| customerid | integer |
None. |
|
| adjustment | decimal number |
None. |
|
| istaxable | boolean |
None. |
|
| status | string |
None. |
|
| orderno | string |
None. |
|
| seq | integer |
None. |
|
| notes | string |
None. |
|
| createby | string |
None. |
|
| createdate | date |
None. |
|
| updateby | string |
None. |
|
| updatedate | date |
None. |
|
| salesrep | string |
None. |
|
| orderdate | date |
None. |
|
| currency | string |
None. |
|
| title | string |
None. |
|
| terms | string |
None. |
|
| tax | decimal number |
None. |
|
| discount | decimal number |
None. |
|
| shippingcharges | decimal number |
None. |
|
| holdfordays | decimal number |
None. |
|
| returnfee | decimal number |
None. |
|
| authorizedby | string |
None. |
|
| authorizationnotes | string |
None. |
|
| signfile | string |
None. |
|
| cno | string |
None. |
|
| projid | integer |
None. |
|
| taskid | integer |
None. |
|
| pricingtype | string |
None. |
|
| mforderno | string |
None. |
|
| printtotalonly | boolean |
None. |
|
| deliverynotes | string |
None. |
|
| deliveredon | date |
None. |
|
| cidprooftype | string |
None. |
|
| cidnumber | string |
None. |
|
| cidexpiry | date |
None. |
|
| lastaction | string |
None. |
|
| collectedon | date |
None. |
|
| signedby | string |
None. |
|
| origin | string |
None. |
|
| isposted | boolean |
None. |
|
| postdate | date |
None. |
|
| postedby | string |
None. |
|
| donotpost | boolean |
None. |
|
| paiddate | date |
None. |
|
| tags | string |
None. |
|
| roe | decimal number |
None. |
|
| rpt_link | string |
None. |
|
| deletedate | date |
None. |
|
| deleteby | string |
None. |
|
| tpcode | string |
None. |
|
| payment_terms | string |
None. |
|
| customer_contact | integer |
None. |
|
| discount_type | string |
None. |
|
| dis_amt | decimal number |
None. |
|
| line_total_amt | decimal number |
None. |
|
| txntype | string |
None. |
|
| ticketid | integer |
None. |
|
| priority | string |
None. |
|
| delivery | boolean |
None. |
|
| delivery_region | integer |
None. |
|
| dod | date |
None. |
|
| tod | time interval |
None. |
|
| dept_id | integer |
None. |
|
| duedate | date |
None. |
|
| deliverytime | time interval |
None. |
|
| standing_order_id | integer |
None. |
|
| notify_customer | boolean |
None. |
|
| total_amt | decimal number |
None. |
|
| publicid | string |
None. |
|
| guest_name | string |
None. |
|
| guest_email | string |
None. |
|
| guest_phone | string |
None. |
|
| guest_address | string |
None. |
|
| customer_notes | string |
None. |
|
| start_time | time interval |
None. |
|
| end_time | time interval |
None. |
|
| tblid | integer |
None. |
|
| invid | integer |
None. |
|
| delivery_address | integer |
None. |
|
| tpid | string |
None. |
|
| print_template | string |
None. |
|
| delivery_type | string |
None. |
|
| delivery_category | string |
None. |
|
| delivery_mode | string |
None. |
|
| t_customer_departments | t_customer_departments |
None. |
|
| t_customercontacts | t_customercontacts |
None. |
|
| t_customersites | t_customersites |
None. |
|
| t_orderentry | Collection of t_orderentry |
None. |
|
| t_ordertype | t_ordertype |
None. |
|
| t_projects | t_projects |
None. |
|
| t_tasks | t_tasks |
None. |
|
| t_tickets | t_tickets |
None. |
|
| t_ordertransactions | Collection of t_ordertransactions |
None. |
|
| t_customers | t_customers |
None. |
|
| t_standing_orders | t_standing_orders |
None. |
|
| t_routes | t_routes |
None. |
|
| t_routes1 | t_routes |
None. |