| Name | Description | Type | Additional information |
|---|---|---|---|
| INVOICE_ID | integer |
None. |
|
| INVOICE_UID | globally unique identifier |
None. |
|
| COMPANY_ID | integer |
None. |
|
| CONTRACT_ID | integer |
None. |
|
| INVOICE_SERIAL_NUMBER | integer |
None. |
|
| INVOICE_NUMBER | string |
None. |
|
| INVOICE_DATE | string |
None. |
|
| SEQUENCE_NUMBER | integer |
None. |
|
| CLIENT_ID | integer |
None. |
|
| HAS_TAX | boolean |
None. |
|
| TAX1_VALUE | decimal number |
None. |
|
| TAX2_VALUE | decimal number |
None. |
|
| DISCOUNT_PERCENT | decimal number |
None. |
|
| DISCOUNT_VALUE | decimal number |
None. |
|
| GROSS_TOTAL | decimal number |
None. |
|
| DISCOUNTED_TOTAL | decimal number |
None. |
|
| NET_TOTAL | decimal number |
None. |
|
| COMPANY_TAX1_ID | integer |
None. |
|
| COMPANY_TAX1_PERCENTAGE | decimal number |
None. |
|
| COMPANY_TAX2_ID | integer |
None. |
|
| COMPANY_TAX2_PERCENTAGE | decimal number |
None. |
|
| INVOICE_DUE_DATE | string |
None. |
|
| STATUS_ID | integer |
None. |
|
| INVOICE_NOTES | string |
None. |
|
| IS_RETURN | boolean |
None. |
|
| DISPLAY_ORDER | integer |
None. |
|
| IS_ACTIVE | boolean |
None. |
|
| REMARKS | string |
None. |
|
| CREATE_DATE | date |
None. |
|
| CREATE_USER | integer |
None. |
|
| CLIENT_ADDRESS_ID | integer |
None. |
|
| HOLDBACK_AMOUNT | decimal number |
None. |
|
| PENALTY_AMOUNT | decimal number |
None. |
|
| PENALTY_PERC | decimal number |
None. |
|
| REMAINING_AMOUNT | decimal number |
None. |
|
| IS_PAID | boolean |
None. |
|
| CLIENT_COMPANY_NAME | string |
None. |
|
| COMPANY_TAX_NAME_1 | string |
None. |
|
| COMPANY_TAX_NAME_2 | string |
None. |
|
| CONTRACT_NAME | string |
None. |
|
| STATUS_NAME | string |
None. |
|
| ADDRESS_NAME | string |
None. |
|
| PROJECT_NAME | string |
None. |
|
| HasSettlements | boolean |
None. |