Functional Description
Purpose
This function will validate whether or not a record exists in the F00092 for SDB and TYDT.
Setup Notes and Prerequisites
None
Special Logic
None
Technical Specifications
This function fetchs on F00092 based on Index and Keys passed in:
Index = 1 : Keys =1 :DSDB
2 :DSDB and TYDB
^
D4100820 - Verify And Get Item Supplement Database - User Define Codes
Parameter Name | Data Item | Data Type | Req/Opt | I/O/Both |
---|---|---|---|---|
cDistributionDatabase | DSDB | char | NONE | NONE |
The code representing what Distribution Data Base is to be used. Currently,only the Inventory Supplemental Data Base is available. This
| ||||
szTypeData | TYDB | char | NONE | NONE |
A code that you enter to distinguish the type of data that you later enter in the Supplemental Database. This user defined code is often an
| ||||
mnShortItemNumber | ITM | MATH_NUMERIC | NONE | NONE |
An inventory item number. The system provides three separate item numbers plus an extensive cross-reference capability to other item
| ||||
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
| ||||
szUserDefineCode | KY | char | NONE | NONE |
A list of valid codes for a specific user defined code list. | ||||
jdEffectiveDate | EFT | JDEDATE | NONE | NONE |
The date that identifies when a date is first valid. The effective date is used generically. It can be a lease effective date, a price or cost
| ||||
jdEndEffectiveDate | EFTE | JDEDATE | NONE | NONE |
The date on which the item, transaction, or table becomes inactive, or through which you want transactions to appear. This field is used
| ||||
mnAmountUserDefined | AMTU | MATH_NUMERIC | NONE | NONE |
A quantity that represents the statistical or measurable information related to the code that is defined for the data type. For example, if the
| ||||
szRemark1 | RMK | char | NONE | NONE |
A generic field that you use for a remark, description, name, or address. | ||||
szRemark2 | RMK2 | char | NONE | NONE |
A generic field that you use for a remark, description, name, or address. | ||||
jdUpdatedDate | UPDJ | JDEDATE | NONE | NONE |
A date that can be used with supplemental data information. For example, you can enter a verification date in this field to show when
| ||||
mnIndex | CDL | MATH_NUMERIC | NONE | NONE |
The length of the user defined code. It cannot be greater than 10 characters. | ||||
mnKeys | CDL | MATH_NUMERIC | NONE | NONE |
The length of the user defined code. It cannot be greater than 10 characters. | ||||
cCallType | EV01 | char | NONE | NONE |
An option that specifies the type of processing for an event. | ||||
cSuppressErrorMessage | EV01 | char | NONE | NONE |
An option that specifies the type of processing for an event. | ||||
szErrorMessageID | 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
|
None |
F41092 Item Supplemental Data Base User Defined Codes |