Please enable JavaScript to view this site.

Error itgendoc001X

xMsg javascript has not been loaded.

Twinfield API Data Model

Navigation: Schema: Twinfield > Tables

Cheques: Twinfield Cheques

 Contents Previous Home Next More

Catalog: Twinfield

Schema: Twinfield

Label: Cheques

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: CQT

Table Columns

The columns of the table Cheques are shown below. Each column has an SQL data type.

Name

Data Type

Label

Required

Documentation

AMOUNT

string

Amount

☐

 

CHEQUE_NUMBER

string

Cheque Number

☐

 

COMPANY_CODE

string

Company ID

☑

 

COMPANY_NAME

string

Company Name

☑

 

DEBIT_OR_CREDIT

string

Debit/Credit

☐

 

RELATION_CODE

string

Relation Code

☐

 

RELATION_NAME

string

Relation Name

☐

 

 

25-10-2021 14:28 Version 20.2.72-PROD+3482