GLTran

PX.Objects.GL

View API Entity: JournalTransaction/entity/Default/24.200.001/JournalTransaction

77 of 77 fields

	Field Name	Type	Display Name	Foreign Key
	`BatchNbr` API	`nvarchar(15)`	Batch Number	Batch
Description:Key field. The number of the Batch, to which the transaction belongs. Corresponds to the Batch.BatchNbr field.
	`LineNbr`	`int`	Line Nbr.	-
Description:Key field. Auto-generated. The number of the transaction in the Batch. Note that the sequence of line numbers of the transactions belonging to a single batch may include gaps.
	`Module` API	`char(2)`	Module	-
Description:Key field. The code of the module, to which the transaction belongs. Defaults to the module of the parent batch. Possible values are: "GL", "AP", "AR", "CM", "CA", "IN", "DR", "FA", "PM", "TX", "SO", "PO".
	`AccountID`Default Navigation	`int`	Account	Account
Description:Identifier of the Account of the transaction. Corresponds to the Account.AccountID field.
	`AccountRequireUnits`Nonexistent in DB	`bit`		-
Description:Indicates whether the account associated with the transaction requires Units of Measure to be specified.
	`BranchID` API Default Navigation	`int`	Branch	Branch
Description:Identifier of the Branch, to which the transaction belongs. Defaults to the branch of the parent batch. Corresponds to the Branch.BranchID field.
	`CATranID`	`bigint`		CATran
Description:Identifier of the Cash Transaction associated with this transaction. Corresponds to the CATran.TranID field.
	`CostCodeID`Default Navigation	`int`	Cost Code	PMCostCode
Description:No description available
	`CreatedByID`Default Navigation	`uniqueidentifier`	Created By	Users
Description:No description available
	`CreatedByScreenID`	`char(8)`		-
Description:No description available
	`CreatedDateTime` API	`datetime`		-
Description:No description available
	`CreditAmt`	`decimal(19, 4)`		-
Description:The credit amount of the transaction. Given in the base currency of the company. See also the CuryCreditAmt field.
	`CuryCreditAmt`	`decimal(19, 4)`	Credit Amount	-
Description:The credit amount of the transaction. Given in the currency of the batch. See also the CreditAmt field.
	`CuryDebitAmt`	`decimal(19, 4)`	Debit Amount	-
Description:The debit amount of the transaction. Given in the currency of the batch. See also the DebitAmt field.
	`CuryInfoID`	`bigint`		CurrencyInfo
Description:Identifier of the CurrencyInfo object associated with the transaction. Auto-generated. Corresponds to the CurrencyInfo.CurrencyInfoID field.
	`CuryReclassRemainingAmt`	`decimal(19, 4)`	Remaining Reclass. Amount	-
Description:No description available
	`DebitAmt`	`decimal(19, 4)`		-
Description:The debit amount of the transaction. Given in the base currency of the company. See also the CuryDebitAmt field.
	`FinPeriodID`	`char(6)`	Period ID	-
Description:No description available
	`IncludedInReclassHistory`Nonexistent in DB	`bit`	Included in Reclass. History	-
Description:Used for storing state of "Reclassification History" button in GL301000 and GL404000
	`InventoryID`Default Navigation	`int`	Inventory ID	InventoryItem
Description:Identifier of the Inventory Item, associated with the transaction. Corresponds to the InventoryItem.InventoryID field.
	`IsInterCompany`	`bit`		-
Description:When "true", indicates that the transaction is an inter-branch transaction. Defaults to "false".
	`IsNonPM`	`bit`		-
Description:No description available
	`IsReclassReverse`	`bit`		-
Description:This field distinguishes reversed transaction in the reclassification pair from transaction on destination account. When "true", indicates that the transaction is a reversed of source transaction. Defaults to "false".
	`LastModifiedByID`Default Navigation	`uniqueidentifier`	Last Modified By	Users
Description:No description available
	`LastModifiedByScreenID`	`char(8)`		-
Description:No description available
	`LastModifiedDateTime` API	`datetime`		-
Description:No description available
	`LedgerBalanceType`Nonexistent in DB	`nchar(1)`		-
Description:The type of balance of the Ledger, associated with the transaction. Corresponds to the Ledger.BalanceType field.
	`LedgerID` API	`int`		Ledger
Description:Identifier of the Ledger, to which the transaction belongs. If the Balance Type of the ledger of the batch is Actual (""A""), defaults to the ledger of the branch. Otherwise defaults to the ledger of the batch. Corresponds to the Ledger.LedgerID field.
	`NextPostYear`Nonexistent in DB	`nchar(6)`		-
Description:The read-only field providing the year, following the PostYear.
	`NextTranYear`Nonexistent in DB	`nchar(6)`		-
Description:The read-only field providing the year, following the TranYear.
	`NonBillable`	`bit`	Non Billable	-
Description:When set to "true", indicates that the transaction is non-billable in the Project This means that when releasing the batch the system will set the PMTran.Billable field of the project transaction generated from this transaction to "false". This field is relevant only if the Projects module has been activated and integrated with the General Ledger module. Defaults to "false".
	`NoteID`	`uniqueidentifier`		-
Description:Identifier of the Note object, associated with the document. Corresponds to the Note.NoteID field.
	`OrigAccountID`Default Navigation	`int`	Original Account	Account
Description:Identifier of the Account associated with the original document. This field is populated for the transactions updating the account, which is different from the account of the original document. For example, if upon release of an Accounts Receivable document an RGOL account must be updated, the system will generate a transaction with AccountID set to the RGOL account and OrigAccountID set to the Accounts Receivable account associated with the document being released. Corresponds to the Account.AccountID field.
	`OrigBatchNbr`	`nvarchar(15)`	Orig. Batch Nbr.	-
Description:The number of the original batch (e.g. the one reversed by the parent batch of this transaction). Corresponds to the Batch.BatchNbr field.
	`OrigLineNbr`	`int`	Orig. Line Nbr.	GLTran
Description:The number of the corresponding transaction in the original batch (e.g. the one reversed by the parent batch of this transaction). Corresponds to the GLTran.LineNbr.
	`OrigModule`	`char(2)`	Orig. Module	-
Description:The module, to which the original batch (e.g. the one reversed by the parent batch of this transaction) belongs. Corresponds to the Batch.Module field.
	`OrigPMTranID`	`bigint`		-
Description:Identifier of the Project Transaction associated with the original transaction (e.g. the transaction reversed by this one). Corresponds to the PMTran.TranID field.
	`OrigSubID`Default Navigation	`int`	Original Subaccount	Sub
Description:Identifier of the Subaccount associated with the original document. For more information see the OrigAccountID field. Corresponds to the Sub.SubID field.
	`PMTranID`	`bigint`	PM Tran.	-
Description:Identifier of the Project Transaction associated with this transaction. Corresponds to the PMTran.TranID field.
	`Posted`	`bit`		-
Description:Indicates whether the transaction has been posted.
	`PostYear`Nonexistent in DB	`nchar(4)`		-
Description:The read-only year, to which the transaction is posted. The value of this field is determined from the FinPeriodID.
	`ProjectID`Default Navigation	`int`	Project	PMProject
Description:Identifier of the Project associated with the transaction, or the non-project code indicating that the transaction is not related to any particular project. Corresponds to the PMProject.ProjectID field.
	`Qty`	`decimal(25, 6)`	Quantity	-
Description:The quantity of the transaction.
	`ReclassBatchModule`	`char(2)`	Reclass. Batch Module	-
Description:The module of the Batch, by which the transaction has been reclassified.
	`ReclassBatchNbr`	`nvarchar(15)`	Reclass. Batch Number	-
Description:The number of the Batch, by which the transaction has been reclassified.
	`ReclassificationProhibited`	`bit`		-
Description:Indicates that the transaction can't be reclassified.
	`Reclassified`	`bit`		-
Description:Indicates that the transaction has been reclassified. It is set on Reclass Batch Releasing. This fact is used.
	`ReclassOrigTranDate`	`datetime2`		-
Description:According to the GLTran.tranDate field of the original reclassified transaction. This field is filling on the ReclassifyTransactionsProcessor.ProcessTransForReclassification Reclassify Transactions (GL506000) screen.
	`ReclassReleasedCount`	`int`		-
Description:The count of reclassifying transactions.
	`ReclassRemainingAmt`	`decimal(19, 4)`		-
Description:No description available
	`ReclassSeqNbr`	`int`	Reclass. Sequence Nbr.	-
Description:Sequence number of reclassification pair in reclassification chain.
	`ReclassSourceTranBatchNbr`	`nvarchar(15)`		-
Description:No description available
	`ReclassSourceTranLineNbr`	`int`		-
Description:No description available
	`ReclassSourceTranModule`	`char(2)`		-
Description:No description available
	`ReclassTotalCount`	`int`		-
Description:The count of reclassifying transactions.
	`ReclassType`	`char(1)`	Reclassification Type	-
Description:No description available
	`ReferenceID`Default Navigation	`int`	Customer/Vendor	BAccount
Description:Identifier of the Customer or Vendor associated with the transaction. This field is populated when a document is released in Accounts Receivable or Accounts Payable module. Corresponds to the Customer.BAccountID and Vendor.BAccountID fields.
	`RefNbr`	`nvarchar(15)`	Ref. Number	-
Description:The reference number of the transaction. Defaults to the reference number of the batch. Can be overriden by user.
	`Released`	`bit`		-
Description:Indicates whether the transaction has been released.
	`Selected`Nonexistent in DB	`bit`	Selected	-
Description:Used for selection on screens.
	`SkipNormalizeAmounts`Nonexistent in DB	`bit`		-
Description:Turn off amount normalization when transactions are posted to GL
	`SubID`Default Navigation	`int`	Subaccount	Sub
Description:Identifier of the Subaccount of the transaction. Corresponds to the Sub.SubID field.
	`SummPost`	`bit`		-
Description:When set to "true", indicates that the system must summarize the transaction with other ones when posting. In this case all transactions being posted are grouped by Account and Subaccount. Then, the amounts are summarized and a single transaction is created for each group. Defaults to "false".
	`TaskID`Default Navigation	`int`	Project Task	PMTask
Description:Identifier of the Task associated with the transaction. The field is relevant only if the Projects module has been activated. Corresponds to the PMTask.TaskID field.
	`TaxCategoryID`Default Navigation	`nvarchar(15)`	Tax Category	TaxCategory
Description:No description available
	`TaxID`Default Navigation	`nvarchar(60)`	Tax ID	-
Description:No description available
	`TranClass`	`char(1)`		-
Description:Reserved for internal use. The class of the document or transaction defined by the line. This field affects posting of documents and transactions to GL.
	`TranDate`	`datetime2`	Transaction Date	-
Description:The date of the transaction. Defaults to the date of the parent batch.
	`TranDesc`	`nvarchar(512)`	Transaction Description	-
Description:The description of the transaction.
	`TranID`	`int`		-
Description:A unique identifier of the transaction reserved for internal use.
	`TranLineNbr`	`int`		-
Description:Reserved for internal use. This field is populated on release of a document in another module with the number of the corresponding line in that document. This field is not populated when SummPost is on and in some other cases.
	`TranPeriodID`	`char(6)`	Master Period ID	-
Description:Identifier of the Financial Period, to which the transaction belongs. Is equal to the Batch.TranPeriodID of the parent batch. For the explanation of the difference between this field and the FinPeriodID see the descriptions of the corresponding fields in the Batch class.
	`TranType`	`char(3)`		-
Description:The type of the original document or transaction. This field is populated when a document is released in another module, such as Accounts Receivable or Accounts Payable. For example, when an ARInvoice is released, the system will set this field for the resulting transactions to the document's DocType.
	`TranYear`Nonexistent in DB	`nchar(4)`		-
Description:The read-only year, to which the transaction is posted. The value of this field is determined from the TranPeriodID.
	`tstamp`	`timestamp`		-
Description:No description available
	`UOM`Default Navigation	`nvarchar(6)`	UOM	INUnit
Description:The code of the Unit of Measure for the qunatity of the transaction. Corresponds to the INUnit.fromUnit field.
	`ZeroPost`Nonexistent in DB	`bit`		-
Description:When set to "true", indicates that the system must post the transaction even if its amounts are equal to zero.