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

COMPANY..VAT00400 Table Definition

(COMPANY..)

4Penny.net

Field Definitions:

What is the 'source' column?

 Column NameData Type
Default Value
 Source
VATRPTID char
''

CCode char
''

Submission_Number char
''

Total_Sales_Tax numeric
0.00

EU_Purchases_Tax numeric
0.00

Total_Tax numeric
0.00

Total_Purchases_Tax numeric
0.00

Total_Tax_Due numeric
0.00

Total_Sales numeric
0.00

TOTPURCH numeric
0.00

Total_EU_Sales numeric
0.00

Total_EU_Purchases numeric
0.00

YEAR1 smallint
0
Year...(more) Join Now SY40101.YEAR1
VAT_Period smallint
0

VATReturn_FileName char
''

STRTNGDT datetime
'1/1/1900'

ENDINGDT datetime
'1/1/1900'

DEX_ROW_ID int
auto number (1,1)
Unique ide...(more) Join Now
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