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

COMPANY..VAT00100 Table Definition

(COMPANY..)

4Penny.net

Field Definitions:

What is the 'source' column?

 Column NameData Type
Default Value
 Source
Submission_Number char
''

ElectronicVATStatus smallint
0

ElecVAT_FromDate datetime
'1/1/1900'

ElecVAT_ToDate datetime
'1/1/1900'

ElecVAT_SubmitDate datetime
'1/1/1900'

Submit_Time datetime
'1/1/1900'

ElecVAT_AcceptDate datetime
'1/1/1900'

Accepted_Time datetime
'1/1/1900'

Correlative_ID char
''

ElecVAT_ErrorDate datetime
'1/1/1900'

Error_Time datetime
'1/1/1900'

Average_Polling_Time smallint
0

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

DEX_ROW_ID int
auto number (1,1)
Unique ide...(more) Join Now
HMRC_Response text


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