Module List >
Module FA tables
FA00701
You are currently viewing the COMPANY
database.
Change
|
COMPANY..FA00701 Table Definition
(COMPANY..Asset Retirement Master WORK)
Field Definitions:
What is the 'source' column?
| 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
|
|
|
|
|