Attributes

The mapping guide describes the available attributes for each dimension.

This table shows the dimensions targeted by the sales contract line fact:

Dimension Type Note
Buy-from BP Conformed tdsls301.bfbp
Carrier LSP Conformed tdsls300.cfrw
Company Conformed tdsls301.compnr
Customer Item Domain specific tdsls301.citt Item Code System

tdsls301.ofbp Sold-to BP

tdsls301.item Item

External Sales Rep Conformed tdsls300.osrp
Financial Company Conformed Read from Sales Office, equal to Company if Sales Office is empty
Intermediate Consignee Conformed tdsls301.imcs
Internal Sales Rep Conformed tdsls300.crep
Invoice-to BP Conformed tdsls300.itbp
Item Conformed tdsls301.item
Pay-by BP Conformed tdsls300.pfbp
Sales Contract Line Domain specific tdsls301.cono Contract

tdsls301.cpon Line

tdsls301.cofc Sales Office

Sales Office Conformed tdsls301.cofc
Ship-from BP Conformed tdsls301.sfbp
Ship-to Address Conformed tdsls301.stad
Ship-to BP Conformed tdsls301.stbp
Site Conformed tdsls301.site
Sold-to Address Conformed tdsls300.ofad
Sold-to BP Conformed tdsls301.ofbp
Time Birst Only for the Sales Contract Line Analysis fact. Does not support day level.
Transaction Currency Conformed tdsls300.ccur
Transaction Unit Conformed tdsls301.cuqs
Warehouse Conformed tdsls301.cwar