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

COMPANY..EDCEI019 Table Definition

(COMPANY..)

4Penny.net

Field Definitions:

What is the 'source' column?

 Column NameData Type
Default Value
 Source
SOPNUMBE char
''

SOPTYPE smallint
0

DOCID char
''

join ... more text available
BACHNUMB char
''
Batch Numb...(more) Join Now
join ... more text available
DOCDATE datetime
'1/1/1900'
The date a...(more) Join Now RM20101.DOCDATE
EXCHDATE datetime
'1/1/1900'
Exchange D...(more) Join Now MC00100.EXCHDATE
POSTEDDT datetime
'1/1/1900'
Posted Date The system date at the time the transaction iso psted B3950340.POSTEDDT
CUSTNMBR char
''
Customer N...(more) Join Now PA01101.CUSTNMBR
join ... more text available
CUSTNAME char
''

CURNCYID char
''
Currency I...(more) Join Now RM20102.CURNCYID
join ... more text available
CURRNIDX smallint
0
Currency I...(more) Join Now RM20102.CURRNIDX
join ... more text available
SUBTOTAL numeric
0.00

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