Functional Description
Purpose
This function verifies that the parameters exist in a master file based on the Alias from the F00090
file.
Setup Notes and Prerequisites
None.
Special Logic
None.
Technical Specification
The function verifies that the Numeric field entered by the user exists in the F4101 if the Alias =
'ITM'.
The function verifies that the Numeric field entered by the user exists in the F1201 if the Alias =
'NUMB'.
The function verifies that the Alpha field entered by the user exists in the F08001 if the Alias =
'JBCD'.
The function verifies that the Alpha field entered by the user exists in the F08001 if the Alias =
'JBST'.
The function verifies that the Numeric field entered by the user exists in the F0101 if the Alias =
'AN8'.
The function verifies that the Alpha field entered by the user exists in the F4801 if the Alias =
'RORN'.
The function verifies that the Alpha field entered by the user exists in the F4801 if the Alias =
'RCTO'.
Retrievals:
1.) Supplemental Database Table (F00090).
SFN1- SDB Numeric Key Flag 1
SFN2- SDB Numeric Key Flag 2
SBA1- SDB Alpha Key Flag 1
SBA2- SDB Alpha Key Flag 2
^
D4101010 - Verify Supplemental Database
Parameters:
Data ItemData Structure Description I/0Required
SAL1Supplemental Database Alias 1 IY
SAL3Supplemental Database Alias 3
SBA1Supplemental Data Alpha Key 1 IY
SBN1Supplemental Data Numeric Key 1 IY
DTAIData Item ON
ERRCError Code ON
SAL2Supplemental Database Alias 2
SAL4Supplemental Database Alias 4
SBN2Supplemental Numeric Key 2 IY
SBA2Supplemental Data Alpha Key 2 IY
MCUCost Center
KCOCompany Key
^
Parameter Name | Data Item | Data Type | Req/Opt | I/O/Both |
---|---|---|---|---|
szSuppDatabaseAlias1 | SAL1 | char | NONE | NONE |
A data dictionary alias name for the first alphanumeric key of the generic supplemental database. Valid values for this key are defined in
| ||||
szSuppDatabaseAlias3 | SAL3 | char | NONE | NONE |
A data dictionary alias name for the first numeric key of the generic supplemental database. Valid values for this key are defined in the
| ||||
szSuppDataAlphaKey1 | 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
| ||||
mnSuppDataNumericKey1 | 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
| ||||
szDataItem | DTAI | char | NONE | NONE |
A code that identifies and defines a unit of information. It is an alphanumeric code up to 8 characters long that does not allow blanks or
| ||||
cErrorCode | ERRC | char | NONE | NONE |
This error code indicates if any errors occurred during the creation of the Trip Document Detail (F4914) records by the Delivery Document
| ||||
szSuppDatabaseAlias2 | SAL2 | char | NONE | NONE |
A data dictionary alias name for the second alphanumeric key of the generic supplemental database. Valid values for this key are defined
| ||||
szSuppDatabaseAlias4 | SAL4 | char | NONE | NONE |
A data dictionary alias name for the second numeric key of the generic supplemental database. Valid values for this key are defined in the
| ||||
mnSuppDataNumericKey2 | 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
| ||||
szSuppDataAlphaKey2 | 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
| ||||
szCostCenter | 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
| ||||
szCompanyKey | 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,
|
None |
None |