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 |