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 NameDescriptionData TypeSupported Values
@LASTSUCCESSFULRUNLast date/time that data was requestedsmalldatetimeValid datetime (e.g., 2018-12-31 12:00:00)

Output Fields

Field NameDescriptionData TypeSupported Values
ACCOUNT_EXEC_IDAccount Exec IDuniqueidentifierGUID
FIRST_NAMEAccount Exec’s first namevarchar(50)Any string value
LAST_NAMEAccount Exec’s last namevarchar(50)Any string value
PRINT_ABBREVIATIONAccount Exec’s code in WO Trafficvarchar(5)Any string value
ROW_STATESpecifies if Account Exec has been deleted or notint0, 1, or 2. 0 or 1 is active record. 2 is a soft deleted row.
CREATE_DATECreate Date of recordsmalldatetimeValid date/time value
UPDATE_DATEUpdate Date of recordsmalldatetimeValid date/time value
AE_GROUP_INTForeign Key of the Account Exec groupintJoin to WOMD.Lookups
USERNAMEAccount Exec’s WideOrbit loginvarchar(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 NameDescriptionData TypeSupported Values
@LASTSUCCESSFULRUNLast date/time that data was requestedsmalldatetimeValid datetime (e.g., 2018-12-31 12:00:00)

Output Fields

Field NameDescriptionData TypeSupported Values
ADDRESS_IDAddress IDuniqueidentifierGUID
ADDRESS_INTAddress ID, integer valueintAny integer value
ADDRESS_CITYAddress Cityvarchar(100)Any string value
ADDRESS_COUNTRYAddress Countryvarchar(100)Any string value
ADDRESS_LINE1Address Line 1varchar(100)Any string value
ADDRESS_LINE2Address Line 2varchar(100)Any string value
ADDRESS_LINE3Address Line 3varchar(100)Any string value
ADDRESS_NAMEAddress Namevarchar(100)Any string value
ADDRESS_STATEAddress Statevarchar(25)Any string value
ADDRESS_ZIPCODEAddress Zip Codevarchar(50)Any string value
ROW_STATESpecifies if Address has been deleted or notint0, 1, or 2.
CREATE_DATECreate Date of Address recordsmalldatetimeValid datetime (e.g., 2018-12-31 12:00:00)
CREATE_BYUsername of user who created Addressvarchar(250)Any string value
UPDATE_DATELast Update Date of AddresssmalldatetimeValid datetime (e.g., 2018-12-31 12:00:00)
UPDATE_BYUsername of user who updated Addressvarchar(250)Any string value
UPDATE_COUNTNumber of times Address has been UpdatedintAny 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 NameDescriptionData TypeSupported Values
@LASTSUCCESSFULRUNLast date/time that data was requestedsmalldatetimeValid datetime (e.g., 2018-12-31 12:00:00)

Output Fields

Field NameDescriptionData TypeSupported Values
ADVERTISER_BRAND_IDAdvertiser Brand IDuniqueidentifierGUID
BRAND_NAMEBrand Namevarchar(50)Any string value
BRAND_DESCRBrand Descriptionvarchar(250)Any string value
BRAND_SEPARATIONBrand Separation (in milliseconds)intAny integer value
ROW_STATESpecifies if EC name has been deleted or notint0, 1, or 2.
0 or 1 is active record.
2 is a soft deleted row.
CREATE_DATECreate Date of Advertiser Brand recordsmalldatetimeValid datetime (e.g., 2018-12-31 12:00:00)
UPDATE_DATELast Update Date of Advertiser BrandsmalldatetimeValid 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 NameDescriptionData TypeSupported Values
@LASTSUCCESSFULRUNLast date/time that data was requestedsmalldatetimeValid datetime (e.g., 2018-12-31 12:00:00)

Output Fields

Field NameDescriptionData TypeSupported Values
ADVERTISER_IDAdvertiser IDuniqueidentifierGUID
ECNAMEAdvertiser’s EC Namevarchar(250)Any string value
SOURCE_SYSTEMSource system where EC Name is usedvarchar(250)Any string value
ROW_STATESpecifies if EC name has been deleted or notint0, 1, or 2.
0 or 1 is active record.
2 is a soft deleted row.
UPDATE_DATEUpdate Date of recordsmalldatetimeValid 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 NameDescriptionData TypeSupported Values
@LASTSUCCESSFULRUNLast date/time that data was requestedsmalldatetimeValid datetime (e.g., 2018-12-31 12:00:00)

Output Fields

Field NameDescriptionData TypeSupported Values
ADVERTISER_IDAdvertiser IDuniqueidentifierGUID
ADVERTISER_NAMEAdvertiser’s Namevarchar(50)Any string value
NEW_BUSINESS_EXPIREAny revenue prior to this date is new business.smalldatetimeValid datetime (e.g., 2018-12-31 12:00:00)
ADVERTISER_REPORTING_NAMEAdvertiser’s Reporting Namevarchar(100)Any string value
TCODEAdvertiser’s external IDvarchar(50)Any string value
REVENUE_PRODUCT_CODE_IDForeign key of the Product Code used for reporting revenueuniqueidentifierGUID, Join to WOMD.ProductCodes
ADVERTISER_TYPE_INTForeign key of the Advertiser Type (optional)intJoin to WOMD.Lookups
ADDRESS_LINE1Advertiser’s address line 1varchar(100)Any string value
ADDRESS_LINE2Advertiser’s address line 2varchar(100)Any string value
ADDRESS_LINE3Advertiser’s address line 3varchar(100)Any string value
ADDRESS_CITYAdvertiser’s address cityvarchar(100)Any string value
ADDRESS_STATEAdvertiser’s address statevarchar(25)Any string value
ADDRESS_ZIPCODEAdvertiser’s address zip codevarchar(50)Any string value
ADDRESS_COUNTRYAdvertiser’s countryvarchar(100)Any string value
ROW_STATESpecifies if Advertiser has been deleted or notint0, 1, or 2.
0 or 1 is active record.
2 is a soft deleted row.
CREATE_DATEAdvertiser’s Create DatesmalldatetimeValid datetime (e.g., 2018-12-31 12:00:00)
UPDATE_DATEAdvertiser’s last Update DatesmalldatetimeValid 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 NameDescriptionData TypeSupported Values
@LASTSUCCESSFULRUNLast date/time that data was requestedsmalldatetimeValid datetime (e.g., 2018-12-31 12:00:00)

Output Fields

Field NameDescriptionData TypeSupported Values
AGENCY_IDAgency IDuniqueidentifierGUID
AGENCY_NAMEAgency’s Namevarchar(50)Any string value
TCODEAgency’s external IDvarchar(50)Any string value
ADDRESS_ZIPCODEAgency’s address zip codevarchar(50)Any string value
ADDRESS_LINE1Agency’s address line 1varchar(100)Any string value
ADDRESS_LINE2Agency’s address line 2varchar(100)Any string value
ADDRESS_CITYAgency’s address cityvarchar(100)Any string value
ADDRESS_STATEAgency’s address statevarchar(25)Any string value
MAIN_PHONE_NUMBERAgency’s main phone numbervarchar(50)Any string value
MAIN_FAX_NUMBERAgency’s main fax numbervarchar(50)Any string value
AGENCY_REPORTING_NAMEAgency’s Reporting Namevarchar(100)Any string value
AGENCY_TYPE_INTForeign key of the Agency Type (optional)intJoin to WOMD.Lookups
ORIGINAL_AGENCY_NAMEAgency’s Namevarchar(50)Any string value
DEFAULT_CASH_COMMISSIONDefault Commission percentage for cash ordersfloatFloating point numeric
ROW_STATESpecifies if Agency has been deleted or notint0, 1, or 2.
0 or 1 is active record.
2 is a soft deleted row.
CREATE_DATEAgency’s Create DatesmalldatetimeValid datetime (e.g., 2018-12-31 12:00:00)
UPDATE_DATEAgency’s last Update DatesmalldatetimeValid 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 NameDescriptionData TypeSupported Values
@LASTSUCCESSFULRUNLast date/time that data was requestedsmalldatetimeValid datetime (e.g., 2018-12-31 12:00:00)

Output Fields

Field NameDescriptionData TypeSupported Values
ADVERTISER_AGENCY_IDAgency/Advertiser relationship IDuniqueidentifierGUID
ADVERTISER_IDForeign key of Advertiser IDuniqueidentifierGUID, Join to WOMD.Advertisers
AGENCY_IDForeign key of Agency IDuniqueidentifierGUID, Join to WOMD.Agencies
ROW_STATESpecifies if Agency has been deleted or notint0, 1, or 2.
0 or 1 is active record.
2 is a soft deleted row.
CREATE_DATEAgency/Advertiser relationship Create DatesmalldatetimeValid datetime (e.g., 2018-12-31 12:00:00)
UPDATE_DATEAgency/Advertiser relationship last Update DatesmalldatetimeValid datetime (e.g., 2018-12-31 12:00:00)
BILLING_ADDRESS_INTForeign key for Billing AddressintJoin to WO_ADDRESSES
REMIT_ADDRESS_INTForeign key for Remit AddressintJoin to WO_ADDRESSES
CONTRACT_ADDRESS_INTForeign key for Contract AddressintJoin to WO_ADDRESSES
WEB_BILLING_ADDRESS_INTForeign key for Web Billing AddressintJoin 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 NameDescriptionData TypeSupported Values
@LASTSUCCESSFULRUNLast date/time that data was requestedsmalldatetimeValid datetime (e.g., 2018-12-31 12:00:00)

Output Fields

Field NameDescriptionData TypeSupported Values
CALENDAR_MONTH_IDCalendar Month IDuniqueidentifierGUID
CALENDAR_INTForeign key for Calendar Type (e.g., Broadcast, Calendar)intJoin to WOMD.Lookups
MONTH_NUMBERMonth number (e.g., 1 = January, 2 = February, etc.)intInteger value betweem 1 amd 12
QUARTER_NUMBERQuarter numberintInteger value betweem 1 amd 4
YEAR_NUMBERYear numberintAny integer value
DISPLAY_NAMEMonth name and year numbervarchar(50)Any string value
MONTH_START_DATEMonth start datesmalldatetimeValid datetime (e.g., 2018-12-31 12:00:00)
MONTH_END_DATEMonth end datesmalldatetimeValid datetime (e.g., 2018-12-31 12:00:00)
ROW_STATESpecifies if Calendar Month has been deleted or notint0, 1, or 2.
0 or 1 is active record.
2 is a soft deleted row.
CREATE_DATECalendar Month Create DatesmalldatetimeValid datetime (e.g., 2018-12-31 12:00:00)
UPDATE_DATECalendar Month last Update DatesmalldatetimeValid 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 NameDescriptionData TypeSupported Values
CHANNEL_IDChannel IDuniqueidentifierGUID
CHANNEL_INTChannel ID, integer valueintAny integer value
STATION_IDForeign key of the Station that Channel belongs touniqueidentifierGUID, Join to WOMD.Stations
CHANNEL_NAMEChannel Namevarchar(5)Any string value
CHANNEL_REVENUE_WEIGHTRevenue weight of channelintAny integer value
ACTIVE_LOG_LENGTHHow far in the future new logs are createdintAny integer value
ROW_STATESpecifies if Calendar Month has been deleted or notint0, 1, or 2.
0 or 1 is active record.
2 is a soft deleted row.
FIRST_LOG_DATEFirst log date of ChannelsmalldatetimeValid datetime (e.g., 2018-12-31 12:00:00)
LAST_LOG_DATELast log date of ChannelsmalldatetimeValid datetime (e.g., 2018-12-31 12:00:00)
FIRST_FINALIZED_LOG_DATEFirst finalized log date of ChannelsmalldatetimeValid datetime (e.g., 2018-12-31 12:00:00)
LAST_FINALIZED_LOG_DATELast finalized log date of ChannelsmalldatetimeValid datetime (e.g., 2018-12-31 12:00:00)
UPDATE_DATEChannel last Update DatesmalldatetimeValid 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 NameDescriptionData TypeSupported Values
@LASTSUCCESSFULRUNLast date/time that data was requestedsmalldatetimeValid datetime (e.g., 2018-12-31 12:00:00)

Output Fields

Field NameDescriptionData TypeSupported Values
INVENTORY_CODE_IDInventory Code IDuniqueidentifierGUID
INVENTORY_CODE_NAMEInventory Code Namevarchar(50)Any string value
INVENTORY_CODE_INTInventory Code ID, integer valueintAny integer value
INVENTORY_CODE_EXTERNAL_IDExternal ID of the Inventory Codevarchar(50)Any string value
PARENT_INVENTORY_CODE_INTInteger Foreign key for the Parent Inventory CodeintJoin to WOMD.InventoryCodes
PARENT_INVENTORY_CODE_IDGUID Foreign key for the Parent Inventory CodeuniqueidentifierGUID, Join to WOMD.InventoryCodes
DAYPART_INTForeign key for Inventory Code’s DaypartintJoin to WOMD.Lookups
IS_SELLGROUPFlag indicating if the Inventory Code is a SellgroupintAny integer value
REPORTING_NAMEInventory Code’s Reporting namevarchar(100)Any string value
SELLING_NAME_INTForeign key for Inventory Code’s Selling NameintJoin to WOMD.Lookups
ROW_STATESpecifies if Inventory Code has been deleted or notint0, 1, or 2.
0 or 1 is active record.
2 is a soft deleted row.
CREATE_DATECreate Date of Inventory CodesmalldatetimeValid datetime (e.g., 2018-12-31 12:00:00)
CREATE_BYUsername of user who created Inventory Codevarchar(250)Any string value
UPDATE_DATELast Update Date of Inventory CodesmalldatetimeValid datetime (e.g., 2018-12-31 12:00:00)
UPDATE_BYUsername of user who last updated Inventory Codevarchar(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 NameDescriptionData TypeSupported Values
LOOKUP_INTLookup ID, integer valueintAny integer value
LOOKUP_GUIDLookup IDuniqueidentifierGUID
LOOKUP_TYPEType of Lookup (e.g., Advertiser Type, Agency Type, etc.)varchar(250)Any string value
LOOKUP_VALUELookup Valuevarchar(250)Any string value
LOOKUP_DISPLAYLookup Display, what shows in WO Trafficvarchar(250)Any string value
LOOKUP_DESCRLookup Descriptionvarchar(250)Any string value
LOOKUP_SORTLookup Sortvarchar(50)Any string value
ROW_STATESpecifies if Lookup has been deleted or notint0, 1, or 2.
0 or 1 is active record.
2 is a soft deleted row.
UPDATE_DATELast Update Date of LookupsmalldatetimeValid 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 NameDescriptionData TypeSupported Values
@LASTSUCCESSFULRUNLast date/time that data was requestedsmalldatetimeValid datetime (e.g., 2018-12-31 12:00:00)

Output Fields

Field NameDescriptionData TypeSupported Values
MATERIAL_IDMaterial IDuniqueidentifierGUID
MATERIAL_NAMEMaterial Namevarchar(50)Any string value
MATERIAL_TITLEMaterial TitleuniqueidentifierGUID
MATERIAL_LENGTHMaterial Length (in milliseconds)intAny integer value
ADVERTISER_IDForeign key of Material’s AdvertiseruniqueidentifierGUID, Join to WOMD.Advertisers
PRODUCT_DESCRMaterial’s Product Descriptionvarchar(50)Any string value
COOP_CODEMaterial Co-op Codevarchar(50)Any string value
ISCI_CODEMaterial ISCI Codevarchar(50)Any string value
HOUSE_NAMEMaterial House Namevarchar(50)Any string value
FCC_TYPE_INTForeign key for Material Content TypeintJoin to WOMD.Lookups
FCC_SOURCE_INTForeign Key for Material Content SourceintJoin to WOMD.Lookups
DISTRIBUTION_SOURCEMaterial Distribution Sourcevarchar(50)Any string value
USEABLE_FOR_FILLERFlag indicating if Material can be used for FillerintAny integer value
ROW_STATESpecifies if the Material has been deleted or notint0, 1, or 2.
0 or 1 is active record.
2 is a soft deleted row.
CREATE_DATECreate Date of MaterialsmalldatetimeValid datetime (e.g., 2018-12-31 12:00:00)
UPDATE_DATELast Update Date of MaterialsmalldatetimeValid datetime (e.g., 2018-12-31 12:00:00)
WO_FIELD1Material Field 1varchar(50)Any string value
WO_FIELD2Material Field 2varchar(50)Any string value
WO_FIELD3Material Field 3varchar(50)Any string value
WO_FIELD4Material Field 4varchar(50)Any string value
WO_FIELD5Material Field 5varchar(50)Any string value
MATERIAL_INTInteger ID of the MaterialintAny integer value
MATERIAL_GROUP_NAMEMaterial Group Namevarchar(10)Any string value
MATERIAL_GROUP_DESCRIPTIONMaterial Group Descriptionvarchar(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 NameDescriptionData TypeSupported Values
@LASTSUCCESSFULRUNLast date/time that data was requestedsmalldatetimeValid datetime (e.g., 2018-12-31 12:00:00)

Output Fields

Field NameDescriptionData TypeSupported Values
ORDER_IDOrder IDuniqueidentifierGUID
ORDER_NUMBEROrder Numbervarchar(50)Any string value
ADVERTISER_IDForeign Key of Order’s AdvertiseruniqueidentifierGUID, Join to WOMD.Advertisers
AGENCY_IDForeign Key of Order’s AgencyuniqueidentifierGUID, Join to WOMD.Agencies
CANCEL_DATEDate order was cancel (only if cancelled)smalldatetimeValid datetime (e.g., 2018-12-31 12:00:00)
ORDER_IS_COOPFlag indicating if Order is a Co-op OrdertinyintSmall integer value
ORDER_IS_CASHFlag indicating if Order is a Cash Orderbit0 or 1
IS_CASH_IN_ADVANCEFlag indicating if Order is Cash In Advancebit0 or 1
CENTRAL_ORDERFlag indicating if Order is create via WO Centralbit0 or 1
FLIGHT_START_DATEStart Date of the OrdersmalldatetimeValid datetime (e.g., 2018-12-31 12:00:00)
FLIGHT_END_DATEEnd Date of the OrdersmalldatetimeValid datetime (e.g., 2018-12-31 12:00:00)
SALES_REGION_INTForeign Key of Order’s Sales RegionintJoin to WOMD.Lookups
SALES_OFFICE_IDForeign Key of Order’s Sales OfficeuniqueidentifierJoin to WOMD.SalesOffices
BILLING_GROUP_INTForeign Key of Order’s Billing GroupintJoin to WOMD.BillingGroup
DEMO_CODE_INTForeign Key of Order’s DemographicintJoin to WOMD.Lookups
SHARE_OF_ORDERShare of the advertiser’s buytinyintAny integer value
ROW_STATESpecifies if Order has been deleted or notint0, 1, or 2.
0 or 1 is active record.
2 is a soft deleted row.
CREATE_DATECreate Date of OrdersmalldatetimeValid datetime (e.g., 2018-12-31 12:00:00)
UPDATE_DATELast Update Date of OrdersmalldatetimeValid datetime (e.g., 2018-12-31 12:00:00)
ORDER_INTOrder ID, integer valueintAny integer value
FIRST_APPROVAL_DATEOrder’s First Approval DatesmalldatetimeValid datetime (e.g., 2018-12-31 12:00:00)
ORDER_TYPE_INTForeign Key of Order TypeintJoin to WOMD.Lookups
AGENCY_COMMISSIONOrder’s Agency CommissionfloatFloating point numeric
UNITCODE_INTForeign Key of Order’s Unit CodeintJoin to WOMD.UnitCodes
NEW_BUSINESS_DATENew Business DatesmalldatetimeValid datetime (e.g., 2018-12-31 12:00:00)
HIATUS_PERIODSHiatus Periodsvarchar(1000)Any string value
HAS_MATERIAL_INSTRUCTIONFlag indicating if Order has Material Instructionbit0 or 1
CREATE_BYUsername who Created Ordervarchar(250)Any string value
BILLING_CALENDAR_INTForeign Key of Order’s Billing CalendarintJoin to WOMD.Lookups
PRODUCT_CODE_IDForeign Key of Order’s Product CodeuniqueidentifierGUID, Join to WOMD.ProductCodes
EXTERNAL_IDOrder’s External IDvarchar(50)Any string value
PRODUCT_DESCRIPTIONOrder’s Product Descriptionvarchar(50)Any string value
ALT_ORDER_NUMBEROrder’s Alternate Order Numbervarchar(50)Any string value
DEFAULT_CHANNEL_INTForeign Key for Order’s ChannelintJoin to WOMD.Channels
CLIENT_TRACKING_NUMBEROrder’s Client Tracking Numbervarchar(50)Any string value
PRIMARY_ACCOUNT_EXEC_IDForeign Key for Order’s Primary Account ExecuniqueidentifierGUID, Join to WOMD.AccountExec
INTERNET_TRAFFICKER_INTForeign Key for Digital Order’s TraffickerintJoin 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 NameDescriptionData TypeSupported Values
@LASTSUCCESSFULRUNLast date/time that data was requestedsmalldatetimeValid datetime (e.g., 2018-12-31 12:00:00)

Output Fields

Field NameDescriptionData TypeSupported Values
ACCOUNT_EXECUTIVE_IDForeign Key for Account ExecuniqueidentifierGUID, Join to WOMD.AccountExec
ORDER_INTForeign Key for OrderintJoin to WOMD.Order
START_DATEStart date of Account Exec’s commission periodsmalldatetimeValid datetime (e.g., 2018-12-31 12:00:00)
END_DATEEnd date of Account Exec’s commission periodsmalldatetimeValid datetime (e.g., 2018-12-31 12:00:00)
SALES_OFFICE_IDForeign Key for Account Exec’s Sales OfficeuniqueidentifierGUID, Join to WOMD.SalesOffices
SALES_REGION_INTForeign Key for Account Exec’s Sales RegionintJoin to WOMD.Lookups
COMMISSION_PERCENTAccount Exec’s commission ratefloatFloating point numeric
IS_PRIMARY_AEFlag indicating if Account Exec is the Primarybit0 or 1
CREATE_DATECreate Date of Order Account Exec recordsmalldatetimeValid datetime (e.g., 2018-12-31 12:00:00)
UPDATE_DATELast Update Date of Order Account Exec recordsmalldatetimeValid 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 NameDescriptionData TypeSupported Values
ORDER_BILL_PLAN_IDOrder Bill Plan IDuniqueidentifierGUID
ORDER_IDForeign Key for Bill Plan’s OrderuniqueidentifierGUID, Join to WOMD.Order
ORDER_INTForeign Key for Bill Plan’s Order, integer valueintJoin to WOMD.Order
SEQ_NUM OrderBill Plan NumberintAny integer value
UNIT_START_DATEStart Date of Bill PlansmalldatetimeValid datetime (e.g., 2018-12-31 12:00:00)
UNIT_END_DATEEnd Date of Bill PlansmalldatetimeValid datetime (e.g., 2018-12-31 12:00:00)
NUMBER_OF_UNITSNumber of Units in Bill PlanintAny integer value
INTERNAL_AMOUNTInternal Amount of Bill PlanmoneyMoney value
EXTERNAL_AMOUNTExternal Amount of Bill PlanmoneyMoney value
IS_USER_OVERRIDEUser altered Bill Planbit0 or 1
INVOICE_REVISIONInvoice Revision numbersmallintAny small integer value
ROW_STATESpecifies if Bill Plan has been deleted or notint0, 1, or 2. 0 or 1 is active record. 2 is a soft deleted row.
CREATE_DATECreate Date of Order Bill Plan recordsmalldatetimeValid datetime (e.g., 2018-12-31 12:00:00)
CREATE_BYUsername of user who created Bill Planvarchar(250)Any string value
UPDATE_DATELast Update Date of Order Bill Plan recordsmalldatetimeValid datetime (e.g., 2018-12-31 12:00:00)
UPDATE_BYUsername of user who updated Bill Planvarchar(250)Any string value
AGENCY_IDForeign Key for Bill Plan’s AgencyuniqueidentifierGUID, Join to WOMD.Agencies
ADVERTISER_IDForeign Key for Bill Plan’s AdvertiseruniqueidentifierGUID, Join to WOMD.Advertisers
ORDER_SHAREShare of the advertiser’s buyfloatFloating point numeric
IS_PLACEHOLDERFlag indicating if Bill Plan is Placeholderbit0 or 1
BILLING_ADDRESS_INTForeign Key for Agency’s Billing AddressintJoin to WO_ADDRESSES
REMIT_ADDRESS_INTForeign Key for Agency’s Remit AddressintJoin to WO_ADDRESSES
AGENCY_COMMISSIONAgency’s CommissionfloatFloating point numeric
BILLPLAN_IS_CASHFlag indicating if Bill Plan is Cashbit0 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 NameDescriptionData TypeSupported Values
REPORT_DATEReporting date, first day of the month payment is receivedsmalldatetimeValid datetime (e.g., 2018-12-31 12:00:00)
AMOUNT_PMTTotal amount of cash paymentsmoneyMoney
COUNT_PMTTotal number of cash paymentsintAny integer value
AMOUNT_CCTotal amount of credit card paymentsmoneyMoney
COUNT_CCTotal number of credit card paymentsintAny 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 NameDescriptionData TypeSupported Values
@LASTSUCCESSFULRUNLast date/time that data was requestedsmalldatetimeValid datetime (e.g., 2018-12-31 12:00:00)

Output Fields

Field NameDescriptionData TypeSupported Values
PRODUCT_CODE_IDProduct Code IDuniqueidentifierGUID
PARENT_PRODUCT_CODE_IDForeign Key for Product Code’s ParentuniqueidentifierGUID, Join back to WOMD.ProductCodes
PRODUCT_CODE_NAMEProduct Code Namevarchar(50)Any string value
PRODUCT_CODE_DESCRProdcut Code Descriptionvarchar(250)Any string value
ROW_STATESpecifies if Product Code has been deleted or notint0, 1, or 2. 0 or 1 is active record. 2 is a soft deleted row.
CREATE_DATECreate Date of Product Code recordsmalldatetimeValid datetime (e.g., 2018-12-31 12:00:00)
UPDATE_DATELast Update Date of Product CodesmalldatetimeValid datetime (e.g., 2018-12-31 12:00:00)
CREATE_BYUsername of user who created Product Codevarchar(250)Any string value
UPDATE_BYUsername of user who updated Product Codevarchar(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 NameDescriptionData TypeSupported Values
@LASTSUCCESSFULRUNLast date/time that data was requestedsmalldatetimeValid datetime (e.g., 2018-12-31 12:00:00)

Output Fields

Field NameDescriptionData TypeSupported Values
PROGRAM_IDProgram IDuniqueidentifierGUID
PROGRAM_INTProgram ID, integer valueintAny integer value
PROGRAM_NAMEProgram Namevarchar(250)Any string value
TV_RATING_INTForeign Key for Program’s TV RatingintJoin to WOMD.Lookups
ROW_STATESpecifies if Program has been deleted or notint0, 1, or 2. 0 or 1 is active record. 2 is a soft deleted row.
CREATE_DATECreate Date of Program recordsmalldatetimeValid datetime (e.g., 2018-12-31 12:00:00)
UPDATE_DATELast Update Date of Programvarchar(250)Any string value
PROGRAM_EXTERNAL_IDProgram’s External IDuniqueidentifierGUID
GENRE_INTForeign Key for Program’s GenreintJoin 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 NameDescriptionData TypeSupported Values
SALES_OFFICE_IDSales Office IDuniqueidentifierGUID
SALES_OFFICE_ABBREVIATIONSales Office Abbreviationvarchar(20)Any string value
SALES_OFFICE_NAMESales Office Namevarchar(50)Any string value
MAILING_ADDRESS_IDForeign Key for Sales Office’s Mailing AddressuniqueidentifierGUID, Join to WO_ADDRESSES
REMIT_ADDRESS_IDForeign Key for Sales Office’s Remit AddressuniqueidentifierGUID, Join to WO_ADDRESSES
SALES_REGION_INTSales office ID (integer value)intAny integer value
MAIN_PHONE_NUMBERSales Office’s Main Phone Numbervarchar(50)Any string value
MAIN_FAX_NUMBERSales Office’s Fax Numbervarchar(50)Any string value
ROW_STATESpecifies if Sales Office has been deleted or notint0, 1, or 2. 0 or 1 is active record. 2 is a soft deleted row.
CREATE_DATECreate Date of Sales Office recordsmalldatetimeValid datetime (e.g., 2018-12-31 12:00:00)
CREATE_BYUsername of user who created Sales Officevarchar(250)Any string value
UPDATE_DATELast Update Date of Sales OfficesmalldatetimeValid datetime (e.g., 2018-12-31 12:00:00)
UPDATE_BYUsername of user who updated Sales Officevarchar(250)Any string value
STATION_ARRAYAn Array representing the Sales Office’s Stationsbinary(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 NameDescriptionData TypeSupported Values
NoOfUsersNumber of active Users created in WideOrbitintAny integer value
SQLVersionSQL Server version where WideOrbit is runningvarchar(512)Any string value
SQLDateOffsetNumber of hours from UTC time; based on time of SQL Server machinedecimalAny decimal number
SQLFileSizeFile Size of WideOrbit databaseintAny integer value
TrafficVersionVersion of WideOrbit customer is runningvarchar(15)Any string value
TrafficBuildBuild number of WideOrbit customer is runningvarchar(15)Any string value
CentralVersionWideOrbit Central Version KeybigintAny big integer value
IsNetworkFlag to indicate whether customer is running WideOrbit Networkbit0 or 1
SQLCompModeCompatibility mode of SQL ServerintAny 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 NameDescriptionData TypeSupported Values
STATION_IDStation IDuniqueidentifierGUID
STATION_CALL_LETTERSStation’s Call Lettersvarchar(25)Any string value
STATION_NAMEStation’s Namevarchar(50)Any string value
AFFILIATIONForeign Key for Station’s AffiliationintJoin to WOMD.Lookups
STATION_MAIN_PHONEStation’s Main Phonevarchar(50)Any string value
STATION_BILLING_PHONEStation’s Billing Phonevarchar(50)Any string value
STATION_WEB_SITEStation’s Web Sitevarchar(50)Any string value
ACCOUNTING_CLOSE_DATEStation’s Last Accounting Close DatesmalldatetimeValid datetime (e.g., 2018-12-31 12:00:00)
STATION_INTStation ID, integer valueintAny integer value
VERIFIED_CLOSE_DATEStation’s Last Verified Close DatesmalldatetimeValid datetime (e.g., 2018-12-31 12:00:00)
MARKETStations’ Marketvarchar(50)Any string value
REGIONStation’s Regionvarchar(50)Any string value
STATION_TYPEForeign Key for Station Typeint1 = Airtime, 2 = Internet, 3 = WO Streaming
STATION_MAIN_ADDRESS_INTForeign Key for Station’s Main AddressintJoin to WO_ADDRESSES
ROW_STATESpecifies if Station has been deleted or notint0, 1, or 2. 0 or 1 is active record. 2 is a soft deleted row.
CREATE_DATECreate Date of Station recordsmalldatetimeValid datetime (e.g., 2018-12-31 12:00:00)
UPDATE_DATELast Update Date of StationsmalldatetimeValid datetime (e.g., 2018-12-31 12:00:00)
ADDRESS_NAMEStation’s Address Namevarchar(100)Any string value
ADDRESS_LINE1Station’sMain Address, Address Line 1varchar(100)
ADDRESS_LINE2Station’sMain Address, Address Line 2varchar(100)
ADDRESS_LINE3Station’sMain Address, Address Line 3varchar(100)
ADDRESS_CITYAddress’s Cityvarchar(100)Any string value
ADDRESS_STATEStation’sMain Address, Statevarchar(25)
ADDRESS_ZIPCODEStation’sMain Address, Zipcodevarchar(50)
ADDRESS_COUNTRYStation’sMain Address, Countryvarchar(100)
EI_BANDStation’s Billing Group EI Bandvarchar(25)Any string value
EI_MEDIA_TYPEStation’s Billing Group EI Media Typevarchar(25)Any string value
EI_NAMEStation’s Billing Group EI Namevarchar(25)Any string value
REPORTING_NAMEStation’s Reporting Namevarchar(100)Any string value
STATION_GROUP_INTForeign Key for Station’s Bill GroupintJoin to WOMD.BillingGroup
UNIT_CODE_INTForeign Key for Station’s default Unit CodeintJoin to WOMD.UnitCodes
BG_STATION_CALL_LETTERSStation’s Billing Group Call Lettersvarchar(25)Any string value
IS_WOX_ENABLEDFlag for whether Billing Group is WO Exchange enabledtinyint0 or 1
IS_DEFAULT_STATIONFlag for whether Station is Billing Group’s default stationbit0 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 NameDescriptionData TypeSupported Values
SYSTEM_SETTING_IDSystem Setting IDuniqueidentifierGUID
SYSTEM_NAMESystem Namevarchar(50)Any string value
SYSTEM_CODESystem Codevarchar(5)Any string value
FISCAL_CALENDAR_INTForeign Key for System’s Fiscal CalendarintJoin to WOMD.Lookups
DEFAULT_DIGITAL_REVENUE_CODE_INTForeign Key for Default Digital Revenue CodeintJoin to WOMD.Lookups
DEFAULT_DIGITAL_REVENUE_CODE2_INTForeign Key for Default Digital Revenue Code2intJoin to WOMD.Lookups
DEFAULT_DIGITAL_REVENUE_CODE3_INTForeign Key for Default Digital Revenue Code3intJoin to WOMD.Lookups
DEFAULT_DIGITAL_ORDER_TYPE_INTForeign Key for Default Digital Order TypeintJoin to WOMD.Lookups
SYSTEM_LICENSESystem LicensetextAny large text value
ROW_STATESpecifies if System Setting has been deleted or notint0, 1, or 2. 0 or 1 is active record. 2 is a soft deleted row.
CREATE_DATECreate Date of System Setting recordsmalldatetimeValid datetime (e.g., 2018-12-31 12:00:00)
CREATE_BYUsername of user who created System Settingvarchar(250)Any string value
UPDATE_DATELast Update Date of System SettingsmalldatetimeValid datetime (e.g., 2018-12-31 12:00:00)
UPDATE_BYUsername of user who updated System Settingvarchar(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 NameDescriptionData TypeSupported Values
UNIT_CODE_IDUnit Code IDuniqueidentifierGUID
UNIT_CODE_INTUnit Code ID, integer valueintAny integer value
UNIT_CODE_CODECode Namevarchar(250)Any string value
UNIT_CODE_DISPLAYDisplay Namevarchar(250)Any string value
UNIT_CODE_SORTSortvarchar(50)Any string value
UNIT_CODE_DESCRIPTIONDescriptionvarchar(250)Any string value
EXTERNAL_IDExternal IDvarchar(250)Any string value
REPORTING_NAMEReporting Namevarchar(250)Any string value
ROW_STATESpecifies if System Setting has been deleted or notint0, 1, or 2. 0 or 1 is active record. 2 is a soft deleted row.
CREATE_DATECreate Date of System Setting recordsmalldatetimeValid datetime (e.g., 2018-12-31 12:00:00)
CREATE_BYUsername of user who created System Settingvarchar(250)Any string value
UPDATE_DATELast Update Date of System SettingsmalldatetimeValid datetime (e.g., 2018-12-31 12:00:00)
UPDATE_BYUsername of user who updated System Settingvarchar(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 NameDescriptionData TypeSupported Values
@LASTSUCCESSFULRUNLast date/time that data was requestedsmalldatetimeValid datetime (e.g., 2018-12-31 12:00:00)

Output Fields

Field NameDescriptionData TypeSupported Values
SECURITY_USER_IDSecurity User IDuniqueidentifierGUID
EMAIL_ADDRESSUser’s Email Addressvarchar(50)Any string value
TITLEUser’s Titlevarchar(50)Any string value
DEPARTMENTUser’s Departmentvarchar(50)Any string value
IS_SUPER_USERFlag indicating whether user is a Super Userint0 or 1
IS_DOMAIN_LOGINFlag indicating whether this is a Domain Loginint0 or 1
LAST_LOGINLast date/time that user logged into WideOrbitsmalldatetimeValid datetime (e.g., 2018-12-31 12:00:00)
INVALID_LOGIN_ATTEMPTSNumber of Invalid Login AttemptsintAny integer value
CREATE_DATECreate Date of User recordsmalldatetimeValid datetime (e.g., 2018-12-31 12:00:00)
UPDATE_DATELast Update Date of User recordsmalldatetimeValid datetime (e.g., 2018-12-31 12:00:00)
ROW_STATESpecifies if System Setting has been deleted or notint0, 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 NameDescriptionData TypeSupported Values
@LASTSUCCESSFULRUNLast date/time that data was requestedsmalldatetimeValid datetime (e.g., 2018-12-31 12:00:00)

Output Fields

Field NameDescriptionData TypeSupported Values
CHANNEL_AIR_DATE_IDChannel Air Date IDuniqueidentifierGUID
CHANNEL_INTForeign Key for the Air Date’s ChannelintJoin to WOMD.Channels
AIR_DATEAir Date of LogsmalldatetimeValid datetime (time is converted to 00:00:00)
SIGN_ONSign On time for Air Date, expressed as milliseconds after midnightintAny integer value
SIGN_OFFSign Off time for Air Date, expressed as milliseconds after midnightint0 or 1
IS_ALTEREDFlag indicating whether the Log has been modifiedint0 or 1
IS_FINALIZEDFlag indicating whether the Log has been finalizedint0 or 1
FINALIZE_COUNTNumber of time Log was finalizedintAny integer value
FINALIZE_DATEThe last Date the Log was finalizedsmalldatetimeValid datetime (e.g., 2018-12-31 12:00:00)
RECONCILE_IN_PROGRESSFlag indicating whether Log has begun Reconcilation processint0 or 1
IS_RECONCILEDFlag indicating whether Log has been completely Reconciledint0 or 1
IS_INVOICEDFlag indicating whether Log has been Invoicedint0 or 1
IS_FROZEN_TO_ORDERSFlag indicating whether the Log is Frozen to changes to Ordersint0 or 1
IS_LOCKEDFlag indicatng whether the Log is Lockedint0 or 1
EXTENDED_LOG_ACTUAL_STARTExtended Log Start Time (for Daylight Savings Time)intAny integer value
EXTENDED_LOG_DISPLAY_STARTExtended Log Start Time that is Displayed (for Daylight Savings Time)intAny integer value
EXTENDED_LOG_TYPEExtended Log Typeint0 or 1
IS_DELETEDFlag indicating whether Log has been Deletedbit0 or 1
CREATE_DATECreate Date of System Setting recordsmalldatetimeValid datetime (e.g., 2018-12-31 12:00:00)
CREATE_BYUsername of user who created System Settingvarchar(250)Any string value
UPDATE_DATELast Update Date of System SettingsmalldatetimeValid datetime (e.g., 2018-12-31 12:00:00)
UPDATE_BYUsername of user who updated System Settingvarchar(250)Any string value
UPDATE_COUNTNumber of times Log has been UpdatedintAny integer value
IS_READY_FOR_PROMOFlag indicating whether Log is Ready to place Promo’sint0 or 1
IS_INSERTION_WINDOWS_LOCKEDFlag indicating whether Insertion Windows are Lockedint0 or 1
PLAYLIST_VERSIONPlaylist Version numbersmallintAny integer value
IS_VERIFIEDFlag indicating whether Log has been Verifiedint0 or 1
PLAYLIST_STATUSPlaylist StatussmallintAny integer value
IS_FROZEN_TO_FORMAT_SCHEDULESFlag indicating whether Log is Frozen to Format Schedule changesint0 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 NameDescriptionData TypeSupported Values
@LASTSUCCESSFULRUNLast date/time that data was requestedsmalldatetimeValid datetime (e.g., 2018-12-31 12:00:00)

Output Fields

Field NameDescriptionData TypeSupported Values
INTERNET_PRODUCT_IDInternet Product IDuniqueidentifierGUID
INTERNET_PRODUCT_INTInternet Product ID, integer valueintAny integer value
CHANNEL_INTForeign Key for Internet Product’s ChannelintJoin to WOMD.Channels
INVENTORY_CODE_INTForeign Key for Internet Product’s Inventory CodeintJoin to WOMD.InventoryCodes
AD_SLOT_INTForeign Key for Internet Product’s Ad SlotintJoin to WOMD.Lookups
AD_TYPE_INTForeign Key for Internet Product’s Ad TypeintJoin to WOMD.Lookups
START_DATEStart Date of Internet ProductsmalldatetimeValid datetime (e.g., 2018-12-31 12:00:00)
END_DATEEnd Date of Internet ProductsmalldatetimeValid datetime (e.g., 2018-12-31 12:00:00)
NAMEName of Internet Productvarchar(50)Any string value
SORTSort of Internet Productvarchar(50)Any string value
EXTERNAL_DESCRIPTIONExternal Description of Internet Productvarchar(250)Any string value
KEYWORDSKeywords of Internet Productvarchar(max)Ad Server commands
IS_DELETEDFlag indicating whether Internet Product is Deletedbit0 or 1
CREATE_DATECreate Date of System Setting recordsmalldatetimeValid datetime (e.g., 2018-12-31 12:00:00)
CREATE_BYUsername of user who created System Settingvarchar(250)Any string value
UPDATE_DATELast Update Date of System SettingsmalldatetimeValid datetime (e.g., 2018-12-31 12:00:00)
UPDATE_BYUsername of user who updated System Settingvarchar(250)Any string value
PRODUCT_TYPE_INTForeign Key of Internet Product TypeintJoin to WOMD.Lookups
TARGETINGTargeting of Internet Productvarchar(max)int value of target (join to WOMD.Lookups) and Target text
DEFAULT_RATEDefault Rate of Internet Productint0 = CPM, actuals; 1 = CPC; 2 = Flat fee; 3 = CPD, daily; 4 = CPP; 5 = CPD, weekly; 6 = CPD, monthly; 7 = CPM, booked
ALLOW_IMP_GOALAllow Goalint0 or 1
DIGITAL_TYPEDigital Type of Internet Productint1 = Internet, 2 = Streaming
GOAL_TYPEGoal Type of Internet Productint1 = 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 NameDescriptionData TypeSupported Values
@LASTSUCCESSFULRUNLast date/time that data was requestedsmalldatetimeValid datetime (e.g., 2018-12-31 12:00:00)

Output Fields

Field NameDescriptionData TypeSupported Values
INVENTORY_TYPE_IDInventory Type IDuniqueidentifierGUID
INVENTORY_TYPE_CODEInventory Type Codevarchar(50)Any string value
INVENTORY_TYPE_DESCRInventroy Type Descriptionvarchar(50)Any string value
INVENTORY_TYPE_INTInventory Type ID, integer valueintAny integer value
ROW_STATESpecifies if System Setting has been deleted or notint0, 1, or 2. 0 or 1 is active record. 2 is a soft deleted row.
CREATE_DATECreate Date of System Setting recordsmalldatetimeValid datetime (e.g., 2018-12-31 12:00:00)
UPDATE_DATELast Update Date of System SettingsmalldatetimeValid 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 NameDescriptionData TypeSupported Values
@LASTSUCCESSFULRUNLast date/time that data was requestedsmalldatetimeValid datetime (e.g., 2018-12-31 12:00:00)

Output Fields

Field NameDescriptionData TypeSupported Values
BILLING_GROUP_IDBilling Group IDuniqueidentifierGUID
BILLING_GROUP_INTBilling Group ID, integer valueintAny integer value
BILLING_GROUP_NAMEBilling Group Namevarchar(50)Any string value
BILLING_GROUP_DESCRBilling Group Descriptionvarchar(250)Any string value
STATION_INTForeign Key for Billing Group’s StationintJoin to WOMD.Stations
ALT_CALL_LETTERSBilling Group’s Station Call Lettersvarchar(25)Any string value
ALT_STATION_NAMEBilling Group’s Station Namevarchar(50)Any string value
ALT_WEB_SITEBilling Group’s Websitevarchar(50)Any string value
EI_NAMEElectronic Invoicing Namevarchar(25)Any string value
EI_MEDIA_TYPEElectronic Invoicing Media Typevarchar(25)Any string value
EI_BANDElectronic Invoicing Bandvarchar(25)Any string value
EC_NAMEElectronic Contracting Namevarchar(25)Any string value
IS_DELETEDFlag indicating whether Internet Product is Deletedbit0 or 1
CREATE_DATECreate Date of System Setting recordsmalldatetimeValid datetime (e.g., 2018-12-31 12:00:00)
CREATE_BYUsername of user who created System Settingvarchar(250)Any string value
UPDATE_DATELast Update Date of System SettingsmalldatetimeValid datetime (e.g., 2018-12-31 12:00:00)
UPDATE_BYUsername of user who updated System Settingvarchar(250)Any string value
ENABLED_FOR_WOXFlag for whether Billing Group is WO Exchange enabledtinyint0 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 NameDescriptionData TypeSupported Values
@LASTSUCCESSFULRUNLast date/time that data was requestedsmalldatetimeValid datetime (e.g., 2018-12-31 12:00:00)

Output Fields

Field NameDescriptionData TypeSupported Values
SELLING_ELEMENT_IDSelling Element IDuniqueidentifierGUID
SELLING_ELEMENT_INTSelling Element ID, integer valueintAny integer value
SELLING_ELEMENT_NAMESelling Element Namevarchar(50)Any string value
SELLING_ELEMENT_CODESelling Element Codevarchar(10)Any string value
SELLING_ELEMENT_SORTSelling Element Sortvarchar(10)Any string value
REPORTING_NAMESelling Element Reporting Namevarchar(100)Any string value
IMPRESSIONS_IN_POSTINGFlag indicating whether Impressions are in Postingbit0 or 1
HAS_IMPRESSIONS Flagindicating whether Selling Element has Impressionsbit0 or 1
SUPPRESS_INVOICE_LINEFlag indicating whether to suppress in Invoice Linebit0 or 1
DEFAULT_INVENTORY_TYPE_INTForeign Key for Default Inventory TypesmallintJoin to WOMD.InventoryType
DEFAULT_BREAK_CODE_INTForeign Key for Default Break CodesmallintJoin to WOMD.Lookups
DEFAULT_SELLING_NAME_RATE_FACTORSelling Name Rate FactorsmallintBetween 0 and 100
DEFAULT_LENGTH1Default Length1 in millisecondsintAny integer value
DEFAULT_LENGTH2Default Length2 in millisecondsintAny integer value
DEFAULT_LENGTHSDefault Lengthsvarchar(max)Any string value
STATION_INTForeign Key for Selling Element’s StationintJoin to WOMD.Stations
IS_DELETEDFlag indicating whether Internet Product is Deletedbit0 or 1
CREATE_DATECreate Date of System Setting recordsmalldatetimeValid datetime (e.g., 2018-12-31 12:00:00)
UPDATE_DATELast Update Date of System SettingsmalldatetimeValid 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 NameDescriptionData TypeSupported Values
@LASTSUCCESSFULRUNLast date/time that data was requestedsmalldatetimeValid datetime (e.g., 2018-12-31 12:00:00)

Output Fields

Field NameDescriptionData TypeSupported Values
STATION_CALL_LETTERSStation Call Lettervarchar(25)Station call letters
INVOICE_COUNTNumber of invoices generated since Last Successful RunintAny 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 NameDescriptionData TypeSupported Values
@LASTSUCCESSFULRUNLast date/time that data was requestedsmalldatetimeValid datetime (e.g., 2018-12-31 12:00:00)

Output Fields

Field NameDescriptionData TypeSupported Values
REPORT_DATA_REVENUE_IDReport Data Revenue IDuniqueidentifierGUID
ACTIVITY_DATEDate of Adjustment ActivitysmalldatetimeValid datetime (e.g., 2018-12-31 12:00:00)
EFFECTED_DATEEffected Date of AdjustmentsmalldatetimeValid datetime (e.g., 2018-12-31 12:00:00)
STATION_INTForeign Key for Adjustment’s StationintJoin to WOMD.Stations
ORDER_IDForeign Key for Adjustment’s OrderuniqueidentifierJoin to WOMD.Order
SALES_OFFICE_IDForeign Key for Adjustment’s Sales OfficeuniqueidentifierJoin to WOMD.SalesOffices
ACCOUNT_EXECUTIVE_IDForeign Key for Adjustment’s Account ExecutiveuniqueidentifierJoin to WOMD.AccountExec
ADVERTISER_IDForeign Key for Adjustment’s AdvertiseruniqueidentifierJoin to WOMD.Advertisers
AGENCY_IDForeign Key for Adjustment’s AgencyuniqueidentifierJoin to WOMD.Agencies
SALES_REGION_INTForeign Key for Adjustment’s Sales RegionintJoin to WOMD.Lookups
GROSS_AMOUNTAdjusted Gross AmountmoneyAny money amount
NET_AMOUNTAdjusted Net AmountmoneyAny money amount
IS_ADJUSTMENTFlag indicating whether this is an Adjustmentbit0 or 1
IS_HIST Flagindicating whether this is Historical Revenuebit0 or 1
PRODUCT_CODE_IDForeign Key for Adjustment’s Product CodeuniqueidentifierJoin to WOMD.ProductCodes
PRIORITY_CODE_INTForeign Key for Adjustment’s Priority CodeintJoin to WOMD.Lookups
REVENUE_CODE1_INTForeign Key for Adjustment’s Revenue Code 1intJoin to WOMD.Lookups
REVENUE_CODE2_INTForeign Key for Adjustment’s Revenue Code 2intJoin to WOMD.Lookups
REVENUE_CODE3_INTForeign Key for Adjustment’s Revenue Code 3intJoin to WOMD.Lookups
UNIT_CODE_INTForeign Key for Adjustment’s Unit CodeintJoin to WOMD.UnitCodes
IS_CASH Flagindicating whether Adjustment isCash Onlybit
REVENUE_ADJUSTMENT_TYPERevenue Adjustment Typeint0 = 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 NameDescriptionData TypeSupported Values
@trackingvalueLast date/time that data was requestedsmalldatetimeValid datetime (e.g., 2018-12-31 12:00:00)

Output Fields

Field NameDescriptionData TypeSupported Values
ACTIVITY_DATEDate of Adjustment ActivitysmalldatetimeValid datetime (e.g., 2018-12-31 12:00:00)
EFFECTED_DATEEffected Date of AdjustmentsmalldatetimeValid datetime (e.g., 2018-12-31 12:00:00)
STATION_IDForeign Key for Revenue’s Activity StationuniqueidentifierJoin to WOMD.Stations
ADVERTISER_IDForeign Key for Revenue’s AdvertiseruniqueidentifierJoin to WOMD.Advertisers
AGENCY_IDForeign Key for Revenue’s AgencyuniqueidentifierJoin to WOMD.Agencies
REVENUE_CODE1_INTForeign Key for Revenue’s Revenue Code 1smallintJoin to WOMD.Lookups
REVENUE_CODE2_INTForeign Key for Revenue’s Revenue Code 2smallintJoin to WOMD.Lookups
REVENUE_CODE3_INTForeign Key for Revenue’s Revenue Code 3smallintJoin to WOMD.Lookups
UNIT_CODE_INTForeign Key for Revenue’s Unit CodesmallintJoin to WOMD.UnitCodes
SALES_REGION_INTForeign Key for Revenue’s Sales RegionsmallintJoin to WOMD.Lookups
SALES_OFFICE_IDForeign Key for Revenue’s Sales OfficeuniqueidentifierJoin to WOMD.SalesOffices
PRODUCT_CODE_IDForeign Key for Revenue’s Product CodeuniqueidentifierJoin to WOMD.ProductCodes
EI_MEDIA_TYPEElectronic Invoicing Media Typevarchar(25)Any string value
CHANGE_AMOUNTDollar amount of revenue changemoneyAny money value
ORDER_IS_CASHFlag indicating whether order is cashtinyint
FILTER_FROM_DATEData 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_DATEsmalldatetimeValid datetime (e.g., 2018-12-31 12:00:00)
FILTER_END_DATEData 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_DATEsmalldatetimeValid datetime (e.g., 2018-12-31 12:00:00)
FILTER_DATA_STATEFlag indicating whether data existstinyintIf 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 NameDescriptionData TypeSupported Values
@trackingvalueLast date/time that data was requestedsmalldatetimeValid datetime (e.g., 2018-12-31 12:00:00)

Output Fields

Field NameDescriptionData TypeSupported Values
ORDER_ACTIVITY_IDOrder Activity IDuniqueidentifier
ACTIVITY_DATEDate of Adjustment ActivitysmalldatetimeValid datetime (e.g., 2018-12-31 12:00:00)
EFFECTED_DATEEffected Date of AdjustmentsmalldatetimeValid datetime (e.g., 2018-12-31 12:00:00)
ORDER_IDForeign Key for Order IDuniqueidentifierJoin to WOMD.Orders
ORDER_INTForeign Key for Order ID, integer valueintJoin to WOMD.Orders
CHANNEL_INTForeign Key for ChannelintJoin to WOMD.Channels
STATION_INTForeign Key for StationintJoin to WOMD.Stations
CHANGE_AMOUNTDollar amount of revenue changemoneyAny money value
CHANGE_TYPEchar(1)
PRIORITY_CODE_INTForeign Key for Priority CodesmallintJoin to WOMD.Lookups
REVENUE_CODE1_INTForeign Key for Revenue Code 1smallintJoin to WOMD.Lookups
REVENUE_CODE2_INTForeign Key for Revenue Code 2smallintJoin to WOMD.Lookups
REVENUE_CODE3_INTForeign Key for Revenue Code 3smallintJoin to WOMD.Lookups
UNIT_CODE_INTForeign Key for Unit CodesmallintJoin to WOMD.UnitCodes
INVENTORY_CODE_IDForeign Key for Inventory CodeuniqueidentifierJoin to WOMD.InventoryCodes
INVENTORY_CODE_INTForeign Key for Inventory Code, integer valueintJoin to WOMD.InventoryCodes
CHANGE_UNITSNumber of Spots that changedintAny integer value
CHANGE_LENGTHLength of Spots that changedintAny integer value
ACTIVITY_BYUser who created the changevarchar(150)Any string value
FILTER_FROM_DATEData 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_DATEsmalldatetimeValid datetime (e.g., 2018-12-31 12:00:00)
FILTER_END_DATEData 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_DATEsmalldatetimeValid datetime (e.g., 2018-12-31 12:00:00)
FILTER_DATA_STATEFlag indicating whether data existstinyintIf 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 NameDescriptionData TypeSupported Values
@trackingvalueLast date/time that data was requestedsmalldatetimeValid datetime (e.g., 2018-12-31 12:00:00)

Output Fields

Field NameDescriptionData TypeSupported Values
STATION_IDForeign Key for StationuniqueidentifierJoin to WOMD.Stations
ADVERTISER_IDForeign Key for Advertiseruniqueidentifier
AGENCY_IDForeign Key for Agencyuniqueidentifier
BOOKED_DAYPART_INTForeign Key for Booked Daypartint
PLACED_DAYPART_INTForeign Key for Placed Daypartint
ISCI_CODEISCI Code of Materialvarchar(50)
INTENDED_AIR_DATEIntended Air Date of Spotsmalldatetime
SALES_REGION_INTForeign Key for Sales Regionint
ORDER_CREATE_DATEOrder Create Datesmalldatetime
SPOT_LENGTHSpot Length in millisecondsint
CHANNEL_INTForeign Key for Channelint
GROSS_REVENUEGross Revenuemoney
PRODUCT_CODE_IDForeign Key for Product Codeuniqueidentifier
ORDER_IS_CASHFlag indicating if Order Is Cashtinyint
INVENTORY_TYPE_INTForeign Key for Inventory Typeint
BREAK_CODE_INTForeign Key for Break Codeint
PROGRAM_INTForeign Key for Programint
INVENTORY_CODE_INTForeign Key for Inventory Codeint
MARKETPLACE_INTForeign Key for Marketplaceint
FILTER_FROM_DATEData 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_DATEsmalldatetime
FILTER_END_DATEData 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_DATEsmalldatetime
FILTER_DATA_STATEFlag indicating whether data existstinyintIf 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 NameDescriptionData TypeSupported Values
@trackingvalueLast date/time that data was requestedsmalldatetimeValid datetime (e.g., 2018-12-31 12:00:00)

Output Fields

Field NameDescriptionData TypeSupported Values
ORDER_LINE_UNIT_IDOrder Line Unit (Spot) IDuniqueidentifierGUID
OVERRIDE_INVENTORY_CODE_INTForeign Key for Spot’s Reconciled Inventory Code if different that bookedintJoin to WOMD.InventoryCodes
INVENTORY_CODE_INTForeign Key for Spot’s Inventory CodeintJoin to WOMD.InventoryCodes
AD_SLOT_INTForeign Key for Spot’s Ad SlotsmallintJoin to WOMD.Lookups
AD_TYPE_INTForeign Key for Spot’s Ad TypesmallintJoin to WOMD.Lookups
FREQUENCY_INTERVALTime Interval for Internet SpotsmallintInterval is 2 in this example: 3 times every 2 hours
FREQUENCY_NUMBERNumber of times within an interval Internet Spot runssmallintFrequency Number is 3 in this example: 3 time every 2 hours
FREQUENCY_TYPEType of time interval for Internet Spottinyint0 = minutes; 1 = hours; 2 = days; 3 = weeks; 4 = months; 5 = lifetime
INTERNET_PRIORITYInternet Spot’s Internet Prioritytinyint0 to 100
INTERNET_PRODUCT_INTForeign Key for Internet Spot’s Internet ProductintJoin to WOMD.InternetProduct
PRODUCT_TYPE_INTForeign Key for Internet Spot’s Product TypesmallintJoin to WOMD.Lookups
RATE_TYPE_INTForeign Key for Internet Spot’s Rate Typetinyint0 = CPM-Actuals; 1 = CPC; 2 = Flat rate; 3 = CPD, Daily; 4 = CPP; 5 = CPD, Weekly; 6 = CPD, Monthly; 7 = CPM, Booked
RECONCILED_AMOUNTInternet Spot’s Reconciled Dollar AmountmoneyAny money value
RECONCILED_CLICKSInternet Spot’s Reconciled Number of ClicksintAny integer value
RECONCILED_IMPRESSIONSInternet Spot’s Reconciled Number of ImpressionsintAny integer value
THIRD_PARTY_AD_SERVER_INTForeign Key for Internet Spot’s Third Party Ad ServersmallintJoin to WOMD.Lookups
INTERNET_WEIGHTInternet WeighttinyintAny tiny integer value
LINE_NUMBEROrder Line NumberintAny integer value
ADVERTISER_BRAND_INTForeign Key for Spot’s Advertiser BrandsmallintJoin to WOMD.AdvertiserBrands
AGREED_IMPRESSIONSAgreed ImpressionsintAny integer value
AGREED_INVENTORY_RATINGAgreed Inventory RatingfloatAny float value
AIR_TIME1Spot’s Air Time1 in milliseconds past midnightintAny integer value
AIR_TIME2Spot’s Air Time2 in milliseconds past midnight (if two part Spot)intAny integer value
SPOT_BREAK_CODE_INTForeign Key for Spot’s Break CodesmallintJoin to WOMD.Lookups
CHANNEL_INTForeign Key for Spot’s ChannelsmallintJoin to WOMD.Channels
CREATE_DATECreate DatesmalldatetimeValid datetime (e.g., 2018-12-31 12:00:00)
EXTERNAL_AMOUNTExternal Amount of SpotmoneyAny money value
H_REVENUE_CODE1_INTForeign Key for Revenue Code 1 for internal rate 2smallintJoin to WOMD.Lookups
H_REVENUE_CODE2_INTForeign Key for Revenue Code 2 for internal rate 2smallintJoin to WOMD.Lookups
H_REVENUE_CODE3_INTForeign Key for Revenue Code 3 for internal rate 2smallintJoin to WOMD.Lookups
HAS_PRODUCT_EXCLUSIVITYFlag indicating whether Spot has Product Exclusivitybit0 or 1
INTENDED_AIR_DATEIntended Air Date of SpotsmalldatetimeValid datetime (e.g., 2018-12-31 12:00:00)
INTERNAL_AMOUNTInternal Amount (Internal Rate 1) of SpotmoneyAny money value
INVENTORY_DESCRInventory Descriptionvarchar(150)Any string value
INVENTORY_TYPE_INTForeign Key for Spot’s Inventory TypesmallintJoin to WOMD.InventoryType
INVOICE_INTForeign Key for Spot’s InvoiceintJoin to WO_INVOICES
IS_BONUSFlag indicating whether the Spot is a Bonus Spotbit0 or 1
IS_BUYER_APPROVEDFlag indicating whether the Spot is Buyer Approvedtinyint0 or 1
IS_CREDITEDFlag indicating whether the Spot is Creditedbit0 or 1
IS_LATE_ADDFlag indicating whether the Spot is a Late Addbit0 or 1
IS_LOCKEDFlag indicating whether the Spot is Lockedbit0 or 1
IS_MAKEGOODFlag indicating whether the Spot is a Makegoodbit0 or 1
IS_PENDINGFlag indicating whether the Spot is Pending (in edit state)bit0 or 1
IS_PLACEABLEFlag indicating whether the Spot is Placeablebit0 or 1
IS_PLACEDFlag indicating whether the Spot is Placedbit0 or 1
IS_PLACED_REVENUE_ONLYFlag indicating whether the Spot is Placed for Revenue Onlybit0 or 1
IS_REJECTEDFlag indicating whether the Spot is Rejectedbit0 or 1
IS_UNRESOLVEDFlag indicating whether the Spot is Unresolvedbit0 or 1
IS_USER_MODIFIEDFlag indicating whether the Spot is User Modifiedbit0 or 1
LENGTH1Length1 in millisecondsintAny integer value
LENGTH2Length2 in milliseconds (if two part Spot)intAny integer value
MATERIAL_INT1Spot’s Material Int1intJoin to WOMD.Materials
MATERIAL_INT2Spot’s Material Int2intJoin to WOMD.Materials
OVERRIDE_BREAK_CODE_INTForeign Key for Spot’s Reconciled Break Code if different that bookedsmallintJoin to WOMD.Lookups
POSTED_IMPRESSIONSSpot’s Posted ImpressionsfloatAny float value
POSTED_RATINGSpot’s Posted RatingfloatAny float value
SPOT_PRIORITY_CODE_INTForeign Key for Spot’s Reconciled Priority Code if different that bookedsmallintJoin to WOMD.Lookups
PROGRAM_INTForeign Key for Spot’s Reconciled Program IntintJoin to WOMD.Program
PREEMPTED_DATEForeign Key for Spot’s Reconciled Preempted DatesmalldatetimeValid datetime (e.g., 2018-12-31 12:00:00)
REVENUE_CODE_INTForeign Key for Revenue Code 1smallintJoin to WOMD.Lookups
REVENUE_CODE2_INTForeign Key for Revenue Code 2smallintJoin to WOMD.Lookups
REVENUE_CODE3_INTForeign Key for Revenue Code 3smallintJoin to WOMD.Lookups
SELLING_ELEMENT_INTForeign Key for Spot’s Selling ElementsmallintJoin to WOMD.SellingElement
SPOT_NUMBERSpot NumbersmallintAny integer value
STATION_INTForeign Key for Spot’s StationsmallintJoin to WOMD.Stations
UNIT_CODE_INTForeign Key for Spot’s Unit CodesmallintJoin to WOMD.UnitCodes
UPDATE_DATEUpdate DatedatetimeValid datetime (e.g., 2018-12-31 12:00:00)
WAS_MADEGOODFlag indicating whether the Spot was Madegoodbit0 or 1
TILE_HEIGHTTile Height of Internet SpotsmallintAny small integer value
TILE_WIDTHTile Width of Internet SpotsmallintAny small integer value
SPOT_CHANNEL_ARRAYChannels that Spot is ordered tovarchar(1000)Binary
LINE_CHANNEL_ARRAYChannels that line is ordered tovarchar(1000)Binary
ORDER_INTForeign Key for Spot’s OrderintJoin to WOMD.Order
ORDER_NUMBEROrder Number of Spotvarchar(50)Any string value
STATION_IDForeign Key for Spot’s StationuniqueidentifierJoin to WOMD.Stations
IS_INTERNET_LINEFlag indicating whether the order line is a Internet Linebit0 or 1
IS_SALES_MAKEGOODFlag indicating whether Spot is a Sales Makegoodbit0 or 1
IS_CLEARED_CIAFlag indicating whether Spot is Cleared from Cash In Advancebit0 or 1
FILTER_FROM_DATEData 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_DATEsmalldatetimeValid datetime (e.g., 2018-12-31 12:00:00)
FILTER_END_DATEData 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_DATEsmalldatetimeValid datetime (e.g., 2018-12-31 12:00:00)
FILTER_DATA_STATEFlag indicating whether data existstinyintIf 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 NameDescriptionData TypeSupported Values
startdateStart date of date range to pull revenue datadateValid datetime (e.g., 2018-12-31)
enddateEnd date of date range to pull revenue datadateValid datetime (e.g., 2018-12-31)
stationIdListComma separated list of Station ID’svarchar(max)List of GUID’s

Output Fields

Field NameDescriptionData TypeSupported Values
PROPERTYStation Call Lettersvarchar(50)Any string value
STATION_INTStation ID, integer valueintegerAny integer value
CHANNELChannel Namevarchar(106)Any string value
CHANNEL_INTChannel ID, integer valueintAny integer value
CHANNEL_ARRAYArray representing channels where the order was placed, if multi-channel ordervarchar(1000)Any string value
ADVERTISER_NAMEAdvertiser Namevarchar(50)Any string value
ADVERTISER_MDM_IDAdvertiser MDM IDintAny integer value
ADVERTISER_EXTERNAL_IDAdvertiser External IDvarchar(50)Any string value
YEAR_NUMBERYearintGregorian calendar year
MONTH_NUMBERMonthintGregorian calendar month
DEMOGRAPHICDemographicvarchar(250)Any string value
ORDER_TYPEOrder Typevarchar(250)Any string value
CASH_OR_TRADECash or Trade Ordervarchar(10)Value is either “CASH” or “TRADE”
AGENCY_NAMEAgency Namevarchar(50)Any string value
AGENCY_MDM_IDAgency MDM IDintAny integer value
AGENCY_EXTERNAL_IDAgency External IDvarchar(50)Any string value
SALES_OFFICE_NAMESales Office Namevarchar(50)Any string value
AE_CODEAccount Executive Abbreviation Codevarchar(5)Any string value
SALES_PERSONAccount Executivevarchar(101)Any string value
SALES_REGIONSales Regionvarchar(250)Any string value
PARENT_PRODUCT_CODE_NAMEParent Product Code Namevarchar(250)Any string value
PRODUCT_CODE_NAMEProduct Code Namevarchar(50)Any string value
INVENTORY_CODEOrdered Inventory Code Namevarchar(50)Any string value
REVENUE_CODE1Revenue Code 1 Namevarchar(250)Any string value
REVENUE_CODE2Revenue Code 2 Namevarchar(250)Any string value
REVENUE_CODE3Revenue Code 3 Namevarchar(250)Any string value
UNIT_CODE_CODEUnit Code Namevarchar(250)Any string value
CALENDAR_TYPECalendar Type (e.g., Broadcast, Calendar, etc.)varchar(250)Any string value
SHARE_OF_ORDERShare of OrdertinyintAny tiny integer value
ORDER_NUMBEROrder Numbervarchar(50)Any string value
BRAND_NAMEBrand Namevarchar(250)Any string value
NET_AMOUNTNet RevenuemoneyMoney value
GROSS_AMOUNTGross RevenuemoneyMoney value
IS_DIRECTFlag indicating whether Advertiser is a Direct Advertiserbit0 or 1
IS_INTERNAL_RATE2Flag indicating whether the revenue data is for Internal Rate 2bit0 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 NameDescriptionData TypeSupported Values
startdateStart date of date range to pull revenue datadateValid datetime (e.g., 2018-12-31)
enddateEnd date of date range to pull revenue datadateValid datetime (e.g., 2018-12-31)
StationListComma separated list of Station ID’svarchar(max)List of GUID’s

Output Fields

Field NameDescriptionData TypeSupported Values
StationStation Call Lettersvarchar(50)Any string value
AE Full NameAccount Executive’s Full Namevarchar(110)Any string value
AdvertiserAdvertiser Namevarchar(50)Any string value
AgencyAgency Namevarchar(50)Any string value
Order #Order Numbervarchar(50)Any string value
Total DueTotal Amount DuemoneyAny money value
DateDate of InvoicesmalldatetimeValid datetime (e.g., 2018-12-31)
Billing MonthBilling Month of Invoicevarchar(50)Any string value
AGENCY_NAME_NO_CITYAgency Name without Billing Cityvarchar(300)Any string value
Estimate #Estimate Numbervarchar(50)Any string value
Original InvoiceOriginal Invoice Numbervarchar(50)Any string value
Total PaymentsTotal Payments made towards invoicemoneyAny money value
Invoice #Invoice Numbervarchar(50)Any string value
Agency Credit RatingAgency’s Credit Ratingvarchar(250)Any string value
Order Product DescriptionOrder’s Product Descriptionvarchar(250)Any string value
CurrentAmount Currently DuemoneyAny money value
30 DaysAmount Due, 30 days oldmoneyAny money value
60 DaysAmount Due, 60 days oldmoneyAny money value
90 DaysAmount Due, 90 days oldmoneyAny money value
120 DaysAmount Due, 120 days oldmoneyAny money value
150+ DaysAmount Due, 150 or more days oldmoneyAny 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 NameDescriptionData TypeSupported Values
startdateStart date of date range to pull revenue datadateValid datetime (e.g., 2018-12-31)
enddateEnd date of date range to pull revenue datadateValid datetime (e.g., 2018-12-31)
StationListComma separated list of Station ID’svarchar(max)List of GUID’s

Output Fields

Field NameDescriptionData TypeSupported Values
STATIONStation Call Lettersvarchar(50)Any string value
DAYPARTDaypart of Inventoryvarchar(250)Any string value
DAYDay of InventorysmalldatetimeValid datetime (e.g., 2018-12-31)
CAPACITY_MINUTESCapacity of Inventory in MinutesfloatAny float number
MAX_UNITSMaximum number of units as defined in format breaksmallintAny small integer value
INVENTORYInventory Codevarchar(250)Any string value
INVENTORY_REPORTING_NAMEInventory Code Reporting Namevarchar(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 NameDescriptionData TypeSupported Values
Start_DateStart date of time range for invoice create or update datesmalldatetimeValid datetime (e.g., 2018-12-31)
End_DateEnd date of time range for invoice create or update rangesmalldatetimeValid datetime (e.g., 2018-12-31)
Invoice_Batch_IdFind invoices in this batchuniqueidentifierGUID
Station_IntFind invoices for this stationintegerJoin to WOMD.Stations

Output Fields

Field NameDescriptionData TypeSupported Values
INVOICE_IDInvoice IduniqueidentifierJoin to WOMD.Stations
INVOICE_NUMBERInvoice Numbervarchar(50)Any string value
INVOICE_INTInvoice Id, integer valueintegerAny integer value
INVOICE_CREATE_DATEInvoice Create DatesmalldatetimeValid datetime (e.g., 2018-12-31)
INVOICE_UPDATE_DATEInvoice Update DatesmalldatetimeValid datetime (e.g., 2018-12-31)
INVOICE_STATUSInvoice StatusintegerReference code
INVOICE_IS_EDITEDFlag to indicate whether the invoice has been editedvarchar‘Yes’ or ‘No’
STATION_IDStation Id of invoiceuniqueidentifierJoin to WOMD.Stations
STATION_INTStation Int of invoiceintegerJoin to WOMD.Stations
STATION_NAMEStation Name of invoicevarchar(50)Any string value
STATION_CALL_LETTERSStation Call letters of invoicevarchar(25)Any string value
CREDIT_INVOICE_NUMBERInvoice number of the previous credit if one existsvarchar(50)Any string value
CREDIT_INVOICE_DATEInvoice date of the previous credit if one existssmalldatetimeValid datetime (e.g., 2018-12-31)
BILLING_MONTHInvoice Bill Monthvarchar(50)Gregorian month name
INVOICE_DATEInvoice Bill DatesmalldatetimeValid datetime (e.g., 2018-12-31)
BILL_TO_NAMEBill to Namevarchar(50)Any string value
BILL_TO_ATTENTIONBill to Attentionvarchar(110)Any string value
AGENCY_IDAgency Id of invoiceuniqueidentifierJoin to WOMD.Agencies
DUNS_NUMBERDuns number of agencyvarchar(50)Any string value
PRODUCT_DESCRIPTIONOrder product descriptionvarchar(50)Any string value
CLIENT_TRACKING_NUMBEROrder tracking number (estimate from application)varchar(50)Any string value
COMBO_DISPLAYCombo type of ordervarchar(50)‘Master’ or ‘Sub’
SPECIAL_HANDLINGSpecial Handlingvarchar(250)Any string value
SPECIAL_HANDLING_CODESpecial Handling Codevarchar(250)Any string value
TAX_RATE1Tax Rate1 of orderfloatAny float number
TAX_RATE2Tax Rate2 of orderfloatAny float number
HANDLING_STATUSHandling Statusvarchar(50)‘Normal’ or ‘Special’
EI_STATUSElectronic Invoice Statusvarchar(50)‘IS ELECTRONIC’ or ‘ONLY PAPER’
INVOICE_CODEInvoice Codevarchar(50)Any string value
AGENCY_PRODUCT_CODEAgency Product Code (EDI value)varchar(50)Any string value
CLIENT_CODEClient Code (EDI value)varchar(50)Any string value
EI_EXPORT_TYPEElectronic Invoice Export TypetinyintReference code
INVOICE_PERIOD_START_DATEStart of invoice periodsmalldatetimeValid datetime (e.g., 2018-12-31)
INVOICE_PERIOD_END_DATEEnd of invoice periodsmalldatetimeValid datetime (e.g., 2018-12-31)
BILL_PLAN_IS_USER_OVERRIDEFlag to indicate if Bill Plan has been modifiedbit0 or 1
ALT_ORDER_NUMBERAlternate order numbervarchar(50)Any string value
IS_CASHFlag indicating if order is cashbit0 or 1
IS_COOPFlag indicating if order is a coop orderbit0 or 1
NEW_BUSINESS_DATENew business date (all revenue behind this date is considered new business)smalldatetimeValid datetime (e.g., 2018-12-31)
ORDER_TYPE_INTOrder type intintegerJoin to WOMD.Lookups
ORDER_PLUS_IDOrder Plus IduniqueidentifierJoin to WOMD.Orders
IDB_NUMBERIDB Numbervarchar(50)Any string value
ORDER_START_DATEOrder Flight Start DatesmalldatetimeValid datetime (e.g., 2018-12-31)
ORDER_END_DATEOrder Flight End DatesmalldatetimeValid datetime (e.g., 2018-12-31)
ORDER_DESCROrder descriptionvarchar(50)Any string value
BILLING_GROUP_INTBilling Group IntintegerJoin to WOMD.BillingGroup
BILLING_GROUP_NAMEBilling Group Namevarchar(50)Any string value
REV_CODE1_INTRevenue Code 1 intintegerJoin to WOMD.Lookups
REV_CODE2_INTRevenue Code 2 intintegerJoin to WOMD.Lookups
REV_CODE3_INTRevenue Code 3 intintegerJoin to WOMD.Lookups
UNIT_CODE_INTUnit Code intintegerJoin to WOMD.UnitCodes
UNIT_CODE_DESCRUnit Code descriptionvarchar(50)Any string value
TOTAL_INVOICE_AMOUNTTotal Invoice AmountmoneyAny money value
OUTSTANDING_AMOUNTOutstanding balance amountmoneyAny money value
NUMBER_OF_UNITSNumber of spots included in invoiceintegerAny money value
GROSS_AMOUNTGross amount of invoicemoneyAny money value
NET_AMOUNTNet amount of invoicemoneyAny money value
AGENCY_COMMISSIONAgency commissionmoneyAny money value
AGENCY_DISCOUNTAgency discountmoneyAny money value
TAX1_AMOUNTTotal Tax 1 amountmoneyAny money value
TAX2_AMOUNTTotal Tax 2 amountmoneyAny money value
PRIMARY_ACCOUNT_EXEC_IDPrimary Account Executive IduniqueidentifierJoin to WOMD.AccountExecutives
SALES_OFFICE_IDSales Office IduniqueidentifierJoin to WOMD.SalesOffices
SALES_REGION_INTSales Region intintegerJoin to WOMD.Lookups
BILLING_CALENDAR_INTBilling Calendar intintegerJoin to WOMD.Lookups
BILLING_CYCLE_INTBilling Cycle intintegerJoin to WOMD.Lookups
ADVERTISER_IDAdvertiser IduniqueidentifierJoin to WOMD.Advertisers
ORDER_NUMBEROrder Numbervarchar(50)Any string value
ADVERTISER_ADDRESS_CITYAdvertiser Address cityvarchar(100)Any string value
ADVERTISER_ADDRESS_COUNTRYAdvertiser Address countryvarchar(100)Any string value
ADVERTISER_ADDRESS_LINE1Advertiser Address line1varchar(100)Any string value
ADVERTISER_ADDRESS_LINE2Advertiser Address line2varchar(100)Any string value
ADVERTISER_ADDRESS_LINE3Advertiser Address line3varchar(100)Any string value
ADVERTISER_ADDRESS_NAMEAdvertiser Address namevarchar(100)Any string value
ADVERTISER_ADDRESS_STATEAdvertiser Address statevarchar(100)Any string value
ADVERTISER_ADDRESS_POSTAL_CODEAdvertiser_Address_Postal Codevarchar(100)Any string value
ORDER_INTOrder IntintegerJoin to WOMD.Orders
ORDER_PLUS_INTOrder Plus intintegerJoin to WOMD.Orders
PENDING_LINK_ORDER_IDPending_Link_Order IduniqueidentifierJoin to WOMD.Orders
BILLING_ADDRESS_INTBilling Address intintegerJoin to WOMD.Addresses
CAMPAIGN_NUMBERCampaign Numbervarchar(50)Any string value
ORDER_TYPE_DESCROrder Type descriptionvarchar(250)Any string value
ORDER_TYPE_DISPLAYOrder Type displayvarchar(250)Any string value
ORDER_TYPEOrder Typevarchar(250)Any string value
REVENUE_CODE1_DESCRRevenue Code1 descrvarchar(250)Any string value
REVENUE_CODE2_DESCRRevenue Code2 descrvarchar(250)Any string value
REVENUE_CODE3_DESCRRevenue Code3 descrvarchar(250)Any string value
AGENCY_NAMEAgency Namevarchar(50)Any string value
ADVERTISER_NAMEAdvertiser Namevarchar(50)Any string value
SALES_OFFICE_NAMESales Office namevarchar(250)Any string value
SALES_REGION_DESCRSales Region descriptionvarchar(250)Any string value
SALES_REGION_DISPLAYSales Region displayvarchar(250)Any string value
SALES_REGIONSales Regionvarchar(250)Any string value
ACCOUNT_EXEC_CODEAccount Exec codevarchar(5)Any string value
ACCOUNT_EXEC_NAMEAccount Exec namevarchar(110)Any string value
ACCOUNT_EXEC_PHONEAccount Exec phonevarchar(100)Any string value
BILLING_CALENDARBilling Calendarvarchar(250)Any string value
BILLING_ADDRESS_LINE1Billing Address line1varchar(100)Any string value
BILLING_ADDRESS_LINE2Billing Address line2varchar(100)Any string value
BILLING_ADDRESS_CITYBilling Address cityvarchar(100)Any string value
BILLING_ADDRESS_STATEBilling Address statevarchar(100)Any string value
BILLING_ADDRESS_POSTAL_CODEBilling_Address_Postal Codevarchar(100)Any string value
BILLING_ADDRESS_COUNTRYBilling Address countryvarchar(100)Any string value
STATION_ADDRESS_LINE1Station Address line1varchar(100)Any string value
STATION_ADDRESS_LINE2Station Address line2varchar(100)Any string value
STATION_ADDRESS_CITYStation Address cityvarchar(100)Any string value
STATION_ADDRESS_STATEStation Address statevarchar(100)Any string value
STATION_ADDRESS_POSTAL_CODEStation_Address_Postal Codevarchar(100)Any string value
REMIT_ADDRESS_LINE1Remit Address line1varchar(100)Any string value
REMIT_ADDRESS_LINE2Remit Address line2varchar(100)Any string value
REMIT_ADDRESS_CITYRemit Address cityvarchar(100)Any string value
REMIT_ADDRESS_STATERemit Address statevarchar(100)Any string value
REMIT_ADDRESS_POSTAL_CODERemit_Address_Postal Codevarchar(100)Any string value
STATION_PHONEStation Phonevarchar(50)Any string value
BILLING_PHONEBilling Phonevarchar(50)Any string value
GLOBAL_AGENCY_IDGlobal Agency idvarchar(50)Any string value
EXTERNAL_AGENCY_CODEExternal Agency codevarchar(50)Any string value
GLOBAL_ADVERTISER_IDGlobal Advertiser idvarchar(50)Any string value
EXTERNAL_ADVERTISER_CODEExternal Advertiser codevarchar(50)Any string value
IS_CASH_IN_ADVANCEFlag indicating whether order is Cash In Advancebit0 or 1
REMARKSRemarksvarchar(50)Any string value
SUPPRESS_CLICKSFlag indicating whether to suppress clicks on invoicebit0 or 1
SUPPRESS_CREDITSFlag indicating whether to suppress credits on invoicebit0 or 1
SUPPRESS_IMPRESSIONSFlag indicating whether to suppress impressions on invoicebit0 or 1
SUPPRESS_LINE_AMOUNTSFlag indicating whether to suppress line amounts on invoicebit0 or 1
IS_DIRECT_ADVERTISERFlag indicating if Advertiser is a Direct Advertiserbit0 or 1
ORDER_EXTERNAL_IDExternal id of ordervarchar(50)Any string value