Orders are available in the API once they have been billed in the Strata Buy Management System (SBMS) or confirmed in Adazzle.
SBMS is a suite of tools used for planning, buying, stewardship, optimization, and billing across all forms of digital media.
Adazzle is a Strata cloud-based platform used to power the end-to-end digital campaign management process, including planning, buying, trafficking, and actualization.
| Field Name | Description | Data Type (Length) |
|---|---|---|
| transactionId | Unique ID for every instance of an order | integer |
| key | Order Key | string |
| orderId | FW OrderId for a given order | integer |
| revisionNumber | Revision number of the order | integer |
| mediaOrderId | Adazzle Brief ID | String (50) |
| campaignId | Adazzle Campaign ID | String (50) |
| agencyCompanyName | Agency name | String (50) |
| agencyCompanyCode | Agency code | String (50) |
| agencyOfficeName | Office name | String (50) |
| agencyOfficeCode | Office code | String (50) |
| advertiserRefId | FW internal ID for the Advertiser | integer |
| advertiserName | Advertiser name | String (50) |
| advertiserCode | Advertiser code | String (50) |
| clientRefId | FW internal ID for the Client | integer |
| clientName | Client name | String (50) |
| clientCode | Advertiser/Client code | String (50) |
| divisionRefId | FW internal ID for the Division | integer |
| divisionName | Division name | String (50) |
| divisionCode | Division code | String (50) |
| productRefId | FW internal ID for the Product | integer |
| productName | Product name | String (50) |
| productCode | Product code | String (50) |
| mediaRefId | FW internal ID for the Media Type | integer |
| mediaTypeName | Estimate media type name | String (50) |
| mediaCode | Estimate media type code (optional) | String (50) |
| estimateId | System generated estimate number | Integer |
| estimateName | Estimate name/description | String |
| estimateCode | Estimate billing code (optional) | String (50) |
| estimateComments | Comments on the Estimate | String (2147483647) |
| flightStartDate | Estimate flight start date | String (23) |
| flightEndDate | Estimate flight end date | String (23) |
| vendorRefId | FW id for the Vendor | Integer |
| vendorName | Spot: Vendor Name Network: Vendor NamePrint/Outdoor: Publication/Vendor Name Digital: Publisher/Fee Vendor Name | String (101) |
| vendorCode | Vendor billing code | String (50) |
| vendorCurrency | Currency in which the Vendor does business | String |
| vendorBillingCodeType | Billing code type which should be used for payment (Vendor; Alternative; Rep) | String |
| thirdPartyCustomData | Third Party Job Number – Component Number | String |
| orderComments | Comments on the order | String (5000) |
| buyerName | Buyer name on the Order | String (50) |
| tvData | ||
| flightStartTime | Estimate flight start time | String (23) |
| flightEndTime | Estimate flight end time | String (23) |
| weeklyOrDaily Spot/Network only. | Daily or weekly estimate (Weekly; Daily) | String (1) |
| primaryDemoName | Spot/Network: Primary Demo | string |
| totalGrossCost | ||
| amount | Gross Cost | money |
| currencyCode | Currency identifier | string |
| totalNetCost | ||
| amount | Net Cost | integer |
| currencyCode | Currency identifier | string |
| totalClientGrossCost | ||
| amount | Client Gross Cost | integer |
| currencyCode | Currency identifier | string |
| totalClientNetCost | ||
| amount | Client Net Cost | integer |
| currencyCode | Currency identifier | string |
| purchaseOrderReference | Purchase Order reference | string |
| estimateCustomFields | Dictionary<CustomFieldName, KeyValuePair<string, string>> | string, string (2000) |
| orderDetails | ||
| id | Numeric ID for the Order | Integer |
| status | Order status (Unchanged; Created; Modified; Cancelled) | String (1) |
| lineNumber | Unique line number by order | Integer |
| isPackage | Digital Only: True/False used to identify if the line ID is associated with the package or placement line | Boolean |
| packageName | Digital Only: Package Name associated with the placement line | String (255) |
| startDate | Order line start date | String (23) |
| endDate | Order line end date | String (23) |
| marketName | Market name associated with the Order | String (50) |
| marketCode | Market code associated with the Order | String (50) |
| totalUnits | Spot/Network = Total spots Print/Outdoor = 1 Digital = Total units | integer |
| grossCost | ||
| CostInfo | ||
| amount | Gross cost | money |
| currencyCode | Currency identifier | string |
| costType | RateType: (CPA; CPC; CPCV; CPE; CPL; CPM; CPMV; CPT; CPV; FlatRate; CPI; CPD; CPMs; Ecpc; eCPM) | String (50) |
| rate | Number | |
| netCost | ||
| CostInfo | ||
| amount | Net cost | money |
| currencyCode | Currency identifier | string |
| costType | RateType: (CPA; CPC; CPCV; CPE; CPL; CPM; CPMV; CPT; CPV; FlatRate; CPI; CPD; CPMs; Ecpc; eCPM) | String (50) |
| rate | Number | |
| clientNetCost | ||
| CostInfo | ||
| amount | Client Net cost | money |
| currencyCode | Currency identifier | string |
| costType | RateType: (CPA; CPC; CPCV; CPE; CPL; CPM; CPMV; CPT; CPV; FlatRate; CPI; CPD; CPMs; Ecpc; eCPM) | String (50) |
| rate Number | ||
| clientGrossCost | ||
| CostInfo | ||
| amount | Client Gross cost | money |
| currencyCode | Currency identifier | string |
| costType | RateType: (CPA; CPC; CPCV; CPE; CPL; CPM; CPMV; CPT; CPV; FlatRate; CPI; CPD; CPMs; Ecpc; eCPM) | String (50) |
| rate | Number | |
| clientNetPercent | Client Net % | number |
| netPercent | Net % | number |
| clientGrossPercent | Client Gross % | number |
| tax1Rate | Spot: State/GST or Local/PST tax rate Network, Print/Outdoor, Digital: vendor tax rate | number |
| tax1Option | 1 = tax based on Gross, 2 = tax based on Net | String (50) |
| tax2Rate Spot: | State/GST or Local/PST tax rate Network, Print/Outdoor, Digital: vendor tax rate | Number |
| tax2Option | 1 = tax based on Gross, 2 = tax based on Net | String (50) |
| cashTrade | Spot and Network by unit: C = Cash T = Trade | String (1) |
| comments | Line comments | String (4000) |
| creativeName | Caption of the ad | String |
| creativeId | Print/Outdoor, Digital: Ad number | String |
| materialClosingDate | Print/Outdoor, Digital: Material closing date | String (23) |
| section | Section in which ad appears Print, OOH, or Digital | String (50) |
| adSize | Size of the ad for Print, OOH, or Digital | String (100) |
| position | Ad position for Print, OOH, or Digital | String (255) |
| actualizationStatus | Actualization status of the ad (If KEY field in OrderAPI = A, values are “Actualized”; “Not Actualized”) | string |
| printDetail | ||
| spaceClosingDate | Print/Outdoor: Space closing date | String (23) |
| monthDay | Print: Insertion Month or Day | String (50) |
| zone | Zone in which the ad runs, for Print only | String (50) |
| materialComments | String | |
| mechanicalDetails | String | |
| color | String | |
| insertionDate | String | |
| tvDetail | ||
| length | Unit length for the line detail for Spot and Network | Integer |
| istartTime | Order line start time | String (23) |
| endTime | Order line end time | String (23) |
| programName | Program for line detail for Spot and Network | String (200) |
| primaryDemoRtgPerSpot | Spot/Network: rating per spot for primary demo | number |
| primaryDemoImpPerSpot | Spot/Network: Imps per spot for primary demo | number |
| daypartCode | Daypart code for the line detail | String (50) |
| daysOfWeek | MTuWThFSaSu | String (50) |
| cableNetwork | Spot only: Cable network codes for networks scheduled for the cable system | String (50) |
| unitsByWeek | ||
| startDate | Week start date | String (23) |
| endDate | Week end date | String (23) |
| totalUnits | Units for the week | integer |
| oohDetail | ||
| cycleType | Outdoor Cycle Type: Broadcast, FourWeeks, or Monthly | String (3) |
| mediaChannelRefId | FW internal ID for the Media Channel | integer |
| mediaChannelName | Media Channel | String (100) |
| mediaChannelCode | Media Channel Code Populated for Adazzle-sourced orders; Null for SBMS-sourced orders | String (50) |
| billingMonth | String (5) | |
| billingMonthType | F, C, B | String (1) |
| commissionCode | String | |
| customMarketCode | String | |
| formatCodes | List of format codes | string |
| financeSystemUser | string |