Properties
-
Name – TransactionData
-
Label – Transaction Data
Fields
-
Customer Id – String
-
Product Id – String
-
Cumulative Name – String
-
PFX Complete Customer Hierarchy – String
-
PFX Complete Product Hierarchy – String
-
Product Name – String
-
Customer Name – String
-
Quantity – Number
-
Profit – Number
-
Revenue – Number
-
List Price – Number
-
Reference Price – Number
-
Reference Price Extended – Number
-
Date – Date
-
Month – Date
-
Quarter – Text
-
Year – Text
-
Customer Hierarchy – String
-
Customer Attributes – String
-
Product Hierarchy Fields – String
-
Product Attributes – String
-
Additional Attributes – String
-
Waterfall Fields – String
The available fields are determined by the fields present in your source datamart.
Example Values
|
Customer Id |
Product Id |
Customer Name |
PFX Complete Customer Hierarchy |
PFX Complete Product Hierarchy |
Product Name |
Quantity |
Profit |
Revenue |
List Price |
Reference Price |
Reference Price Extended |
Date |
Month |
Quarter |
Year |
Segmentation |
Industry |
City |
Country |
Customer Class |
Customer Type |
Region |
Sales Org |
Sales Person |
Parent Field Name |
Top Level Hierarchy |
Top Level Name |
Business Unit |
Product Group |
Global List Price |
Local Adjustment |
Customer Discount |
Standard Discount |
|
C-0113 |
P-0206 |
RW Beckett |
Civil aircraft-Aerospace |
Industrial & Scientific-Power Transmission Products |
5 Accu-Link V-Belt Belting, 1/2 inch |
10 |
248.25 |
415.02 |
20.58 |
40.332 |
403.32 |
2025-10-01 |
2025-M10 |
2025-Q4 |
2025 |
Civil aircraft |
Aerospace |
Elizabeth City |
United States of America |
C |
Industry |
AMER |
South |
Chandler Buckley |
Businessity Group |
TLH-02 |
Businessity Group |
Industrial & Scientific |
Power Transmission Products |
415.02 |
11.7 |
0 |
20.58 |
|
C-0113 |
P-0241 |
RW Beckett |
Civil aircraft-Aerospace |
Industrial & Scientific-Power Transmission Products |
Wire Compression Spring, 0.72" OD x 0.063" Wire Size x 1.25" Free Length (Pack of 5) |
10 |
38.25 |
122.1 |
5.02 |
11.956 |
119.56 |
2025-10-01 |
2025-M10 |
2025-Q4 |
2025 |
Civil aircraft |
Aerospace |
Elizabeth City |
United States of America |
C |
Industry |
AMER |
South |
Chandler Buckley |
Businessity Group |
TLH-02 |
Businessity Group |
Industrial & Scientific |
Power Transmission Products |
122.1 |
2.54 |
0 |
5.02 |
|
C-0113 |
P-0381 |
RW Beckett |
Civil aircraft-Aerospace |
Industrial & Scientific-Material Handling Products |
Magnet 3/8" Stubby |
10 |
213.66 |
392.16 |
24.47 |
38.385 |
383.85 |
2025-10-01 |
2025-M10 |
2025-Q4 |
2025 |
Civil aircraft |
Aerospace |
Elizabeth City |
United States of America |
C |
Industry |
AMER |
South |
Chandler Buckley |
Businessity Group |
TLH-02 |
Businessity Group |
Industrial & Scientific |
Material Handling Products |
392.16 |
8.31 |
0 |
24.47 |