Module List > Module FA tables FA01401
You are currently viewing the COMPANY database.
Change

COMPANY..FA01401 Table Definition

(COMPANY..Asset Purchase Master WORK)

4Penny.net

Field Definitions:

What is the 'source' column?

 Column NameData Type
Default Value
 Source
ASSETINDEX int
0

PURCHLINESEQ int
0

PURCHDESC char(41)
''

Acquisition_Cost numeric(19,5)
0.00

Orig_Acquisition_Cost numeric(19,5)
0.00

VENDORID char(15)
''
Vendor ID:...(more) Join Now PM10000.VENDORID
join ... more text available
DOCNUMBR char(21)
''
Document N...(more) Join Now PM10000.DOCNUMBR
DOCDATE datetime
'1/1/1900'
The date a...(more) Join Now
TRXSORCE char(13)
''
Transactio...(more) Join Now
ORCTRNUM char(21)
''
Originatin...(more) Join Now GL10001.ORCTRNUM
FA_AP_Post_Index int
0

PORDNMBR char(21)
''
Purchase O...(more) Join Now PM10000.PORDNMBR
CURNCYID char(15)
''
Currency I...(more) Join Now CM20000
join ... more text available
CURRNIDX smallint
0
Currency I...(more) Join Now CM20200.CURRNIDX
join ... more text available
XCHGRATE numeric(19,7)
0.00
Exchange R...(more) Join Now CM20200.XCHGRATE
EXCHDATE datetime
'1/1/1900'
Exchange D...(more) Join Now CM20200.EXCHDATE
TIME1 datetime
'1/1/1900'
Time see ...(more) Join Now CM20200.TIME1
EXGTBLID char(15)
''
Exchange T...(more) Join Now CM20200.EXGTBLID
RATETPID char(15)
''
A valid Ra...(more) Join Now
RTCLCMTD smallint
0
Rate Calcu...(more) Join Now CM20200.RTCLCMTD
DENXRATE numeric(19,7)
0.00
Denominati...(more) Join Now CM20200.DENXRATE
MCTRXSTT smallint
0
MC Transac...(more) Join Now CM20200.MCTRXSTT
LASTMNTDDATE datetime
'1/1/1900'

LASTMNTDTIME datetime
'1/1/1900'

LASTMNTDUSERID char(15)
''

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