APTranPostGLwithLines

PX.Objects.AP

52 of 52 fields

	Field Name	Type	Display Name	Foreign Key
	`DocType`	`varchar(MAX)`	Doc. Type	-
Description:The type of the document. The field can have one of the following values: - INV: Invoice - ACR: Credit Adjustment - ADR: Debit Adjustment - CHK: Payment - VCK: Voided Payment - PPM: Prepayment - REF: Refund - VRF: Voided Refund - QCK: Cash Purchase - VQC: Voided Cash Purchase
	`ID`	`int`		-
Description:No description available
	`LineNbr`	`int`	Line Nbr.	-
Description:No description available
	`Ord`	`smallint`		-
Description:The field is used in reports for joining and filtering purposes.
	`ProjectID`	`int`		-
Description:No description available
	`RefNbr`	`varchar(MAX)`	Ref. Nbr.	-
Description:Reference number of the document.
	`AccountID`Default Navigation	`int`	Account	-
Description:AccountID of corresponding APTranPostGL table record.
	`APRegisterDocDate`	`datetime2`	Date	-
Description:Date of the document.
	`APRegisterTranPeriodID`	`char(6)`		-
Description:Financial Period of the document.
	`BalanceAmt`	`decimal`		-
Description:No description available
	`BalanceSign`	`smallint`		-
Description:Sign of the Balance.
	`BranchID`Default Navigation	`int`	Branch	-
Description:Identifier of the Branch, to which the document belongs.
	`ClosedDate`	`datetime2`		-
Description:The date of the last application.
	`ClosedFinPeriodID`	`char(6)`		-
Description:The Financial Period, in which the document was closed. Corresponds to the FinPeriodID field.
	`ClosedTranPeriodID`	`char(6)`		-
Description:The Financial Period, in which the document was closed. Corresponds to the TranPeriodID field.
	`CreditAPAmt`Nonexistent in DB	`decimal`		-
Description:Credit AP amount in the base currency of the company.
	`CuryCreditAPAmt`Nonexistent in DB	`decimal`	Credit AP Amt.	-
Description:Credit AP amount.
	`CuryDebitAPAmt`Nonexistent in DB	`decimal`	Debit AP Amt.	-
Description:Debit AP amount.
	`CuryID`	`nvarchar(MAX)`		-
Description:Identifier of the Currency of this Currency Info object.
	`CuryInfoID`	`bigint`		CurrencyInfo
Description:Identifier of the CurrencyInfo object associated with the document.
	`CuryTurnDiscAmt`Nonexistent in DB	`decimal`		-
Description:No description available
	`CuryTurnWHTaxAmt`Nonexistent in DB	`decimal`		-
Description:No description available
	`DebitAPAmt`Nonexistent in DB	`decimal`		-
Description:Debit AP amount in the base currency of the company.
	`DocDate`	`datetime`	Date	-
Description:No description available
	`FinPeriodID`	`nvarchar(MAX)`	Application Period	-
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.
	`OpenDoc`	`bit`		-
Description:When set to "true" indicates that the document is open.
	`OrigBalanceAmt`	`decimal`		-
Description:No description available
	`OrigDocType`	`char(3)`	Orig. Doc. Type	-
Description:Type of the original (source) document.
	`OrigRefNbr`	`nvarchar(15)`	Orig. Ref. Nbr.	-
Description:Reference number of the original (source) document.
	`OrigRetainageAmt`	`decimal`	Original Retainage	-
Description:No description available
	`PaymentsByLinesAllowed`	`bit`		-
Description:Specifies (if set to "true") that the record has been created with activated FeaturesSet.PaymentsByLines feature and such document allow payments by lines.
	`Prebooked`	`bit`		-
Description:When set to "true" indicates that the document was prebooked.
	`PrintDocType`Nonexistent in DB	`nchar(3)`	Type	-
Description:Type of the document for displaying in reports. This field has the same set of possible internal values as the DocType field, but exposes different user-friendly values.
	`ReferenceID`	`int`		-
Description:Transaction Reference ID.
	`RefNoteID`	`uniqueidentifier`		-
Description:AP document transaction note id.
	`Released`	`bit`		-
Description:When set to "true" indicates that the document was released.
	`ReleasedRetainageAmt`	`decimal`		-
Description:No description available
	`RGOLAmt`	`decimal`		-
Description:Realized gains or losses amount.
	`SourceDocType`	`varchar(MAX)`	Source Doc. Type	-
Description:Source document doc type.
	`SourceRefNbr`	`varchar(MAX)`	Source Ref. Nbr.	-
Description:Source document ref number.
	`SubID`Default Navigation	`int`	Subaccount	-
Description:SubID Account ID of corresponding APTranPostGL table record.
	`TranClass`	`varchar(MAX)`		-
Description:Transaction class.
	`TranPeriodID`	`nvarchar(MAX)`		-
Description:No description available
	`TranRefNbr`	`varchar(MAX)`		-
Description:Transaction ref number.
	`TranType`	`nvarchar(MAX)`		-
Description:No description available
	`TurnDiscAmt`Nonexistent in DB	`decimal`		-
Description:No description available
	`TurnRGOLAmt`Nonexistent in DB	`decimal`		-
Description:No description available
	`TurnWHTaxAmt`Nonexistent in DB	`decimal`		-
Description:No description available
	`Type`	`varchar(MAX)`		-
Description:Transaction type.
	`VendorID`Default Navigation	`int`	Vendor	-
Description:No description available
	`Voided`	`bit`		-
Description:When set to "true" indicates that the document was voided. In this case VoidBatchNbr field will hold the number of the voiding Batch.