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 |
|
Comments
0 comments
Article is closed for comments.