Alias: MFN#

(P2K_AM_FUNCTIONS)

Unique Keys: FUNCTION_NAME

ERD: ERD-AM15

A component of a product - can be screens, report

Table Columns#

Column nameData Type / SizeDomainMand.Notes
IDNumber(10)IDY
FUNCTION_NAMEVarchar2(30)VARCHAR30Y
MPD_IDNumber(10)IDYpart of P2K_AM_PRODUCTS
MFN_IDNumber(10)ID extended by another P2K_AM_FUNCTIONS
DCR_IDNumber(10)ID default P2K_CM_CHANGE_REASONS
CREATE_USERVarchar2(30)VARCHAR30Y
CHANGE_DATEDate()DATEY
CREATE_DATEDate()DATEY
CHANGE_USERVarchar2(30)VARCHAR30Y
DESCRIPTIONVarchar2(50)DESCRIPTIONY
FUNCTION_TYPEVarchar2(2)X_FUNCTION_TYPEY
FUNCTION_USAGEVarchar2(2)X_FUNCTION_USAGEY
FUNCTION_LEVELVarchar2(2)X_FUNCTION_LEVEL
IMPLEMENTATION_NAMEVarchar2(200)VARCHAR200
COMPUTER_LANGUAGEVarchar2(2)X_COMPUTER_LANGUAGE
PLSQL_BLOCKVarchar2(30)VARCHAR30
MENU_SEQUENCENumber(5)NUMBER5
CREATE_ALLOWEDVarchar2(1)TOGGLE
RETRIEVE_ALLOWEDVarchar2(1)TOGGLE
UPDATE_ALLOWEDVarchar2(1)TOGGLE
DELETE_ALLOWEDVarchar2(1)TOGGLE
WHERE_RUNVarchar2(2)X_WHERE_RUN
PRINT_ORIENTATIONVarchar2(9)X_PRINT_ORIENTATION
PURPOSEVarchar2(2000)VARCHAR2000
ONLINE_OFFLINEVarchar2(2)X_ONLINE_OFFLINE
REPORT_MODEVarchar2(10)X_REPORT_MODE
FUNCTION_STYLEVarchar2(2)X_FUNCTION_STYLE
PA_ALLOWEDVarchar2(1)TOGGLE
WEB_ADDRESSVarchar2(200)URL
MTD_IDNumber(10)ID maintains P2K_AM_TABLE_DETAILS
SPY_IDNumber(10)ID associated to P2K_SA_PA_TYPES
MLOV_IDNumber(10)ID link to P2K_AM_LIST_OF_VALUES
DESTINATION_FORMATVarchar2(10)X_DESFORMAT
PROCESS_CANCEL_ALLOWEDVarchar2(1)TOGGLE new in 40800

Derived Fields#

Column Name
DRV_COPY_AS_USER_DEFINED

User Fields: Not Allowed
Audit Logging: Not Allowed