Skip to main content
AR

ARStatementCycle

PX.Objects.ARScreenAR202800Release 2025.2

No summary is documented for this DAC in the release source.

Field NameTypeDisplay NameForeign Key
AgeBasedOn
char(1)Age Based On-
Description:Indicates whether documents of customers belonging to the current statement cycle should be aged based on their document date, or their due date.
AgeDays00 API
smallintAge Days 1-
Description:An integer value indicating the upper inclusive bound, in days, of the first aging period. For example, if AgeDays00 is equal to 7, then the first aging period will correspond to documents that are 1-7 days past due.
AgeDays01 API
smallintAge Days 2-
Description:An integer value indicating the upper inclusive bound, in days, of the second aging period. For example, if AgeDays00 is equal to 7, and AgeDays01 is equal to 14, then the second aging period will correspond to documents that are 8-14 days past due.
AgeDays02 API
smallintAge Days 3-
Description:An integer value indicating the upper inclusive bound, in days, of the third non-current aging period. For example, if AgeDays01 is equal to 14, and AgeDays02 is equal to 21, then the third aging period will correspond to documents that are 15-21 days past due.
AgeMsg00 API
nvarchar(60)Age Message 1-
Description:The description of the first aging period, which incorporates documents that are from 1 to AgeDays00 days past due.
AgeMsg01 API
nvarchar(60)Age Message 2-
Description:The description of the second aging period, which incorporates documents that are from AgeDays00 + 1 to AgeDays01 days past due.
AgeMsg02 API
nvarchar(60)Age Message 3-
Description:The description of the third aging period that incorporates documents that are from AgeDays01 + 1 to AgeDays02 days past due.
AgeMsg03 API
nvarchar(60)Age Message 4-
Description:The description of the last aging period that incorporates documents that are over AgeDays02 days past due.
AgeMsgCurrent
nvarchar(60)Age Message 0-
Description:The description of the zeroth (current) aging period, which incorporates documents that are not overdue.
Bucket01LowerInclusiveBoundNonexistent in DB
int?-
Description:A display-only integer field indicating the lower inclusive bound, in days, of the first aging period.
Bucket02LowerInclusiveBoundNonexistent in DB
int?-
Description:A display-only integer field indicating the lower inclusive bound, in days, of the second aging period.
Bucket03LowerInclusiveBoundNonexistent in DB
int?-
Description:A display-only integer field indicating the lower inclusive bound, in days, of the third aging period.
Bucket04LowerExclusiveBoundNonexistent in DB
int?-
Description:A display-only integer field indicating the lower exclusive bound, in days, of the last aging period (the "over" period).
CreatedByIDDefault Navigation
uniqueidentifierCreated ByUsers
Description:No description available
CreatedByScreenID
char(8)-
Description:No description available
CreatedDateTime API
datetimeCreated On-
Description:No description available
Day00 API
smallintDay of Month 1-
Description:For ARStatementScheduleType.TwiceAMonth and ARStatementScheduleType.FixedDayOfMonth schedule types, indicates the first (or the only, correspondingly) day of month, on which customer statements are generated.
Day01 API
smallintDay of Month 2-
Description:For ARStatementScheduleType.TwiceAMonth schedule type, indicates the second day of month, on which bi-monthly customer statements are generated.
DayOfWeek
intDay of Week-
Description:For ARStatementScheduleType.Weekly schedule type, indicates the day of the week, on which weekly customer statements are generated.
Descr API
nvarchar(60)Description-
Description:The statement cycle description.
FinChargeApply API
bitApply Overdue Charges-
Description:A boolean value indicating whether financial charges should be applied to customers belonging to the current statement cycle.
FinChargeID API Default Navigation
nvarchar(10)Overdue Charge IDARFinCharge
Description:The reference to the overdue charge that should be calculated for customers belonging to the current statement cycle.
LastAgeDateObsolete
datetime-
Description:Obsolete field.
LastFinChrgDate
datetimeLast Finance Charge Date-
Description:Indicates the date on which financial charges were last generated for the current statement cycle.
LastModifiedByIDDefault Navigation
uniqueidentifierLast Modified ByUsers
Description:No description available
LastModifiedByScreenID
char(8)-
Description:No description available
LastModifiedDateTime API
datetimeLast Modified On-
Description:No description available
LastStmtDate API
datetimeLast Statement Date-
Description:Indicates the date on which customer statements were last generated for the current statement cycle.
NextStmtDateNonexistent in DB
DateTime?Next Statement Date-
Description:A non-DB calculated field indicating the next date on which the customer statements will be generated.
NoteID
uniqueidentifier-
Description:The unique identifier of the note associated with the current statement cycle.
PrepareOn API
char(1)Schedule Type-
Description:Indicates the type of schedule, according to which customer statements are generated within the current statement cycle. See ARStatementScheduleType.
PrintEmptyStatements
bitPrint Empty Statements-
Description:If "true", the system will generate but not print or email Open Item statements without open documents, and Balance Brought Forward statements if there was no activity in the period and the balance brought from the previous statement is zero.
RequireFinChargeProcessing API
bitRequire Overdue Charges Calculation Before Statement-
Description:A boolean value indicating whether the system should require the overdue charges calculation before generating customer statements.
RequirePaymentApplication API
bitRequire Payment Application Before Statement-
Description:A boolean value indicating whether the system should require all open customer payments to be applied in full before generating customer statements.
SelectedNonexistent in DB
bool?Selected-
Description:A non-DB field indicating whether the current statement cycle has been selected for processing by a user.
StatementCycleId API Default Navigation
nvarchar(10)Cycle ID-
Description:Key field. A human-readable unique string identifier of the statement cycle.
UseFinPeriodForAging
bitUse Financial Periods for Aging-
Description:A boolean value indicating whether financial periods should be used instead of user-defined aging periods. If "true", the fields AgeDays00, AgeDays01, and AgeDays02 will not be used for aging. Instead, the current (corresponding to the statement/aging date) and the three preceding financial periods will be used.
tstamp
timestamp-
Description:No description available