Tableau Connector for Sage Intacct

Build 21.0.7930

Revrecscheduleentry

Retrieves RevRecScheduleEntry report data.

Columns

Name Type ReadOnly Description
Recordno [KEY] Long False

Record Number

Revrecschedulekey Long False

REVRECSCHEDULEKEY

Posted String True

Period Offset

Position String False

Position

Next String False

Next

Postingdate Date False

Posting Date

Revacctkey String False

Account Key

Accountno String False

ACCOUNTNO

Accounttitle String False

ACCOUNTTITLE

Journalkey Long False

GL Journal Key

Gljournal String True

GL Journal Key

Deferredrevacctkey String False

Defered Rev Acct Key

Amount Decimal True

Amount

Glbatchkey Long False

GLBATCHKEY

Schopkey Long False

SCHOPKEY

Tr_type Long False

tr type

Trx_amount Decimal False

Amount

Currency String True

Currency

Posted_amount Decimal True

Amount

Basecurr String True

Base Currency

Exch_rate_date Date False

Exchange Rate Date

Exch_rate_type_id Long False

Exchange Rate Type

Exchange_rate Decimal False

Exchange Rate

Description String False

Description

Parentstatus String True

Revenue Posting Status

Unscheduled Bool False

Budgetqty Decimal True

Budgeted hours

Estqty Decimal True

Estimated hours

Plannedqty Decimal True

Planned hours

Actualqty Decimal True

Approved hours

Percentcompleted Decimal True

Percent Completed

Percentrecognized Decimal True

Percent Recognized

Obspercentcomplete Decimal True

Observed Percent Completed

Budgetedcost Decimal True

Budgeted Cost

Totalcost Decimal True

Actual Cost

Whencreated Datetime True

timestamp marking last time this was created.

Whenmodified Datetime True

timestamp marking last time this was changed.

Createdby Long True

User who created this.

Modifiedby Long True

User who modified this.

Projectdimkey Long False

Projectdimkey

Projectid String False

Project

Projectname String False

Project Name

Customerdimkey Long False

Customerdimkey

Customerid String False

Customer

Customername String False

Customer Name

Vendordimkey Long False

Vendordimkey

Vendorid String False

Vendor

Vendorname String False

Vendor Name

Employeedimkey Long False

Employeedimkey

Employeeid String False

Employee

Employeename String False

Employee Name

Itemdimkey Long False

Itemdimkey

Itemid String False

Item

Itemname String False

Item Name

Classdimkey Long False

Classdimkey

Classid String False

Class

Classname String False

Class Name

Warehousedimkey Long False

Warehousedimkey

Warehouseid String False

Warehouse

Warehousename String False

Warehouse Name

Contractdimkey Long False

Contractdimkey

Contractid String False

Contract

Contractname String False

Contract Name

Record_url String True

A portable, user-independent, deep-link URL for viewing this record

Gldimtestegi1 String False

Gldimtest String False

Copyright (c) 2021 CData Software, Inc. - All rights reserved.
Build 21.0.7930