Column name | Column description | Business rule |
|---|
transaction_detail_id
| Uniquely identifies transaction detail record at the line item level. | Distinct transaction_detail_id from TRANSACTION_DETAIL. |
transaction_datetime
| Date time when transaction occurred. | 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. | transaction_id from TRANSACTION_DETAIL record with the same transaction_detail_id.
|
source_transaction_id
| Transaction number at the source system. | 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. | purchase_order_id from TRANSACTION_DETAIL record with the same transaction_detail_id.
|
pos_transaction_id
| Transaction number generated by POS system. | TRANSACTION_HEADER.pos_transaction_id joined to TRANSACTION_DETAIL on transaction_id.
|
register_num
| Register identifier used for placing an order. | 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). | 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. | 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: | 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. | 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. | 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. | 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. | 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. | 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. | 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. | 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. | invoice_num from TRANSACTION_HEADER joined on transaction_id.
|
business_unit_code
| Identifies unique association between an individual and business unit. | 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
| transaction_type_code from TRANSACTION_HEADER joined on transaction_id.
|
transaction_source_id
| Numeric ID of the source of this record. | source_id from TRANSACTION_DETAIL.
|
transaction_source_name
| Name ID of the source of this record. | source_name from local_LOOKUP joined on TRANSACTION_DETAIL.local_id.
|
transaction_feed_id
| Feed ID of the transaction header record. | 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. | TRANSACTION_HEADER.sor_name joined to TRANSACTION_DETAIL on transaction_id.
|
individual_id
| Uniquely identifies the individual associated with transaction. | 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. | 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. | Calculated based upon birthdate AS (datediff(year,[birth_date],getdate())). |
gender_code
| A code that identifies individual's gender (F, M, or U). | 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. | 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. | party_profile_id from TRANSACTION_CUSTOMER_MAP joined on transaction_id.
|
source_party_profile_id
| Identifies customer profile within legacy system associated with transaction. | source_party_profile_id from TRANSACTION_CUSTOMER_MAP joined on transaction_id.
|
customer_account_id
| Identifies customer account associated with transaction. | customer_account_id from TRANSACTION_CUSTOMER_MAP joined on transaction_id.
|
source_customer_account_id
| Identifies customer account within legacy system associated with transaction. | source_customer_account_id from TRANSACTION_CUSTOMER_MAP joined on transaction_id.
|
loyalty_account_id
| Identifies loyalty account associated with transaction. | loyalty_account_id from TRANSACTION_CUSTOMER_MAP joined on transaction_id.
|
source_loyalty_account_id
| Identifies loyalty account within legacy system associated with transaction. | source_loyalty_account_id from TRANSACTION_CUSTOMER_MAP joined on transaction_id.
|
bill_to_email_id
| Uniquely identifies bill to email associated with transaction. | 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). | 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. | 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. | bill_to_address_id from TRANSACTION_CUSTOMER_MAP joined on transaction_id.
|
bill_to_city
| Bill to city or local name. | bill_to_city from TRANSACTION_CUSTOMER_MAP joined on transaction_id.
|
bill_to_postal_code
| Bill to postal code. | bill_to_postal_code from TRANSACTION_CUSTOMER_MAP joined on transaction_id.
|
bill_to_address_latitude
| Latitude of bill to address. | ir.ADDRESS.latitude where ir.ADDRESS.address_id = TRANSACTION_CUSTOMER_MAP.bill_to_address_id.
|
bill_to_address_longitude
| Longitude of bill to address. | 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. | 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. | 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. | 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. | 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. | 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. | 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. | 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. | 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. | 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. | 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. | transaction_line_item_count from TRANSACTION_HEADER joined on transaction_id.
|
transaction_standard_date
| Standard date of the transaction (YYYY-MM-DD). | 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. | 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). | 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). | fiscal_qtr_num from DATE_LOOKUP joined on date corresponding to TRANSACTION_DETAIL.transaction_datetime.
|
fiscal_month_num
| Fiscal month number (1, 2, …, 12). | fiscal_month_num from DATE_LOOKUP joined on date corresponding to TRANSACTION_DETAIL.transaction_datetime.
|
fiscal_week_num
| Fiscal week number (1, 2, …, 52). | 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) | 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. | global_total_transaction_amount from TRANSACTION_HEADER joined on transaction_id.
|
local_total_transaction_amount
| Total transaction amount in local currency. | 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. | 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. | 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. | 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. | 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. | global_total_discount_amount from TRANSACTION_HEADER joined on transaction_id.
|
local_total_discount_amount
| Total amount of all discounts applied for entire purchase. | local_total_discount_amount from TRANSACTION_HEADER joined on transaction_id.
|
global_total_tax_amount
| Total tax amount in USD. | global_total_tax_amount from TRANSACTION_HEADER joined on transaction_id.
|
local_total_tax_amount
| Total tax amount | local_total_tax_amount from TRANSACTION_HEADER joined on transaction_id.
|
global_total_addtl_tax_amount
| Additional tax amount in USD. | global_total_addtl_tax_amount from TRANSACTION_HEADER joined on transaction_id.
|
local_total_addtl_tax_amount
| Additional tax amount as per source system. | 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. | 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. | 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. | 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. | order_origin_name from TRANSACTION_HEADER joined on transaction_id.
|
employee_id
| When customer is also an employee, contains employee number. | employee_id from TRANSACTION_HEADER joined on transaction_id.
|
transaction_detail_status_code
| The status of the line item. | 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. | line_item_num from TRANSACTION_DETAIL joined on transaction_detail_id.
|
sku
| Uniquely identifies a product in Stock-Keeping Unit (SKU) notation. | 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. | upc from PRODUCT joined on product_id from TRANSACTION_DETAIL joined on transaction_detail_id.
|
product_qty
| Item quantity. | product_qty from TRANSACTION_DETAIL joined on transaction_detail_id.
|
product_id
| Identifies a product in the transaction line; references product hierarchy. | product_id from TRANSACTION_DETAIL joined on transaction_detail_id.
|
product_name
| Name of the product. | 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. | 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. | 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. | 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. | 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. | 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). | 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). | 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. | 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. | 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. | 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. | 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. | 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. | 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. | 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. | product_style from PRODUCT joined on product_id corresponding to TRANSACTION_DETAIL.product_id.
|
product_style_desc
| A description of the product style. | product_style_desc from PRODUCT joined on product_id corresponding to TRANSACTION_DETAIL.product_id.
|
product_material_id
| Product material ID. | material_id from PRODUCT joined on product_id corresponding to TRANSACTION_DETAIL.product_id.
|
product_brand_code
| Defines a product's brand. | brand_code from PRODUCT joined on product_id corresponding to TRANSACTION_DETAIL.product_id.
|
product_brand_desc
| A description of the brand. | 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. | product_category_code from PRODUCT joined on product_id corresponding to TRANSACTION_DETAIL.product_id.
|
product_category_desc
| Product category description. | 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). | 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. | 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. | 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). | 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). | 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. | 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. | 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. | global_unit_cost_amount from TRANSACTION_DETAIL.
|
local_unit_cost_amount
| The amount of value of an item or a service. | 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. | 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. | 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. | global_sale_price_amount from TRANSACTION_DETAIL.
|
local_sale_price_amount
| The amount of value of an item or a service. | local_sale_price_amount from TRANSACTION_DETAIL.
|
global_item_tax_amount
| The amount of value an item or a service in USD. | global_item_tax_amount from TRANSACTION_DETAIL.
|
local_item_tax_amount
| The amount of value an item or a service per source system. | local_item_tax_amount from TRANSACTION_DETAIL.
|
global_addtl_tax_amount
| Additional tax amount in USD. | global_addtl_tax_amount from TRANSACTION_DETAIL.
|
local_addtl_tax_amount
| Additional tax amount as per source system. | local_addtl_tax_amount from TRANSACTION_DETAIL.
|
gift_item_ind
| When Y indicates that the item is a gift. | 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. | gift_certificate_id from TRANSACTION_DETAIL.
|
taxable_ind
| Taxable status: Y = taxable
N = not taxable
| taxable_ind from TRANSACTION_DETAIL.
|
return_reason_code
| A three-byte code that matches the reason why an item was returned. | return_reason_code from TRANSACTION_DETAIL.
|
original_purchase_order_id
| Original purchase order ID. | original_purchase_order_id from TRANSACTION_DETAIL.
|
original_source_location_id
| Original transaction location ID in the source system. | original_source_location_id from TRANSACTION_DETAIL.
|
original_source_transaction_id
| Original transaction number. | original_source_transaction_id from TRANSACTION_DETAIL.
|
original_transaction_datetime
| Date time when original transaction occurred. | original_transaction_datetime from TRANSACTION_DETAIL.
|
original_register_num
| Register identifier used for placing an order. | 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. | 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. | 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. | 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. | 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. | 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. | 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. | 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. | 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. | 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. | local_original_addtl_tax_amount from TRANSACTION_DETAIL.
|
create_datetime
| Date time when the record was created in the CDP. | create_datetime from TRANSACTION_DETAIL.
|
update_datetime
| Date time when the record was last updated in the CDP. | update_datetime from TRANSACTION_DETAIL.
|
