SAP Open Connectors

Expense Bills

Expense Bills
A commercial document issued by a seller/vendor, relating to a sale transaction and indicating the services, and agreed costs for services the seller/vendor had provided along with the payment terms agreed.

FieldTypeDescription
amountnumberAmount of the bill including tax.
currencystringCurrency of the bill
idstringIdentifier for the bill, unique to the bill in the accounting platform.
linesarrayAn array of bill lines
billingAddressobjectAn object of billing address
billDatedateDate of the bill as recorded in the accounting platform.
dueDatedateDate the supplier is due to be paid.
modifiedDatedateDate the record was last updated in the accounting system.
paymentTermsobjectAn object of Payment Terms applied to the bill
vendorobjectAn object of vendor associated with the bill
createdDatedateDate the record was created in the accounting system.
departmentobjectAn object of department for which the services have been ordered.
externalIdstringFriendly reference of the bill/reference of bill (invoice) from an external system
lastPaidDatedateThe date of the last payment pertaining to this bill
locationobjectAn object of location for which the services have been ordered.
paymentarrayAn array of payment details pertaining to this bill
statusstringCurrent status of this bill.
taxAmountnumberTotal tax amount on the bill
creditLimitnumberCurrent credit limit available from the vendor.
descriptionstringThe description / reference / notes associated with the bill
discountDatedateThe date of discount recorded in the accounting system for the bill
isOnHoldbooleanIndicator of whether the bill is on hold or active
purchase-orderobjectAn object of purchase order associated with this bill
totalAmountDuenumberTotal amount that is due against the bill
totalAmountPaidnumberTotal amount that is paid against the bill
discountAmountnumberTotal discount amount applied on the bill
glPostDaterdateThe date of posting of this transaction in the accounting system (General Ledger)
accountstringThe General Ledger account in which this transaction is posted
landedCostnumberThe bill of lading cost associated with this bill
exchangeRatenumberRate between the currency of the bill and the base currency.
subTotalnumberThe total amount of bill excluding any taxes
  • lines
lines[*].department.idstringThe unique id of the department for which the service has been ordered.
lines[*].department.namestringThe name of the department for which the services has been ordered.
lines[*].descriptionstringThe description / notes pertaining to the service
lines[*].location.idstringThe unique id of the location for which the service has been ordered.
lines[*].location.namestringThe name of the location for which the service has been ordered.
lines[*].subTotalnumberAmount of the line, inclusive of discounts but exclusive of tax.
lines[*].taxAmountnumberAmount of tax for the line.
lines[*].taxCodestringThe applicable tax code pertaining to the line
lines[*].accountstringThe applicable General ledger account where the line is recorded
lines[*].taxRatestringThe tax rate to which the line is linked.
lines[*].totalAmountnumberThe total amount of the line including taxes
lines[*].customer.idstringThe unique identifier of the customer who has ordered the service
lines[*].customer.namestringThe name of the customer who has ordered the service
lines[*].discountAmountnumberThe total applicable discount on this line
lines[*].idstringThe unique identifier of the line in the bill
lines[*].billableStatusstringThe current state of the line
  • billingAddress
billingAddress.citystringCity of vendor’s billing address
billingAddress.countrystringCountry of vendor’s billing address
billingAddress.idstringIdentifier of vendor’s billing address in accounting system
billingAddress.line1stringAddress line1 of vendor’s billing address
billingAddress.line2stringAddress line2 of vendor’s billing address
billingAddress.phonestringPhone number of vendor’s billing address
billingAddress.postalCodestringPostal code of vendor’s billing address
billingAddress.provincestringProvince of vendor’s billing address
billingAddress.contact.firstNamestringFirst name of contact at vendor’s billing address
billingAddress.contact.middleNamestringMiddle name of contact at vendor’s billing address
billingAddress.contact.lastNamestringLast name of contact at vendor’s billing address
billingAddress.contact.salutationstringSalutation / Title of contact at vendor’s billing address
billingAddress.contact.emailstringEmail of contact at vendor’s billing address
  • paymentTerms
paymentTerms.idstringIdentifier of the payment terms.
paymentTerms.namestringName of the payment terms.
  • vendor
vendor.idstringIdentifier of the supplier / vendor
vendor.namestringName of the supplier / vendor
  • department
department.idstringIdentifier of the department
department.namestringName of the department
  • location
location.idstringIdentifier of the location
location.namestringName of the location
  • payment
payment[*].idstringIdentifier of the payment
payment[*].amountnumberAmount paid for this payment
  • purchase-order
purchase-order.idstringThe unique identifier of purchase order