CustomerPaymentMethods2: Visma.net Financials Customer Payment Methods |
Get Customer payment methods
Catalog: VismaNet
Schema: CustomerPaymentMethod
Label: Customer Payment Methods
This is a read-only table. The Visma.net Financials API may not support changing the data or the Invantive UniversalSQL driver for Visma.net Financials does not cover it. In the latter case, please use the table NativePlatformScalarRequests to upload data to the Visma.net Financials API.
Table Columns
The columns of the table CustomerPaymentMethods2 are shown below. Each column has an SQL data type.
Name |
Data Type |
Label |
Required |
Documentation |
|---|---|---|---|---|
active |
char |
Active |
☐ |
The top part > Active > A check box that indicates (if selected) that the selected customer payment method is active (that is, available for recording payments). |
cardOrAccountNo |
varchar2 |
|
☐ |
The top part > Card/account no. > The identifier for the customer's payment method. |
cashAccount_description |
varchar2 |
Cash Account Description |
☐ |
Click on the magnifier. > The description. |
cashAccount_id |
varchar2 |
|
☐ |
Click on the magnifier. > The identifier. |
COMPANY_CODE |
varchar2(30) |
Company Code |
☑ |
Partition code, segmenting the data. |
COMPANY_NAME |
varchar2(240) |
Company Name |
☑ |
Name of the partition. |
customer_id |
varchar2 |
|
☐ |
|
customer_name |
varchar2 |
Customer Name |
☐ |
Click the magnifier > The displayed name |
customerId |
varchar2 |
|
☐ |
|
paymentMethod_description |
varchar2 |
Payment Method Description |
☐ |
Click on the magnifier. > The description. |
paymentMethod_id |
varchar2 |
Payment Method ID |
☐ |
Click on the magnifier. > The identifier. |
timeStamp |
blob |
Timestamp |
☐ |
Identifier that represents a specific version of the resource.It helps to prevent simultaneous updates of the resource from overwriting each other (by using ETags and If-Match headers) |
Visma.net Financials API Data Model