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 |