invantive documentation
Invantive Support ForumsAanmelden / Inschrijven

CounterPartyHistoryPostalAddresses: XAF 3.2

read only per partition XML

  • Catalogus: XAF

Kan alleen gegevens ophalen.

API-bron

  • XML-onderwerp: auditfile
  • XML-pad: /xaf:customerSupplierHistory/xaf:customerSupplier/xaf:postalAddress

Tabelkolommen

De kolommen van de tabel CounterPartyHistoryPostalAddresses 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
AUDIT_FILE_VERSION varchar2(240)
CITY varchar2(240)
COMPANY_ADDRESS varchar2(240)
COMPANY_CITY varchar2(240)
COMPANY_ID varchar2(240)
COMPANY_NAME varchar2(1000)
COMPANY_POSTAL_CODE varchar2(240)
COMPANY_TAX_REG_IDENT varchar2(240)
COUNTRY varchar2(240)
CUSTOMERSUPPLIER_CHANGEINFO_CHANGEDATETIME datetime
CUSTOMERSUPPLIER_CHANGEINFO_CHANGEDESCRIPTION varchar2(999)
CUSTOMERSUPPLIER_CHANGEINFO_USERID varchar2(240)
CUSTOMERSUPPLIER_COMMERCENR varchar2(999)
CUSTOMERSUPPLIER_CONTACT varchar2(240)
CUSTOMERSUPPLIER_CUSTCREDITLIMIT decimal
CUSTOMERSUPPLIER_CUSTOMERSUPPLIERHISTORY_CUSTOMERSUPPLIER_CHANGEINFO_CHANGEDATETIME datetime Datum/tijd wijzigingsinformatie relatie
CUSTOMERSUPPLIER_CUSTOMERSUPPLIERHISTORY_CUSTOMERSUPPLIER_CHANGEINFO_CHANGEDESCRIPTION varchar2(999) Beschrijving wijzigingsinformatie relatie
CUSTOMERSUPPLIER_CUSTOMERSUPPLIERHISTORY_CUSTOMERSUPPLIER_CHANGEINFO_USERID varchar2(240) Gebruikers-ID wijzigingsinformatie relatie
CUSTOMERSUPPLIER_CUSTOMERSUPPLIERHISTORY_CUSTOMERSUPPLIER_COMMERCENR varchar2(999) KvK-nummer relatie
CUSTOMERSUPPLIER_CUSTOMERSUPPLIERHISTORY_CUSTOMERSUPPLIER_CONTACT varchar2(240) Contactpersoon relatie
CUSTOMERSUPPLIER_CUSTOMERSUPPLIERHISTORY_CUSTOMERSUPPLIER_CUSTCREDITLIMIT decimal Kredietlimiet relatie als klant
CUSTOMERSUPPLIER_CUSTOMERSUPPLIERHISTORY_CUSTOMERSUPPLIER_CUSTSUPGRPID varchar2(240) Relatiegroep-ID
CUSTOMERSUPPLIER_CUSTOMERSUPPLIERHISTORY_CUSTOMERSUPPLIER_CUSTSUPID varchar2(240) Relatie-identificatie
CUSTOMERSUPPLIER_CUSTOMERSUPPLIERHISTORY_CUSTOMERSUPPLIER_CUSTSUPNAME varchar2(240) Naam Tegenpartij
CUSTOMERSUPPLIER_CUSTOMERSUPPLIERHISTORY_CUSTOMERSUPPLIER_CUSTSUPTP varchar2(240) Relatietype
CUSTOMERSUPPLIER_CUSTOMERSUPPLIERHISTORY_CUSTOMERSUPPLIER_EMAIL varchar2 E-mail tegenpartij
CUSTOMERSUPPLIER_CUSTOMERSUPPLIERHISTORY_CUSTOMERSUPPLIER_FAX varchar2(240) Fax tegenpartij
CUSTOMERSUPPLIER_CUSTOMERSUPPLIERHISTORY_CUSTOMERSUPPLIER_RELATIONSHIPID varchar2(240) Relatiekoppelings-ID
CUSTOMERSUPPLIER_CUSTOMERSUPPLIERHISTORY_CUSTOMERSUPPLIER_SUPPLIERLIMIT decimal Kredietlimiet relatie als leverancier
CUSTOMERSUPPLIER_CUSTOMERSUPPLIERHISTORY_CUSTOMERSUPPLIER_TAXREGIDENT varchar2(240) Btw-registratie-identificatie relatie
CUSTOMERSUPPLIER_CUSTOMERSUPPLIERHISTORY_CUSTOMERSUPPLIER_TAXREGISTRATIONCOUNTRY varchar2(240) Land van belastingregistratie tegenpartij
CUSTOMERSUPPLIER_CUSTOMERSUPPLIERHISTORY_CUSTOMERSUPPLIER_TELEPHONE varchar2(240) Telefoon tegenpartij
CUSTOMERSUPPLIER_CUSTOMERSUPPLIERHISTORY_CUSTOMERSUPPLIER_WEBSITE varchar2 Website relatie
CUSTOMERSUPPLIER_CUSTSUPGRPID varchar2(240)
CUSTOMERSUPPLIER_CUSTSUPID varchar2(240)
CUSTOMERSUPPLIER_CUSTSUPNAME varchar2(240)
CUSTOMERSUPPLIER_CUSTSUPTP varchar2(240)
CUSTOMERSUPPLIER_EMAIL varchar2
CUSTOMERSUPPLIER_FAX varchar2(240)
CUSTOMERSUPPLIER_RELATIONSHIPID varchar2(240)
CUSTOMERSUPPLIER_SUPPLIERLIMIT decimal
CUSTOMERSUPPLIER_TAXREGIDENT varchar2(240)
CUSTOMERSUPPLIER_TAXREGISTRATIONCOUNTRY varchar2(240)
CUSTOMERSUPPLIER_TELEPHONE varchar2(240)
CUSTOMERSUPPLIER_WEBSITE varchar2
FILE_CURRENCY_CODE varchar2(240)
FILE_DATE_CREATED varchar2(240)
FISCAL_YEAR_END_DATE datetime
FISCAL_YEAR_NUMBER varchar2(240)
FISCAL_YEAR_START_DATE datetime
INTERFACE_URL varchar2(4000)
NUMBER varchar2(240)
NUMBEREXTENSION varchar2(999)
POSTALCODE varchar2(240)
PRODUCT_ID varchar2(240)
PRODUCT_VERSION varchar2(240)
PROPERTY varchar2(240)
REGION varchar2(240)
STREETNAME varchar2(999)