ARStatementDetail

PX.Objects.AR

24 of 24 fields

	Field Name	Type	Display Name	Foreign Key
	`CuryID`Default Navigation	`nvarchar(5)`	Currency ID	ARStatement
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:No description available
	`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.
	`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`	`datetime2`	Statement Date	-
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.
	`AgeBalance00`	`decimal(19, 4)`	Age00 Balance	-
Description:The customer statement's balance of the age bucket 00 in the base currency.
	`AgeBalance01`	`decimal(19, 4)`	Age01 Balance	-
Description:The customer statement's balance of the age bucket 01 in the base currency.
	`AgeBalance02`	`decimal(19, 4)`	Age02 Balance	-
Description:The customer statement's balance of the age bucket 02 in the base currency.
	`AgeBalance03`	`decimal(19, 4)`	Cury. Age03 Balance	-
Description:The customer statement's balance of the age bucket 03 in the base currency.
	`AgeBalance04`	`decimal(19, 4)`	Age04 Balance	-
Description:The customer statement's balance of the age bucket 04 in the base currency.
	`BegBalance`	`decimal(19, 4)`	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(19, 4)`	Cury. Age00 Balance	-
Description:The customer statement's balance of the age bucket 00 in the foreign currency.
	`CuryAgeBalance01`	`decimal(19, 4)`	Cury. Age01 Balance	-
Description:The customer statement's balance of the age bucket 01 in the foreign currency.
	`CuryAgeBalance02`	`decimal(19, 4)`	Cury. Age02 Balance	-
Description:The customer statement's balance of the age bucket 03 in the foreign currency.
	`CuryAgeBalance03`	`decimal(19, 4)`	Cury. Age03 Balance	-
Description:The customer statement's balance of the age bucket 03 in the foreign currency.
	`CuryAgeBalance04`	`decimal(19, 4)`	Cury. Age04 Balance	-
Description:The customer statement's balance of the age bucket 04 in the foreign currency.
	`CuryBegBalance`	`decimal(19, 4)`	Curr. Beg. Balance	-
Description:The beginning balance of the customer statement in the foreign currency. Only for the Balance Brought Forvard type.
	`CuryDocBalance`	`decimal(19, 4)`	Cury. Doc. Balance	-
Description:Indicates the balance, in document currency, that the document has on the statement date.
	`DocBalance`	`decimal(19, 4)`	Doc. Balance	-
Description:Indicates the balance, in base currency, that the document has on the statement date.
	`IsOpen`	`bit`		-
Description:If set to "true", indicates that the document is open on the statement date.
	`StatementType`	`char(1)`	Statement Type	-
Description:The type of the customer statement.
	`TranPostID`	`int`		-
Description:No description available