Cash Facts
This module uses the following central fact table(s) for analytics.
CUB_AccountsPayable
| Column | Type | Description |
|---|---|---|
| LedgerEntryDocumentTypeBK | string | |
| LedgerEntryTypeBK | string | |
| VendLedgerEntryNo | string | |
| DetVendLedgerEntryNo | string | |
| AppliedVendLedgerEntryNo | string | |
| DetailedLedgerEntryDocumentTypeBK | string | |
| AR_Amount_OrigPmtDiscPossible | double | |
| AR_Amount_PmtDiscRcd | double | |
| DetailDocumentType_Orig | int64 | |
| DateBK | dateTime | |
| DueDateBK | dateTime | |
| ClosedAtDateBK | dateTime | |
| PmtDiscountDateBK | dateTime | |
| DocumentDateBK | dateTime |
CUB_AccountsReceivable
| Column | Type | Description |
|---|---|---|
| LedgerEntryDocumentTypeBK | string | |
| LedgerEntryTypeBK | string | |
| CustLedgerEntryNo | string | |
| DetCustLedgerEntryNo | string | |
| AR_Amount_OrigPmtDiscPossible | double | |
| AR_Amount_PmtDiscGiven | double | |
| lastIssuedReminderLevel | int64 | |
| DetailedLedgerEntryDocumentTypeBK | string | |
| DetailDocumentType_Orig | int64 | |
| AppliedCustLedgerEntryNo | string | |
| DateBK | dateTime | |
| DueDateBK | dateTime | |
| CloseAtDateBK | dateTime | |
| PmtDiscountDateBK | dateTime | |
| DocumentDateBK | dateTime |
CUB_ExchangeRate
All columns of this fact table are hidden and surfaced through measures.
Note
Numeric fact columns are typically surfaced through measures rather than used directly. See KPIs for the ready-to-use measures built on these facts.