Receipt or Settlement
This table shows the table from which fields are retrieved for the dimension:
Table | Description |
---|---|
tfacr200 | Open Items (Sales Invoices & Receipts) |
tfgld011 | Transaction Types |
This table shows the attribute mapping for the dimension:
Attribute | Mapping |
---|---|
Accounts Receivable Receipt Document | Transaction Type + Document Number + Line tfacr200.tdoc + tfacr200.docn + tfacr200.lino |
Company | tfacr200_compnr |
Document Date | tfacr200.docd |
Document Number | tfacr200.docn |
Line | tfacr200.lino |
Original Schedule Number | tfacr200.osch |
Transaction Category | tfgld011.catg |
Transaction Category Filter | tfgld011.catg |
Transaction Category Sort | tfgld011.catg |
Transaction Type | tfacr200.tdoc |
Transaction Type Desc | tfgld011.desc |
Unknown | 1 for null records, else 0 |
deleted | 1 if deleted in LN, else 0 |
Customer Defined Fields | Standard list of fields |