Use data elements in the Receivables UBL 2.1 XML extract to include detailed
financial and tax information in your business-to-business electronic invoices.
Many countries now mandate the delivery of accurate and transparent data to businesses
and tax authorities for all transactions subject to VAT.
These additional data elements help improve the entry and delivery of UBL 2.1 electronic
invoices. You can also use the additional data elements to create custom output files
with data specific to a particular transaction or government requirement.
Create an Electronic Invoice with Additional Data Elements
To create and deliver an electronic invoice with additional data elements:
- Create a Receivables transaction with invoice and tax lines.
Make use of the
additional data elements to include all details required by the local
government tax authority.
- Run the Generate and Transfer XML Transactions process.
A run of the Generate
and Transfer XML Transactions process generates and displays the original
message extract file and the UBL 2.1 XML transformed message in the Manage
Collaboration Messaging History page.
- Navigate to the Manage Collaboration Messaging History page.
- Open both the original extract message and the UBL 2.1 XML transformed
message.
The output file contains the XML File Header, Invoice Header,
Invoice Lines, Invoice Tax details and additional invoice information
specific to the transaction.
Financial and Tax Data Elements for UBL 2.1 XML Transactions
The following tables describe the 13 sets of additional data elements available for
the Receivables XML message. All 13 sets of attributes are available for use in all
countries.
Header
Header Element |
Navigation and Notes |
Transaction Source |
Transaction - General Information - Transaction Source |
Accounting Date |
Transaction - General Information - Accounting Date |
Notes |
Transaction - General Information - Notes (4000 bytes maximum;
Public Notes Only) |
FOB (Free on Board) |
Transaction - General Information - Edit Freight - FOB |
Exempt from late charges |
Transaction - General Information - Payment option - Exempt from
late charges |
Default Tax Exemption Handling |
Transaction - General Information - Miscellaneous - Default Tax
Exemption Handling: Code/Description |
Print Date (date the XML file is generated) |
Transaction - General Information - Miscellaneous - Print
Date |
Attachments |
Transaction - Attachments: Title/Description |
Payment Status |
Paid/Not Paid/Partially Paid |
Product Type |
Concatenated Product Type Values from Transaction Lines |
Internal Notes from Projects |
|
Lines
Line Element |
Navigation and Notes |
Channel |
Transaction - Line - Sales Order - Channel |
Exemption Handling |
Transaction - Line - Tax Exemption - Exemption Handling:
Code/Description |
Certificate Number |
Transaction - Line - Tax Exemption - Certificate Number |
Sales Order Details |
Transaction - Line - Details: Number/Line/Channel/Date |
Ship-to Customer Details |
Transaction - Line - Ship-to Customer - Details: Name/Address
Line 1-4/City/County/State/Province/Postal Code/Country |
Tax Lines
Tax Line Element |
Navigation and Notes |
Tax Status Details |
Transaction - Line - Detail Tax Line - Details: Tax Status
Name/Tax Status Code |
Legal justification message |
For tax lines that use tax rules |
Memo Lines
Memo Line Element |
Navigation and Notes |
Memo Line |
Global Descriptive Flexfield (GDF) |
Bill-to Customer
Bill-to Customer Element |
Navigation and Notes |
Translated Customer Name |
Customer - Site Details - Account Address Details - Translated
Customer Name |
SIRET Number (France only) |
Customer - Site - Profile History - Site Profile - Additional
Information - Regional Information - Customer Profiles for France -
SIRET Number |
Routing Code (France only) |
Customer - Site - Profile History- Site Profile - Additional
Information - Regional Information - Customer Profiles for France -
Routing Code |
Tax Registration Status (for TRN defined on Transaction Header
) |
Customer - Site - Tax Profile - Tax Registration - Create Tax
Registration: Tax Registration Status |
Ship-to Customer
Ship-to Customer Element |
Navigation and Notes |
Party Site Descriptive Flexfields |
|
Concatenate Party Site Purpose |
|
Paying Customer
Paying Customer Element |
Navigation and Notes |
Paying Customer Name |
Transaction - Customer - Paying Customer - Name |
Descriptive Flexfields |
Customer - Site - Profile History - Site Profile - Additional
Information - Context Value - Descriptive Flexfields |
Global Descriptive Flexfields (France only) |
Customer - Site - Profile History - Site Profile - Additional
Information - Regional Information - Customer Profiles for France -
SIRET Number/Routing Code |
Customer Account Site Information Descriptive Flexfields |
Customer - Site - Site Details - Enter Customer Account Site
information - Descriptive Flexfields |
Paying Customer Address |
Transaction - Customer - Paying Customer - Address: Address Line
1-4/City/County/State/Province/Postal Code/Country |
Primary Contacts |
Account or Site: Name/Phone/Email |
Tax Registration Number |
Customer - Site - Tax Profile - Tax Registration - Edit Tax
Registration: Registration Number/Tax Regime Name If multiple TRNs
are defined on the Customer Site, you must define a default to
display a TRN on the transaction. |
Legal Entity
Legal Entity Element |
Navigation and Notes |
Place of Registration |
Manage Legal Entity Registration: Place of Registration |
Legal Reporting Unit
Legal Reporting Unit Element |
Navigation and Notes |
Registered Name |
Manage Legal Reporting Unit Registration: Registered Name |
Alternate Name |
Manage Legal Reporting Unit Registration: Alternate Name |
Registration Number |
Manage Legal Reporting Unit Registration: Registration
Number |
Bank Account
Bank Account Element |
Navigation and Notes |
Description |
Manage Bank Accounts: Description |
Account Type/Deposit Type |
Manage Bank Accounts: Account Type or Deposit Type |
Legal Entity Bank Account
Legal Entity Bank Account Element |
Navigation and Notes |
Legal Entity Name |
Manage Bank Accounts: Legal Entity Name |
Legal Entity Address |
Address: Line 1-4/City/County/ State/Province/Postal
Code/Country |
Legal Entity Primary Contact |
Name/Phone/Email |
Legal Entity Registration |
Number/Code |
Legal Reporting Unit Registration |
Number/Code |
Payment Card
Payment Card Element |
Navigation and Notes |
Credit Card |
Transaction - Payment - Payment Details - Credit Card - Masked
Credit Card number |
Name on Card |
Transaction - Payment - Payment Details - Name on Card |
Previous Invoice References
Reference Element |
Navigation and Notes |
Previous Invoice Type |
|
Previous Invoice ID |
|
Previous Invoice Line Number |
|
Previous Invoice Date |
|