!!!Alias: MFN
(P2K_AM_FUNCTIONS)

Unique Keys: [FUNCTION_NAME]

ERD: [ERD-AM15]

A component of a product - can be screens, report

!!Table Columns
||Column name||Data Type / Size||Domain||Mand.||Notes
|[ID]|Number(10)|[ID]|Y|
|[FUNCTION_NAME]|Varchar2(30)|[VARCHAR30|VARCHARnn]|Y|
|[MPD_ID]|Number(10)|[ID]|Y|part of [P2K_AM_PRODUCTS]
|[MFN_ID]|Number(10)|[ID]| |extended by another [P2K_AM_FUNCTIONS]
|[DCR_ID]|Number(10)|[ID]| |default [P2K_CM_CHANGE_REASONS]
|[CREATE_USER]|Varchar2(30)|[VARCHAR30|VARCHARnn]|Y|
|[CHANGE_DATE]|Date()|[DATE]|Y|
|[CREATE_DATE]|Date()|[DATE]|Y|
|[CHANGE_USER]|Varchar2(30)|[VARCHAR30|VARCHARnn]|Y|
|[DESCRIPTION]|Varchar2(50)|[DESCRIPTION]|Y|
|[FUNCTION_TYPE]|Varchar2(2)|[X_FUNCTION_TYPE]|Y|
|[FUNCTION_USAGE]|Varchar2(2)|[X_FUNCTION_USAGE]|Y|
|[FUNCTION_LEVEL]|Varchar2(2)|[X_FUNCTION_LEVEL]| |
|[IMPLEMENTATION_NAME]|Varchar2(200)|[VARCHAR200|VARCHARnn]| |
|[COMPUTER_LANGUAGE]|Varchar2(2)|[X_COMPUTER_LANGUAGE]| |
|[PLSQL_BLOCK]|Varchar2(30)|[VARCHAR30|VARCHARnn]| |
|[MENU_SEQUENCE]|Number(5)|[NUMBER5|NUMBERn]| |
|[CREATE_ALLOWED]|Varchar2(1)|[TOGGLE]| |
|[RETRIEVE_ALLOWED]|Varchar2(1)|[TOGGLE]| |
|[UPDATE_ALLOWED]|Varchar2(1)|[TOGGLE]| |
|[DELETE_ALLOWED]|Varchar2(1)|[TOGGLE]| |
|[WHERE_RUN]|Varchar2(2)|[X_WHERE_RUN]| |
|[PRINT_ORIENTATION]|Varchar2(9)|[X_PRINT_ORIENTATION]| |
|[PURPOSE]|Varchar2(2000)|[VARCHAR2000|VARCHARnn]| |
|[ONLINE_OFFLINE]|Varchar2(2)|[X_ONLINE_OFFLINE]| |
|[REPORT_MODE]|Varchar2(10)|[X_REPORT_MODE]| |
|[FUNCTION_STYLE]|Varchar2(2)|[X_FUNCTION_STYLE]| |
|[PA_ALLOWED]|Varchar2(1)|[TOGGLE]| |
|[WEB_ADDRESS]|Varchar2(200)|[URL]| |
|[MTD_ID]|Number(10)|[ID]| |maintains [P2K_AM_TABLE_DETAILS]
|[SPY_ID]|Number(10)|[ID]| |associated to [P2K_SA_PA_TYPES]
|[MLOV_ID]|Number(10)|[ID]| |link to [P2K_AM_LIST_OF_VALUES]
|[DESTINATION_FORMAT]|Varchar2(10)|[X_DESFORMAT]| |
|[PROCESS_CANCEL_ALLOWED]|Varchar2(1)|[TOGGLE]| |
|[REQUIRES_LOGIN]|Varchar2(1)|[TOGGLE]| |

!![Derived Fields|DERIVED FIELDS]
||Column Name
|[DRV_COPY_AS_USER_DEFINED]



User Fields: Not Allowed\\
Audit Logging: Not Allowed\\


----
![Notes|Edit:Internal.P2K_AM_FUNCTIONS] 	
[{InsertPage page='Internal.P2K_AM_FUNCTIONS' default='Click to create a new notes page'}]