| Field |
Description |
Type |
Size |
Related |
Default Value |
Constraints |
| Code |
Code |
nVarChar |
8 |
- |
|
|
|
| Name |
Name |
nVarChar |
50 |
- |
|
|
|
| Rate |
Rate % |
Num |
19.6 |
- |
|
|
|
| EffecDate |
Effective from |
Date |
8 |
- |
|
|
|
| Category |
Category |
VarChar |
1 |
- |
O |
O |
Output Tax |
| |
|
|
|
|
|
I |
Input Tax |
| Account |
Tax Account |
nVarChar |
15 |
OACT |
|
|
|
| Locked |
Locked |
VarChar |
1 |
- |
N |
Y |
Yes |
| |
|
|
|
|
|
N |
No |
| DataSource |
Data Source |
VarChar |
1 |
- |
N |
N |
Unknown |
| |
|
|
|
|
|
I |
Interface |
| |
|
|
|
|
|
U |
Update |
| |
|
|
|
|
|
M |
Import |
| |
|
|
|
|
|
O |
DI API |
| |
|
|
|
|
|
S |
Service Layer |
| |
|
|
|
|
|
W |
Web Client |
| |
|
|
|
|
|
A |
Doc. Generation Wizard |
| |
|
|
|
|
|
D |
Restore Wizard |
| |
|
|
|
|
|
P |
Partner Implementation |
| |
|
|
|
|
|
T |
Year Transfer |
| UserSign |
User Signature |
Int |
6 |
OUSR |
|
|
|
| IsEC |
EU |
VarChar |
1 |
- |
N |
Y |
Yes |
| |
|
|
|
|
|
N |
No |
| Indicator |
Triangular Deal |
VarChar |
1 |
OIND |
|
|
|
| AcqstnRvrs |
Acquisition/Reverse |
VarChar |
1 |
- |
N |
Y |
Yes |
| |
|
|
|
|
|
N |
No |
| NonDedct |
Non Deduct. % |
Num |
19.6 |
- |
|
|
|
| AcqsTax |
Acquisition Tax Account |
nVarChar |
15 |
OACT |
|
|
|
| GoddsShip |
Goods Shipment |
VarChar |
1 |
OGSP |
|
|
|
| NonDedAcc |
Non Deduct. Acct |
nVarChar |
15 |
OACT |
|
|
|
| DeferrAcc |
Deferred Tax Account |
nVarChar |
15 |
OACT |
|
|
|
| EquVatPr |
Equalization Tax % |
Num |
19.6 |
- |
|
|
|
| ReportCode |
Group Description |
nVarChar |
100 |
- |
|
|
|
| FixdAssts |
Fixed Assets Flag |
VarChar |
1 |
- |
N |
Y |
Yes |
| |
|
|
|
|
|
N |
No |
| CalcMethod |
Calculation Method |
VarChar |
1 |
- |
R |
R |
Rate |
| |
|
|
|
|
|
F |
Fixed |
| TaxType |
Tax Type (VAT or Stamp) |
VarChar |
1 |
- |
V |
V |
VAT |
| |
|
|
|
|
|
S |
Stamp |
| FixedAmnt |
Fixed Amount (LC) |
Num |
19.6 |
- |
|
|
|
| ExtCode |
External Code |
nVarChar |
10 |
- |
|
|
|
| Correction |
Correction |
VarChar |
1 |
- |
N |
Y |
Yes |
| |
|
|
|
|
|
N |
No |
| VatCrctn |
VAT Correction |
nVarChar |
8 |
OVTG |
|
|
|
| RetVatCode |
Returning VAT Code |
nVarChar |
8 |
- |
|
|
|
| RepType |
Report Type |
Int |
11 |
OKRT |
|
|
|
| LogInstanc |
Log Instance |
Int |
11 |
- |
0 |
|
|
| UpdateDate |
Date of Update |
Date |
8 |
- |
|
|
|
| TaxCtgr |
Tax Type (Annual List) |
nVarChar |
6 |
- |
E |
E |
Excluded |
| |
|
|
|
|
|
T |
Taxable |
| |
|
|
|
|
|
X |
Exempt |
| |
|
|
|
|
|
N |
Not Taxable |
| |
|
|
|
|
|
N31 |
N3.1 - Not Taxable - exports |
| |
|
|
|
|
|
N32 |
N3.2 - Not Taxable - intra-community sales |
| |
|
|
|
|
|
N33 |
N3.3 - Not Taxable - sales to San Marino |
| |
|
|
|
|
|
N34 |
N3.4 - Not Taxable - operations similar to export sales |
| |
|
|
|
|
|
N35 |
N3.5 - Not Taxable - due to tax exemption letter |
| |
|
|
|
|
|
N36 |
N3.6 - Not Taxable - other transactions |
| |
|
|
|
|
|
G |
Gross Profit |
| |
|
|
|
|
|
R |
Reverse Charge |
| |
|
|
|
|
|
R61 |
N6.1 - Reverse Charge - disposal of scrap and other recycled materials |
| |
|
|
|
|
|
R62 |
N6.2 - Accounting Reversal - sale of gold and pure silver |
| |
|
|
|
|
|
R63 |
N6.3 - Reverse Charge - subcontracting in the construction sector |
| |
|
|
|
|
|
R64 |
N6.4 - Reverse Charge - sales of buildings |
| |
|
|
|
|
|
R65 |
N6.5 - Reverse Charge - sales of cell phones |
| |
|
|
|
|
|
R66 |
N6.6 - Reverse Charge - sales of electronic products |
| |
|
|
|
|
|
R67 |
N6.7 - Reverse Charge - services of the construction and related sectors |
| |
|
|
|
|
|
R68 |
N6.8 - Reverse Charge - energy sector operations |
| |
|
|
|
|
|
R69 |
N6.9 - Reverse Charge - other cases |
| |
|
|
|
|
|
U |
Tourism |
| |
|
|
|
|
|
A |
Taxable - Article 162 |
| |
|
|
|
|
|
B |
Taxable - Article 173 point 5 |
| |
|
|
|
|
|
C |
Taxable - Construction |
| |
|
|
|
|
|
D |
Taxable - Expected Confirmation |
| |
|
|
|
|
|
F |
Taxable - Gross |
| |
|
|
|
|
|
I |
Taxable - Import |
| |
|
|
|
|
|
Y |
Taxable - Import from EAEU |
| |
|
|
|
|
|
L |
Taxable - Late Export |
| |
|
|
|
|
|
O |
Taxable - Not Confirmed |
| |
|
|
|
|
|
S |
Taxable - Real Estate |
| |
|
|
|
|
|
W |
Taxable - Sale of Company |
| |
|
|
|
|
|
H |
Excluded Art. 15 |
| |
|
|
|
|
|
J |
Not Subject |
| |
|
|
|
|
|
J21 |
N2.1 - Not Subject - to VAT under articles from 7 to 7-septies of DPR 633/72 |
| |
|
|
|
|
|
J22 |
N2.2 - Not Subject - other cases |
| |
|
|
|
|
|
K |
Paid in other EU country |
| |
|
|
|
|
|
M |
Taxable - Article 151 point 1 |
| |
|
|
|
|
|
P |
Taxable - Article 170 point 3 |
| |
|
|
|
|
|
V |
Taxable - Fixed Assets |
| |
|
|
|
|
|
Q |
Taxable - Tax Free |
| EquAccount |
Equalization Tax Account |
nVarChar |
15 |
OACT |
|
|
|
| UserSign2 |
Updating User |
Int |
6 |
OUSR |
|
|
|
| IsIGIC |
IGIC |
VarChar |
1 |
- |
N |
Y |
Yes |
| |
|
|
|
|
|
N |
No |
| ServSupply |
Service Supply |
VarChar |
1 |
OSSP |
|
|
|
| Inactive |
Inactive |
VarChar |
1 |
- |
N |
Y |
Yes |
| |
|
|
|
|
|
N |
No |
| TaxCtgrBL |
Tax Type (Black List) |
VarChar |
1 |
- |
E |
E |
Excluded |
| |
|
|
|
|
|
T |
Taxable |
| |
|
|
|
|
|
X |
Exempt |
| |
|
|
|
|
|
N |
Not Taxable |
| |
|
|
|
|
|
S |
Non-Subject |
| R349Code |
Report 349 Code |
Int |
11 |
- |
0 |
0 |
|
| |
|
|
|
|
|
1 |
E |
| |
|
|
|
|
|
2 |
A |
| |
|
|
|
|
|
3 |
T |
| |
|
|
|
|
|
4 |
S |
| |
|
|
|
|
|
5 |
I |
| |
|
|
|
|
|
6 |
M |
| |
|
|
|
|
|
7 |
H |
| |
|
|
|
|
|
8 |
R |
| |
|
|
|
|
|
9 |
D |
| VatRevAcc |
VAT in Revenue Account |
nVarChar |
15 |
OACT |
|
|
|
| CashDisAcc |
Cash Discount Account |
nVarChar |
15 |
OACT |
|
|
|
| DpmTaxOAcc |
Down Paymnt Tax Offset Account |
nVarChar |
15 |
OACT |
|
|
|
| VatDedAcc |
VAT Deductible Account |
nVarChar |
15 |
OACT |
|
|
|
| CstmExpAcc |
Customs VAT Expense Account |
nVarChar |
15 |
- |
|
|
|
| CstmAlcAcc |
Customs VAT Allocation Account |
nVarChar |
15 |
- |
|
|
|
| TaxRegion |
Tax Country Region |
nVarChar |
5 |
- |
PT |
PT |
Continental Portugal |
| |
|
|
|
|
|
PT-AC |
Azores Islands |
| |
|
|
|
|
|
PT-MA |
Madeira Islands |
| ExemReason |
Tax Exemption Reason |
nVarChar |
3 |
TXRE |
|
|
|
| Agent |
Agent |
VarChar |
1 |
- |
N |
Y |
Yes |
| |
|
|
|
|
|
N |
No |
| OpCode |
Tax Operation Code |
nVarChar |
7 |
- |
|
|
|
| Export |
Export |
VarChar |
1 |
- |
N |
Y |
Yes |
| |
|
|
|
|
|
N |
No |
| Section |
VAT Section |
nVarChar |
3 |
- |
|
|
|
| SplitPaymt |
Split Payment |
VarChar |
1 |
- |
N |
Y |
Yes |
| |
|
|
|
|
|
N |
No |
| SplitPayAc |
Split Payment Account |
nVarChar |
15 |
OACT |
|
|
|
| TaxAgent |
Tax Agent (Section 3) |
VarChar |
1 |
- |
N |
Y |
Yes |
| |
|
|
|
|
|
N |
No |
| SectionLim |
VAT Section (under limit) |
nVarChar |
3 |
- |
|
|
|
| VatSubjCod |
VAT Subject Code |
nVarChar |
10 |
- |
|
|
|
| VatType |
Type of VAT |
Int |
11 |
OBNI |
-1 |
|
|
| VatCategor |
VAT Category |
Int |
11 |
OBNI |
-1 |
|
|
| Parag44 |
Paragraph 44 |
VarChar |
1 |
- |
N |
Y |
Yes |
| |
|
|
|
|
|
N |
No |
| ProrataDed |
Pro-rata deductible |
VarChar |
1 |
- |
N |
Y |
Yes |
| |
|
|
|
|
|
N |
No |
| ExcFrmTaxS |
Exclude from Tax Summary Report Total A/R or A/P Net Amounts |
VarChar |
1 |
- |
N |
Y |
Yes |
| |
|
|
|
|
|
N |
No |
| CstmActing |
Customer Accounting |
VarChar |
1 |
- |
N |
Y |
Yes |
| |
|
|
|
|
|
N |
No |
| CstmActOut |
Customer Accounting Corresponding Tax Code |
nVarChar |
8 |
- |
|
|
|
| StdTaxCode |
Standard Tax Code |
nVarChar |
35 |
- |
|
|
|
| AcqRevTax |
Acquisition/Reverse Corresponding Tax Code |
nVarChar |
8 |
- |
|
|
|
| ExReasonHU |
Tax Exemption Reason |
nVarChar |
30 |
- |
|
|
|
| ExRemarkHU |
Tax Exemption Remark |
nVarChar |
50 |
- |
|
|
|
| EBVatCateg |
VAT Category |
Int |
11 |
- |
|
|
|
| SAFTTaxCod |
SAF-T Tax Code |
nVarChar |
10 |
- |
NOR |
RED |
Reduced Tax |
| |
|
|
|
|
|
INT |
Middle Tax |
| |
|
|
|
|
|
NOR |
Normal Tax |
| |
|
|
|
|
|
ISE |
Exempt |
| |
|
|
|
|
|
OUT |
Others |
| EBVatExCau |
VAT Exemption Cause |
Int |
11 |
OVEC |
|
|
|
| VatClasTyp |
VAT Expense Class. Type |
Int |
11 |
OECP |
|
|
|
| VatClasCat |
VAT Expense Class. Category |
Int |
11 |
OECC |
|
|
|
| SAFTTxCdEx |
SAF-T Tax Code |
nVarChar |
10 |
OSTX |
NOR |
|
|