Please enable JavaScript to view this site.

Error itgendoc001X

xMsg javascript has not been loaded.

Facebook API Data Model

Navigation: Catalog: V32 > Schemas > Schema: Marketing > Tables

MyAdContracts

Contents Previous Home Next More

Name: MyAdContracts

Catalog: V32

Schema: Marketing

Table Columns

Name

Data Type

Label

Required

Documentation

account_id

string

itgen_facebook_account_id

Account ID.

account_mgr_fbid

decimal

itgen_facebook_account_mgr_fbid

FB ID of the Account Manager.

account_mgr_name

string

itgen_facebook_account_mgr_name

Account Manager Name.

adops_person_name

string

itgen_facebook_adops_person_name

Ad Ops Person Name.

advertiser_address_fbid

decimal

itgen_facebook_advertiser_address_fbid

FBID of Advertiser address.

advertiser_fbid

decimal

itgen_facebook_advertiser_fbid

FBID of Advertiser Organization.

advertiser_name

string

itgen_facebook_advertiser_name

Advertiser Name.

agency_discount

double

itgen_facebook_agency_discount

Ad Agency Discount.

agency_name

string

itgen_facebook_agency_name

Ad Agency Name.

bill_to_address_fbid

decimal

itgen_facebook_bill_to_address_fbid

FBID of billed Organization address.

bill_to_fbid

decimal

itgen_facebook_bill_to_fbid

FBID to Organization billed.

campaign_name

string

itgen_facebook_campaign_name

Campaign Name.

created_by

string

itgen_facebook_created_by

Created by.

created_date

int32

itgen_facebook_created_date

Created Date.

customer_io

string

itgen_facebook_customer_io

Customer IO Number.

io_number

int32

itgen_facebook_io_number

Insertion Order Number.

io_terms

string

itgen_facebook_io_terms

IO Terms.

io_type

string

itgen_facebook_io_type

Insertion Order Type, which is used to identify type of product associated with this IO. Currently, possible values are UNSPECIFIED (0) and RF (1).

last_updated_by

string

itgen_facebook_last_updated_by

Last Updated by.

last_updated_date

int32

itgen_facebook_last_updated_date

Last Updated Date.

max_end_date

int32

itgen_facebook_max_end_date

Max End Date.

mdc_fbid

decimal

itgen_facebook_mdc_fbid

FB ID of MDC.

media_plan_number

string

itgen_facebook_media_plan_number

Media Plan Number.

min_start_date

int32

itgen_facebook_min_start_date

Min Start Date.

msa_contract

string

itgen_facebook_msa_contract

MSA Contract Number.

payment_terms

string

itgen_facebook_payment_terms

Payment Terms.

rev_hold_flag

boolean

itgen_facebook_rev_hold_flag

Rev Hold Flag.

rev_hold_released_by

int32

itgen_facebook_rev_hold_released_by

User id to release the rev hold.

rev_hold_released_on

int32

itgen_facebook_rev_hold_released_on

Date to release the rev hold.

salesrep_fbid

int32

itgen_facebook_salesrep_fbid

FB ID of the Sales Rep.

salesrep_name

string

itgen_facebook_salesrep_name

Sales Rep Name.

sold_to_address_fbid

int32

itgen_facebook_sold_to_address_fbid

FBID of sold to Organization address.

sold_to_fbid

int32

itgen_facebook_sold_to_fbid

FBID of Organization sold to.

status

string

itgen_facebook_status

Status.

subvertical

string

itgen_facebook_subvertical

Sub-vertical.

thirdparty_billed

int32

itgen_facebook_thirdparty_billed

Third Party Billed.

thirdparty_password

string

itgen_facebook_thirdparty_password

Third Party Password.

thirdparty_uid

string

itgen_facebook_thirdparty_uid

Third Party UID.

thirdparty_url

string

itgen_facebook_thirdparty_url

Third Party URL.

vat_country

string

itgen_facebook_vat_country

VAT Country.

version

int32

itgen_facebook_version

Version.

vertical

string

itgen_facebook_vertical

Vertical.

 

Generated 11-01-2019 15:44 on version 17.30.0-PROD+1821.