Contractbillingschedule

Metadata for managing contract billing schedules in Sage Intacct.

Columns


Name	Type	Description
Recordno [KEY]	Long	Unique record number for the billing schedule.
Type	String	Type of billing schedule.
Contractkey	Long	Unique key referencing the contract.
Contractdetailkey	Long	Key referencing the contract detail.
State	String	State of the billing schedule.
Contractdetail_templatename	String	Name of the billing template.
Contractid	String	Unique identifier for the contract.
Lineno	Long	Line number associated with the contract.
Begindate	Date	Start date of the billing schedule.
Enddate	Date	End date of the billing schedule.
Templatekey	Long	Unique key referencing the billing template.
Canceldate	Date	Date the billing schedule was canceled.
Billingholddate	Date	Date the billing schedule was put on hold.
Billingresumedate	Date	Date the billing schedule was resumed.
Cndetailglpostingdate	Date	General ledger posting date for the contract detail.
Whencreated	Datetime	Timestamp of when the billing schedule was created.
Whenmodified	Datetime	Timestamp of the last modification to the billing schedule.
Createdby	Long	Identifier for the user who created the billing schedule.
Modifiedby	Long	Identifier for the user who last modified the billing schedule.
Completedate	Date	Date of the estimated revaluation completion.
Contract_recordno [KEY]	Long	Foreign key referencing the related contract record.
Contractdetail_recordno [KEY]	Long	Foreign key referencing the related contract detail record.

Tracks revenue schedules for contracts, supporting financial reporting and compliance.


Name	Type	Description
Recordno [KEY]	Long	Unique record number for the billing schedule.
Type	String	Type of billing schedule.
Contractkey	Long	Unique key referencing the contract.
Contractdetailkey	Long	Key referencing the contract detail.
State	String	State of the billing schedule.
Contractdetail_templatename	String	Name of the billing template.
Contractid	String	Unique identifier for the contract.
Lineno	Long	Line number associated with the contract.
Begindate	Date	Start date of the billing schedule.
Enddate	Date	End date of the billing schedule.
Templatekey	Long	Unique key referencing the billing template.
Canceldate	Date	Date the billing schedule was canceled.
Billingholddate	Date	Date the billing schedule was put on hold.
Billingresumedate	Date	Date the billing schedule was resumed.
Cndetailglpostingdate	Date	General ledger posting date for the contract detail.
Whencreated	Datetime	Timestamp of when the billing schedule was created.
Whenmodified	Datetime	Timestamp of the last modification to the billing schedule.
Createdby	Long	Identifier for the user who created the billing schedule.
Modifiedby	Long	Identifier for the user who last modified the billing schedule.
Completedate	Date	Date of the estimated revaluation completion.
Contract_recordno [KEY]	Long	Foreign key referencing the related contract record.
Contractdetail_recordno [KEY]	Long	Foreign key referencing the related contract detail record.