AR
ARStatementDetailInfo
A projection that is used in the AR Statement report. Cash sales and cash returns are excluded to prevent them from appearing in the Statement Report.
| Field Name | Type | Display Name | Foreign Key | |
|---|---|---|---|---|
AdjdBranchID | int | Branch | - | |
Description:No description available | ||||
AdjdCuryIDNonexistent in DB | string | - | ||
Description:No description available | ||||
AdjdCustomerID | int | Customer | BAccountR | |
Description:No description available | ||||
AdjdDocTypeNonexistent in DB | string | - | ||
Description:No description available | ||||
AdjdRefNbrNonexistent in DB | string | - | ||
Description:No description available | ||||
AdjgBranchID | int | Branch | - | |
Description:No description available | ||||
AdjgCuryIDNonexistent in DB | string | - | ||
Description:No description available | ||||
AdjgCustomerID | int | Customer | BAccountR | |
Description:No description available | ||||
AdjgDocType | char(3) | - | ||
Description:No description available | ||||
AdjgRefNbrNonexistent in DB | string | - | ||
Description:No description available | ||||
AgeBalance00 | decimal | Age00 Balance | - | |
Description:The customer statement's balance of the age bucket 00 in the base currency. See ARStatementDetail.AgeBalance00 | ||||
AgeBalance01 | decimal | Age01 Balance | - | |
Description:The customer statement's balance of the age bucket 01 in the base currency. See ARStatementDetail.AgeBalance01 | ||||
AgeBalance02 | decimal | Age02 Balance | - | |
Description:The customer statement's balance of the age bucket 02 in the base currency. See ARStatementDetail.AgeBalance02 | ||||
AgeBalance03 | decimal | Cury. Age03 Balance | - | |
Description:The customer statement's balance of the age bucket 03 in the base currency. See ARStatementDetail.AgeBalance03 | ||||
AgeBalance04 | decimal | Age04 Balance | - | |
Description:The customer statement's balance of the age bucket 04 in the base currency. See ARStatementDetail.AgeBalance04 | ||||
BalanceAmt | decimal | - | ||
Description:No description available | ||||
BalanceSignNonexistent in DB | decimal? | - | ||
Description:No description available | ||||
BegBalance | decimal | Beg. Balance | - | |
Description:The beginning balance of the customer statement in the base currency. Only for the Balance Brought Forvard type. See ARStatementDetail.BegBalance | ||||
BranchID | int | Branch | Branch | |
Description:No description available | ||||
CuryAgeBalance00 | decimal | Cury. Age00 Balance | - | |
Description:The customer statement's balance of the age bucket 00 in the foreign currency. See ARStatementDetail.CuryAgeBalance00 | ||||
CuryAgeBalance01 | decimal | Cury. Age01 Balance | - | |
Description:The customer statement's balance of the age bucket 01 in the foreign currency. See ARStatementDetail.CuryAgeBalance01 | ||||
CuryAgeBalance02 | decimal | Cury. Age02 Balance | - | |
Description:The customer statement's balance of the age bucket 02 in the foreign currency. See ARStatementDetail.CuryAgeBalance02 | ||||
CuryAgeBalance03 | decimal | Cury. Age03 Balance | - | |
Description:The customer statement's balance of the age bucket 03 in the foreign currency. See ARStatementDetail.CuryAgeBalance03 | ||||
CuryAgeBalance04 | decimal | Cury. Age04 Balance | - | |
Description:The customer statement's balance of the age bucket 04 in the foreign currency. See ARStatementDetail.CuryAgeBalance04 | ||||
CuryBalanceAmt | decimal | - | ||
Description:No description available | ||||
CuryBegBalance | decimal | Curr. Beg. Balance | - | |
Description:The beginning balance of the customer statement in the foreign currency. Only for the Balance Brought Forvard type. See ARStatementDetail.CuryBegBalance | ||||
CuryDocBalance | decimal | Cury. Doc. Balance | - | |
Description:Indicates the balance, in document currency, that the document has on the statement date. | ||||
CuryDocBalanceSignedNonexistent in DB | decimal? | Amount Due | - | |
Description:No description available | ||||
CuryID | nvarchar(5) | Currency | ||
Description:No description available | ||||
CuryInfoID | bigint | CurrencyInfo | ||
Description:No description available | ||||
CuryInitDocBal | decimal | - | ||
Description:The entered in migration mode balance of the document. Given in the currency of the document. | ||||
CuryInitDocBalSignedNonexistent in DB | decimal? | - | ||
Description:The entered in migration mode balance of the document. Given in the currency of the document. | ||||
CuryOrigDocAmt | decimal | Amount | - | |
Description:No description available | ||||
CuryOrigDocAmtSignedNonexistent in DB | decimal? | Origin. Amt | - | |
Description:No description available | ||||
CuryTurnDiscAmt | decimal | - | ||
Description:No description available | ||||
CuryTurnWOAmt | decimal | - | ||
Description:No description available | ||||
CustomerID | int | Customer | Customer | |
Description:No description available | ||||
DocBalance | decimal | Doc. Balance | - | |
Description:Indicates the balance, in base currency, that the document has on the statement date. | ||||
DocBalanceSignedNonexistent in DB | decimal? | - | ||
Description:No description available | ||||
DocDate | datetime | Date | - | |
Description:No description available | ||||
DocDesc | nvarchar(60) | Description | - | |
Description:No description available | ||||
DocExtRefNbrNonexistent in DB | string | Ext. Ref.# | - | |
Description:No description available | ||||
DocStatementDate | datetime | - | ||
Description:No description available | ||||
DocType | nvarchar | Doc. Type | - | |
Description:No description available | ||||
DueDate | datetime | Due Date | - | |
Description:No description available | ||||
ExtRefNbr | nvarchar(40) | Payment Ref. | - | |
Description:No description available | ||||
ID | int | - | ||
Description:No description available | ||||
InitDocBal | decimal | - | ||
Description:The entered in migration mode balance of the document. Given in the base currency of the company. | ||||
InitDocBalSignedNonexistent in DB | decimal? | - | ||
Description:The entered in migration mode balance of the document. Given in the base currency of the company. | ||||
InvoiceNbr | nvarchar(40) | Customer Ref. Nbr. | - | |
Description:No description available | ||||
IsDocumentPresentNonexistent in DB | bool? | - | ||
Description:No description available | ||||
IsInterBranchApplicationNonexistent in DB | bool? | - | ||
Description:If set to "true", indicates that the parent application affects documents that originate in different branches. | ||||
IsInterCurrencyApplicationNonexistent in DB | bool? | - | ||
Description:If set to "true", indicates that the parent application affects documents that have different currencies. | ||||
IsInterCustomerApplicationNonexistent in DB | bool? | - | ||
Description:If set to "true", indicates that the parent application affects documents that belong to different customers. | ||||
IsInterStatementApplicationNonexistent in DB | bool? | - | ||
Description:If set to "true", indicates that the parent application affects two Customer Statements at once. If and only if this flag is set to "true", the ending balance of the parent statement will account for the application amount. | ||||
IsMigratedRecord | bit | - | ||
Description:Specifies (if set to "true") that the record has been created in migration mode without affecting GL module. | ||||
IsOpen | bit | - | ||
Description:If set to "true", indicates that the document is open on the statement date. | ||||
IsOrphanApplicationNonexistent in DB | bool? | - | ||
Description:No description available | ||||
IsSelfVoidingVoidApplicationNonexistent in DB | bool? | - | ||
Description:No description available | ||||
IsSourceDocumentPresentNonexistent in DB | bool? | - | ||
Description:No description available | ||||
OrigDocAmt | decimal | - | ||
Description:No description available | ||||
OrigDocAmtSignedNonexistent in DB | decimal? | - | ||
Description:No description available | ||||
PayableNonexistent in DB | bool? | - | ||
Description:No description available | ||||
PrintDocTypeNonexistent in DB | string | Type | - | |
Description:No description available | ||||
RGOLAmt | decimal | - | ||
Description:No description available | ||||
RefNbr | nvarchar | Ref. Nbr. | - | |
Description:No description available | ||||
RefNoteID | uniqueidentifier | - | ||
Description:No description available | ||||
SignBalanceDeltaNonexistent in DB | decimal? | - | ||
Description:No description available | ||||
SourceBranchID | int | Branch | - | |
Description:No description available | ||||
SourceCuryID | nvarchar(5) | - | ||
Description:No description available | ||||
SourceCustomerID | int | Customer | BAccountR | |
Description:No description available | ||||
SourceDocType | nvarchar | Source Doc. Type | - | |
Description:No description available | ||||
SourceRefNbr | nvarchar | Source Ref. Nbr. | - | |
Description:No description available | ||||
StatementDate | datetime | Statement Date | ARStatement | |
Description:The date of the Customer Statement, to which the detail belongs. This field is part of the compound key of the statement detail, and part of the foreign key referencing the Customer Statement record. Corresponds to the ARStatement.StatementDate field. | ||||
StatementType | char(1) | Statement Type | - | |
Description:The type of the customer statement. See ARStatementDetail.StatementType | ||||
TranType | nvarchar | - | ||
Description:No description available | ||||
TurnDiscAmt | decimal | - | ||
Description:No description available | ||||
TurnWOAmt | decimal | - | ||
Description:No description available | ||||
Type | nvarchar | - | ||
Description:No description available | ||||