iPaaS.com transactions can be sent to Orderful as EDI 810 invoices, including their line items and addresses (remit-to, ship-from, and bill-to) and terms of sale. The integration builds the invoice header plus its children so a complete invoice is created in Orderful.
ID Format
Manual Sync ID Format
On the iPaaS.com Manual Sync page, enter the iPaaS.com transaction ID.
External ID Format
After the invoice is created, iPaaS.com saves the Orderful transaction identifier as the external ID on a dedicated external-ID record, which is the primary match for later updates.
Deleted Record Support
Outbound delete is not supported. Deletions are not propagated to Orderful, and delete mappings are not included in the default templates.
Custom Field Support
Several Orderful EDI header values are sourced from iPaaS.com custom fields populated by the inbound flow (terms of sale, reference identifiers, and sender/receiver identifiers). No additional custom-field configuration is required.
Mapping Collection Status
Status: Enabled (filtered to invoice transactions)
Trigger Events: Enabled under the subscription's Outbound Data Flows by subscribing to the iPaaS.com transaction created and updated triggers. No invoices are sent automatically until those triggers are enabled.
Duplicate or Conflicting Mappings
Add Orderful Invoice TO iPaaS.com transfers invoices in the opposite direction.
Review filters and Add/Update settings before enabling these together, and decide which system is the source of truth.
Supported Child Collections
Add Orderful Invoice Remit-To Address FROM iPaaS.com — the remit-to address (entity identifier code RI).
Add Orderful Invoice Address FROM iPaaS.com — the bill-to/ship-to addresses carried on the transaction.
Add Orderful Invoice Ship-From Address FROM iPaaS.com — the ship-from address (entity identifier code SF).
Add Orderful Invoice Line FROM iPaaS.com — the line items sent on the invoice.
System Caveats
iPaaS.com Caveats
The invoice filter limits this collection to transactions of type Invoice. The currency defaults to USD and should be changed if you invoice in another currency.
Orderful Caveats
The Orderful stream (TEST or LIVE) must match your target environment; sending to the wrong stream routes the invoice to the wrong Orderful environment.
Setup Requirements
Enable this transfer under the subscription's Outbound Data Flows by subscribing to the iPaaS.com transaction created and updated triggers. Until those are enabled, no invoices are sent to Orderful.
Integration Flow
A transaction of type Invoice is dispatched from iPaaS.com (by an enabled outbound trigger or Manual Sync).
The integration builds the 810 invoice header with its addresses and line items and creates it in Orderful.
Orderful returns its transaction identifier, which iPaaS.com saves as the external ID.
Mappings
Add Orderful Invoice FROM iPaaS.com
Mapping Filter: Type == "Invoice" — only transactions whose type is Invoice are processed; transactions of any other type are skipped.
The 810 invoice header.
Mapping Type | Source Field (iPaaS.com) | Destination Field (Orderful) | Description |
Field | Orderful Invoice Administrative Communications Contact Function Code | AdministrativeCommunicationsContact_ContactFunctionCode | The role of the administrative communications contact; for example AP (Accounts Payable). |
Field | Orderful Invoice Administrative Communications Contact Name | AdministrativeCommunicationsContact_Name | The name of the administrative communications contact. |
Field | Orderful Date | BeginningSegmentForInvoice_Date | The invoice date, in CCYYMMDD format. |
Field | Orderful Date | BeginningSegmentForInvoice_Date1 | A date expressed as CCYYMMDD. |
Field | TransactionNumber | BeginningSegmentForInvoice_InvoiceNumber | The invoice number, taken from the transaction number. |
Field | Orderful Purchase Order Number | BeginningSegmentForInvoice_PurchaseOrderNumber | The purchase order number related to this invoice. |
Field | Orderful Transaction Set Purpose Code | BeginningSegmentForInvoice_TransactionSetPurposeCode | Purpose of the transaction; 00 means Original. |
Static | "USD" | Currency_CurrencyCode | Placeholder — set to USD; replace if your invoices use a different currency. |
Static | "BT" | Currency_EntityIdentifierCode | The currency segment entity; BT means Bill-to-Party. |
Field | Orderful Delivered DateTimeReference Date | Delivered_DateTimeReference_Date | The delivered date corresponding to the delivered qualifier. |
Static | "002" | Delivered_DateTimeReference_DateTimeQualifier | Type of date given (DTM02); 002 means Delivery Requested. |
Dynamic Formula | Line item count | NumberOfLineItems | The count of line items on the invoice. |
Field | Orderful Receiver isaID | Receiver_IsaId | The receiver's ISA interchange ID. |
Field | Orderful Invoice Reference Identification | ReferenceIdentification | The reference identification value. |
Field | Orderful Invoice Reference Identification Qualifier | ReferenceIdentificationQualifier | Type of reference; for example IK (Invoice Number) or PO (Purchase Order Number). |
Field | Orderful Sender isaID | Sender_IsaId | The sender's ISA interchange ID. |
Field | Orderful Shipped DateTimeReference Date | Shipped_DateTimeReference_Date | The shipped date corresponding to the shipped qualifier. |
Static | "010" | Shipped_DateTimeReference_DateTimeQualifier | Type of date given (DTM02); 010 means Requested Ship Date. |
Field | Orderful Terms Description | TermsOfSale_Description | A description of the payment terms. |
Field | Orderful Terms Basis Date Code | TermsOfSale_TermsBasisDateCode | The date the payment terms start from; 3 means Invoice date. |
Field | Orderful Terms Net Days | TermsOfSale_TermsNetDays | The net number of days for the payment terms. |
Field | Orderful Terms Net Due Date | TermsOfSale_TermsNetDueDate | The date the total invoice amount is due, in CCYYMMDD format. |
Field | Orderful Terms Type Code | TermsOfSale_TermsTypeCode | The type of payment terms; 01 means Basic. |
Dynamic Formula | Sum of invoice lines | TotalMonetaryValueSummary_Amount | The total amount of all invoice lines added together. |
Field | Orderful Transaction Set Control Number | TransactionSetHeader_TransactionSetControlNumber | A control number unique within the transaction set (length 4 to 9). |
Static | "810" | TransactionSetHeader_TransactionSetIdentifierCode | 810 is the X12 code for an invoice. |
Field | Orderful Transaction Set Control Number | TransactionSetTrailer_TransactionSetControlNumber | The trailer control number, matching the header control number. |
Static | "810_INVOICE" | Type_Name | Required to create the invoice in Orderful. |
Field | Orderful Stream | Stream | Placeholder — set to match your environment (TEST or LIVE) before go-live. |
Add Orderful Invoice Remit-To Address FROM iPaaS.com
The remit-to address. Parent-driven; derived from the parent invoice. Links to the parent invoice by a composite external ID made of the entity identifier code and the parent transaction ID (for example, RI then 4).
Mapping Type | Source Field (iPaaS.com) | Destination Field (Orderful) | Description |
Dynamic Formula | Remit-to address line | AddressInformation | The first line of the remit-to address. |
Dynamic Formula | Remit-to city | CityName | The city of the remit-to address. |
Dynamic Formula | Remit-to country | CountryCode | The country code. Maximum length 3. |
Static | "RI" | EntityIdentifierCode | The address role, set to RI (Remit To). |
Dynamic Formula | Remit-to name | Name | The party name on the remit-to address. |
Dynamic Formula | Remit-to postal code | PostalCode | The postal code of the remit-to address. |
Dynamic Formula | Remit-to state/province | StateOrProvinceCode | The two-character state or province code. |
Add Orderful Invoice Address FROM iPaaS.com
The bill-to/ship-to addresses carried on the transaction. Links to the parent invoice by a composite external ID made of the entity identifier code and the parent transaction ID (for example, ST then 4).
Mapping Type | Source Field (iPaaS.com) | Destination Field (Orderful) | Description |
Field | Address1 | AddressInformation | The first line of the address. |
Field | City | CityName | The city of the address. |
Dynamic Formula | Country | CountryCode | The country code. Maximum length 3. |
Dynamic Formula | Address role | EntityIdentifierCode | The EDI entity identifier code; BT means Bill To, ST means Ship To. |
Field | FirstName | Name | The party name on the address. |
Field | PostalCode | PostalCode | The postal code of the address. |
Field | Region | StateOrProvinceCode | The two-character state or province code. |
Add Orderful Invoice Ship-From Address FROM iPaaS.com
The ship-from address. Parent-driven; derived from the parent invoice. Links to the parent invoice by a composite external ID made of the entity identifier code and the parent transaction ID (for example, SF then 4).
Mapping Type | Source Field (iPaaS.com) | Destination Field (Orderful) | Description |
Dynamic Formula | Ship-from address line | AddressInformation | The first line of the ship-from address. |
Dynamic Formula | Ship-from city | CityName | The city of the ship-from address. |
Dynamic Formula | Ship-from country | CountryCode | The country code. Maximum length 3. |
Static | "SF" | EntityIdentifierCode | The address role, set to SF (Ship From). |
Dynamic Formula | Ship-from name | Name | The party name on the ship-from address. |
Dynamic Formula | Ship-from postal code | PostalCode | The postal code of the ship-from address. |
Dynamic Formula | Ship-from state/province | StateOrProvinceCode | The two-character state or province code. |
Add Orderful Invoice Line FROM iPaaS.com
The line items sent on the invoice. Each line links to the parent invoice by a composite external ID made of the line number and the parent transaction ID (for example, 1 then 4).
Mapping Type | Source Field (iPaaS.com) | Destination Field (Orderful) | Description |
Field | Qty | AdditionalItemData_NumberOfUnitsShipped | The number of units shipped for the line. |
Dynamic Formula | Unit of measure | AdditionalItemData_UnitOrBasisForMeasurementCode | The unit of measure for the units shipped; CA means Case. |
Field | SequenceNumber | AssignedIdentification | The line number of the item. |
Field | Description | Description | A free-form product description. |
Field | Orderful Item Description Code Type | ItemDescriptionTypeCode | Type of item description (PID05); F means Free-Form. |
Dynamic Formula | Product/service identifier | ProductServiceID | The product/service identifier per the qualifier (PO105). |
Field | Orderful Product Service ID 1 | ProductServiceID1 | The second product/service identifier value (PO107). |
Field | Orderful Product Service ID Qualifier | ProductServiceIDQualifier | Type of item reference (PO106); UP means Universal Product Code. |
Field | Orderful Product Service ID Qualifier 1 | ProductServiceIDQualifier1 | The second item reference qualifier (PO108); VN means Vendor's Item Number. |
Field | Qty | Quantity | The quantity invoiced. |
Dynamic Formula | Unit of measure | UnitOrBasisForMeasurementCode | The unit of measure for the quantity (PO102); CA means Case. |
Field | UnitPrice | UnitPrice | The price of the item for the unit of measure. |
Error Handling
See the Orderful Error Messages article for the full catalog. This outbound flow surfaces "Transaction could not be created because the Address information is missing." and "Transaction creation failed. No line items were provided." — resolution: ensure the invoice has at least one address and at least one line item before transferring.
Testing & Validation
Test Scenarios
Create an Invoice transaction in iPaaS.com with addresses and line items, transfer it, and verify the 810 is created in Orderful with remit-to and ship-from addresses.
Attempt a transfer with no line items and confirm the expected error.
Re-transfer an updated invoice and verify it updates the existing Orderful invoice rather than creating a duplicate.
Validation Checklist
The 810 is created in Orderful with header, addresses, line items, and terms of sale.
The Orderful transaction ID is saved as the external ID.
The currency and stream values match the intended configuration and environment.
Related Documents