PaymentConditionsEx: Exact Online Payment Conditions
insert update per partition XML
- Catalog:
ExactOnlineXML - Schema:
XML - Primary Keys:
code_attr - Label: Payment Conditions
The data in this table is partitioned per value of the Division column.
Can retrieve data and change data using insert and update.
Summary
Additional where-clause columns supported:
- division
- downloadid
- code
API Source
- XML service:
PaymentConditions - XML topic:
PaymentConditions - XML path:
/
Parameters
| Name | Data Type | Required | Default | Documentation |
|---|---|---|---|---|
division |
int32 |
Company code. | ||
Params_ |
varchar2 |
Code. | ||
Params_ |
varchar2 |
Data subscription token. |
Table Columns
The columns of the table PaymentConditionsEx are shown below. Each column has an SQL data type. A new non-null value must be provided for every required column at all times during insert and update.
| Name | Data Type | Label | Required | Marks | Documentation |
|---|---|---|---|---|---|
CODE_ |
varchar2 |
Code | / |
||
CREDITMANAGEMENTSCENARIO_ |
varchar2 |
Credit Management Scenario Code | / |
||
CREDITMANAGEMENTSCENARIO_ |
varchar2 |
Credit Management Scenario Description | / |
||
CREDITMANAGEMENTSCENARIO_ |
number |
Credit Management Scenario Description Term ID | / |
||
CREDITMANAGEMENTSCENARIO_ |
varchar2 |
Credit Management Scenario ID | / |
||
CREDITMANAGEMENTSCENARIO_ |
boolean |
Credit Management Scenario Is Active | / |
||
CREDITMANAGEMENTSCENARIO_ |
varchar2 |
itgen_eol_credit_management_scenario_status Code | / |
||
CREDITMANAGEMENTSCENARIO_ |
varchar2 |
itgen_eol_credit_management_scenario_status Description | / |
||
CREDITMANAGEMENTSCENARIO_ |
number |
itgen_eol_credit_management_scenario_status_description Term ID | / |
||
CREDITMANAGEMENTSCENARIO_ |
varchar2 |
itgen_eol_credit_management_scenario_status ID | / |
||
CREDITMANAGEMENTSCENARIO_ |
boolean |
itgen_eol_credit_management_scenario_status Is Active | / |
||
DESCRIPTION |
varchar2 |
Description | / |
||
DESCRIPTION_ |
number |
Description Term ID | / |
||
DISCOUNTCALCULATION |
varchar2 |
Discount Calculation | / |
||
DISCOUNTPAYMENTDAYS |
number |
Discount Payment Days | / |
||
DISCOUNTPERCENTAGE |
number |
Discount Percentage | / |
The percentage as a number from -1 to 1, for example 0.19 = 19% | |
DIVISION_ |
varchar2 |
Administration ID | Internal unique number of the Exact Online administration. | ||
DIVISION_ |
int64 |
Administration | Number of the Exact Online administration. Not guaranteed to be unique. | ||
DIVISION_ |
varchar2 |
Administration Name | Name of the Exact Online administration. Not guaranteed to be unique. | ||
INTERFACE_ |
varchar2 |
Interface URL | URL used to interface this row with Exact Online. | ||
PAYMENTDAYS |
number |
Payment Days | / |
||
PAYMENTDISCOUNTTYPE |
varchar2 |
Payment Discount Type | / |
||
PAYMENTENDOFMONTHS |
number |
Payment End of Months | / |
||
PAYMENTMETHOD |
varchar2 |
Payment Method | / |
||
ROWNUM |
int64 |
Row Number | Number of the row within the results, starting at 1. | ||
VATCALCULATION |
varchar2 |
VAT Calculation | / |
Release Notes
What changed per release in the tables, columns, attributes and capabilities of the driver: