Power BI Connector for Sage Intacct

Build 25.0.9454

OtherReceiptsEntry

Maintains line-level details for miscellaneous receipts, including allocations to specific accounts, departments, or projects.

Columns

Name Type Description
Recordno [KEY] String The unique identifier for the other receipts entry record.
Recordkey Int64 The key representing the specific record for the other receipts entry.
Recordtype String The type classification of the other receipts entry record.
Accountkey Int64 The key identifying the account associated with the other receipts entry.
Accountno String The account number associated with the other receipts entry.
Accounttitle String The title of the account associated with the other receipts entry.
Accountlabelkey Int64 The key identifying the label of the account for the other receipts entry.
Accountlabel String The label of the account associated with the other receipts entry.
Amount Double The amount specified for the other receipts entry.
Trx_amount Double The transaction amount in the associated currency for the other receipts entry.
DeptNUM Int64 The department number associated with the other receipts entry.
Departmentid String The identifier of the department associated with the other receipts entry.
Departmentname String The name of the department associated with the other receipts entry.
LocationNUM Int64 The location number associated with the other receipts entry.
Locationid String The identifier of the location associated with the other receipts entry.
Locationname String The name of the location associated with the other receipts entry.
Description String A brief description of the other receipts entry.
Exch_rate_date Datetime The date for the applicable exchange rate for the other receipts entry.
Exch_rate_type_id String The identifier for the exchange rate type applied to the other receipts entry.
Exchange_rate Double The exchange rate applied to the transaction for the other receipts entry.
Lineitem String The line item identifier for the other receipts entry.
Line_no String The line number associated with the other receipts entry.
Currency String The transaction currency used for the other receipts entry.
Basecurr String The base currency for the other receipts entry transaction.
Status String The current status of the other receipts entry.
Whencreated Datetime The date and time when the other receipts entry record was created.
Whenmodified Datetime The date and time when the other receipts entry record was last modified.
Createdby Int64 The identifier of the user who created the other receipts entry record.
Modifiedby Int64 The identifier of the user who last modified the other receipts entry record.
Departmentkey Int64 The key identifying the department associated with the other receipts entry.
Locationkey Int64 The key identifying the location associated with the other receipts entry.
Projectdimkey Int64 The key identifying the project dimension associated with the other receipts entry.
Projectid String The identifier of the project associated with the other receipts entry.
Projectname String The name of the project associated with the other receipts entry.
Customerdimkey Int64 The key identifying the customer dimension associated with the other receipts entry.
Customerid String The identifier of the customer associated with the other receipts entry.
Customername String The name of the customer associated with the other receipts entry.
Vendordimkey Int64 The key identifying the vendor dimension associated with the other receipts entry.
Vendorid String The identifier of the vendor associated with the other receipts entry.
Vendorname String The name of the vendor associated with the other receipts entry.
Employeedimkey Int64 The key identifying the employee dimension associated with the other receipts entry.
Employeeid String The identifier of the employee associated with the other receipts entry.
Employeename String The name of the employee associated with the other receipts entry.
Itemdimkey Int64 The key identifying the item dimension associated with the other receipts entry.
Itemid String The identifier of the item associated with the other receipts entry.
Itemname String The name of the item associated with the other receipts entry.
Classdimkey Int64 The key identifying the class dimension associated with the other receipts entry.
Classid String The identifier of the class associated with the other receipts entry.
Classname String The name of the class associated with the other receipts entry.
Record_url String The URL link to view the other receipts entry record.

Copyright (c) 2025 CData Software, Inc. - All rights reserved.
Build 25.0.9454