ARStatementDetail

PX.Objects.ARRelease 2025.2

A document that has been included in a customer statement. The entities of this type are created on the Prepare Statements (AR503000) processing form and can be seen on the Customer Statement (AR641500) and Customer Statement MC (AR642000) reports.

Select a row for its description 24 of 24 fields

	Field Name	Type	Display Name	Foreign Key
	`AgeBalance00`	`decimal`	Age00 Balance	-
Description:The customer statement's balance of the age bucket 00 in the base currency.
	`AgeBalance01`	`decimal`	Age01 Balance	-
Description:The customer statement's balance of the age bucket 01 in the base currency.
	`AgeBalance02`	`decimal`	Age02 Balance	-
Description:The customer statement's balance of the age bucket 02 in the base currency.
	`AgeBalance03`	`decimal`	Cury. Age03 Balance	-
Description:The customer statement's balance of the age bucket 03 in the base currency.
	`AgeBalance04`	`decimal`	Age04 Balance	-
Description:The customer statement's balance of the age bucket 04 in the base currency.
	`BegBalance`	`decimal`	Beg. Balance	-
Description:The beginning balance of the customer statement in the base currency. Only for the Balance Brought Forvard type.
	`BranchID`Default Navigation	`int`	Branch	Branch
Description:The integer identifier of the Branch 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.BranchID field.
	`CuryAgeBalance00`	`decimal`	Cury. Age00 Balance	-
Description:The customer statement's balance of the age bucket 00 in the foreign currency.
	`CuryAgeBalance01`	`decimal`	Cury. Age01 Balance	-
Description:The customer statement's balance of the age bucket 01 in the foreign currency.
	`CuryAgeBalance02`	`decimal`	Cury. Age02 Balance	-
Description:The customer statement's balance of the age bucket 03 in the foreign currency.
	`CuryAgeBalance03`	`decimal`	Cury. Age03 Balance	-
Description:The customer statement's balance of the age bucket 03 in the foreign currency.
	`CuryAgeBalance04`	`decimal`	Cury. Age04 Balance	-
Description:The customer statement's balance of the age bucket 04 in the foreign currency.
	`CuryBegBalance`	`decimal`	Curr. Beg. Balance	-
Description:The beginning balance of the customer statement in the foreign currency. Only for the Balance Brought Forvard type.
	`CuryDocBalance`	`decimal`	Cury. Doc. Balance	-
Description:Indicates the balance, in document currency, that the document has on the statement date.
	`CuryID`Default Navigation	`nvarchar(5)`	Currency ID	Currency
Description:The currency 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.
	`CustomerID`	`int`	Customer ID	Customer
Description:The integer identifier of the Customer 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.CustomerID field.
	`DocBalance`	`decimal`	Doc. Balance	-
Description:Indicates the balance, in base currency, that the document has on the statement date.
	`DocType`	`char(3)`	DocType	-
Description:The type of the document, for which the statement detail is created. This field is part of the compound key of the statement detail, and part of the foreign key referencing the ARRegister document. Corresponds to the ARRegister.DocType field.
	`IsOpen`	`bit`		-
Description:If set to "true", indicates that the document is open on the statement date.
	`RefNbr`	`nvarchar(15)`	Ref. Nbr.	-
Description:The reference number of the document, for which the statement detail is created. This field is part of the compound key of the statement detail, and part of the foreign key referencing the ARRegister document. Corresponds to the ARRegister.RefNbr field.
	`RefNoteID`	`uniqueidentifier`		-
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.
	`TranPostID`	`int`		-
Description:No description available