Module List > Module EDC tables EDCEI016
You are currently viewing the COMPANY database.
Change

COMPANY..EDCEI016 Table Definition

(COMPANY..)

4Penny.net

Field Definitions:

What is the 'source' column?

 Column NameData Type
Default Value
 Source
SERIES smallint
0
Seriesbr /...(more) Join Now GL20000.SERIES
DOCTYPE smallint
0
Document T...(more) Join Now PM30300.DOCTYPE
DOCNUMBR char
''
Document N...(more) Join Now RM20102.DOCNUMBR
SQNCLINE numeric
0.00
Sequence L...(more) Join Now PP50101.SQNCLINE
CUSTNMBR char
''
Customer N...(more) Join Now PA01101.CUSTNMBR
join ... more text available
CCode char
''

TXRGNNUM char
''
Tax Regist...(more) Join Now
TCC char
''

NUMASS numeric
0.00

QUANTITY numeric
0.00
QTY: The n...(more) Join Now SCSU0030.QUANTITY
LMASS numeric
0.00

TMCODE char
''

TRANSNATURE char
''

SUPPUNITS numeric
0.00

TRADREF char
''

GOODSVALUE numeric
0.00

TAXAMNT numeric
0.00
Tax Amount...(more) Join Now PA11801.TAXAMNT
NOTEINDX numeric
0.00
Note Index...(more) Join Now
join ... more text available
DOCDATE datetime
'1/1/1900'
The date a...(more) Join Now RM20101.DOCDATE
Tax_Date datetime
'1/1/1900'

Reference_Date datetime
'1/1/1900'

POSTED tinyint
0

VOIDSTTS smallint
0
1 = Voided...(more) Join Now PP100100.VOIDSTTS
ORGDSVAL numeric
0.00

ORTAXAMT numeric
0.00
Originatin...(more) Join Now
CURRNIDX smallint
0
Currency I...(more) Join Now RM20102.CURRNIDX
join ... more text available
ITEMNMBR char
''
span style...(more) Join Now JC00701.ITEMNMBR
join ... more text available
ITEMDESC char
''
Item Descr...(more) Join Now WO010116.ITEMDESC
PRT char
''

RGN char
''

CNTRYORGN char
''

PRCDRRGM char
''

INCTRMS char
''

STTSTCLVL numeric
0.00

ORGNTNGSTTSTCLVL numeric
0.00

DCLGDSVAL numeric
0.00

DCLTXAMT numeric
0.00

DCLSTVAL numeric
0.00

DECLID char
''

LOCNCODE char
''
Location C...(more) Join Now PA11801.LOCNCODE
join ... more text available
ARRDISP char
''

Included_On_Return tinyint
0

INTRSTTRTRNID char
''

PERIOD char
''

AUDITTRAIL char
''

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