Skip Headers

Oracle Receivables Reference Guide
Release 12.1
Part Number E13512-04
Go to Table of Contents
Contents
Go to previous page
Previous
Go to next page
Next

XML Transactions

XML Receivables Documents Mapping

This appendix provides the mapping for the XML messages used in the XML Invoices process.

For more information about sending XML messages, that contain Receivables documents, to customers, see: XML Receivables Documents, Oracle Receivables User Guide.

Related Topics

Process Invoice XML Message Map

Confirm BOD Message Map

Transaction Limitations

Process Invoice XML Message Map

The XML invoices process uses the Open Applications Group Process Invoice DTD called 171_process_invoice_002.dtd (version 7.2.1).

The following table shows you the mapping between Receivables database columns and the elements of the Process Invoice XML message for the invoice header.

INVHEADER Target (XML) Source
  AMOUNT.DOCUMENT.T.VALUE AR_XML_INVOICE_V.amount
  AMOUNT.DOCUMENT.T.CURRENCY AR_XML_INVOICE_V.currency_code
  DATETIME.DOCUMENT AR_XML_INVOICE_V.trx_date
  DOCUMENTID AR_XML_INVOICE_V.trx_number
  PAYMETHOD AR_XML_INVOICE_V.payment_method
  PARTNER.NAME AR_XML_INVOICE_V.supplier_name
  PARTNER.PARTNERID AR_XML_INVOICE_V.supplier_code
  PARTNER.PARTNRTYPE Supplier
  PARTNER.PARTNERIDX AR_XML_INVOICE_V.supplier_code
  PARTNER.CONTACT.NAME AR_XML_INVOICE_V.salesrep
  PARTNER.CONTACT.EMAIL AR_XML_INVOICE_V.salesrep_email
  DOCUMNTREF.DOCTYPE AR_XML_INVOICE_V.document_type
  DOCUMNTREF.DOCMENTID AR_XML_INVOICE_V.reference_number
  DOCUMNTREF.PARTNRID AR_XML_INVOICE_V.supplier_code
  DOCUMNTREF.PARTNRTYPE Supplier
one or more PYMTTERM.AMOUNT.DISCNT.T AR_XML_PAYMENT_TERMS_V.discount_amount
one or more PYMTTERM.DATETIME.DISCNT AR_XML_PAYMENT_TERM_V.discount_date
one or more PYMTTERM.DATETIME.DUE AR_XML_PAYMENT_TERMS_V.due_date
one or more PYMTTERM.DATETIME.PYMTTERM AR_XML_PAYMENT_TERMS_V.term_start_date_effective
one or more PYMTTERM.DESCRIPTN AR_XML_PAYMENT_TERMS_V.term_decscription
one or more PYMTERRM.TERMID AR_XML_PAYMENT_TERMS_V.term_name
one or more PYMTERRM.USERAREA.AMOUNT AR_XML_PAYMENT_TERMS_V.due_amount

The following table shows you the mapping between Receivables database columns and the elements of the Process Invoice XML message for the invoice charges.

INVCHARGE Target (XML) Source
zero or more AMOUNT.EXTENDED.T AR_XML_INVOICE_CHARGE_V.charge_amount
zero or more CHARGETYPE AR_XML_INVOICE_CHARGE_V.line_type
zero or more DESCRIPTION AR_XML_INVOICE_CHARGE_V.description
zero or more LINENUM AR_XML_INVOICE_CHARGE_V.line_number

The following table shows you the mapping between Receivables database columns and the elements of the Process Invoice XML message for the invoice lines.

INVLINE Target (XML) Source
  AMOUNT.EXTENDED.T AR_XML_INVOICE_LINE_V.line_amount
  OPERAMT.UNIT.T AR_XML_INVOICE_LINE_V.unit_selling_price
  QUANTITY.ITEM AR_XML_INVOICE_LINE_V.quantity
  LINENUM AR_XML_INVOICE_LINE_V.line_number
  DESCRIPTN AR_XML_INVOICE_LINE_V.description
  ITEM AR_XML_INVOICE_LINE_V.item.description
  ITEMX AR_XML_INVOICE_LINE_V.item
  UNIT AR_XML_INVOICE_LINE_V.uom
  DOCUMNTREF.DOCTYPE AR_XML_INVOICE_LINE_V.line_type
  DOCUMNTREF.DOCUMENTID AR_XML_INVOICE_LINE_V.reference_number
  DOCUMNTREF.PARTNRID AR_XML_INVOICE_LINE_V.supplier_code
  DOCUMNTREF.PARTNRTYPE Supplier
  DOCUMNTREF.DOCTYPE PurchaseOrder
  DOCUMNTREF.DOCUMENTID AR_XML_INVOICE_LINE_V.po_number
zero or more INVCHARGE.AMOUNT.EXTENDED.T AR_XML_INVOICE_CHARGE_V.charge_amount
zero or more INVCHARGE.CHARGETYPE AR_XML_INVOICE_CHARGE_V.line_type
zero or more INVCHARGE.DESCRIPTION AR_XML_INVOICE_CHARGE_V.description
zero or more INVCHARGE.LINENUM AR_XML_INVOICE_CHARGE_V.line_number
zero or more INVTAX.AMOUNT.TAX.T AR_XML_INVOICE_TAX_V.tax_amount
zero or more INVTAX.AMOUNT.TAXBASE.T AR_XML_INVOICE_TAX_V.taxable_amount
zero or more INVTAX.QUANTITY.PERCENT AR_XML_INVOICE_TAX_V.tax_rate
zero or more INVTAX.DESCRIPTN AR_XML_INVOICE_TAX_V.description
zero or more INVTAX.LINENUM AR_XML_INVOICE_TAX_V.line_number
zero or more INVTAX.TAXCODE AR_XML_INVOICE_TAX_V.tax_code

Confirm BOD Message Map

The message map for the Confirm_BOD XML message used by the XML Receivables Documents feature is Confirm_BOD (XML - XML, Inbound) and the DTD is 002_confirm_bod_004.dtd.

The Confirm BOD has two control areas. One has the information for the Confirm BOD. The second is an exact copy of the control area from the Process Payment XML message. The second control area provides the context of the Confirm BOD.

The following table shows the mapping of the Confirm BOD XML message.

CONFIRM Source (XML) Value Target (PLSQL)
  STATUSLVL 00: Success
10: AR Invoice Failure
AR_CONFIRMATION.initiate_confirmation_process.P_STATUS
  DESCRIPTIN    
  ORIGREF   AR_CONFIRMATION.initiate_confirmation_process.P_ID.
ar_document_transfers.document_transfer_id:ra_customer_trx.customer_trx_id:ra_customer_trx_lines.customer_trx_line_id
Passed from Receivables to your customer's payables system.
zero or more CONFIRMMSG.REASONCODE   AR_CONFIRMATION.initiate_confirmation_process.P_REASON_CODE
zero or more CONFIRMMSG.DESCRIPTN Invoice
InvoiceLine
CreditMemo
CreditMemo Line
DebitMemo
DebitMemo Line
AR_CONFIRMATION.initiate_confirmation_process.P_DESCRIPTION

Transaction Limitations

This feature has certain limitations. They include the following: