Module List >
Module FA tables
FA01100
You are currently viewing the COMPANY
database.
Change
|
COMPANY..FA01100 Table Definition
(COMPANY..FA-AP Post Master)
Field Definitions:
What is the 'source' column?
| FA_AP_Post_Index |
int
0
|
|
|
|
|
| MARKED |
tinyint
0
|
|
|
|
|
| FAPRIMARY |
smallint
0
|
|
|
|
|
| CNTRLTYP |
smallint
0
|
Control Ty...(more) Join Now
|
PM00400.CNTRLTYP
|
|
|
| APPLDAMT |
numeric(19,5)
0.00
|
Applied Am...(more) Join Now
|
RM10301.APPLDAMT
|
|
|
| ORAPPAMT |
numeric(19,5)
0.00
|
|
|
|
|
| Purchased_Quantity |
int
0
|
|
|
|
|
| Applied_Quantity |
int
0
|
|
|
|
|
| ASSETID |
char(15)
''
|
|
|
|
|
| ASSETIDSUF |
smallint
0
|
|
|
|
|
| SHRTNAME |
char(15)
''
|
Short Name...(more) Join Now
|
RM00101.SHRTNAME
|
|
|
| ASSETDESC |
char(41)
''
|
|
|
|
|
| EXTASSETDESC |
char(41)
''
|
|
|
|
|
| Master_Asset_ID |
char(19)
''
|
|
|
|
|
| STRUCTUREID |
char(31)
''
|
|
|
|
|
| ASSETCLASSID |
char(15)
''
|
|
|
|
|
| LOCATNID |
char(15)
''
|
Location I...(more) Join Now
|
UPR00100.LOCATNID
|
|
join ... more text available
|
| ACQDATE |
datetime
'1/1/1900'
|
|
|
|
|
| Acquisition_Cost |
numeric(19,5)
0.00
|
|
|
|
|
| Orig_Acquisition_Cost |
numeric(19,5)
0.00
|
|
|
|
|
| ASSETTYPE |
smallint
0
|
|
|
|
|
| PROPTYPE |
smallint
0
|
|
|
|
|
| ASSETQTY |
int
0
|
|
|
|
|
| ASSETBEGQTY |
int
0
|
|
|
|
|
| ASSETCURRMAINT |
numeric(19,5)
0.00
|
|
|
|
|
| ASSETYTDMAINT |
numeric(19,5)
0.00
|
|
|
|
|
| ASSETLTDMAINT |
numeric(19,5)
0.00
|
|
|
|
|
| LASTMAINTDATE |
datetime
'1/1/1900'
|
|
|
|
|
| ASSESSEDVALUE |
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
|
|
|
| PORDNMBR |
char(21)
''
|
Purchase O...(more) Join Now
|
PM10000.PORDNMBR
|
|
|
| PO_Line |
char(7)
''
|
|
|
|
|
| MFGRNAME |
char(25)
''
|
|
|
|
|
| SERLNMBR |
char(21)
''
|
Field Type...(more) Join Now
|
SVC30620.SERLNMBR
|
|
|
| MODELNUMBER |
char(21)
''
|
|
|
|
|
| WARRENTYDATE |
datetime
'1/1/1900'
|
|
|
|
|
| CUSTODIAN |
char(25)
''
|
|
|
|
|
| DATEADDED |
datetime
'1/1/1900'
|
|
|
|
|
| DELETEDATE |
datetime
'1/1/1900'
|
|
|
|
|
| Physical_Location_ID |
char(15)
''
|
|
|
|
|
| Asset_Label |
char(19)
''
|
|
|
|
|
| Verified_Date |
datetime
'1/1/1900'
|
|
|
|
|
| PIN |
char(15)
''
|
|
|
|
|
| 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
|
|
|
|
|