Transaction date filters
Data is extracted from Lawson System Foundation (LSF) into IRC using the Process Insight for Lawson and analyzed. Transaction date filters are used for scoping during extraction and analysis.
This table lists the objects, date fields for full extraction, date fields for Incremental extraction, and additional filters.
| Object name | Date field for full extraction | Date field for incremental extraction for Lawson 10.x | Additional filters |
|---|---|---|---|
| APDISTRIB | Join to APINVOICE For CREATE_DATE | APINVOICE. LAST-UPDT-DATE | NA |
| APINVOICE | CREATE_DATE | LAST-UPDT-DATE | NA |
| APPAYMENT | CHECK_DATE | LAST-UPDT-DATE | NA |
| GLCONTROL | POSTING_DATE | LAST-UPDT-DATE | NA |
| GLTRANS | POSTING_DATE | UPDATE_DATE | NA |
| ICRECEIPTS | RECEIVED_DATE | LAST_ACT_DATE | NA |
| ICTRANS | TRANS_DATE | UPDATE_DATE | NA |
| MAINVDTL | DISTRIB_DATE | UPDATE_DATE | NA |
| MMDIST | POSTED_DATE | LAST-UPDT-DATE | NA |
| POLINE | Join to PURCHORDER FOR PO_DATE | PURCHORDER .LAST-UPDT-DATE | NA |
| POLINESRC | Join to PURCHORDER FOR PO_DATE | PURCHORDER .LAST-UPDT-DATE | NA |
| PORECEIVE | REC_DATE | LAST-UPDT-DATE | NA |
| PORECLINE | REC_DATE | UPDATE_DATE | NA |
| PURCHORDER | PO_DATE | LAST-UPDT-DATE | NA |
| REQHEADER | CREATION_DATE | LAST-UPDT-DATE | NA |
| REQLINE | CREATION_DATE | LAST-UPDT-DATE | NA |
Note: For successful extraction of transaction objects, you must create
additional indexes on Lawson database on ERP versions 10.0 SP1, 10.0 SP2, 10.0
SP3, 10.0.4 SP4, 10.0 SP5, and 10.0 SP6.