invantive documentation
Invantive Support ForumsLog In / Sign Up

SalesOrders_ItemsUserDefinedFields: Autotask itgen_autotask_salesorders_itemsuserdefinedfields_plural

read only REST

  • Catalog: Autotask
  • Schema: SalesOrders
  • Label: itgen_autotask_salesorders_itemsuserdefinedfields_plural

Can only retrieve data.

API Source

  • Endpoint: /V1.0/SalesOrders/query
  • Operation: get /V1.0/SalesOrders/query

Table Columns

The columns of the table SalesOrders_ItemsUserDefinedFields 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
additionalBillToAddressInformation varchar2 Additional Bill-to Address Information
additionalShipToAddressInformation varchar2 Additional Ship-to Address Information
billingAddress1 varchar2 Billing Address 1
billingAddress2 varchar2 Billing Address 2
billToCity varchar2 Bill-to City
billToCountryID int32 Bill-to Country ID
billToPostalCode varchar2 Bill-to Postal Code
billToState varchar2 Bill-to State
companyID int32 Company ID
contactID int32 Contact ID
id int64 ID
impersonatorCreatorResourceID int32 Imperonsator Creator Resource ID
name varchar2 Name
opportunityID int32 Opportunity ID
organizationalLevelAssociationID int32 Organisational Level Association ID
ownerResourceID int32 Owner Resource ID
promisedFulfillmentDate datetime Promised Fulfillment Date
salesOrderDate datetime Sales Order Date
shipToAddress1 varchar2 Ship-to Address 1
shipToAddress2 varchar2 Ship-to Address 2
shipToCity varchar2 Ship-to City
shipToCountryID int32 Ship-to Country ID
shipToPostalCode varchar2 Ship-to Postal Code
shipToState varchar2 Ship-to State
soapParentPropertyId_body_canReduce char itgen_autotask_soapparentpropertyid_body_canreduce
soapParentPropertyId_body_nodeType varchar2 itgen_autotask_soapparentpropertyid_body_nodetype
soapParentPropertyId_body_type varchar2 itgen_autotask_soapparentpropertyid_body_type
soapParentPropertyId_canReduce char itgen_autotask_soapparentpropertyid_canreduce
soapParentPropertyId_name varchar2 itgen_autotask_soapparentpropertyid_name
soapParentPropertyId_nodeType varchar2 itgen_autotask_soapparentpropertyid_nodetype
soapParentPropertyId_returnType varchar2 itgen_autotask_soapparentpropertyid_returntype
soapParentPropertyId_tailCall char itgen_autotask_soapparentpropertyid_tailcall
soapParentPropertyId_type varchar2 itgen_autotask_soapparentpropertyid_type
status int32 Status
title varchar2 Title
value varchar2 Value

Release Notes

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