SSIS Components for Sage Intacct

Build 24.0.9062

Revrecschedule

Retrieves RevRecSchedule report data.

Columns

Name Type ReadOnly Description
Recordno [KEY] Long False

Record Number

Revrectemplatekey Long False

Rev Rec Template Key

Revrectemplateid String True

Template

Templatepostingmethod String False

Template posting method

Recmethod String True

Recognition method

Milestonesource String False

Percent or Milestone source

Pacalcsource String True

Calculation Method

Pacalchours String True

Based on

Scheduleperiod String True

Schedule Period

Postingday String False

Posting Day

Status String True

Revenue posting status

Invoiceno String False

INVOICENO

Invoicedate String False

INVOICEDATE

Recordkey Long False

prrecord record key

Dochdrkey Long False

Document Header Key

Docid String False

DOCID

Documentdate String False

DOCUMENTDATE

Description String False

Name

Prentrykey Long False

PRENTRYKEY

Docentrykey Long False

Document Entry Key

Revreccatkey Long False

Rev Rec Category Key

Changecategory String True

rev. rec. category

Changememo String False

changememo

Dayslastperiod Long False

Days in last period

Projectid String True

Project ID

Projectname String True

Project Name

Taskname String True

Task Name

Taskid String False

Task ID

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.

Megaentitykey Long True

Created at - Entity key

Megaentityid String True

Created at - Entity ID

Megaentityname String True

Created at - Entity name

Record_url String True

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

Copyright (c) 2024 CData Software, Inc. - All rights reserved.
Build 24.0.9062