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

COMPANY..FA00904 Table Definition

(COMPANY..Asset Financial Detail Master WORK)

4Penny.net

Field Definitions:

What is the 'source' column?

 Column NameData Type
Default Value
 Source
FINANCIALINDX int
0

ASSETINDEX int
0

BOOKINDX int
0

FA_Doc_Number char
''

TRANSDATESTAMP datetime
'1/1/1900'

TRANSTIMESTAMP datetime
'1/1/1900'

FISCALYRADDED smallint
0

FAYEAR smallint
0

FAPERIOD smallint
0

DEPRFROMDATE datetime
'1/1/1900'

DEPRTODATE datetime
'1/1/1900'

AMOUNT numeric(19,5)
0.00

TRANSUSERID char(15)
''

SOURCDOC char(11)
''
Field values: 1= Invoice 2= Finance Charge 3= Miscellaneous Charges 4= Return 5= Credit Memo PP000001.SOURCDOC
TRANSACCTTYPE smallint
0

INTERFACEGL tinyint
0

GLINTTRXDATE datetime
'1/1/1900'

GLINTDATESTAMP datetime
'1/1/1900'

GLINTTIMESTAMP datetime
'1/1/1900'

GLINTACCTINDX int
0

GLINTBTCHNUM char(15)
''

DEX_ROW_ID int
auto number (1,1)
Unique ide...(more) Join Now
FA_Reset_Offset_Index int
0

FA_Reset_User_ID char
''

FA_Reset_Date datetime
'1/1/1900'

FA_Reset_Time datetime
'1/1/1900'

Ledger_ID smallint
0

REFRENCE char
''

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