GLTranDoc

PX.Objects.GL

91 of 91 fields

	Field Name	Type	Display Name	Foreign Key
	`BatchNbr`	`nvarchar(15)`	Batch Number	GLDocBatch
Description:Key field. Auto-generated unique number of the parent document batch. The number is obtained from the GLDocBatch.BatchNbr field of the parent batch.
	`LineNbr`	`int`	Line Nbr.	-
Description:Key field. The number of the document/transaction line inside the document batch. Note that the sequence of line numbers of the transactions belonging to a single document may include gaps.
	`Module`	`char(2)`	Batch Module	-
Description:Key field. The code of the module, to which the parent batch belongs. Defaults to the value of the GLDocBatch.Module field of the parent batch. This field is not supposed to be changed directly. Possible values are: "GL", "AP", "AR", "CM", "CA", "IN", "DR", "FA", "PM", "TX", "SO", "PO".
	`ApplAmt`	`decimal(19, 4)`		-
Description:The amount of the application. Given in the base currency of the company. For more infor see CuryApplAmt.
	`ApplCount`	`int`		-
Description:The number of applications specified for the document. The applications are represented by APAdjust or ARAdjust records.
	`BAccountID`Default Navigation	`int`	Customer/Vendor	BAccount
Description:Identifier of the Vendor or Customer, for whom the system will create a document from this line. The field corresponds to the BAccount.BAccountID field and is relevant only for the documents of AP and AR modules.
	`BranchID`Default Navigation	`int`	Branch	Branch
Description:Identifier of the Branch, to which the parent document batch belongs. The value of this field is obtained from the GLDocBatch.BranchID field of the parent batch. Corresponds to the Branch.BranchID field.
	`CADrCr`	`nchar(1)`		-
Description:No description available
	`CashAccountID`Nonexistent in DB	`int`		-
Description:Read-only identifier of the Cash Account associated with the document or transaction defined by the line. Depending on the TranModule and TranType returns either DebitCashAccountID or CreditCashAccountID.
	`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`	`datetime`		-
Description:No description available
	`CreditAccountID`Default Navigation	`int`	Credit Account	Account
Description:No description available
	`CreditCashAccountID`	`int`		CashAccount
Description:The identifier of the Credit Cash Account associated with the document. Credit Cash Account is required for some types of the documents, that can be included in a document batch - see NeedsCreditCashAccount. Corresponds to the CashAccount.CashAccountID field.
	`CreditSubID`Default Navigation	`int`	Credit Subaccount	Sub
Description:Identifier of the credit Subaccount associated with the line of the batch. Corresponds to the Sub.SubID field. For the information related to defaulting of this field see CreditAccountID.
	`CuryApplAmt`	`decimal(19, 4)`	Application Amount	-
Description:The amount of the application. Given in the currency of the line. See also ApplAmt. The value of this field should be set if a line describes an APPayment or an ARPayment, which is applied to existing documents. The Journal Vouchers (GL304000) form allows you to enter application information through the AP Payment Applications and AR Payment Applications tabs.
	`CuryDiscAmt`	`decimal(19, 4)`	Cash Discount	-
Description:The amount of the cash discount for the document (if applicable), given in the currency of the line. See also DiscAmt.
	`CuryDiscBal`Nonexistent in DB	`decimal`	Disc. Balance	-
Description:The read-only discount balance of the document - the amount of the cash discount that has not been used. Given in the currency of the line. See also DiscBal. The value of this field is calculated from the CuryDiscAmt and CuryDiscTaken fields.
	`CuryDiscTaken`	`decimal(19, 4)`		-
Description:The amount of the cash discount taken on the document. Given in the currency of the line. See also DiscTaken.
	`CuryDocTotal`Nonexistent in DB	`decimal`	Doc Total	-
Description:Read-only document total. Given in the currency of the line. For the lines representing document headers gives the total amount of the document, including taxes amount. For the lines representing details of a document returns "null". Calculated from CuryTaxAmt, CuryTranAmt and CuryInclTaxAmt fields.
	`CuryID`Default Navigation	`nvarchar(5)`	Currency	Currency
Description:Identifier of the Currency of the document or transaction that the system creates from the line of the batch.
	`CuryInclTaxAmt`	`decimal(19, 4)`	Included Tax Amount	-
Description:The amount of tax that is included in the document total. Given in the currency of the line. See also InclTaxAmt.
	`CuryInfoID`	`bigint`		CurrencyInfo
Description:Identifier of the CurrencyInfo object associated with the line. Aut-generated. Corresponds to the CurrencyInfo.CurrencyInfoID field.
	`CuryOrigWhTaxAmt`	`decimal(19, 4)`	With. Tax	-
Description:The tax amount withheld on the document. Given in the currency of the line. See also OrigWhTaxAmt.
	`CuryTaxableAmt`	`decimal(19, 4)`	Taxable Amount	-
Description:The amount that is subjected to the tax for the line. Given in the currency of the line. See also TaxableAmt.
	`CuryTaxAmt`	`decimal(19, 4)`	Tax Amount	-
Description:The resulting amount of the tax associated with the line. Given in the currency of the line. See also TaxAmt.
	`CuryTaxTotal`Nonexistent in DB	`decimal`	Tax Total	-
Description:Read-only total amount of tax associated with the document or transaction. Given in the currency of the line. Calculated from the CuryTaxAmt and CuryInclTaxAmt fields.
	`CuryTaxWheld`	`decimal(19, 4)`		-
Description:The actual amount of tax withheld on the applications of the document. Given in the currency of the line. See also TaxWheld. The value of this field is calculated from the values of the APAdjust.CuryAdjdWhTaxAmt or ARAdjust.CuryAdjdWhTaxAmt fields of the applications assoicated with the line.
	`CuryTranAmt`	`decimal(19, 4)`	Subtotal Amount	-
Description:The sum of the document or transaction details or lines. Does not include tax amount. For the batch lines representing details of the document to be created (see Split field), the value of this field defines the line amount. Given in the currency of the line. See also TranAmt.
	`CuryTranTotal`	`decimal(19, 4)`	Total Amount	-
Description:The amount of the document or transaction, including the total tax amount. Given in the currency of the line. See also TotalAmt.
	`CuryUnappliedBal`Nonexistent in DB	`decimal`	Unapplied Balance	-
Description:Read-only unapplied balance of the document. Given in the currency of the line. See also UnappliedBalance. The value of this field is calculated from the CuryTranTotal and CuryApplAmt fields.
	`CuryWhTaxBal`Nonexistent in DB	`decimal`	Wh. Tax Balance	-
Description:The read-only balance of the tax withheld on the document. Given in the currency of the line. See also the WhTaxBal field. The value of this field is calculated from the CuryOrigWhTaxAmt and CuryTaxWheld fields.
	`DebitAccountID`Default Navigation	`int`	Debit Account	Account
Description:No description available
	`DebitCashAccountID`	`int`		CashAccount
Description:The identifier of the Debit Cash Account associated with the document. Debit Cash Account is required for some types of the documents, that can be included in a document batch - see NeedsDebitCashAccount. Corresponds to the CashAccount.CashAccountID field.
	`DebitSubID`Default Navigation	`int`	Debit Subaccount	Sub
Description:Identifier of the debit Subaccount associated with the line of the batch. Corresponds to the Sub.SubID field. For the information related to defaulting of this field see DebitAccountID.
	`DiscAmt`	`decimal(19, 4)`		-
Description:The amount of the cash discount for the document (if applicable), given in the base currency of the company. See also DiscAmt.
	`DiscBal`Nonexistent in DB	`decimal`		-
Description:The read-only discount balance of the document - the amount of the cash discount that has not been used. Given in the base currency of the company. See also CuryDiscBal. The value of this field is calculated from the DiscAmt and DiscTaken fields.
	`DiscDate`	`datetime2`	Cash Discount Date	-
Description:The date of the cash discount for the document, if applicable.
	`DiscTaken`	`decimal(19, 4)`		-
Description:The amount of the cash discount taken on the document. Given in the base currency of the company. See also CuryDiscTaken.
	`DocCreated`	`bit`	Doc. Created	-
Description:When "true", indicates that the document or transaction defined by the line has been created.
	`DocTotal`Nonexistent in DB	`unspecified`		-
Description:Read-only document total. Given in the base currency of the company. For the lines representing document headers gives the total amount of the document, including taxes amount. For the lines representing details of a document returns "null". Calculated from TaxAmt, TranAmt and InclTaxAmt fields.
	`DueDate`	`datetime2`	Due Date	-
Description:The due date of the document defined by the line, if applicable.
	`EntryTypeID`Default Navigation	`nvarchar(10)`	Entry Type ID	CAEntryType
Description:No description available
	`ExtRefNbr`	`nvarchar(40)`	Ext. Ref.Number	-
Description:The reference number of the original vendor or customer document.
	`FinPeriodID`Default Navigation	`char(6)`		-
Description:No description available
	`GroupTranID`Nonexistent in DB	`int`	GroupTranID	-
Description:Read-only identifier of the group of batch lines. Batch lines are grouped by document or transaction, so that for the lines describing different documents the values of this field are different, and for the lines defining header or lines of the same document (see the Split field) the GroupTranID value is the same. Depends only on the LineNbr and ParentLineNbr fields.
	`ImportRefNbr`Nonexistent in DB	`nvarchar(15)`		-
Description:No description available
	`InclTaxAmt`	`decimal(19, 4)`	Included Tax Amount	-
Description:The amount of tax that is included in the document total. Given in the base currency of the company. See also CuryInclTaxAmt.
	`IsARCustomerCashAccount`Nonexistent in DB	`bit`		-
Description:The read-only virtual field, indicating whether the Debit Cash Account is used in AR documents by customers.
	`LastModifiedByID`Default Navigation	`uniqueidentifier`	Last Modified By	Users
Description:No description available
	`LastModifiedByScreenID`	`char(8)`		-
Description:No description available
	`LastModifiedDateTime`	`datetime`		-
Description:No description available
	`LedgerBalanceType`Nonexistent in DB	`nchar(1)`		-
Description:The type of balance of the Ledger, associated with the line. Possible values are: ""A"" - Actual, ""R"" - Reporting, ""S"" - Statistical, ""B"" - Budget. Corresponds to the Ledger.BalanceType field.
	`LedgerID`	`int`		Ledger
Description:Identifier of the Ledger, to which the parent document batch belongs. The value of this field is obtained from the GLDocBatch.LedgerID field of the parent batch. Corresponds to the Ledger.LedgerID field.
	`LocationID`Default Navigation	`int`	Location	Location
Description:Identifier of the Location of the Vendor or Customer associated with this line of the batch. Corresponds to the Location.LocationID field. Defaults to vendor's or customer's default location.
	`NeedsCreditCashAccount`Nonexistent in DB	`bit`		-
Description:The read-only field, indicating whether the Credit Cash Account is required to define the document described by the batch line. The value of this field is determined by the TranModule, TranType, EntryTypeID and CADrCr fields.
	`NeedsDebitCashAccount`Nonexistent in DB	`bit`		-
Description:The read-only field, indicating whether the Debit Cash Account is required to define the document described by the batch line. The value of this field is determined by the TranModule, TranType, EntryTypeID and CADrCr fields.
	`NeedTaskValidation`Nonexistent in DB	`bit`		-
Description:Indicates whether validation for the presence of the correct TaskID must be performed for the line before it is persisted to the database.
	`NoteID`	`uniqueidentifier`		-
Description:Identifier of the Note object, associated with the document. Corresponds to the Note.NoteID field.
	`OrigWhTaxAmt`	`decimal(19, 4)`		-
Description:The tax amount withheld on the document. Given in the base currency of the company. See also OrigWhTaxAmt.
	`ParentLineNbr`	`int`	Parent Line Nbr.	GLTranDoc
Description:No description available
	`PaymentMethodID`Default Navigation	`nvarchar(10)`	Payment Method	PaymentMethod
Description:No description available
	`PMInstanceID`Default Navigation	`int`	Card/Account Nbr.	CustomerPaymentMethod
Description:No description available
	`PMTranID`	`bigint`		PMTran
Description:Identifier of the Project Transactions assoicated with the document or transactions, represented by the line. Corresponds to the PMTran.TranID field.
	`ProjectID`Default Navigation	`int`	Project	PMProject
Description:Identifier of the Project associated with the document or transaction that the system creates from the line, or the non-project code indicating that the document or transaction is not associated with any particular project. Corresponds to the PMProject.ProjectID field.
	`RefNbr`	`nvarchar(15)`	Ref. Number	APInvoice
Description:Reference number of the document or transaction created from the line. For the lines defining GL transactions the field corresponds to the Batch.BatchNbr field. For the lines used to create documents in AP and AR modules the field corresponds to the APRegister.RefNbr and ARRegister.RefNbr fields, respectively. For the lines defining CA transactions the field corresponds to the CAAdj.AdjRefNbr field.
	`Released`	`bit`	Released	-
Description:Indicates whether the document defined by the line has been released. The system releases the documents once they have been generated. "true" if released, otherwise "false".
	`Split`	`bit`	Split	-
Description:When set to "true", indicates that the document or transaction created from this line should include the details defined by other lines of the batch. See also the ParentLineNbr field.
	`TaskID`Default Navigation	`int`	Project Task	PMTask
Description:Identifier of the Task associated with the document or transaction that the system creates from the line. The field is relevant only if the Projects module has been activated and integrated with the module of the document or transaction. Corresponds to the PMTask.TaskID field.
	`TaxableAmt`	`decimal(19, 4)`	Taxable Amount	-
Description:The amount that is subjected to the tax for the line. Given in the base currency of the company. See also CuryTaxableAmt.
	`TaxAmt`	`decimal(19, 4)`	Tax Amount	-
Description:The resulting amount of the tax associated with the line. Given in the base currency of the company. See also CuryTaxAmt.
	`TaxCategoryID`Default Navigation	`nvarchar(15)`	Tax Category	TaxCategory
Description:Identifier of the Tax Category associated with the document or transaction defined by the line. Corresponds to the TaxCategory.TaxCategoryID field.
	`TaxID`Default Navigation	`nvarchar(60)`	Tax ID	Tax
Description:Identifier of the Tax associated with the document, if applicable. Corresponds to the Tax.TaxID field.
	`TaxRate`	`decimal(9, 6)`	Tax Rate	-
Description:The tax rate for the document, if applicable.
	`TaxWheld`	`decimal(19, 4)`		-
Description:The actual amount of tax withheld on the applications of the document. Given in the base currency of the company. See also CuryTaxWheld. The value of this field is calculated from the values of the APAdjust.CuryAdjdWhTaxAmt or ARAdjust.CuryAdjdWhTaxAmt fields of the applications assoicated with the line.
	`TaxZoneID`Default Navigation	`nvarchar(10)`	Tax Zone	TaxZone
Description:Identifier of the Tax Zone associated with the document, if applicable. Corresponds to the TaxZone.TaxZoneID field.
	`TermsID`Default Navigation	`nvarchar(10)`	Terms	Terms
Description:No description available
	`TranAmt`	`decimal(19, 4)`		-
Description:The sum of the document or transaction details or lines. Does not include tax amount. For the batch lines representing details of the document to be created (see Split field), the value of this field defines the line amount. Given in the base currency of the company. See also CuryTranAmt.
	`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.
	`TranCode`Default Navigation	`nvarchar(5)`	Tran. Code	GLTranCode
Description:No description available
	`TranDate`	`datetime2`	Transaction Date	-
Description:The date of the transaction or document that the system creates from this line of the batch. Defaults to the date of the batch.
	`TranDesc`	`nvarchar(256)`	Transaction Description	-
Description:The description of the document or transaction defined by the line.
	`TranLineNbr`	`int`		-
Description:Reserved for internal use.
	`TranModule`	`char(2)`	Tran. Module	-
Description:The module of the transaction or document that the system creates from this line of the batch. The value of this field is defined by the Entry Code specified in the TranCode field.
	`TranPeriodID`	`char(6)`		-
Description:Financial Period of the document or transaction. Corresponds to the period of the batch, which is defined by its date and can't be changed by user.
	`TranTotal`	`decimal(19, 4)`		-
Description:The amount of the document or transaction, including the total tax amount. Given in the base currency of the company. See also CuryTotalAmt.
	`TranType`	`char(3)`	Type	GLTranCode
Description:The type of the transaction or document that the system creates from this line of the batch. The value of this field is defined by the Entry Code specified in the TranCode field.
	`tstamp`	`timestamp`		-
Description:No description available
	`UnappliedBal`Nonexistent in DB	`decimal`		-
Description:Read-only unapplied balance of the document. Given in the base currency of the company. See also CuryUnappliedBalance. The value of this field is calculated from the TranTotal and ApplAmt fields.
	`WhTaxBal`Nonexistent in DB	`decimal`		-
Description:The read-only balance of the tax withheld on the document. Given in the base currency of the company. See also the CuryWhTaxBal field. The value of this field is calculated from the OrigWhTaxAmt and TaxWheld fields.