Information for the FinancialBatch

Columns

• Id (datatype: int) Required Primary Key
• Name (datatype: nvarchar(50)) Required Primary Key
• BatchStartDateTime (datatype: datetime) Required Primary Key
• BatchEndDateTime (datatype: datetime) Required Primary Key
• Status (datatype: int) Required Primary Key
• CampusId (datatype: int) Required Primary Key
• AccountingSystemCode (datatype: nvarchar(100)) Required Primary Key
• ControlAmount (datatype: decimal(18, 2)) Required Primary Key
• Guid (datatype: uniqueidentifier) Required Primary Key
• CreatedDateTime (datatype: datetime) Required Primary Key
• ModifiedDateTime (datatype: datetime) Required Primary Key
• CreatedByPersonAliasId (datatype: int) Required Primary Key
• ModifiedByPersonAliasId (datatype: int) Required Primary Key
• ForeignKey (datatype: nvarchar(100)) Required Primary Key
• Note (datatype: nvarchar(max)) Required Primary Key
• ForeignGuid (datatype: uniqueidentifier) Required Primary Key
• ForeignId (datatype: int) Required Primary Key
• IsAutomated (datatype: bit) Required Primary Key
• ControlItemCount (datatype: int) Required Primary Key
• RemoteSettlementBatchUrl (datatype: nvarchar(300)) Required Primary Key
• RemoteSettlementBatchKey (datatype: nvarchar(50)) Required Primary Key
• RemoteSettlementAmount (datatype: decimal(18, 2)) Required Primary Key