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

COMPANY..FA01100 Table Definition

(COMPANY..FA-AP Post Master)

4Penny.net

Field Definitions:

What is the 'source' column?

 Column NameData Type
Default Value
 Source
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
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