Accounts Receivable
This table shows the table from which fields are retrieved for the dimension:
| Table | Description |
|---|---|
| tcmcs002 | Currencies |
| tcmcs010 | Countries |
| tcmcs037 | Tax Codes |
| tfacr002 | Problem |
| tfacr003 | Problem References |
| tfacr200 | Open Items (Sales Invoices & Receipts) |
| tfgld011 | Transaction Types |
This table shows the attribute mapping for the dimension:
| Attribute | Mapping |
|---|---|
| Clearing Date | Document date of the final receipt or settlement, settling the invoice or credit
notes. If Open Entry = 0, then the document date of the final receipt or settlement, settling the accounts receivable. For all other scenarios, ‘9999-12-31’. |
| Company | tfacr200_compnr |
| Country for Tax | tfacr200.ccty |
| Country for Tax Desc | tcmcs010.dsca |
| Currency | tfacr200.ccur |
| Currency Desc | tcmcs002.dsca |
| Days Clearing | Days it took to settle the invoice or credit note. If Open Entry = 0, then DATEDIFF (Day, Clearing Date, Document Date) Else, 0 |
| Days Overdue | Days the settled invoice and credit note was late. If (Open Entry = 0 And Late = 1), then DATEDIFF (DAY, Clearing Date, Due Date). Else, 0. |
| Document | tfacr200.ninv |
| Document Date | tfacr200.docd |
| Document Type | tfacr200.trec |
| Document Type Filter | tfacr200.trec |
| Document Type Sort | tfacr200.trec |
| Due Date | tfacr200.dued |
| First Discount Amount | First discount amount for a customer. For invoice currency, tfacr200.di1i. For transaction currency, tfacr200.ld1a. Else, tfacr200.di1h. |
| First Discount Date | tfacr200.did1 |
| Last Receipt Date | Document date of the latest Receipt or Settlement on the invoice or credit note. |
| Late | 1, if non-open receivable has a clearing date greater than the due date. Else, 0. |
| Late Outstanding | 1, if open receivable has a due date earlier than the current date time. |
| Late Payment Surcharge Amount | Late payment surcharge amount a customer must potentially pay. For invoice currency, tfacr200.lapi. For transaction currency, tfacr200.lapa. Else, tfacr200.laph. |
| Late Payment Surcharge Date | tfacr200.lpdt |
| Line | tfacr200.line |
| Open Entry | If (tfacr200.balc] - tfacr200.bala > -0.00001) and (tfacr200.balc - tfacr200.bala < 0.00001) then 0. Else, 1. |
| Payments by Schedule | tfacr200.pysh |
| Payments by Schedule Filter | tfacr200.pysh |
| Payments by Schedule Sort | tfacr200.pysh |
| Problem | tfacr200.prob |
| Problem Date | tfacr200.prop |
| Problem Desc | tfacr002.desc |
| Problem Reference | tfacr200.pref |
| Problem Reference Desc | tfacr003.desc |
| Sales Type | tfacr200.styp |
| Second Discount Amount | Second discount amount for a customer. For invoice currency, tfacr200.di2i. For transaction currency, tfacr200.ld2a. Else, tfacr200.di2h. |
| Second Discount Date | tfacr200.did2 |
| Source Document | tfacr200.orno |
| Tax Code | tfacr200.cvat |
| Tax Code Desc | tcmcs037.dsca |
| Third Discount Amount | Third discount amount for a customer. For invoice currency, tfacr200.di3i. For transaction currency, tfacr200.ld3a. Else, tfacr200.di3h. |
| Third Discount Date | tfacr200.did3 |
| Transaction Category | tfgld011.catg |
| Transaction Category Filter | tfgld011.catg |
| Transaction Category Sort | tfgld011.catg |
| Transaction Type | tfacr200.ttyp |
| Transaction Type Desc | tfgld011.desc |
| Unknown | 0 |
| deleted | 1 if deleted in LN, else 0. |
| Customer Defined Fields | Standard list of fields. |