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.

The following table displays details regarding requested Order Transaction Id:

Field NameDescriptionData Type (Length)
1. transactionIdUnique ID for every instance of an orderinteger
2. keyOrder Keystring
3. orderIdFW OrderId for a given orderinteger
4. revisionNumberRevision number of the orderinteger
5. mediaOrderIdAdazzle Brief IDString (50)
6. campaignIdAdazzle Campaign IDString (50)
7. agencyCompanyNameAgency nameString (50)
8. agencyCompanyCodeAgency codeString (50)
9. agencyOfficeNameOffice nameString (50)
10. agencyOfficeCodeOffice codeString (50)
11. advertiserRefIdFW internal ID for the Advertiserinteger
12. advertiserNameAdvertiser nameString (50)
13. advertiserCodeAdvertiser codeString (50)
14. clientRefIdFW internal ID for the Clientinteger
15. clientNameClient nameString (50)
16. clientCodeAdvertiser/Client codeString (50)
17. divisionRefIdFW internal ID for the Divisioninteger
18. divisionNameDivision nameString (50)
19. divisionCodeDivision codeString (50)
20. productRefIdFW internal ID for the Productinteger
21. productNameProduct nameString (50)
22. productCodeProduct codeString (50)
23. mediaRefIdFW internal ID for the Media Typeinteger
24. mediaTypeNameEstimate media type nameString (50)
25. mediaCodeEstimate media type code (optional)String (50)
26. estimateIdSystem generated estimate numberInteger
27. estimateNameEstimate name/descriptionString
28. estimateCodeEstimate billing code (optional)String (50)
29. estimateCommentsComments on the EstimateString (2147483647)
30. flightStartDateEstimate flight start dateString (23)
31. flightEndDateEstimate flight end dateString (23)
32. vendorRefIdFW id for the VendorInteger
33. vendorNameSpot: Vendor Name
Network: Vendor
NamePrint/Outdoor: Publication/Vendor Name
Digital: Publisher/Fee Vendor Name
String (101)
34. vendorCodeVendor billing codeString (50)
35. vendorCurrencyCurrency in which the Vendor does businessString
36. vendorBillingCodeTypeBilling code type which should be used for payment
(Vendor; Alternative; Rep)
String
37. thirdPartyCustomDataThird Party Job Number – Component NumberString
38. orderCommentsComments on the orderString (5000)
39. buyerNameBuyer name on the OrderString (50)
40. tvData
a. flightStartTimeEstimate flight start timeString (23)
b. flightEndTimeEstimate flight end timeString (23)
c. weeklyOrDailySpot/Network only.

Daily or weekly estimate
(Weekly; Daily)
String (1)
d. primaryDemoNameSpot/Network: Primary Demostring
41. totalGrossCost
a. amountGross Costmoney
b. currencyCodeCurrency identifierstring
42. totalNetCost
a. amountNet Costinteger
b. currencyCodeCurrency identifierstring
43. totalClientGrossCost
a. amountClient Gross Costinteger
b. currencyCodeCurrency identifierstring
44. totalClientNetCost
a. amountClient Net Costinteger
b. currencyCodeCurrency identifierstring
45. purchaseOrderReferencePurchase Order referencestring
46. estimateCustomFieldsDictionary<CustomFieldName, KeyValuePair<string, string>>string, string (2000)
47. orderDetails
a. idNumeric ID for the OrderInteger
b. statusOrder status
(Unchanged; Created; Modified; Cancelled)
String (1)
c. lineNumberUnique line number by orderInteger
d. isPackageDigital Only: True/False used to identify if the line ID is associated with the package or placement lineBoolean
e. packageNameDigital Only: Package Name associated with the placement lineString (255)
f. startDateOrder line start dateString (23)
g. endDateOrder line end dateString (23)
h. marketNameMarket name associated with the OrderString (50)
i. marketCodeMarket code associated with the OrderString (50)
j. totalUnitsSpot/Network = Total spots
Print/Outdoor = 1
Digital = Total units
integer
k. grossCost
i. CostInfo
a) amountGross costmoney
b) currencyCodeCurrency identifierstring
ii. costTypeRateType:
(CPA; CPC; CPCV; CPE; CPL; CPM; CPMV; CPT; CPV; FlatRate; CPI; CPD; CPMs; Ecpc; eCPM)
String (50)
iii. rateNumber
l. netCost
i. CostInfo
a. amountNet costmoney
b. currencyCodeCurrency identifierstring
ii. costTypeRateType:
(CPA; CPC; CPCV; CPE; CPL; CPM; CPMV; CPT; CPV; FlatRate; CPI; CPD; CPMs; Ecpc; eCPM)
String (50)
iii. rateNumber
m. clientNetCost
i. CostInfo
a) amountClient Net costmoney
b) currencyCodeCurrency identifierstring
ii. costTypeRateType:
(CPA; CPC; CPCV; CPE; CPL; CPM; CPMV; CPT; CPV; FlatRate; CPI; CPD; CPMs; Ecpc; eCPM)
String (50)
iii. rateNumber
n. clientGrossCost
i. CostInfo
a) amountClient Gross costmoney
b) currencyCodeCurrency identifierstring
ii. costTypeRateType:
(CPA; CPC; CPCV; CPE; CPL; CPM; CPMV; CPT; CPV; FlatRate; CPI; CPD; CPMs; Ecpc; eCPM)
String (50)
iii. rateNumber
o. clientNetPercentClient Net %number
p. netPercentNet %number
q. clientGrossPercentClient Gross %number
r. tax1RateSpot: State/GST or Local/PST tax rate
Network, Print/Outdoor, Digital: vendor tax rate
number
s. tax1Option1 = tax based on Gross, 2 = tax based on NetString (50)
t. tax2RateSpot:State/GST or Local/PST tax rate
Network, Print/Outdoor, Digital: vendor tax rate
Number
u. tax2Option1 = tax based on Gross, 2 = tax based on NetString (50)
v. cashTradeSpot and Network by unit: C = Cash T = TradeString (1)
w. commentsLine commentsString (4000)
x. creativeNameCaption of the adString
y. creativeIdPrint/Outdoor, Digital: Ad numberString
z. materialClosingDatePrint/Outdoor, Digital: Material closing dateString (23)
i. sectionSection in which ad appears Print, OOH, or DigitalString (50)
ii. adSizeSize of the ad for Print, OOH, or DigitalString (100)
iii. positionAd position for Print, OOH, or DigitalString (255)
iv. actualizationStatusActualization status of the ad
(If KEY field in OrderAPI = A, values are “Actualized”; “Not Actualized”)
string
v. printDetail
1) spaceClosingDatePrint/Outdoor: Space closing dateString (23)
2) monthDayPrint: Insertion Month or DayString (50)
3) zoneZone in which the ad runs, for Print onlyString (50)
4) materialCommentsString
5) mechanicalDetailsString
6) colorString
7) insertionDateString
w. tvDetail
1) lengthUnit length for the line detail for Spot and NetworkInteger
2) istartTimeOrder line start timeString (23)
3) endTimeOrder line end timeString (23)
4) programNameProgram for line detail for Spot and NetworkString (200)
5) primaryDemoRtgPerSpotSpot/Network: rating per spot for primary demonumber
6) primaryDemoImpPerSpotSpot/Network: Imps per spot for primary demonumber
7) daypartCodeDaypart code for the line detailString (50)
8) daysOfWeekMTuWThFSaSuString (50)
9) cableNetworkSpot only: Cable network codes for networks scheduled for the cable systemString (50)
10) unitsByWeek
a) startDateWeek start dateString (23)
b) endDateWeek end dateString (23)
c) totalUnitsUnits for the weekinteger
x. oohDetail
i. cycleTypeOutdoor Cycle Type: Broadcast, FourWeeks, or MonthlyString (3)
y. mediaChannelRefIdFW internal ID for the Media Channelinteger
z. mediaChannelNameMedia ChannelString (100)
aa. mediaChannelCodeMedia Channel Code
Populated for Adazzle-sourced orders; Null for SBMS-sourced orders
String (50)
bb. billingMonthString (5)
cc. billingMonthTypeF, C, BString (1)
dd. commissionCodeString
ee. customMarketCodeString
48. formatCodesList of format codesstring
49. financeSystemUserstring