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.