Transaction date filters
Data is extracted from the Base Data Store into IRC using the Process Insight for Infor and analyzed. Transaction date filters are used for scoping during extraction and analysis.
The following 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 |
|---|---|---|
| Supplier Invoice Header | SUPPLIER_INVOICE.SIH_DCMNT_DATE | SUPPLIER_INVOICE.SIH_LAST_MODIFICATION_DATE OR SUPPLIER_INVOICE.SIH_INSRT_UPDT_DATE |
| Supplier Invoice Line | SUPPLIER_INVOICE.SIH_DCMNT_DATE | SUPPLIER_INVOICE.SIH_LAST_MODIFICATION_DATE OR SUPPLIER_INVOICE.SIH_INSRT_UPDT_DATE |
| Receive Delivery Header | RECEIVE_DLVRY.RDH_DCMNT_DATE | NA |
| Receive Delivery Item | RECEIVE_DLVRY.RDH_DCMNT_DATE | NA |
| Purchase Order Header | PUR_ORDER.POH_DCMNT_DATE | PUR_ORDER.POH_LAST_MODIFICATION_DATE OR PUR_ORDER.POH_INSRT_UPDT_DATE |
| Purchase Order Line | PUR_ORDER.POH_DCMNT_DATE | PUR_ORDER.POH_LAST_MODIFICATION_DATE OR PUR_ORDER.POH_INSRT_UPDT_DATE |
| Purchase Order Schedule | PUR_ORDER.POH_DCMNT_DATE | PUR_ORDER.POH_LAST_MODIFICATION_DATE OR PUR_ORDER.POH_INSRT_UPDT_DATE |
| Requisition Header | REQUISITION.RH_DCMNT_DATE | REQUISITION.RH_LAST_MODIFICATION_DATE OR REQUISITION.RH_INSRT_UPDT_DATE |
| Requisition Line | REQUISITION.RH_DCMNT_DATE | REQUISITION.RH_LAST_MODIFICATION_DATE OR REQUISITION.RH_INSRT_UPDT_DATE |
| Payable Transaction Header | PYBL_TXN.PTH_DCMNT_DATE | PYBL_TXN.PTH_LAST_MODIFICATION_DATE OR PYBL_TXN.PTH_INSRT_UPDT_DATE |
| Payable Transaction Line | PYBL_TXN.PTH_DCMNT_DATE | PYBL_TXN.PTH_LAST_MODIFICATION_DATE OR PYBL_TXN.PTH_INSRT_UPDT_DATE |
| Item Master Header | NA | NA |
| Supplier Party Master | NA | NA |
| Sales Order Header | SALES_ORDER.SOH_DCMNT_DATE | SALES_ORDER.SOH_LAST_MODIFICATION_DATE OR SALES_ORDER.SOH_INSRT_UPDT_DATE |
| Sales Order Line | SALES_ORDER.SOH_DCMNT_DATE | SALES_ORDER.SOH_LAST_MODIFICATION_DATE OR SALES_ORDER.SOH_INSRT_UPDT_DATE |
| Shipment Header | SHIPMENT.SH_DCMNT_DATE | NA |
| Shipment Item | SHIPMENT.SH_DCMNT_DATE | NA |
| Invoice Header | INVOICE.IH_DCMNT_DATE | INVOICE.IH_LAST_MODIFICATION_DATE OR INVOICE.IH_INSRT_UPDT_DATE |
| Invoice Line | INVOICE.IH_DCMNT_DATE | INVOICE.IH_LAST_MODIFICATION_DATE OR INVOICE.IH_INSRT_UPDT_DATE |
| Customer Party Master | NA | NA |
| Receivable Transaction Header | RVBL_TXN.RTH_DCMNT_DATE | RVBL_TXN.RTH_LAST_MODIFICATION_DATE OR RVBL_TXN.RTH_INSRT_UPDT_DATE |
| Journal Entry Header | GL_JOURNAL.SSJEH_BJEH_EA_DATE | NA |
| Journal Entry Line | GL_JOURNAL.SSJEH_BJEH_EA_DATE | NA |
| GL Account Master | NA | NA |
| Customer Return Header | CUSTOMER_RETURN.CRH_DCMNT_DATE | CUSTOMER_RETURN.CRH_LAST_MODIFICATION_DATE OR CUSTOMER_RETURN.CRH_INSRT_UPDT_DATE |
| Customer Return Line | CUSTOMER_RETURN.CRH_DCMNT_DATE | CUSTOMER_RETURN.CRH_LAST_MODIFICATION_DATE OR CUSTOMER_RETURN.CRH_INSRT_UPDT_DATE |
| Quote Header | QUOTE.QH_DCMNT_DATE | NA |
| Quote Line | QUOTE.QH_DCMNT_DATE | NA |
| Purchasing Contract header | PUR_CNTRCT.CH_DCMNT_DATE | PUR_CNTRCT.CH_LAST_MODIFICATION_DATE OR PUR_CNTRCT.CH_INSRT_UPDT_DATE |
| Purchasing Contract Schedule | PUR_CNTRCT.CH_DCMNT_DATE | PUR_CNTRCT.CH_LAST_MODIFICATION_DATE OR PUR_CNTRCT.CH_INSRT_UPDT_DATE |
| Sales Contract header | SALES_CNTRCT.CH_DCMNT_DATE | SALES_CNTRCT.CH_LAST_MODIFICATION_DATE OR SALES_CNTRCT.CH_INSRT_UPDT_DATE |
| Sales Contract Schedule | SALES_CNTRCT.CH_DCMNT_DATE | SALES_CNTRCT.CH_LAST_MODIFICATION_DATE OR SALES_CNTRCT.CH_INSRT_UPDT_DATE |
| RFQ Header | RFQ.RFQH_DCMNT_DATE | RFQ.RFQH_LAST_MODIFICATION_DATE OR RFQ.RFQH_INSRT_UPDT_DATE |
| RFQ Line | RFQ.RFQH_DCMNT_DATE | RFQ.RFQH_LAST_MODIFICATION_DATE OR RFQ.RFQH_INSRT_UPDT_DATE |