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

COMPANY..FA00701 Table Definition

(COMPANY..Asset Retirement Master WORK)

4Penny.net

Field Definitions:

What is the 'source' column?

 Column NameData Type
Default Value
 Source
RETIREMENTINDX int
0

RETIRESEQ smallint
0

RETIREEVENT int
0

ASSETINDEX int
0

ASSETID char(15)
''

RETDATESTAMP datetime
'1/1/1900'

RETTIMESTAMP datetime
'1/1/1900'

RETIREMENTTYPE smallint
0

RETIREMENTDATE datetime
'1/1/1900'

RETIREMENTCODE char(9)
''

CASHPROCEEDS numeric(19,5)
0.00

Orig_Cash_Proceeds numeric(19,5)
0.00

NONCASHPROCEEDS numeric(19,5)
0.00

Orig_Non_Cash_Proceeds numeric(19,5)
0.00

EXPOFSALE numeric(19,5)
0.00

Orig_Expenses_of_Sale numeric(19,5)
0.00

PARTIALQTY int
0

PARTIALCOST numeric(19,5)
0.00

PARTIALPCT smallint
0

ASSETINDXAFTRET int
0

NOTEINDX numeric(19,5)
0.00
Note Index...(more) Join Now
join ... more text available
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