Vendor credits template
The following table lists the fields that can be selected in the vendor credits template.
| Field Display Name | Field data type | Description | Values |
|---|---|---|---|
| Action type | List | The action to take on the bill:
|
|
| Amount | FloatingPoint | Total amount of the submitted bill | |
| Amount absolute value | FloatingPoint | The absolute value of the bill amount | |
| AP Account external ID | String | An ID that uniquely identifies the AP account in the ERP | |
| AP Account name | String | The default AP account name | |
| AP Account number | String | The default AP account number | |
| Bill attachment | String | Bill's original invoice download link | |
| Bill status | List | The status of the bill |
|
| Creation date | Datetime | The date the bill was created in Tipalti | |
| Currency | String | The currency of the invoice | |
| Description | String | A description of the invoice | |
| Due date | Datetime | The date the invoice is due to be paid | |
| Invoice date | Datetime | The date the invoice was created | |
| Invoice ID | String | The ID of the invoice | |
| Invoice number | String | The number of the invoice | |
| Journal entry account number | String | The GL account which is relevant to the journal entry line. | |
| Net Amount | FloatingPoint | Total net amount of the vendor credit | |
| Number of lines | Integer | Total number of bill lines in the file | |
| Payee Address 1 | String | Payee street address line 1 | |
| Payee Address 2 | String | Payee street address line 2 | |
| Payee alias | String | An alternate name for the payee, if applicable | |
| Payee AP account external id | String | The default AP account external id of the payee linked to the vendor credit | |
| Payee AP account name | String | The default AP account name of the payee linked to the vendor credit | |
| Payee AP account number | String | The default AP account number of the payee linked to the vendor credit | |
| Payee City | String | Payee city | |
| Payee Country | String | Payee country | |
| Payee external ID | String | The external unique payee identifier | |
| Payee ID | String | Unique payee identifier | |
| Payee name | String | Full name of payee (for individuals) or company name (for companies) | |
| Payee payment term days | Integer | The number of days of the payment term | |
| Payee payment term name | String | The display name for the payment term in the Tipalti Hub | |
| Payee payment term external ID | String | The ID associated with the payment term | |
| Payee State | String | Payee state/ province | |
| Payee Zip | String | Payee zip/ postal code | |
| Payees company name | String | Payee company name | |
| Payer entity name | String | The payer's default entity | |
| Payer entity name | Integer | The payer's default entity | |
| Tax Amount | FloatingPoint | Total tax amount of the vendor credit | |
| Total amount | FloatingPoint | The total amount of the bill (Net amount + Delivery costs + Tax amount Discount) | |
| Business posting group | String | ||
| Description | String | A description of bill line | |
| External line ID | String | ||
| GL account external id | String | An ID that uniquely identifies the GL account in the payer s ERP | |
| GL account name | String | The name of the GL account in the payer's ERP | |
| GL account number | String | The number of the GL account in the payer's ERP | |
| Journal entry account number | String | The GL account which is relevant to the journal entry line. | |
| Journal entry line type | List | The type of the Journal entry line (Credit or Debit). |
|
| Line identifier | String | unique number to identify line | |
| Net amount (line) | FloatingPoint | The amount of the bill line | |
| Product posting group | String | ||
| Quantity | FloatingPoint | The number of units for the bill line description | |
| Tax amount | FloatingPoint | The total amount of tax charged by the supplier A negative number (for vendor credit) is allowed | |
| Tax Code | String | The type of tax code and its rate | |
| Tax rate display name | String | ||
| Total amount | FloatingPoint | Net amount plus tax amount | |
| Unit ID | String | ||
| Unit name | String | ||
| Unit price | FloatingPoint | The price for a single unit of the bill line A negative number (for vendor credit) is allowed | |
| Unit type | String | The unit of measurement for the bill line description (e.g., kilograms, pounds, etc.) |