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 |