ACR Credit Control
This table shows the table from which fields are retrieved for the dimension:
Table | Description |
---|---|
tccom001 | Employees – General |
tccom112 | Invoice-to Business Partners |
tcmcs064 | Credit Ratings |
This table shows the attribute mapping for the dimension:
Attribute | Mapping |
---|---|
Company | tfacr200_compnr |
Credit Analyst | tccom112.ccra |
Credit Analyst ID Name | tccom112.ccra + tccom001.nama |
Credit Analyst Name | tccom001.nama |
Credit Rating | tccom112.crat |
Credit Rating Desc | tcmcs064.dsca |
Unknown | 1 for null records, else 0 |
deleted | 1 if deleted in LN, else 0 |