SSIS Components for Sage Intacct

Build 25.0.9434

Revrecschedule

Maintains schedules outlining how revenue is recognized over time, supporting compliance with revenue recognition principles.

Columns

Name Type ReadOnly Description
Recordno [KEY] Long False

Unique identifier for the revenue recognition schedule.

Revrectemplatekey Long False

Unique key for the revenue recognition template.

Revrectemplateid String True

Identifier for the revenue recognition template.

Templatepostingmethod String False

Method for posting the template.

Recmethod String True

Recognition method used for the schedule.

Milestonesource String False

Source for milestone or percentage-based recognition.

Pacalcsource String True

Calculation method for revenue recognition.

Pacalchours String True

Basis for hours-based recognition calculations.

Scheduleperiod String True

Time period covered by the recognition schedule.

Postingday String False

Day of the month for revenue posting.

Status String True

Current status of the revenue recognition schedule.

Invoiceno String False

Invoice number associated with the schedule.

Invoicedate String False

Invoice date associated with the schedule.

Recordkey Long False

Key for the associated record entry.

Dochdrkey Long False

Document header key associated with the schedule.

Docid String False

Document ID associated with the schedule.

Documentdate String False

Date of the document associated with the schedule.

Description String False

Name or description of the schedule.

Prentrykey Long False

Entry key for the revenue recognition process.

Docentrykey Long False

Key for the document entry associated with the schedule.

Revreccatkey Long False

Key for the revenue recognition category.

Changecategory String True

Category of changes made to the schedule.

Changememo String False

Memo or notes regarding changes to the schedule.

Dayslastperiod Long False

Number of days in the last reporting period.

Projectid String True

Project ID associated with the schedule.

Projectname String True

Name of the project associated with the schedule.

Taskname String True

Name of the task associated with the schedule.

Taskid String False

Identifier for the task associated with the schedule.

Whencreated Datetime True

Timestamp indicating when the schedule was created.

Whenmodified Datetime True

Timestamp indicating the last modification of the schedule.

Createdby Long True

Identifier of the user who created the schedule.

Modifiedby Long True

Identifier of the user who last modified the schedule.

Megaentitykey Long True

Key for the mega-entity associated with the schedule.

Megaentityid String True

ID of the mega-entity associated with the schedule.

Megaentityname String True

Name of the mega-entity associated with the schedule.

Record_url String True

A user-independent, deep-link URL for viewing the schedule record.

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