Master Data

Master Data: Order of Creation

Master Data – Order of Creation

This list outlines the recommended order to add Master Data into Advvy either the first time, or when importing in bulk.

Master Data Entity
Data Fields
0- a1a_autoname Entity Name
0-a1a_autonumber Name, Auto-Number, Auto-Number Text, Auto/Manual, Code Field, Entity Name, Last Automatic Code, Last Generated Number, Leading Zero, Lock Helper, Next Automatic Code, Prefix, Trimmed Auto-Number
1-Agency Types Name
1-Audiences Code, Name, Demographics Count
1-Client Type Name, Code
1-Contact Type Name
1-Countries Name
1-Ethnicities Name
1-Fees Name
1-Market Type Code, Name, Market Type Count
1-Media Workflow Reporting Pillar Reporting Pillar, Sort Order, Colour, Workflow Type
1-Media Workflow Role Name
1-Tag Name, Parent Tag
2-Contact Full Name, First Name, Middle Name, Last Name, Business Phone, Email, Mobile Phone, Portal User, Portal Visibility, User Name
2-Market Market Type, Name, Edit Fields, Market Count
2-Media Type Class Name
3-Media Type Segment Name, Media Type Class
3-Media Type Group Name
4-Media Type Name, Code, Media Type Segment, Media Type Group, Colour, Sort Order
5-Media Sub Type Code, Name, Media Type
6-Master Client Name, Agency, is parent, Parent Master Client
6-Network Name, Code, Parent Network, Primary Contact, Phone, Fax
7-Client      (Account) Account Name        Primary Contact        Main Phone        Address1: Country        Address2: Country        Agency        Branch        Client Type        Code        Master Client        Same as Office Address
7-Medium Code, Name, Market, Media Type, Media Sub Type, Network
8-Product Classification Name, Client
9-Product Name, Client, Primary Contact, Product Classification, Product Description, Reference Name
Related Articles