TX
TaxReportLine
PX.Objects.TX21 of 21 fields
| Field Name | Type | Display Name | Foreign Key | |
|---|---|---|---|---|
LineNbr | int | Report Line Nbr. | - | |
Description:The number of the report line. The field is a part of the primary key. | ||||
TaxReportRevisionID | int | Report Version | TaxReport | |
Description:No description available | ||||
VendorID | int | Vendor | ||
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. | ||||
CreatedByID | uniqueidentifier | Created By | Users | |
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 | bit | Hide Report Line | - | |
Description:Specifies (if set to "true") that the line will not be included in the tax report during generation of the report. | ||||
LastModifiedByID | uniqueidentifier | Last Modified By | Users | |
Description:No description available | ||||
LastModifiedByScreenID | char(8) | - | ||
Description:No description available | ||||
LastModifiedDateTime | datetime | - | ||
Description:No description available | ||||
LineMult | smallint | Update 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 | bit | Net 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 | int | Report Line Order | - | |
Description:No description available | ||||
TaxZoneID | nvarchar(10) | Tax Zone ID | TaxZone | |
Description:The foreign key to TaxZone. If the field contains NULL, the report line contains aggregated data for all tax zones. | ||||
TempLine | bit | Detail 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 | int | Parent 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 | ||||