| Name | Description | Type | Additional information |
|---|---|---|---|
| id | integer |
None. |
|
| pino | string |
None. |
|
| supplierid | integer |
None. |
|
| invdate | date |
None. |
|
| status | string |
None. |
|
| payment_terms | string |
None. |
|
| carrier | integer |
None. |
|
| duedate | date |
None. |
|
| taxscheme | string |
None. |
|
| currency | string |
None. |
|
| notes | string |
None. |
|
| createby | string |
None. |
|
| createdate | date |
None. |
|
| updateby | string |
None. |
|
| updatedate | date |
None. |
|
| companyid | integer |
None. |
|
| pitype | integer |
None. |
|
| pititle | string |
None. |
|
| priority | string |
None. |
|
| seq | integer |
None. |
|
| customerid | integer |
None. |
|
| terms | string |
None. |
|
| approvedby | string |
None. |
|
| department | string |
None. |
|
| islocal | boolean |
None. |
|
| roe | decimal number |
None. |
|
| shippingfees | decimal number |
None. |
|
| adjustment | decimal number |
None. |
|
| orderref | string |
None. |
|
| paiddate | date |
None. |
|
| invoiceno | string |
None. |
|
| projid | integer |
None. |
|
| ticketid | integer |
None. |
|
| otherfees | decimal number |
None. |
|
| orderconfirmation | string |
None. |
|
| emaillist | string |
None. |
|
| notified | boolean |
None. |
|
| discount | decimal number |
None. |
|
| tax | decimal number |
None. |
|
| invoice_attached | boolean |
None. |
|
| isposted | boolean |
None. |
|
| postdate | date |
None. |
|
| postedby | string |
None. |
|
| donotpost | boolean |
None. |
|
| voyageno | string |
None. |
|
| date_approved | date |
None. |
|
| tags | string |
None. |
|
| poid | integer |
None. |
|
| deletedate | date |
None. |
|
| deleteby | string |
None. |
|
| tpcode | string |
None. |
|
| line_total_amt | decimal number |
None. |
|
| contactid | integer |
None. |
|
| tds_applicable | boolean |
None. |
|
| tdstype | integer |
None. |
|
| taxable_amt | decimal number |
None. |
|
| tds_amt | decimal number |
None. |
|
| tds_rate | decimal number |
None. |
|
| total_amt | decimal number |
None. |
|
| tpid | string |
None. |
|
| print_template | string |
None. |
|
| t_customers | t_customers |
None. |
|
| t_pientry | Collection of t_pientry |
None. |
|
| t_pitype | t_pitype |
None. |
|
| t_suppliercontacts | t_suppliercontacts |
None. |
|
| t_projects | t_projects |
None. |
|
| t_suppliers | t_suppliers |
None. |
|
| t_tickets | t_tickets |
None. |
|
| t_tdstype | t_tdstype |
None. |
|
| t_pitransactions | Collection of t_pitransactions |
None. |