| PaymentWorks Field | Oracle Fusion Object / Field | Status | Notes |
|---|
| Vendor ID | Supplier → Supplier Number | ✓ Out-of-box | External supplier identifier; maps to Party Number |
| Company Name | Supplier → Supplier Name | ✓ Out-of-box | Required; matched against existing party records |
| Tax ID / TIN | Supplier → Tax Registration Number | ✓ Out-of-box | EIN / TIN validated; format enforced per country |
| Address | Supplier Site → Address (HZ_LOCATIONS) | ✓ Out-of-box | Full address object; country code ISO 3166 validated |
| Contact Name / Email | Supplier Contact → Contact Point | ◎ Optional | Maps to Party Contact; not required |
| Vendor Status | Supplier → Supplier Status | ✓ Out-of-box | Active / Inactive — only approved vendors synced |
| Business Unit | Supplier Site → Business Unit Assignment | ⚙ AI-Mappable | Maps to BU via AI; configurable per tenant structure |
Module: Oracle Procurement Cloud
Object: Supplier (AP_SUPPLIERS)
API: Suppliers REST v1 · FBDI for bulk
Trigger: Event-driven (on approval)
| PaymentWorks Field | Oracle Fusion Object / Field | Status | Notes |
|---|
| Bank Name | External Bank Account → Bank Name | ✓ Out-of-box | Matched against CE_BANKS_V |
| Account Number | External Bank Account → Account Number | ✓ Out-of-box | AES-256 encrypted in transit and at rest |
| Routing / SWIFT / IBAN | External Bank Account → Bank Branch | ✓ Out-of-box | ABA routing, SWIFT BIC, or IBAN; format-validated |
| Account Type | External Bank Account → Account Type | ✓ Out-of-box | Checking / Savings enum |
| Currency | External Bank Account → Currency Code | ✓ Out-of-box | ISO 4217; must match Fusion-enabled currencies |
| Payment Method | Payment Method → IBY_PAYMENT_METHODS | ✓ Out-of-box | EFT / Wire / Check — maps to IBY payment methods |
| Bank Status | External Bank Account → Active Flag | ✓ Out-of-box | Only active accounts synced |
Module: Oracle Cash Management / Payments
Object: External Bank Accounts (IBY_EXT_BANK_ACCOUNTS)
API: External Bank Accounts REST · SOAP
Security: OAuth2 · TLS 1.3 · Field-level encryption
| PaymentWorks Field | Oracle Fusion Object / Field | Status | Notes |
|---|
| Invoice ID | AP Invoice → Invoice Number | ✓ Out-of-box | Unique per supplier; deduplicated on insert |
| Vendor ID | AP Invoice → Supplier Reference | ✓ Out-of-box | Links to AP_SUPPLIERS via Supplier Number |
| Invoice Date | AP Invoice → Invoice Date | ✓ Out-of-box | Required; ISO 8601 format |
| Invoice Amount | AP Invoice → Invoice Amount | ✓ Out-of-box | Validated against currency precision rules |
| Currency | AP Invoice → Invoice Currency Code | ✓ Out-of-box | ISO 4217; must match enabled ledger currencies |
| Payment Terms | AP Invoice → Payment Terms (AP_TERMS) | ◎ Optional | Defaults to supplier site terms if not passed |
| Invoice Line Items | AP Invoice Lines → AP_INVOICE_LINES_ALL | ⚙ AI-Mappable | Description, qty, unit price, account coding — via Mapping Designer |
| Tax Amount | AP Invoice → Tax Lines (ZX_LINES) | ◎ Optional | Maps to E-Business Tax module when configured |
Module: Oracle Payables Cloud
Object: Invoices (AP_INVOICES_ALL)
API: Invoices REST v1 · FBDI bulk load · SOAP
Trigger: Batch (daily / per AP cycle)
| PaymentWorks Field | Oracle Fusion Object / Field | Status | Notes |
|---|
| Payment ID | Payment → Payment Reference Number | ✓ Out-of-box | Unique identifier per payment |
| Vendor ID | Payment → Supplier Reference | ✓ Out-of-box | Links to AP_SUPPLIERS |
| Invoice ID | Payment → Invoice Reference | ✓ Out-of-box | Invoice must exist; AP_INVOICES_ALL reference |
| Payment Amount | Payment → Payment Amount | ✓ Out-of-box | Validated against invoice amount |
| Payment Date | Payment → Payment Date | ✓ Out-of-box | Required; validated against AP period |
| Payment Method | Payment → Payment Method (IBY) | ✓ Out-of-box | EFT / Wire / Check via IBY_PAYMENT_METHODS |
| Currency | Payment → Payment Currency Code | ✓ Out-of-box | ISO 4217 matching invoice currency |
| Bank Account Used | Payment → External Bank Account Ref | ✓ Out-of-box | References IBY_EXT_BANK_ACCOUNTS |
Module: Oracle Payments Cloud (IBY)
Object: Payment Requests (IBY_PAYMENTS_ALL)
API: Payments REST v1 · SOAP · Payment Process Request
Trigger: Batch (per payment run)
