C1-UBLINVOICEEXTRACT Extract Template
The C1-UBLINVOICEEXTRACT extract template is used to extract invoice details in the Universal Business Language (UBL) 2.1 XML format. It uses the C1-InvoiceChargeExtract business service to fetch the person details, bill segments, adjustments, and tax details with respect to the bills attached to the respective bill route types associated with the C1-UBLBILEX algorithm.
The C1-UBLINVOICEEXTRACT extract template
has the following three types of field mappings:
-
Fields Starting with IN - Indicates the initial fields which are used as an input to fetch details corresponding to the C1-InvoiceChargeExtract business service.
-
Fields Starting with OUT_INV - Indicates the extracted fields which contains the invoice information.
-
Fields Starting with OUT_INV_LIN - Indicates the extracted fields which contains the invoice line information.
The C1-UBLINVOICEEXTRACT extract template is mapped in the system as shown in the below table:
| Extract Template Field Name | Source Xpath | Target Xpath | Parameters/Default Values |
|---|---|---|---|
| IN_ACCOUNT_ID | - | ubl:Invoice/accountId | PARAM(accountId) |
| IN_ACCT_NBR | - | ubl:Invoice/acctNbr | PARAM(acctNbr) |
| IN_BILLID_IC | C1-InvoiceChargeExtract/billId | Invoice/InvoiceCharge/billId2 | PARAM(billId) |
| IN_PERSON_ID | - | ubl:Invoice/personId | PARAM(personId) |
| IN_PER_ID_NUM | - | ubl:Invoice/personIdNbr | PARAM(personIdNbr) |
| OUT_INV_CURRENCYCD | C1-InvoiceChargeExtract/billCurrency | ubl:Invoice/cbc:DocumentCurrencyCode | - |
| OUT_INV_CURRENCY_PYBLAMT | C1-InvoiceChargeExtract/billCurrency | ubl:Invoice/cac:LegalMonetaryTotal/cbc:PayableAmount/currency | - |
| OUT_INV_CUSTADDR1 | C1-InvoiceChargeExtract/receiver/address1 | ubl:Invoice/cbc:custAdd1 | - |
| OUT_INV_CUSTADDR2 | C1-InvoiceChargeExtract/receiver/address2 | ubl:Invoice/cbc:custAdd2 | - |
| OUT_INV_CUSTADDR3 | C1-InvoiceChargeExtract/receiver/address3 | ubl:Invoice/cbc:custAdd3 | - |
| OUT_INV_CUSTCITY | C1-InvoiceChargeExtract/receiver/city | ubl:Invoice/cbc:custCity | - |
| OUT_INV_CUSTCOUNTRY | C1-InvoiceChargeExtract/receiver/country | ubl:Invoice/cbc:custCountry | - |
| OUT_INV_CUSTMORNAME | C1-InvoiceChargeExtract/receiver/legalName | ubl:Invoice/cac:AccountingCustomerParty/cac:Party/cac:PartyName/cbc:Name | - |
| OUT_INV_CUSTPOSTAL | C1-InvoiceChargeExtract/receiver/postal | ubl:Invoice/cbc:custPostal | - |
| OUT_INV_CUSTSTATE | C1-InvoiceChargeExtract/receiver/state | ubl:Invoice/cbc:custState | - |
| OUT_INV_ID | - | ubl:Invoice/cbc:ID | SCRIPT([IN_BILLID_IC=='' || IN_BILLID_IC=='0'],{ERROR(90003,282,IN_BILLID_IC,:CHAR_DATE,'Error');IN_BILLID_IC}) |
| OUT_INV_INVOICETYPECODE | - | ubl:Invoice/cbc:InvoiceTypeCode | STANDARD |
| OUT_INV_ISSUEDT | C1-InvoiceChargeExtract/billDate | ubl:Invoice/cbc:IssueDate | - |
| OUT_INV_CURRENCY_TAX | C1-InvoiceChargeExtract/billCurrency | ubl:Invoice/cac:TaxTotal/cbc:TaxAmount/currencyID | - |
| OUT_INV_TAXTOTAL | C1-InvoiceChargeExtract/totalInvTaxes | ubl:Invoice/cac:TaxTotal/cbc:TaxAmount | - |
| OUT_INV_LIN_AMT | C1-InvoiceChargeExtract/invoicelineDtls/amount | ubl:Invoice/cac:InvoiceLine/cbc:LineExtensionAmount | - |
| OUT_INV_LIN_CURRENCY_LINEOUTAMT | C1-InvoiceChargeExtract/billCurrency | ubl:Invoice/cac:InvoiceLine/cbc:LineExtensionAmount/currency | - |
| OUT_INV_LIN_CURRENCY_PRICE | C1-InvoiceChargeExtract/billCurrency | ubl:Invoice/cac:InvoiceLine/cac:Price/cbc:PriceAmount/currency | - |
| OUT_INV_LIN_ID | C1-InvoiceChargeExtract/invoicelineDtls/lineNumber | ubl:Invoice/cac:InvoiceLine/cbc:ID | - |
| OUT_INV_LIN_NOTE | C1-InvoiceChargeExtract/invoicelineDtls/descr | ubl:Invoice/cac:InvoiceLine/cbc:Note | - |
| OUT_INV_LIN_QUANTITY | C1-InvoiceChargeExtract/invoicelineDtls/invoiceQuantity | ubl:Invoice/cac:InvoiceLine/cbc:InvoicedQuantity | - |
| OUT_INV_LIN_UNITPRICE | C1-InvoiceChargeExtract/invoicelineDtls/unitPrice | ubl:Invoice/cac:InvoiceLine/cac:Price/cbc:PriceAmount | - |
| OUT_INV_NAMESPACE | - | ubl:Invoice/xmlns:ap | http://www.oracle.com/ap/invoice" xmlns:cac="urn:oasis:names:specification:ubl:schema:xsd:CommonAggregateComponents-2" xmlns:cbc="urn:oasis:names:specification:ubl:schema:xsd:CommonBasicComponents-2" xmlns:ext="urn:oasis:names:specification:ubl:schema:xsd:CommonExtensionComponents-2" xmlns:ubl="urn:oasis:names:specification:ubl:schema:xsd:Invoice-2 |
| OUT_INV_NETAMTDUE | C1-InvoiceChargeExtract/netDueAmt | ubl:Invoice/cac:LegalMonetaryTotal/cbc:PayableAmount | |
| OUT_INV_NOTE | C1-InvoiceChargeExtract/receiver/name | ubl:Invoice/cbc:Note | SCRIPT([OUT_INV_PAYERFULLNAME=='true'],{'CONCAT(OUT_INV_PAYERFULLNAME||' '||OUT_INV_CUSTADDR1||' '||OUT_INV_CUSTADDR2||' '||OUT_INV_CUSTADDR3||' '||OUT_INV_CUSTCITY||' '||OUT_INV_CUSTSTATE||' '||OUT_INV_CUSTPOSTAL||' '||OUT_INV_CUSTCOUNTRY) ';'CONCAT(OUT_INV_CUSTADDR1||' '||OUT_INV_CUSTADDR2||' '||OUT_INV_CUSTADDR3||' '||OUT_INV_CUSTCITY||' '||OUT_INV_CUSTSTATE||' '||OUT_INV_CUSTPOSTAL||' '||OUT_INV_CUSTCOUNTRY) '}) |
| OUT_INV_PAYERFULLNAME | C1-InvoiceChargeExtract/receiver/name | ubl:Invoice/cbc:payerFullName | - |
| OUT_INV_SUPPLIERNAME | C1-InvoiceChargeExtract/sender/legalName | ubl:Invoice/cac:AccountingSupplierParty/cac:Party/cac:PartyName/cbc:Name | - |
| OUT_INV_VERSIONID | - | ubl:Invoice/cbc:UBLVersionID | 2.1 |
Note:
You should always create a new template or copy the existing template for additional field mapping.
You can use predefined functions/scripts to manipulate and enrich extract fields.
Related Topics
| For more information on... | See... |
|---|---|
| How to map fields for the UBL format | Field Mapping for UBL Format |