Localizations

T5018VendorTransaction

PX.Objects.Localizations.CARelease 2025.2

Projection DAC for aggregating payments for the purpose of T5018 calculations.

Select a row for its description 84 of 84 fields

	Field Name	Type	Display Name	Foreign Key
	`APAdjustReleased`	`bit`		-
Description:When set to "true" indicates that the adjustment was released.
	`APAdjustVoided`	`bit`		-
Description:When set to "true" indicates that the adjustment was voided.
	`AcctCD`Default Navigation	`nvarchar(30)`	Account ID	BAccountR
Description:The human-readable identifier of the business account that is specified by the user or defined by the auto-numbering sequence during the creation of the account. This field is a natural key, as opposed to the surrogate key BAccountID.
	`AcctName`	`nvarchar(255)`	Account Name	-
Description:The full business account name (as opposed to the short identifier AcctCD).
	`AcctReferenceNbr`	`nvarchar(50)`	Ext. Ref. Nbr.	-
Description:The external reference number of the business account. It can be an additional number of the business account used in external integration.
	`AdjdDocDate`	`datetime`		-
Description:Either the date when the adjusted document was created or the date of the original vendor's document.
	`AdjdDocType`	`nvarchar`		-
Description:The type of the adjusted document.
	`AdjdLineNbr`	`int`		-
Description:No description available
	`AdjdRefNbr`	`nvarchar`		-
Description:Reference number of the adjusted document.
	`AdjgDocDate`	`datetime`		-
Description:The date when the payment is applied.
	`AllowOverrideCury`	`bit`	Enable Currency Override	-
Description:If set to true, indicates that the currency of business account documents (which is specified by BAccount.CuryID) can be overridden by a user during document entry.
	`AllowOverrideRate`	`bit`	Enable Rate Override	-
Description:If set to true, indicates that the currency rate for customer documents (which is calculated by the system from the currency rate history) can be overridden by a user during document entry. The field is used only if the business account is a customer (that is, IsCustomerOrCombined is true).
	`Attributes`Nonexistent in DB	`string`		-
Description:The attributes list available for the current business account. The field is preserved for internal use.
	`BAccountID`	`int`	Business Account ID	-
Description:The identifier of the business account. This field is auto-incremental. This field is a surrogate key, as opposed to the natural key AcctCD.
	`BaseCuryID`Default Navigation	`nvarchar(5)`	Base Currency ID	CurrencyList
Description:The base Currency of the Branch. This unbound field corresponds to the Organization.BaseCuryID.
	`BranchID`	`int`		-
Description:The branch ID of associated payments.
	`COrgBAccountID`Default Navigation	`int`	Customer Restriction Group	-
Description:No description available
	`CampaignSourceID`Default Navigation	`nvarchar(15)`	Source Campaign	CRCampaign
Description:The identifier of the marketing or sales campaign that resulted in creation of the business account. Corresponds to the value of the CRCampaign.CampaignID field.
	`CasesCount`Nonexistent in DBObsolete	`int?`		-
Description:No description available
	`ClassID`Default Navigation	`nvarchar(10)`	Class ID	CRCustomerClass
Description:Identifier of the business acccount class to which the business account belongs.
	`ConsolidateToParent`	`bit`	Consolidate Balance	-
Description:The total balance of the parent customer account including balances of its child accounts for which the value of this field is true on the Billing Info tab of this form. The amount includes the balances of all open documents and prepayments. This field is used in the Customer class and showed only on the Customers (AR303000) form.
	`ConsolidatingBAccountID`	`int`		-
Description:The field is preserved for internal use.
	`Count`Nonexistent in DBObsolete	`int?`	Count	-
Description:No description available
	`CreatedByID`Default Navigation	`uniqueidentifier`	Created By	Users
Description:No description available
	`CreatedByScreenID`	`char(8)`		-
Description:No description available
	`CreatedDateTime`	`datetime`	Created On	-
Description:No description available
	`CuryAdjgAmt`	`decimal`		-
Description:The actual amount paid on the document. Presented in the currency of the document, see APRegister.CuryID.
	`CuryDiscTot`	`decimal`		-
Description:Total discount associated with the document in the currency of the document. (See CuryID)
	`CuryDocBal`	`decimal`		-
Description:No description available
	`CuryID`Default Navigation	`nvarchar(5)`	Currency ID	Currency
Description:The identifier of the Currency, which is applied to the documents of the business account.
	`CuryLineAmt`	`decimal`		-
Description:The extended cost of the item or service associated with the line, which is the unit price multiplied by the quantity. (Presented in the currency of the document, see APRegister.CuryID)
	`CuryOrigDocAmt`	`decimal`		-
Description:The amount to be paid for the document in the currency of the document. (See CuryID)
	`CuryRateTypeID`Default Navigation	`nvarchar(6)`	Curr. Rate Type	CurrencyRateType
Description:The identifier of the currency rate type, which is applied to the documents of the customer. The field is used only if the business account is a customer (that is, IsCustomerOrCombined is true).
	`CuryTaxableAmt`	`decimal`		-
Description:No description available
	`CuryTranAmt`	`decimal`		-
Description:The total amount for the specified quantity of items or services of this type (after discount has been taken), or the amount of debit adjustment or prepayment. (Presented in the currency of the document, see APRegister.CuryID)
	`DefAddressID`Default Navigation	`int`	Default Address	Address
Description:The identifier of the CR.Address record used to store address data of the business account. Corresponds to the value of the Address.AddressID field. Also, the Address.BAccountID value must be equal to the BAccount.BAccountID value of the current business account.
	`DefContactID`Default Navigation	`int`	Default Contact	Contact
Description:The identifier of the CR.Contact object used to store additional contact data of the business account. Corresponds to the value of the Contact.ContactID field. Also, the Contact.BAccountID value must be equal to the BAccount.BAccountID value of the current business account.
	`DefLocationID`Default Navigation	`int`	Default Location	Location
Description:The identifier of the Location object linked with the business account and marked as default. The linked location is shown on the Shipping tab. Corresponds to the value of the Location.LocationID field. Also, the Location.BAccountID value must also equal to the BAccount.BAccountID value of the current business account.
	`DocDate`	`datetime`		-
Description:Either the date when the adjusted document was created or the date of the original vendor's document.
	`DocType`	`nvarchar(3)`		-
Description:The type of the adjusted document.
	`GroupMask`	`varbinary`		-
Description:The group mask that indicates which restriction groups the business account belongs to.
	`IncludeInT5018Report`	`bit`		-
Description:The type of the adjusted document.
	`InvoiceTotal`	`decimal`		-
Description:The amount to be paid for the document in the currency of the document. (See CuryID)
	`IsBranch`	`bit`		-
Description:No description available
	`IsCustomerOrCombined`Nonexistent in DB	`bool?`		-
Description:A calculated field that indicates (if set to "true") that BAccount.Type is either BAccountType.CustomerType or BAccountType.CombinedType.
	`IsRelatedToProjectContact`Nonexistent in DB	`bool?`	Is Related To Project Contact	-
Description:No description available
	`LastActivity`Nonexistent in DBObsolete	`DateTime?`	Last Activity	-
Description:No description available
	`LastModifiedByID`Default Navigation	`uniqueidentifier`	Last Modified By	Users
Description:No description available
	`LastModifiedByScreenID`	`char(8)`		-
Description:No description available
	`LastModifiedDateTime`	`datetime`	Last Modified On	-
Description:No description available
	`LegalName`	`nvarchar(255)`	Legal Name	-
Description:The legal name of the company that is used by the 1099 Reporting feature only (see DAC.Organization).
	`LineType`	`nvarchar`		-
Description:The type of the transaction line. This field is used to distinguish Discount lines from other ones. Equals ""DS"" for discounts, ""LA"" for landed-cost transactions created in AP, ""LP"" for landed-cost transactions created from PO, and empty string for common lines.
	`LocaleName`Default Navigation	`nvarchar(10)`	Language/Locale	Locale
Description:The name of the business account locale.
	`NoteID`	`uniqueidentifier`		-
Description:No description available
	`OrigDocType`	`nvarchar`		-
Description:No description available
	`OrigLineNbr`	`int`		-
Description:No description available
	`OrigRefNbr`	`nvarchar`		-
Description:No description available
	`OverrideSalesTerritory`	`bit`	Override Territory	-
Description:The flag identified that the salesTerritoryID is filled automatically based on Address.state and Address.countryID or can be assigned manually.
	`OwnerID`Default Navigation	`int`	Owner	Contact
Description:No description available
	`ParentBAccountID`Default Navigation	`int`	Business Account	BAccountR
Description:The identifier of the parent business account. Corresponds to the value of the BAccount.BAccountID field of the parent account. This field is used for consolidating customer account balances on the parent account from child accounts.
	`PreviewHtml`Nonexistent in DBObsolete	`string`		-
Description:No description available
	`PrimaryContactID`Default Navigation	`int`	Primary Contact	Contact
Description:The identifier of the CR.Contact object linked with the business account and marked as primary. Corresponds to the value of the Contact.ContactID field. Also, the Contact.BAccountID value must equal to the BAccount.BAccountID value of the current business account.
	`PseudonymizationStatus`	`int`	Pseudonymized	-
Description:No description available
	`RefNbr`	`nvarchar(15)`		-
Description:Reference number of the document.
	`RegisteredEntityForReporting`	`bit`	Registered Entity for Government Payroll Reporting	-
Description:The registered entity for government payroll reporting.
	`Released`	`bit`		-
Description:When set to "true" indicates that the document was released.
	`RetainageApply`	`bit`		-
Description:If the document is the parent for a retainage bill.
	`SalesTerritoryID`Default Navigation	`nvarchar(15)`	Sales Territory	SalesTerritory
Description:The reference to SalesTerritory.salesTerritoryID. If overrideSalesTerritory is false then it's filled automatically based on Address.state and Address.countryID otherwise it's assigned by user.
	`Selected`Nonexistent in DB	`bool?`	Selected	-
Description:No description available
	`Status`	`char(1)`	Customer Status	-
Description:No description available
	`T5018Service`	`bit`		-
Description:No description available
	`TaxRegistrationID`	`nvarchar(50)`	Tax Registration ID	-
Description:The registration ID of the company in the state tax authority.
	`TranID`	`int`		-
Description:Internal unique identifier of the transaction line. The value is an auto-generated database identity.
	`TranType`	`nvarchar`		-
Description:The type of the transaction. The field is determined by the type of the parent document. For the list of possible values see APRegister.DocType.
	`Type`	`char(2)`	Type	-
Description:Represents the type of the business account. The field can have one of the values listed in the BAccountType class. The default value is BAccountType.ProspectType for a prospect, BAccountType.CustomerType for a customer, and BAccountType.VendorType for a vendor.
	`VOrgBAccountID`Default Navigation	`int`	Vendor Restriction Group	-
Description:No description available
	`VStatus`	`char(1)`	Vendor Status	-
Description:No description available
	`VendorID`	`int`		-
Description:The vendor ID of associated payments.
	`ViewInAp`Nonexistent in DB	`bool?`		-
Description:The flag is used to identify whether a BAccount is associated with a Vendor (AP). It is set to true within the VendorAttribute and utilized in the PrimaryGraphList logic of BAccount to determine the appropriate navigation behavior.
	`ViewInAr`Nonexistent in DB	`bool?`		-
Description:The flag is used to identify whether a BAccount is associated with a Customer (AR). It is set to true within the CustomerAttribute and utilized in the PrimaryGraphList logic of BAccount to determine the appropriate navigation behavior.
	`ViewInCrm`Nonexistent in DB	`bool?`	View In CRM	-
Description:No description available
	`Voided`	`bit`		-
Description:When set to "true" indicates that the document was voided.
	`WorkgroupID`Default Navigation	`int`	Workgroup	EPCompanyTree
Description:No description available
	`tstamp`	`timestamp`		-
Description:No description available