iTunes Downloads Column Name Column Description account_enabled_ind 0 = account is disabled, 1 = enabled account_signup_ts date the account was created/converted to an iTunes account (Pacific Time) address_country_cd Account country code artist_name Artist/developer name card_bin_country Accounts credit card bin country location city_name Account city name content_name product name create_ts line item transaction timestamp (Pacific Time) credit_card_type_id Account key value for the credit card type customer_name Account customer first and last name email_addr_txt Account billing profile email address email_domain Account billing profile email domain full_street Account street 1,2 and 3 address lines guid_name UDID for iOS Devices, MAC address for Macs, and an iTunes created Device ID for Windows/Other ip_addr_txt ip address used at the time of the transaction item_qty line item quanity (can be more than 1, especially for volume accounts) parent_content_name Content name of the parent adam id payment_type Account payment setting: 0 = iTunes Store credit, 1 = Credit Card / Payservice person_id iTunes account unique identifier phone_nr Account phone number platform_name what kind of device is being used (Windows, Mac, iPhone etc.) platform_version_nr Version number of iTunes postal_cd Account postal code price_amt_usd USD value of the line item purchase (can be 0 for free downloads) provider_name Content provider name (usually same as Artist name for dev, and Music Labels for music) purch_line_item_id unique row id for each line item of a transaction in our database purch_status_name Status of purchase sap_content_type_desc Transaction Type (App, InApp, Song, Video etc) state_name Account state name store_front_country iTunes store front selected for the account user_agent_txt customers user agent string user_tm_zone_name user agent time zone of the device making purchase (only stored for Macs and Windows machines) web_order_id Transaction identifier for a purchase (can include multiple purch_line_item_ids) iTunes Updates Column Name Column Description acct_id Account Identifier asset_flavor_id Asset Flavor Identifier change_ts Change Timestamp client_name Client Name client_version_nr Client Version Number content_name Content Name create_ts Create Timestamp download_id Download Identifier download_type_id Download Type Identifier download_variety_id Download Variety Identifier fulfilled_ind Download Fulfilled Indicator global_unique_id Global Unique Identifier ip_addr_txt IP Address Text part_of_book_ind Part of Book Indicator person_id Person Identifier platform_name Platform Name platform_version_nr Platform Version Number purch_line_item_id Purchase Line Item Identifier rptg_dt Reporting Date saga_acct_ind Saga Account Indicator store_front_name Store Front Name user_agent_txt User Agent Text iTunes Match Downloads Column Name Column Description area_cd Area Code asset_flavor_desc Asset Flavor Description city_name City Name client_name Client Name client_version_nr Client Version Number content_name Content Name country_cd Country Code create_ts Create timestamp device_version_nr Device Version Number email_addr_txt Email Address first_name First Name global_unique_id Global Unique Identifier ip_addr_txt Internet Protocol Address Text last_name Last Name person_id Person Identifier phone_nr Phone Number platform_name Platform Name platform_version_nr Platform Version Number postal_cd Postal Code store_front_name Store Front Name street_1_name Street Name Field One street_2_name Street Name Field Two iTunes Match Uploads Column Name Column Description album_name Album Name artist_name Artist Name client_name Client Name client_version_nr Client Version Number collection_unique_id Collection Unique Identifier content_name Content Name create_ts Create Timestamp file_extn_cd File extension code file_size_nr File size number genre_name Genre Name person_id Person Identifier platform_name Platform Name platform_version_nr Platform Version Number store_front_name Store Front Name track_name Track Name user_agent_txt User Agent Text Game Center Column Name Column Description adam_id iTunes Content Identifier content_name iTunes Content Name create_ts Create Timestamp device_os_version_nr Device Operating System Version Number device_type_name Device Type Name ip_address_txt Internet Protocol Address Text person_id Person Identifier session_length_secs Session Length in Seconds unique_device_id Universal Unique Device Identifier DS Signons Column Name Column Description customer_name Account first and last name email_addr_txt Account email address failed_signon_ind 0 = successful sign-on, 1 = unsuccessful (ex. Wrong password given) login_machine_guid_nr Unique identifier for device login_machine_ip_addr_txt IP address used during the signon login_store_front_name iTunes store front name used for the sign-on that isnt always the same storefront for the account person_id unique id for account signon_id unique id for the sign-on transaction in our database signon_ts signon timestamp (Pacific) signup_ts account signup timestamp (Pacific) MyAppleID and iForgot Column Name Column Description activity_ts Activity Timestamp ac_name Account Name apple_credential_id Apple Credential Identifier app_id Application Identifier Number app_name Application Name client_ip_nr Client Internet Protocol Address lang_id Language Identfier person_id Person Identifier timezone_cd Timezone Code txn_id Transaction Identifier AOS (Online) Orders Column Name Column Description acct_create_dt Account Create Date bill_to_city_name Bill to city name bill_to_country_cd Bill to country code bill_to_cust_1_name Bill to customer 1 name bill_to_phone_nr Bill to phone number bill_to_postal_cd Bill to postal code bill_to_street_name Bill to street name browser_url_txt Browser Universal Resource Locator Text charged_amt Charged Amount currency_cd Currency Code device_id Device Identifier email_txt Electronic Mail Address Text express_shipping_ind Express Shipping Indicator grp_id Group Identifier - Unique identifier for order number highest_amt Highest Amount highest_tax_amt Highest Tax Amount ip_addr_txt Internet protocol Address Text javascript_disabled_ind Javascript Disabled Indicator level_1_prod_cd Level 1 Product Code - Product description order_id Order Identifier order_item_nr Order Item Number order_phone_2_nr Order Phone 2 Number order_ts Order timestamp order_type_cd Order type code payment_type_cd Payment Type Code person_id Person Identifier prod_id Product Identifier prod_serial_nr Product Serial Number region_cd Region Code return_dt Order Return Date rma_order_id Return merchandise authorization order identifier ship_dt Ship Date ship_to_city_name Ship to city name ship_to_cust_1_name Ship to customer 1 name ship_to_cust_email_txt Ship to customer email address ship_to_phone_nr Ship to phone number ship_to_postal_cd Ship to postal code ship_to_street_name Ship to street name total_gift_card_order_val Total Gift Card Order Value tracking_txt Tracking Text web_order_id Web Order ID CRM Warranty Column Name Column Description change_ts Most Recent modification date & time contract_create_ts Apple Warranty Contract Creation Date & Time stamp contract_end_ts Apple Warranty Contract Expiration Date & Time stamp create_ts Most Recent modification date & time cust_id Apple SAP account Sold To Identifier id number hw_serial_nr Device Unique Serial Number onsite_uplift_ind Eligibility indicator for Enhanced Warranty coverage person_id Unique person identifier prod_id Part number purch_dt Device Purchase date & Time stamp sap_contract_create_dt Warranty Contract Begin date sap_contract_end_dt Warranty Contract expiration date serial_nr_status_cd Associated with Sale/Delivery Channel. i.e. Direct Indirect or Replacement source_cd Direct or Indirect purchase source_hw_serial_nr Device Unique Serial Number status_cd Registration status valid_hw_serial_nr_ind Valid Device Serial Number associated with warranty contract valid_ind Warranty validation indicator CRM Installed Product Column Name Column Description activation_ts Activation Timestamp airport_mac_addr Airport MAC Address for Mac Computers apple_logon_id Apple Logon Identifier bluetooth_mac_addr Bluetooth MAC Address for Mac Computers bt_mac_addr Bluetooth MAC Address for iOS Devices city City contact_name Contact Name country Country customer_name Customer Name cust_phone_nr Customer Phone Number device_family_id Device Family Identifier ds_id Person Identifier email_addr_txt Email Address eng_proj_desc Engineering Project Description eousb_mac_addr Ethernet over USB MAC Address for iOS Devices ethernet_mac_addr Ethernet MAC Address for Mac Computers firewire_mac_addr Firewire MAC Address for Mac Computers icc_id ICCID Number imei_nr International Mobile Station Equipment Identity Number last_unbrick_ts Last Unbrick Timestamp mfg_ts Manufacturing Timestamp mkt_part_id Marketing Part Number mobile_country_cd Mobile Country Code mobile_network_cd Mobile Network Code network_name Mobile Network Name order_ts Order Timestamp original_policy_desc Original Activation Policy part_desc Part Description phone_nr Phone Number pipod_ind Personalized Product Indicator policy_desc Activation Policy postal_cd Postal Code pos_rcpt_nr Point of Sale Receipt Number prod_desc Product Description prod_version_cd Software Version row_added_ts Record Creation Timestamp row_last_maint_ts Last Modified Timestamp serial_nr Serial Number ship_country_cd Ship Point Country state State street_address Street Address unlock_ind Unlock Status unlock_ts Unlock Timestamp wifi_mac_addr Wifi MAC Address for iOS Devices CRM AppleCare Case Header Column Name Column Description agmt_id Extended warranty agreement id if available case_id CRM unique case id number used to track customer interaction. case_type_cd Sources GSX, Technical, Retail, etc. closed_dt Available some of the time. closed_ts Case closure date & time (where relevant) comptia_cd Computer Industry Repair Failure Codes comp_cd Case Component Code country_cd Country Code creation_ts Case creation date & time cust_id Apple Customer Account number eligible_prod_id Eligible product id number issue_cd Case Issue code lang_cd Language designator code i.e. E for English priority_cd Norm or NULL most of the time. region_cd Region Code serial_nr Serialized product identifier source_id Source of interaction status_cd Case Status summary_txt Brief summary for the case notes CRM AppleCare Case Contact Column Name Column Description home_email_addr_txt Home Email Address Text home_phone_nr Home Phone Number mktg_email_ind accepts email indicator mktg_pmail_ind accepts letter mail indicator office_addr_1_txt Office Address Text office_city_name Office City Name office_country_name Office Country Name office_email_addr_txt Office Email Address Text office_phone_nr Office Phone Number office_postal_cd Office Postal Code office_state_name Office State Name person_id Unique person identifier phone_calls_ind accepts phone calls indicator pref_addr_1_txt Preferred Address Text pref_city_name Preferred City Name pref_country_name Preferred Country Name pref_email_addr_txt Preferred Email Address Text pref_phone_nr Preferred Phone Number pref_postal_cd Preferred Postal Code pref_state_name Preferred State Name Repair Transactional Details Column Name Column Description acdnt_damage_ind Accidental damage indicator activity_ts Activation Date & time stamp alt_phone_nr Alternate Customer Phone number ap_serial_status_cd Affected Product Serial Status Code biz_unit_cd Indicates AppleCare vs Account sales support box_reqd_ind Box Required Indicator brick_ind Bricking indicator case_id CRM unique case identifier city_postal_cd Repair city postal code closed_ts Repair Completion date & time stamp comptia_cd Computer Industry Association repair codes comptia_desc Computer Industry Association repair code descriptions country_cd Repair country code csmt_damage_fix_ind Cosmetic fix indicator csmt_damage_ind Cosmetic Damage indicator currency_cd Currency Code 3 digit cust_phone_nr Customer Phone number dispatch_clean_txt Dispatch Summary text cleaned of tabs and special characters dispatch_id Unique Repair Transaction ID from CRM system dispatch_txt Summary of repair issue and resolution dispatch_type_cd C-IN = Carry In email_id email address text icc_id ICC id imei_nr IMEI number iph_repair_ind iPhone Repair indicator last_call_tm Last call date & time stamp new_part_serial_nr New part serial number old_part_serial_nr Old part serial number ovrd_warranty_rslt_ind Warranty override Result indicator (Y,N) part_desc Part decriptions phone_nr Customer Phone number pickup_delivery_ind Pickup Delivery Indicator policy_id Policy Identification Number pos_rcpt_nr POS Receipt Number price_amt Price Amount procare_ind ProCare indicator purch_order_received_ind Purchase Order indicator quote_id Quote ID Number reason_desc Summary - Reason Description repair_estimate_amt Populated for certain repair types repair_ind R for Repair or D for Dispatch repair_scenario_desc Sub category of the repair rep_comment_txt Free text populated some of the time resolution_cd Resolution Code row_added_ts Date & Time the record was added to this table sap_ts SAP Repair Creation Date & Timestamp sap_warranty_cd SAP Warranty claim Code sap_warranty_new_cd New SAP warranty coverage for device or module serial_nr Unique Device Serial number state_name Repair state name svc_reason_cd Service Reason Code swap_repair_ind Repair swap indicator (Y, N, & NULL) sw_version_val iOS related tax_amt Tax Amount total_amt Total Amount warranty_coverage_cd Warranty Coverage of the device warranty_coverage_new_cd New warranty coverage for device or module Marketing Contact Column Name Column Description accepts_apple_email Currently Accepts Apple Email accepts_itunes_email Currently Accepts iTunes Email addr_line_1_txt Address Line 1 Text addr_line_2_txt Address Line 2 Text apple_email_contactable Currently Apple Email Contactable apple_id_ind Apple ID Indicator city_name City Name country_cd Country Code create_dt Create Date email_addr_txt Email Address Text first_contact_dt First Contact Date first_name First Name home_phone_nr Home Phone Number indiv_id Individual Identifier last_12_months_email_contacts Total Email Contacts in Last 12 Months last_contact_dt Last Contact Date last_name Last Name official_phone_nr Daytime Phone Number person_id Person Identifier postal_cd Postal Code postal_extn_cd Postal Code Extension state_name State Name