Field Mapping for UBL Format
To extract the data in the UBL format, each tag is mapped to a field as shown in the following table:
| UBL Tag Name | XML Tag Name | Table | Field | Comments |
|---|---|---|---|---|
| ubl:Invoice | - | - | - | - |
| cbc:UBLVersionID | - | - | OUT_INV_VERSIONID | - |
| cbc:InvoiceTypeCode | - | - | OUT_INV_INVOICETYPECODE | - |
| cbc:payerFullName | name | CI_PER_NAME.ENTITY_NAME | OUT_INV_PAYERFULLNAME | The data in this tag is derived from the receivers contact record where the NAME_TYP_FLG is set to PRIM. |
| cbc:custAdd1 | address1 | CI_PER.ADDRESS 1 | OUT_INV_CUSTADDR1 | - |
| cbc:custAdd2 | address2 | CI_PER.ADDRESS 2 | OUT_INV_CUSTADDR2 | - |
| cbc:custAdd3 | address3 | CI_PER.ADDRESS 3 | OUT_INV_CUSTADDR3 | - |
| cbc:custCity | city | CI_PER.CITY | OUT_INV_CUSTCITY | - |
| cbc:custCountry | country | CI_PER.COUNTRY | OUT_INV_CUSTCOUNTRY | - |
| cbc:DocumentCurrencyCode | billCurrency | OUT_INV_CURRENCYCD | - | |
| cbc:IssueDate | billDate | CI_BILL.BILL_DT | OUT_INV_ISSUEDT | - |
| cbc:ID | - | CI_BILL.BILL_ID | OUT_INV_ID | - |
| cbc:Note | name | - | OUT_INV_NOTE | The data in this tag is derived from the receivers name and address details. |
| cac:AccountingCustomerParty | - | CI_PER_NAME.ENTITY_NAME | - | - |
| cac:Party | - | - | - | - |
| cac:PartyName | - | - | - | - |
| cbc:Name | legalName | CI_PER_NAME.ENTITY_NAME | OUT_INV_CUSTMORNAME | The data is this tag is derived from the receivers record where the NAME_TYP_FLG is set to LGAL. |
| cac:AccountingSupplierParty | - | CI_PER_NAME.ENTITY_NAME | - | - |
| cac:Party | - | - | - | - |
| cac:PartyName | - | - | - | - |
| cbc:Name | legalName | CI_PER_NAME.ENTITY_NAME | OUT_INV_SUPPLIERNAME | The data is this tag is derived from the senders record where the NAME_TYP_FLG is set to LGAL. |
| cac:LegalMonetaryTotal | - | - | - | - |
| cbc:PayableAmount | netAmtDue | - | OUT_INV_NETAMTDUE | The data in this tag is derived from the statement extractor. |
| cac:TaxTotal | - | - | - | - |
| cbc:TaxAmount | totalInvTaxes | - | OUT_INV_TAXTOTAL | - |
| currencyID | billCurrency | - | OUT_INV_CURRENCY_TAX | - |
| cac:InvoiceLine | - | - | - | - |
| cac:Price | - | - | - | - |
| cbc:PriceAmount | unitPrice | - | OUT_INV_LIN_UNITPRICE | The data in this tag is derived from the statement extractor. |
| cbc:ID | lineNumber | - | OUT_INV_LIN_ID | The data in this tag is derived from the statement extractor. |
| cbc:Note | descr | - | OUT_INV_LIN_NOTE | The data in this tag is derived from the statement extractor. |
| cbc:LineExtensionAmount | amount | - | OUT_INV_LIN_AMT | The data in this tag is derived from the statement extractor. |
| cbc:InvoicedQuantity | invoiceQuantity | - | OUT_INV_LIN_QUANTITY | The data in this tag is derived from the statement extractor. |
| currency | billCurrency | CI_ACCT.CURRENCY_CD | OUT_INV_CURRENCY_PYBLAMT | - |
| cbc:custPostal | postal | CI_PER.POSTAL | OUT_INV_CUSTPOSTAL | - |
| cbc:custState | state | CI_PER.STATE | OUT_INV_CUSTSTATE | - |
| currency | billCurrency | CI_ACCT.CURRENCY_CD | OUT_INV_LIN_CURRENCY_LINEOUTAMT | - |
| xmlns:ap | - | - | OUT_INV_NAMESPACE | - |
| accountId | - | - | IN_ACCOUNT_ID | - |
| acctNbr | - | - | IN_ACCT_NBR | - |
| InvoiceCharge | - | - | - | - |
| billId2 | billId | - | IN_BILLID_IC | - |
| personId | - | - | IN_PERSON_ID | - |
| personIdNbr | - | - | IN_PER_ID_NUM | - |
Related Topics
| For more information on... | See... |
|---|---|
| C1-UBLINVOICEEXTRACT Extract Template | C1-UBLINVOICEEXTRACT Extract Template |