ARStatementCycle

PX.Objects.AR

View API Entity: StatementCycle/entity/Default/24.200.001/StatementCycle

38 of 38 fields

	Field Name	Type	Display Name	Foreign Key
	`StatementCycleId`Default Navigation	`nvarchar(10)`	Cycle ID	-
Description:Key field. A human-readable unique string identifier of the statement cycle.
	`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`	`smallint`	Age 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`	`smallint`	Age 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`	`smallint`	Age 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`	`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`	`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`	`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`	`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.
	`Bucket01LowerInclusiveBound`Nonexistent in DB	`int`	Bucket01LowerInclusiveBound	-
Description:A display-only integer field indicating the lower inclusive bound, in days, of the first aging period.
	`Bucket02LowerInclusiveBound`Nonexistent in DB	`int`	Bucket02LowerInclusiveBound	-
Description:A display-only integer field indicating the lower inclusive bound, in days, of the second aging period.
	`Bucket03LowerInclusiveBound`Nonexistent in DB	`int`	Bucket03LowerInclusiveBound	-
Description:A display-only integer field indicating the lower inclusive bound, in days, of the third aging period.
	`Bucket04LowerExclusiveBound`Nonexistent in DB	`int`	Bucket04LowerExclusiveBound	-
Description:A display-only integer field indicating the lower exclusive bound, in days, of the last aging period (the "over" period).
	`CreatedByID`Default Navigation	`uniqueidentifier`	Created By	Users
Description:No description available
	`CreatedByScreenID`	`char(8)`		-
Description:No description available
	`CreatedDateTime`	`datetime`	Created On	-
Description:No description available
	`Day00`	`smallint`	Day of Month 1	-
Description:No description available
	`Day01`	`smallint`	Day of Month 2	-
Description:For ARStatementScheduleType.TwiceAMonth schedule type, indicates the second day of month, on which bi-monthly customer statements are generated.
	`DayOfWeek`	`int`	Day of Week	-
Description:For ARStatementScheduleType.Weekly schedule type, indicates the day of the week, on which weekly customer statements are generated.
	`Descr`	`nvarchar(60)`	Description	-
Description:The statement cycle description.
	`FinChargeApply`	`bit`	Apply Overdue Charges	-
Description:A boolean value indicating whether financial charges should be applied to customers belonging to the current statement cycle.
	`FinChargeID`Default Navigation	`nvarchar(10)`	Overdue Charge ID	ARFinCharge
Description:The reference to the overdue charge that should be calculated for customers belonging to the current statement cycle.
	`LastAgeDate`Obsolete	`datetime2`		-
Description:Obsolete field.
	`LastFinChrgDate`	`datetime2`	Last Finance Charge Date	-
Description:Indicates the date on which financial charges were last generated for the current statement cycle.
	`LastModifiedByID`Default Navigation	`uniqueidentifier`	Last Modified By	Users
Description:No description available
	`LastModifiedByScreenID`	`char(8)`		-
Description:No description available
	`LastModifiedDateTime`	`datetime`	Last Modified On	-
Description:No description available
	`LastStmtDate`	`datetime2`	Last Statement Date	-
Description:Indicates the date on which customer statements were last generated for the current statement cycle.
	`NextStmtDate`Nonexistent 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`	`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`	`bit`	Print 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`	`bit`	Require Overdue Charges Calculation Before Statement	-
Description:A boolean value indicating whether the system should require the overdue charges calculation before generating customer statements.
	`RequirePaymentApplication`	`bit`	Require 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.
	`Selected`Nonexistent in DB	`bit`	Selected	-
Description:A non-DB field indicating whether the current statement cycle has been selected for processing by a user.
	`tstamp`	`timestamp`		-
Description:No description available
	`UseFinPeriodForAging`	`bit`	Use 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.