invantive documentation
Invantive Support ForumsAanmelden / Inschrijven

BalanceLinesProcessed: Exact Online Processed Balance Lines

insert update per partition XML

  • Catalogus: ExactOnlineXML
  • Schema: XML
  • Label: Processed Balance Lines

De gegevens in deze tabel zijn gepartitioneerd per waarde van de kolom Division.

Je kunt gegevens ophalen en wijzigen met insert en update.

Samenvatting

Additional where-clause columns supported:

  • division
  • jaar
  • prevyears (2 )
  • period_from
  • period_to
  • afterentry (0 )

API-bron

  • XML-service: Balances
  • XML-onderwerp: Balances
  • XML-pad: /Years/Year

Tabelkolommen

De kolommen van de tabel BalanceLinesProcessed worden hieronder weergegeven. Elke kolom heeft een SQL-gegevenstype. Voor elke vereiste kolom moet bij het invoegen en bijwerken steeds een nieuwe, niet-lege waarde worden opgegeven.

Name Datatype Label Required Marks Documentation
BALANCE number Balance
CLOSE number Close /eExact/Balances/Balance/Years/Year/Close/
COSTANALYSIS varchar2 Kostenanalyse /eExact/Balances/Balance/Years/Year/CostAnalysis/
CREDIT number Credit /eExact/Balances/Balance/Years/Year/Credit/
DEBIT number Debit /eExact/Balances/Balance/Years/Year/Debit/
DIVISION_CODE varchar2 Administratie ID Intern uniek nummer van de Exact Online administratie.
DIVISION_HID int64 Administration Number of the Exact Online administration.Not guaranteed to be unique.
DIVISION_NAME varchar2(240) Administratie Naam Name of the Exact Online administration.Not guaranteed to be unique.
INTERFACE_URL varchar2(4000) Interface URL URL gebruikt om deze rij uit te wisselen met Exact Online.
OPEN number Open /eExact/Balances/Balance/Years/Year/Open/
PREVYEARS int32 Vorige Jaren Inbegrepen
REPORTINGYEAR_ATTR number Rapportage Jaar /eExact/Balances/Balance/Years/Year/ReportingYear
ROWNUM int64 Rijnummer Nummer van de regel binnen de resultaten, te beginnen bij 1.
YEARS_BALANCE_ADDRESS varchar2 Balance Address /eExact/Balances/Balance/Address/
YEARS_BALANCE_BALANCETYPE_ATTR varchar2 Balance Balance Type /eExact/Balances/Balance/balanceType
YEARS_BALANCE_CHAMBEROFCOMMERCE varchar2 Balance Chamber of Commerce /eExact/Balances/Balance/ChamberOfCommerce/
YEARS_BALANCE_CITY varchar2 Balance City /eExact/Balances/Balance/City/
YEARS_BALANCE_CODE_ATTR varchar2 Balance Code /eExact/Balances/Balance/code
YEARS_BALANCE_COMPANYNAME varchar2 Balance Company Name /eExact/Balances/Balance/CompanyName/
YEARS_BALANCE_COUNTRY_CODE_ATTR varchar2 Landcode /eExact/Balances/Balance/Country/code
YEARS_BALANCE_COUNTRY_DESCRIPTION varchar2(255) Land Omschrijving /eExact/Balances/Balance/Country/Description/
YEARS_BALANCE_COUNTRY_DESCRIPTION_TERMID_ATTR number Balance Country Term ID /eExact/Balances/Balance/Country/Description/termid
YEARS_BALANCE_DESCRIPTION varchar2(255) Balansomschrijving /eExact/Balances/Balance/Description/
YEARS_BALANCE_DESCRIPTION_TERMID_ATTR number itgen_eol_balances_balance_description Term ID /eExact/Balances/Balance/Description/termid
YEARS_BALANCE_LEADCODE varchar2 Balance Lead Code /eExact/Balances/Balance/LeadCode/
YEARS_BALANCE_POSTALCODE varchar2 Balance Postal Code /eExact/Balances/Balance/PostalCode/

Release Notes

Wat is er per release veranderd in de tabellen, kolommen, attributen en mogelijkheden van de driver: