ARStatementDetailInfo

PX.Objects.AR

72 of 72 fields

	Field Name	Type	Display Name	Foreign Key
	`AdjdDocType`Nonexistent in DB	`nchar(3)`		-
Description:No description available
	`AdjgDocType`	`char(3)`		-
Description:No description available
	`AdjgRefNbr`Nonexistent in DB	`nvarchar(15)`		-
Description:No description available
	`DocType`	`char(3)`	Doc. Type	-
Description:No description available
	`RefNbr`	`nvarchar(15)`	Ref. Nbr.	-
Description:No description available
	`RefNoteID`	`uniqueidentifier`		-
Description:No description available
	`SourceDocType`	`varchar(MAX)`	Source Doc. Type	-
Description:No description available
	`SourceRefNbr`	`varchar(MAX)`	Source Ref. Nbr.	-
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.
	`AdjdBranchID`Default Navigation	`int`	Branch	Branch
Description:No description available
	`AdjdCuryID`Nonexistent in DB	`nvarchar(MAX)`		-
Description:No description available
	`AdjdCustomerID`Default Navigation	`int`	Customer	BAccount
Description:No description available
	`AdjdRefNbr`Nonexistent in DB	`nvarchar(15)`		-
Description:No description available
	`AdjgBranchID`Default Navigation	`int`	Branch	Branch
Description:No description available
	`AdjgCuryID`Nonexistent in DB	`nvarchar(MAX)`		-
Description:No description available
	`AdjgCustomerID`Default Navigation	`int`	Customer	BAccount
Description:No description available
	`AgeBalance00`	`decimal(19, 4)`	Age00 Balance	-
Description:The customer statement's balance of the age bucket 00 in the base currency. See ARStatementDetail.AgeBalance00
	`AgeBalance01`	`decimal(19, 4)`	Age01 Balance	-
Description:The customer statement's balance of the age bucket 01 in the base currency. See ARStatementDetail.AgeBalance01
	`AgeBalance02`	`decimal(19, 4)`	Age02 Balance	-
Description:The customer statement's balance of the age bucket 02 in the base currency. See ARStatementDetail.AgeBalance02
	`AgeBalance03`	`decimal(19, 4)`	Cury. Age03 Balance	-
Description:The customer statement's balance of the age bucket 03 in the base currency. See ARStatementDetail.AgeBalance03
	`AgeBalance04`	`decimal(19, 4)`	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
	`BalanceSign`Nonexistent in DB	`decimal`		-
Description:No description available
	`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. See ARStatementDetail.BegBalance
	`BranchID`Default Navigation	`int`	Branch	Branch
Description:No description available
	`CuryAgeBalance00`	`decimal(19, 4)`	Cury. Age00 Balance	-
Description:The customer statement's balance of the age bucket 00 in the foreign currency. See ARStatementDetail.CuryAgeBalance00
	`CuryAgeBalance01`	`decimal(19, 4)`	Cury. Age01 Balance	-
Description:The customer statement's balance of the age bucket 01 in the foreign currency. See ARStatementDetail.CuryAgeBalance01
	`CuryAgeBalance02`	`decimal(19, 4)`	Cury. Age02 Balance	-
Description:The customer statement's balance of the age bucket 02 in the foreign currency. See ARStatementDetail.CuryAgeBalance02
	`CuryAgeBalance03`	`decimal(19, 4)`	Cury. Age03 Balance	-
Description:The customer statement's balance of the age bucket 03 in the foreign currency. See ARStatementDetail.CuryAgeBalance03
	`CuryAgeBalance04`	`decimal(19, 4)`	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(19, 4)`	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(19, 4)`	Cury. Doc. Balance	-
Description:Indicates the balance, in document currency, that the document has on the statement date.
	`CuryID`	`nvarchar(5)`		ARStatement
Description:No description available
	`CuryInfoID`	`bigint`		CurrencyInfo
Description:No description available
	`CuryInitDocBal`	`decimal(19, 4)`		-
Description:The entered in migration mode balance of the document. Given in the currency of the document.
	`CuryOrigDocAmt`	`decimal(19, 4)`	Amount	-
Description:No description available
	`CuryTurnDiscAmt`	`decimal`		-
Description:No description available
	`CuryTurnWOAmt`	`decimal`		-
Description:No description available
	`CustomerID`Default Navigation	`int`	Customer	Customer
Description:No description available
	`DocBalance`	`decimal(19, 4)`	Doc. Balance	-
Description:Indicates the balance, in base currency, that the document has on the statement date.
	`DocDate`	`datetime2`	Date	-
Description:No description available
	`DocDesc`	`nvarchar(512)`	Description	-
Description:No description available
	`DocStatementDate`	`datetime2`		-
Description:No description available
	`DueDate`	`datetime2`	Due Date	-
Description:No description available
	`ExtRefNbr`	`nvarchar(40)`	Payment Ref.	-
Description:No description available
	`ID`	`int`		-
Description:No description available
	`InitDocBal`	`decimal(19, 4)`		-
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
	`IsDocumentPresent`	`bit`		-
Description:No description available
	`IsInterBranchApplication`Nonexistent in DB	`bit`		-
Description:If set to "true", indicates that the parent application affects documents that originate in different branches.
	`IsInterCurrencyApplication`Nonexistent in DB	`bit`		-
Description:If set to "true", indicates that the parent application affects documents that have different currencies.
	`IsInterCustomerApplication`Nonexistent in DB	`bit`		-
Description:If set to "true", indicates that the parent application affects documents that belong to different customers.
	`IsInterStatementApplication`Nonexistent in DB	`bit`		-
Description:No description available
	`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.
	`IsOrphanApplication`Nonexistent in DB	`bit`		-
Description:No description available
	`IsSelfVoidingVoidApplication`	`bit`		-
Description:No description available
	`IsSourceDocumentPresent`	`bit`		-
Description:No description available
	`OrigDocAmt`	`decimal(19, 4)`		-
Description:No description available
	`Payable`Nonexistent in DB	`bit`		-
Description:No description available
	`PrintDocType`Nonexistent in DB	`nchar(3)`	Type	-
Description:No description available
	`RGOLAmt`	`decimal`		-
Description:No description available
	`SignBalanceDelta`Nonexistent in DB	`decimal`		-
Description:No description available
	`SourceBranchID`Default Navigation	`int`	Branch	-
Description:No description available
	`SourceCuryID`	`nvarchar(5)`		-
Description:No description available
	`SourceCustomerID`Default Navigation	`int`	Customer	-
Description:No description available
	`StatementType`	`char(1)`	Statement Type	-
Description:The type of the customer statement. See ARStatementDetail.StatementType
	`TranType`	`varchar(MAX)`		-
Description:No description available
	`TurnDiscAmt`	`decimal`		-
Description:No description available
	`TurnWOAmt`	`decimal`		-
Description:No description available
	`Type`	`varchar(MAX)`		-
Description:No description available