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

COMPANY..VAT10302 Table Definition

(COMPANY..VAT_INTRA_WORK)

This table contains intrastat information associated with an EC Transaction record. There may be multiple records in this table for each EC Transaction. In SBF, this table is not available. Multiple currencies are not supported in SBF.


4Penny.net

Field Definitions:

What is the 'source' column?

 Column NameData Type
Default Value
 Source
SERIES smallint
0
Series: In...(more) Join Now
DOCTYPE smallint
0
Document T...(more) Join Now
DOCNUMBR char(21)
''
Document N...(more) Join Now
SQNCLINE numeric(19,5)
0.00
Sequence L...(more) Join Now
CUSTNMBR char(15)
''
Customer N...(more) Join Now
join ... more text available
CCode char(7)
''
Country Co...(more) Join Now
TXRGNNUM char(25)
''
Tax Regist...(more) Join Now
TCC char(31)
''
Tax Commod...(more) Join Now
NUMASS numeric(19,5)
0.00
Net Unit M...(more) Join Now
QUANTITY numeric(19,5)
0.00
QTY: This ...(more) Join Now
LMASS numeric(19,5)
0.00
Line Mass:...(more) Join Now
TMCODE char(7)
''
Transport ...(more) Join Now
TRANSNATURE char(7)
''
Transactio...(more) Join Now
SUPPUNITS numeric(19,5)
0.00
Supplement...(more) Join Now
TRADREF char(21)
''
Traders Re...(more) Join Now
GOODSVALUE numeric(19,5)
0.00
Goods Valu...(more) Join Now
TAXAMNT numeric(19,5)
0.00
Tax Amount...(more) Join Now
NOTEINDX numeric(19,5)
0.00
Note Index...(more) Join Now
join ... more text available
DOCDATE datetime
'1/1/1900'
Document D...(more) Join Now
Tax_Date datetime
'1/1/1900'
Tax Date: ...(more) Join Now
Reference_Date datetime
'1/1/1900'
Reference ...(more) Join Now
POSTED tinyint
0
Posted: Tr...(more) Join Now
VOIDSTTS smallint
0
Void Statu...(more) Join Now
ORGDSVAL numeric(19,5)
0.00
Originatin...(more) Join Now
ORTAXAMT numeric(19,5)
0.00
Originatin...(more) Join Now
CURRNIDX smallint
0
Currency I...(more) Join Now
join ... more text available
ITEMNMBR char(31)
''
Item Numbe...(more) Join Now
join ... more text available
ITEMDESC char(101)
''
Item Descr...(more) Join Now
PRT char(7)
''
Port: Port...(more) Join Now
RGN char(7)
''
Region: Re...(more) Join Now
CNTRYORGN char(7)
''
Country Or...(more) Join Now
PRCDRRGM char(7)
''
Procedure/...(more) Join Now
INCTRMS char(7)
''
Incoterms:...(more) Join Now
STTSTCLVL numeric(19,5)
0.00
Statistica...(more) Join Now
ORGNTNGSTTSTCLVL numeric(19,5)
0.00
Originatin...(more) Join Now
Included_On_Return tinyint
0
Included o...(more) Join Now
INTRSTTRTRNID char(21)
''
Intrastat ...(more) Join Now
DECLID char(15)
''
Declarant ...(more) Join Now
LOCNCODE char(11)
''
Location C...(more) Join Now
join ... more text available
ARRDISP char(1)
''
Arrival/De...(more) Join Now
PERIOD char(5)
''
Period: Th...(more) Join Now
AUDITTRAIL char(13)
''
Audit Trai...(more) Join Now
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