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 |