Module List > Module VAT tables TX00300
You are currently viewing the COMPANY database.
Change

COMPANY..TX00300 Table Definition

(COMPANY..taxReturn)

4Penny.net

Field Definitions:

What is the 'source' column?

 Column NameData Type
Default Value
 Source
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

Table Definition Quick Links
All Tables
SOP Tables
RM Tables
GL Tables
POP Tables
HR Tables
PM Tables
UPR Tables
IV Tables
Olympic Tables
3