Transaction Detail summary

transaction_detail_id

Uniquely identifies transaction detail record at the line item level.

BIGINT

Distinct transaction_detail_id from TRANSACTION_DETAIL.

transaction_datetime

Date time when transaction occurred.

DATETIME

transaction_datetime from TRANSACTION_DETAIL record with the same transaction_detail_id.

transaction_id

Uniquely identifies transaction such as RETAIL SALES, RETAIL RETURNS, WEB SALES, WEB RETURNS.

BIGINT

transaction_id from TRANSACTION_DETAIL record with the same transaction_detail_id.

source_transaction_id

Transaction number at the source system.

NVARCHAR(200)

source_transaction_id from TRANSACTION_HEADER joined to TRANSACTION_DETAIL on transaction_id record with the same transaction_detail_id.

purchase_order_id

Either web order id of the customer's order generated by eCommerce system or a combination of transaction ID, store ID, and other data that makes a purchase unique within POS system.

NVARCHAR(200)

purchase_order_id from TRANSACTION_DETAIL record with the same transaction_detail_id.

pos_transaction_id

Transaction number generated by POS system.

NVARCHAR(200)

TRANSACTION_HEADER.pos_transaction_id joined to TRANSACTION_DETAIL on transaction_id.

register_num

Register identifier used for placing an order.

BIGINT

register_num from TRANSACTION_HEADER joined to TRANSACTION_DETAIL on transaction_id record with the same transaction_detail_id.

transaction_location_id

Uniquely identifies a Location where transaction took place (location can be a store or website).

BIGINT

transaction_location_id from TRANSACTION_HEADER joined to TRANSACTION_DETAIL on transaction_id record with the same transaction_detail_id.

transaction_source_location_id

Transaction number at the source system.

NVARCHAR(100)

transaction_source_location_id from TRANSACTION_HEADER joined to TRANSACTION_DETAIL on transaction_id record with the same transaction_detail_id.

transaction_location_type_code

Defines the type of location (could have more types).

Examples:

• B&M: brick and mortar store

• WEB: website

• Warehouse

• Headquarters

NVARCHAR(50)

location_type_code from LOCATION joined on location_id = transaction_location_id of corresponding TRANSACTION_HEADER joined on transaction_id.

transaction_location_city

Location's city name.

NVARCHAR(64)

std_city from LOCATION joined on location_id = transaction_location_id of corresponding TRANSACTION_HEADER joined on transaction_id.

transaction_location_postal_code_1

Location's postal code.

NVARCHAR(16)

std_postal_code_1 from LOCATION joined on location_id = transaction_location_id of corresponding TRANSACTION_HEADER joined on transaction_id.

transaction_location_postal_code_2

Location's postal code.

NVARCHAR(16)

std_postal_code_2 from LOCATION joined on location_id = transaction_location_id of corresponding TRANSACTION_HEADER joined on transaction_id.

transaction_location_latitude

Latitude of the store where transaction took place.

DECIMAL(10, 7)

latitude from LOCATION joined on location_id = transaction_location_id of corresponding TRANSACTION_HEADER joined on transaction_id.

transaction_location_longitude

Longitude of the store where transaction took place.

DECIMAL(10, 7)

longitude from LOCATION joined on location_id = transaction_location_id of corresponding TRANSACTION_HEADER joined on transaction_id.

transaction_location_state_province

Location's state code.

NVARCHAR(64)

std_state from LOCATION joined on location_id = transaction_location_id of corresponding TRANSACTION_HEADER joined on transaction_id.

transaction_location_country_code

Location's country code.

NVARCHAR(2)

iso_2_country_code from LOCATION joined on location_id = transaction_location_id of corresponding TRANSACTION_HEADER joined on transaction_id.

invoice_num

Value that uniquely identifies invoice in the fulfillment system.

NVARCHAR(50)

invoice_num from TRANSACTION_HEADER joined on transaction_id.

business_unit_code

Identifies unique association between an individual and business unit.

NVARCHAR(50)

business_unit_code from TRANSACTION_HEADER joined on transaction_id.

transaction_type_code

Uniquely identifies a type of transaction.

Examples:

• sale

• canceled_order

• placed_order

• return

• price_adj

NVARCHAR(50)

transaction_type_code from TRANSACTION_HEADER joined on transaction_id.

transaction_source_id

Numeric ID of the source of this record.

INT

source_id from TRANSACTION_DETAIL.

transaction_source_name

Name ID of the source of this record.

NVARCHAR(50)

source_name from local_LOOKUP joined on TRANSACTION_DETAIL.local_id.

transaction_feed_id

Feed ID of the transaction header record.

INT

TRANSACTION_HEADER.feed_id joined to TRANSACTION_DETAIL on transaction_id.

transaction_sor_name

Name of the system that is the authoritative data source for the transaction.

NVARCHAR(100)

TRANSACTION_HEADER.sor_name joined to TRANSACTION_DETAIL on transaction_id.

individual_id

Uniquely identifies the individual associated with transaction.

BIGINT

individual_id from TRANSACTION_CUSTOMER_MAP joined on transaction_id.

individual_business_unit_id

Identifies unique association between an individual and business unit associated with transaction.

BIGINT

individual_business_unit_id from TRANSACTION_CUSTOMER_MAP joined on transaction_id.

age

The age of the individual associated with transaction, calculated at the time the summary record created.

INT

Calculated based upon birthdate AS (datediff(year,[birth_date],getdate())).

gender_code

A code that identifies individual's gender (F, M, or U).

NVARCHAR(1)

Join to PARTY_PROFILE and MATCH_INSTANCE on individual_business_unit_id and select MATCH_INSTANCE.gender_code from the record with PARTY_PROFILE.max(local_rec_create_datetime).

birth_date

Date of birth of the individual associated with transaction.

DATE

Join to dbo.PARTY_PROFILE and ir.MATCH_INSTANCE on  individual_business_unit_id and select MATCH_INSTANCE.birth_date from the record with PARTY_PROFILE.max(local_rec_create_datetime).

party_profile_id

Identifies customer profile associated with transaction.

BIGINT

party_profile_id from TRANSACTION_CUSTOMER_MAP joined on transaction_id.

source_party_profile_id

Identifies customer profile within legacy system associated with transaction.

NVARCHAR(320)

source_party_profile_id from TRANSACTION_CUSTOMER_MAP joined on transaction_id.

customer_account_id

Identifies customer account associated with transaction.

BIGINT

customer_account_id from TRANSACTION_CUSTOMER_MAP joined on transaction_id.

source_customer_account_id

Identifies customer account within legacy system associated with transaction.

NVARCHAR(320)

source_customer_account_id from TRANSACTION_CUSTOMER_MAP joined on transaction_id.

loyalty_account_id

Identifies loyalty account associated with transaction.

BIGINT

loyalty_account_id from TRANSACTION_CUSTOMER_MAP joined on transaction_id.

source_loyalty_account_id

Identifies loyalty account within legacy system associated with transaction.

NVARCHAR(320)

source_loyalty_account_id from TRANSACTION_CUSTOMER_MAP joined on transaction_id.

bill_to_email_id

Uniquely identifies bill to email associated with transaction.

BIGINT

bill_to_email_id from TRANSACTION_CUSTOMER_MAP joined on transaction_id.

bill_to_email_domain

An email domain is the web address that comes after the @ symbol in an email address associated with transaction (e.g., gmail.com).

NVARCHAR(255)

email_domain from ir.EMAIL where ir.EMAIL.email_id = TRANSACTION_CUSTOMER_MAP.bill_to_email_id joined on transaction_id.

bill_to_email_country_code

ISO standard code for bill to email.

NVARCHAR(2)

domain_iso_2_country_code from EMAIL joined on email_id = TRANSACTION_CUSTOMER_MAP.bill_to_email_id joined on transaction_id.

bill_to_address_id

Uniquely identifies the standardized phone or fax number.

BIGINT

bill_to_address_id from TRANSACTION_CUSTOMER_MAP joined on transaction_id.

bill_to_city

Bill to city or local name.

NVARCHAR(64)

bill_to_city from TRANSACTION_CUSTOMER_MAP joined on transaction_id.

bill_to_postal_code

Bill to postal code.

NVARCHAR(16)

bill_to_postal_code from TRANSACTION_CUSTOMER_MAP joined on transaction_id.

bill_to_address_latitude

Latitude of bill to address.

DECIMAL(10, 7)

ir.ADDRESS.latitude where ir.ADDRESS.address_id = TRANSACTION_CUSTOMER_MAP.bill_to_address_id.

bill_to_address_longitude

Longitude of bill to address.

DECIMAL(10, 7)

ir.ADDRESS.longitude where ir.ADDRESS.address_id = TRANSACTION_CUSTOMER_MAP.bill_to_address_id.

bill_to_country_code

ISO standard code for bill to country.

NVARCHAR(2)

bill_to_country_code from TRANSACTION_CUSTOMER_MAP joined on transaction_id.

bill_to_mobile_phone_country_code

Standard 2-character country code for bill to cell phone number.

NVARCHAR(2)

bill_to_mobile_phone_country_code from TRANSACTION_CUSTOMER_MAP joined on transaction_id.

bill_to_mobile_phone_id

Customer's bill to cell phone number, including area code.

BIGINT

bill_to_mobile_phone_id from TRANSACTION_CUSTOMER_MAP joined on transaction_id.

bill_to_home_phone_country_code

Standard 2-character country code for bill to home phone number.

NVARCHAR(2)

bill_to_home_phone_country_code from TRANSACTION_CUSTOMER_MAP joined on transaction_id.

bill_to_home_phone_id

Customer's bill to home phone number, including area code.

BIGINT

bill_to_home_phone_id from TRANSACTION_CUSTOMER_MAP joined on transaction_id.

bill_to_work_phone_country_code

Standard 2-character country code for bill to work phone number.

NVARCHAR(2)

bill_to_work_phone_country_code from TRANSACTION_CUSTOMER_MAP joined on transaction_id.

bill_to_work_phone_id

Customer's bill to work phone number, including area code.

BIGINT

bill_to_work_phone_id from TRANSACTION_CUSTOMER_MAP joined on transaction_id.

bill_to_other_phone_country_code

Standard 2-character country code for bill to other phone number.

NVARCHAR(2)

bill_to_other_phone_country_code from TRANSACTION_CUSTOMER_MAP joined on transaction_id.

bill_to_other_phone_id

Customer's bill to "other" phone number, including area code.

BIGINT

bill_to_other_phone_id from TRANSACTION_CUSTOMER_MAP joined on transaction_id.

bill_to_other_phone_type_code

The type of the phone such as billing, shipping, home, work, primary, mobile, or other, as defined in the reference data worksheet.

NVARCHAR(50)

bill_to_other_phone_type_code from TRANSACTION_CUSTOMER_MAP joined on transaction_id.

transaction_line_item_count

Total number of line items included in the transaction.

INT

transaction_line_item_count from TRANSACTION_HEADER joined on transaction_id.

transaction_standard_date

Standard date of the transaction (YYYY-MM-DD).

DATE

standard_date from DATE_LOOKUP joined on "formatted date ( YYYY-MM-DD)" that corresponds to TRANSACTION_DETAIL.transaction_datetime.

fiscal_day_of_fiscal_year_num

Number of the fiscal day of the fiscal year.

INT

fiscal_day_of_fiscal_year_num from DATE_LOOKUP joined on standard_date corresponding to "formatted date ( YYYY-MM-DD)" TRANSACTION_DETAIL.transaction_datetime.

fiscal_disp_year

Fiscal year displayed (e.g., 2024).

INT

fiscal_disp_year from DATE_LOOKUP joined on date corresponding to TRANSACTION_DETAIL.transaction_datetime.

fiscal_qtr_num

Fiscal quarter number (i.e., 1, 2, 3, 4).

INT

fiscal_qtr_num from DATE_LOOKUP joined on date corresponding to TRANSACTION_DETAIL.transaction_datetime.

fiscal_month_num

Fiscal month number (1, 2, …, 12).

INT

fiscal_month_num from DATE_LOOKUP joined on date corresponding to TRANSACTION_DETAIL.transaction_datetime.

fiscal_week_num

Fiscal week number (1, 2, …, 52).

INT

fiscal_week_num from DATE_LOOKUP joined on date corresponding to TRANSACTION_DETAIL.transaction_datetime.

fiscal_week_of_fiscal_year_num

Fiscal week of fiscal year number (202402, 202306, 201912)

INT

fiscal_week_of_fiscal_year_num from DATE_LOOKUP joined on date corresponding to TRANSACTION_DETAIL.transaction_datetime.

global_total_transaction_amount

Total transaction amount in USD.

NUMERIC(20, 6)

global_total_transaction_amount from TRANSACTION_HEADER joined on transaction_id.

local_total_transaction_amount

Total transaction amount in local currency.

NUMERIC(20, 6)

local_total_transaction_amount from TRANSACTION_HEADER joined on transaction_id.

global_total_non_merchandise_amount

Total non-merchandise amount (including GC purchases, Shipping, Restock Fees, etc.), decimal not included, (e.g., $1 = 100) in USD.

NUMERIC(20, 6)

global_total_non_merchandise_amount from TRANSACTION_HEADER joined on transaction_id.

local_total_non_merchandise_amount

Non-merchandise amount (including Shipping and Restock Fee, Delivery Fee, any services fee, etc.) in local currency.

NUMERIC(20, 6)

local_total_non_merchandise_amount from TRANSACTION_HEADER joined on transaction_id.

global_sub_total_transaction_amount

Subtotal amount of the transaction before taxes and fees in USD.

NUMERIC(20, 6)

global_sub_total_transaction_amount from TRANSACTION_HEADER joined on transaction_id.

local_sub_total_transaction_amount

Subtotal amount of the transaction before taxes and fees.

NUMERIC(20, 6)

local_sub_total_transaction_amount from TRANSACTION_HEADER joined on transaction_id.

global_total_discount_amount

Total amount of all discounts applied for entire purchase in USD.

NUMERIC(20, 6)

global_total_discount_amount from TRANSACTION_HEADER joined on transaction_id.

local_total_discount_amount

Total amount of all discounts applied for entire purchase.

NUMERIC(20, 6)

local_total_discount_amount from TRANSACTION_HEADER joined on transaction_id.

global_total_tax_amount

Total tax amount in USD.

NUMERIC(20, 6)

global_total_tax_amount from TRANSACTION_HEADER joined on transaction_id.

local_total_tax_amount

Total tax amount

NUMERIC(20, 6)

local_total_tax_amount from TRANSACTION_HEADER joined on transaction_id.

global_total_addtl_tax_amount

Additional tax amount in USD.

NUMERIC(20, 6)

global_total_addtl_tax_amount from TRANSACTION_HEADER joined on transaction_id.

local_total_addtl_tax_amount

Additional tax amount as per source system.

NUMERIC(20, 6)

local_total_addtl_tax_amount from TRANSACTION_HEADER joined on transaction_id.

shipping_type_code

Shipping method used, such as air, ground, store pickup, expedited, etc.

NVARCHAR(50)

shipping_type_code from TRANSACTION_HEADER joined on transaction_id.

shipping_type_desc

Description of a code that identifies a shipping method used such as air, ground, store pickup, etc.

NVARCHAR(100)

shipping_type_desc from SHIPPING_TYPE_LOOKUP joined on shipping_type_code for TRANSACTION_HEADER.transaction_id.

customer_associate_id

The ID of an associate who helped/processed customer's transaction.

NVARCHAR(100)

customer_associate_id from TRANSACTION_HEADER joined on transaction_id.

order_origin_name

The code that identifies the original source of the transaction (purchase order), such as a particular call center, particular store (when items were purchased online but from a particular B&M store location), an app, etc.

NVARCHAR(250)

order_origin_name from TRANSACTION_HEADER joined on transaction_id.

employee_id

When customer is also an employee, contains employee number.

NVARCHAR(20)

employee_id from TRANSACTION_HEADER joined on transaction_id.

transaction_detail_status_code

The status of the line item.

NVARCHAR(50)

transaction_detail_status_code from TRANSACTION_DETAIL joined on transaction_detail_id.

line_item_num

Line item number identifies transaction's line number that corresponds to the actual line on the receipt where the item appears.

INT

line_item_num from TRANSACTION_DETAIL joined on transaction_detail_id.

sku

Uniquely identifies a product in Stock-Keeping Unit (SKU) notation.

NVARCHAR(100)

sku from PRODUCT joined on product_id from TRANSACTION_DETAIL joined on transaction_detail_id.

upc

Uniquely identifies a product in Universal Product Code (UPC) notation.

NVARCHAR(100)

upc from PRODUCT joined on product_id from TRANSACTION_DETAIL joined on transaction_detail_id.

product_qty

Item quantity.

INT

product_qty from TRANSACTION_DETAIL joined on transaction_detail_id.

product_id

Identifies a product in the transaction line; references product hierarchy.

BIGINT

product_id from TRANSACTION_DETAIL joined on transaction_detail_id.

product_name

Name of the product.

NVARCHAR(200)

product_name from PRODUCT joined on product_id corresponding to TRANSACTION_DETAIL.product_id joined on transaction_detail_id.

product_desc

A description of the product.

NVARCHAR(1000)

product_desc from PRODUCT joined on product_id corresponding to TRANSACTION_DETAIL.product_id joined on transaction_detail_id.

product_class_code

Identifies merchandise class that groups similar products together that share specific qualities. For example, women's evening wear can be broken down into floor length dresses and street length dresses.

NVARCHAR(50)

class_code from PRODUCT joined on product_id corresponding to TRANSACTION_DETAIL.product_id joined on transaction_detail_id.

product_class_name

Name of merchandise class that groups similar products together that share specific qualities. For example, women's evening wear can be broken down into floor length dresses and street length dresses.

NVARCHAR(60)

class_name from PRODUCT joined on product_id corresponding to TRANSACTION_DETAIL.product_id joined on transaction_detail_id.

product_division_code

A code that identifies business subdivisions.

NVARCHAR(50)

product_division_code from PRODUCT joined on product_id corresponding to TRANSACTION_DETAIL.product_id joined on transaction_detail_id.

product_division_desc

Description of the division code.

NVARCHAR(100)

product_division_desc from PRODUCT joined on product_id corresponding to TRANSACTION_DETAIL.product_id joined on transaction_detail_id.

product_color_code

This is a free text field and has no lookups. The data type is varchar(50).

NVARCHAR(50)

color_code from PRODUCT joined on product_id corresponding to TRANSACTION_DETAIL.product_id joined on transaction_detail_id.

product_color_name

This is a free text field and has no lookups. The data type is varchar(60).

NVARCHAR(60)

color_name from PRODUCT joined on product_id corresponding to TRANSACTION_DETAIL.product_id joined on transaction_detail_id.

product_size_code

Whatever defines the size in the source system.

NVARCHAR(50)

size_code from PRODUCT joined on product_id corresponding to TRANSACTION_DETAIL.product_id joined on transaction_detail_id.

product_size_name

Whatever defines the name of the size in the source system.

NVARCHAR(60)

size_name from PRODUCT joined on product_id corresponding to TRANSACTION_DETAIL.product_id joined on transaction_detail_id.

product_custom_ind

When Y, indicates custom product.

NVARCHAR(1)

custom_ind from PRODUCT joined on product_id corresponding to TRANSACTION_DETAIL.product_id.

product_sub_department_name

Name of sub-departments, such as outwear in the clothing department.

NVARCHAR(60)

sub_department_name from PRODUCT joined on product_id corresponding to TRANSACTION_DETAIL.product_id.

product_sub_department_desc

Descriptive name of sub-department code, such as men's or women's shoes and clothing.

NVARCHAR(100)

sub_department_desc from PRODUCT joined on product_id corresponding to TRANSACTION_DETAIL.product_id.

product_status_code

Product status code, such as active, discontinued, pending, etc.

NVARCHAR(50)

product_status_code from PRODUCT joined on product_id corresponding to TRANSACTION_DETAIL.product_id.

product_status_desc

A description of the product status code.

NVARCHAR(100)

product_status_desc from PRODUCT_STATUS_LOOKUP joined on product_status_code for corresponding to TRANSACTION_DETAIL.product_id.

product_style

Whatever defines style in the source system.

NVARCHAR(50)

product_style from PRODUCT joined on product_id corresponding to TRANSACTION_DETAIL.product_id.

product_style_desc

A description of the product style.

NVARCHAR(100)

product_style_desc from PRODUCT joined on product_id corresponding to TRANSACTION_DETAIL.product_id.

product_material_id

Product material ID.

NVARCHAR(50)

material_id from PRODUCT joined on product_id corresponding to TRANSACTION_DETAIL.product_id.

product_brand_code

Defines a product's brand.

NVARCHAR(50)

brand_code from PRODUCT joined on product_id corresponding to TRANSACTION_DETAIL.product_id.

product_brand_desc

A description of the brand.

NVARCHAR(100)

brand_desc from PRODUCT joined on product_id corresponding to TRANSACTION_DETAIL.product_id.

product_category_code

The type is a classification of the entity.

NVARCHAR(50)

product_category_code from PRODUCT joined on product_id corresponding to TRANSACTION_DETAIL.product_id.

product_category_desc

Product category description.

NVARCHAR(100)

product_category_desc from PRODUCT_CATEGORY_LOOKUP joined on product_category_code for corresponding TRANSACTION_DETAIL.product_id.

sold_at_discount_ind

When Y, indicates that the final price paid for the item is less than retail price amount (global_total_item_discount_amount > 0).

NVARCHAR(1)

Set to Y when value of global_net_sales_amount < global_total_item_amount.

global_net_sales_amount

The final price the customer paid, after all markdowns, discounts, or coupons have been applied in USD.

NUMERIC(20, 6)

global_net_sales_amount from TRANSACTION_DETAIL.

local_net_sales_amount

The final price the customer paid, after all markdowns, discounts, or coupons have been applied in local currency.

NUMERIC(20, 6)

local_net_sales_amount from TRANSACTION_DETAIL.

global_total_item_amount

The price the before markdowns, discounts, or coupons have been applied in USD (global_retail_price_amount * product_qty).

NUMERIC(20, 6)

global_total_item_amount from TRANSACTION_DETAIL.

local_total_item_amount

The price the before markdowns, discounts, or coupons have been applied in local currency (local_retail_price_amount * product_qty).

NUMERIC(20, 6)

local_total_item_amount from TRANSACTION_DETAIL.

global_total_item_discount_amount

Line item total discount amount in USD. For example, $10 discount based on a coupon + $5 based on store sale will be $15.

NUMERIC(20, 6)

global_total_item_discount_amount from TRANSACTION_DETAIL.

local_total_item_discount_amount

Line item total discount amount in local currency. For example, $10 discount based on a coupon + $5 based on store sale will be $15.

NUMERIC(20, 6)

local_total_item_discount_amount from TRANSACTION_DETAIL.

global_unit_cost_amount

The cost to produce the SKU in USD. Should be populated 99% of the time; will only be null if merch credit, gift card, MTM, or the like.

NUMERIC(20, 6)

global_unit_cost_amount from TRANSACTION_DETAIL.

local_unit_cost_amount

The amount of value of an item or a service.

NUMERIC(20, 6)

local_unit_cost_amount from TRANSACTION_DETAIL.

global_retail_price_amount

The price in USD originally assigned to an item before any markdowns, discounts, or coupons have been applied. Should be populated 99% of the time; will only be null if merch credit, gift card, MTM, or the like.

NUMERIC(20, 6)

global_retail_price_amount from TRANSACTION_DETAIL.

local_retail_price_amount

The price in USD/CAD originally assigned to an item before any markdowns, discounts, or coupons have been applied.

NUMERIC(20, 6)

local_retail_price_amount from TRANSACTION_DETAIL.

global_sale_price_amount

The price in USD assigned to an item after corporate markdowns, but before discounts or coupons are applied. This is currently retail_amount in the GCD trans table. Should be populated 99% of the time; will only be null if merch credit, gift card, MTM, or the like.

NUMERIC(20, 6)

global_sale_price_amount from TRANSACTION_DETAIL.

local_sale_price_amount

The amount of value of an item or a service.

NUMERIC(20, 6)

local_sale_price_amount from TRANSACTION_DETAIL.

global_item_tax_amount

The amount of value an item or a service in USD.

NUMERIC(20, 6)

global_item_tax_amount from TRANSACTION_DETAIL.

local_item_tax_amount

The amount of value an item or a service per source system.

NUMERIC(20, 6)

local_item_tax_amount from TRANSACTION_DETAIL.

global_addtl_tax_amount

Additional tax amount in USD.

NUMERIC(20, 6)

global_addtl_tax_amount from TRANSACTION_DETAIL.

local_addtl_tax_amount

Additional tax amount as per source system.

NUMERIC(20, 6)

local_addtl_tax_amount from TRANSACTION_DETAIL.

gift_item_ind

When Y indicates that the item is a gift.

NVARCHAR(1)

gift_item_ind from TRANSACTION_DETAIL.

gift_certificate_id

Unique ID for GCs purchased (only for SVS). Card number for physical or virtual gift card purchase or original order card number for price adjustments and returns. Left-adjusted with trailing blanks.

NVARCHAR(20)

gift_certificate_id from TRANSACTION_DETAIL.

taxable_ind

Taxable status:

• Y = taxable

• N = not taxable

NVARCHAR(1)

taxable_ind from TRANSACTION_DETAIL.

return_reason_code

A three-byte code that matches the reason why an item was returned.

NVARCHAR(50)

return_reason_code from TRANSACTION_DETAIL.

original_purchase_order_id

Original purchase order ID.

NVARCHAR(200)

original_purchase_order_id from TRANSACTION_DETAIL.

original_source_location_id

Original transaction location ID in the source system.

NVARCHAR(100)

original_source_location_id from TRANSACTION_DETAIL.

original_source_transaction_id

Original transaction number.

NVARCHAR(200)

original_source_transaction_id from TRANSACTION_DETAIL.

original_transaction_datetime

Date time when original transaction occurred.

DATETIME

original_transaction_datetime from TRANSACTION_DETAIL.

original_register_num

Register identifier used for placing an order.

BIGINT

original_register_num from TRANSACTION_DETAIL.

global_original_net_sales_amount

Net price per unit * quantity ordered; for price adjustments only. Decimal not included (i.e., $1 = 100) in USD; may be blank.

NUMERIC(20, 6)

global_original_net_sales_amount from TRANSACTION_DETAIL.

local_original_net_sales_amount

Net price per unit * quantity ordered; for price adjustments only. Decimal not included (i.e., 1 = 100); may be blank.

NUMERIC(20, 6)

local_original_net_sales_amount from TRANSACTION_DETAIL.

global_original_total_item_amount

Final price plus discount; for price adjustments only . Decimal not included (i.e., $1 = 100) in USD; may be blank.

NUMERIC(20, 6)

global_original_total_item_amount from TRANSACTION_DETAIL.

local_original_total_item_amount

Final price plus discount; for price adjustments only. Decimal not included (i.e., 1 = 100); may be blank.

NUMERIC(20, 6)

local_original_total_item_amount from TRANSACTION_DETAIL.

global_original_item_discount_amount

Line item discount amount; for price adjustments only. Decimal not included (i.e., $1 = 100) in USD; may be blank.

NUMERIC(20, 6)

global_original_item_discount_amount from TRANSACTION_DETAIL.

local_original_item_discount_amount

Line item discount amount; for price adjustments only. Decimal not included (i.e., 1 = 100); may be blank.

NUMERIC(20, 6)

local_original_item_discount_amount from TRANSACTION_DETAIL.

global_original_item_tax_amount

Line item tax amount; for price adjustments only. Decimal not included (i.e., $1 = 100) in USD; may be blank.

NUMERIC(20, 6)

global_original_item_tax_amount from TRANSACTION_DETAIL.

local_original_item_tax_amount

Line item tax amount; for price adjustments only. Decimal not included (i.e., 1 = 100); may be blank as per source system.

NUMERIC(20, 6)

local_original_item_tax_amount from TRANSACTION_DETAIL.

global_original_addtl_tax_amount

Line item tax amount; for price adjustments only. Decimal not included (i.e., $1 = 100) in USD; may be blank.

NUMERIC(20, 6)

global_original_addtl_tax_amount from TRANSACTION_DETAIL.

local_original_addtl_tax_amount

Line item tax amount; for price adjustments only. Decimal not included (i.e., 1 = 100); may be blank as per source system.

NUMERIC(20, 6)

local_original_addtl_tax_amount from TRANSACTION_DETAIL.

create_datetime

Date time when the record was created in the CDP.

DATETIME

create_datetime from TRANSACTION_DETAIL.

update_datetime

Date time when the record was last updated in the CDP.

DATETIME

update_datetime from TRANSACTION_DETAIL.