Named ER Specification
Source NameN3800100DesignerMarie Midgley
Data Structure D3800100AProgrammerMarie Midgley
Function NameF38012GetSourceDestinationInfoSystem Code38
Function DescriptionF38012 Get Source/Destination Info Function Category
Function Use
Revisions Log
Modifications bySAR NumberDescription
6/12/98Marie Midgley1765283Created
Functional Description
1.1Purpose
The purpose of this Named ER is to retrieve data from the F38010. F38012, F38011.
Setup Notes and Prerequisites
Called in Agreement Quantity Schedule application in Post Dialog
2.2Special Logic
Technical Specifications
2.2Parameters:
Data Item Data Structure DescriptionI/ORequiredNotes
DMCTAgreement NumberIYes
DMCSAgreement Number SuppIYes
PSRProduct SourceINo
PSRYProduct Source TypeIYes
SEQSequence NumberIYes
DL01DesciptionONo
DESDestinationONo
DESYDestination TypeONo
ITMShort Item NumberONo
CRCDCurrency Code FromONo
MCUBranch / PlantONo
DTODue ToONo
UOMUnit of MeasureONo
CNQYContract Qty TypeONo
DMTCContract TypeONo
CNQTContract QuantityONo
AAAmountONo
DL01DescriptionNo
DL02DescriptionNo
EFTJEffective DateONo
EFDJExpired DateONo
2.2Related Tables
Table Table Description
F38010Agreement Master
F38011Agreement Quantities
F38012Agreement Source/Destination
2.3Related Business Functions
Source NameFunction Name
2.4Processing
F38010.Fetch Single
F38012.Fetch Single
If SV File_IO_Status is equal to CO SUCCESS
F38011.Fetch Single
End If
^
D3800100A - F38012 Get Source/Destination Information
Parameter Name | Data Item | Data Type | Req/Opt | I/O/Both |
---|---|---|---|---|
szAgreementNumber | DMCT | char | OPT | NONE |
A unique number your company assigns to identify a particular agreement. You might want to assign some significance to the agreement
| ||||
mnAgreementSupplement | DMCS | MATH_NUMERIC | OPT | NONE |
The supplement number records any changes or addendum to agreements that occur over time or by item. It can also indicate individual
| ||||
szSource | PSR | char | OPT | NONE |
A value that identifies the location that supplies the item to fulfill the agreement. The value must match the Source Type code, as follows:
o
| ||||
szSourceType | PSRY | char | OPT | NONE |
A code that specifies the type of source entered in the Transaction Source field, as follows:
o If the transaction source is an address book
| ||||
mnSequenceNumber1 | SEQ | MATH_NUMERIC | OPT | NONE |
A number that specifies the sequence of information. | ||||
szAgreementDescription | DL01 | char | OPT | NONE |
A user defined name or remark. | ||||
szDestination | DES | char | OPT | NONE |
A value that identifies where an item on the agreement is delivered. This required field must match the Destination Type code, as follows:
| ||||
szDestinationType | DESY | char | OPT | NONE |
A code that identifies the type of destination. Valid values are:
AB The destination must be an Address Book number.
CC The destination
| ||||
mnShortItem | ITM | MATH_NUMERIC | OPT | NONE |
An inventory item number. The system provides three separate item numbers plus an extensive cross-reference capability to other item
| ||||
szAgreementCurrecny | CRCD | char | OPT | NONE |
A code that identifies the currency of a transaction. | ||||
szBusinessUnit | MCU | char | OPT | NONE |
An alphanumeric code that identifies a separate entity within a business for which you want to track costs. For example, a business unit
| ||||
cDueTo | DTO | char | OPT | NONE |
A code that identifies which partner is due to receive the listed item. Valid values are:
C Company - Your company expects to receive
| ||||
szUOM | UOM | char | OPT | 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). | ||||
cAgreementQuantityType | CNQY | char | OPT | NONE |
A code that indicates if this agreement is based on quantity by item or currency amount. Valued values are:
Q Quantity
A Currency
| ||||
cAgreementType | DMTC | char | OPT | NONE |
A user defined code that indicates the general type of the agreement. | ||||
mnAgreementQuantity | CNQT | MATH_NUMERIC | OPT | NONE |
The gross quantity for the life of the contract. | ||||
mnQuantityAmount | AA | MATH_NUMERIC | OPT | NONE |
A number that identifies the amount that the system will add to the account balance of the associated account number. Enter credits with a
| ||||
szSourceDescription | DL01 | char | OPT | NONE |
A user defined name or remark. | ||||
szDestinationDescription | DL02 | char | OPT | NONE |
Additional text that further describes or clarifies a field in the system. | ||||
jdEffectiveDate | EFTJ | JDEDATE | OPT | NONE |
The date when a transaction, contract, obligation, preference, or policy rule becomes effective. | ||||
jdExpiredDate | EFDJ | JDEDATE | OPT | NONE |
The date when a transaction, contract, obligation, preference, or policy rule ceases to be in effect. |
None |
None |