Module List >
Module VAT tables
TX00300
You are currently viewing the COMPANY
database.
Change
|
COMPANY..TX00300 Table Definition
(COMPANY..taxReturn)
Field Definitions:
What is the 'source' column?
| Tax_Return_ID |
char(21)
''
|
|
|
|
|
| STRTDATE |
datetime
'1/1/1900'
|
Start Date...(more) Join Now
|
UPR00100.STRTDATE
|
|
|
| ENDDATE |
datetime
'1/1/1900'
|
End Date: ...(more) Join Now
|
SOP00300.ENDDATE
|
|
|
| Tax_Return_Description |
char(51)
''
|
|
|
|
|
| Total_Sales_Tax |
numeric(19,5)
0.00
|
|
|
|
|
| EU_Purchases_Tax |
numeric(19,5)
0.00
|
|
|
|
|
| Total_Tax |
numeric(19,5)
0.00
|
|
|
|
|
| Total_Purchases_Tax |
numeric(19,5)
0.00
|
|
|
|
|
| Total_Tax_Due |
numeric(19,5)
0.00
|
|
|
|
|
| Total_Sales |
numeric(19,5)
0.00
|
|
|
|
|
| TOTPURCH |
numeric(19,5)
0.00
|
Total Purc...(more) Join Now
|
POP10160.TOTPURCH
|
|
|
| Total_EU_Sales |
numeric(19,5)
0.00
|
|
|
|
|
| Total_EU_Purchases |
numeric(19,5)
0.00
|
|
|
|
|
| NOTEINDX |
numeric(19,5)
0.00
|
Note Index...(more) Join Now
|
|
|
join ... more text available
|
| DEX_ROW_ID |
int
auto number (1,1)
|
Unique ide...(more) Join Now
|
|
|
|
| Final_Return |
tinyint
0
|
|
|
|
|
| Resubmission |
tinyint
0
|
|
|
|
|
| Submission_Number |
char
''
|
|
|
|
|
| VATReturn_FileName |
char
''
|
|
|
|
|
| YEAR1 |
smallint
0
|
Year...(more) Join Now
|
SY40101.YEAR1
|
|
|
| VAT_Period |
smallint
0
|
|
|
|
|
|