invantive documentation
Invantive SupportforenAnmelden / Eintragen

PaymentConditionsEx: Exact Online Payment Conditions

insert update per partition XML

  • Katalog: ExactOnlineXML
  • Schema: XML
  • Primärschlüssel: code_attr
  • Label: Payment Conditions

Die Daten in dieser Tabelle sind nach dem Wert der Spalte Division aufgeteilt.

Mit insert und update können Daten abgerufen und geändert werden.

Zusammenfassung

Additional where-clause columns supported:

  • division
  • downloadid
  • code

API-Quelle

  • XML-Dienst: PaymentConditions
  • XML-Thema: PaymentConditions
  • XML-Pfad: /

Parameter

Name Datentyp Required Default Documentation
division int32 Company code.
Params_Code varchar2 Code.
Params_DownloadID varchar2 Data subscription token.

Tabellenspalten

Die Spalten der Tabelle PaymentConditionsEx sind unten aufgeführt. Jede Spalte hat einen SQL-Datentyp. Beim Einfügen und Aktualisieren muss für jede erforderliche Spalte jederzeit ein neuer Wert angegeben werden der nicht Null ist.

Name Datentyp Label Required Marks Documentation
CODE_ATTR varchar2 Code /eExact/PaymentConditions/PaymentCondition/code
CREDITMANAGEMENTSCENARIO_CODE_ATTR varchar2 Kreditmanagement-Szenario Code /eExact/PaymentConditions/PaymentCondition/CreditManagementScenario/code
CREDITMANAGEMENTSCENARIO_DESCRIPTION varchar2(255) Kreditmanagement-Szenario Beschreibung /eExact/PaymentConditions/PaymentCondition/CreditManagementScenario/Description/
CREDITMANAGEMENTSCENARIO_DESCRIPTION_TERMID_ATTR number Credit Management Scenario Description Term ID /eExact/PaymentConditions/PaymentCondition/CreditManagementScenario/Description/termid
CREDITMANAGEMENTSCENARIO_ID_ATTR varchar2 Credit Management Scenario ID /eExact/PaymentConditions/PaymentCondition/CreditManagementScenario/ID
CREDITMANAGEMENTSCENARIO_ISACTIVE_ATTR boolean Credit Management Scenario Is Active /eExact/PaymentConditions/PaymentCondition/CreditManagementScenario/isactive
CREDITMANAGEMENTSCENARIO_STATUS_CODE_ATTR varchar2 itgen_eol_credit_management_scenario_status Code /eExact/PaymentConditions/PaymentCondition/CreditManagementScenario/Status/code
CREDITMANAGEMENTSCENARIO_STATUS_DESCRIPTION varchar2(255) itgen_eol_credit_management_scenario_status Description /eExact/PaymentConditions/PaymentCondition/CreditManagementScenario/Status/Description/
CREDITMANAGEMENTSCENARIO_STATUS_DESCRIPTION_TERMID_ATTR number itgen_eol_credit_management_scenario_status_description Term ID /eExact/PaymentConditions/PaymentCondition/CreditManagementScenario/Status/Description/termid
CREDITMANAGEMENTSCENARIO_STATUS_ID_ATTR varchar2 itgen_eol_credit_management_scenario_status-ID /eExact/PaymentConditions/PaymentCondition/CreditManagementScenario/Status/ID
CREDITMANAGEMENTSCENARIO_STATUS_ISACTIVE_ATTR boolean itgen_eol_credit_management_scenario_status Is Active /eExact/PaymentConditions/PaymentCondition/CreditManagementScenario/Status/isactive
DESCRIPTION varchar2(255) Description /eExact/PaymentConditions/PaymentCondition/Description/
DESCRIPTION_TERMID_ATTR number Beschreibung Begriffs-ID /eExact/PaymentConditions/PaymentCondition/Description/termid
DISCOUNTCALCULATION varchar2 Skontoberechnung /eExact/PaymentConditions/PaymentCondition/DiscountCalculation/
DISCOUNTPAYMENTDAYS number Skontotage /eExact/PaymentConditions/PaymentCondition/DiscountPaymentDays/
DISCOUNTPERCENTAGE number Rabatt Prozentsatz /eExact/PaymentConditions/PaymentCondition/DiscountPercentage/ The percentage as a number from -1 to 1, for example 0.19 = 19%
DIVISION_CODE varchar2 Verwaltung ID Interne einzigartige Nummer der Exact Online-Verwaltung.
DIVISION_HID int64 Administration Number of the Exact Online administration.Not guaranteed to be unique.
DIVISION_NAME varchar2(240) Verwaltung Name Name of the Exact Online administration.Not guaranteed to be unique.
INTERFACE_URL varchar2(4000) Schnittstelle URL URL, die zum Verbinden dieser Reihe mit Exact Online verwendet wird.
PAYMENTDAYS number Zahltage /eExact/PaymentConditions/PaymentCondition/PaymentDays/
PAYMENTDISCOUNTTYPE varchar2 Zahlung Rabatt Typ /eExact/PaymentConditions/PaymentCondition/PaymentDiscountType/
PAYMENTENDOFMONTHS number Zahlung Monatsende /eExact/PaymentConditions/PaymentCondition/PaymentEndOfMonths/
PAYMENTMETHOD varchar2 Zahlungsmethode /eExact/PaymentConditions/PaymentCondition/PaymentMethod/
ROWNUM int64 Zeilennummer Nummer der Reihe innerhalb der Ergebnisse, startend bei 1.
VATCALCULATION varchar2 USt. Kalkulation /eExact/PaymentConditions/PaymentCondition/VATCalculation/

Anmerkungen zu dieser Version

Was hat sich in den Tabellen, Spalten, Attributen und Funktionen des Treibers mit jeder neuen Version geändert: