NAV

WOMD.AccountExec

Returns a list of Account Executives

Input Parameters

Example Request:

  {
    "RequestType":"WOMD.AccountExec",
    "DataExportFormat":"JSON",
    "TargetUrl":"https://yoursite.com/ProcessData",
    "ChunkRowsCount":"50",
    "GenerateInValidFormat":"true",
    "Parameters":
    [
      {
        "Name":"@LASTSUCCESSFULRUN",
        "DbType":"smalldatetime",       
        "Value":"2018-12-31 12:00:00"
      }
    ]
  }

Example Error:

  {
    "Message": "There is no DDL's with request type - WOMD.AE for Agreement YOU/PM_v110"
  }
Field Name Description Data Type Supported Values
@LASTSUCCESSFULRUN Last date/time that data was requested smalldatetime Valid datetime (e.g., 2018-12-31 12:00:00)

Output Fields

Field Name Description Data Type Supported Values
ACCOUNT_EXEC_ID Account Exec ID uniqueidentifier GUID
FIRST_NAME Account Exec’s first name varchar(50) Any string value
LAST_NAME Account Exec’s last name varchar(50) Any string value
PRINT_ABBREVIATION Account Exec’s code in WO Traffic varchar(5) Any string value
ROW_STATE Specifies if Account Exec has been deleted or not int 0, 1, or 2. 0 or 1 is active record. 2 is a soft deleted row.
CREATE_DATE Create Date of record smalldatetime Valid date/time value
UPDATE_DATE Update Date of record smalldatetime Valid date/time value
AE_GROUP_INT Foreign Key of the Account Exec group int Join to WOMD.Lookups
USERNAME Account Exec’s WideOrbit login varchar(50) Any string value

WOMD.Addresses

Returns a list of Addresses

Input Parameters

Example Request:

  {
    "RequestType":"WOMD.Addresses",
    "DataExportFormat":"JSON",
    "TargetUrl":"https://yoursite.com/ProcessData",
    "ChunkRowsCount":"50",
    "GenerateInValidFormat":"true",
    "Parameters":
    [
      {
        "Name":"@LASTSUCCESSFULRUN",
        "DbType":"smalldatetime",       
        "Value":"2018-12-31 12:00:00"
      }
    ]
  }

Example Error:

  {
    "Message": "There is no DDL's with request type - WOMD.AE for Agreement YOU/PM_v110"
  }
Field Name Description Data Type Supported Values
@LASTSUCCESSFULRUN Last date/time that data was requested smalldatetime Valid datetime (e.g., 2018-12-31 12:00:00)

Output Fields

Field Name Description Data Type Supported Values
ADDRESS_ID Address ID uniqueidentifier GUID
ADDRESS_INT Address ID, integer value int Any integer value
ADDRESS_CITY Address City varchar(100) Any string value
ADDRESS_COUNTRY Address Country varchar(100) Any string value
ADDRESS_LINE1 Address Line 1 varchar(100) Any string value
ADDRESS_LINE2 Address Line 2 varchar(100) Any string value
ADDRESS_LINE3 Address Line 3 varchar(100) Any string value
ADDRESS_NAME Address Name varchar(100) Any string value
ADDRESS_STATE Address State varchar(25) Any string value
ADDRESS_ZIPCODE Address Zip Code varchar(50) Any string value
ROW_STATE Specifies if Address has been deleted or not int 0, 1, or 2.
CREATE_DATE Create Date of Address record smalldatetime Valid datetime (e.g., 2018-12-31 12:00:00)
CREATE_BY Username of user who created Address varchar(250) Any string value
UPDATE_DATE Last Update Date of Address smalldatetime Valid datetime (e.g., 2018-12-31 12:00:00)
UPDATE_BY Username of user who updated Address varchar(250) Any string value
UPDATE_COUNT Number of times Address has been Updated int Any integer value

WOMD.AdvertiserBrands

Returns Advertiser Brands

Input Parameters

Example Request:

  {
    "RequestType":"WOMD.AdvertiserBrands",
    "DataExportFormat":"JSON",
    "TargetUrl":"https://yoursite.com/ProcessData",
    "ChunkRowsCount":"50",
    "GenerateInValidFormat":"true",
    "Parameters":
    [
      {
        "Name":"@LASTSUCCESSFULRUN",
        "DbType":"smalldatetime",       
        "Value":"2018-12-31 12:00:00"
      }
    ]
  }

Example Error:

  {
    "Message": "There is no DDL's with request type - WOMD.AE for Agreement YOU/PM_v110"
  }
Field Name Description Data Type Supported Values
@LASTSUCCESSFULRUN Last date/time that data was requested smalldatetime Valid datetime (e.g., 2018-12-31 12:00:00)

Output Fields

Field Name Description Data Type Supported Values
ADVERTISER_BRAND_ID Advertiser Brand ID uniqueidentifier GUID
BRAND_NAME Brand Name varchar(50) Any string value
BRAND_DESCR Brand Description varchar(250) Any string value
BRAND_SEPARATION Brand Separation (in milliseconds) int Any integer value
ROW_STATE Specifies if EC name has been deleted or not int 0, 1, or 2.
0 or 1 is active record.
2 is a soft deleted row.
CREATE_DATE Create Date of Advertiser Brand record smalldatetime Valid datetime (e.g., 2018-12-31 12:00:00)
UPDATE_DATE Last Update Date of Advertiser Brand smalldatetime Valid datetime (e.g., 2018-12-31 12:00:00)

WOMD.AdvECNames

Returns advertiser’s EC Name list

Input Parameters

Example Request:

  {
    "RequestType":"WOMD.AdvECNames",
    "DataExportFormat":"JSON",
    "TargetUrl":"https://yoursite.com/ProcessData",
    "ChunkRowsCount":"50",
    "GenerateInValidFormat":"true",
    "Parameters":
    [
      {
        "Name":"@LASTSUCCESSFULRUN",
        "DbType":"smalldatetime",       
        "Value":"2018-12-31 12:00:00"
      }
    ]
  }

Example Error:

  {
    "Message": "There is no DDL's with request type - WOMD.AE for Agreement YOU/PM_v110"
  }
Field Name Description Data Type Supported Values
@LASTSUCCESSFULRUN Last date/time that data was requested smalldatetime Valid datetime (e.g., 2018-12-31 12:00:00)

Output Fields

Field Name Description Data Type Supported Values
ADVERTISER_ID Advertiser ID uniqueidentifier GUID
ECNAME Advertiser’s EC Name varchar(250) Any string value
SOURCE_SYSTEM Source system where EC Name is used varchar(250) Any string value
ROW_STATE Specifies if EC name has been deleted or not int 0, 1, or 2.
0 or 1 is active record.
2 is a soft deleted row.
UPDATE_DATE Update Date of record smalldatetime Valid date/time value

WOMD.Advertisers

Returns list of advertisers

Input Parameters

Example Request:

  {
    "RequestType":"WOMD.Advertisers",
    "DataExportFormat":"JSON",
    "TargetUrl":"https://yoursite.com/ProcessData",
    "ChunkRowsCount":"50",
    "GenerateInValidFormat":"true",
    "Parameters":
    [
      {
        "Name":"@LASTSUCCESSFULRUN",
        "DbType":"smalldatetime",       
        "Value":"2018-12-31 12:00:00"
      }
    ]
  }

Example Error:

  {
    "Message": "There is no DDL's with request type - WOMD.AE for Agreement YOU/PM_v110"
  }
Field Name Description Data Type Supported Values
@LASTSUCCESSFULRUN Last date/time that data was requested smalldatetime Valid datetime (e.g., 2018-12-31 12:00:00)

Output Fields

Field Name Description Data Type Supported Values
ADVERTISER_ID Advertiser ID uniqueidentifier GUID
ADVERTISER_NAME Advertiser’s Name varchar(50) Any string value
NEW_BUSINESS_EXPIRE Any revenue prior to this date is new business. smalldatetime Valid datetime (e.g., 2018-12-31 12:00:00)
ADVERTISER_REPORTING_NAME Advertiser’s Reporting Name varchar(100) Any string value
TCODE Advertiser’s external ID varchar(50) Any string value
REVENUE_PRODUCT_CODE_ID Foreign key of the Product Code used for reporting revenue uniqueidentifier GUID, Join to WOMD.ProductCodes
ADVERTISER_TYPE_INT Foreign key of the Advertiser Type (optional) int Join to WOMD.Lookups
ADDRESS_LINE1 Advertiser’s address line 1 varchar(100) Any string value
ADDRESS_LINE2 Advertiser’s address line 2 varchar(100) Any string value
ADDRESS_LINE3 Advertiser’s address line 3 varchar(100) Any string value
ADDRESS_CITY Advertiser’s address city varchar(100) Any string value
ADDRESS_STATE Advertiser’s address state varchar(25) Any string value
ADDRESS_ZIPCODE Advertiser’s address zip code varchar(50) Any string value
ADDRESS_COUNTRY Advertiser’s country varchar(100) Any string value
ROW_STATE Specifies if Advertiser has been deleted or not int 0, 1, or 2.
0 or 1 is active record.
2 is a soft deleted row.
CREATE_DATE Advertiser’s Create Date smalldatetime Valid datetime (e.g., 2018-12-31 12:00:00)
UPDATE_DATE Advertiser’s last Update Date smalldatetime Valid datetime (e.g., 2018-12-31 12:00:00)

WOMD.Agencies

Returns list of agencies

Input Parameters

Example Request:

  {
    "RequestType":"WOMD.Agencies",
    "DataExportFormat":"JSON",
    "TargetUrl":"https://yoursite.com/ProcessData",
    "ChunkRowsCount":"50",
    "GenerateInValidFormat":"true",
    "Parameters":
    [
      {
        "Name":"@LASTSUCCESSFULRUN",
        "DbType":"smalldatetime",       
        "Value":"2018-12-31 12:00:00"
      }
    ]
  }

Example Error:

  {
    "Message": "There is no DDL's with request type - WOMD.AE for Agreement YOU/PM_v110"
  }
Field Name Description Data Type Supported Values
@LASTSUCCESSFULRUN Last date/time that data was requested smalldatetime Valid datetime (e.g., 2018-12-31 12:00:00)

Output Fields

Field Name Description Data Type Supported Values
AGENCY_ID Agency ID uniqueidentifier GUID
AGENCY_NAME Agency’s Name varchar(50) Any string value
TCODE Agency’s external ID varchar(50) Any string value
ADDRESS_ZIPCODE Agency’s address zip code varchar(50) Any string value
ADDRESS_LINE1 Agency’s address line 1 varchar(100) Any string value
ADDRESS_LINE2 Agency’s address line 2 varchar(100) Any string value
ADDRESS_CITY Agency’s address city varchar(100) Any string value
ADDRESS_STATE Agency’s address state varchar(25) Any string value
MAIN_PHONE_NUMBER Agency’s main phone number varchar(50) Any string value
MAIN_FAX_NUMBER Agency’s main fax number varchar(50) Any string value
AGENCY_REPORTING_NAME Agency’s Reporting Name varchar(100) Any string value
AGENCY_TYPE_INT Foreign key of the Agency Type (optional) int Join to WOMD.Lookups
ORIGINAL_AGENCY_NAME Agency’s Name varchar(50) Any string value
DEFAULT_CASH_COMMISSION Default Commission percentage for cash orders float Floating point numeric
ROW_STATE Specifies if Agency has been deleted or not int 0, 1, or 2.
0 or 1 is active record.
2 is a soft deleted row.
CREATE_DATE Agency’s Create Date smalldatetime Valid datetime (e.g., 2018-12-31 12:00:00)
UPDATE_DATE Agency’s last Update Date smalldatetime Valid datetime (e.g., 2018-12-31 12:00:00)

WOMD.AgencyAdvertiser

Returns list of agencies and the advertisers they represent

Input Parameters

Example Request:

  {
    "RequestType":"WOMD.AgencyAdvertiser",
    "DataExportFormat":"JSON",
    "TargetUrl":"https://yoursite.com/ProcessData",
    "ChunkRowsCount":"50",
    "GenerateInValidFormat":"true",
    "Parameters":
    [
      {
        "Name":"@LASTSUCCESSFULRUN",
        "DbType":"smalldatetime",       
        "Value":"2018-12-31 12:00:00"
      }
    ]
  }

Example Error:

  {
    "Message": "There is no DDL's with request type - WOMD.AE for Agreement YOU/PM_v110"
  }
Field Name Description Data Type Supported Values
@LASTSUCCESSFULRUN Last date/time that data was requested smalldatetime Valid datetime (e.g., 2018-12-31 12:00:00)

Output Fields

Field Name Description Data Type Supported Values
ADVERTISER_AGENCY_ID Agency/Advertiser relationship ID uniqueidentifier GUID
ADVERTISER_ID Foreign key of Advertiser ID uniqueidentifier GUID, Join to WOMD.Advertisers
AGENCY_ID Foreign key of Agency ID uniqueidentifier GUID, Join to WOMD.Agencies
ROW_STATE Specifies if Agency has been deleted or not int 0, 1, or 2.
0 or 1 is active record.
2 is a soft deleted row.
CREATE_DATE Agency/Advertiser relationship Create Date smalldatetime Valid datetime (e.g., 2018-12-31 12:00:00)
UPDATE_DATE Agency/Advertiser relationship last Update Date smalldatetime Valid datetime (e.g., 2018-12-31 12:00:00)
BILLING_ADDRESS_INT Foreign key for Billing Address int Join to WO_ADDRESSES
REMIT_ADDRESS_INT Foreign key for Remit Address int Join to WO_ADDRESSES
CONTRACT_ADDRESS_INT Foreign key for Contract Address int Join to WO_ADDRESSES
WEB_BILLING_ADDRESS_INT Foreign key for Web Billing Address int Join to WO_ADDRESSES

WOMD.Calendars

Returns start and end dates of Broadcast calendar, Gregorian calendar, and custom calendars

Input Parameters

Example Request:

  {
    "RequestType":"WOMD.Calendars",
    "DataExportFormat":"JSON",
    "TargetUrl":"https://yoursite.com/ProcessData",
    "ChunkRowsCount":"50",
    "GenerateInValidFormat":"true",
    "Parameters":
    [
      {
        "Name":"@LASTSUCCESSFULRUN",
        "DbType":"smalldatetime",       
        "Value":"2018-12-31 12:00:00"
      }
    ]
  }

Example Error:

  {
    "Message": "There is no DDL's with request type - WOMD.AE for Agreement YOU/PM_v110"
  }
Field Name Description Data Type Supported Values
@LASTSUCCESSFULRUN Last date/time that data was requested smalldatetime Valid datetime (e.g., 2018-12-31 12:00:00)

Output Fields

Field Name Description Data Type Supported Values
CALENDAR_MONTH_ID Calendar Month ID uniqueidentifier GUID
CALENDAR_INT Foreign key for Calendar Type (e.g., Broadcast, Calendar) int Join to WOMD.Lookups
MONTH_NUMBER Month number (e.g., 1 = January, 2 = February, etc.) int Integer value betweem 1 amd 12
QUARTER_NUMBER Quarter number int Integer value betweem 1 amd 4
YEAR_NUMBER Year number int Any integer value
DISPLAY_NAME Month name and year number varchar(50) Any string value
MONTH_START_DATE Month start date smalldatetime Valid datetime (e.g., 2018-12-31 12:00:00)
MONTH_END_DATE Month end date smalldatetime Valid datetime (e.g., 2018-12-31 12:00:00)
ROW_STATE Specifies if Calendar Month has been deleted or not int 0, 1, or 2.
0 or 1 is active record.
2 is a soft deleted row.
CREATE_DATE Calendar Month Create Date smalldatetime Valid datetime (e.g., 2018-12-31 12:00:00)
UPDATE_DATE Calendar Month last Update Date smalldatetime Valid datetime (e.g., 2018-12-31 12:00:00)

WOMD.Channels

Returns list of Channels

Input Parameters

Example Request:

  {
    "RequestType":"WOMD.Channels",
    "DataExportFormat":"JSON",
    "TargetUrl":"https://yoursite.com/ProcessData",
    "ChunkRowsCount":"50",
    "GenerateInValidFormat":"true",
    "Parameters": []
  }

Example Error:

  {
    "Message": "There is no DDL's with request type - WOMD.AE for Agreement YOU/PM_v110"
  }

None

Output Fields

Field Name Description Data Type Supported Values
CHANNEL_ID Channel ID uniqueidentifier GUID
CHANNEL_INT Channel ID, integer value int Any integer value
STATION_ID Foreign key of the Station that Channel belongs to uniqueidentifier GUID, Join to WOMD.Stations
CHANNEL_NAME Channel Name varchar(5) Any string value
CHANNEL_REVENUE_WEIGHT Revenue weight of channel int Any integer value
ACTIVE_LOG_LENGTH How far in the future new logs are created int Any integer value
ROW_STATE Specifies if Calendar Month has been deleted or not int 0, 1, or 2.
0 or 1 is active record.
2 is a soft deleted row.
FIRST_LOG_DATE First log date of Channel smalldatetime Valid datetime (e.g., 2018-12-31 12:00:00)
LAST_LOG_DATE Last log date of Channel smalldatetime Valid datetime (e.g., 2018-12-31 12:00:00)
FIRST_FINALIZED_LOG_DATE First finalized log date of Channel smalldatetime Valid datetime (e.g., 2018-12-31 12:00:00)
LAST_FINALIZED_LOG_DATE Last finalized log date of Channel smalldatetime Valid datetime (e.g., 2018-12-31 12:00:00)
UPDATE_DATE Channel last Update Date smalldatetime Valid datetime (e.g., 2018-12-31 12:00:00)

WOMD.InventoryCodes

Returns list of Inventory Codes

Input Parameters

Example Request:

  {
    "RequestType":"WOMD.InventoryCodes",
    "DataExportFormat":"JSON",
    "TargetUrl":"https://yoursite.com/ProcessData",
    "ChunkRowsCount":"50",
    "GenerateInValidFormat":"true",
    "Parameters":
    [
      {
        "Name":"@LASTSUCCESSFULRUN",
        "DbType":"smalldatetime",       
        "Value":"2018-12-31 12:00:00"
      }
    ]
  }

Example Error:

  {
    "Message": "There is no DDL's with request type - WOMD.AE for Agreement YOU/PM_v110"
  }
Field Name Description Data Type Supported Values
@LASTSUCCESSFULRUN Last date/time that data was requested smalldatetime Valid datetime (e.g., 2018-12-31 12:00:00)

Output Fields

Field Name Description Data Type Supported Values
INVENTORY_CODE_ID Inventory Code ID uniqueidentifier GUID
INVENTORY_CODE_NAME Inventory Code Name varchar(50) Any string value
INVENTORY_CODE_INT Inventory Code ID, integer value int Any integer value
INVENTORY_CODE_EXTERNAL_ID External ID of the Inventory Code varchar(50) Any string value
PARENT_INVENTORY_CODE_INT Integer Foreign key for the Parent Inventory Code int Join to WOMD.InventoryCodes
PARENT_INVENTORY_CODE_ID GUID Foreign key for the Parent Inventory Code uniqueidentifier GUID, Join to WOMD.InventoryCodes
DAYPART_INT Foreign key for Inventory Code’s Daypart int Join to WOMD.Lookups
IS_SELLGROUP Flag indicating if the Inventory Code is a Sellgroup int Any integer value
REPORTING_NAME Inventory Code’s Reporting name varchar(100) Any string value
SELLING_NAME_INT Foreign key for Inventory Code’s Selling Name int Join to WOMD.Lookups
ROW_STATE Specifies if Inventory Code has been deleted or not int 0, 1, or 2.
0 or 1 is active record.
2 is a soft deleted row.
CREATE_DATE Create Date of Inventory Code smalldatetime Valid datetime (e.g., 2018-12-31 12:00:00)
CREATE_BY Username of user who created Inventory Code varchar(250) Any string value
UPDATE_DATE Last Update Date of Inventory Code smalldatetime Valid datetime (e.g., 2018-12-31 12:00:00)
UPDATE_BY Username of user who last updated Inventory Code varchar(250) Any string value

WOMD.Lookups

Returns list of Lookup values used in WO Traffic

Input Parameters

Example Request:

  {
    "RequestType":"WOMD.Lookups",
    "DataExportFormat":"JSON",
    "TargetUrl":"https://yoursite.com/ProcessData",
    "ChunkRowsCount":"50",
    "GenerateInValidFormat":"true",
    "Parameters":[]
  }

Example Error:

  {
    "Message": "There is no DDL's with request type - WOMD.AE for Agreement YOU/PM_v110"
  }

None

Output Fields

Field Name Description Data Type Supported Values
LOOKUP_INT Lookup ID, integer value int Any integer value
LOOKUP_GUID Lookup ID uniqueidentifier GUID
LOOKUP_TYPE Type of Lookup (e.g., Advertiser Type, Agency Type, etc.) varchar(250) Any string value
LOOKUP_VALUE Lookup Value varchar(250) Any string value
LOOKUP_DISPLAY Lookup Display, what shows in WO Traffic varchar(250) Any string value
LOOKUP_DESCR Lookup Description varchar(250) Any string value
LOOKUP_SORT Lookup Sort varchar(50) Any string value
ROW_STATE Specifies if Lookup has been deleted or not int 0, 1, or 2.
0 or 1 is active record.
2 is a soft deleted row.
UPDATE_DATE Last Update Date of Lookup smalldatetime Valid datetime (e.g., 2018-12-31 12:00:00)

WOMD.Materials

Returns list of Materials

Input Parameters

Example Request:

  {
    "RequestType":"WOMD.Materials",
    "DataExportFormat":"JSON",
    "TargetUrl":"https://yoursite.com/ProcessData",
    "ChunkRowsCount":"50",
    "GenerateInValidFormat":"true",
    "Parameters":
    [
      {
        "Name":"@LASTSUCCESSFULRUN",
        "DbType":"smalldatetime",       
        "Value":"2018-12-31 12:00:00"
      }
    ]
  }

Example Error:

  {
    "Message": "There is no DDL's with request type - WOMD.AE for Agreement YOU/PM_v110"
  }
Field Name Description Data Type Supported Values
@LASTSUCCESSFULRUN Last date/time that data was requested smalldatetime Valid datetime (e.g., 2018-12-31 12:00:00)

Output Fields

Field Name Description Data Type Supported Values
MATERIAL_ID Material ID uniqueidentifier GUID
MATERIAL_NAME Material Name varchar(50) Any string value
MATERIAL_TITLE Material Title uniqueidentifier GUID
MATERIAL_LENGTH Material Length (in milliseconds) int Any integer value
ADVERTISER_ID Foreign key of Material’s Advertiser uniqueidentifier GUID, Join to WOMD.Advertisers
PRODUCT_DESCR Material’s Product Description varchar(50) Any string value
COOP_CODE Material Co-op Code varchar(50) Any string value
ISCI_CODE Material ISCI Code varchar(50) Any string value
HOUSE_NAME Material House Name varchar(50) Any string value
FCC_TYPE_INT Foreign key for Material Content Type int Join to WOMD.Lookups
FCC_SOURCE_INT Foreign Key for Material Content Source int Join to WOMD.Lookups
DISTRIBUTION_SOURCE Material Distribution Source varchar(50) Any string value
USEABLE_FOR_FILLER Flag indicating if Material can be used for Filler int Any integer value
ROW_STATE Specifies if the Material has been deleted or not int 0, 1, or 2.
0 or 1 is active record.
2 is a soft deleted row.
CREATE_DATE Create Date of Material smalldatetime Valid datetime (e.g., 2018-12-31 12:00:00)
UPDATE_DATE Last Update Date of Material smalldatetime Valid datetime (e.g., 2018-12-31 12:00:00)
WO_FIELD1 Material Field 1 varchar(50) Any string value
WO_FIELD2 Material Field 2 varchar(50) Any string value
WO_FIELD3 Material Field 3 varchar(50) Any string value
WO_FIELD4 Material Field 4 varchar(50) Any string value
WO_FIELD5 Material Field 5 varchar(50) Any string value
MATERIAL_INT Integer ID of the Material int Any integer value
MATERIAL_GROUP_NAME Material Group Name varchar(10) Any string value
MATERIAL_GROUP_DESCRIPTION Material Group Description varchar(50) Any string value

WOMD.Orders

Returns list of Orders

Input Parameters

Example Request:

  {
    "RequestType":"WOMD.Orders",
    "DataExportFormat":"JSON",
    "TargetUrl":"https://yoursite.com/ProcessData",
    "ChunkRowsCount":"50",
    "GenerateInValidFormat":"true",
    "Parameters":
    [
      {
        "Name":"@LASTSUCCESSFULRUN",
        "DbType":"smalldatetime",       
        "Value":"2018-12-31 12:00:00"
      }
    ]
  }

Example Error:

  {
    "Message": "There is no DDL's with request type - WOMD.AE for Agreement YOU/PM_v110"
  }
Field Name Description Data Type Supported Values
@LASTSUCCESSFULRUN Last date/time that data was requested smalldatetime Valid datetime (e.g., 2018-12-31 12:00:00)

Output Fields

Field Name Description Data Type Supported Values
ORDER_ID Order ID uniqueidentifier GUID
ORDER_NUMBER Order Number varchar(50) Any string value
ADVERTISER_ID Foreign Key of Order’s Advertiser uniqueidentifier GUID, Join to WOMD.Advertisers
AGENCY_ID Foreign Key of Order’s Agency uniqueidentifier GUID, Join to WOMD.Agencies
CANCEL_DATE Date order was cancel (only if cancelled) smalldatetime Valid datetime (e.g., 2018-12-31 12:00:00)
ORDER_IS_COOP Flag indicating if Order is a Co-op Order tinyint Small integer value
ORDER_IS_CASH Flag indicating if Order is a Cash Order bit 0 or 1
IS_CASH_IN_ADVANCE Flag indicating if Order is Cash In Advance bit 0 or 1
CENTRAL_ORDER Flag indicating if Order is create via WO Central bit 0 or 1
FLIGHT_START_DATE Start Date of the Order smalldatetime Valid datetime (e.g., 2018-12-31 12:00:00)
FLIGHT_END_DATE End Date of the Order smalldatetime Valid datetime (e.g., 2018-12-31 12:00:00)
SALES_REGION_INT Foreign Key of Order’s Sales Region int Join to WOMD.Lookups
SALES_OFFICE_ID Foreign Key of Order’s Sales Office uniqueidentifier Join to WOMD.SalesOffices
BILLING_GROUP_INT Foreign Key of Order’s Billing Group int Join to WOMD.BillingGroup
DEMO_CODE_INT Foreign Key of Order’s Demographic int Join to WOMD.Lookups
SHARE_OF_ORDER Share of the advertiser’s buy tinyint Any integer value
ROW_STATE Specifies if Order has been deleted or not int 0, 1, or 2.
0 or 1 is active record.
2 is a soft deleted row.
CREATE_DATE Create Date of Order smalldatetime Valid datetime (e.g., 2018-12-31 12:00:00)
UPDATE_DATE Last Update Date of Order smalldatetime Valid datetime (e.g., 2018-12-31 12:00:00)
ORDER_INT Order ID, integer value int Any integer value
FIRST_APPROVAL_DATE Order’s First Approval Date smalldatetime Valid datetime (e.g., 2018-12-31 12:00:00)
ORDER_TYPE_INT Foreign Key of Order Type int Join to WOMD.Lookups
AGENCY_COMMISSION Order’s Agency Commission float Floating point numeric
UNITCODE_INT Foreign Key of Order’s Unit Code int Join to WOMD.UnitCodes
NEW_BUSINESS_DATE New Business Date smalldatetime Valid datetime (e.g., 2018-12-31 12:00:00)
HIATUS_PERIODS Hiatus Periods varchar(1000) Any string value
HAS_MATERIAL_INSTRUCTION Flag indicating if Order has Material Instruction bit 0 or 1
CREATE_BY Username who Created Order varchar(250) Any string value
BILLING_CALENDAR_INT Foreign Key of Order’s Billing Calendar int Join to WOMD.Lookups
PRODUCT_CODE_ID Foreign Key of Order’s Product Code uniqueidentifier GUID, Join to WOMD.ProductCodes
EXTERNAL_ID Order’s External ID varchar(50) Any string value
PRODUCT_DESCRIPTION Order’s Product Description varchar(50) Any string value
ALT_ORDER_NUMBER Order’s Alternate Order Number varchar(50) Any string value
DEFAULT_CHANNEL_INT Foreign Key for Order’s Channel int Join to WOMD.Channels
CLIENT_TRACKING_NUMBER Order’s Client Tracking Number varchar(50) Any string value
PRIMARY_ACCOUNT_EXEC_ID Foreign Key for Order’s Primary Account Exec uniqueidentifier GUID, Join to WOMD.AccountExec
INTERNET_TRAFFICKER_INT Foreign Key for Digital Order’s Trafficker int Join to WOMD.Lookups

WOMD.OrderAccountExec

Returns list of Order’s Account Execs

Input Parameters

Example Request:

  {
    "RequestType":"WOMD.OrderAccountExec",
    "DataExportFormat":"JSON",
    "TargetUrl":"https://yoursite.com/ProcessData",
    "ChunkRowsCount":"50",
    "GenerateInValidFormat":"true",
    "Parameters":
    [
      {
        "Name":"@LASTSUCCESSFULRUN",
        "DbType":"smalldatetime",       
        "Value":"2018-12-31 12:00:00"
      }
    ]
  }

Example Error:

  {
    "Message": "There is no DDL's with request type - WOMD.AE for Agreement YOU/PM_v110"
  }
Field Name Description Data Type Supported Values
@LASTSUCCESSFULRUN Last date/time that data was requested smalldatetime Valid datetime (e.g., 2018-12-31 12:00:00)

Output Fields

Field Name Description Data Type Supported Values
ACCOUNT_EXECUTIVE_ID Foreign Key for Account Exec uniqueidentifier GUID, Join to WOMD.AccountExec
ORDER_INT Foreign Key for Order int Join to WOMD.Order
START_DATE Start date of Account Exec’s commission period smalldatetime Valid datetime (e.g., 2018-12-31 12:00:00)
END_DATE End date of Account Exec’s commission period smalldatetime Valid datetime (e.g., 2018-12-31 12:00:00)
SALES_OFFICE_ID Foreign Key for Account Exec’s Sales Office uniqueidentifier GUID, Join to WOMD.SalesOffices
SALES_REGION_INT Foreign Key for Account Exec’s Sales Region int Join to WOMD.Lookups
COMMISSION_PERCENT Account Exec’s commission rate float Floating point numeric
IS_PRIMARY_AE Flag indicating if Account Exec is the Primary bit 0 or 1
CREATE_DATE Create Date of Order Account Exec record smalldatetime Valid datetime (e.g., 2018-12-31 12:00:00)
UPDATE_DATE Last Update Date of Order Account Exec record smalldatetime Valid datetime (e.g., 2018-12-31 12:00:00)

WOMD.OrderBillplanException

Returns list of Order bill plans which are different from order header

Input Parameters

Example Request:

  {
    "RequestType":"WOMD.OrderBillplanException",
    "DataExportFormat":"JSON",
    "TargetUrl":"https://yoursite.com/ProcessData",
    "ChunkRowsCount":"50",
    "GenerateInValidFormat":"true",
    "Parameters": []
  }

Example Error:

  {
    "Message": "There is no DDL's with request type - WOMD.AE for Agreement YOU/PM_v110"
  }

None

Output Fields

Field Name Description Data Type Supported Values
ORDER_BILL_PLAN_ID Order Bill Plan ID uniqueidentifier GUID
ORDER_ID Foreign Key for Bill Plan’s Order uniqueidentifier GUID, Join to WOMD.Order
ORDER_INT Foreign Key for Bill Plan’s Order, integer value int Join to WOMD.Order
SEQ_NUM Order Bill Plan Number int Any integer value
UNIT_START_DATE Start Date of Bill Plan smalldatetime Valid datetime (e.g., 2018-12-31 12:00:00)
UNIT_END_DATE End Date of Bill Plan smalldatetime Valid datetime (e.g., 2018-12-31 12:00:00)
NUMBER_OF_UNITS Number of Units in Bill Plan int Any integer value
INTERNAL_AMOUNT Internal Amount of Bill Plan money Money value
EXTERNAL_AMOUNT External Amount of Bill Plan money Money value
IS_USER_OVERRIDE User altered Bill Plan bit 0 or 1
INVOICE_REVISION Invoice Revision number smallint Any small integer value
ROW_STATE Specifies if Bill Plan has been deleted or not int 0, 1, or 2. 0 or 1 is active record. 2 is a soft deleted row.
CREATE_DATE Create Date of Order Bill Plan record smalldatetime Valid datetime (e.g., 2018-12-31 12:00:00)
CREATE_BY Username of user who created Bill Plan varchar(250) Any string value
UPDATE_DATE Last Update Date of Order Bill Plan record smalldatetime Valid datetime (e.g., 2018-12-31 12:00:00)
UPDATE_BY Username of user who updated Bill Plan varchar(250) Any string value
AGENCY_ID Foreign Key for Bill Plan’s Agency uniqueidentifier GUID, Join to WOMD.Agencies
ADVERTISER_ID Foreign Key for Bill Plan’s Advertiser uniqueidentifier GUID, Join to WOMD.Advertisers
ORDER_SHARE Share of the advertiser’s buy float Floating point numeric
IS_PLACEHOLDER Flag indicating if Bill Plan is Placeholder bit 0 or 1
BILLING_ADDRESS_INT Foreign Key for Agency’s Billing Address int Join to WO_ADDRESSES
REMIT_ADDRESS_INT Foreign Key for Agency’s Remit Address int Join to WO_ADDRESSES
AGENCY_COMMISSION Agency’s Commission float Floating point numeric
BILLPLAN_IS_CASH Flag indicating if Bill Plan is Cash bit 0 or 1

WOMD.Payments

Returns list of Payment Processing Levels

Input Parameters

Example Request:

  {
    "RequestType":"WOMD.Payments",
    "DataExportFormat":"JSON",
    "TargetUrl":"https://yoursite.com/ProcessData",
    "ChunkRowsCount":"50",
    "GenerateInValidFormat":"true",
    "Parameters": []
  }

Example Error:

  {
    "Message": "There is no DDL's with request type - WOMD.AE for Agreement YOU/PM_v110"
  }

None

Output Fields

Field Name Description Data Type Supported Values
REPORT_DATE Reporting date, first day of the month payment is received smalldatetime Valid datetime (e.g., 2018-12-31 12:00:00)
AMOUNT_PMT Total amount of cash payments money Money
COUNT_PMT Total number of cash payments int Any integer value
AMOUNT_CC Total amount of credit card payments money Money
COUNT_CC Total number of credit card payments int Any integer value

WOMD.ProductCodes

Returns list of Product Codes

Input Parameters

Example Request:

  {
    "RequestType":"WOMD.ProductCodes",
    "DataExportFormat":"JSON",
    "TargetUrl":"https://yoursite.com/ProcessData",
    "ChunkRowsCount":"50",
    "GenerateInValidFormat":"true",
    "Parameters":
    [
      {
        "Name":"@LASTSUCCESSFULRUN",
        "DbType":"smalldatetime",       
        "Value":"2018-12-31 12:00:00"
      }
    ]
  }

Example Error:

  {
    "Message": "There is no DDL's with request type - WOMD.AE for Agreement YOU/PM_v110"
  }
Field Name Description Data Type Supported Values
@LASTSUCCESSFULRUN Last date/time that data was requested smalldatetime Valid datetime (e.g., 2018-12-31 12:00:00)

Output Fields

Field Name Description Data Type Supported Values
PRODUCT_CODE_ID Product Code ID uniqueidentifier GUID
PARENT_PRODUCT_CODE_ID Foreign Key for Product Code’s Parent uniqueidentifier GUID, Join back to WOMD.ProductCodes
PRODUCT_CODE_NAME Product Code Name varchar(50) Any string value
PRODUCT_CODE_DESCR Prodcut Code Description varchar(250) Any string value
ROW_STATE Specifies if Product Code has been deleted or not int 0, 1, or 2. 0 or 1 is active record. 2 is a soft deleted row.
CREATE_DATE Create Date of Product Code record smalldatetime Valid datetime (e.g., 2018-12-31 12:00:00)
UPDATE_DATE Last Update Date of Product Code smalldatetime Valid datetime (e.g., 2018-12-31 12:00:00)
CREATE_BY Username of user who created Product Code varchar(250) Any string value
UPDATE_BY Username of user who updated Product Code varchar(250) Any string value

WOMD.Programs

Returns list of Programs

Input Parameters

Example Request:

  {
    "RequestType":"WOMD.Programs",
    "DataExportFormat":"JSON",
    "TargetUrl":"https://yoursite.com/ProcessData",
    "ChunkRowsCount":"50",
    "GenerateInValidFormat":"true",
    "Parameters":
    [
      {
        "Name":"@LASTSUCCESSFULRUN",
        "DbType":"smalldatetime",       
        "Value":"2018-12-31 12:00:00"
      }
    ]
  }

Example Error:

  {
    "Message": "There is no DDL's with request type - WOMD.AE for Agreement YOU/PM_v110"
  }
Field Name Description Data Type Supported Values
@LASTSUCCESSFULRUN Last date/time that data was requested smalldatetime Valid datetime (e.g., 2018-12-31 12:00:00)

Output Fields

Field Name Description Data Type Supported Values
PROGRAM_ID Program ID uniqueidentifier GUID
PROGRAM_INT Program ID, integer value int Any integer value
PROGRAM_NAME Program Name varchar(250) Any string value
TV_RATING_INT Foreign Key for Program’s TV Rating int Join to WOMD.Lookups
ROW_STATE Specifies if Program has been deleted or not int 0, 1, or 2. 0 or 1 is active record. 2 is a soft deleted row.
CREATE_DATE Create Date of Program record smalldatetime Valid datetime (e.g., 2018-12-31 12:00:00)
UPDATE_DATE Last Update Date of Program varchar(250) Any string value
PROGRAM_EXTERNAL_ID Program’s External ID uniqueidentifier GUID
GENRE_INT Foreign Key for Program’s Genre int Join to WOMD.Lookups

WOMD.SalesOffices

Returns list of Sales Offices

Input Parameters

Example Request:

  {
    "RequestType":"WOMD.SalesOffices",
    "DataExportFormat":"JSON",
    "TargetUrl":"https://yoursite.com/ProcessData",
    "ChunkRowsCount":"50",
    "GenerateInValidFormat":"true",
    "Parameters":[]
  }

Example Error:

  {
    "Message": "There is no DDL's with request type - WOMD.AE for Agreement YOU/PM_v110"
  }

None

Output Fields

Field Name Description Data Type Supported Values
SALES_OFFICE_ID Sales Office ID uniqueidentifier GUID
SALES_OFFICE_ABBREVIATION Sales Office Abbreviation varchar(20) Any string value
SALES_OFFICE_NAME Sales Office Name varchar(50) Any string value
MAILING_ADDRESS_ID Foreign Key for Sales Office’s Mailing Address uniqueidentifier GUID, Join to WO_ADDRESSES
REMIT_ADDRESS_ID Foreign Key for Sales Office’s Remit Address uniqueidentifier GUID, Join to WO_ADDRESSES
SALES_REGION_INT Sales office ID (integer value) int Any integer value
MAIN_PHONE_NUMBER Sales Office’s Main Phone Number varchar(50) Any string value
MAIN_FAX_NUMBER Sales Office’s Fax Number varchar(50) Any string value
ROW_STATE Specifies if Sales Office has been deleted or not int 0, 1, or 2. 0 or 1 is active record. 2 is a soft deleted row.
CREATE_DATE Create Date of Sales Office record smalldatetime Valid datetime (e.g., 2018-12-31 12:00:00)
CREATE_BY Username of user who created Sales Office varchar(250) Any string value
UPDATE_DATE Last Update Date of Sales Office smalldatetime Valid datetime (e.g., 2018-12-31 12:00:00)
UPDATE_BY Username of user who updated Sales Office varchar(250) Any string value
STATION_ARRAY An Array representing the Sales Office’s Stations binary(64) or binary(256) Binary(64) for pre-11.0. Binary(256) for ver. 11 and up.

WOMD.ServerInfo

Returns SQL Server and WideOrbit Info

Input Parameters

Example Request:

  {
    "RequestType":"WOMD.ServerInfo",
    "DataExportFormat":"JSON",
    "TargetUrl":"https://yoursite.com/ProcessData",
    "ChunkRowsCount":"50",
    "GenerateInValidFormat":"true",
    "Parameters":[]
  }

Example Error:

  {
    "Message": "There is no DDL's with request type - WOMD.AE for Agreement YOU/PM_v110"
  }

None

Output Fields

Field Name Description Data Type Supported Values
NoOfUsers Number of active Users created in WideOrbit int Any integer value
SQLVersion SQL Server version where WideOrbit is running varchar(512) Any string value
SQLDateOffset Number of hours from UTC time; based on time of SQL Server machine decimal Any decimal number
SQLFileSize File Size of WideOrbit database int Any integer value
TrafficVersion Version of WideOrbit customer is running varchar(15) Any string value
TrafficBuild Build number of WideOrbit customer is running varchar(15) Any string value
CentralVersion WideOrbit Central Version Key bigint Any big integer value
IsNetwork Flag to indicate whether customer is running WideOrbit Network bit 0 or 1
SQLCompMode Compatibility mode of SQL Server int Any integer value

WOMD.Stations

Returns list of Stations

Input Parameters

Example Request:

  {
    "RequestType":"WOMD.Stations",
    "DataExportFormat":"JSON",
    "TargetUrl":"https://yoursite.com/ProcessData",
    "ChunkRowsCount":"50",
    "GenerateInValidFormat":"true",
    "Parameters":[]
  }

Example Error:

  {
    "Message": "There is no DDL's with request type - WOMD.AE for Agreement YOU/PM_v110"
  }

None

Output Fields

Field Name Description Data Type Supported Values
STATION_ID Station ID uniqueidentifier GUID
STATION_CALL_LETTERS Station’s Call Letters varchar(25) Any string value
STATION_NAME Station’s Name varchar(50) Any string value
AFFILIATION Foreign Key for Station’s Affiliation int Join to WOMD.Lookups
STATION_MAIN_PHONE Station’s Main Phone varchar(50) Any string value
STATION_BILLING_PHONE Station’s Billing Phone varchar(50) Any string value
STATION_WEB_SITE Station’s Web Site varchar(50) Any string value
ACCOUNTING_CLOSE_DATE Station’s Last Accounting Close Date smalldatetime Valid datetime (e.g., 2018-12-31 12:00:00)
STATION_INT Station ID, integer value int Any integer value
VERIFIED_CLOSE_DATE Station’s Last Verified Close Date smalldatetime Valid datetime (e.g., 2018-12-31 12:00:00)
MARKET Stations’ Market varchar(50) Any string value
REGION Station’s Region varchar(50) Any string value
STATION_TYPE Foreign Key for Station Type int 1 = Airtime, 2 = Internet, 3 = WO Streaming
STATION_MAIN_ADDRESS_INT Foreign Key for Station’s Main Address int Join to WO_ADDRESSES
ROW_STATE Specifies if Station has been deleted or not int 0, 1, or 2. 0 or 1 is active record. 2 is a soft deleted row.
CREATE_DATE Create Date of Station record smalldatetime Valid datetime (e.g., 2018-12-31 12:00:00)
UPDATE_DATE Last Update Date of Station smalldatetime Valid datetime (e.g., 2018-12-31 12:00:00)
ADDRESS_NAME Station’s Address Name varchar(100) Any string value
ADDRESS_LINE1 Station’s Main Address, Address Line 1 varchar(100)
ADDRESS_LINE2 Station’s Main Address, Address Line 2 varchar(100)
ADDRESS_LINE3 Station’s Main Address, Address Line 3 varchar(100)
ADDRESS_CITY Address’s City varchar(100) Any string value
ADDRESS_STATE Station’s Main Address, State varchar(25)
ADDRESS_ZIPCODE Station’s Main Address, Zipcode varchar(50)
ADDRESS_COUNTRY Station’s Main Address, Country varchar(100)
EI_BAND Station’s Billing Group EI Band varchar(25) Any string value
EI_MEDIA_TYPE Station’s Billing Group EI Media Type varchar(25) Any string value
EI_NAME Station’s Billing Group EI Name varchar(25) Any string value
REPORTING_NAME Station’s Reporting Name varchar(100) Any string value
STATION_GROUP_INT Foreign Key for Station’s Bill Group int Join to WOMD.BillingGroup
UNIT_CODE_INT Foreign Key for Station’s default Unit Code int Join to WOMD.UnitCodes
BG_STATION_CALL_LETTERS Station’s Billing Group Call Letters varchar(25) Any string value
IS_WOX_ENABLED Flag for whether Billing Group is WO Exchange enabled tinyint 0 or 1
IS_DEFAULT_STATION Flag for whether Station is Billing Group’s default station bit 0 or 1

WOMD.SystemSettings

Returns WideOrbit System Settings

Input Parameters

Example Request:

  {
    "RequestType":"WOMD.SystemSettings",
    "DataExportFormat":"JSON",
    "TargetUrl":"https://yoursite.com/ProcessData",
    "ChunkRowsCount":"50",
    "GenerateInValidFormat":"true",
    "Parameters":[]
  }

Example Error:

  {
    "Message": "There is no DDL's with request type - WOMD.AE for Agreement YOU/PM_v110"
  }

None

Output Fields

Field Name Description Data Type Supported Values
SYSTEM_SETTING_ID System Setting ID uniqueidentifier GUID
SYSTEM_NAME System Name varchar(50) Any string value
SYSTEM_CODE System Code varchar(5) Any string value
FISCAL_CALENDAR_INT Foreign Key for System’s Fiscal Calendar int Join to WOMD.Lookups
DEFAULT_DIGITAL_REVENUE_CODE_INT Foreign Key for Default Digital Revenue Code int Join to WOMD.Lookups
DEFAULT_DIGITAL_REVENUE_CODE2_INT Foreign Key for Default Digital Revenue Code2 int Join to WOMD.Lookups
DEFAULT_DIGITAL_REVENUE_CODE3_INT Foreign Key for Default Digital Revenue Code3 int Join to WOMD.Lookups
DEFAULT_DIGITAL_ORDER_TYPE_INT Foreign Key for Default Digital Order Type int Join to WOMD.Lookups
SYSTEM_LICENSE System License text Any large text value
ROW_STATE Specifies if System Setting has been deleted or not int 0, 1, or 2. 0 or 1 is active record. 2 is a soft deleted row.
CREATE_DATE Create Date of System Setting record smalldatetime Valid datetime (e.g., 2018-12-31 12:00:00)
CREATE_BY Username of user who created System Setting varchar(250) Any string value
UPDATE_DATE Last Update Date of System Setting smalldatetime Valid datetime (e.g., 2018-12-31 12:00:00)
UPDATE_BY Username of user who updated System Setting varchar(250) Any string value

WOMD.UnitCodes

Returns list of Unit Codes

Input Parameters

Example Request:

  {
    "RequestType":"WOMD.UnitCodes",
    "DataExportFormat":"JSON",
    "TargetUrl":"https://yoursite.com/ProcessData",
    "ChunkRowsCount":"50",
    "GenerateInValidFormat":"true",
    "Parameters":[]
  }

Example Error:

  {
    "Message": "There is no DDL's with request type - WOMD.AE for Agreement YOU/PM_v110"
  }

None

Output Fields

Field Name Description Data Type Supported Values
UNIT_CODE_ID Unit Code ID uniqueidentifier GUID
UNIT_CODE_INT Unit Code ID, integer value int Any integer value
UNIT_CODE_CODE Code Name varchar(250) Any string value
UNIT_CODE_DISPLAY Display Name varchar(250) Any string value
UNIT_CODE_SORT Sort varchar(50) Any string value
UNIT_CODE_DESCRIPTION Description varchar(250) Any string value
EXTERNAL_ID External ID varchar(250) Any string value
REPORTING_NAME Reporting Name varchar(250) Any string value
ROW_STATE Specifies if System Setting has been deleted or not int 0, 1, or 2. 0 or 1 is active record. 2 is a soft deleted row.
CREATE_DATE Create Date of System Setting record smalldatetime Valid datetime (e.g., 2018-12-31 12:00:00)
CREATE_BY Username of user who created System Setting varchar(250) Any string value
UPDATE_DATE Last Update Date of System Setting smalldatetime Valid datetime (e.g., 2018-12-31 12:00:00)
UPDATE_BY Username of user who updated System Setting varchar(250) Any string value

WOMD.Users

Returns list of WideOrbit Users

Input Parameters

Example Request:

  {
    "RequestType":"WOMD.Users",
    "DataExportFormat":"JSON",
    "TargetUrl":"https://yoursite.com/ProcessData",
    "ChunkRowsCount":"50",
    "GenerateInValidFormat":"true",
    "Parameters":
    [
      {
        "Name":"@LASTSUCCESSFULRUN",
        "DbType":"smalldatetime",       
        "Value":"2018-12-31 12:00:00"
      }
    ]
  }

Example Error:

  {
    "Message": "There is no DDL's with request type - WOMD.AE for Agreement YOU/PM_v110"
  }
Field Name Description Data Type Supported Values
@LASTSUCCESSFULRUN Last date/time that data was requested smalldatetime Valid datetime (e.g., 2018-12-31 12:00:00)

Output Fields

Field Name Description Data Type Supported Values
SECURITY_USER_ID Security User ID uniqueidentifier GUID
EMAIL_ADDRESS User’s Email Address varchar(50) Any string value
TITLE User’s Title varchar(50) Any string value
DEPARTMENT User’s Department varchar(50) Any string value
IS_SUPER_USER Flag indicating whether user is a Super User int 0 or 1
IS_DOMAIN_LOGIN Flag indicating whether this is a Domain Login int 0 or 1
LAST_LOGIN Last date/time that user logged into WideOrbit smalldatetime Valid datetime (e.g., 2018-12-31 12:00:00)
INVALID_LOGIN_ATTEMPTS Number of Invalid Login Attempts int Any integer value
CREATE_DATE Create Date of User record smalldatetime Valid datetime (e.g., 2018-12-31 12:00:00)
UPDATE_DATE Last Update Date of User record smalldatetime Valid datetime (e.g., 2018-12-31 12:00:00)
ROW_STATE Specifies if System Setting has been deleted or not int 0, 1, or 2. 0 or 1 is active record. 2 is a soft deleted row.

WOMD.ChannelAirDates

Returns list of Log Dates

Input Parameters

Example Request:

  {
    "RequestType":"WOMD.ChannelAirDates",
    "DataExportFormat":"JSON",
    "TargetUrl":"https://yoursite.com/ProcessData",
    "ChunkRowsCount":"50",
    "GenerateInValidFormat":"true",
    "Parameters":
    [
      {
        "Name":"@LASTSUCCESSFULRUN",
        "DbType":"smalldatetime",       
        "Value":"2018-12-31 12:00:00"
      }
    ]
  }

Example Error:

  {
    "Message": "There is no DDL's with request type - WOMD.AE for Agreement YOU/PM_v110"
  }
Field Name Description Data Type Supported Values
@LASTSUCCESSFULRUN Last date/time that data was requested smalldatetime Valid datetime (e.g., 2018-12-31 12:00:00)

Output Fields

Field Name Description Data Type Supported Values
CHANNEL_AIR_DATE_ID Channel Air Date ID uniqueidentifier GUID
CHANNEL_INT Foreign Key for the Air Date’s Channel int Join to WOMD.Channels
AIR_DATE Air Date of Log smalldatetime Valid datetime (time is converted to 00:00:00)
SIGN_ON Sign On time for Air Date, expressed as milliseconds after midnight int Any integer value
SIGN_OFF Sign Off time for Air Date, expressed as milliseconds after midnight int 0 or 1
IS_ALTERED Flag indicating whether the Log has been modified int 0 or 1
IS_FINALIZED Flag indicating whether the Log has been finalized int 0 or 1
FINALIZE_COUNT Number of time Log was finalized int Any integer value
FINALIZE_DATE The last Date the Log was finalized smalldatetime Valid datetime (e.g., 2018-12-31 12:00:00)
RECONCILE_IN_PROGRESS Flag indicating whether Log has begun Reconcilation process int 0 or 1
IS_RECONCILED Flag indicating whether Log has been completely Reconciled int 0 or 1
IS_INVOICED Flag indicating whether Log has been Invoiced int 0 or 1
IS_FROZEN_TO_ORDERS Flag indicating whether the Log is Frozen to changes to Orders int 0 or 1
IS_LOCKED Flag indicatng whether the Log is Locked int 0 or 1
EXTENDED_LOG_ACTUAL_START Extended Log Start Time (for Daylight Savings Time) int Any integer value
EXTENDED_LOG_DISPLAY_START Extended Log Start Time that is Displayed (for Daylight Savings Time) int Any integer value
EXTENDED_LOG_TYPE Extended Log Type int 0 or 1
IS_DELETED Flag indicating whether Log has been Deleted bit 0 or 1
CREATE_DATE Create Date of System Setting record smalldatetime Valid datetime (e.g., 2018-12-31 12:00:00)
CREATE_BY Username of user who created System Setting varchar(250) Any string value
UPDATE_DATE Last Update Date of System Setting smalldatetime Valid datetime (e.g., 2018-12-31 12:00:00)
UPDATE_BY Username of user who updated System Setting varchar(250) Any string value
UPDATE_COUNT Number of times Log has been Updated int Any integer value
IS_READY_FOR_PROMO Flag indicating whether Log is Ready to place Promo’s int 0 or 1
IS_INSERTION_WINDOWS_LOCKED Flag indicating whether Insertion Windows are Locked int 0 or 1
PLAYLIST_VERSION Playlist Version number smallint Any integer value
IS_VERIFIED Flag indicating whether Log has been Verified int 0 or 1
PLAYLIST_STATUS Playlist Status smallint Any integer value
IS_FROZEN_TO_FORMAT_SCHEDULES Flag indicating whether Log is Frozen to Format Schedule changes int 0 or 1

WOMD.InternetProduct

Returns list of Internet Products

Input Parameters

Example Request:

  {
    "RequestType":"WOMD.InternetProduct",
    "DataExportFormat":"JSON",
    "TargetUrl":"https://yoursite.com/ProcessData",
    "ChunkRowsCount":"50",
    "GenerateInValidFormat":"true",
    "Parameters":
    [
      {
        "Name":"@LASTSUCCESSFULRUN",
        "DbType":"smalldatetime",       
        "Value":"2018-12-31 12:00:00"
      }
    ]
  }

Example Error:

  {
    "Message": "There is no DDL's with request type - WOMD.AE for Agreement YOU/PM_v110"
  }
Field Name Description Data Type Supported Values
@LASTSUCCESSFULRUN Last date/time that data was requested smalldatetime Valid datetime (e.g., 2018-12-31 12:00:00)

Output Fields

Field Name Description Data Type Supported Values
INTERNET_PRODUCT_ID Internet Product ID uniqueidentifier GUID
INTERNET_PRODUCT_INT Internet Product ID, integer value int Any integer value
CHANNEL_INT Foreign Key for Internet Product’s Channel int Join to WOMD.Channels
INVENTORY_CODE_INT Foreign Key for Internet Product’s Inventory Code int Join to WOMD.InventoryCodes
AD_SLOT_INT Foreign Key for Internet Product’s Ad Slot int Join to WOMD.Lookups
AD_TYPE_INT Foreign Key for Internet Product’s Ad Type int Join to WOMD.Lookups
START_DATE Start Date of Internet Product smalldatetime Valid datetime (e.g., 2018-12-31 12:00:00)
END_DATE End Date of Internet Product smalldatetime Valid datetime (e.g., 2018-12-31 12:00:00)
NAME Name of Internet Product varchar(50) Any string value
SORT Sort of Internet Product varchar(50) Any string value
EXTERNAL_DESCRIPTION External Description of Internet Product varchar(250) Any string value
KEYWORDS Keywords of Internet Product varchar(max) Ad Server commands
IS_DELETED Flag indicating whether Internet Product is Deleted bit 0 or 1
CREATE_DATE Create Date of System Setting record smalldatetime Valid datetime (e.g., 2018-12-31 12:00:00)
CREATE_BY Username of user who created System Setting varchar(250) Any string value
UPDATE_DATE Last Update Date of System Setting smalldatetime Valid datetime (e.g., 2018-12-31 12:00:00)
UPDATE_BY Username of user who updated System Setting varchar(250) Any string value
PRODUCT_TYPE_INT Foreign Key of Internet Product Type int Join to WOMD.Lookups
TARGETING Targeting of Internet Product varchar(max) int value of target (join to WOMD.Lookups) and Target text
DEFAULT_RATE Default Rate of Internet Product int 0 = CPM, actuals; 1 = CPC; 2 = Flat fee; 3 = CPD, daily; 4 = CPP; 5 = CPD, weekly; 6 = CPD, monthly; 7 = CPM, booked
ALLOW_IMP_GOAL Allow Goal int 0 or 1
DIGITAL_TYPE Digital Type of Internet Product int 1 = Internet, 2 = Streaming
GOAL_TYPE Goal Type of Internet Product int 1 = Impressions, 2 = Plays

WOMD.InventoryType

Returns list of Internet Products

Input Parameters

Example Request:

  {
    "RequestType":"WOMD.InventoryType",
    "DataExportFormat":"JSON",
    "TargetUrl":"https://yoursite.com/ProcessData",
    "ChunkRowsCount":"50",
    "GenerateInValidFormat":"true",
    "Parameters":
    [
      {
        "Name":"@LASTSUCCESSFULRUN",
        "DbType":"smalldatetime",       
        "Value":"2018-12-31 12:00:00"
      }
    ]
  }

Example Error:

  {
    "Message": "There is no DDL's with request type - WOMD.AE for Agreement YOU/PM_v110"
  }
Field Name Description Data Type Supported Values
@LASTSUCCESSFULRUN Last date/time that data was requested smalldatetime Valid datetime (e.g., 2018-12-31 12:00:00)

Output Fields

Field Name Description Data Type Supported Values
INVENTORY_TYPE_ID Inventory Type ID uniqueidentifier GUID
INVENTORY_TYPE_CODE Inventory Type Code varchar(50) Any string value
INVENTORY_TYPE_DESCR Inventroy Type Description varchar(50) Any string value
INVENTORY_TYPE_INT Inventory Type ID, integer value int Any integer value
ROW_STATE Specifies if System Setting has been deleted or not int 0, 1, or 2. 0 or 1 is active record. 2 is a soft deleted row.
CREATE_DATE Create Date of System Setting record smalldatetime Valid datetime (e.g., 2018-12-31 12:00:00)
UPDATE_DATE Last Update Date of System Setting smalldatetime Valid datetime (e.g., 2018-12-31 12:00:00)

WOMD.BillingGroup

Returns list of Billing Groups

Input Parameters

Example Request:

  {
    "RequestType":"WOMD.BillingGroup",
    "DataExportFormat":"JSON",
    "TargetUrl":"https://yoursite.com/ProcessData",
    "ChunkRowsCount":"50",
    "GenerateInValidFormat":"true",
    "Parameters":
    [
      {
        "Name":"@LASTSUCCESSFULRUN",
        "DbType":"smalldatetime",       
        "Value":"2018-12-31 12:00:00"
      }
    ]
  }

Example Error:

  {
    "Message": "There is no DDL's with request type - WOMD.AE for Agreement YOU/PM_v110"
  }
Field Name Description Data Type Supported Values
@LASTSUCCESSFULRUN Last date/time that data was requested smalldatetime Valid datetime (e.g., 2018-12-31 12:00:00)

Output Fields

Field Name Description Data Type Supported Values
BILLING_GROUP_ID Billing Group ID uniqueidentifier GUID
BILLING_GROUP_INT Billing Group ID, integer value int Any integer value
BILLING_GROUP_NAME Billing Group Name varchar(50) Any string value
BILLING_GROUP_DESCR Billing Group Description varchar(250) Any string value
STATION_INT Foreign Key for Billing Group’s Station int Join to WOMD.Stations
ALT_CALL_LETTERS Billing Group’s Station Call Letters varchar(25) Any string value
ALT_STATION_NAME Billing Group’s Station Name varchar(50) Any string value
ALT_WEB_SITE Billing Group’s Website varchar(50) Any string value
EI_NAME Electronic Invoicing Name varchar(25) Any string value
EI_MEDIA_TYPE Electronic Invoicing Media Type varchar(25) Any string value
EI_BAND Electronic Invoicing Band varchar(25) Any string value
EC_NAME Electronic Contracting Name varchar(25) Any string value
IS_DELETED Flag indicating whether Internet Product is Deleted bit 0 or 1
CREATE_DATE Create Date of System Setting record smalldatetime Valid datetime (e.g., 2018-12-31 12:00:00)
CREATE_BY Username of user who created System Setting varchar(250) Any string value
UPDATE_DATE Last Update Date of System Setting smalldatetime Valid datetime (e.g., 2018-12-31 12:00:00)
UPDATE_BY Username of user who updated System Setting varchar(250) Any string value
ENABLED_FOR_WOX Flag for whether Billing Group is WO Exchange enabled tinyint 0 or 1

WOMD.SellingElements

Returns list of Selling Elements

Input Parameters

Example Request:

  {
    "RequestType":"WOMD.SellingElements",
    "DataExportFormat":"JSON",
    "TargetUrl":"https://yoursite.com/ProcessData",
    "ChunkRowsCount":"50",
    "GenerateInValidFormat":"true",
    "Parameters":
    [
      {
        "Name":"@LASTSUCCESSFULRUN",
        "DbType":"smalldatetime",       
        "Value":"2018-12-31 12:00:00"
      }
    ]
  }

Example Error:

  {
    "Message": "There is no DDL's with request type - WOMD.AE for Agreement YOU/PM_v110"
  }
Field Name Description Data Type Supported Values
@LASTSUCCESSFULRUN Last date/time that data was requested smalldatetime Valid datetime (e.g., 2018-12-31 12:00:00)

Output Fields

Field Name Description Data Type Supported Values
SELLING_ELEMENT_ID Selling Element ID uniqueidentifier GUID
SELLING_ELEMENT_INT Selling Element ID, integer value int Any integer value
SELLING_ELEMENT_NAME Selling Element Name varchar(50) Any string value
SELLING_ELEMENT_CODE Selling Element Code varchar(10) Any string value
SELLING_ELEMENT_SORT Selling Element Sort varchar(10) Any string value
REPORTING_NAME Selling Element Reporting Name varchar(100) Any string value
IMPRESSIONS_IN_POSTING Flag indicating whether Impressions are in Posting bit 0 or 1
HAS_IMPRESSIONS Flag indicating whether Selling Element has Impressions bit 0 or 1
SUPPRESS_INVOICE_LINE Flag indicating whether to suppress in Invoice Line bit 0 or 1
DEFAULT_INVENTORY_TYPE_INT Foreign Key for Default Inventory Type smallint Join to WOMD.InventoryType
DEFAULT_BREAK_CODE_INT Foreign Key for Default Break Code smallint Join to WOMD.Lookups
DEFAULT_SELLING_NAME_RATE_FACTOR Selling Name Rate Factor smallint Between 0 and 100
DEFAULT_LENGTH1 Default Length1 in milliseconds int Any integer value
DEFAULT_LENGTH2 Default Length2 in milliseconds int Any integer value
DEFAULT_LENGTHS Default Lengths varchar(max) Any string value
STATION_INT Foreign Key for Selling Element’s Station int Join to WOMD.Stations
IS_DELETED Flag indicating whether Internet Product is Deleted bit 0 or 1
CREATE_DATE Create Date of System Setting record smalldatetime Valid datetime (e.g., 2018-12-31 12:00:00)
UPDATE_DATE Last Update Date of System Setting smalldatetime Valid datetime (e.g., 2018-12-31 12:00:00)

WOMD.InvoiceSummary

Return count of Invoices by Stations

Input Parameters

Example Request:

  {
    "RequestType":"WOMD.InvoiceSummary",
    "DataExportFormat":"JSON",
    "TargetUrl":"https://yoursite.com/ProcessData",
    "ChunkRowsCount":"50",
    "GenerateInValidFormat":"true",
    "Parameters":
    [
      {
        "Name":"@LASTSUCCESSFULRUN",
        "DbType":"smalldatetime",       
        "Value":"2018-12-31 12:00:00"
      }
    ]
  }

Example Error:

  {
    "Message": "There is no DDL's with request type - WOMD.AE for Agreement YOU/PM_v110"
  }
Field Name Description Data Type Supported Values
@LASTSUCCESSFULRUN Last date/time that data was requested smalldatetime Valid datetime (e.g., 2018-12-31 12:00:00)

Output Fields

Field Name Description Data Type Supported Values
STATION_CALL_LETTERS Station Call Letter varchar(25) Station call letters
INVOICE_COUNT Number of invoices generated since Last Successful Run int Any integer value

WOMD.Adjustments

Returns list of Adjustments

Input Parameters

Example Request:

  {
    "RequestType":"WOMD.Adjustments",
    "DataExportFormat":"JSON",
    "TargetUrl":"https://yoursite.com/ProcessData",
    "ChunkRowsCount":"50",
    "GenerateInValidFormat":"true",
    "Parameters":
    [
      {
        "Name":"@LASTSUCCESSFULRUN",
        "DbType":"smalldatetime",       
        "Value":"2018-12-31 12:00:00"
      }
    ]
  }

Example Error:

  {
    "Message": "There is no DDL's with request type - WOMD.AE for Agreement YOU/PM_v110"
  }
Field Name Description Data Type Supported Values
@LASTSUCCESSFULRUN Last date/time that data was requested smalldatetime Valid datetime (e.g., 2018-12-31 12:00:00)

Output Fields

Field Name Description Data Type Supported Values
REPORT_DATA_REVENUE_ID Report Data Revenue ID uniqueidentifier GUID
ACTIVITY_DATE Date of Adjustment Activity smalldatetime Valid datetime (e.g., 2018-12-31 12:00:00)
EFFECTED_DATE Effected Date of Adjustment smalldatetime Valid datetime (e.g., 2018-12-31 12:00:00)
STATION_INT Foreign Key for Adjustment’s Station int Join to WOMD.Stations
ORDER_ID Foreign Key for Adjustment’s Order uniqueidentifier Join to WOMD.Order
SALES_OFFICE_ID Foreign Key for Adjustment’s Sales Office uniqueidentifier Join to WOMD.SalesOffices
ACCOUNT_EXECUTIVE_ID Foreign Key for Adjustment’s Account Executive uniqueidentifier Join to WOMD.AccountExec
ADVERTISER_ID Foreign Key for Adjustment’s Advertiser uniqueidentifier Join to WOMD.Advertisers
AGENCY_ID Foreign Key for Adjustment’s Agency uniqueidentifier Join to WOMD.Agencies
SALES_REGION_INT Foreign Key for Adjustment’s Sales Region int Join to WOMD.Lookups
GROSS_AMOUNT Adjusted Gross Amount money Any money amount
NET_AMOUNT Adjusted Net Amount money Any money amount
IS_ADJUSTMENT Flag indicating whether this is an Adjustment bit 0 or 1
IS_HIST Flag indicating whether this is Historical Revenue bit 0 or 1
PRODUCT_CODE_ID Foreign Key for Adjustment’s Product Code uniqueidentifier Join to WOMD.ProductCodes
PRIORITY_CODE_INT Foreign Key for Adjustment’s Priority Code int Join to WOMD.Lookups
REVENUE_CODE1_INT Foreign Key for Adjustment’s Revenue Code 1 int Join to WOMD.Lookups
REVENUE_CODE2_INT Foreign Key for Adjustment’s Revenue Code 2 int Join to WOMD.Lookups
REVENUE_CODE3_INT Foreign Key for Adjustment’s Revenue Code 3 int Join to WOMD.Lookups
UNIT_CODE_INT Foreign Key for Adjustment’s Unit Code int Join to WOMD.UnitCodes
IS_CASH Flag indicating whether Adjustment is Cash Only bit
REVENUE_ADJUSTMENT_TYPE Revenue Adjustment Type int 0 = No Adjustment; 1 = Adjust Gross; 2 = Adjust Commission; 3 = Adjust Tax1; 4 = Adjust Tax2

WOMD.Pacing

Returns Incremental Pacing Information

Input Parameters

Example Request:

  {
    "RequestType":"WOMD.Pacing",
    "DataExportFormat":"JSON",
    "TargetUrl":"https://yoursite.com/ProcessData",
    "ChunkRowsCount":"50",
    "GenerateInValidFormat":"true",
    "Parameters":
    [
      {
        "Name":"@trackingvalue",
        "DbType":"smalldatetime",       
        "Value":"2018-12-31 12:00:00"
      }
    ]
  }

Example Error:

  {
    "Message": "There is no DDL's with request type - WOMD.AE for Agreement YOU/PM_v110"
  }
Field Name Description Data Type Supported Values
@trackingvalue Last date/time that data was requested smalldatetime Valid datetime (e.g., 2018-12-31 12:00:00)

Output Fields

Field Name Description Data Type Supported Values
ACTIVITY_DATE Date of Adjustment Activity smalldatetime Valid datetime (e.g., 2018-12-31 12:00:00)
EFFECTED_DATE Effected Date of Adjustment smalldatetime Valid datetime (e.g., 2018-12-31 12:00:00)
STATION_ID Foreign Key for Revenue’s Activity Station uniqueidentifier Join to WOMD.Stations
ADVERTISER_ID Foreign Key for Revenue’s Advertiser uniqueidentifier Join to WOMD.Advertisers
AGENCY_ID Foreign Key for Revenue’s Agency uniqueidentifier Join to WOMD.Agencies
REVENUE_CODE1_INT Foreign Key for Revenue’s Revenue Code 1 smallint Join to WOMD.Lookups
REVENUE_CODE2_INT Foreign Key for Revenue’s Revenue Code 2 smallint Join to WOMD.Lookups
REVENUE_CODE3_INT Foreign Key for Revenue’s Revenue Code 3 smallint Join to WOMD.Lookups
UNIT_CODE_INT Foreign Key for Revenue’s Unit Code smallint Join to WOMD.UnitCodes
SALES_REGION_INT Foreign Key for Revenue’s Sales Region smallint Join to WOMD.Lookups
SALES_OFFICE_ID Foreign Key for Revenue’s Sales Office uniqueidentifier Join to WOMD.SalesOffices
PRODUCT_CODE_ID Foreign Key for Revenue’s Product Code uniqueidentifier Join to WOMD.ProductCodes
EI_MEDIA_TYPE Electronic Invoicing Media Type varchar(25) Any string value
CHANGE_AMOUNT Dollar amount of revenue change money Any money value
ORDER_IS_CASH Flag indicating whether order is cash tinyint
FILTER_FROM_DATE Data is merged by deleting all data for returned period in target table and inserting new set. Value of FILTER_FROM_DATE and FILTER_END_DATE fields can be used to determine data to delete against EFFECTED_DATE smalldatetime Valid datetime (e.g., 2018-12-31 12:00:00)
FILTER_END_DATE Data is merged by deleting all data for returned period in target table and inserting new set. Value of FILTER_FROM_DATE and FILTER_END_DATE fields can be used to determine data to delete against EFFECTED_DATE smalldatetime Valid datetime (e.g., 2018-12-31 12:00:00)
FILTER_DATA_STATE Flag indicating whether data exists tinyint If there are records with 0, means no data was retrieved

WOMD.PacingEx

Returns Complete Pacing Information

Input Parameters

Example Request:

  {
    "RequestType":"WOMD.PacingEx",
    "DataExportFormat":"JSON",
    "TargetUrl":"https://yoursite.com/ProcessData",
    "ChunkRowsCount":"50",
    "GenerateInValidFormat":"true",
    "Parameters":
    [
      {
        "Name":"@trackingvalue",
        "DbType":"smalldatetime",       
        "Value":"2018-12-31 12:00:00"
      }
    ]
  }

Example Error:

  {
    "Message": "There is no DDL's with request type - WOMD.AE for Agreement YOU/PM_v110"
  }
Field Name Description Data Type Supported Values
@trackingvalue Last date/time that data was requested smalldatetime Valid datetime (e.g., 2018-12-31 12:00:00)

Output Fields

Field Name Description Data Type Supported Values
ORDER_ACTIVITY_ID Order Activity ID uniqueidentifier
ACTIVITY_DATE Date of Adjustment Activity smalldatetime Valid datetime (e.g., 2018-12-31 12:00:00)
EFFECTED_DATE Effected Date of Adjustment smalldatetime Valid datetime (e.g., 2018-12-31 12:00:00)
ORDER_ID Foreign Key for Order ID uniqueidentifier Join to WOMD.Orders
ORDER_INT Foreign Key for Order ID, integer value int Join to WOMD.Orders
CHANNEL_INT Foreign Key for Channel int Join to WOMD.Channels
STATION_INT Foreign Key for Station int Join to WOMD.Stations
CHANGE_AMOUNT Dollar amount of revenue change money Any money value
CHANGE_TYPE char(1)
PRIORITY_CODE_INT Foreign Key for Priority Code smallint Join to WOMD.Lookups
REVENUE_CODE1_INT Foreign Key for Revenue Code 1 smallint Join to WOMD.Lookups
REVENUE_CODE2_INT Foreign Key for Revenue Code 2 smallint Join to WOMD.Lookups
REVENUE_CODE3_INT Foreign Key for Revenue Code 3 smallint Join to WOMD.Lookups
UNIT_CODE_INT Foreign Key for Unit Code smallint Join to WOMD.UnitCodes
INVENTORY_CODE_ID Foreign Key for Inventory Code uniqueidentifier Join to WOMD.InventoryCodes
INVENTORY_CODE_INT Foreign Key for Inventory Code, integer value int Join to WOMD.InventoryCodes
CHANGE_UNITS Number of Spots that changed int Any integer value
CHANGE_LENGTH Length of Spots that changed int Any integer value
ACTIVITY_BY User who created the change varchar(150) Any string value
FILTER_FROM_DATE Data is merged by deleting all data for returned period in target table and inserting new set. Value of FILTER_FROM_DATE and FILTER_END_DATE fields can be used to determine data to delete against EFFECTED_DATE smalldatetime Valid datetime (e.g., 2018-12-31 12:00:00)
FILTER_END_DATE Data is merged by deleting all data for returned period in target table and inserting new set. Value of FILTER_FROM_DATE and FILTER_END_DATE fields can be used to determine data to delete against EFFECTED_DATE smalldatetime Valid datetime (e.g., 2018-12-31 12:00:00)
FILTER_DATA_STATE Flag indicating whether data exists tinyint If there are records with 0, means no data was retrieved

WOMD.Spot

Returns incremental lists of Spots

Input Parameters

Example Request:

  {
    "RequestType":"WOMD.Spot",
    "DataExportFormat":"JSON",
    "TargetUrl":"https://yoursite.com/ProcessData",
    "ChunkRowsCount":"50",
    "GenerateInValidFormat":"true",
    "Parameters":
    [
      {
        "Name":"@trackingvalue",
        "DbType":"smalldatetime",       
        "Value":"2018-12-31 12:00:00"
      }
    ]
  }

Example Error:

  {
    "Message": "There is no DDL's with request type - WOMD.AE for Agreement YOU/PM_v110"
  }
Field Name Description Data Type Supported Values
@trackingvalue Last date/time that data was requested smalldatetime Valid datetime (e.g., 2018-12-31 12:00:00)

Output Fields

Field Name Description Data Type Supported Values
STATION_ID Foreign Key for Station uniqueidentifier Join to WOMD.Stations
ADVERTISER_ID Foreign Key for Advertiser uniqueidentifier
AGENCY_ID Foreign Key for Agency uniqueidentifier
BOOKED_DAYPART_INT Foreign Key for Booked Daypart int
PLACED_DAYPART_INT Foreign Key for Placed Daypart int
ISCI_CODE ISCI Code of Material varchar(50)
INTENDED_AIR_DATE Intended Air Date of Spot smalldatetime
SALES_REGION_INT Foreign Key for Sales Region int
ORDER_CREATE_DATE Order Create Date smalldatetime
SPOT_LENGTH Spot Length in milliseconds int
CHANNEL_INT Foreign Key for Channel int
GROSS_REVENUE Gross Revenue money
PRODUCT_CODE_ID Foreign Key for Product Code uniqueidentifier
ORDER_IS_CASH Flag indicating if Order Is Cash tinyint
INVENTORY_TYPE_INT Foreign Key for Inventory Type int
BREAK_CODE_INT Foreign Key for Break Code int
PROGRAM_INT Foreign Key for Program int
INVENTORY_CODE_INT Foreign Key for Inventory Code int
MARKETPLACE_INT Foreign Key for Marketplace int
FILTER_FROM_DATE Data is merged by deleting all data for returned period in target table and inserting new set. Value of FILTER_FROM_DATE and FILTER_END_DATE fields can be used to determine data to delete against INTENDED_AIR_DATE smalldatetime
FILTER_END_DATE Data is merged by deleting all data for returned period in target table and inserting new set. Value of FILTER_FROM_DATE and FILTER_END_DATE fields can be used to determine data to delete against INTENDED_AIR_DATE smalldatetime
FILTER_DATA_STATE Flag indicating whether data exists tinyint If there are records with 0, means no data was retrieved

WOMD.SpotEx

Returns complete lists of Spots

Input Parameters

Example Request:

  {
    "RequestType":"WOMD.SpotEx",
    "DataExportFormat":"JSON",
    "TargetUrl":"https://yoursite.com/ProcessData",
    "ChunkRowsCount":"50",
    "GenerateInValidFormat":"true",
    "Parameters":
    [
      {
        "Name":"@trackingvalue",
        "DbType":"smalldatetime",       
        "Value":"2018-12-31 12:00:00"
      }
    ]
  }

Example Error:

  {
    "Message": "There is no DDL's with request type - WOMD.AE for Agreement YOU/PM_v110"
  }
Field Name Description Data Type Supported Values
@trackingvalue Last date/time that data was requested smalldatetime Valid datetime (e.g., 2018-12-31 12:00:00)

Output Fields

Field Name Description Data Type Supported Values
ORDER_LINE_UNIT_ID Order Line Unit (Spot) ID uniqueidentifier GUID
OVERRIDE_INVENTORY_CODE_INT Foreign Key for Spot’s Reconciled Inventory Code if different that booked int Join to WOMD.InventoryCodes
INVENTORY_CODE_INT Foreign Key for Spot’s Inventory Code int Join to WOMD.InventoryCodes
AD_SLOT_INT Foreign Key for Spot’s Ad Slot smallint Join to WOMD.Lookups
AD_TYPE_INT Foreign Key for Spot’s Ad Type smallint Join to WOMD.Lookups
FREQUENCY_INTERVAL Time Interval for Internet Spot smallint Interval is 2 in this example: 3 times every 2 hours
FREQUENCY_NUMBER Number of times within an interval Internet Spot runs smallint Frequency Number is 3 in this example: 3 time every 2 hours
FREQUENCY_TYPE Type of time interval for Internet Spot tinyint 0 = minutes; 1 = hours; 2 = days; 3 = weeks; 4 = months; 5 = lifetime
INTERNET_PRIORITY Internet Spot’s Internet Priority tinyint 0 to 100
INTERNET_PRODUCT_INT Foreign Key for Internet Spot’s Internet Product int Join to WOMD.InternetProduct
PRODUCT_TYPE_INT Foreign Key for Internet Spot’s Product Type smallint Join to WOMD.Lookups
RATE_TYPE_INT Foreign Key for Internet Spot’s Rate Type tinyint 0 = CPM-Actuals; 1 = CPC; 2 = Flat rate; 3 = CPD, Daily; 4 = CPP; 5 = CPD, Weekly; 6 = CPD, Monthly; 7 = CPM, Booked
RECONCILED_AMOUNT Internet Spot’s Reconciled Dollar Amount money Any money value
RECONCILED_CLICKS Internet Spot’s Reconciled Number of Clicks int Any integer value
RECONCILED_IMPRESSIONS Internet Spot’s Reconciled Number of Impressions int Any integer value
THIRD_PARTY_AD_SERVER_INT Foreign Key for Internet Spot’s Third Party Ad Server smallint Join to WOMD.Lookups
INTERNET_WEIGHT Internet Weight tinyint Any tiny integer value
LINE_NUMBER Order Line Number int Any integer value
ADVERTISER_BRAND_INT Foreign Key for Spot’s Advertiser Brand smallint Join to WOMD.AdvertiserBrands
AGREED_IMPRESSIONS Agreed Impressions int Any integer value
AGREED_INVENTORY_RATING Agreed Inventory Rating float Any float value
AIR_TIME1 Spot’s Air Time1 in milliseconds past midnight int Any integer value
AIR_TIME2 Spot’s Air Time2 in milliseconds past midnight (if two part Spot) int Any integer value
SPOT_BREAK_CODE_INT Foreign Key for Spot’s Break Code smallint Join to WOMD.Lookups
CHANNEL_INT Foreign Key for Spot’s Channel smallint Join to WOMD.Channels
CREATE_DATE Create Date smalldatetime Valid datetime (e.g., 2018-12-31 12:00:00)
EXTERNAL_AMOUNT External Amount of Spot money Any money value
H_REVENUE_CODE1_INT Foreign Key for Revenue Code 1 for internal rate 2 smallint Join to WOMD.Lookups
H_REVENUE_CODE2_INT Foreign Key for Revenue Code 2 for internal rate 2 smallint Join to WOMD.Lookups
H_REVENUE_CODE3_INT Foreign Key for Revenue Code 3 for internal rate 2 smallint Join to WOMD.Lookups
HAS_PRODUCT_EXCLUSIVITY Flag indicating whether Spot has Product Exclusivity bit 0 or 1
INTENDED_AIR_DATE Intended Air Date of Spot smalldatetime Valid datetime (e.g., 2018-12-31 12:00:00)
INTERNAL_AMOUNT Internal Amount (Internal Rate 1) of Spot money Any money value
INVENTORY_DESCR Inventory Description varchar(150) Any string value
INVENTORY_TYPE_INT Foreign Key for Spot’s Inventory Type smallint Join to WOMD.InventoryType
INVOICE_INT Foreign Key for Spot’s Invoice int Join to WO_INVOICES
IS_BONUS Flag indicating whether the Spot is a Bonus Spot bit 0 or 1
IS_BUYER_APPROVED Flag indicating whether the Spot is Buyer Approved tinyint 0 or 1
IS_CREDITED Flag indicating whether the Spot is Credited bit 0 or 1
IS_LATE_ADD Flag indicating whether the Spot is a Late Add bit 0 or 1
IS_LOCKED Flag indicating whether the Spot is Locked bit 0 or 1
IS_MAKEGOOD Flag indicating whether the Spot is a Makegood bit 0 or 1
IS_PENDING Flag indicating whether the Spot is Pending (in edit state) bit 0 or 1
IS_PLACEABLE Flag indicating whether the Spot is Placeable bit 0 or 1
IS_PLACED Flag indicating whether the Spot is Placed bit 0 or 1
IS_PLACED_REVENUE_ONLY Flag indicating whether the Spot is Placed for Revenue Only bit 0 or 1
IS_REJECTED Flag indicating whether the Spot is Rejected bit 0 or 1
IS_UNRESOLVED Flag indicating whether the Spot is Unresolved bit 0 or 1
IS_USER_MODIFIED Flag indicating whether the Spot is User Modified bit 0 or 1
LENGTH1 Length1 in milliseconds int Any integer value
LENGTH2 Length2 in milliseconds (if two part Spot) int Any integer value
MATERIAL_INT1 Spot’s Material Int1 int Join to WOMD.Materials
MATERIAL_INT2 Spot’s Material Int2 int Join to WOMD.Materials
OVERRIDE_BREAK_CODE_INT Foreign Key for Spot’s Reconciled Break Code if different that booked smallint Join to WOMD.Lookups
POSTED_IMPRESSIONS Spot’s Posted Impressions float Any float value
POSTED_RATING Spot’s Posted Rating float Any float value
SPOT_PRIORITY_CODE_INT Foreign Key for Spot’s Reconciled Priority Code if different that booked smallint Join to WOMD.Lookups
PROGRAM_INT Foreign Key for Spot’s Reconciled Program Int int Join to WOMD.Program
PREEMPTED_DATE Foreign Key for Spot’s Reconciled Preempted Date smalldatetime Valid datetime (e.g., 2018-12-31 12:00:00)
REVENUE_CODE_INT Foreign Key for Revenue Code 1 smallint Join to WOMD.Lookups
REVENUE_CODE2_INT Foreign Key for Revenue Code 2 smallint Join to WOMD.Lookups
REVENUE_CODE3_INT Foreign Key for Revenue Code 3 smallint Join to WOMD.Lookups
SELLING_ELEMENT_INT Foreign Key for Spot’s Selling Element smallint Join to WOMD.SellingElement
SPOT_NUMBER Spot Number smallint Any integer value
STATION_INT Foreign Key for Spot’s Station smallint Join to WOMD.Stations
UNIT_CODE_INT Foreign Key for Spot’s Unit Code smallint Join to WOMD.UnitCodes
UPDATE_DATE Update Date datetime Valid datetime (e.g., 2018-12-31 12:00:00)
WAS_MADEGOOD Flag indicating whether the Spot was Madegood bit 0 or 1
TILE_HEIGHT Tile Height of Internet Spot smallint Any small integer value
TILE_WIDTH Tile Width of Internet Spot smallint Any small integer value
SPOT_CHANNEL_ARRAY Channels that Spot is ordered to varchar(1000) Binary
LINE_CHANNEL_ARRAY Channels that line is ordered to varchar(1000) Binary
ORDER_INT Foreign Key for Spot’s Order int Join to WOMD.Order
ORDER_NUMBER Order Number of Spot varchar(50) Any string value
STATION_ID Foreign Key for Spot’s Station uniqueidentifier Join to WOMD.Stations
IS_INTERNET_LINE Flag indicating whether the order line is a Internet Line bit 0 or 1
IS_SALES_MAKEGOOD Flag indicating whether Spot is a Sales Makegood bit 0 or 1
IS_CLEARED_CIA Flag indicating whether Spot is Cleared from Cash In Advance bit 0 or 1
FILTER_FROM_DATE Data is merged by deleting all data for returned period in target table and inserting new set. Value of FILTER_FROM_DATE and FILTER_END_DATE  fields can be used to determine data to delete against INTENDED_AIR_DATE smalldatetime Valid datetime (e.g., 2018-12-31 12:00:00)
FILTER_END_DATE Data is merged by deleting all data for returned period in target table and inserting new set. Value of FILTER_FROM_DATE and FILTER_END_DATE  fields can be used to determine data to delete against INTENDED_AIR_DATE smalldatetime Valid datetime (e.g., 2018-12-31 12:00:00)
FILTER_DATA_STATE Flag indicating whether data exists tinyint If there are records with 0, means no data was retrieved

WOMD.Revenue

Returns Revenue Distribution for a date range. One dataset of non-preempted spots and another for preempted spots.

Input Parameters

Example Request:

  {
    "RequestType":"WOMD.Revenue",
    "DataExportFormat":"JSON",
    "TargetUrl":"https://yoursite.com/ProcessData",
    "ChunkRowsCount":"50",
    "GenerateInValidFormat":"true",
    "Parameters":
    [
      {
        "Name":"@startdate",
        "DbType":"datetime",       
        "Value":"2018-12-31"
      },
      {
        "Name":"@enddate",
        "DbType":"datetime",       
        "Value":"2018-12-31"
      },
      {
        "Name":"@stationIdList",
        "DbType":"varchar",       
        "Value":"12345"
      }
    ]
  }

Example Error:

  {
    "Message": "There is no DDL's with request type - WOMD.AE for Agreement YOU/PM_v110"
  }
Field Name Description Data Type Supported Values
startdate Start date of date range to pull revenue data date Valid datetime (e.g., 2018-12-31)
enddate End date of date range to pull revenue data date Valid datetime (e.g., 2018-12-31)
stationIdList Comma separated list of Station ID’s varchar(max) List of GUID’s

Output Fields

Field Name Description Data Type Supported Values
PROPERTY Station Call Letters varchar(50) Any string value
STATION_INT Station ID, integer value integer Any integer value
CHANNEL Channel Name varchar(106) Any string value
CHANNEL_INT Channel ID, integer value int Any integer value
CHANNEL_ARRAY Array representing channels where the order was placed, if multi-channel order varchar(1000) Any string value
ADVERTISER_NAME Advertiser Name varchar(50) Any string value
ADVERTISER_MDM_ID Advertiser MDM ID int Any integer value
ADVERTISER_EXTERNAL_ID Advertiser External ID varchar(50) Any string value
YEAR_NUMBER Year int Gregorian calendar year
MONTH_NUMBER Month int Gregorian calendar month
DEMOGRAPHIC Demographic varchar(250) Any string value
ORDER_TYPE Order Type varchar(250) Any string value
CASH_OR_TRADE Cash or Trade Order varchar(10) Value is either “CASH” or “TRADE”
AGENCY_NAME Agency Name varchar(50) Any string value
AGENCY_MDM_ID Agency MDM ID int Any integer value
AGENCY_EXTERNAL_ID Agency External ID varchar(50) Any string value
SALES_OFFICE_NAME Sales Office Name varchar(50) Any string value
AE_CODE Account Executive Abbreviation Code varchar(5) Any string value
SALES_PERSON Account Executive varchar(101) Any string value
SALES_REGION Sales Region varchar(250) Any string value
PARENT_PRODUCT_CODE_NAME Parent Product Code Name varchar(250) Any string value
PRODUCT_CODE_NAME Product Code Name varchar(50) Any string value
INVENTORY_CODE Ordered Inventory Code Name varchar(50) Any string value
REVENUE_CODE1 Revenue Code 1 Name varchar(250) Any string value
REVENUE_CODE2 Revenue Code 2 Name varchar(250) Any string value
REVENUE_CODE3 Revenue Code 3 Name varchar(250) Any string value
UNIT_CODE_CODE Unit Code Name varchar(250) Any string value
CALENDAR_TYPE Calendar Type (e.g., Broadcast, Calendar, etc.) varchar(250) Any string value
SHARE_OF_ORDER Share of Order tinyint Any tiny integer value
ORDER_NUMBER Order Number varchar(50) Any string value
BRAND_NAME Brand Name varchar(250) Any string value
NET_AMOUNT Net Revenue money Money value
GROSS_AMOUNT Gross Revenue money Money value
IS_DIRECT Flag indicating whether Advertiser is a Direct Advertiser bit 0 or 1
IS_INTERNAL_RATE2 Flag indicating whether the revenue data is for Internal Rate 2 bit 0 or 1

WOMD.Aging

Returns Aging report

Input Parameters

Example Request:

  {
    "RequestType":"WOMD.Aging",
    "DataExportFormat":"JSON",
    "TargetUrl":"https://yoursite.com/ProcessData",
    "ChunkRowsCount":"50",
    "GenerateInValidFormat":"true",
    "Parameters":
    [
      {
        "Name":"@startdate",
        "DbType":"datetime",       
        "Value":"2018-12-31"
      },
      {
        "Name":"@enddate",
        "DbType":"datetime",       
        "Value":"2018-12-31"
      },
      {
        "Name":"@StationList",
        "DbType":"varchar",       
        "Value":"12345"
      }
    ]
  }

Example Error:

  {
    "Message": "There is no DDL's with request type - WOMD.AE for Agreement YOU/PM_v110"
  }
Field Name Description Data Type Supported Values
startdate Start date of date range to pull revenue data date Valid datetime (e.g., 2018-12-31)
enddate End date of date range to pull revenue data date Valid datetime (e.g., 2018-12-31)
StationList Comma separated list of Station ID’s varchar(max) List of GUID’s

Output Fields

Field Name Description Data Type Supported Values
Station Station Call Letters varchar(50) Any string value
AE Full Name Account Executive’s Full Name varchar(110) Any string value
Advertiser Advertiser Name varchar(50) Any string value
Agency Agency Name varchar(50) Any string value
Order # Order Number varchar(50) Any string value
Total Due Total Amount Due money Any money value
Date Date of Invoice smalldatetime Valid datetime (e.g., 2018-12-31)
Billing Month Billing Month of Invoice varchar(50) Any string value
AGENCY_NAME_NO_CITY Agency Name without Billing City varchar(300) Any string value
Estimate # Estimate Number varchar(50) Any string value
Original Invoice Original Invoice Number varchar(50) Any string value
Total Payments Total Payments made towards invoice money Any money value
Invoice # Invoice Number varchar(50) Any string value
Agency Credit Rating Agency’s Credit Rating varchar(250) Any string value
Order Product Description Order’s Product Description varchar(250) Any string value
Current Amount Currently Due money Any money value
30 Days Amount Due, 30 days old money Any money value
60 Days Amount Due, 60 days old money Any money value
90 Days Amount Due, 90 days old money Any money value
120 Days Amount Due, 120 days old money Any money value
150+ Days Amount Due, 150 or more days old money Any money value

WOMD.DaypartInventory

Returns Inventory By Daypart and Inventory Code

Input Parameters

Example Request:

  {
    "RequestType":"WOMD.DaypartInventory",
    "DataExportFormat":"JSON",
    "TargetUrl":"https://yoursite.com/ProcessData",
    "ChunkRowsCount":"50",
    "GenerateInValidFormat":"true",
    "Parameters":
    [
      {
        "Name":"@startdate",
        "DbType":"datetime",       
        "Value":"2018-12-31"
      },
      {
        "Name":"@enddate",
        "DbType":"datetime",       
        "Value":"2018-12-31"
      },
      {
        "Name":"@StationList",
        "DbType":"varchar",       
        "Value":"12345"
      }
    ]
  }

Example Error:

  {
    "Message": "There is no DDL's with request type - WOMD.AE for Agreement YOU/PM_v110"
  }
Field Name Description Data Type Supported Values
startdate Start date of date range to pull revenue data date Valid datetime (e.g., 2018-12-31)
enddate End date of date range to pull revenue data date Valid datetime (e.g., 2018-12-31)
StationList Comma separated list of Station ID’s varchar(max) List of GUID’s

Output Fields

Field Name Description Data Type Supported Values
STATION Station Call Letters varchar(50) Any string value
DAYPART Daypart of Inventory varchar(250) Any string value
DAY Day of Inventory smalldatetime Valid datetime (e.g., 2018-12-31)
CAPACITY_MINUTES Capacity of Inventory in Minutes float Any float number
MAX_UNITS Maximum number of units as defined in format break smallint Any small integer value
INVENTORY Inventory Code varchar(250) Any string value
INVENTORY_REPORTING_NAME Inventory Code Reporting Name varchar(250) Any string value

WOMD.Invoices

Returns Invoice Header information

Input Parameters

Example Request:

  {
    "RequestType":"WOMD.Invoices",
    "DataExportFormat":"JSON",
    "TargetUrl":"https://yoursite.com/ProcessData",
    "ChunkRowsCount":"50",
    "GenerateInValidFormat":"true",
    "Parameters":
    [
      {
        "Name":"@startdate",
        "DbType":"datetime",       
        "Value":"2018-12-31"
      },
      {
        "Name":"@enddate",
        "DbType":"datetime",       
        "Value":"2018-12-31"
      },
      {
        "Name":"@Invoice_Batch_Id",
        "DbType":"uniqueidentifier",       
        "Value":"12345"
      },
      {
        "Name":"@Station_Int",
        "DbType":"integer",       
        "Value":"12345"
      }
    ]
  }

Example Error:

  {
    "Message": "There is no DDL's with request type - WOMD.AE for Agreement YOU/PM_v110"
  }
Field Name Description Data Type Supported Values
Start_Date Start date of time range for invoice create or update date smalldatetime Valid datetime (e.g., 2018-12-31)
End_Date End date of time range for invoice create or update range smalldatetime Valid datetime (e.g., 2018-12-31)
Invoice_Batch_Id Find invoices in this batch uniqueidentifier GUID
Station_Int Find invoices for this station integer Join to WOMD.Stations

Output Fields

Field Name Description Data Type Supported Values
INVOICE_ID Invoice Id uniqueidentifier Join to WOMD.Stations
INVOICE_NUMBER Invoice Number varchar(50) Any string value
INVOICE_INT Invoice Id, integer value integer Any integer value
INVOICE_CREATE_DATE Invoice Create Date smalldatetime Valid datetime (e.g., 2018-12-31)
INVOICE_UPDATE_DATE Invoice Update Date smalldatetime Valid datetime (e.g., 2018-12-31)
INVOICE_STATUS Invoice Status integer Reference code
INVOICE_IS_EDITED Flag to indicate whether the invoice has been edited varchar ‘Yes’ or ‘No’
STATION_ID Station Id of invoice uniqueidentifier Join to WOMD.Stations
STATION_INT Station Int of invoice integer Join to WOMD.Stations
STATION_NAME Station Name of invoice varchar(50) Any string value
STATION_CALL_LETTERS Station Call letters of invoice varchar(25) Any string value
CREDIT_INVOICE_NUMBER Invoice number of the previous credit if one exists varchar(50) Any string value
CREDIT_INVOICE_DATE Invoice date of the previous credit if one exists smalldatetime Valid datetime (e.g., 2018-12-31)
BILLING_MONTH Invoice Bill Month varchar(50) Gregorian month name
INVOICE_DATE Invoice Bill Date smalldatetime Valid datetime (e.g., 2018-12-31)
BILL_TO_NAME Bill to Name varchar(50) Any string value
BILL_TO_ATTENTION Bill to Attention varchar(110) Any string value
AGENCY_ID Agency Id of invoice uniqueidentifier Join to WOMD.Agencies
DUNS_NUMBER Duns number of agency varchar(50) Any string value
PRODUCT_DESCRIPTION Order product description varchar(50) Any string value
CLIENT_TRACKING_NUMBER Order tracking number (estimate from application) varchar(50) Any string value
COMBO_DISPLAY Combo type of order varchar(50) ‘Master’ or ‘Sub’
SPECIAL_HANDLING Special Handling varchar(250) Any string value
SPECIAL_HANDLING_CODE Special Handling Code varchar(250) Any string value
TAX_RATE1 Tax Rate1 of order float Any float number
TAX_RATE2 Tax Rate2 of order float Any float number
HANDLING_STATUS Handling Status varchar(50) ‘Normal’ or ‘Special’
EI_STATUS Electronic Invoice Status varchar(50) ‘IS ELECTRONIC’ or ‘ONLY PAPER’
INVOICE_CODE Invoice Code varchar(50) Any string value
AGENCY_PRODUCT_CODE Agency Product Code (EDI value) varchar(50) Any string value
CLIENT_CODE Client Code (EDI value) varchar(50) Any string value
EI_EXPORT_TYPE Electronic Invoice Export Type tinyint Reference code
INVOICE_PERIOD_START_DATE Start of invoice period smalldatetime Valid datetime (e.g., 2018-12-31)
INVOICE_PERIOD_END_DATE End of invoice period smalldatetime Valid datetime (e.g., 2018-12-31)
BILL_PLAN_IS_USER_OVERRIDE Flag to indicate if Bill Plan has been modified bit 0 or 1
ALT_ORDER_NUMBER Alternate order number varchar(50) Any string value
IS_CASH Flag indicating if order is cash bit 0 or 1
IS_COOP Flag indicating if order is a coop order bit 0 or 1
NEW_BUSINESS_DATE New business date (all revenue behind this date is considered new business) smalldatetime Valid datetime (e.g., 2018-12-31)
ORDER_TYPE_INT Order type int integer Join to WOMD.Lookups
ORDER_PLUS_ID Order Plus Id uniqueidentifier Join to WOMD.Orders
IDB_NUMBER IDB Number varchar(50) Any string value
ORDER_START_DATE Order Flight Start Date smalldatetime Valid datetime (e.g., 2018-12-31)
ORDER_END_DATE Order Flight End Date smalldatetime Valid datetime (e.g., 2018-12-31)
ORDER_DESCR Order description varchar(50) Any string value
BILLING_GROUP_INT Billing Group Int integer Join to WOMD.BillingGroup
BILLING_GROUP_NAME Billing Group Name varchar(50) Any string value
REV_CODE1_INT Revenue Code 1 int integer Join to WOMD.Lookups
REV_CODE2_INT Revenue Code 2 int integer Join to WOMD.Lookups
REV_CODE3_INT Revenue Code 3 int integer Join to WOMD.Lookups
UNIT_CODE_INT Unit Code int integer Join to WOMD.UnitCodes
UNIT_CODE_DESCR Unit Code description varchar(50) Any string value
TOTAL_INVOICE_AMOUNT Total Invoice Amount money Any money value
OUTSTANDING_AMOUNT Outstanding balance amount money Any money value
NUMBER_OF_UNITS Number of spots included in invoice integer Any money value
GROSS_AMOUNT Gross amount of invoice money Any money value
NET_AMOUNT Net amount of invoice money Any money value
AGENCY_COMMISSION Agency commission money Any money value
AGENCY_DISCOUNT Agency discount money Any money value
TAX1_AMOUNT Total Tax 1 amount money Any money value
TAX2_AMOUNT Total Tax 2 amount money Any money value
PRIMARY_ACCOUNT_EXEC_ID Primary Account Executive Id uniqueidentifier Join to WOMD.AccountExecutives
SALES_OFFICE_ID Sales Office Id uniqueidentifier Join to WOMD.SalesOffices
SALES_REGION_INT Sales Region int integer Join to WOMD.Lookups
BILLING_CALENDAR_INT Billing Calendar int integer Join to WOMD.Lookups
BILLING_CYCLE_INT Billing Cycle int integer Join to WOMD.Lookups
ADVERTISER_ID Advertiser Id uniqueidentifier Join to WOMD.Advertisers
ORDER_NUMBER Order Number varchar(50) Any string value
ADVERTISER_ADDRESS_CITY Advertiser Address city varchar(100) Any string value
ADVERTISER_ADDRESS_COUNTRY Advertiser Address country varchar(100) Any string value
ADVERTISER_ADDRESS_LINE1 Advertiser Address line1 varchar(100) Any string value
ADVERTISER_ADDRESS_LINE2 Advertiser Address line2 varchar(100) Any string value
ADVERTISER_ADDRESS_LINE3 Advertiser Address line3 varchar(100) Any string value
ADVERTISER_ADDRESS_NAME Advertiser Address name varchar(100) Any string value
ADVERTISER_ADDRESS_STATE Advertiser Address state varchar(100) Any string value
ADVERTISER_ADDRESS_POSTAL_CODE Advertiser_Address_Postal Code varchar(100) Any string value
ORDER_INT Order Int integer Join to WOMD.Orders
ORDER_PLUS_INT Order Plus int integer Join to WOMD.Orders
PENDING_LINK_ORDER_ID Pending_Link_Order Id uniqueidentifier Join to WOMD.Orders
BILLING_ADDRESS_INT Billing Address int integer Join to WOMD.Addresses
CAMPAIGN_NUMBER Campaign Number varchar(50) Any string value
ORDER_TYPE_DESCR Order Type description varchar(250) Any string value
ORDER_TYPE_DISPLAY Order Type display varchar(250) Any string value
ORDER_TYPE Order Type varchar(250) Any string value
REVENUE_CODE1_DESCR Revenue Code1 descr varchar(250) Any string value
REVENUE_CODE2_DESCR Revenue Code2 descr varchar(250) Any string value
REVENUE_CODE3_DESCR Revenue Code3 descr varchar(250) Any string value
AGENCY_NAME Agency Name varchar(50) Any string value
ADVERTISER_NAME Advertiser Name varchar(50) Any string value
SALES_OFFICE_NAME Sales Office name varchar(250) Any string value
SALES_REGION_DESCR Sales Region description varchar(250) Any string value
SALES_REGION_DISPLAY Sales Region display varchar(250) Any string value
SALES_REGION Sales Region varchar(250) Any string value
ACCOUNT_EXEC_CODE Account Exec code varchar(5) Any string value
ACCOUNT_EXEC_NAME Account Exec name varchar(110) Any string value
ACCOUNT_EXEC_PHONE Account Exec phone varchar(100) Any string value
BILLING_CALENDAR Billing Calendar varchar(250) Any string value
BILLING_ADDRESS_LINE1 Billing Address line1 varchar(100) Any string value
BILLING_ADDRESS_LINE2 Billing Address line2 varchar(100) Any string value
BILLING_ADDRESS_CITY Billing Address city varchar(100) Any string value
BILLING_ADDRESS_STATE Billing Address state varchar(100) Any string value
BILLING_ADDRESS_POSTAL_CODE Billing_Address_Postal Code varchar(100) Any string value
BILLING_ADDRESS_COUNTRY Billing Address country varchar(100) Any string value
STATION_ADDRESS_LINE1 Station Address line1 varchar(100) Any string value
STATION_ADDRESS_LINE2 Station Address line2 varchar(100) Any string value
STATION_ADDRESS_CITY Station Address city varchar(100) Any string value
STATION_ADDRESS_STATE Station Address state varchar(100) Any string value
STATION_ADDRESS_POSTAL_CODE Station_Address_Postal Code varchar(100) Any string value
REMIT_ADDRESS_LINE1 Remit Address line1 varchar(100) Any string value
REMIT_ADDRESS_LINE2 Remit Address line2 varchar(100) Any string value
REMIT_ADDRESS_CITY Remit Address city varchar(100) Any string value
REMIT_ADDRESS_STATE Remit Address state varchar(100) Any string value
REMIT_ADDRESS_POSTAL_CODE Remit_Address_Postal Code varchar(100) Any string value
STATION_PHONE Station Phone varchar(50) Any string value
BILLING_PHONE Billing Phone varchar(50) Any string value
GLOBAL_AGENCY_ID Global Agency id varchar(50) Any string value
EXTERNAL_AGENCY_CODE External Agency code varchar(50) Any string value
GLOBAL_ADVERTISER_ID Global Advertiser id varchar(50) Any string value
EXTERNAL_ADVERTISER_CODE External Advertiser code varchar(50) Any string value
IS_CASH_IN_ADVANCE Flag indicating whether order is Cash In Advance bit 0 or 1
REMARKS Remarks varchar(50) Any string value
SUPPRESS_CLICKS Flag indicating whether to suppress clicks on invoice bit 0 or 1
SUPPRESS_CREDITS Flag indicating whether to suppress credits on invoice bit 0 or 1
SUPPRESS_IMPRESSIONS Flag indicating whether to suppress impressions on invoice bit 0 or 1
SUPPRESS_LINE_AMOUNTS Flag indicating whether to suppress line amounts on invoice bit 0 or 1
IS_DIRECT_ADVERTISER Flag indicating if Advertiser is a Direct Advertiser bit 0 or 1
ORDER_EXTERNAL_ID External id of order varchar(50) Any string value