Functional Description
Purpose
This function will run an application based on the parameters: Supplemental
Database Code,
Type of Data, Business Unit, Key Company, Numeric Key 1, Numeric Key 2, Alpha Key
2,
application ID, form ID and version.
Setup Notes and Prerequisites
Special Logic
Technical Specification
Parameters
Data Item Data Structure Description I/O Required Notes
SDB Supplemental Database Code I Y
TYDT Type of Data I Y
MCU Business Unit I Y
KCO Key Company I Y
SBA1 Alpha Key 1 I Y
SBA2 Alpha Key 2 I Y
SBN1 Numeric Key 1 I Y
SBN2 Numeric Key 2 I Y
Related Tables
F00091 - Supplemental Database Data Types
F00090 - Supplemental Database Setup
Related Business Fuctions
Processing
Use Supplemental Database Code to retrieve key Alias (Key can no more than 3
aliases) from F00090.
Do dynamic resolution of the retrieved alias and the form variable (form variable
could be MCU, KCO,
SBA1, SBA2, SBN1, SBN2).
If the variable fits tha alias, create data structure using that alias.
Use Start_Form_Dynamic with the data structure created. Pass in the application
ID, form ID,
and (optional) version from the F00091.
^
D4101000 - F00092, Run Program From Supplement Database
Parameters
Data Item Data Structure Description I/O Required Notes
SDB Supplemental Database Code I Y
TYDT Type of Data I Y
MCU Business Unit I Y
KCO Key Company I Y
SBA1 Alpha Key 1 I Y
SBA2 Alpha Key 2 I Y
SBN1 Numeric Key 1 I Y
SBN2 Numeric Key 2 I Y
^
Parameter Name | Data Item | Data Type | Req/Opt | I/O/Both |
---|---|---|---|---|
szSupplementalDatabaseCode | SDB | char | NONE | NONE |
A user defined code (00/SD) that sets up databases for groups of related supplemental data types. This code differentiates the
| ||||
szDataType | TYDT | char | NONE | NONE |
A code that you assign to supplemental data so that you can group data by categories. Valid values include:
A
Approval steps
B
Requisition
| ||||
szBranchPlant | MCU | char | NONE | NONE |
An alphanumeric code that identifies a separate entity within a business for which you want to track costs. For example, a business unit
| ||||
szKeyCompany | KCO | char | NONE | NONE |
A number that, with the document number, document type and G/L date, uniquely identifies an original document, such as invoice, voucher,
| ||||
szAlphaKey1 | SBA1 | char | NONE | NONE |
This field specifies one of the alphanumeric keys to the Generic Supplmental Database. The key may be selected from a list of supported
| ||||
szAlphaKey2 | SBA2 | char | NONE | NONE |
This field specifies one of the alphanumeric keys to the Generic Supplmental Database. The key may be selected from a list of supported
| ||||
mnNumericKey1 | SBN1 | MATH_NUMERIC | NONE | NONE |
This field specifies one of the numeric keys to the Generic Supplemental Database. You can select the key from a list of supported data
| ||||
mnNumericKey2 | SBN2 | MATH_NUMERIC | NONE | NONE |
This field specifies one of the numeric keys to the Generic Supplmental Database. The key may be selected from a list of supported data
|
None |
F00090 Supplemental Database Setup | ||||
F00091 Supplemental Database Data Types | ||||
F9865 Form Information File |