Strata sync - Strata to Workamajig Sync fields [in-depth guide] – Workamajig

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)

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)
Vendor Code	This is a field that we parse to get the values we require	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

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)

Strata Field		WMJ Field	Database Type
Pub_Code	This is a field that we parse to get the values we require	VendorID	varchar(50)
Pub_Code	This is a field that we parse to get the values we require	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

Strata Field	Strata Visible Field Name	WMJ Field	Database Type
IL_Caption	Placement Name	Ad#Caption	varchar(200)
IL_Comments	Comments	Standard Description	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

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	Ignored (WMJ Vendor Terms + Invoice Date)	smalldatetime

Strata Fields		WMJ Fields	Database Type
Comments		Comments	varchar(500)

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	Ignored (WMJ Vendor Terms + Invoice Date)	smalldatetime
Invoice_Comments	Comments	varchar(500)

NOTE: (CONTACT data comes from PRINT_PUB_CONTACT ordered by PUB_CONTACT_ID)