DB Column | Object | DB Column Default Value |
3D_CAD_METADATA_DOCTYPE | Document Title | Define the document type that should be used for the CAD integration meta data storage. File types connected to the document typed defined by 3D_CAD_METADATA_DOCTYPE will always be saved in the database repository. The value to be set would be the value “ETRAGE”. If a generating database repository is not found, an error will be raised. |
ALLOW_INS_OBSOLETE_CHILD_DOC | Document Title | Determines whether it should be possible to insert an obsolete document as child under a new parent document, and also whether we should copy the obsolete child documents when creating a new revision. The value can only be set centrally (Document Basic/Document Default Values tab) and cannot be set for each class. |
ALLOW_UPD_COMMENT_REL_DOC | Document Revision | Determines whether it will be possible to add, update and delete a comment file when the document is in Approved or Released statuses. Possible values are Y(es)and N(o). Default value is N. |
APPROVAL_TEMPLATE | Approval Routing | This value determines if and which approval template is automatically attached to a new document. This applies only the first time, when creating the title. When creating new document revisions or new sheets, approval templates will not be attached. |
ATTACH_CREATE_NEW_FORM | Create Document Dialog | This value determines the dialog that will be opened when the New button in the Documents Attachment panel is clicked. Possible values are Create Document Assistant, Create New Document and Create Documents. |
ATTACH_DROP_SINGLE_FILE_FORM | Create Document Dialog | This value determines the dialog that will be opened when a single file is dragged and dropped into the Documents Attachment panel. Possible values are Create Document Assistant, Create New Document and Create Documents. |
CHECK_FILE_EMPTY | Document Revision | This value is used to check if the document has a checked in file when approving a document. Possible values are Y(es)and N(o). Default value is Y. This value can be set only centrally (Document Basic/Document Default Values tab) and cannot be set for each class. |
DAYS_EXPIRED | Document Revision | Default number of days before an obsolete document has expired. |
DOCUMENT_TICKET_TEMP_PATH | Document Revision |
When performing file operations in Document Management through the ifsfileservice servlet (also known as the FTS – File Transfer Service),
the ticket folder should be created in a common path that all cluster environment nodes can access.
The path should be the exact same one as was entered during installation of the server. e.g:- \\Server\Share\Folder |
DOC_CLASS | Create Document Dialog | This value is used as the default value for the document class in the Create Documents and Create New Document dialogs in the Windows client. The value can only be set centrally (Document Basic/Document Default Values tab) and cannot be set for each class. |
DOC_CLASS | Create New Document Wizard | This value is used for the default value for the document class in the Create Document Assistant in the Windows client. The value can only be set centrally (Document Basic/Document Default Values tab) and cannot be set for each class. |
DOC_CLASS | Doc File Import | The default document class to be used when importing files using the File Import window/page in the Windows and Web clients. The value can only be set centrally (Document Basic/Document Default Values tab) and cannot be set for each class. |
DOC_DIST_IMMEDIATELY | Doc Dist Engine | Controls whether the Execute Immediately check box in the Document Distribution Wizard is selected or not by default. The value can only be set centrally (Document Basic/Document Default Values tab) and cannot be set for each class. |
DOC_INFO_ALT_LAYOUT | Document Revision | Defines the value of the alternate screen layout. Alternate screen layouts are used to create custom layouts for the Document Revision window. If this field is empty, the alternate screen layout option will not be available. If a value is given in this field, it should also be given as the Process for the Target field in the Properties of the new navigator item when creating a alternate layout. The value can only be set centrally (Document Basic/Document Default Values tab) and cannot be set for each class. |
DOC_ISSUE_MANDATORY_FIELDS | Document Revision | Defines the mandatory fields that should have values to query in the Document Revision page. If this value is empty, querying in the Document Revision page will be performed without any checks for mandatory fields or values. Enter the fields in the following format: DOC_CLASS^DOC_NO^DOC_SHEET^DOC_REV^. The value can only be set centrally (Document Basic/Document Default Values tab) and cannot be set for each class. |
DOC_REV | Document Title | Default first document revision. E.g., A1. |
DOC_SHEET | Document Title | Default sheet number for the first document sheet. E.g., 1. |
FILE_IMPORT_TITLE_PATTERN | Doc File Import | Pattern used to format the titles of documents created using File Import. Put %f in place of the file name being imported. Other text is taken as it is. Example: Imported file %f, might produce a title Import file my_document. Notice that the file extension is stripped. |
FILE_PATH_FOR_BATCH_TRANSFER | Batch Transfer Handler | This value is used when you use the wizard to transfer documents from one repository to another. It points out a directory on the extended server where the files are stored temporarily when they are moved. The value can only be set centrally (Document Basic/Document Default Values tab) and cannot be set for each class |
FIRST_SHEET_ORDER | Document Title | Default sheet order number of the first document sheet. E.g., 10. |
FORMAT_MANDATORY | Document Revision | Determines whether the format should be entered or not when creating a new document revision. |
FORMAT_SIZE | CreateDocumentDialog | This value is used as the default value for the document format when using the drag-and-drop functionality in the Windows client and the Office Add-In feature in the Windows and Web clients. The value can only be set centrally (Document Basic/Document Default Values tab) and cannot be set for each class. |
FORMAT_SIZE | Doc File Import | This value is to be used as default format size when importing files using the File Import window/page in the Windows and Web clients. The value can only be set centrally (Document Basic/Document Default Values tab) and cannot be set for each class. |
IFS_CAD_DB_ALIAS | Document Revision | This field determines the Oracle tnsnames alias used in document macros for IFS CAD applications. |
KEEP_LAST_DOC_REV | Document Reference Object | The field determines what happens to the connected object when a new document revision is created. Values are (single letter): F(ixed) = object remains with current revision. L(atest Revision) = object moves to latest revision. Latest R(eleased) = object moves to latest released revision. |
LANGUAGE_CODE | DocLanguage | Default language for new document issues. The value must be an ISO language code that has been registered in Application Services. E.g., en (English). |
LIMIT_NORMAL_STATE_CHANGES | DocIssue | This value is used when doing a status change of large number of documents to approved state or released state. The value determines the minimum number of documents for which the system automatically creates a background job. Values must be between 1 and 100. Can only be set centrally (Document Basic/Document Default Values tab) and cannot be set for each class. |
LMT_OBJ_CON_SHOW_WIZARD | Document Revision | This value is used when a new sheet or revision is created or when a document is released. The value determines the maximum number of object connections that will be displayed in the wizard. If the number of object connections is greater than the specified number, the objects will not be displayed in the wizard and the user have to select an option which will affect all the object connections. Can only be set centrally (Document Basic/Document Default Values tab) and cannot be set for each class. Possible values are between 2 and 9999. |
MAKE_WASTE_REQ | Document Title | The value specifies if revisions and their copies are to be deleted when the document title is obsolete or has expired. Values are: Y(es) = revisions and possible copies outside the system should be deleted. N(o) = no action is required. This default value is for informational purposes only and affects nothing else in the system. |
NO_OF_PRELIMINARY_REVISIONS | Document Revision | This field sets the preliminary revision control of a document sheet. MANY = Can have as many revisions as you like in preliminary status. ONE = Can have only one preliminary revision of a document sheet. |
NO_OF_RELEASED_REVISIONS | Document Revision | This field sets the released revision control of a document sheet. MANY = Can have as many revisions as you like in released status. ONE = Can have only one released revision of a document sheet. |
NUMBER_COUNTER | Document Title | Specifies the default number counter used for advanced number generation. Enter the default value for the ID1of the number counter. E.g, Drawings. |
NUMBER_GENERATOR | Document Title | Specifies if the advanced document number generator is used. Values are: ADVANCED = used. STANDARD = not used. |
OBJ_CONN_REQ | Document Title | This field determines if a document title must be connected to a business object before it can be released. The values are: Y(es) = an object must be connected. N(o) = document can be released without a connected business object. |
REDIRECT_WEB_LINKS_TO_IEE | Document Revision | The value in this field determines whether the file operations view, edit and check in when performed in the Web client should be redirected to the Enterprise Explorer client. When configured, the file operation will be redirected even when the user is accessing the document through a link that has been created for the document. Possible values are Y (Yes) and N (No). The default value is N. |
REP_ARCH_DEL_OBSOLETE_REVS | Document Title |
If this is set to Y (yes) then the previous
revisions will also be deleted after being set to obsolete. Related to Business Analytics. |
REP_ARCH_NO_DEL_ON_PARAM_CHG | Document Title |
If there was a change in the report parameters,
previous obsolete revisions will not be deleted if this setting is set to Y (yes). Related to Business Analytics. |
REP_ARCH_SET_PREV_OBSOLETE | Document Title | This value is used when IFS Document Management stores an Excel report from Business Analytics. It controls whether previous revisions of the document will be set to obsolete or not when a new revision is created. |
RESTRICTED_ACCESS | Document Title | This setting determines if general information about the document should be hidden from Persons without access to it. If Y is entered, only Persons who have at least View Access will see that a document even exists. If N is selected, Persons without access to the document will still be able to see its general information. The value can be set centrally or per document class. |
SAFETY_COPY_REQ | Document Title | This field specifies the document title's requirements for the creation of a safety copy. Valid values are N(o) and Y(es). If this field is set to Y(es), a safety copy is required for this document title. This field is for informational purposes only and affects nothing else in the system. |
SET_APPROVED_SEC_CHKPT | Document Revision | This field determines if the Security Checkpoint dialog will be shown to the user (requiring authentication) when trying to approve a document. Y(es) = Checkpoint is enabled. N(o) = Checkpoint is disabled. |
SHEET_ORDER_STEP | Document Title | Determines how much the sheet sort order value is increased each time a new sheet is created for a document title. Use the value 10 to allow for the creation of in-between sheets. |
STRUCTURE | Document Title | Determines if the structure attribute will be selected or not selected by default. The value can be set centrally or per document class. Typically set this to Y(es) for classes where you often handle structure documents. |
SYSCFG_SHARED_PATH_APPSERVER | Document Revision | System parameter. The directory where the application server (FNDEXT) looks for a file to check in or places file for check out. There is one value for each client here, and all should point to the same physical directory. The reason there are more than one value is that the directories might need to look different on different operating systems. The value can only be set centrally (Document Basic/Document Default Values tab) and cannot be set for each class. |
SYSCFG_SHARED_PATH_FNDWEB | Document Revision | System parameter. The directory where the Web client (FNDWEB) looks for file to check in or places file for check out. There is one value for each client here, and all should point to the same physical directory. The reason there are more than one value is that the directories might need to look different on different operating systems. The value can only be set centrally (Document Basic/Document Default Values tab) and cannot be set for each class. |
SYSCFG_SOX_LOG_EXPIRE_DAYS | Edm Op File Announce | Controls how old records in the File Operation Log window can become before they are expired (removed). The value can only be set centrally (Document Basic/Document Default Values tab) and cannot be set for each class. |
TRANSMITTAL_ACK_CLASS | DocumentTransmittal | Document class used when a transmittal acknowledgement is checked in. The value can only be set centrally (Document Basic/Document Default Values tab) and cannot be set for each class. |
TRANSMITTAL_REPORT_CLASS | DocumentTransmittal | Document class used when a transmittal report is checked in. The value can only be set centrally (Document Basic/Document Default Values tab) and cannot be set for each class. |
UPDATE_DURING_APPROVAL | Document Title | This will control if the Update during Approval check box in the Document Revision window should be selected by default or not. Possible values are Y and N. |
UPD_APPR_OR_REL_ALLOWED | Document Title | This field determines if a document title with Released or Approved revisions is allowed to be edited. Y(es) = Edits allowed. N(o) = Edits not allowed. |
VIEW_FILE_REQ | Document Title | Specifies the default value for the View Copy requirement for document titles. Values for each new document revision are: Y(es) = a view copy (PDF) is required. N(o) = no view copy required. |
WEB_SITE_ADDRESS | Document Revision | Defines the web address of the server where IFS Applications web is installed. The value can only be set centrally (Document Basic/Document Default Values tab) and cannot be set for each class. |