| Name | Description | Type | Additional information |
|---|---|---|---|
| id | integer |
None. |
|
| projid | integer |
None. |
|
| companyid | integer |
None. |
|
| estno | string |
None. |
|
| invdate | date |
None. |
|
| duedate | date |
None. |
|
| terms | string |
None. |
|
| notes | string |
None. |
|
| seq | integer |
None. |
|
| invno | string |
None. |
|
| status | string |
None. |
|
| pon | string |
None. |
|
| customerid | integer |
None. |
|
| discount | decimal number |
None. |
|
| adjustment | decimal number |
None. |
|
| createby | string |
None. |
|
| createdate | date |
None. |
|
| updateby | string |
None. |
|
| updatedate | date |
None. |
|
| currency | string |
None. |
|
| tax | decimal number |
None. |
|
| projref | string |
None. |
|
| paiddate | date |
None. |
|
| cno | string |
None. |
|
| mfinvno | string |
None. |
|
| joblocation | string |
None. |
|
| isposted | boolean |
None. |
|
| postdate | date |
None. |
|
| postedby | string |
None. |
|
| donotpost | boolean |
None. |
|
| ticketid | integer |
None. |
|
| tags | string |
None. |
|
| roe | decimal number |
None. |
|
| salesrep | string |
None. |
|
| contractid | integer |
None. |
|
| deletedate | date |
None. |
|
| deleteby | string |
None. |
|
| tpcode | string |
None. |
|
| latefee | boolean |
None. |
|
| customer_contact | integer |
None. |
|
| payment_terms | string |
None. |
|
| discount_type | string |
None. |
|
| dis_amt | decimal number |
None. |
|
| line_total_amt | decimal number |
None. |
|
| origin | string |
None. |
|
| company_subscription_id | integer |
None. |
|
| contract_billing_id | integer |
None. |
|
| dept_id | integer |
None. |
|
| pricingtype | string |
None. |
|
| total_amt | decimal number |
None. |
|
| invtype | integer |
None. |
|
| print_template | string |
None. |
|
| shipdate | date |
None. |
|
| tpid | string |
None. |
|
| requestby | string |
None. |
|
| delivery_address | integer |
None. |
|
| delivery_region | integer |
None. |
|
| print_prorated_late_fee | boolean |
None. |
|
| fin_yr | string |
None. |
|
| t_company_subscriptions | t_company_subscriptions |
None. |
|
| t_contract_billing | t_contract_billing |
None. |
|
| t_contracts | t_contracts |
None. |
|
| t_customer_departments | t_customer_departments |
None. |
|
| t_customercontacts | t_customercontacts |
None. |
|
| t_customers | t_customers |
None. |
|
| t_ezbcosting | Collection of t_ezbcosting |
None. |
|
| t_inventry | Collection of t_inventry |
None. |
|
| t_projects | t_projects |
None. |
|
| t_tickets | t_tickets |
None. |
|
| t_invtransactions | Collection of t_invtransactions |
None. |
|
| t_late_payment_charges | Collection of t_late_payment_charges |
None. |
|
| t_pohdr | Collection of t_pohdr |
None. |