NAV

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