Checks Data Flow

Workflow Steps

The process of sharing check data begins in IFS Land after a user enters check information and then integration with IFS BOLO follows these steps:

1. System Checks or Manual Checks - System Checks or Manual Checks - In IFS Land, checks are generated by the Check Printing Process as System Generated Payments or as Manual Payments.

2. Accounting Interface Process - In IFS Land, this process stages the checks in the outbound staging tables by the Accounting Period and Check type.

3. IFS Land Web Services - In IFS Land, this process stages the checks in the outbound staging tables by the Accounting Period and Check type.

4. Midcap API Web Services - In IFS BOLO, the web services transfer the data to be stored in the appropriate tables.

5. Voucher AP1301 - In IFS BOLO, the user can see the check data in the Vendor Invoice Data Entry Screen, AP1301.

6. Midcap API Web Services - In IFS BOLO, the web services send a message back to IFS Land about the status of the integration: if the transfer was successful or encountered errors.

7. Voucher AP 1301 - In IFS BOLO, the user can utilize the data for payment and invoicing.

Payment Attribute Mapping

IFS Land Screen \| Tab	IFS Land Field	BOLO Screen	IFS BOLO Field	Comments

IFS Land Screen \| Tab	IFS Land Field	BOLO Screen	IFS BOLO Field	Comments
Lease \| Payment	Payor Number	AP1301	Company	External ID for the interface
Accounting Interface	Acct Period	AP1301	Accounting Period	Last day of the accounting month
Lease \| Payment \| Payees	Payee Number	COM1201 AP1210	Vendor	External ID for the interface
Check Maintenance	Payment Document Key	SI_5063	Invoice	Lease payment type and Payment Doc Number generated in IFS BOLO
Accounting Interface	Update Date	AP1301	Invoice Date	Accounting process run date
Check Maintenance	Payment Doc Date	AP1301	Occurrence Date	Activity Date
Check Maintenance	Actual Payment Amount	AP1301	Amount	Voided check will have negative amount
Check Maintenance	Check Number	CNV.ID	N/A	Check number appended to IFS BOLO invoice number
Check Maintenance	Bank Account	AP1301	Bank Account	Default value from Company and InterOP system settings
Lease \| Payment \| Payees	ACH	AP1210	N/A	Payment method (check or ACH) defined by Vendor. Blank value on Vendor Setup defers to Check.
Lease \| Payment \| ONRR	ONRR	AP1210	N/A	Payment method (check or ACH) defined by Vendor. Utilize Special Handling Code of ONRR for Office of Natural Resource Revenue.
Check Printing \| Details	Check Type	AP1201	Separate Check	Check Type in IFS Land is set to N when integrated with a IFS Accounting system. Separate check field in IFS BOLO should be set to Yes when receiving payments from IFS Land.
Check Maintenance \| Process Details	Void Date	N/A	N/A	Applicable with a Voided Check. INT3502 report in IFS BOLO displays the IFS BOLO Check Number and IFS Land Check to be Voided.

TABLE 1. Payment attribute mapping between IFS BOLO and IFS Land.

Integration Status Message

The Check integration status message that IFS BOLO sends to IFS Land includes the following data:

DATA	COMMENTS

DATA	COMMENTS
Primary Key for the Check Header	IFS Land Table: PROCESS_REPORT_OUTPUT IFS Land Field: PROCESS_REPORT_OUT_KEY
The Source System	On IFS BOLO screen CNV.NAME, the Source System is identified as IFS Land
Integration Status Flag	IFS Land Table: V_PROC_MIDCAP_CHECK_HDR IFS Land Field: INTEG_FLAG N = Ready to be sent to accounting Y = Processed by Accounting E = Error F = Fatal Error
Integration Messaging	IFS Land Table: V_PROC_MIDCAP_CHECK_HDR IFS Land Field: INTEG_STATUS_MESG S = Successful transfer of data E = Errors found in transfer of data - Validation errors F = Fatal Error in transfer of data - Critical errors
Date data Transfer occurred	IFS Land Table: V_PROC_MIDCAP_CHECK_HDR IFS Land Field: INTEG_DATE

TABLE 2. Check integration status sent from IFS BOLO to IFS Land.

Payment Document Detail

Payment Document Attribute Mapping

IFS Land Screen \| Tab	IFS Land Field	IFS BOLO Screen	IFS BOLO Field	Comments

IFS Land Screen \| Tab	IFS Land Field	IFS BOLO Screen	IFS BOLO Field	Comments
Lease Payment	GL Account Code	INT1201	Account
Lease \| Payment	Next Due Date	AP1301	Invoice Due Date
Lease \| Payment	Payment Type	SI_5063	N/A	Lease Payment Type and Payment Doc Number generated in IFS BOLO
Lease \| Payment	Payment Amount	AP1301	Amount	Payment Amount is GROSS or NET of withholding
File Definition	File Key	AP1302	Cost Center	Lease Id (LD1220.INT)
Lease \| Payment	Accounting Code	AP1302 CBD1210	Project AFE ID	IFS Land System Generated Checks
Check Maintenance	AFE ID	AP1302 CBD1210	Project AFE ID	IFS Land Manual Checks
Lease Header Lease \| Payment Lease \| Documents Lease \| Tract \| Legals Check Maintenance Check Maintenance Lease \| Payment Lease \| Payment Lease \| Payment	Lessor Net Amt Book / Page / Reception Number Tract Number/Legal Descriptions Start Payment Date End Payment Date Frequency Code Payment Description Check Remarks	AP1301	Remarks	Lease Header, Lease and Check Maintenance information from IFS Land is concatenated and integrated as IFS BOLO Voucher Remittance Annotation

TABLE 3. Payment Document attribute mapping between IFS BOLO and IFS Land.

Withholding Document Detail

Withholding Document Attribute Mapping

IFS Land Screen \| Tab	IFS Land Field	IFS BOLO Screen	IFS BOLO Field	Comments

IFS Land Screen \| Tab	IFS Land Field	IFS BOLO Screen	IFS BOLO Field	Comments
Code and Rules \| Payment Type Codes	GL Account Number	AP1301	Accounting	GL Account Number for Withholding associated to Payment Type in IFS Land
Lease \| Payment	Next Due Date	AP1301	Invoice Due Date
Check Maintenance	1099 Withhold Amount	AP2345	Amount	Withholding Amount displayed on report generated through AP2345 in IFS BOLO
File Definition	File Key
Lease Header Lease \| Payment Lease \| Documents Lease \| Tract \| Legals Check Maintenance Check Maintenance Lease \| Payment Lease \| Payment Lease \| Payment	Lessor Net Amt Book / Page / Reception Number Tract Number / Legal Descriptions Start Payment Date End Payment Date Frequency Code Payment Description Check Remarks	AP1301	Remarks	Summary of Parent Leases referenced to create with Withholding Voucher

TABLE 4. Withholding Document attribute mapping between IFS BOLO and IFS Land.

IFS Energy & Resources Connect

IFS BOLO and IFS Land Checks Workflow