invantive documentation
Invantive Support ForumsLog In / Sign Up

dutchVehicleGetPurchaseReference: Company.info itgen_cio_dutchvehiclegetpurchasereference

read only XML

  • Catalog: CompanyInfo
  • Schema: CompanyInfo
  • Label: itgen_cio_dutchvehiclegetpurchasereference

Can only retrieve data.

API Source

  • XML topic: dutchVehicleGetPurchaseReference

Parameters

Name Data Type Required Default Documentation
license_plate ``

Table Columns

The columns of the table dutchVehicleGetPurchaseReference 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
BASIC_DATA_BODY_STYLE varchar2 itgen_cio_basic_data Body Style
BASIC_DATA_BRAND varchar2 itgen_cio_basic_data Brand
BASIC_DATA_BRAND_CODE varchar2 itgen_cio_basic_data Brand Code
BASIC_DATA_CATALOG_PRICE number itgen_cio_basic_data Catalog Price
BASIC_DATA_CATEGORY varchar2 itgen_cio_basic_data Category
BASIC_DATA_COLOR varchar2 itgen_cio_basic_data itgen_cio_color
BASIC_DATA_LICENSE_PLATE varchar2 itgen_cio_basic_data License Plate
BASIC_DATA_LOCATION_VIN_NUMBER varchar2 itgen_cio_basic_data itgen_cio_location_vin_number
BASIC_DATA_MODEL varchar2 itgen_cio_basic_data Model
BASIC_DATA_SECONDARY_COLOR varchar2 itgen_cio_basic_data itgen_cio_secondary_color
BASIC_DATA_TYPE varchar2 itgen_cio_basic_data Type
PURCHASE_DATA_PRICE_DATA_CALCULATION_METHOD varchar2 itgen_cio_purchase_data_price_data itgen_cio_calculation_method
PURCHASE_DATA_PRICE_DATA_NET_PURCHASE_PRICE number itgen_cio_purchase_data_price_data itgen_cio_net_purchase_price
PURCHASE_DATA_PRICE_DATA_PURCHASE_PRICE number itgen_cio_purchase_data_price_data itgen_cio_purchase_price
PURCHASE_DATA_PRICE_DATA_VALUE_ADDED_TAX number itgen_cio_purchase_data_price_data itgen_cio_value_added_tax
PURCHASE_DATA_PRICE_DATA_VEHICLE_PURCHASE_TAX number itgen_cio_purchase_data_price_data itgen_cio_vehicle_purchase_tax
PURCHASE_DATA_REFERENCE_DATE date itgen_cio_purchase_data itgen_cio_reference_date
REFERENCE_DATE_FIRST_ADMISSION date itgen_cio_reference First Admission
REFERENCE_FUEL_TYPE varchar2 itgen_cio_reference Fuel Type
REFERENCE_MAXIMUM_MASS_PAYLOAD number itgen_cio_reference itgen_cio_maximum_mass_payload
REFERENCE_VERSION varchar2 itgen_cio_reference itgen_cio_version
REFERENCE_WEIGHT number itgen_cio_reference itgen_cio_weight
REFERENCE_YEAR_MANUFACTORED number itgen_cio_reference itgen_cio_year_manufactored

Release Notes

What changed per release in the tables, columns, attributes and capabilities of the driver: