Inbound Invoice Fields
Field descriptions, data types, and mandatory fields for the Inbound Invoice table used to import invoice data through the integration framework to create invoices.
| Column | Description | Data type |
|---|---|---|
| Invoice Type \(Mandatory\) | Details about the invoice. | Choice Examples: invoice/non\_ po\_invoice, debit \_memo, credit\_memo |
| Supplier invoice number | The invoice number of the supplier and ERP source and ERP invoice number | String |
| Business owner | email of business the owner who owns the application from the business side | String |
| Supplier \(Mandatory\) | Name of the ERP supplier code | String |
| Purchase order | Binding contract between a buyer and a supplier that authorizes a purchasing transaction. Derived from ERP source and supplier | String |
| Invoice date \(Mandatory\) | The date on which the invoice is created. | String \(yyyy-mm-dd\) |
| Payment terms | Conditions applied on the payment term. | String |
| Legal entity | Stores Legal entity's ERP company code | String |
| Tax amount | Tax rate applied on the invoice amount | Decimal number |
| Shipping amount | Shipping charges incurred for the invoice | Decimal number |
| Subtotal \(Mandatory\) | Total amount of money to be paid to the supplier excluding tax and shipping charges. | Decimal number. Example 12345.65 |
| Other charges | Additional charges incurred on the invoice | Decimal number |
| Discounts | Reduction on the total amount incurred on the invoice | Decimal number |
| Currency | Currency code standard of amount exchanged. ISO 4217 currency code \(USD, GBP, INR, etc\) | String |
| External invoice number \(Mandatory\) | Invoice number originated from a third party application. | String |
| ERP source \(Mandatory\) | The available ERP | String |
| Status | Current state of the invoice is Draft | String |
| External invoice source \(Mandatory\) | Name of the third party application associated with the invoice. | String |
- Inbound invoice line fields
Field definitions and data types for the Inbound Invoice Line [u_inbound_invoice_line] table used to map invoice line data for import through the integration framework. - Inbound invoice payment fields
Field descriptions and data types for inbound invoice payment records used to import supplier invoice payment data into Accounts Payable Operations.
Parent Topic:Create New Invoice form