Strata Sync - Strata To WMJ Sync Fields
NOTE: You can now use Invoice Month as another option for the Posting Date when syncing over Vendor Invoices from Strata.
Broadcast Estimate
|
Strata Field |
|
WMJ Field |
Database Type |
|
Client_ID |
|
Client ID |
varchar(50) |
|
Estimate_ID |
|
Estimate ID |
varchar(50) |
|
Estimate_Description |
|
Estimate Name |
varchar(200) |
|
Estimate_Code |
This is a field that we parse to get the values we require |
Project Number |
varchar(100) |
|
Task ID |
varchar(50) |
||
|
Class ID |
varchar(50) |
||
|
GL Company ID |
varchar(50) |
||
|
Office ID |
varchar(50) |
||
|
Flight_Start_Date |
|
FlightStartDate |
smalldatetime |
|
Flight_End_Date |
|
FlightEndDate |
smalldatetime |
|
Product_ID |
|
Client Product Link ID |
varchar(100) |
|
Product_Name |
|
Client Product Name |
varchar(300) |
|
Division_ID |
|
Client Division Link ID |
varchar(100) |
|
Division_Name |
|
Client Division Name |
varchar(300) |
Broadcast Order Header
|
Strata Field |
|
WMJ Field |
Database Type |
|
Vendor Code |
This is a field that we parse to get the values we require |
Vendor ID |
varchar(50) |
|
Station ID |
varchar(50) |
||
|
Station_Comments |
|
Special Instructions |
varchar(500) |
|
Traffic_Instruction_Comments |
|
Delivery Instructions |
varchar(500) |
|
Billing_Date |
|
PODate |
smalldatetime |
|
Address1 |
|
Address1 |
varchar(200) |
|
Address2 |
|
Address2 |
varchar(200) |
|
City |
|
City |
varchar(200) |
|
State |
|
State |
varchar(50) |
|
Zip |
|
PostalCode |
varchar(20) |
|
Primary_Contact_Name |
|
Contact |
varchar(200) |
|
Flight_Start_Date |
|
FlightStartDate |
smalldatetime |
|
Flight_End_Date |
|
FlightEndDate |
smalldatetime |
Broadcast Detail Lines
|
Strata Field |
|
WMJ Field |
Database Type |
|
Number_of_Spots |
|
Quantity |
decimal(24,4) |
|
Comments |
|
Comments |
varchar(1000) |
|
Program_Name |
|
Program |
varchar(200) |
|
Flight_Start_Date |
|
StartDate |
smalldatetime |
|
Flight_End_Date |
|
EndDate |
smalldatetime |
Print / Interactive Orders Estimate
|
Strata Field |
|
WMJ Field |
Database Type |
|
Client_ID |
|
Client ID |
varchar(50) |
|
Estimate_ID |
|
Estimate ID |
varchar(50) |
|
Estimate_Description |
|
Estimate Name |
varchar(200) |
|
Estimate_Code |
This is a field that we parse to get the values we require |
Project Number |
varchar(100) |
|
Task ID |
varchar(50) |
||
|
Class ID |
varchar(50) |
||
|
GL Company ID |
varchar(50) |
||
|
Office ID |
varchar(50) |
||
|
Flight_Start_Date |
|
FlightStartDate |
smalldatetime |
|
Flight_End_Date |
|
FlightEndDate |
smalldatetime |
|
Product_ID |
|
Client Product Link ID |
varchar(100) |
|
Product_Name |
|
Client Product Name |
varchar(300) |
|
Division_ID |
|
Client Division Link ID |
varchar(100) |
|
Division_Name |
|
Client Division Name |
varchar(300) |
Print / Interactive Order Header
|
Strata Field |
|
WMJ Field |
Database Type |
|
Pub_Code |
This is a field that we parse to get the values we require |
VendorID |
varchar(50) |
|
PublicationID |
varchar(50) |
||
|
Print_Media_ID |
|
ItemLinkID |
varchar(50) |
|
IH_Comments |
|
SpecialInstructions |
varchar(50) |
|
IH_Date |
|
PODate |
smalldatetime |
|
Contact_Address1 |
|
Address1 |
varchar(200) |
|
Contact_Address2 |
|
Address2 |
varchar(200) |
|
Contact_City |
|
City |
varchar(200) |
|
Contact_State |
|
State |
varchar(50) |
|
Contact_Zip |
|
PostalCode |
varchar(20) |
|
Contact_Name |
|
Contact |
varchar(200) |
|
Flight_Start_Date |
|
StartDate |
smalldatetime |
|
Flight_End_Date |
|
EndDate |
smalldatetime |
Print / Interactive Order Detail Line
|
Strata Field |
Strata Visible Field Name |
WMJ Field |
Database Type |
|
IL_Caption |
Placement Name |
Ad#Caption |
varchar(200) |
|
IL_Comments |
Comments |
Comments |
varchar(1000) |
|
Print_Insertion_Line.Space_Closing_Date |
Space Close | smalldatetime | |
|
Print_Insertion_Line.Material_Closing_Date |
Materials Due | smalldatetime | |
|
Interactive_Insertion_Line.Space_Closing_Date |
Space Close | smalldatetime | |
|
Interactive_Insertion_Line.Material_Closing_Date |
Materials Due | smalldatetime |
Broadcast Invoices Header
|
Strata Fields |
|
WMJ Fields |
Database Type |
|
Vendor_Code |
|
VendorID |
varchar(50) |
|
Invoice_Number |
|
InvoiceNumber |
varchar(50) |
|
Invoice_Date |
|
InvoiceDate |
smalldatetime |
|
Matched_Date |
|
MatchedDate |
smalldatetime |
|
Due_Date |
|
DueDate |
smalldatetime |
Broadcast Invoices Detail Line
|
Strata Fields |
|
WMJ Fields |
Database Type |
|
Comments |
|
Comments |
varchar(500) |
Print/ Interactive Invoices Header/Detail Line
|
Strata Fields |
|
WMJ Fields |
Database Type |
|
Vendor_Code |
|
VendorID |
varchar(50) |
|
Invoice_Number |
|
InvoiceNumber |
varchar(50) |
|
Invoice_Date |
|
InvoiceDate |
smalldatetime |
|
Cleared_Date |
|
ClearedDate |
smalldatetime |
|
Due_Date |
|
DueDate |
smalldatetime |
|
Invoice_Comments |
|
Comments |
varchar(500) |
Broadcast Vendors
|
Strata Fields |
|
WMJ Fields |
Database Type |
|
VENDOR_ID |
|
LinkID |
|
|
VENDOR_CODE |
|
VendorID |
|
|
VENDOR_NAME |
|
CompanyName |
|
|
ADDRESS_1 |
|
Address1 |
|
|
ADDRESS_2 |
|
Address2 |
|
|
CITY |
|
City |
|
|
STATE |
|
State |
|
|
ZIP |
|
PostalCode |
|
|
PAYEE_ADDRESS_1 |
|
BAddress1 |
|
|
PAYEE_ADDRESS_2 |
|
BAddress2 |
|
|
PAYEE_CITY |
|
BCity |
|
|
PAYEE_STATE |
|
BState |
|
|
PAYEE_ZIP |
|
BPostalCode |
|
Print Vendors
NOTE: (CONTACT data comes from PRINT_PUB_CONTACT ordered by PUB_CONTACT_ID)
|
Strata Fields |
|
WMJ Fields |
Database Type |
|
PUBLICATION_ID |
|
LinkID |
|
|
PUB_CODE |
|
VendorID |
|
|
PUB_NAME |
|
CompanyName |
|
|
CONTACT_ADDRESS1 |
CONTACT_TYPE = 1 |
Address1 |
|
|
CONTACT_ADDRESS2 |
CONTACT_TYPE = 1 |
Address2 |
|
|
CONTACT_CITY |
CONTACT_TYPE = 1 |
City |
|
|
CONTACT_STATE |
CONTACT_TYPE = 1 |
State |
|
|
CONTACT_ZIP |
CONTACT_TYPE = 1 |
PostalCode |
|
|
CONTACT_ADDRESS1 |
CONTACT_TYPE = 3 |
BAddress1 |
|
|
CONTACT_ADDRESS2 |
CONTACT_TYPE = 3 |
BAddress2 |
|
|
CONTACT_CITY |
CONTACT_TYPE = 3 |
BCity |
|
|
CONTACT_STATE |
CONTACT_TYPE = 3 |
BState |
|
|
CONTACT_ZIP |
CONTACT_TYPE = 3 |
BPostalCode |
|
Interactive Vendors
|
Strata Fields |
|
WMJ Fields |
Database Type |
|
INTERACTIVE_SITE_ID |
|
LinkID |
|
|
SITE_CODE |
|
VendorID |
|
|
SITE_NAME |
|
CompanyName |
|
|
ADDRESS_1 |
|
Address1 |
|
|
ADDRESS_2 |
|
Address2 |
|
|
CITY |
|
City |
|
|
STATE |
|
State |
|
|
ZIP |
|
PostalCode |
|
|
PAYEE_ADDRESS_1 |
|
BAddress1 |
|
|
PAYEE_ADDRESS_2 |
|
BAddress2 |
|
|
PAYEE_CITY |
|
BCity |
|
|
PAYEE_STATE |
|
BState |
|
|
PAYEE_ZIP |
|
BPostalCode |
|