Column name | Column description | Data type | Business rule |
|---|
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: | 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.
|
