Functional Description
Purpose
This function fetches, changes, adds or deletes records to the Supplier Catalog table (F41061).
Setup Notes and Prerequisites
The Address Number (AN8), Item Number (ITM), Branch/Plant (MCU), Currency Code (CRCD), Unit of
Measure (UOM), Expired Date (EXDJ), Catalog Number (CATN) and Quantity (UORG) are required parameters.
Access Method:
F= Fetch
D= Delete
U= Update
I= Insert
Special Logic:
None
Technical Specification
This function fetches, deletes, updates or inserts records to the database based on the Access Method
passed in. The record is fetched from the Supplier Catalog table with the keys passed in and the
appropriate action is taken.
Edits:
None.
Retrievals:
AccessMethod:F)etch
D)elete
U)pdate
I)nsert
Use the values of each key field to access the database table. Use the GetAuditInfo function to stamp
the user jobn, updj, and tday in the record for update and insert.
Returns:
Return the ErrorMessage when the SetGBRError is set to 1, else set the Error.
^
D4100250 - Access Record In F41061
Parameters:
Data Item Data Structure DescriptionI/ORequired
AN8AddressNumberI/0Y
ITMItemNumberI/0Y
MCUBusinessUnitI/0Y
CRCDCurrencyCodeI/0Y
UOMUnitOfMeasureI/0Y
EXDJExpiredDateI/0Y
CATNCatalogNumberI/0Y
UORGQuantityI/0Y
LITM2ndItemNumberI/0N
AITM3rdItemNumberI/0N
PRRCUnitCostI/0N
EFTJEffectiveDateI/0N
PIDProgramIDI/0N
EV01SetGBRErrorI/0N
DTAIErrorMessageI/0N
ERRAccessMethodI/0N
^
Parameter Name | Data Item | Data Type | Req/Opt | I/O/Both |
---|---|---|---|---|
mnAddressNumber | AN8 | MATH_NUMERIC | NONE | NONE |
A number that identifies an entry in the Address Book system, such as employee, applicant, participant, customer, supplier, tenant, or
| ||||
mnItemNumber | 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
| ||||
szBusinessUnit | 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
| ||||
szCurrencyCode | CRCD | char | NONE | NONE |
A code that identifies the currency of a transaction. | ||||
szUnitOfMeasure | UOM | char | NONE | NONE |
A user defined code (00/UM) that indicates the quantity in which to express an inventory item, for example, CS (case) or BX (box). | ||||
jdExpiredDate | EXDJ | JDEDATE | NONE | NONE |
The date on which a transaction, text message, agreement, obligation, or preference has expired or been completed. | ||||
szCatalogNumber | CATN | char | NONE | NONE |
This is a grouping of suppliers and items for pricing purposes. | ||||
mnQuantity | UORG | MATH_NUMERIC | NONE | NONE |
The quantity of units affected by this transaction. | ||||
sz2ndItemNumber | LITM | char | NONE | NONE |
A number that identifies the item. The system provides three separate item numbers plus an extensive cross-reference capability to
| ||||
sz3rdItemNumber | AITM | char | NONE | NONE |
The system provides three separate item numbers plus an extensive cross-reference capability to alternate item numbers. These item
| ||||
mnUnitCost | PRRC | MATH_NUMERIC | NONE | NONE |
The unit cost of one item, as purchased from the supplier, excluding freight,taxes, discounts, and other factors that might modify the actual
| ||||
jdEffectiveDate | EFTJ | JDEDATE | NONE | NONE |
The date when a transaction, contract, obligation, preference, or policy rule becomes effective. | ||||
szProgramID | PID | char | NONE | NONE |
The number that identifies the batch or interactive program (batch or interactive object). For example, the number of the Sales Order Entry
| ||||
cSetGBRError | EV01 | char | NONE | NONE |
An option that specifies the type of processing for an event. | ||||
szErrorMessage | 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
| ||||
cAccessMethod | ERR | char | NONE | NONE |
The Data Field Error Code field is simply a generic data field to pass an error condition flag. This field is one of the fields that make up the
|
B9800100 Get Audit Information |
F41061 Supplier Price/Catalog File |