AR
ARStatement
The primary entity representing a customer statement in the system. It contains general statement information (including aged customer due and overdue balances on the statement date) and serves as a master entity for all document details/> that are displayed in the statement.
| Field Name | Type | Display Name | Foreign Key | |
|---|---|---|---|---|
AgeBalance00 | decimal | Age00 Balance | - | |
Description:No description available | ||||
AgeBalance01 | decimal | Age01 Balance | - | |
Description:No description available | ||||
AgeBalance02 | decimal | Age02 Balance | - | |
Description:No description available | ||||
AgeBalance03 | decimal | Cury. Age03 Balance | - | |
Description:No description available | ||||
AgeBalance04 | decimal | Age04 Balance | - | |
Description:No description available | ||||
AgeBucket01Description | nvarchar(60) | Age Message 1 | - | |
Description:The description of the first aging period, which incorporates documents that are from 1 to AgeDays01 days past due. | ||||
AgeBucket02Description | nvarchar(60) | Age Message 2 | - | |
Description:The description of the second aging period, which incorporates documents that are from AgeDays01 + 1 to AgeDays02 days past due. | ||||
AgeBucket03Description | nvarchar(60) | Age Message 3 | - | |
Description:The description of the third aging period that incorporates documents that are from AgeDays02 + 1 to AgeDays03 days past due. | ||||
AgeBucket04Description | nvarchar(60) | Age Message 4 | - | |
Description:The description of the last aging period that incorporates documents that are over AgeDays03 days past due. | ||||
AgeBucketCurrentDescription | nvarchar(60) | Age Message 0 | - | |
Description:The description of the current aging period, which incorporates documents that are no more than AgeDays00 days past due. | ||||
AgeDays00 | smallint | - | ||
Description:No description available | ||||
AgeDays01 | smallint | - | ||
Description:No description available | ||||
AgeDays02 | smallint | - | ||
Description:No description available | ||||
AgeDays03 | smallint | - | ||
Description:No description available | ||||
AgeDays04Obsolete | smallint | - | ||
Description:No description available | ||||
BegBalance | decimal | Beg. Balance | - | |
Description:No description available | ||||
BranchID | int | Branch | Branch | |
Description:No description available | ||||
CreatedByID | uniqueidentifier | Created By | Users | |
Description:No description available | ||||
CreatedByScreenID | char(8) | - | ||
Description:No description available | ||||
CreatedDateTime | datetime | - | ||
Description:No description available | ||||
CuryAgeBalance00 | decimal | Cury. Age00 Balance | - | |
Description:No description available | ||||
CuryAgeBalance01 | decimal | Cury. Age01 Balance | - | |
Description:No description available | ||||
CuryAgeBalance02 | decimal | Cury. Age02 Balance | - | |
Description:No description available | ||||
CuryAgeBalance03 | decimal | Cury. Age03 Balance | - | |
Description:No description available | ||||
CuryAgeBalance04 | decimal | Cury. Age04 Balance | - | |
Description:No description available | ||||
CuryBegBalance | decimal | Curr. Beg. Balance | - | |
Description:No description available | ||||
CuryEndBalance | decimal | - | ||
Description:No description available | ||||
CuryID | nvarchar(5) | Currency ID | Currency | |
Description:No description available | ||||
CustomerID | int | Customer | Customer | |
Description:No description available | ||||
DontEmail | bit | Don't Email | - | |
Description:No description available | ||||
DontPrint | bit | Don't Print | - | |
Description:No description available | ||||
Emailed | bit | Emailed | - | |
Description:No description available | ||||
EndBalance | decimal | - | ||
Description:No description available | ||||
IsParentCustomerStatementNonexistent in DB | bool | - | ||
Description:No description available | ||||
LastModifiedByID | uniqueidentifier | Last Modified By | Users | |
Description:No description available | ||||
LastModifiedByScreenID | char(8) | - | ||
Description:No description available | ||||
LastModifiedDateTime | datetime | - | ||
Description:No description available | ||||
LocaleName | nvarchar(10) | Locale | - | |
Description:The name of the locale in which the statement has been generated. | ||||
NoteID | uniqueidentifier | - | ||
Description:No description available | ||||
OnDemand | bit | On-Demand Statement | - | |
Description:Gets or sets a value indicating whether the current customer statement has been generated on demand as opposed to by schedule. | ||||
PrevEmailedCnt | smallint | Previously Emailed Count | - | |
Description:No description available | ||||
PrevPrintedCnt | smallint | Previously Printed Count | - | |
Description:No description available | ||||
PrevStatementDate | datetime | Last Statement Date | - | |
Description:No description available | ||||
Printed | bit | Printed | - | |
Description:No description available | ||||
ProcessedNonexistent in DB | bool? | - | ||
Description:No description available | ||||
StatementCustomerID | int | Customer | ||
Description:No description available | ||||
StatementCycleId | nvarchar(10) | Statement Cycle ID | ARStatementCycle | |
Description:No description available | ||||
StatementDate | datetime | Statement Date | - | |
Description:No description available | ||||
StatementType | char(1) | Statement Type | - | |
Description:No description available | ||||
tstamp | timestamp | - | ||
Description:No description available | ||||