Table "Date Compr. Register"
ID 87
Namespace: Microsoft.Foundation.Period
Properties
Fields
| Name |
Type |
Description |
| "No." |
Integer
|
|
| "Creation Date" |
Date
|
|
| "Table Caption" |
Text[250]
|
|
| "Period Length" |
Option
|
|
| "Ending Date" |
Date
|
|
| "No. of New Records" |
Integer
|
|
| "No. Records Deleted" |
Integer
|
|
| "User ID" |
Code[50]
|
|
| Filter |
Text[250]
|
|
| "Starting Date" |
Date
|
|
| "Table ID" |
Integer
|
|
| "Register No." |
Integer
|
|
| "Source Code" |
Code[10]
|
|
| "Retain Field Contents" |
Text[80]
|
|
| "Retain Totals" |
Text[80]
|
|
| SystemId |
Guid
|
|
| SystemCreatedAt |
DateTime
|
|
| SystemCreatedBy |
Guid
|
|
| SystemModifiedAt |
DateTime
|
|
| SystemModifiedBy |
Guid
|
|
| SystemRowVersion |
BigInteger
|
|
Methods
GetLastEntryNo
procedure GetLastEntryNo(): Integer
Returns
InitRegister
procedure InitRegister(TableID: Integer, RegNo: Integer, StartingDate: Date, EndingDate: Date, PeriodLength: Integer, EntryFilter: Text[250], RelatedRegNo: Integer, SourceCode: Code[10])
Parameters
| Name |
Type |
Description |
|
TableID
|
Integer
|
|
|
RegNo
|
Integer
|
|
|
StartingDate
|
Date
|
|
|
EndingDate
|
Date
|
|
|
PeriodLength
|
Integer
|
|
|
EntryFilter
|
Text[250]
|
|
|
RelatedRegNo
|
Integer
|
|
|
SourceCode
|
Code[10]
|
|
CheckMaxDateCompressed
procedure CheckMaxDateCompressed(MaxPostingDate: Date, Type: Option)
Parameters
| Name |
Type |
Description |
|
MaxPostingDate
|
Date
|
|
|
Type
|
Option
|
|
See also