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
Accounts Receivable Document Transaction Type + Document + Line

tfacr200.ttyp + tfacr200.ninv + tfacr200.line

Advance or Unallocated Receipt If ACR Document Type = Advance Receipt or Unallocated Receipt, then Amount. Else, 0.
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
Credit Collection

1 if Late, or Reminded, or Disputed, or Written Off, or Advance, or Unallocated Receipt. Else 0.

These documents are important for a credit collector, as used in the Collections by Invoice-to Business Partner (tfacr3607m000) session.

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 0, if the due date is empty.

Number of days after the due date for an Open Entry.

If no Open Entry is applicable, the number of days between the clearing date and the due date.

Days Overdue Aging 99999, if the due date is empty.

Number of days after the due date for an Open Entry.

If no Open Entry is applicable, the number of days between the clearing date and the due date.

Disputed 1 if tfacr200.prob is filled, 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 days Overdue > 0. Else, 0.
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 0 if Balance is 0. Else, 1.

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
Reminded 1 if tfacr200.lett > 0. Else, 0.
Reminder Letter tfacr200.lett
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
Total Open Entry 0 if Balance Total Open Entry is 0. Else, 1.
Transaction Category tfgld011.catg
Transaction Category Filter tfgld011.catg
Transaction Category Sort tfgld011.catg
Transaction Type tfacr200.ttyp
Transaction Type Desc tfgld011.desc
Unassigned 1 if ACR Document Type is Sales Invoice, or Credit Note, or Advance Receipt, or Unallocated Receipt. Else, 0.
Unknown 0
Written Off 1 if Write-Off Status (tfacr200.wros) is Written Off. Else, 0.
deleted 1 if deleted in LN, else 0.
Customer Defined Fields Standard list of fields.