| Field |
Description |
Type |
Size |
Related |
Default Value |
Constraints |
| AbsEntry |
Abs Entry (Numerator) |
Int |
11 |
- |
|
|
|
| ReportName |
Report Name |
nVarChar |
50 |
- |
|
|
|
| RptLayout |
Report Layout |
VarChar |
1 |
- |
R |
R |
Tax Register Book |
| |
|
|
|
|
|
D |
Tax Declaration |
| |
|
|
|
|
|
B |
Black List Country - Tax Declaration |
| |
|
|
|
|
|
L |
Black List Country - Tax Declaration 2013 |
| |
|
|
|
|
|
A |
VAT Annual List |
| |
|
|
|
|
|
I |
Annual Invoice Declaration 2011 |
| |
|
|
|
|
|
N |
Annual Invoice Declaration 2013 |
| |
|
|
|
|
|
P |
Declaration of Purchases from San Marino |
| |
|
|
|
|
|
E |
Electronic Tax Declaration |
| |
|
|
|
|
|
F |
Electronic Tax Declaration 2018 |
| |
|
|
|
|
|
M |
VAT Invoice Declaration 2017 |
| |
|
|
|
|
|
G |
Electronic Tax Declaration 2019 |
| |
|
|
|
|
|
T |
One-Stop Shop Declaration |
| FirstPrint |
First Printed No. |
Int |
11 |
- |
|
|
|
| FromDate |
Date From |
Date |
8 |
- |
|
|
|
| ToDate |
Date To |
Date |
8 |
- |
|
|
|
| TaxDate |
Document Date |
VarChar |
1 |
- |
N |
N |
No |
| |
|
|
|
|
|
Y |
Yes |
| RoundSum |
Round Amounts |
VarChar |
1 |
- |
N |
N |
No |
| |
|
|
|
|
|
Y |
Yes |
| |
|
|
|
|
|
|
. |
| Declration |
Declaration Type |
VarChar |
1 |
- |
O |
O |
Original |
| |
|
|
|
|
|
S |
Substitute |
| |
|
|
|
|
|
C |
Complementary |
| FilterType |
Selection Criteria Type |
VarChar |
1 |
- |
N |
V |
Tax Report |
| |
|
|
|
|
|
W |
Withholding Tax Report |
| |
|
|
|
|
|
T |
Report 347 |
| |
|
|
|
|
|
E |
349 Report |
| |
|
|
|
|
|
R |
Reconciliation Report |
| |
|
|
|
|
|
S |
Stamp Tax |
| |
|
|
|
|
|
U |
Sales Report |
| |
|
|
|
|
|
N |
None |
| |
|
|
|
|
|
B |
Box Report |
| |
|
|
|
|
|
O |
Appendix O or P Selection |
| |
|
|
|
|
|
A |
Annual Sales Report |
| |
|
|
|
|
|
F |
VAT Refund Report |
| |
|
|
|
|
|
C |
Input/Output VAT Report |
| ExcludeWT |
Exclude Withholding Tax |
VarChar |
1 |
- |
N |
N |
No |
| |
|
|
|
|
|
Y |
Yes |
| CustomerIn |
Include Customers |
VarChar |
1 |
- |
Y |
Y |
Yes |
| |
|
|
|
|
|
N |
No |
| VendorIn |
Include Vendors |
VarChar |
1 |
- |
Y |
N |
No |
| |
|
|
|
|
|
Y |
Yes |
| Period |
Quarter, Year or Month |
VarChar |
1 |
- |
Q |
Q |
Quarter |
| |
|
|
|
|
|
Y |
Year |
| |
|
|
|
|
|
M |
Month |
| |
|
|
|
|
|
S |
. |
| Quarter |
Quarter |
Int |
11 |
- |
|
|
|
| Year |
Year |
Int |
11 |
- |
|
|
|
| DocType |
A/P or A/R |
VarChar |
1 |
- |
P |
P |
Purchasing Documents |
| |
|
|
|
|
|
R |
Sales Documents |
| CreditMemo |
Credit Memos |
VarChar |
1 |
- |
N |
N |
No |
| |
|
|
|
|
|
Y |
Yes |
| DocTypeIn |
Include Document Type |
VarChar |
1 |
- |
N |
N |
No |
| |
|
|
|
|
|
Y |
Yes |
| FirstReg |
First Register Number |
Int |
11 |
- |
|
|
|
| AccountIn |
Include G/L Accounts |
VarChar |
1 |
- |
N |
N |
No |
| |
|
|
|
|
|
Y |
Yes |
| DeferTaxIn |
Show Pmts with Deferred Tax |
VarChar |
1 |
- |
Y |
Y |
Yes |
| |
|
|
|
|
|
N |
No |
| ApndxOOrP |
Appendix O or P Selection |
VarChar |
1 |
- |
Y |
Y |
Yes |
| |
|
|
|
|
|
N |
No |
| DispOBCB |
Opening & Closing Balance |
VarChar |
1 |
- |
Y |
N |
No |
| |
|
|
|
|
|
Y |
Yes |
| FromSeries |
From Tax Series Group |
Int |
11 |
- |
|
|
|
| ToSeries |
To Tax Series Group |
Int |
11 |
- |
|
|
|
| canceltn |
For EU Sales Report |
VarChar |
1 |
- |
N |
|
|
| HideNTrans |
Hide Tax Codes with no Trans. |
VarChar |
1 |
- |
N |
N |
No |
| |
|
|
|
|
|
Y |
Yes |
| SeriesIn |
Include Series Filter |
VarChar |
1 |
- |
N |
N |
No |
| |
|
|
|
|
|
Y |
Yes |
| UserCode |
User Code |
nVarChar |
25 |
- |
|
|
|
| FromCardCo |
BP Code From |
nVarChar |
15 |
- |
|
|
|
| ToCardCo |
BP Code To |
nVarChar |
15 |
- |
|
|
|
| SizeOfStru |
Size of Structure |
Int |
11 |
- |
|
|
|
| PostFrDate |
Posting Date From |
Date |
8 |
- |
|
|
|
| PostToDate |
Posting Date To |
Date |
8 |
- |
|
|
|
| DocFrDate |
Document Date From |
Date |
8 |
- |
|
|
|
| DocToDate |
Document Date To |
Date |
8 |
- |
|
|
|
| FromDoc1Nu |
Document 1 - From |
nVarChar |
11 |
- |
|
|
|
| ToDoc1Nu |
Document 1 - To |
nVarChar |
11 |
- |
|
|
|
| Serie1 |
Invoice Numbering Series |
nVarChar |
11 |
- |
Y |
Y |
Yes |
| |
|
|
|
|
|
N |
No |
| Serie1CB |
Inv. Numbering Series Filter |
VarChar |
1 |
- |
N |
Y |
Yes |
| |
|
|
|
|
|
N |
No |
| Doc1Type |
Type of Document 1 |
Int |
11 |
- |
|
|
|
| FromDoc2Nu |
Document 2 - From |
nVarChar |
11 |
- |
|
|
|
| ToDoc2Nu |
Document 2 - To |
nVarChar |
11 |
- |
|
|
|
| Serie2 |
Credit Memo Numbering Series |
nVarChar |
11 |
- |
Y |
Y |
Yes |
| |
|
|
|
|
|
N |
No |
| Serie2CB |
Corr. Inv. Rev. No. Series |
VarChar |
1 |
- |
N |
Y |
Yes |
| |
|
|
|
|
|
N |
No |
| Doc2Type |
Type of Document 2 |
Int |
11 |
- |
|
|
|
| FromDoc3Nu |
Document 3 - From |
nVarChar |
11 |
- |
|
|
|
| ToDoc3Nu |
Document 3 - To |
nVarChar |
11 |
- |
|
|
|
| Serie3 |
Corr. Inv. Numbering Series |
nVarChar |
11 |
- |
Y |
Y |
Yes |
| |
|
|
|
|
|
N |
No |
| Serie3CB |
Corr. Inv. Num. Series Filter |
VarChar |
1 |
- |
N |
Y |
Yes |
| |
|
|
|
|
|
N |
No |
| Doc3Type |
Type of Document 3 |
Int |
11 |
- |
|
|
|
| FromDoc4Nu |
Document 4 - From |
nVarChar |
11 |
- |
|
|
|
| ToDoc4Nu |
Document 4 - To |
nVarChar |
11 |
- |
|
|
|
| Serie4 |
Corr. Inv. Rev. No. Series |
nVarChar |
11 |
- |
Y |
Y |
Yes |
| |
|
|
|
|
|
N |
No |
| Serie4CB |
Corr. Inv. Reversal No. Series |
VarChar |
1 |
- |
N |
Y |
Yes |
| |
|
|
|
|
|
N |
No |
| Doc4Type |
Type of Document 4 |
Int |
11 |
- |
|
|
|
| FromDoc5Nu |
Document 5 - From |
nVarChar |
11 |
- |
|
|
|
| ToDoc5Nu |
Document 5 - To |
nVarChar |
11 |
- |
|
|
|
| Serie5 |
Down Payment Numbering Series |
nVarChar |
11 |
- |
Y |
Y |
Yes |
| |
|
|
|
|
|
N |
No |
| Serie5CB |
Down Payment Numbering Series |
VarChar |
1 |
- |
N |
Y |
Yes |
| |
|
|
|
|
|
N |
No |
| Doc5Type |
Type of Document 5 |
Int |
11 |
- |
|
|
|
| DateRBtn |
Report Period |
VarChar |
1 |
- |
I |
I |
Interval |
| |
|
|
|
|
|
D |
Date |
| MarkDocsIn |
Include Marketing Documents |
VarChar |
1 |
- |
Y |
N |
No |
| |
|
|
|
|
|
Y |
Yes |
| ExRate |
Exchange Rate |
VarChar |
1 |
- |
P |
P |
Posting |
| |
|
|
|
|
|
R |
For Reports |
| ExRateDate |
Exchange Rate Date |
VarChar |
1 |
- |
P |
P |
Posting Date |
| |
|
|
|
|
|
D |
Document Date |
| |
|
|
|
|
|
V |
VAT Date |
| TrsPerioTp |
Report Period Type |
VarChar |
1 |
- |
|
Y |
Year |
| |
|
|
|
|
|
Q |
Quarter |
| |
|
|
|
|
|
B |
Bi-Monthly |
| |
|
|
|
|
|
M |
Month |
| |
|
|
|
|
|
P |
Period |
| |
|
|
|
|
|
F |
Fiscal Year |
| |
|
|
|
|
|
G |
Fiscal Quarter |
| TrsPerioNu |
Report Period Number |
Int |
11 |
- |
|
|
|
| TrsYear |
Report Year |
Int |
6 |
- |
|
|
|
| TrsAdjtNum |
Report Adjustment Number |
Int |
6 |
- |
|
|
|
| DateType |
Date Type |
VarChar |
1 |
- |
P |
P |
Posting Date |
| |
|
|
|
|
|
D |
Document Date |
| |
|
|
|
|
|
V |
VAT Date |
| |
|
|
|
|
|
C |
System Date |
| IncServDoc |
Include Service Documents |
VarChar |
1 |
- |
Y |
Y |
Yes |
| |
|
|
|
|
|
N |
No |
| GrpBySCode |
Group by Sales Code |
VarChar |
1 |
- |
Y |
Y |
Yes |
| |
|
|
|
|
|
N |
No |
| IncUnReDoc |
Include Unreconciled Documents |
VarChar |
1 |
- |
Y |
Y |
Yes |
| |
|
|
|
|
|
N |
No |
| DoYearSum |
Year Summary |
VarChar |
1 |
- |
|
Y |
Yes |
| |
|
|
|
|
|
N |
No |
| DefTaxOnly |
Only Include Deferred Tax Docs |
VarChar |
1 |
- |
N |
Y |
Yes |
| |
|
|
|
|
|
N |
No |
| ExcElDoc |
Exclude Electronic Documents |
VarChar |
1 |
- |
N |
Y |
Yes |
| |
|
|
|
|
|
N |
No |
| QtrByMnt |
Quarter by Months |
VarChar |
1 |
- |
N |
Y |
Yes |
| |
|
|
|
|
|
N |
No |
| OnlyExtnTx |
Only External Tax |
VarChar |
1 |
- |
N |
Y |
Yes |
| |
|
|
|
|
|
N |
No |
| IncludeWTR |
Include Inventory Transfers |
VarChar |
1 |
- |
Y |
Y |
Yes |
| |
|
|
|
|
|
N |
No |
| FromMark |
MARK From |
nVarChar |
40 |
- |
|
|
|
| ToMark |
MARK To |
nVarChar |
40 |
- |
|
|
|
| IsueFrDate |
Issue Date From |
Date |
8 |
- |
|
|
|
| IsueToDate |
Issue Date To |
Date |
8 |
- |
|
|
|
| FromVatNo |
Issuer VAT No. From |
nVarChar |
64 |
- |
|
|
|
| ToVatNo |
Issuer VAT No. To |
nVarChar |
64 |
- |
|
|
|
| FrInvType |
Invoice Type From |
nVarChar |
50 |
- |
|
|
|
| ToInvType |
Invoice Type To |
nVarChar |
50 |
- |
|
|
|