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.) |