WOMD_ACCOUNT_EXEC_SALES_OFFICES

Returns a list of Account Exec Sales Offices

Input Parameters

Example Request:

  {
    "RequestType":"[VENDORNAME].WOMD_ACCOUNT_EXEC_SALES_OFFICES",
    "DataExportFormat":"JSON",
    "TargetUrl":"https://yoursite.com/ProcessData",
    "ChunkRowsCount":"50",
    "GenerateInValidFormat":"true",
    "Parameters":
    [
      {
        "Name":"@PriorVersion",
        "DbType":"int",
        "Value":"100"
      },
      {
        "Name":"@Version",
        "DbType":"int",
        "Value":"100"
      }
    ]
  }

Example Error:

  {
    "Message": "There is no DDL's with request type - [VENDOR_NAME].WOMD_ACCOUNT_EXEC_SALES_OFFICES for Agreement [VENDOR_NAME]/PM_v110"
  }

Field Name	Data Type
@PriorVersion	int
@Version	int

Output Fields

Field Name	Data Type
ACCOUNT_EXEC_SALES_OFFICE_ID	uniqueidentifier
ACCOUNT_EXEC_ID	uniqueidentifier
SALES_OFFICE_ID	uniqueidentifier
IS_SOFT_DELETED	int
CREATE_DATE	smalldatetime
CREATE_BY	varchar(250)
UPDATE_DATE	datetime
UPDATE_BY	varchar(250)
UPDATE_COUNT	int
Version (Note: This is sent as a separate dataset.)	bigint

WOMD_ACCOUNT_EXECS

Returns a list of Account Execs

Input Parameters

Example Request:

  {
    "RequestType":"[VENDORNAME].WOMD_ACCOUNT_EXECS",
    "DataExportFormat":"JSON",
    "TargetUrl":"https://yoursite.com/ProcessData",
    "ChunkRowsCount":"50",
    "GenerateInValidFormat":"true",
    "Parameters":
    [
      {
        "Name":"@PriorVersion",
        "DbType":"int",
        "Value":"100"
      },
      {
        "Name":"@Version",
        "DbType":"int",
        "Value":"100"
      }
    ]
  }

Example Error:

  {
    "Message": "There is no DDL's with request type - [VENDOR_NAME].WOMD_ACCOUNT_EXECS for Agreement [VENDOR_NAME]/PM_v110"
  }

Field Name	Data Type
@PriorVersion	int
@Version	int

Output Fields

Field Name	Data Type
ACCOUNT_EXEC_ID	uniqueidentifier
BASE_COMMISSION	float
CONTACT_ID	uniqueidentifier
NEW_BUSINESS_COMMISSION	float
PRINT_ABBREVIATION	varchar(5)
IS_SOFT_DELETED	int
CREATE_DATE	smalldatetime
CREATE_BY	varchar(250)
UPDATE_DATE	datetime
UPDATE_BY	varchar(250)
UPDATE_COUNT	int
COMMISSION_CODE_INT	smallint
Version (Note: This is sent as a separate dataset.)	bigint

WOMD_ADDRESSES

Returns a list of Addresses

Input Parameters

Example Request:

  {
    "RequestType":"[VENDORNAME].WOMD_ADDRESSES",
    "DataExportFormat":"JSON",
    "TargetUrl":"https://yoursite.com/ProcessData",
    "ChunkRowsCount":"50",
    "GenerateInValidFormat":"true",
    "Parameters":
    [
      {
        "Name":"@PriorVersion",
        "DbType":"int",
        "Value":"100"
      },
      {
        "Name":"@Version",
        "DbType":"int",
        "Value":"100"
      }
    ]
  }

Example Error:

  {
    "Message": "There is no DDL's with request type - [VENDOR_NAME].WOMD_ADDRESSES for Agreement [VENDOR_NAME]/PM_v110"
  }

Field Name	Data Type
@PriorVersion	int
@Version	int

Output Fields

Field Name	Data Type
ADDRESS_ID	uniqueidentifier
ADDRESS_INT	int
ADDRESS_CITY	varchar(100)
ADDRESS_COUNTRY	varchar(100)
ADDRESS_LINE1	varchar(100)
ADDRESS_LINE2	varchar(100)
ADDRESS_LINE3	varchar(100)
ADDRESS_NAME	varchar(100)
ADDRESS_STATE	varchar(25)
ADDRESS_ZIPCODE	varchar(50)
IS_SOFT_DELETED	int
CREATE_DATE	smalldatetime
CREATE_BY	varchar(250)
UPDATE_DATE	datetime
UPDATE_BY	varchar(250)
UPDATE_COUNT	int
Version (Note: This is sent as a separate dataset.)	bigint

WOMD_ADVERTISER_AGENCIES

Returns a list of Advertiser Agencies Relationships

Input Parameters

Example Request:

  {
    "RequestType":"[VENDORNAME].WOMD_ADVERTISER_AGENCIES",
    "DataExportFormat":"JSON",
    "TargetUrl":"https://yoursite.com/ProcessData",
    "ChunkRowsCount":"50",
    "GenerateInValidFormat":"true",
    "Parameters":
    [
      {
        "Name":"@PriorVersion",
        "DbType":"int",
        "Value":"100"
      },
      {
        "Name":"@Version",
        "DbType":"int",
        "Value":"100"
      }
    ]
  }

Example Error:

  {
    "Message": "There is no DDL's with request type - [VENDOR_NAME].WOMD_ADVERTISER_AGENCIES for Agreement [VENDOR_NAME]/PM_v110"
  }

Field Name	Data Type
@PriorVersion	int
@Version	int

Output Fields

Field Name	Data Type
ADVERTISER_AGENCY_ID	uniqueidentifier
ADVERTISER_ID	uniqueidentifier
AGENCY_ID	uniqueidentifier
AGING_THRESHOLD	int
AGING_WARNING	tinyint
AGING_WARNING_ARRAY	binary(256)
AGING_WARNING_DATE	datetime
BILLING_ADDRESS_INT	int
BILLING_ADDRESS_ID	uniqueidentifier
CONTRACT_ADDRESS_INT	int
CONTRACT_ADDRESS_ID	uniqueidentifier
EINVOICE_CODE	varchar(50)
EI_EXPORT_TYPE	tinyint
REMIT_ADDRESS_INT	int
REMIT_ADDRESS_ID	uniqueidentifier
REPORTING_ACCOUNT_EXEC_ID	uniqueidentifier
STATION_IDS	text
WEB_BILLING_ADDRESS_INT	int
WEB_BILLING_ADDRESS_ID	uniqueidentifier
IS_DIRECT	int
IS_SOFT_DELETED	int
CREATE_DATE	smalldatetime
CREATE_BY	varchar(250)
UPDATE_DATE	datetime
UPDATE_BY	varchar(250)
UPDATE_COUNT	int
Version (Note: This is sent as a separate dataset.)	bigint

WOMD_ADVERTISER_BRAND_PRODUCT_CODES

Returns a list of Advertiser Brand Product Codes

Input Parameters

Example Request:

  {
    "RequestType":"[VENDORNAME].WOMD_ADVERTISER_BRAND_PRODUCT_CODES",
    "DataExportFormat":"JSON",
    "TargetUrl":"https://yoursite.com/ProcessData",
    "ChunkRowsCount":"50",
    "GenerateInValidFormat":"true",
    "Parameters":
    [
      {
        "Name":"@PriorVersion",
        "DbType":"int",
        "Value":"100"
      },
      {
        "Name":"@Version",
        "DbType":"int",
        "Value":"100"
      }
    ]
  }

Example Error:

  {
    "Message": "There is no DDL's with request type - [VENDOR_NAME].WOMD_ADVERTISER_BRAND_PRODUCT_CODES for Agreement [VENDOR_NAME]/PM_v110"
  }

Field Name	Data Type
@PriorVersion	int
@Version	int

Output Fields

Field Name	Data Type
ADVERTISER_BRAND_PRODUCT_CODE_ID	uniqueidentifier
ADVERTISER_ID	uniqueidentifier
ADVERTISER_BRAND_ID	uniqueidentifier
IS_USED_IN_REVENUE	bit
IS_USED_IN_SEPARATION	bit
PRODUCT_CODE_ID	uniqueidentifier
IS_SOFT_DELETED	int
CREATE_DATE	smalldatetime
CREATE_BY	varchar(250)
UPDATE_DATE	smalldatetime
UPDATE_BY	varchar(250)
UPDATE_COUNT	smallint
Version (Note: This is sent as a separate dataset.)	bigint

WOMD_ADVERTISER_BRANDS

Returns a list of Advertiser Brands

Input Parameters

Example Request:

  {
    "RequestType":"[VENDORNAME].WOMD_ADVERTISER_BRANDS",
    "DataExportFormat":"JSON",
    "TargetUrl":"https://yoursite.com/ProcessData",
    "ChunkRowsCount":"50",
    "GenerateInValidFormat":"true",
    "Parameters":
    [
      {
        "Name":"@PriorVersion",
        "DbType":"int",
        "Value":"100"
      },
      {
        "Name":"@Version",
        "DbType":"int",
        "Value":"100"
      }
    ]
  }

Example Error:

  {
    "Message": "There is no DDL's with request type - [VENDOR_NAME].WOMD_ADVERTISER_BRANDS for Agreement [VENDOR_NAME]/PM_v110"
  }

Field Name	Data Type
@PriorVersion	int
@Version	int

Output Fields

Field Name	Data Type
ADVERTISER_BRAND_ID	uniqueidentifier
ADVERTISER_BRAND_INT	smallint
ADVERTISER_ID	uniqueidentifier
BRAND_DESCR	varchar(250)
BRAND_NAME	varchar(50)
BRAND_SEPARATION	int
IS_SOFT_DELETED	int
CREATE_DATE	smalldatetime
CREATE_BY	varchar(250)
UPDATE_DATE	datetime
UPDATE_BY	varchar(250)
UPDATE_COUNT	int
Version (Note: This is sent as a separate dataset.)	bigint

WOMD_ADVERTISER_CONTACTS

Returns a list of Advertiser Contacts

Input Parameters

Example Request:

  {
    "RequestType":"[VENDORNAME].WOMD_ADVERTISER_CONTACTS",
    "DataExportFormat":"JSON",
    "TargetUrl":"https://yoursite.com/ProcessData",
    "ChunkRowsCount":"50",
    "GenerateInValidFormat":"true",
    "Parameters":
    [
      {
        "Name":"@PriorVersion",
        "DbType":"int",
        "Value":"100"
      },
      {
        "Name":"@Version",
        "DbType":"int",
        "Value":"100"
      }
    ]
  }

Example Error:

  {
    "Message": "There is no DDL's with request type - [VENDOR_NAME].WOMD_ADVERTISER_CONTACTS for Agreement [VENDOR_NAME]/PM_v110"
  }

Field Name	Data Type
@PriorVersion	int
@Version	int

Output Fields

Field Name	Data Type
ADVERTISER_CONTACT_ID	uniqueidentifier
ADVERTISER_ID	uniqueidentifier
CONTACT_ID	uniqueidentifier
CONTACT_TYPE	varchar(250)
STATION_IDS	text
IS_SOFT_DELETED	int
CREATE_DATE	smalldatetime
CREATE_BY	varchar(250)
UPDATE_DATE	datetime
UPDATE_BY	varchar(250)
UPDATE_COUNT	int
Version (Note: This is sent as a separate dataset.)	bigint

WOMD_ADVERTISER_PRODUCT_CODES

Returns a list of Advertiser Product Codes

Input Parameters

Example Request:

  {
    "RequestType":"[VENDORNAME].WOMD_ADVERTISER_PRODUCT_CODES",
    "DataExportFormat":"JSON",
    "TargetUrl":"https://yoursite.com/ProcessData",
    "ChunkRowsCount":"50",
    "GenerateInValidFormat":"true",
    "Parameters":
    [
      {
        "Name":"@PriorVersion",
        "DbType":"int",
        "Value":"100"
      },
      {
        "Name":"@Version",
        "DbType":"int",
        "Value":"100"
      }
    ]
  }

Example Error:

  {
    "Message": "There is no DDL's with request type - [VENDOR_NAME].WOMD_ADVERTISER_PRODUCT_CODES for Agreement [VENDOR_NAME]/PM_v110"
  }

Field Name	Data Type
@PriorVersion	int
@Version	int

Output Fields

Field Name	Data Type
ADVERTISER_PRODUCT_CODE_ID	uniqueidentifier
ADVERTISER_ID	uniqueidentifier
IS_USED_IN_REVENUE	int
IS_USED_IN_SEPARATION	int
PRODUCT_CODE_ID	uniqueidentifier
IS_SOFT_DELETED	int
CREATE_DATE	smalldatetime
CREATE_BY	varchar(250)
UPDATE_DATE	datetime
UPDATE_BY	varchar(250)
UPDATE_COUNT	int
Version (Note: This is sent as a separate dataset.)	bigint

WOMD_ADVERTISER_TYPES

Returns a list of Advertiser Types

Input Parameters

Example Request:

  {
    "RequestType":"[VENDORNAME].WOMD_ADVERTISER_TYPES",
    "DataExportFormat":"JSON",
    "TargetUrl":"https://yoursite.com/ProcessData",
    "ChunkRowsCount":"50",
    "GenerateInValidFormat":"true",
    "Parameters":
    [
      {
        "Name":"@PriorVersion",
        "DbType":"int",
        "Value":"100"
      },
      {
        "Name":"@Version",
        "DbType":"int",
        "Value":"100"
      }
    ]
  }

Example Error:

  {
    "Message": "There is no DDL's with request type - [VENDOR_NAME].WOMD_ADVERTISER_TYPES for Agreement [VENDOR_NAME]/PM_v110"
  }

Field Name	Data Type
@PriorVersion	int
@Version	int

Output Fields

Field Name	Data Type
ADVERTISER_TYPE_INT	smallint
ADVERTISER_TYPE_GUID	uniqueidentifier
ADVERTISER_TYPE_TYPE	varchar(50)
ADVERTISER_TYPE_VALUE	varchar(250)
ADVERTISER_TYPE_DISPLAY	varchar(250)
ADVERTISER_TYPE_DESCR	varchar(250)
ADVERTISER_TYPE_SORT	varchar(50)
ROW_STATE	int
CREATE_DATE	smalldatetime
CREATE_BY	varchar(250)
UPDATE_DATE	datetime
UPDATE_BY	varchar(250)
UPDATE_COUNT	int
ADVERTISER_TYPE_EXTERNAL	varchar(50)
Version (Note: This is sent as a separate dataset.)	bigint

WOMD_ADVERTISERS

Returns a list of Advertisers

Input Parameters

Example Request:

  {
    "RequestType":"[VENDORNAME].WOMD_ADVERTISERS",
    "DataExportFormat":"JSON",
    "TargetUrl":"https://yoursite.com/ProcessData",
    "ChunkRowsCount":"50",
    "GenerateInValidFormat":"true",
    "Parameters":
    [
      {
        "Name":"@PriorVersion",
        "DbType":"int",
        "Value":"100"
      },
      {
        "Name":"@Version",
        "DbType":"int",
        "Value":"100"
      }
    ]
  }

Example Error:

  {
    "Message": "There is no DDL's with request type - [VENDOR_NAME].WOMD_ADVERTISERS for Agreement [VENDOR_NAME]/PM_v110"
  }

Field Name	Data Type
@PriorVersion	int
@Version	int

Output Fields

Field Name	Data Type
ADVERTISER_ID	uniqueidentifier
ADVERTISER_EDI_CODE	varchar(50)
ADVERTISER_EXTERNAL_ID	varchar(50)
ADVERTISER_NAME	varchar(50)
ADVERTISER_REPORTING_NAME	varchar(100)
ADVERTISER_TYPE_ID	uniqueidentifier
CARE_OF	varchar(50)
DEFAULT_ELIGIBLE_FOR_FILL	tinyint
DEFAULT_ONAIR_SEPARATION	int
DEFAULT_POSTING_PERCENT	smallint
EXTERNAL_ADVERTISER_CODE	varchar(50)
GLOBAL_ADVERTISER_ID	uniqueidentifier
IS_PENDING	tinyint
IS_REQUIRES_POSTING	tinyint
IS_TAXED	int
IS_TAXED2	tinyint
MAIN_ADDRESS_ID	uniqueidentifier
NEW_BUSINESS_EXPIRE	smalldatetime
PRODUCT_CODE_DISPLAY	varchar(50)
STATION_IDS	text
TCODE	varchar(50)
REVENUE_CODE1_ID	uniqueidentifier
REVENUE_CODE2_ID	uniqueidentifier
REVENUE_CODE3_ID	uniqueidentifier
IS_DIRECT	int
BILLING_ADDRESS_ID	uniqueidentifier
IS_SOFT_DELETED	int
CREATE_DATE	smalldatetime
CREATE_BY	varchar(250)
UPDATE_DATE	datetime
UPDATE_BY	varchar(250)
UPDATE_COUNT	int
ADVERTISER_INT	int
ADVERTISER_TYPE_INT	smallint
DEFAULT_DIGITAL_ORDER_TYPE_INT	smallint
DEFAULT_DIGITAL_REVENUE_CODE2_INT	smallint
DEFAULT_DIGITAL_REVENUE_CODE3_INT	smallint
DEFAULT_DIGITAL_REVENUE_CODE_INT	smallint
DEFAULT_ORDER_TYPE_INT	smallint
DEFAULT_POSTING_METHOD_INT	smallint
DEFAULT_PRIORITY_CODE_INT	smallint
DEFAULT_RATING_STREAM_INT	smallint
DEFAULT_REVENUE_CODE2_INT	smallint
DEFAULT_REVENUE_CODE3_INT	smallint
DEFAULT_REVENUE_CODE_INT	smallint
DEFAULT_STEWARDSHIP_METHOD_INT	smallint
MAIN_ADDRESS_INT	int
STATION_ARRAY_INT	int
Version (Note: This is sent as a separate dataset.)	bigint

WOMD_AGENCY_TYPES

Returns a list of Agency Types

Input Parameters

Example Request:

  {
    "RequestType":"[VENDORNAME].WOMD_AGENCY_TYPES",
    "DataExportFormat":"JSON",
    "TargetUrl":"https://yoursite.com/ProcessData",
    "ChunkRowsCount":"50",
    "GenerateInValidFormat":"true",
    "Parameters":
    [
      {
        "Name":"@PriorVersion",
        "DbType":"int",
        "Value":"100"
      },
      {
        "Name":"@Version",
        "DbType":"int",
        "Value":"100"
      }
    ]
  }

Example Error:

  {
    "Message": "There is no DDL's with request type - [VENDOR_NAME].WOMD_AGENCY_TYPES for Agreement [VENDOR_NAME]/PM_v110"
  }

Field Name	Data Type
@PriorVersion	int
@Version	int

Output Fields

Field Name	Data Type
AGENCY_TYPE_INT	smallint
AGENCY_TYPE_GUID	uniqueidentifier
AGENCY_TYPE_TYPE	varchar(50)
AGENCY_TYPE_VALUE	varchar(250)
AGENCY_TYPE_DISPLAY	varchar(250)
AGENCY_TYPE_DESCR	varchar(250)
AGENCY_TYPE_SORT	varchar(50)
ROW_STATE	int
CREATE_DATE	smalldatetime
CREATE_BY	varchar(250)
UPDATE_DATE	datetime
UPDATE_BY	varchar(250)
UPDATE_COUNT	int
AGENCY_TYPE_EXTERNAL	varchar(50)
Version (Note: This is sent as a separate dataset.)	bigint

WOMD_AGENCIES

Returns a list of Agencies

Input Parameters

Example Request:

  {
    "RequestType":"[VENDORNAME].WOMD_AGENCIES",
    "DataExportFormat":"JSON",
    "TargetUrl":"https://yoursite.com/ProcessData",
    "ChunkRowsCount":"50",
    "GenerateInValidFormat":"true",
    "Parameters":
    [
      {
        "Name":"@PriorVersion",
        "DbType":"int",
        "Value":"100"
      },
      {
        "Name":"@Version",
        "DbType":"int",
        "Value":"100"
      }
    ]
  }

Example Error:

  {
    "Message": "There is no DDL's with request type - [VENDOR_NAME].WOMD_AGENCIES for Agreement [VENDOR_NAME]/PM_v110"
  }

Field Name	Data Type
@PriorVersion	int
@Version	int

Output Fields

Field Name	Data Type
AGENCY_ID	uniqueidentifier
AGENCY_EXTERNAL_ID	varchar(50)
AGENCY_NAME	varchar(50)
AGENCY_REPORTING_NAME	varchar(100)
AGENCY_TYPE_INT	smallint
AGENCY_TYPE_ID	uniqueidentifier
DEFAULT_CASH_COMMISSION	float
DEFAULT_TRADE_COMMISSION	float
DUNS_NUMBER	varchar(9)
EINVOICE_CODE	varchar(50)
EI_EXPORT_TYPE	tinyint
EXTERNAL_AGENCY_CODE	varchar(50)
FAX_NUMBER	varchar(50)
GLOBAL_AGENCY_ID	uniqueidentifier
IS_PENDING	tinyint
MAIN_ADDRESS_INT	int
MAIN_ADDRESS_ID	uniqueidentifier
MAIN_PHONE_NUMBER	varchar(50)
MICR_CODE	varchar(50)
STATION_IDS	text
TCODE	varchar(50)
WEBSITE	varchar(50)
IS_DIRECT	int
IS_SOFT_DELETED	int
CREATE_DATE	smalldatetime
CREATE_BY	varchar(250)
UPDATE_DATE	datetime
UPDATE_BY	varchar(250)
UPDATE_COUNT	int
AGENCY_INT	int
DEFAULT_BILLING_CALENDAR_INT	smallint
DEFAULT_BILLING_CYCLE_INT	smallint
LOCKBOX_PARENT_INT	int
STATION_ARRAY_INT	int
Version (Note: This is sent as a separate dataset.)	bigint

WOMD_AGENCY_BILLING_ADDRESSES

Returns a list of Agency Billing Addresses

Input Parameters

Example Request:

  {
    "RequestType":"[VENDORNAME].WOMD_AGENCY_BILLING_ADDRESSES",
    "DataExportFormat":"JSON",
    "TargetUrl":"https://yoursite.com/ProcessData",
    "ChunkRowsCount":"50",
    "GenerateInValidFormat":"true",
    "Parameters":
    [
      {
        "Name":"@PriorVersion",
        "DbType":"int",
        "Value":"100"
      },
      {
        "Name":"@Version",
        "DbType":"int",
        "Value":"100"
      }
    ]
  }

Example Error:

  {
    "Message": "There is no DDL's with request type - [VENDOR_NAME].WOMD_AGENCY_BILLING_ADDRESSES for Agreement [VENDOR_NAME]/PM_v110"
  }

Field Name	Data Type
@PriorVersion	int
@Version	int

Output Fields

Field Name	Data Type
AGENCY_BILLING_ADDRESS_ID	uniqueidentifier
AGENCY_ID	uniqueidentifier
BILLING_ADDRESS_ID	uniqueidentifier
IS_SOFT_DELETED	int
CREATE_DATE	smalldatetime
CREATE_BY	varchar(250)
UPDATE_DATE	datetime
UPDATE_BY	varchar(250)
UPDATE_COUNT	int
Version (Note: This is sent as a separate dataset.)	bigint

WOMD_AGENCY_CONTACTS

Returns a list of Agency Contacts

Input Parameters

Example Request:

  {
    "RequestType":"[VENDORNAME].WOMD_AGENCY_CONTACTS",
    "DataExportFormat":"JSON",
    "TargetUrl":"https://yoursite.com/ProcessData",
    "ChunkRowsCount":"50",
    "GenerateInValidFormat":"true",
    "Parameters":
    [
      {
        "Name":"@PriorVersion",
        "DbType":"int",
        "Value":"100"
      },
      {
        "Name":"@Version",
        "DbType":"int",
        "Value":"100"
      }
    ]
  }

Example Error:

  {
    "Message": "There is no DDL's with request type - [VENDOR_NAME].WOMD_AGENCY_CONTACTS for Agreement [VENDOR_NAME]/PM_v110"
  }

Field Name	Data Type
@PriorVersion	int
@Version	int

Output Fields

Field Name	Data Type
AGENCY_CONTACT_ID	uniqueidentifier
AGENCY_ID	uniqueidentifier
CONTACT_ID	uniqueidentifier
CONTACT_TYPE	varchar(250)
STATION_IDS	text
IS_SOFT_DELETED	int
CREATE_DATE	smalldatetime
CREATE_BY	varchar(250)
UPDATE_DATE	datetime
UPDATE_BY	varchar(250)
UPDATE_COUNT	int
Version (Note: This is sent as a separate dataset.)	bigint

WOMD_AGENCY_CONTRACT_ADDRESSES

Returns a list of Agency Contract Addresses

Input Parameters

Example Request:

  {
    "RequestType":"[VENDORNAME].WOMD_AGENCY_CONTRACT_ADDRESSES",
    "DataExportFormat":"JSON",
    "TargetUrl":"https://yoursite.com/ProcessData",
    "ChunkRowsCount":"50",
    "GenerateInValidFormat":"true",
    "Parameters":
    [
      {
        "Name":"@PriorVersion",
        "DbType":"int",
        "Value":"100"
      },
      {
        "Name":"@Version",
        "DbType":"int",
        "Value":"100"
      }
    ]
  }

Example Error:

  {
    "Message": "There is no DDL's with request type - [VENDOR_NAME].WOMD_AGENCY_CONTRACT_ADDRESSES for Agreement [VENDOR_NAME]/PM_v110"
  }

Field Name	Data Type
@PriorVersion	int
@Version	int

Output Fields

Field Name	Data Type
AGENCY_CONTRACT_ADDRESS_ID	uniqueidentifier
AGENCY_ID	uniqueidentifier
CONTRACT_ADDRESS_ID	uniqueidentifier
IS_SOFT_DELETED	int
CREATE_DATE	smalldatetime
CREATE_BY	varchar(250)
UPDATE_DATE	smalldatetime
UPDATE_BY	varchar(250)
UPDATE_COUNT	int
Version (Note: This is sent as a separate dataset.)	bigint

WOMD_BILLING_GROUPS

Returns a list of Billing Groups

Input Parameters

Example Request:

  {
    "RequestType":"[VENDORNAME].WOMD_BILLING_GROUPS",
    "DataExportFormat":"JSON",
    "TargetUrl":"https://yoursite.com/ProcessData",
    "ChunkRowsCount":"50",
    "GenerateInValidFormat":"true",
    "Parameters":
    [
      {
        "Name":"@PriorVersion",
        "DbType":"int",
        "Value":"100"
      },
      {
        "Name":"@Version",
        "DbType":"int",
        "Value":"100"
      }
    ]
  }

Example Error:

  {
    "Message": "There is no DDL's with request type - [VENDOR_NAME].WOMD_BILLING_GROUPS for Agreement [VENDOR_NAME]/PM_v110"
  }

Field Name	Data Type
@PriorVersion	int
@Version	int

Output Fields

Field Name	Data Type
BILLING_GROUP_ID	uniqueidentifier
BILLING_GROUP_INT	smallint
BILLING_GROUP_NAME	varchar(50)
BILLING_GROUP_DESCR	varchar(250)
STATION_ID	uniqueidentifier
ALT_CALL_LETTERS	varchar(25)
ALT_STATION_NAME	varchar(50)
ALT_WEB_SITE	varchar(50)
EI_NAME	varchar(25)
EI_MEDIA_TYPE	varchar(25)
EI_BAND	varchar(25)
EC_NAME	varchar(25)
IS_SOFT_DELETED	int
CREATE_DATE	smalldatetime
CREATE_BY	varchar(250)
UPDATE_DATE	datetime
UPDATE_BY	varchar(250)
UPDATE_COUNT	int
ENABLED_FOR_WOX	tinyint
BILLING_GROUP_REPORTING_NAME	varchar(100)
Version (Note: This is sent as a separate dataset.)	bigint

WOMD_CHANNEL_INVENTORY_CODES

Returns a list of Channel Inventory Codes

Input Parameters

Example Request:

  {
    "RequestType":"[VENDORNAME].WOMD_CHANNEL_INVENTORY_CODES",
    "DataExportFormat":"JSON",
    "TargetUrl":"https://yoursite.com/ProcessData",
    "ChunkRowsCount":"50",
    "GenerateInValidFormat":"true",
    "Parameters":
    [
      {
        "Name":"@PriorVersion",
        "DbType":"int",
        "Value":"100"
      },
      {
        "Name":"@Version",
        "DbType":"int",
        "Value":"100"
      }
    ]
  }

Example Error:

  {
    "Message": "There is no DDL's with request type - [VENDOR_NAME].WOMD_CHANNEL_INVENTORY_CODES for Agreement [VENDOR_NAME]/PM_v110"
  }

Field Name	Data Type
@PriorVersion	int
@Version	int

Output Fields

Field Name	Data Type
CHANNEL_INVENTORY_CODE_ID	uniqueidentifier
CHANNEL_INT	smallint
DISPLAY_TIMES	varchar(50)
ELIGIBLE_WEEKDAYS	tinyint
INVENTORY_DESCR	varchar(250)
IS_RESTRICTED	bit
INVENTORY_CODE_INT	int
KEYWORDS_KEYVALUES	text
CHANNEL_SORT	varchar(50)
IS_SOFT_DELETED	int
CREATE_DATE	smalldatetime
CREATE_BY	varchar(250)
UPDATE_DATE	datetime
UPDATE_BY	varchar(250)
UPDATE_COUNT	int
Version (Note: This is sent as a separate dataset.)	bigint

WOMD_CHANNEL_TILES

Returns a list of Channel Tiles

Input Parameters

Example Request:

  {
    "RequestType":"[VENDORNAME].WOMD_CHANNEL_TILES",
    "DataExportFormat":"JSON",
    "TargetUrl":"https://yoursite.com/ProcessData",
    "ChunkRowsCount":"50",
    "GenerateInValidFormat":"true",
    "Parameters":
    [
      {
        "Name":"@PriorVersion",
        "DbType":"int",
        "Value":"100"
      },
      {
        "Name":"@Version",
        "DbType":"int",
        "Value":"100"
      }
    ]
  }

Example Error:

  {
    "Message": "There is no DDL's with request type - [VENDOR_NAME].WOMD_CHANNEL_TILES for Agreement [VENDOR_NAME]/PM_v110"
  }

Field Name	Data Type
@PriorVersion	int
@Version	int

Output Fields

Field Name	Data Type
CHANNEL_TILE_ID	uniqueidentifier
CHANNEL_INT	smallint
TILE_INT	smallint
KEYWORDS_KEYVALUES	text
HEIGHT	smallint
WIDTH	smallint
IS_ACTIVE	bit
ROW_STATE	tinyint
CREATE_DATE	smalldatetime
CREATE_BY	varchar(250)
UPDATE_DATE	datetime
UPDATE_BY	varchar(250)
UPDATE_COUNT	int
Version (Note: This is sent as a separate dataset.)	bigint

WOMD_CHANNELS

Returns a list of Channels

Input Parameters

Example Request:

  {
    "RequestType":"[VENDORNAME].WOMD_CHANNELS",
    "DataExportFormat":"JSON",
    "TargetUrl":"https://yoursite.com/ProcessData",
    "ChunkRowsCount":"50",
    "GenerateInValidFormat":"true",
    "Parameters":
    [
      {
        "Name":"@PriorVersion",
        "DbType":"int",
        "Value":"100"
      },
      {
        "Name":"@Version",
        "DbType":"int",
        "Value":"100"
      }
    ]
  }

Example Error:

  {
    "Message": "There is no DDL's with request type - [VENDOR_NAME].WOMD_CHANNELS for Agreement [VENDOR_NAME]/PM_v110"
  }

Field Name	Data Type
@PriorVersion	int
@Version	int

Output Fields

Field Name	Data Type
CHANNEL_ID	uniqueidentifier
STATION_ID	uniqueidentifier
INVENTORY_TREE_ID	uniqueidentifier
MATERIAL_LOCATION_ID	uniqueidentifier
CHANNEL_NAME	varchar(5)
CHANNEL_REVENUE_WEIGHT	int
AUTOMATION_IDENTIFIER	varchar(10)
ACTIVE_LOG_LENGTH	int
ACTIVE_LOG_START_DATE	smalldatetime
ACTIVE_LOG_END_DATE	smalldatetime
MAX_FORMAT_OVERLAP	int
MON_SIGN_ON	int
MON_SIGN_OFF	int
TUE_SIGN_ON	int
TUE_SIGN_OFF	int
WED_SIGN_ON	int
WED_SIGN_OFF	int
THU_SIGN_OFF	int
THU_SIGN_ON	int
FRI_SIGN_ON	int
FRI_SIGN_OFF	int
SAT_SIGN_ON	int
SAT_SIGN_OFF	int
SUN_SIGN_ON	int
SUN_SIGN_OFF	int
PLACER_PRIORITY_RATE	int
PLACER_PRIORITY_PRIORITY_CODE	int
PLACER_PRIORITY_INVENTORY_CODE	int
PLACER_PRIORITY_ORDER_ENTRY_DATE	int
PLACER_PRIORITY_ORDER_START_DATE	int
PLACER_PRIORITY_ORDER_END_DATE	int
PLACER_PRIORITY_ORDER_LINE_START_DATE	int
PLACER_PRIORITY_ORDER_LINE_END_DATE	int
PLACER_PRIORITY_THRESHOLD	int
IS_SOFT_DELETED	int
CREATE_DATE	smalldatetime
CREATE_BY	varchar(250)
UPDATE_DATE	datetime
UPDATE_BY	varchar(250)
UPDATE_COUNT	int
MASTER_CHANNEL_INT	smallint
MATERIAL_PLACER_OVERRIDE_MATERIAL	int
MATERIAL_PLACER_RE_STAMP_INSTRUCTION	int
MATERIAL_PLACER_AUTO_UPDATE_MATERIAL	int
MIN_RATE_CARD_ID	uniqueidentifier
CHANNEL_INT	smallint
INVENTORY_UNIT_SIZES	varchar(100)
SALES_STATION_ID	uniqueidentifier
REPORTING_NAME	varchar(100)
WINDOW_TYPE	smallint
WINDOW_PRE_OFFSET	int
WINDOW_POST_OFFSET	int
PRINT_TIME_OFFSET	int
EC_NAME	varchar(100)
ENABLED_FOR_WOX	tinyint
PLAYLIST_TYPE_ID	uniqueidentifier
CHANNEL_TYPE_INT	smallint
IS_INTERNET_CHANNEL	bit
INVOICE_NAME	varchar(100)
KEYWORDS_KEYVALUES	text
ROLLDOWN_DISPLACED_PARENTS	bit
IS_STREAMING_CHANNEL	bit
LIVE_TIME_OFFSET	int
NETWORK_TIME_OFFSET	int
MATERIAL_PRIORITY	smallint
BILLING_GROUP_INT	smallint
Version (Note: This is sent as a separate dataset.)	bigint

WOMD_CONTACTS

Returns a list of Contacts

Input Parameters

Example Request:

  {
    "RequestType":"[VENDORNAME].WOMD_CONTACTS",
    "DataExportFormat":"JSON",
    "TargetUrl":"https://yoursite.com/ProcessData",
    "ChunkRowsCount":"50",
    "GenerateInValidFormat":"true",
    "Parameters":
    [
      {
        "Name":"@PriorVersion",
        "DbType":"int",
        "Value":"100"
      },
      {
        "Name":"@Version",
        "DbType":"int",
        "Value":"100"
      }
    ]
  }

Example Error:

  {
    "Message": "There is no DDL's with request type - [VENDOR_NAME].WOMD_CONTACTS for Agreement [VENDOR_NAME]/PM_v110"
  }

Field Name	Data Type
@PriorVersion	int
@Version	int

Output Fields

Field Name	Data Type
CONTACT_ID	uniqueidentifier
ANNIVERSARY	smalldatetime
ASSISTANT	varchar(50)
BIRTHDAY	smalldatetime
BUSINESS_ADDRESS	uniqueidentifier
DEPARTMENT	varchar(50)
EMAIL_ADDRESS	varchar(250)
FAX_NUMBER	varchar(50)
FIRST_NAME	varchar(50)
HOME_ADDRESS	uniqueidentifier
HOME_NUMBER	varchar(50)
IS_INTERNAL	tinyint
LAST_NAME	varchar(50)
MANAGER	varchar(50)
MOBILE_NUMBER	varchar(50)
NICKNAME	varchar(50)
OFFICE	varchar(50)
OTHER_ADDRESS	uniqueidentifier
PHONE_NUMBER	varchar(50)
PROFESSION	varchar(50)
SPOUSE	varchar(50)
TITLE	varchar(50)
IS_SOFT_DELETED	int
CREATE_DATE	smalldatetime
CREATE_BY	varchar(250)
UPDATE_DATE	datetime
UPDATE_BY	varchar(250)
UPDATE_COUNT	int
EXTERNAL_DEPARTMENT	varchar(50)
EXTERNAL_TITLE	varchar(50)
Version (Note: This is sent as a separate dataset.)	bigint

WOMD_INTERNET_PRODUCTS

Returns a list of Internet Products

Input Parameters

Example Request:

  {
    "RequestType":"[VENDORNAME].WOMD_INTERNET_PRODUCTS",
    "DataExportFormat":"JSON",
    "TargetUrl":"https://yoursite.com/ProcessData",
    "ChunkRowsCount":"50",
    "GenerateInValidFormat":"true",
    "Parameters":
    [
      {
        "Name":"@PriorVersion",
        "DbType":"int",
        "Value":"100"
      },
      {
        "Name":"@Version",
        "DbType":"int",
        "Value":"100"
      }
    ]
  }

Example Error:

  {
    "Message": "There is no DDL's with request type - [VENDOR_NAME].WOMD_INTERNET_PRODUCTS for Agreement [VENDOR_NAME]/PM_v110"
  }

Field Name	Data Type
@PriorVersion	int
@Version	int

Output Fields

Field Name	Data Type
INTERNET_PRODUCT_ID	uniqueidentifier
INTERNET_PRODUCT_INT	int
CHANNEL_INTS	text
INVENTORY_CODE_INT	int
AD_SLOT_INT	smallint
AD_TYPE_INT	smallint
START_DATE	smalldatetime
END_DATE	smalldatetime
NAME	varchar(50)
SORT	varchar(50)
EXTERNAL_DESCRIPTION	varchar(250)
KEYWORDS	text
ROW_STATE	tinyint
CREATE_DATE	smalldatetime
CREATE_BY	varchar(250)
UPDATE_DATE	datetime
UPDATE_BY	varchar(250)
UPDATE_COUNT	int
PRODUCT_TYPE_INT	smallint
TARGETING	text
DEFAULT_RATETYPE	tinyint
DEFAULT_RATE	money
ALLOW_IMP_GOAL	bit
ADSERVER_DELIVERY	bit
DIGITAL_TYPE	tinyint
GOAL_TYPE	tinyint
PRIORITY	tinyint
FLOOR_RATE	money
REVENUE_CODE_INT	smallint
REVENUE_CODE2_INT	smallint
REVENUE_CODE3_INT	smallint
UNIT_CODE_INT	smallint
IS_SPONSORSHIP	bit
Version (Note: This is sent as a separate dataset.)	bigint

WOMD_INVENTORY_CODE_RELATIONSHIPS

Returns a list of Inventory Code Relationships

Input Parameters

Example Request:

  {
    "RequestType":"[VENDORNAME].WOMD_INVENTORY_CODE_RELATIONSHIPS",
    "DataExportFormat":"JSON",
    "TargetUrl":"https://yoursite.com/ProcessData",
    "ChunkRowsCount":"50",
    "GenerateInValidFormat":"true",
    "Parameters":
    [
      {
        "Name":"@PriorVersion",
        "DbType":"int",
        "Value":"100"
      },
      {
        "Name":"@Version",
        "DbType":"int",
        "Value":"100"
      }
    ]
  }

Example Error:

  {
    "Message": "There is no DDL's with request type - [VENDOR_NAME].WOMD_INVENTORY_CODE_RELATIONSHIPS for Agreement [VENDOR_NAME]/PM_v110"
  }

Field Name	Data Type
@PriorVersion	int
@Version	int

Output Fields

Field Name	Data Type
INVENTORY_CODE_RELATIONSHIP_ID	uniqueidentifier
IS_SOFT_DELETED	int
IS_HARD_DELETED	int
CREATE_DATE	smalldatetime
CREATE_BY	varchar(250)
UPDATE_DATE	datetime
UPDATE_BY	varchar(250)
UPDATE_COUNT	int
ANCESTOR_INVENTORY_CODE_INT	int
DESCENDANT_INVENTORY_CODE_INT	int
Version (Note: This is sent as a separate dataset.)	bigint

WOMD_INVENTORY_CODE_SELLGROUPS

Returns a list of Inventory Code Sellgroups

Input Parameters

Example Request:

  {
    "RequestType":"[VENDORNAME].WOMD_INVENTORY_CODE_SELLGROUPS",
    "DataExportFormat":"JSON",
    "TargetUrl":"https://yoursite.com/ProcessData",
    "ChunkRowsCount":"50",
    "GenerateInValidFormat":"true",
    "Parameters":
    [
      {
        "Name":"@PriorVersion",
        "DbType":"int",
        "Value":"100"
      },
      {
        "Name":"@Version",
        "DbType":"int",
        "Value":"100"
      }
    ]
  }

Example Error:

  {
    "Message": "There is no DDL's with request type - [VENDOR_NAME].WOMD_INVENTORY_CODE_SELLGROUPS for Agreement [VENDOR_NAME]/PM_v110"
  }

Field Name	Data Type
@PriorVersion	int
@Version	int

Output Fields

Field Name	Data Type
INVENTORY_CODE_SELLGROUP_ID	uniqueidentifier
INVENTORY_CODE_INT	int
LINKED_INVENTORY_CODE_INT	int
IS_SOFT_DELETED	int
CREATE_DATE	smalldatetime
CREATE_BY	varchar(250)
UPDATE_DATE	datetime
UPDATE_BY	varchar(250)
UPDATE_COUNT	int
Version (Note: This is sent as a separate dataset.)	bigint

WOMD_INVENTORY_CODES

Returns a list of Inventory Codes

Input Parameters

Example Request:

  {
    "RequestType":"[VENDORNAME].WOMD_INVENTORY_CODES",
    "DataExportFormat":"JSON",
    "TargetUrl":"https://yoursite.com/ProcessData",
    "ChunkRowsCount":"50",
    "GenerateInValidFormat":"true",
    "Parameters":
    [
      {
        "Name":"@PriorVersion",
        "DbType":"int",
        "Value":"100"
      },
      {
        "Name":"@Version",
        "DbType":"int",
        "Value":"100"
      }
    ]
  }

Example Error:

  {
    "Message": "There is no DDL's with request type - [VENDOR_NAME].WOMD_INVENTORY_CODES for Agreement [VENDOR_NAME]/PM_v110"
  }

Field Name	Data Type
@PriorVersion	int
@Version	int

Output Fields

Field Name	Data Type
INVENTORY_CODE_ID	uniqueidentifier
INVENTORY_TREE_ID	uniqueidentifier
INVENTORY_CODE_NAME	varchar(50)
INVENTORY_SORT	varchar(50)
DAYPART_INT	smallint
IS_SELLGROUP	int
IS_USED_IN_FORMATS	int
IS_USED_IN_ORDERS	int
INVENTORY_CODE_PRIORITY	int
VALID_START_DATE	smalldatetime
VALID_END_DATE	smalldatetime
LAST_USED_DATE	smalldatetime
EXPIRE_DATE	smalldatetime
EXPIRATION_DAYS	int
IS_SOFT_DELETED	int
CREATE_DATE	smalldatetime
CREATE_BY	varchar(250)
UPDATE_DATE	datetime
UPDATE_BY	varchar(250)
UPDATE_COUNT	int
IS_USED_IN_PROPOSALS	tinyint
INVENTORY_CODE_EXTERNAL_ID	varchar(50)
ENABLED_FOR_WOX	tinyint
INVENTORY_CODE_INT	int
PARENT_INVENTORY_CODE_INT	int
REPORTING_NAME	varchar(100)
DISPLAY_PARENT_INVENTORY_CODE_INT	int
Version (Note: This is sent as a separate dataset.)	bigint

WOMD_INVENTORY_TREES

Returns a list of Inventory Trees

Input Parameters

Example Request:

  {
    "RequestType":"[VENDORNAME].WOMD_INVENTORY_TREES",
    "DataExportFormat":"JSON",
    "TargetUrl":"https://yoursite.com/ProcessData",
    "ChunkRowsCount":"50",
    "GenerateInValidFormat":"true",
    "Parameters":
    [
      {
        "Name":"@PriorVersion",
        "DbType":"int",
        "Value":"100"
      },
      {
        "Name":"@Version",
        "DbType":"int",
        "Value":"100"
      }
    ]
  }

Example Error:

  {
    "Message": "There is no DDL's with request type - [VENDOR_NAME].WOMD_INVENTORY_TREES for Agreement [VENDOR_NAME]/PM_v110"
  }

Field Name	Data Type
@PriorVersion	int
@Version	int

Output Fields

Field Name	Data Type
INVENTORY_TREE_ID	uniqueidentifier
PARENT_INVENTORY_TREE_ID	uniqueidentifier
INVENTORY_TREE_NAME	varchar(50)
INVENTORY_TREE_DESCR	varchar(250)
IS_SOFT_DELETED	int
CREATE_DATE	smalldatetime
CREATE_BY	varchar(250)
UPDATE_DATE	datetime
UPDATE_BY	varchar(250)
UPDATE_COUNT	int
Version (Note: This is sent as a separate dataset.)	bigint

WOMD_INVENTORY_TYPES

Returns a list of Inventory Types

Input Parameters

Example Request:

  {
    "RequestType":"[VENDORNAME].WOMD_INVENTORY_TYPES",
    "DataExportFormat":"JSON",
    "TargetUrl":"https://yoursite.com/ProcessData",
    "ChunkRowsCount":"50",
    "GenerateInValidFormat":"true",
    "Parameters":
    [
      {
        "Name":"@PriorVersion",
        "DbType":"int",
        "Value":"100"
      },
      {
        "Name":"@Version",
        "DbType":"int",
        "Value":"100"
      }
    ]
  }

Example Error:

  {
    "Message": "There is no DDL's with request type - [VENDOR_NAME].WOMD_INVENTORY_TYPES for Agreement [VENDOR_NAME]/PM_v110"
  }

Field Name	Data Type
@PriorVersion	int
@Version	int

Output Fields

Field Name	Data Type
INVENTORY_TYPE_ID	uniqueidentifier
INVENTORY_TYPE_CODE	varchar(50)
INVENTORY_TYPE_DESCR	varchar(50)
INVENTORY_TYPE_SORT	varchar(50)
IS_SOFT_DELETED	int
CREATE_DATE	smalldatetime
CREATE_BY	varchar(250)
UPDATE_DATE	datetime
UPDATE_BY	varchar(250)
UPDATE_COUNT	int
INVENTORY_TYPE_INT	smallint
Version (Note: This is sent as a separate dataset.)	bigint

WOMD_INVOICES

Returns a list of Invoices

Input Parameters

Example Request:

  {
    "RequestType":"[VENDORNAME].WOMD_INVOICES",
    "DataExportFormat":"JSON",
    "TargetUrl":"https://yoursite.com/ProcessData",
    "ChunkRowsCount":"50",
    "GenerateInValidFormat":"true",
    "Parameters":
    [
      {
        "Name":"@PriorVersion",
        "DbType":"int",
        "Value":"100"
      },
      {
        "Name":"@Version",
        "DbType":"int",
        "Value":"100"
      }
    ]
  }

Example Error:

  {
    "Message": "There is no DDL's with request type - [VENDOR_NAME].WOMD_INVOICES for Agreement [VENDOR_NAME]/PM_v110"
  }

Field Name	Data Type
@PriorVersion	int
@Version	int

Output Fields

Field Name	Data Type
INVOICE_ID	uniqueidentifier
INVOICE_BATCH_ID	uniqueidentifier
ORDER_BILL_PLAN_ID	uniqueidentifier
INVOICE_NUMBER	varchar(50)
TOTAL_INVOICE_AMOUNT	money
OUTSTANDING_AMOUNT	money
INVOICE_DATE	smalldatetime
DUE_DATE	datetime
IN_COLLECTIONS	int
IS_SOFT_DELETED	int
IS_HARD_DELETED	int
CREATE_DATE	smalldatetime
CREATE_BY	varchar(250)
UPDATE_DATE	datetime
UPDATE_BY	varchar(250)
UPDATE_COUNT	int
GROSS_AMOUNT	money
NET_AMOUNT	money
MASTER_INVOICE_ID	uniqueidentifier
TAX1_AMOUNT	money
TAX2_AMOUNT	money
EXPORT_DATE	datetime
INVOICE_STATUS	tinyint
CREDIT_INVOICE_NUMBER	varchar(50)
CREDIT_INVOICE_DATE	smalldatetime
CREDIT_EXPORT_DATE	datetime
INVOICE_INT	int
Version (Note: This is sent as a separate dataset.)	bigint

WOMD_LOOKUPS

Returns a list of Lookup values

Input Parameters

Example Request:

  {
    "RequestType":"[VENDORNAME].WOMD_LOOKUPS",
    "DataExportFormat":"JSON",
    "TargetUrl":"https://yoursite.com/ProcessData",
    "ChunkRowsCount":"50",
    "GenerateInValidFormat":"true",
    "Parameters":
    [
      {
        "Name":"@LookupType",
        "DbType":"varchar",
        "Value":"SALES_REGION"
      },
      {
        "Name":"@PriorVersion",
        "DbType":"int",
        "Value":"100"
      },
      {
        "Name":"@Version",
        "DbType":"int",
        "Value":"100"
      },
      {
        "Name":"@FormatColumns",
        "DbType":"bit",
        "Value":"0"
      }
    ]
  }

Example Error:

  {
    "Message": "There is no DDL's with request type - [VENDOR_NAME].WOMD_LOOKUPS for Agreement [VENDOR_NAME]/PM_v110"
  }

Field Name	Data Type
@LookupType	varchar(50)
@PriorVersion	int
@Version	int
@FormatColumns	bit

Output Fields

Field Name	Data Type
LOOKUP_INT	smallint
LOOKUP_GUID	uniqueidentifier
LOOKUP_TYPE	varchar(50)
LOOKUP_VALUE	varchar(250)
LOOKUP_DISPLAY	varchar(250)
LOOKUP_DESCR	varchar(250)
LOOKUP_SORT	varchar(50)
ROW_STATE	int
CREATE_DATE	smalldatetime
CREATE_BY	varchar(250)
UPDATE_DATE	datetime
UPDATE_BY	varchar(250)
UPDATE_COUNT	int
LOOKUP_EXTERNAL	varchar(50)
Version (Note: This is sent as a separate dataset.)	bigint

WOMD_ORDER_PRODUCT_CODES

Returns a list of Order Product Codes

Input Parameters

Example Request:

  {
    "RequestType":"[VENDORNAME].WOMD_ORDER_PRODUCT_CODES",
    "DataExportFormat":"JSON",
    "TargetUrl":"https://yoursite.com/ProcessData",
    "ChunkRowsCount":"50",
    "GenerateInValidFormat":"true",
    "Parameters":
    [
      {
        "Name":"@PriorVersion",
        "DbType":"int",
        "Value":"100"
      },
      {
        "Name":"@Version",
        "DbType":"int",
        "Value":"100"
      }
    ]
  }

Example Error:

  {
    "Message": "There is no DDL's with request type - [VENDOR_NAME].WOMD_ORDER_PRODUCT_CODES for Agreement [VENDOR_NAME]/PM_v110"
  }

Field Name	Data Type
@PriorVersion	int
@Version	int

Output Fields

Field Name	Data Type
ORDER_PRODUCT_CODE_ID	uniqueidentifier
PRODUCT_CODE_ID	uniqueidentifier
IS_USED_IN_SEPARATION	int
IS_USED_IN_REVENUE	int
ORDER_INT	int
IS_SOFT_DELETED	int
IS_HARD_DELETED	int
CREATE_DATE	smalldatetime
CREATE_BY	varchar(250)
UPDATE_DATE	datetime
UPDATE_BY	varchar(250)
UPDATE_COUNT	int
Version (Note: This is sent as a separate dataset.)	bigint

WOMD_ORDER_TYPES

Returns a list of Order Types

Input Parameters

Example Request:

  {
    "RequestType":"[VENDORNAME].WOMD_ORDER_TYPES",
    "DataExportFormat":"JSON",
    "TargetUrl":"https://yoursite.com/ProcessData",
    "ChunkRowsCount":"50",
    "GenerateInValidFormat":"true",
    "Parameters":
    [
      {
        "Name":"@PriorVersion",
        "DbType":"int",
        "Value":"100"
      },
      {
        "Name":"@Version",
        "DbType":"int",
        "Value":"100"
      }
    ]
  }

Example Error:

  {
    "Message": "There is no DDL's with request type - [VENDOR_NAME].WOMD_ORDER_TYPES for Agreement [VENDOR_NAME]/PM_v110"
  }

Field Name	Data Type
@PriorVersion	int
@Version	int

Output Fields

Field Name	Data Type
ORDER_TYPE_INT	smallint
ORDER_TYPE_GUID	uniqueidentifier
ORDER_TYPE_TYPE	varchar(50)
ORDER_TYPE_VALUE	varchar(250)
ORDER_TYPE_DISPLAY	varchar(250)
ORDER_TYPE_DESCR	varchar(250)
ORDER_TYPE_SORT	varchar(50)
ROW_STATE	int
CREATE_DATE	smalldatetime
CREATE_BY	varchar(250)
UPDATE_DATE	datetime
UPDATE_BY	varchar(250)
UPDATE_COUNT	int
ORDER_TYPE_EXTERNAL	varchar(50)
Version (Note: This is sent as a separate dataset.)	bigint

WOMD_PRODUCT_CODES

Returns a list of Product Codes

Input Parameters

Example Request:

  {
    "RequestType":"[VENDORNAME].WOMD_PRODUCT_CODES",
    "DataExportFormat":"JSON",
    "TargetUrl":"https://yoursite.com/ProcessData",
    "ChunkRowsCount":"50",
    "GenerateInValidFormat":"true",
    "Parameters":
    [
      {
        "Name":"@PriorVersion",
        "DbType":"int",
        "Value":"100"
      },
      {
        "Name":"@Version",
        "DbType":"int",
        "Value":"100"
      }
    ]
  }

Example Error:

  {
    "Message": "There is no DDL's with request type - [VENDOR_NAME].WOMD_PRODUCT_CODES for Agreement [VENDOR_NAME]/PM_v110"
  }

Field Name	Data Type
@PriorVersion	int
@Version	int

Output Fields

Field Name	Data Type
PRODUCT_CODE_ID	uniqueidentifier
DEFAULT_SPOTS_PER_EVENT	int
DEFAULT_TIME_SEPARATION	int
IS_USED_IN_REVENUE	int
IS_USED_IN_SEPARATION	int
PARENT_PRODUCT_CODE_ID	uniqueidentifier
PRODUCT_CODE_DESCR	varchar(250)
PRODUCT_CODE_DISPLAY	varchar(250)
PRODUCT_CODE_NAME	varchar(50)
PRODUCT_CODE_REPORTING_NAME	varchar(100)
PRODUCT_CODE_SORT	varchar(50)
SELFISH_PRODUCT_CODE_ID	uniqueidentifier
IS_SOFT_DELETED	int
CREATE_DATE	smalldatetime
CREATE_BY	varchar(250)
UPDATE_DATE	datetime
UPDATE_BY	varchar(250)
UPDATE_COUNT	int
Version (Note: This is sent as a separate dataset.)	bigint

WOMD_PROGRAMS

Returns a list of Programs

Input Parameters

Example Request:

  {
    "RequestType":"[VENDORNAME].WOMD_PROGRAMS",
    "DataExportFormat":"JSON",
    "TargetUrl":"https://yoursite.com/ProcessData",
    "ChunkRowsCount":"50",
    "GenerateInValidFormat":"true",
    "Parameters":
    [
      {
        "Name":"@PriorVersion",
        "DbType":"int",
        "Value":"100"
      },
      {
        "Name":"@Version",
        "DbType":"int",
        "Value":"100"
      }
    ]
  }

Example Error:

  {
    "Message": "There is no DDL's with request type - [VENDOR_NAME].WOMD_PROGRAMS for Agreement [VENDOR_NAME]/PM_v110"
  }

Field Name	Data Type
@PriorVersion	int
@Version	int

Output Fields

Field Name	Data Type
PROGRAM_ID	uniqueidentifier
PROGRAM_NAME	varchar(250)
TV_RATING_INT	smallint
LAST_USED_DATE	smalldatetime
EXPIRE_DATE	smalldatetime
EXPIRATION_DAYS	int
IS_SOFT_DELETED	int
CREATE_DATE	smalldatetime
CREATE_BY	varchar(250)
UPDATE_DATE	datetime
UPDATE_BY	varchar(250)
UPDATE_COUNT	int
GENRE_INT	smallint
PROGRAM_INT	int
PROGRAM_EXTERNAL_ID	varchar(50)
STATION_ARRAY_INT	int
Version (Note: This is sent as a separate dataset.)	bigint

WOMD_ REVENUE_CODE2S

Returns a list of Revenue Code2's

Input Parameters

Example Request:

  {
    "RequestType":"[VENDORNAME].WOMD_ REVENUE_CODE2S",
    "DataExportFormat":"JSON",
    "TargetUrl":"https://yoursite.com/ProcessData",
    "ChunkRowsCount":"50",
    "GenerateInValidFormat":"true",
    "Parameters":
    [
      {
        "Name":"@PriorVersion",
        "DbType":"int",
        "Value":"100"
      },
      {
        "Name":"@Version",
        "DbType":"int",
        "Value":"100"
      }
    ]
  }

Example Error:

  {
    "Message": "There is no DDL's with request type - [VENDOR_NAME].WOMD_ REVENUE_CODE2S for Agreement [VENDOR_NAME]/PM_v110"
  }

Field Name	Data Type
@PriorVersion	int
@Version	int

Output Fields

Field Name	Data Type
REVENUE_CODE2_INT	smallint
REVENUE_CODE2_GUID	uniqueidentifier
REVENUE_CODE2_TYPE	varchar(50)
REVENUE_CODE2_VALUE	varchar(250)
REVENUE_CODE2_DISPLAY	varchar(250)
REVENUE_CODE2_DESCR	varchar(250)
REVENUE_CODE2_SORT	varchar(50)
ROW_STATE	int
CREATE_DATE	smalldatetime
CREATE_BY	varchar(250)
UPDATE_DATE	datetime
UPDATE_BY	varchar(250)
UPDATE_COUNT	int
REVENUE_CODE2_EXTERNAL	varchar(50)
Version (Note: This is sent as a separate dataset.)	bigint

WOMD_ REVENUE_CODE3S

Returns a list of Revenue Code3's

Input Parameters

Example Request:

  {
    "RequestType":"[VENDORNAME].WOMD_ REVENUE_CODE3S",
    "DataExportFormat":"JSON",
    "TargetUrl":"https://yoursite.com/ProcessData",
    "ChunkRowsCount":"50",
    "GenerateInValidFormat":"true",
    "Parameters":
    [
      {
        "Name":"@PriorVersion",
        "DbType":"int",
        "Value":"100"
      },
      {
        "Name":"@Version",
        "DbType":"int",
        "Value":"100"
      }
    ]
  }

Example Error:

  {
    "Message": "There is no DDL's with request type - [VENDOR_NAME].WOMD_ REVENUE_CODE3S for Agreement [VENDOR_NAME]/PM_v110"
  }

Field Name	Data Type
@PriorVersion	int
@Version	int

Output Fields

Field Name	Data Type
REVENUE_CODE3_INT	smallint
REVENUE_CODE3_GUID	uniqueidentifier
REVENUE_CODE3_TYPE	varchar(50)
REVENUE_CODE3_VALUE	varchar(250)
REVENUE_CODE3_DISPLAY	varchar(250)
REVENUE_CODE3_DESCR	varchar(250)
REVENUE_CODE3_SORT	varchar(50)
ROW_STATE	int
CREATE_DATE	smalldatetime
CREATE_BY	varchar(250)
UPDATE_DATE	datetime
UPDATE_BY	varchar(250)
UPDATE_COUNT	int
REVENUE_CODE3_EXTERNAL	varchar(50)
Version (Note: This is sent as a separate dataset.)	bigint

WOMD_ REVENUE_CODES

Returns a list of Revenue Codes

Input Parameters

Example Request:

  {
    "RequestType":"[VENDORNAME].WOMD_ REVENUE_CODES",
    "DataExportFormat":"JSON",
    "TargetUrl":"https://yoursite.com/ProcessData",
    "ChunkRowsCount":"50",
    "GenerateInValidFormat":"true",
    "Parameters":
    [
      {
        "Name":"@PriorVersion",
        "DbType":"int",
        "Value":"100"
      },
      {
        "Name":"@Version",
        "DbType":"int",
        "Value":"100"
      }
    ]
  }

Example Error:

  {
    "Message": "There is no DDL's with request type - [VENDOR_NAME].WOMD_ REVENUE_CODES for Agreement [VENDOR_NAME]/PM_v110"
  }

Field Name	Data Type
@PriorVersion	int
@Version	int

Output Fields

Field Name	Data Type
REVENUE_CODE_INT	smallint
REVENUE_CODE_GUID	uniqueidentifier
REVENUE_CODE_TYPE	varchar(50)
REVENUE_CODE_VALUE	varchar(250)
REVENUE_CODE_DISPLAY	varchar(250)
REVENUE_CODE_DESCR	varchar(250)
REVENUE_CODE_SORT	varchar(50)
ROW_STATE	int
CREATE_DATE	smalldatetime
CREATE_BY	varchar(250)
UPDATE_DATE	datetime
UPDATE_BY	varchar(250)
UPDATE_COUNT	int
REVENUE_CODE_EXTERNAL	varchar(50)
Version (Note: This is sent as a separate dataset.)	bigint

WOMD_SALES_OFFICES

Returns a list of Sales Offices

Input Parameters

Example Request:

  {
    "RequestType":"[VENDORNAME].WOMD_SALES_OFFICES",
    "DataExportFormat":"JSON",
    "TargetUrl":"https://yoursite.com/ProcessData",
    "ChunkRowsCount":"50",
    "GenerateInValidFormat":"true",
    "Parameters":
    [
      {
        "Name":"@PriorVersion",
        "DbType":"int",
        "Value":"100"
      },
      {
        "Name":"@Version",
        "DbType":"int",
        "Value":"100"
      }
    ]
  }

Example Error:

  {
    "Message": "There is no DDL's with request type - [VENDOR_NAME].WOMD_SALES_OFFICES for Agreement [VENDOR_NAME]/PM_v110"
  }

Field Name	Data Type
@PriorVersion	int
@Version	int

Output Fields

Field Name	Data Type
SALES_OFFICE_ID	uniqueidentifier
MAILING_ADDRESS_ID	uniqueidentifier
MAIN_FAX_NUMBER	varchar(50)
MAIN_PHONE_NUMBER	varchar(50)
REMIT_ADDRESS_ID	uniqueidentifier
SALES_OFFICE_ABBREVIATION	varchar(20)
SALES_OFFICE_EXTERNAL_ID	varchar(50)
SALES_OFFICE_NAME	varchar(50)
SALES_OFFICE_REPORTING_NAME	varchar(100)
SALES_REGION_ID	uniqueidentifier
SALES_REGION_INT	smallint
STATION_IDS	text
IS_SOFT_DELETED	int
CREATE_DATE	smalldatetime
CREATE_BY	varchar(250)
UPDATE_DATE	datetime
UPDATE_BY	varchar(250)
UPDATE_COUNT	int
Version (Note: This is sent as a separate dataset.)	bigint

WOMD_SALES_REGIONS

Returns a list of Sales Regions

Input Parameters

Example Request:

  {
    "RequestType":"[VENDORNAME].WOMD_SALES_REGIONS",
    "DataExportFormat":"JSON",
    "TargetUrl":"https://yoursite.com/ProcessData",
    "ChunkRowsCount":"50",
    "GenerateInValidFormat":"true",
    "Parameters":
    [
      {
        "Name":"@PriorVersion",
        "DbType":"int",
        "Value":"100"
      },
      {
        "Name":"@Version",
        "DbType":"int",
        "Value":"100"
      }
    ]
  }

Example Error:

  {
    "Message": "There is no DDL's with request type - [VENDOR_NAME].WOMD_SALES_REGIONS for Agreement [VENDOR_NAME]/PM_v110"
  }

Field Name	Data Type
@PriorVersion	int
@Version	int

Output Fields

Field Name	Data Type
SALES_REGIONS_INT	smallint
SALES_REGIONS_GUID	uniqueidentifier
SALES_REGIONS_TYPE	varchar(50)
SALES_REGIONS_VALUE	varchar(250)
SALES_REGIONS_DISPLAY	varchar(250)
SALES_REGIONS_DESCR	varchar(250)
SALES_REGIONS_SORT	varchar(50)
ROW_STATE	int
CREATE_DATE	smalldatetime
CREATE_BY	varchar(250)
UPDATE_DATE	datetime
UPDATE_BY	varchar(250)
UPDATE_COUNT	int
SALES_REGIONS_EXTERNAL	varchar(50)
Version (Note: This is sent as a separate dataset.)	bigint

WOMD_SECURITY_GROUPS

Returns a list of Security Groups

Input Parameters

Example Request:

  {
    "RequestType":"[VENDORNAME].WOMD_SECURITY_GROUPS",
    "DataExportFormat":"JSON",
    "TargetUrl":"https://yoursite.com/ProcessData",
    "ChunkRowsCount":"50",
    "GenerateInValidFormat":"true",
    "Parameters":
    [
      {
        "Name":"@PriorVersion",
        "DbType":"int",
        "Value":"100"
      },
      {
        "Name":"@Version",
        "DbType":"int",
        "Value":"100"
      }
    ]
  }

Example Error:

  {
    "Message": "There is no DDL's with request type - [VENDOR_NAME].WOMD_SECURITY_GROUPS for Agreement [VENDOR_NAME]/PM_v110"
  }

Field Name	Data Type
@PriorVersion	int
@Version	int

Output Fields

Field Name	Data Type
SECURITY_GROUP_ID	uniqueidentifier
GROUPNAME	varchar(52)
DESCRIPTION	varchar(250)
SECURITY_USER_ID	uniqueidentifier
IS_SOFT_DELETED	int
CREATE_DATE	smalldatetime
CREATE_BY	varchar(250)
UPDATE_DATE	datetime
UPDATE_BY	varchar(250)
UPDATE_COUNT	int
Version (Note: This is sent as a separate dataset.)	bigint

WOMD_SECURITY_USERS

Returns a list of Security Users

Input Parameters

Example Request:

  {
    "RequestType":"[VENDORNAME].WOMD_SECURITY_USERS",
    "DataExportFormat":"JSON",
    "TargetUrl":"https://yoursite.com/ProcessData",
    "ChunkRowsCount":"50",
    "GenerateInValidFormat":"true",
    "Parameters":
    [
      {
        "Name":"@PriorVersion",
        "DbType":"int",
        "Value":"100"
      },
      {
        "Name":"@Version",
        "DbType":"int",
        "Value":"100"
      }
    ]
  }

Example Error:

  {
    "Message": "There is no DDL's with request type - [VENDOR_NAME].WOMD_SECURITY_USERS for Agreement [VENDOR_NAME]/PM_v110"
  }

Field Name	Data Type
@PriorVersion	int
@Version	int

Output Fields

Field Name	Data Type
SECURITY_USER_ID	uniqueidentifier
USERNAME	varchar(50)
IS_SUPER_USER	int
CONTACT_ID	uniqueidentifier
LAST_LOGIN	smalldatetime
LAST_PASSWORD_CHANGE	smalldatetime
IS_DOMAIN_LOGIN	int
INVALID_LOGIN_ATTEMPTS	int
BUYER_CONTACT_ID	uniqueidentifier
SECURITY_USER_INT	smallint
AE_SECURITY_GROUP_INT	int
ACCOUNT_EXEC_ID	uniqueidentifier
IS_PASSWORD_RESET	int
GROUPS	ntext
PROPERTIES	ntext
IS_SOFT_DELETED	int
CREATE_DATE	smalldatetime
CREATE_BY	varchar(250)
UPDATE_DATE	datetime
UPDATE_BY	varchar(250)
UPDATE_COUNT	int
Version (Note: This is sent as a separate dataset.)	bigint

WOMD_SELLING_ELEMENTS

Returns a list of Selling Elements

Input Parameters

Example Request:

  {
    "RequestType":"[VENDORNAME].WOMD_SELLING_ELEMENTS",
    "DataExportFormat":"JSON",
    "TargetUrl":"https://yoursite.com/ProcessData",
    "ChunkRowsCount":"50",
    "GenerateInValidFormat":"true",
    "Parameters":
    [
      {
        "Name":"@PriorVersion",
        "DbType":"int",
        "Value":"100"
      },
      {
        "Name":"@Version",
        "DbType":"int",
        "Value":"100"
      }
    ]
  }

Example Error:

  {
    "Message": "There is no DDL's with request type - [VENDOR_NAME].WOMD_SELLING_ELEMENTS for Agreement [VENDOR_NAME]/PM_v110"
  }

Field Name	Data Type
@PriorVersion	int
@Version	int

Output Fields

Field Name	Data Type
SELLING_ELEMENT_ID	uniqueidentifier
SELLING_ELEMENT_INT	smallint
SELLING_ELEMENT_NAME	varchar(50)
SELLING_ELEMENT_CODE	varchar(10)
SELLING_ELEMENT_SORT	varchar(10)
REPORTING_NAME	varchar(100)
IMPRESSIONS_IN_POSTING	bit
HAS_IMPRESSIONS	bit
SUPPRESS_INVOICE_LINE	bit
DEFAULT_INVENTORY_TYPE_INT	smallint
DEFAULT_BREAK_CODE_INT	smallint
DEFAULT_SELLING_NAME_RATE_FACTOR	smallint
DEFAULT_LENGTH1	int
DEFAULT_LENGTH2	int
DEFAULT_LENGTHS	text
ALLOWS_CUSTOM_LENGTH	bit
DEFAULT_INSTRUCTION_CLASS_INT	smallint
STATION_ARRAY_INT	int
IS_SOFT_DELETED	int
CREATE_DATE	smalldatetime
CREATE_BY	varchar(250)
UPDATE_DATE	smalldatetime
UPDATE_BY	varchar(250)
UPDATE_COUNT	smallint
Version (Note: This is sent as a separate dataset.)	bigint

WOMD_STATION_CONTACTS

Returns a list of Station Contacts

Input Parameters

Example Request:

  {
    "RequestType":"[VENDORNAME].WOMD_STATION_CONTACTS",
    "DataExportFormat":"JSON",
    "TargetUrl":"https://yoursite.com/ProcessData",
    "ChunkRowsCount":"50",
    "GenerateInValidFormat":"true",
    "Parameters":
    [
      {
        "Name":"@PriorVersion",
        "DbType":"int",
        "Value":"100"
      },
      {
        "Name":"@Version",
        "DbType":"int",
        "Value":"100"
      }
    ]
  }

Example Error:

  {
    "Message": "There is no DDL's with request type - [VENDOR_NAME].WOMD_STATION_CONTACTS for Agreement [VENDOR_NAME]/PM_v110"
  }

Field Name	Data Type
@PriorVersion	int
@Version	int

Output Fields

Field Name	Data Type
STATION_CONTACT_ID	uniqueidentifier
STATION_ID	uniqueidentifier
CONTACT_ID	uniqueidentifier
CONTACT_TYPE	varchar(250)
LAST_PRINT_DATE	datetime
IS_SOFT_DELETED	int
CREATE_DATE	smalldatetime
CREATE_BY	varchar(250)
UPDATE_DATE	datetime
UPDATE_BY	varchar(250)
UPDATE_COUNT	int
Version (Note: This is sent as a separate dataset.)	bigint

WOMD_STATIONS

Returns a list of Stations

Input Parameters

Example Request:

  {
    "RequestType":"[VENDORNAME].WOMD_STATIONS",
    "DataExportFormat":"JSON",
    "TargetUrl":"https://yoursite.com/ProcessData",
    "ChunkRowsCount":"50",
    "GenerateInValidFormat":"true",
    "Parameters":
    [
      {
        "Name":"@PriorVersion",
        "DbType":"int",
        "Value":"100"
      },
      {
        "Name":"@Version",
        "DbType":"int",
        "Value":"100"
      }
    ]
  }

Example Error:

  {
    "Message": "There is no DDL's with request type - [VENDOR_NAME].WOMD_STATIONS for Agreement [VENDOR_NAME]/PM_v110"
  }

Field Name	Data Type
@PriorVersion	int
@Version	int

Output Fields

Field Name	Data Type
STATION_ID	uniqueidentifier
STATION_INT	smallint
ACCOUNTING_CLOSE_DATE	smalldatetime
ALLOW_IGNORE_INVENTORY_CODE	tinyint
ALLOW_TIMES_CLEARED_INVENTORY_CHANGES	bit
BUMP_FILLERS	tinyint
CLUSTER_PROXIMITY	tinyint
DEFAULT_ADVERTISER_SEPARATION	int
DEFAULT_CHANNEL_PLACEMENT_TYPE	tinyint
DEFAULT_DAILY_MAX	tinyint
DEFAULT_DEMO_CODE	varchar(250)
DEFAULT_DEMO_CODE_INT	smallint
DEFAULT_EC_DAILY_MAX	bit
DEFAULT_LINE_ROTATION_TYPE	tinyint
DEFAULT_NEW_BUSINESS_MONTHS	int
DEFAULT_ORDER_IS_COOP	tinyint
DEFAULT_ORDER_LINE_CUSTOM_WEEKS	tinyint
DEFAULT_ORDER_PRINT_FULL	int
DEFAULT_ORDER_SEPARATION	int
DEFAULT_SPECIAL_HANDLING	varchar(250)
DEFAULT_SUPPRESS_CREDITS	bit
DEFAULT_SUPPRESS_MAKEGOOD_INFO	bit
DEFAULT_TARGET_CHANNEL_PERCENT	tinyint
DISABLE_DISTRIBUTION_CONFLICTS	tinyint
DISALLOW_DISPLAY_TIMES_CHANGES	tinyint
DISALLOW_INVENTORY_DESCRIPTION_CHANGES	tinyint
DISPLAY_TIMES_FROM_EC_TIMES	bit
DISPLAY_TIMES_FROM_RESTRICT	tinyint
EC_NAME	varchar(25)
ENABLE_LIVE_OPTIMIZER	tinyint
FORMAT	varchar(50)
HIDE_NSI_DISCLAIMER	bit
IGNORE_TIE_EVENT_SEPARATIONS	bit
INTERNAL_ESTIMATE_GUID	uniqueidentifier
INVENTORY_DESCRIPTION_FROM_EC_PROGRAM	bit
INVENTORY_DESCRIPTION_FROM_RESTRICT	tinyint
INVOICE_ATTENTION	varchar(50)
INVOICE_NUMBER_TYPE	tinyint
INVOICE_STATION_OFFICIAL	varchar(50)
INVOICE_STATION_TITLE	varchar(50)
IS_REQUIRED_AIRED_PROGRAM	bit
LIVE_OPTIMIZER_MAX_DAYS	tinyint
LOG_FINALIZE_CHECK_MISSING_MATERIALS	tinyint
LOG_FINALIZE_CHECK_OPEN_INVENTORY	tinyint
LOG_FINALIZE_CHECK_PENDING_BUYER_APPROVAL	tinyint
LOG_FINALIZE_CHECK_PGM_MISSING_MATERIALS	tinyint
LOG_FINALIZE_CHECK_UNPROCESSED_ORDERS	tinyint
MARKET	varchar(50)
MONTHLY_INVOICE_PREFIX	varchar(2)
ORDERS_REQUIRE_BUYCODE	tinyint
ORDERS_REQUIRE_DIGITAL_PRODUCT	bit
ORDERS_REQUIRE_TRAFFICKER	bit
PLACE_IN_WEEK_THEN_BUMP	bit
PLACER_SLOT_PREFERENCE	tinyint
PRINT_SCRIPT_AFTER_LOG	tinyint
PRINT_SCRIPT_ON_LOG	tinyint
RE_APPLY_INSTRUCTIONS_WINDOW	tinyint
REGION	varchar(50)
REMIT_ADDRESS_ID	uniqueidentifier
REPORTING_NAME	varchar(100)
REQUIRE_AE_OFFICE_REGION	bit
REQUIRE_ALT_ORDER_NUMBER	tinyint
REQUIRE_ORDER_PRODUCT_DESCR	tinyint
REQUIRE_RESTRICT_TIMES	tinyint
SALES_STATION_CODE	varchar(50)
SHOW_ONLY_CURRENT_CHANNEL_CONFLICTS	bit
SPOTS_RETAIN_MATERIAL	bit
STATION_BILLING_PHONE	varchar(50)
STATION_CALL_LETTERS	varchar(25)
STATION_GROUP_ID	uniqueidentifier
STATION_GROUP_INT	smallint
MAIN_ADDRESS_ID	uniqueidentifier
STATION_MAIN_PHONE	varchar(50)
STATION_NAME	varchar(50)
STATION_WEB_SITE	varchar(50)
VERIFIED_CLOSE_DATE	smalldatetime
UNIT_CODE_ID	uniqueidentifier
IS_SOFT_DELETED	int
CREATE_DATE	smalldatetime
CREATE_BY	varchar(250)
UPDATE_DATE	datetime
UPDATE_BY	varchar(250)
UPDATE_COUNT	int
STATION_TYPE	smallint
STATION_ARRAY	binary(256)
AFFILIATION_INT	smallint
ALLOW_PROGRAM_CLEARED_INVENTORY_CHANGES	bit
AVAIL_REQUEST_REQUIRE_STATION_SHARES	bit
CNS_DEAL_AVAILS_PRIORITY_HIGH	text
CNS_DEAL_AVAILS_PRIORITY_LOW	text
CNS_OPTIONS_ALERT_DAYS	smallint
DEFAULT_BILLING_GROUP_INT	smallint
DEFAULT_ORDER_CHANNEL_INT	int
DEFAULT_RATING_STREAM_INT	smallint
DEFAULT_RI_IMPORT_IS_CASH	bit
DEFAULT_SELLING_ELEMENT_INT	smallint
DEFAULT_STATION_TAX1_ID	uniqueidentifier
DEFAULT_STATION_TAX2_ID	uniqueidentifier
DEFAULT_SUPPRESS_IMPRESSIONS	bit
DEFAULT_SUPPRESS_RATES	bit
DEFAULT_TAX1_INT	smallint
DEFAULT_TAX2_INT	smallint
EC_GRID_IGNORE_ELIGIBLE_TIMES_VALIDATION	bit
EC_GRID_TIME_THRESHOLD	tinyint
FILLER_FORMAT_TEMPLATE_ID	uniqueidentifier
HAS_AD_ID_SUMMARY_AFTER_INVOICE	bit
IS_AUTO_POPULATE_NOTARIZE_DATE	bit
IS_REQUIRED_ORDER_BRAND	bit
LOG_FINALIZE_CHECK_CIA	tinyint
LOG_FINALIZE_CHECK_DISPLACED	tinyint
LOG_FINALIZE_CHECK_HOLD_CNS_DEALS	tinyint
LOG_FINALIZE_CHECK_UNWIRED_APPLY_NOT_SELECTED	tinyint
LOG_FINALIZE_CHECK_UNWIRED_MATERIAL_MISMATCH	tinyint
LOG_FINALIZE_CHECK_UNWIRED_MATERIAL_SOURCE_MISSING	tinyint
LOG_FINALIZE_CHECK_UNWIRED_NO_AVAILABLE_SLOT	tinyint
LOG_FINALIZE_CHECK_UNWIRED_REQUIRE_NETWORK_FINALIZATION	tinyint
MULTICAST_PRIMARY_STATION_INT	smallint
NOTARY_COMMISSION_EXPIRATION	nvarchar(10)
NOTARY_SIGNATURE	image
NOTARY_STAMP	image
OFFICIAL_SIGNATURE	image
ORDERS_REQUIRE_BILLING_SOURCE	bit
PACK_BREAKS_ON_DISPLACE	bit
PACK_IGNORE_SEPARATION_CONFLICTS	bit
PLATFORM_INT	smallint
RADIO_INTERCHANGE_MATERIAL_GROUP_ID	uniqueidentifier
REMIT_ADDRESS_INT	int
SALES_STATION_ID	uniqueidentifier
STATION_ARRAY_INT	int
STATION_INTERNAL_LOGO	image
STATION_MAIN_ADDRESS_INT	int
SUPPRESS_DIGITAL_BOOKED_IMPS	bit
SUPPRESS_DIGITAL_DELIVERED_CLICKS	bit
SUPPRESS_DIGITAL_DELIVERED_IMPS	bit
SUPPRESS_DIGITAL_RATES	bit
SUPPRESS_DIGITAL_RATETYPE	bit
SUPPRESS_DIGITAL_TOTAL_AMOUNT	bit
TRADE_CREDIT_STATUS	tinyint
UNIT_CODE_INT	smallint
USE_PLACER_OPTIMIZATION_SETTINGS	bit
Version (Note: This is sent as a separate dataset.)	bigint

WOMD_UNIT_CODES

Returns a list of Unit Codes

Input Parameters

Example Request:

  {
    "RequestType":"[VENDORNAME].WOMD_UNIT_CODES",
    "DataExportFormat":"JSON",
    "TargetUrl":"https://yoursite.com/ProcessData",
    "ChunkRowsCount":"50",
    "GenerateInValidFormat":"true",
    "Parameters":
    [
      {
        "Name":"@PriorVersion",
        "DbType":"int",
        "Value":"100"
      },
      {
        "Name":"@Version",
        "DbType":"int",
        "Value":"100"
      }
    ]
  }

Example Error:

  {
    "Message": "There is no DDL's with request type - [VENDOR_NAME].WOMD_UNIT_CODES for Agreement [VENDOR_NAME]/PM_v110"
  }

Field Name	Data Type
@PriorVersion	int
@Version	int

Output Fields

Field Name	Data Type
UNIT_CODE_ID	uniqueidentifier
UNIT_CODE_INT	smallint
EXTERNAL_ID	varchar(250)
REPORTING_NAME	varchar(250)
UNIT_CODE_CODE	varchar(250)
UNIT_CODE_DESCRIPTION	varchar(250)
UNIT_CODE_DISPLAY	varchar(250)
UNIT_CODE_SORT	varchar(50)
STATION_IDS	text
IS_SOFT_DELETED	int
CREATE_DATE	smalldatetime
CREATE_BY	varchar(250)
UPDATE_DATE	smalldatetime
UPDATE_BY	varchar(250)
UPDATE_COUNT	smallint
Version (Note: This is sent as a separate dataset.)	bigint

WOXD_FED

Returns the log for a given Station

Input Parameters

Example Request:

  {
    "RequestType":"[VENDORNAME].WOXD_FED",
    "DataExportFormat":"JSON",
    "TargetUrl":"https://yoursite.com/ProcessData",
    "ChunkRowsCount":"50",
    "GenerateInValidFormat":"true",
    "Parameters":
    [
      {
        "Name":"@StationInt",
        "DbType":"int",
        "Value":"1"
      },
      {
        "Name":"@PriorVersion",
        "DbType":"int",
        "Value":"100"
      },
      {
        "Name":"@Version",
        "DbType":"int",
        "Value":"1000"
      }
    ]
  }

Example Error:

  {
    "Message": "There is no DDL's with request type - [VENDOR_NAME].WOXD_FED for Agreement [VENDOR_NAME]/PM_v110"
  }

Field Name	Data Type
@StationInt	int
@PriorVersion	int
@Version	int

Output Fields

Field Name	Data Type
FORMAT_EVENT_DETAIL_ID	uniqueidentifier
CHANNEL_INT	int
ORDER_LINE_UNIT_ID	uniqueidentifier
ORDER_LINE_UNIT_INDEX	tinyint
OFFSET	int
DISPLAY_NAME	varchar(50)
LOG_HOUSE_NAME	varchar(50)
LOG_HOUSE_NAME_EDIT_CODE	tinyint
LOG_HOUSE_NAME_DEFAULT	varchar(50)
LENGTH	int
START_TIME	int
END_TIME	int
EVENT_CODE_INT	smallint
BREAK_CODE_INT	smallint
IS_LOCKED	bit
IS_ALL_CHANNEL	bit
AIR_DATE	smalldatetime
RECONCILE_DATE	smalldatetime
LOG_SPOT_NUMBER	smallint
AS_AIRED_START_TIME	int
AS_AIRED_END_TIME	int
AS_AIRED_LOG_HOUSE_NAME	varchar(50)
AS_AIRED_LENGTH	int
AIR_STATUS_CODE_INT	smallint
UPDATE_DATE	smalldatetime
UPDATE_BY	varchar(250)
FORMAT_EVENT_DETAIL_INT	int
THRESHOLD_PCT	decimal(5,2)
PROMOTION_INT	int
INVENTORY_CODE_INT	int
MATERIAL_INT	int
MATERIAL_INSTRUCTION_SET_INT	int
MATERIAL_INSTRUCTION_INT	int
FORMAT_INT	int
FORMAT_EVENT_DETAIL_TEMPLATE_INT	int
SPLIT_MATERIAL_INT	int
SPLIT_MATERIAL_INSTRUCTION_INT	int
AS_AIRED_MATERIAL_INT	int
Version (Note: This is sent as a separate dataset.)	bigint

WOXD_MATERIALS

Returns a list of Materials

Input Parameters

Example Request:

  {
    "RequestType":"[VENDORNAME].WOXD_MATERIALS",
    "DataExportFormat":"JSON",
    "TargetUrl":"https://yoursite.com/ProcessData",
    "ChunkRowsCount":"50",
    "GenerateInValidFormat":"true",
    "Parameters":
    [
      {
        "Name":"@PriorVersion",
        "DbType":"int",
        "Value":"100"
      },
      {
        "Name":"@Version",
        "DbType":"int",
        "Value":"100"
      }
    ]
  }

Example Error:

  {
    "Message": "There is no DDL's with request type - [VENDOR_NAME].WOXD_MATERIALS for Agreement [VENDOR_NAME]/PM_v110"
  }

Field Name	Data Type
@PriorVersion	int
@Version	int

Output Fields

Field Name	Data Type
MATERIAL_ID	uniqueidentifier
MATERIAL_GROUP_ID	uniqueidentifier
MATERIAL_NAME	varchar(50)
MATERIAL_TITLE	varchar(50)
MATERIAL_LENGTH	int
ADVERTISER_ID	uniqueidentifier
PRODUCT_DESCR	varchar(50)
COOP_CODE	varchar(50)
ISCI_CODE	varchar(50)
HOUSE_ALPHA	varchar(50)
HOUSE_NUMBER	int
CUT_ALPHA	varchar(50)
CUT_NUMBER	int
HOUSE_NAME	varchar(50)
PRODUCT_CODE_ID	uniqueidentifier
FCC_TYPE_INT	smallint
FCC_SOURCE_INT	smallint
DISTRIBUTION_SOURCE	varchar(50)
USEABLE_FOR_FILLER	int
IS_SOFT_DELETED	int
CREATE_DATE	smalldatetime
CREATE_BY	varchar(250)
UPDATE_DATE	datetime
UPDATE_BY	varchar(250)
UPDATE_COUNT	int
QC_REVIEW_INT	int
ADVERTISER_BRAND_ID	uniqueidentifier
EXTERNAL_MEDIA_REF	varchar(50)
SCRIPT	text
PRINT_SCRIPT_ON_LOG	tinyint
WO_FIELD1	varchar(50)
WO_FIELD2	varchar(50)
WO_FIELD3	varchar(50)
WO_FIELD4	varchar(50)
WO_FIELD5	varchar(50)
MATERIAL_INT	int
MATERIAL_ANNOTATION	varchar(50)
STANDBY_HOUSE_NUMBER	varchar(50)
IS_TAPE	bit
STATION_ARRAY_INT	int
DIGITAL_STREAMING_INTEGRATION_AD_SLOT_INT	int
DIGITAL_INTERNET_INTEGRATION_AD_SLOT_INT	int
DIGITAL_TAP_INTEGRATION_AD_SLOT_INT	int
PROMOTION_INT	int
ADDRESSABLE_INT	smallint
Version (Note: This is sent as a separate dataset.)	bigint

WOXD_ORDER_ACTIVITY

Returns Order Activity for a given station

Input Parameters

Example Request:

  {
    "RequestType":"[VENDORNAME].WOXD_ORDER_ACTIVITY",
    "DataExportFormat":"JSON",
    "TargetUrl":"https://yoursite.com/ProcessData",
    "ChunkRowsCount":"50",
    "GenerateInValidFormat":"true",
    "Parameters":
    [
      {
        "Name":"@StationInt",
        "DbType":"int",
        "Value":"1"
      },
      {
        "Name":"@PriorVersion",
        "DbType":"int",
        "Value":"100"
      },
      {
        "Name":"@Version",
        "DbType":"int",
        "Value":"100"
      }
    ]
  }

Example Error:

  {
    "Message": "There is no DDL's with request type - [VENDOR_NAME].WOXD_ORDER_ACTIVITY for Agreement [VENDOR_NAME]/PM_v110"
  }

Field Name	Data Type
@StationInt	int
@PriorVersion	int
@Version	int

Output Fields

Field Name	Data Type
ACTIVITY_BY	varchar(250)
ACTIVITY_DATE	smalldatetime
CHANGE_AMOUNT	money
CHANGE_LENGTH	int
CHANGE_NET_AMOUNT	money
CHANGE_TYPE	varchar(1)
CHANGE_UNITS	smallint
CHANNEL_INT	smallint
EFFECTED_DATE	smalldatetime
INVENTORY_CODE_INT	int
ORDER_ACTIVITY_ID	uniqueidentifier
ORDER_INT	int
PRIORITY_CODE_INT	smallint
REVENUE_CODE1_INT	smallint
REVENUE_CODE2_INT	smallint
REVENUE_CODE3_INT	smallint
STATION_INT	smallint
UNIT_CODE_INT	smallint
Version (Note: This is sent as a separate dataset.)	bigint

WOXD_ORDER_BILL_PLANS

Returns a list of Order Bill Plans

Input Parameters

Example Request:

  {
    "RequestType":"[VENDORNAME].WOXD_ORDER_BILL_PLANS",
    "DataExportFormat":"JSON",
    "TargetUrl":"https://yoursite.com/ProcessData",
    "ChunkRowsCount":"50",
    "GenerateInValidFormat":"true",
    "Parameters":
    [
      {
        "Name":"@PriorVersion",
        "DbType":"int",
        "Value":"100"
      },
      {
        "Name":"@Version",
        "DbType":"int",
        "Value":"100"
      }
    ]
  }

Example Error:

  {
    "Message": "There is no DDL's with request type - [VENDOR_NAME].WOXD_ORDER_BILL_PLANS for Agreement [VENDOR_NAME]/PM_v110"
  }

Field Name	Data Type
@PriorVersion	int
@Version	int

Output Fields

Field Name	Data Type
ORDER_BILL_PLAN_ID	uniqueidentifier
SEQ_NUM	smallint
UNIT_START_DATE	smalldatetime
UNIT_END_DATE	smalldatetime
NUMBER_OF_UNITS	smallint
INTERNAL_AMOUNT	money
EXTERNAL_AMOUNT	money
IS_USER_OVERRIDE	bit
INVOICE_REVISION	smallint
AGENCY_ID	uniqueidentifier
ADVERTISER_ID	uniqueidentifier
ORDER_SHARE	float
IS_PLACEHOLDER	bit
BILLING_ADDRESS_INT	int
REMIT_ADDRESS_INT	int
AGENCY_COMMISSION	float
ORDER_IS_CASH	bit
ORDER_INT	int
INVOICE_INT	int
USE_SINGLE_PLAN_PER_SPOT	bit
IS_REISSUE_PLAN	bit
ADVERTISER_BRAND_INT	int
BILLING_GROUP_INT	int
IS_DELETED	int
IS_SOFT_DELETED	int
CREATE_DATE	smalldatetime
CREATE_BY	varchar(250)
UPDATE_DATE	datetime
UPDATE_BY	varchar(250)
UPDATE_COUNT	int
Version (Note: This is sent as a separate dataset.)	bigint

WOXD_ORDER_INTERNET_LINES

Returns a list of Order Internet Lines

Input Parameters

Example Request:

  {
    "RequestType":"[VENDORNAME].WOXD_ORDER_INTERNET_LINES",
    "DataExportFormat":"JSON",
    "TargetUrl":"https://yoursite.com/ProcessData",
    "ChunkRowsCount":"50",
    "GenerateInValidFormat":"true",
    "Parameters":
    [
      {
        "Name":"@PriorVersion",
        "DbType":"int",
        "Value":"100"
      },
      {
        "Name":"@Version",
        "DbType":"int",
        "Value":"100"
      }
    ]
  }

Example Error:

  {
    "Message": "There is no DDL's with request type - [VENDOR_NAME].WOXD_ORDER_INTERNET_LINES for Agreement [VENDOR_NAME]/PM_v110"
  }

Field Name	Data Type
@PriorVersion	int
@Version	int

Output Fields

Field Name	Data Type
ORDER_INTERNET_LINE_ID	uniqueidentifier
ORDER_LINE_ID	uniqueidentifier
ORDER_INT	int
INTERNET_PRODUCT_INT	int
AD_SLOT_INT	smallint
AD_TYPE_INT	smallint
KEYWORDS	text
TARGET_KEYWORDS	text
FLIGHT_START_TIME	int
FLIGHT_END_TIME	int
INTERNET_PRIORITY	tinyint
FREQUENCY_NUMBER	smallint
FREQUENCY_INTERVAL	smallint
FREQUENCY_TYPE	tinyint
RATE_TYPE	tinyint
ROW_STATE	tinyint
CREATE_DATE	smalldatetime
CREATE_BY	varchar(250)
UPDATE_DATE	datetime
UPDATE_BY	varchar(250)
UPDATE_COUNT	int
WEIGHT	tinyint
RECONCILED_IMPRESSIONS	int
RECONCILED_CLICKS	int
RECONCILED_AMOUNT	money
PRODUCT_TYPE_INT	smallint
AUTO_ORDERID	varchar(80)
AUTO_LINEID	varchar(80)
THIRD_PARTY_AD_SERVER_INT	smallint
AD_SERVER_PCT	real
GOAL_TYPE	tinyint
SUPPRESS_LINE_DELIVERED_CLICKS	bit
CPD_PERIODS	int
FORCE_TOTAL_AMOUNT	money
IS_SPONSORSHIP	bit
EXTERNAL_STATUS	int
EXTERNAL_STATUS_UPDATE_DATE	smalldatetime
SUPPRESS_RATETYPE	bit
IS_MULTICHANNEL	bit
REVENUE_FACTORS	text
SUPPRESS_TOTAL_AMOUNT	bit
ADSERVER_DELIVERY	bit
RECONCILED_INTERNAL_AMOUNT	money
THIRD_PARTY_BILLING	bit
IS_CLEARED_CIA	bit
IS_DELETED	int
IS_SOFT_DELETED	int
Version (Note: This is sent as a separate dataset.)	bigint

WOXD_ORDER_LINE_UNITS

Returns a list of Order Line Units (Spots) for a given station

Input Parameters

Example Request:

  {
    "RequestType":"[VENDORNAME].WOXD_ORDER_LINE_UNITS",
    "DataExportFormat":"JSON",
    "TargetUrl":"https://yoursite.com/ProcessData",
    "ChunkRowsCount":"50",
    "GenerateInValidFormat":"true",
    "Parameters":
    [
	  {
        "Name":"@StationInt",
        "DbType":"int",
        "Value":"1"
      },
      {
        "Name":"@PriorVersion",
        "DbType":"int",
        "Value":"100"
      },
      {
        "Name":"@Version",
        "DbType":"int",
        "Value":"100"
      }
    ]
  }

Example Error:

  {
    "Message": "There is no DDL's with request type - [VENDOR_NAME].WOXD_ORDER_LINE_UNITS for Agreement [VENDOR_NAME]/PM_v110"
  }

Field Name	Data Type
@StationInt	int
@PriorVersion	int
@Version	int

Output Fields

Field Name	Data Type
ACTUAL_ORDER_LINE_UNIT_ID	uniqueidentifier
ADDRESSABLE_INT	smallint
ADVERTISER_BRAND_INT	smallint
AGREED_IMPRESSIONS	int
AGREED_INVENTORY_RATING	float
AIR_LENGTH1	int
AIR_LENGTH2	int
AIR_TIME1	int
AIR_TIME2	int
AIRED_PROGRAM_INT	int
BREAK_CODE_INT	smallint
BREAK_NUMBER	tinyint
BREAK_POSITION	tinyint
CHANNEL_INT	smallint
CNS_RATE_CARD_RATE	money
CNS_SERIAL_NUMBER	int
CREATE_BY	varchar(250)
CREATE_DATE	datetime
CURRENT_STATE_DESCR	varchar(250)
DEAL_INT	int
DISPLAYED_TIMES	varchar(50)
ELIGIBLE_WEEKDAYS	weekdays
EXTERNAL_AMOUNT	money
FIRST_ELIGIBLE_AIR_DATE	smalldatetime
GROUP_CHANGE_INT	int
H_REVENUE_CODE1_INT	smallint
H_REVENUE_CODE2_INT	smallint
H_REVENUE_CODE3_INT	smallint
HAS_MANUAL_MATERIAL	bit
HAS_MANUAL_MOVE	bit
HAS_PRODUCT_EXCLUSIVITY	bit
HAS_SPLIT_FEED	bit
IGNORE_INVENTORY_CODE	bit
INSTRUCTION_CLASS_INT	smallint
INTENDED_AIR_DATE	smalldatetime
INTENDED_LOG_INT	tinyint
INTERNAL_AMOUNT	money
INVENTORY_CODE_INT	int
INVENTORY_DESCR	varchar(50)
INVENTORY_TYPE_INT	smallint
INVOICE_CHANNEL_OVERRIDE	varchar(10)
INVOICE_INT	int
INVOICE_ISCI_CODE1	varchar(50)
INVOICE_ISCI_CODE2	varchar(50)
IS_BONUS	bit
IS_BUYER_APPROVED	tinyint
IS_CLEARED_CIA	bit
IS_CREDITED	bit
IS_LATE_ADD	bit
IS_LOCKED	bit
IS_MAKEGOOD	bit
IS_PENDING	bit
IS_PLACEABLE	bit
IS_PLACED	bit
IS_PLACED_REVENUE_ONLY	bit
IS_REJECTED	bit
IS_SALES_MAKEGOOD	bit
IS_TRANSIENT_ADO_MOVED	bit
IS_TRANSIENT_FORCED	bit
IS_UNRESOLVED	bit
IS_USER_MODIFIED	bit
LAST_ELIGIBLE_AIR_DATE	smalldatetime
LAST_OPTIMIZER_CONFLICTS	tinyint
LENGTH1	int
LENGTH2	int
LIFECYCLE_STATE	tinyint
MADE_GOOD_BY_DESCR	varchar(250)
MAKEGOOD_GROUP_INT	smallint
MATERIAL_INT1	int
MATERIAL_INT2	int
ORDER_INT	int
ORDER_LINE_ID	uniqueidentifier
ORDER_LINE_SCHEDULE_ID	uniqueidentifier
ORDER_LINE_UNIT_ID	uniqueidentifier
ORIGINAL_GROUP_INT	smallint
OVERRIDE_BREAK_CODE_INT	smallint
OVERRIDE_INVENTORY_CODE_INT	int
PLACED_CHANNEL_PERCENT	tinyint
POSTED_IMPRESSIONS	int
POSTED_RATING	float
PRE_VIEWUP_AIR_TIME	int
PRINT_ON_INVOICE	bit
PRINT_ON_ORDER	bit
PRIORITY_CODE_INT	smallint
PROGRAM_INT	int
REJECT_DATE	smalldatetime
RESTRICT_END_TIME	int
RESTRICT_START_TIME	int
REVENUE_CODE_INT	smallint
REVENUE_CODE2_INT	smallint
REVENUE_CODE3_INT	smallint
ROW_STATE	tinyint
SELLING_ELEMENT_INT	smallint
SEQ_NUM	smallint
SPOT_ACTION_INT	tinyint
STATION_INT	smallint
SUPPRESS_SPOT_AMOUNT	bit
TARGET_CHANNEL_PERCENT	tinyint
THRESHOLD_PCT	decimal
UNIT_AIR_STATUS_CODE_INT	smallint
UNIT_CODE_INT	smallint
UPDATE_BY	varchar(250)
UPDATE_COUNT	smallint
UPDATE_DATE	datetime
WAS_MADEGOOD	bit
Version (Note: This is sent as a separate dataset.)	bigint

WOXD_ORDER_LINES

Returns a list of Order Lines

Input Parameters

Example Request:

  {
    "RequestType":"[VENDORNAME].WOXD_ORDER_LINES",
    "DataExportFormat":"JSON",
    "TargetUrl":"https://yoursite.com/ProcessData",
    "ChunkRowsCount":"50",
    "GenerateInValidFormat":"true",
    "Parameters":
    [
      {
        "Name":"@PriorVersion",
        "DbType":"int",
        "Value":"100"
      },
      {
        "Name":"@Version",
        "DbType":"int",
        "Value":"100"
      }
    ]
  }

Example Error:

  {
    "Message": "There is no DDL's with request type - [VENDOR_NAME].WOXD_ORDER_LINES for Agreement [VENDOR_NAME]/PM_v110"
  }

Field Name	Data Type
@PriorVersion	int
@Version	int

Output Fields

Field Name	Data Type
ORDER_LINE_ID	uniqueidentifier
SEQ_NUM	int
CHANNEL_INT	smallint
PARENT_ORDER_LINE_ID	uniqueidentifier
BREAK_CODE_INT	smallint
PRIORITY_CODE_INT	smallint
REVENUE_CODE_INT	smallint
REVENUE_CODE2_INT	smallint
REVENUE_CODE3_INT	smallint
BREAK_POSITION	tinyint
BREAK_NUMBER	tinyint
AGREED_INVENTORY_RATING	float
BILLBOARD_POSITION	tinyint
IS_MAKEGOOD	tinyint
FIRST_ELIGIBLE_DATE	smalldatetime
LAST_ELIGIBLE_DATE	smalldatetime
ORDER_LINE_STATE	tinyint
CANCEL_DATE	smalldatetime
DISPLAYED_TIMES	varchar(50)
INVENTORY_DESCR	varchar(50)
RESTRICT_START_TIME	int
RESTRICT_END_TIME	int
IGNORE_INVENTORY_CODE	tinyint
LENGTH1	int
LENGTH2	int
EXTERNAL_AMOUNT	money
INTERNAL_AMOUNT	money
SUPPRESS_LINE_AMOUNT	tinyint
SUPPRESS_LINE_PRINTING	tinyint
WEEK_DEFINITION	tinyint
NORMAL_SPOT_DISTRIBUTION	tinyint
AIR_START_DATE	smalldatetime
AIR_END_DATE	smalldatetime
WEEK_SPOTS	smallint
IS_PENDING	tinyint
ALT_LINE_NUMBER	varchar(50)
H_REVENUE_CODE1_INT	smallint
H_REVENUE_CODE2_INT	smallint
H_REVENUE_CODE3_INT	smallint
MON_MIN_SPOTS	smallint
TUE_MIN_SPOTS	smallint
WED_MIN_SPOTS	smallint
THU_MIN_SPOTS	smallint
FRI_MIN_SPOTS	smallint
SAT_MIN_SPOTS	smallint
SUN_MIN_SPOTS	smallint
MON_MAX_SPOTS	smallint
TUE_MAX_SPOTS	smallint
WED_MAX_SPOTS	smallint
THU_MAX_SPOTS	smallint
FRI_MAX_SPOTS	smallint
SAT_MAX_SPOTS	smallint
SUN_MAX_SPOTS	smallint
PROGRAM_INT	int
INVENTORY_TYPE_INT	smallint
ROTATION_TYPE	tinyint
COMMENTS_FOR_LOG	tinyint
ENFORCE_DISTRIBUTION	tinyint
AGREED_IMPRESSIONS	int
HAS_PRODUCT_EXCLUSIVITY	bit
STATION_INT	smallint
CHANNEL_PLACEMENT_TYPE	tinyint
INVOICE_CHANNEL_OVERRIDE	varchar(10)
INVENTORY_CODE_INT	int
TARGET_CHANNEL_PERCENT	tinyint
ORDER_INT	int
IS_INTERNET_LINE	bit
UNIT_CODE_INT	smallint
SUPPRESS_LINE_IMP	tinyint
SUPPRESS_LINE_DELIVERED_IMP	tinyint
SELLING_ELEMENT_INT	smallint
IS_DELETED	int
IS_SOFT_DELETED	int
CREATE_DATE	smalldatetime
CREATE_BY	varchar(250)
UPDATE_DATE	datetime
UPDATE_BY	varchar(250)
UPDATE_COUNT	smallint
INTERNAL_COMMENTS	ntext
EXTERNAL_COMMENTS	ntext
INSTRUCTION_CLASS_INT	smallint
MARKET_RATE	money
EXCLUDE_FROM_COMMISSION	bit
EXCLUDE_FROM_TAX1	bit
EXCLUDE_FROM_TAX2	bit
ADDRESSABLE_INT	smallint
Version (Note: This is sent as a separate dataset.)	bigint

WOXD_ORDERS

Returns a list of Orders

Input Parameters

Example Request:

  {
    "RequestType":"[VENDORNAME].WOXD_ORDERS",
    "DataExportFormat":"JSON",
    "TargetUrl":"https://yoursite.com/ProcessData",
    "ChunkRowsCount":"50",
    "GenerateInValidFormat":"true",
    "Parameters":
    [
      {
        "Name":"@PriorVersion",
        "DbType":"int",
        "Value":"100"
      },
      {
        "Name":"@Version",
        "DbType":"int",
        "Value":"100"
      }
    ]
  }

Example Error:

  {
    "Message": "There is no DDL's with request type - [VENDOR_NAME].WOXD_ORDERS for Agreement [VENDOR_NAME]/PM_v110"
  }

Field Name	Data Type
@PriorVersion	int
@Version	int

Output Fields

Field Name	Data Type
ORDER_ID	uniqueidentifier
STATION_ID	uniqueidentifier
ADVERTISER_ID	uniqueidentifier
AGENCY_ID	uniqueidentifier
AGENCY_BUYING_CONTACT_ID	uniqueidentifier
AGENCY_BILLING_CONTACT_ID	uniqueidentifier
AGENCY_COMMISSION	float
PRIMARY_ACCOUNT_EXEC_ID	uniqueidentifier
SALES_OFFICE_ID	uniqueidentifier
SALES_REGION_INT	smallint
REVENUE_CODE_INT	smallint
REVENUE_CODE2_INT	smallint
REVENUE_CODE3_INT	smallint
DEMO_CODE_INT	smallint
SHARE_OF_ORDER	tinyint
AVAIL_REQUEST_ID	uniqueidentifier
ORDER_NUMBER	varchar(50)
REVISION_NUMBER	int
CLIENT_TRACKING_NUMBER	varchar(50)
ALT_ORDER_NUMBER	varchar(50)
PRODUCT_DESCRIPTION	varchar(50)
PRIORITY_CODE_INT	smallint
FLIGHT_START_DATE	smalldatetime
FLIGHT_END_DATE	smalldatetime
HIATUS_PERIODS	varchar(1000)
CANCEL_DATE	smalldatetime
ORDER_SEPARATION	int
ORDER_IS_COOP	tinyint
ORDER_IS_CASH	bit
SUPPRESS_LINE_AMOUNTS	bit
BILLING_CYCLE_INT	smallint
BILLING_CALENDAR_INT	smallint
TOTAL_ORDER_AMOUNT	money
TOTAL_ORDER_UNITS	int
PRINT_FULL_ORDER	bit
LAST_PRINT_DATE	datetime
IS_PENDING	bit
PENDING_LINK_ORDER_ID	uniqueidentifier
SPECIAL_HANDLING	varchar(250)
WEEK_DEFINITION	tinyint
PRODUCT_CODE_DISPLAY	varchar(50)
MATERIAL_INSTRUCTION_SET_BUNDLE_ID	uniqueidentifier
PRIOR_MATERIAL_INSTRUCTION_SET_BUNDLE_ID	uniqueidentifier
FIRST_DATE_EFFECTED	smalldatetime
DEFAULT_CHANNEL_INT	smallint
CLIENT_CODE	varchar(50)
AGENCY_PRODUCT_CODE	varchar(50)
INVOICE_CODE	varchar(50)
INVOICE_TIME_OFFSET	int
IS_COMBO_HEADER	bit
COMBO_HEADER_ORDER_ID	uniqueidentifier
NEW_BUSINESS_DATE	smalldatetime
EI_EXPORT_TYPE	tinyint
TAX1_RATE	float
TAX2_RATE	float
TAX1_APPLIED_TO	tinyint
TAX2_APPLIED_TO	tinyint
TAX1_LABEL	varchar(25)
TAX2_LABEL	varchar(25)
LOCKDOWN_MODE	tinyint
BILLING_ADDRESS_INT	int
REMIT_ADDRESS_INT	int
CONTRACT_ADDRESS_INT	int
ORDER_TYPE_INT	smallint
BILLING_GROUP_INT	smallint
ELIGIBLE_FOR_FILL	tinyint
BUYCODE_INT	smallint
TOTAL_AGREED_GRP	float
INVOICE_LOCK	bit
CAMPAIGN_INT	int
RATE_CARD_ID	uniqueidentifier
IS_CASH_IN_ADVANCE	bit
BUYER_VERSION_NUMBER	int
HAS_PRODUCT_EXCLUSIVITY	bit
AGENCY_PACKAGE_CODE	varchar(3)
CENTRAL_ORDER	bit
TOTAL_AGREED_IMPRESSIONS	bigint
MAX_USED_GROUP_INT	smallint
STATION_ARRAY	binary(256)
SUPPRESS_CREDITS	bit
EXTERNAL_ID	varchar(50)
ORDER_INT	int
PRINT_RATINGS_OR_IMP	tinyint
ORDER_WORKFLOW_STATE_RULE_INT	int
SUPPRESS_IMPRESSIONS	bit
SUPPRESS_CLICKS	bit
POST_IMPRESSIONS_FROM	bit
PRINT_PRIORITY_ON_CONTRACT	bit
UNIT_CODE_INT	smallint
INTERNET_TRAFFICKER_INT	int
SUPPRESS_DELIVERED_IMP	bit
AGENCY_PRODUCT_CODE_2	varchar(50)
TOTAL_RATE_CARD_RATE	money
SUPPRESS_MAKEGOOD_INFO	bit
SUPPRESS_DIGITAL_RATETYPE	bit
DEFAULT_ADVERTISER_BRAND_INT	smallint
IS_DELETED	int
IS_SOFT_DELETED	int
CREATE_DATE	smalldatetime
CREATE_BY	varchar(250)
UPDATE_DATE	datetime
UPDATE_BY	varchar(250)
UPDATE_COUNT	int