Module List >
Module FA tables
FA45000
You are currently viewing the COMPANY
database.
Change
|
COMPANY..FA45000 Table Definition
(COMPANY..Fixed Assets Report Options)
Field Definitions:
What is the 'source' column?
| FILEXPNM |
char(255)
''
|
|
|
|
|
| EXPTTYPE |
smallint
0
|
|
|
|
|
| ASKECHTM |
tinyint
0
|
|
|
|
|
| IFFILXST |
smallint
0
|
|
|
|
|
| PRNTOFIL |
tinyint
0
|
|
|
|
|
| PRTOPRTR |
tinyint
0
|
|
|
|
|
| PRTOSCRN |
tinyint
0
|
|
|
|
|
| PRNTTYPE |
smallint
0
|
|
|
|
|
| RPTGRIND |
smallint
0
|
|
|
|
|
| RTPACHIN |
smallint
0
|
|
|
|
|
| RTGRSBIN |
numeric(19,5)
0.00
|
|
|
|
|
| REPORTID |
smallint
0
|
|
|
|
|
| FAREPTNAME |
char(51)
''
|
|
|
|
|
| SORTBY |
smallint
0
|
|
|
|
|
| Sort_By_Value |
char(41)
''
|
|
|
|
|
| BOOKINDX |
int
0
|
|
|
|
|
| BOOKID |
char(15)
''
|
|
|
|
|
| CURRFISCALYR |
smallint
0
|
|
|
|
|
| Begin_Current_Fiscal_Yr |
datetime
'1/1/1900'
|
|
|
|
|
| End_Current_Fiscal_Year |
datetime
'1/1/1900'
|
|
|
|
|
| Second_Book_Index |
int
0
|
|
|
|
|
| Second_Book_ID |
char(15)
''
|
|
|
|
|
| Current_Fiscal_Year_2 |
smallint
0
|
|
|
|
|
| Second_Begin_Current_FY |
datetime
'1/1/1900'
|
|
|
|
|
| Second_End_Current_FY |
datetime
'1/1/1900'
|
|
|
|
|
| ACTIVE |
tinyint
0
|
p>Active:&...(more) Join Now
|
GL00100.ACTIVE
|
|
|
| RETIRED |
tinyint
0
|
|
|
|
|
| PARTIALOPEN |
tinyint
0
|
|
|
|
|
| Multicurrency_Information |
tinyint
0
|
|
|
|
|
| In_Detail |
tinyint
0
|
|
|
|
|
| Only_Not_Interfaced |
tinyint
0
|
|
|
|
|
| Start_Master_Asset_ID |
char(19)
''
|
|
|
|
|
| End_Master_Asset_ID |
char(19)
''
|
|
|
|
|
| Start_Asset_ID |
char(15)
''
|
|
|
|
|
| End_Asset_ID |
char(15)
''
|
|
|
|
|
| Start_Asset_ID_Suffix |
smallint
0
|
|
|
|
|
| End_Asset_ID_Suffix |
smallint
0
|
|
|
|
|
| Start_Asset_Description |
char(41)
''
|
|
|
|
|
| End_Asset_Description |
char(41)
''
|
|
|
|
|
| Start_Structure_ID |
char(31)
''
|
|
|
|
|
| End_Structure_ID |
char(31)
''
|
|
|
|
|
| STTCLSID |
char(15)
''
|
|
|
|
|
| ENDCLSID |
char(15)
''
|
|
|
|
|
| STTLOCID |
char(15)
''
|
|
|
|
|
| ENDLOCID |
char(15)
''
|
|
|
|
|
| Start_YTD_Depreciation |
numeric(19,5)
0.00
|
|
|
|
|
| End_YTD_Depreciation |
numeric(19,5)
0.00
|
|
|
|
|
| Start_LTD_Depreciation |
numeric(19,5)
0.00
|
|
|
|
|
| End_LTD_Depreciation |
numeric(19,5)
0.00
|
|
|
|
|
| Start_Net_Book_Value |
numeric(19,5)
0.00
|
|
|
|
|
| End_Net_Book_Value |
numeric(19,5)
0.00
|
|
|
|
|
| SSRCEDOC |
char(11)
''
|
|
|
|
|
| ENDSRCDC |
char(11)
''
|
|
|
|
|
| Start_GL_Account_Index |
int
0
|
|
|
|
|
| End_GL_Account_Index |
int
0
|
|
|
|
|
| Start_FA_Year |
smallint
0
|
|
|
|
|
| End_FA_Year |
smallint
0
|
|
|
|
|
| Start_FA_Period |
smallint
0
|
|
|
|
|
| End_FA_Period |
smallint
0
|
|
|
|
|
| Start_Property_Type |
smallint
0
|
|
|
|
|
| End_Property_Type |
smallint
0
|
|
|
|
|
| Start_Asset_Type |
smallint
0
|
|
|
|
|
| End_Asset_Type |
smallint
0
|
|
|
|
|
| Start_Asset_Quantity |
int
0
|
|
|
|
|
| End_Asset_Quantity |
int
0
|
|
|
|
|
| Start_Original_Life_Year |
smallint
0
|
|
|
|
|
| End_Original_Life_Years |
smallint
0
|
|
|
|
|
| Start_Original_Life_Days |
smallint
0
|
|
|
|
|
| End_Original_Life_Days |
smallint
0
|
|
|
|
|
| Start_Remaining_Life_Yea |
smallint
0
|
|
|
|
|
| End_Remaining_Life_Years |
smallint
0
|
|
|
|
|
| Start_Remaining_Life_Day |
smallint
0
|
|
|
|
|
| End_Remaining_Life_Days |
smallint
0
|
|
|
|
|
| Start_Depr_Method |
smallint
0
|
|
|
|
|
| End_Depreciation_Method |
smallint
0
|
|
|
|
|
| Start_Averaging_Conventi |
smallint
0
|
|
|
|
|
| End_Averaging_Convention |
smallint
0
|
|
|
|
|
| Start_Amortization_Code |
smallint
0
|
|
|
|
|
| End_Amortization_Code |
smallint
0
|
|
|
|
|
| Start_Retirement_Type |
smallint
0
|
|
|
|
|
| End_Retirement_Type |
smallint
0
|
|
|
|
|
| Start_Trx_Acct_Type |
smallint
0
|
|
|
|
|
| End_Trx_Acct_Type |
smallint
0
|
|
|
|
|
| Start_Cost_Basis |
numeric(19,5)
0.00
|
|
|
|
|
| End_Cost_Basis |
numeric(19,5)
0.00
|
|
|
|
|
| Start_Fiscal_Year_Added |
smallint
0
|
|
|
|
|
| End_Fiscal_Year_Added |
smallint
0
|
|
|
|
|
| Start_Place_in_Service |
datetime
'1/1/1900'
|
|
|
|
|
| End_Place_in_Service |
datetime
'1/1/1900'
|
|
|
|
|
| Start_PIS_Token |
char(25)
''
|
|
|
|
|
| End_PIS_Token |
char(25)
''
|
|
|
|
|
| Start_Acquisition_Date |
datetime
'1/1/1900'
|
|
|
|
|
| End_Acquisition_Date |
datetime
'1/1/1900'
|
|
|
|
|
| Start_Acq_Token |
char(25)
''
|
|
|
|
|
| End_Acq_Token |
char(25)
''
|
|
|
|
|
| Start_Date_Added |
datetime
'1/1/1900'
|
|
|
|
|
| End_Date_Added |
datetime
'1/1/1900'
|
|
|
|
|
| Start_Date_Added_Token |
char(25)
''
|
|
|
|
|
| End_Date_Added_Token |
char(25)
''
|
|
|
|
|
| Start_Fully_Depr_Date |
datetime
'1/1/1900'
|
|
|
|
|
| End_Fully_Depr_Date |
datetime
'1/1/1900'
|
|
|
|
|
| Start_Fully_DTD_Token |
char(25)
''
|
|
|
|
|
| End_Fully_DTD_Token |
char(25)
''
|
|
|
|
|
| Start_Retirement_Date |
datetime
'1/1/1900'
|
|
|
|
|
| End_Retirement_Date |
datetime
'1/1/1900'
|
|
|
|
|
| Start_Ret_Date_Token |
char(25)
''
|
|
|
|
|
| End_Ret_Date_Token |
char(25)
''
|
|
|
|
|
| Start_Transfer_Date |
datetime
'1/1/1900'
|
|
|
|
|
| End_Transfer_Date |
datetime
'1/1/1900'
|
|
|
|
|
| Start_Transfer_Date_Toke |
char(25)
''
|
|
|
|
|
| End_Transfer_Date_Token |
char(25)
''
|
|
|
|
|
| Start_Switchover_Date |
datetime
'1/1/1900'
|
|
|
|
|
| End_Switchover_Date |
datetime
'1/1/1900'
|
|
|
|
|
| Start_Switch_Date_Token |
char(25)
''
|
|
|
|
|
| End_Switch_Date_Token |
char(25)
''
|
|
|
|
|
| Start_GL_Intf_TRX_Date |
datetime
'1/1/1900'
|
|
|
|
|
| End_GL_Intf_TRX_Date |
datetime
'1/1/1900'
|
|
|
|
|
| Start_GL_Intf_Date_Token |
char(25)
''
|
|
|
|
|
| End_GL_Intf_Date_Token |
char(25)
''
|
|
|
|
|
| STBCHNUM |
char(15)
''
|
|
|
|
|
| ENDBNMBR |
char(15)
''
|
|
|
|
|
| FISCALYEAR |
smallint
0
|
|
|
|
|
| PROJFROM |
datetime
'1/1/1900'
|
|
|
|
|
| PROJTO |
datetime
'1/1/1900'
|
|
|
|
|
| FA_Depreciation_As_Of |
smallint
0
|
|
|
|
|
| DEX_ROW_ID |
int
auto number (1,1)
|
Unique ide...(more) Join Now
|
|
|
|
| FA_Depreciation_As_Of_Dt |
datetime
'1/1/1900'
|
|
|
|
|
| FA_Calc_With_Reset_Amts |
tinyint
0
|
|
|
|
|
| FA_Display_Reset_Amounts |
tinyint
0
|
|
|
|
|
|