P 2 K_AM_FUNCTIONS
Back to current versionRestore this version

Alias: MFN#

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)IDYlink to P2K_AM_PRODUCTS
MFN_IDNumber(10)ID link to P2K_AM_FUNCTIONS
DCR_IDNumber(10)ID link to 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 link to P2K_AM_TABLE_DETAILS
SPY_IDNumber(10)ID link 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

User Fields: Not Allowed
Audit Logging: Not Allowed

Screen captures are meant to be indicative of the concept being presented and may not reflect the current screen design.
If you have any comments or questions please email the Wiki Editor

All content © High Line Corporation