Accounts Receivable Detail
This table shows the table from which fields are retrieved for the dimension:
| Table | Description |
|---|---|
| tfacr200 | Open Items (Sales Invoices & Receipts) |
This table shows the attribute mapping for the dimension:
| Attribute | Mapping |
|---|---|
| Advance Invoice or Payment Request | tfacr200.arrq |
| Advance Invoice or Payment Request Filter | tfacr200.arrq |
| Advance Invoice or Payment Request Sort | tfacr200.arrq |
| Debit Note | tfacr200.dbnt |
| Debit Note Filter | tfacr200.dbnt |
| Debit Note Sort | tfacr200.dbnt |
| Doubtful | tfacr200.doub |
| Doubtful Filter | tfacr200.doub |
| Doubtful Sort | tfacr200.doub |
| Finalized | If tcr200.post = 0 then no, else yes |
| Finalized Filter | If tcr200.post = 0 then no, else yes |
| Finalized Sort | If tcr200.post = 0 then no, else yes |
| Receipt Procedure Step | tfacr200.step |
| Receipt Procedure Step Filter | tfacr200.step |
| Receipt Procedure Step Sort | tfacr200.step |
| Status for Linking Unallocated Payment | tfacr200.rcpt |
| Status for Linking Unallocated Payment Filter | tfacr200.rcpt |
| Status for Linking Unallocated Payment Sort | tfacr200.rcpt |
| Write Off Status | tfacr200.wros |
| Write-Off Status Filter | tfacr200.wros |
| Write-Off Status Sort | tfacr200.wros |