Skip to main content
TX

TaxReportLine

PX.Objects.TX
Field NameTypeDisplay NameForeign Key
LineNbr
intReport Line Nbr.-
Description:The number of the report line. The field is a part of the primary key.
TaxReportRevisionID
intReport VersionTaxReport
Description:No description available
VendorID
intVendor
Description:The foreign key to , which specifies a tax agency to which the report line belongs. The field is a part of the primary key.
BucketSumNonexistent in DB
nvarchar(50)Calc. Rule-
Description:The calculation rule, which is filled in by the system automatically if the report line is an aggregate line and the appropriate settings have been specified.
CreatedByIDDefault Navigation
uniqueidentifierCreated ByUsers
Description:No description available
CreatedByScreenID
char(8)-
Description:No description available
CreatedDateTime
datetime-
Description:No description available
Descr
nvarchar(60)Description-
Description:The description of the report line, which can be specified by the user.
HideReportLine
bitHide Report Line-
Description:Specifies (if set to "true") that the line will not be included in the tax report during generation of the report.
LastModifiedByIDDefault Navigation
uniqueidentifierLast Modified ByUsers
Description:No description available
LastModifiedByScreenID
char(8)-
Description:No description available
LastModifiedDateTime
datetime-
Description:No description available
LineMult
smallintUpdate Rule-
Description:The rule (sign) of updating the report line. The field can have one of the following values: ""1"": +Output-Input. ""-1"": +Input-Output.
LineType
char(1)Update With-
Description:The type of the report line, which indicates whether the tax amount or taxable amount should be used to update the line. The field can have one of the following values: ""P"": Tax amount. ""A"": Taxable amount.
NetTax
bitNet Tax-
Description:The field indicates (if set to "true") that the line shows the net tax amount.
ReportLineNbr
nvarchar(10)Tax Box Number-
Description:The number of the corresponding box of the original report form; the number is unique for each tax agency.
SortOrder
intReport Line Order-
Description:No description available
TaxZoneIDDefault Navigation
nvarchar(10)Tax Zone IDTaxZone
Description:The foreign key to TaxZone. If the field contains NULL, the report line contains aggregated data for all tax zones.
TempLine
bitDetail by Tax Zones-
Description:Specifies (if set to "true") that the report line should be sliced by tax zones, and that the line is parent.
TempLineNbr
intParent Line-
Description:The reference to the parent line (TaxReportLine.LineNbr). The child lines are created for each tax zone if the TempLine of the parent line is set to "true".
tstamp
timestamp-
Description:No description available