CustomerPaymentMethodDetails: Visma.net Financials Customer Payment Method Details |
Get Customer payment methods
Catalog: VismaNet
Schema: CustomerPaymentMethod
Label: Customer Payment Method Details
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 CustomerPaymentMethodDetails 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 |
|
☐ |
|
description |
varchar2 |
Description |
☐ |
Payment method details tab > Description > A description of the selected payment method. |
detailId |
varchar2 |
Detail ID |
☐ |
|
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) |
value |
varchar2 |
Value |
☐ |
Payment method details tab > Value > The value you enter. This must match the input validation mask set for the column. |
Visma.net Financials API Data Model