D3800030 - F38012 Retrieve Parent /Child Records
Parameter Name | Data Item | Data Type | Req/Opt | I/O/Both |
---|---|---|---|---|
cLastCacheRecordRead | EV01 | char | NONE | NONE |
An option that specifies the type of processing for an event. | ||||
idCursorPointer | GENLNG | ID | NONE | NONE |
General purpose ID variable. | ||||
mnContractSupplementDistri | DMCS | MATH_NUMERIC | NONE | NONE |
The supplement number records any changes or addendum to agreements that occur over time or by item. It can also indicate individual
| ||||
szContractNumberDistributi | DMCT | char | NONE | NONE |
A unique number your company assigns to identify a particular agreement. You might want to assign some significance to the agreement
| ||||
mnIdentifierShortItem | 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
| ||||
jdDateEffectiveJulian1 | EFTJ | JDEDATE | NONE | NONE |
The date when a transaction, contract, obligation, preference, or policy rule becomes effective. | ||||
jdDateExpiredJulian1 | EXDJ | JDEDATE | NONE | NONE |
The date on which a transaction, text message, agreement, obligation, or preference has expired or been completed. | ||||
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
| ||||
cDueTo | DTO | char | NONE | NONE |
A code that identifies which partner is due to receive the listed item. Valid values are:
C Company - Your company expects to receive
| ||||
mnContractQuantity | CNQT | MATH_NUMERIC | NONE | NONE |
The gross quantity for the life of the contract. | ||||
szParentContractNumber | PAGM | char | NONE | NONE |
A number that identifies a parent agreement for the displayed agreement. Use the parent agreement and supplement numbers to define a
| ||||
mnParentContractSupplement | PAGS | MATH_NUMERIC | NONE | NONE |
Used to record changes or addenda to agreements that occur over time or by product. It can also indicate individual agreements tied to a
| ||||
szProductSourceType | PSRY | char | NONE | 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
| ||||
szProductSource | PSR | char | NONE | 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
| ||||
mnAmountField | AA | MATH_NUMERIC | NONE | 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
| ||||
cPriceatAmbiantorStandard | PRAS | char | NONE | NONE |
Identifies the price extension calculation method. Valid Values are:
A Unit price X delivered volume at ambient temperature
S Unit price X
| ||||
mnLevelIndented | LV | MATH_NUMERIC | NONE | NONE |
A number indicating the level of a child in the relationship to its parent in a hierarchy. | ||||
mnJobnumberA | JOBS | MATH_NUMERIC | NONE | NONE |
The job number (work station ID) which executed the particular job. | ||||
mnQuantityTransaction | TRQT | MATH_NUMERIC | NONE | NONE |
A value that represents the available quantity, which might consist of the on-hand balance minus commitments, reservations, and
| ||||
mnCommittedQuantity | QCOM | MATH_NUMERIC | NONE | NONE |
Current balance of agreement transactions which have been committed. | ||||
mnBalanceQuantity | QBAL | MATH_NUMERIC | NONE | NONE |
Current balance of agreement transactions which have been posted. | ||||
mnScheduledQuantity_2 | CNQT | MATH_NUMERIC | NONE | NONE |
The gross quantity for the life of the contract. | ||||
cModeProcessing | MODE | char | NONE | NONE |
The processing mode used in Purchase Order Consolidator to signify when specific orders are being processed. | ||||
szDestination | DES | char | NONE | 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 | NONE | NONE |
A code that identifies the type of destination. Valid values are:
AB The destination must be an Address Book number.
CC The destination
| ||||
szUnitOfMeasureAsInput | 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). | ||||
cReverseQuantity | EV01 | char | NONE | NONE |
An option that specifies the type of processing for an event. | ||||
mnTransactionAmount | AA | MATH_NUMERIC | NONE | 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
| ||||
mnCommittedAmount | AA | MATH_NUMERIC | NONE | 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
| ||||
mnBalanceAmount | AA | MATH_NUMERIC | NONE | 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
| ||||
mnScheduledAmount | AA | MATH_NUMERIC | NONE | 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
| ||||
mnAddressNumber | AN8 | MATH_NUMERIC | OPT | NONE |
A number that identifies an entry in the Address Book system, such as employee, applicant, participant, customer, supplier, tenant, or
| ||||
mnLevelIndented_2 | LV | MATH_NUMERIC | OPT | NONE |
A number indicating the level of a child in the relationship to its parent in a hierarchy. | ||||
szCurrencyCodeFrom | CRCD | char | OPT | NONE |
A code that identifies the currency of a transaction. |
None |
F38010 Agreement Master | ||||
F38012 Product Source/Destination Master | ||||
F38013 Agreement Quantities Schedule | ||||
F38111 Agreements Transaction Ledger | ||||
F38112 Agreements Committed Quantities |