You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Virtual Card Reconciliation

in Payables, Payments & Cash Management

We use a virtual card through Paymode-X and they have a reconciliation file they can provide. It has the below specifications. Has anyone integrated similar type v-card files into Oracle to reconcile?

File Data:
• Field 1 – Payment Type
• Field 2 – Routing Number
• Field 3 – Bank Account Number
• Field 4 – Payment Number
• Field 5 – Payment Amount
• Field 6 – Payment Settlement Date
• Field 7 – TRX Code (Payment status)
• Field 8 – Collecting Paymode-X ID
• Field 9 – Disbursing Paymode-X ID
• Field 10 – Vendor Number
Configurable Options:
• Delimiter (Default: Pipe)
• Date Format (Default: MMDDYYYY)
• Payment Type indicators (Defaults: ACH, CARD, UNKNOWN*)
• Optional NO DATA file.
o NO DATA file text (Default: NO DATA for + MMDDYYYY)

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!