Error itgendoc001X
xMsg javascript has not been loaded.
Twinfield API Data ModelCatalog: Twinfield
Schema: Twinfield
Label: Invoices
The data in this table is partitioned per value of the COMPANY_CODE column.
This is a read-only table. The Twinfield API may not support changing the data or the Invantive SQL driver for Twinfield does not cover it. In the latter case, please use the table NativePlatformScalarRequests to upload data to the Twinfield API.
Twinfield API URL: webservices/finder.asmx
Topic: IVT
Table Columns
The columns of the table Invoices are shown below. Each column has an SQL data type.
Name |
Data Type |
Label |
Required |
Documentation |
|---|---|---|---|---|
AMOUNT |
string |
Amount |
☐ |
|
COMPANY_CODE |
string |
Company ID |
☑ |
|
COMPANY_NAME |
string |
Company Name |
☑ |
|
DEBIT_OR_CREDIT |
string |
Debit/Credit |
☐ |
|
INVOICE_NUMBER |
string |
Invoice Number |
☐ |
|
RELATION_CODE |
string |
Relation Code |
☐ |
|
RELATION_NAME |
string |
Relation Name |
☐ |
|
25-10-2021 14:28 Version 20.2.72-PROD+3482
