D3800040 - Create Agreement Transaction Ledger
| Parameter Name | Data Item | Data Type | Req/Opt | I/O/Both |
|---|---|---|---|---|
| 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
| ||||
| szVersion | VERS | char | NONE | NONE |
A user-defined set of specifications that control how applications and reports run. You use versions to group and save a set of user-defined
| ||||
| cModeProcessing | MODE | char | NONE | NONE |
The processing mode used in Purchase Order Consolidator to signify when specific orders are being processed. | ||||
| szAgreementNumber | 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
| ||||
| mnAgreementSupplement | 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
| ||||
| 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
| ||||
| 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
| ||||
| mnQuantity | QTYW | MATH_NUMERIC | NONE | NONE |
The number of units that will be reworked as a result of receipt routing. | ||||
| szUnitOfMeasurePrimary | UOM1 | char | NONE | NONE |
A user defined code (00/UM) that identifies the unit of measure that the system uses to express the quantity of an item, for example, EA
| ||||
| mnDocumentOrderInvoiceE | DOCO | MATH_NUMERIC | NONE | NONE |
A number that identifies an original document. This document can be a voucher, a sales order, an invoice, unapplied cash, a journal entry,
| ||||
| szOrderType | DCTO | char | NONE | NONE |
A user defined code (00/DT) that identifies the type of document. This code also indicates the origin of the transaction. J.D. Edwards has
| ||||
| szCompanyKeyOrderNo | KCOO | char | NONE | NONE |
A number that, along with order number and order type, uniquely identifies an order document (such as a purchase order, a contract, a
| ||||
| mnLineNumber | LNID | MATH_NUMERIC | NONE | NONE |
A number that identifies multiple occurrences, such as line numbers on a purchase order or other document. Generally, the system assigns
| ||||
| cAgreementType | DMTC | char | NONE | NONE |
A user defined code that indicates the general type of the agreement. | ||||
| 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
| ||||
| mnRelatedAddressNo | AN8R | MATH_NUMERIC | NONE | NONE |
Use this field to relate a ship-to address to a sold-to address or vice versa.
For example, if you enter only a ship-to address in sales order
| ||||
| 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
| ||||
| szCompany | CO | char | NONE | NONE |
A code that identifies a specific organization, fund, or other reporting entity. The company code must already exist in the Company
| ||||
| szLocation | LOCN | char | NONE | NONE |
The storage location from which goods will be moved. | ||||
| szLot | LOTN | char | NONE | NONE |
A number that identifies a lot or a serial number. A lot is a group of items with similar characteristics. | ||||
| cTypeAgreementAdjustment | TCAJ | char | NONE | NONE |
A user defined code (system 38/type CA) that indicates the type, cause, or reason for an adjustment to an agreement. | ||||
| jdDateTransactionJulian | TRDJ | JDEDATE | NONE | NONE |
The date that an order was entered into the system. This date determines which effective level the system uses for inventory pricing. | ||||
| jdDateAdjustment | ADJJ | JDEDATE | NONE | NONE |
The date that the adjustment was made. | ||||
| mnDocVoucherInvoiceE | DOC | MATH_NUMERIC | NONE | NONE |
A number that identifies the original document, such as a voucher, invoice, or journal entry. On entry forms, you can assign the document
| ||||
| szDocumentType | DCT | char | NONE | NONE |
A user defined code (00/DT) that identifies the origin and purpose of the transaction. PeopleSoft reserves several prefixes for document
| ||||
| szCompanyKey | KCO | char | NONE | NONE |
A number that, with the document number, document type and G/L date, uniquely identifies an original document, such as invoice, voucher,
| ||||
| mnJournalEntryLineNo | JELN | MATH_NUMERIC | NONE | NONE |
A number that designates a line within a journal entry. The system uses this field to sequence the journal entry lines for inquiry purposes. | ||||
| szVehicleId | VEHI | char | NONE | NONE |
A unique identification number for a vehicle. This number serves as a primary identifier for a vehicle. | ||||
| szCostCenterTrip | VMCU | char | NONE | NONE |
Indicates the depot from which a trip originates. The Trip Depot and the Trip Number fields identify the unique combination of vehicle,
| ||||
| mnTripNumber | TRP | MATH_NUMERIC | NONE | NONE |
The number assigned to a trip during direct assignment or trip building. The Trip Depot and the Trip Number fields identify the unique
| ||||
| mnCompartmentNumber | CMPN | MATH_NUMERIC | NONE | NONE |
The unique identifier associated with one of the storage compartments of this vehicle. Some vehicles (especially those designed to carry
| ||||
| 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
| ||||
| 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
| ||||
| 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
| ||||
| szExplanationTransaction | TREX | char | NONE | NONE |
Text that identifies the reason that a transaction occurred. | ||||
| 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
| ||||
| 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). | ||||
| mnTemperature | TEMP | MATH_NUMERIC | NONE | NONE |
The temperature of the product. | ||||
| cStrappingTemperatureUnit | STPU | char | NONE | NONE |
A code used to identify the type of temperature. Valid values are: F Fahrenheit C Celsius | ||||
| szBlock | BLK1 | char | NONE | NONE |
A field used in location reporting. The block is used in conjunction with the lot and unit to describe a parcel of land, usually within a
| ||||
| mnDensity | DNTY | MATH_NUMERIC | NONE | NONE |
Identifies your company's standard for density. You can also use this field for pack size and weight information. | ||||
| cDensityTypeAtStandardTem | DNTP | char | NONE | NONE |
A code used to identify the type of density. Valid values are: A Absolute Density G API Specific Gravity R Relative Density | ||||
| szCompositeKeyBlock2 | BLK2 | char | NONE | NONE |
A Composite Key Block contains a number of individual key values which have been combined into one field. This process is generally
| ||||
| mnDensityTemperature | DETP | MATH_NUMERIC | NONE | NONE |
Indicates the temperature at which the density was measured. The system uses the density temperature type from Branch/Plant Constants -
| ||||
| cDensityTemperatureUnit | DTPU | char | NONE | NONE |
Identifies the type of temperature. Valid values are: F Fahrenheit C Celsius | ||||
| szCompositeKeyBlock3 | BLK3 | char | NONE | NONE |
A Composite Key Block contains a number of individual key values which have been combined into one field. This process is generally
| ||||
| mnAmbientResult | AMBR | MATH_NUMERIC | NONE | NONE |
The volume as measured for density and temperature prior to conversion. You can enter the ambient quantity or let the system
| ||||
| szUnitofMeasureAmbientVolu | AMBU | char | NONE | NONE |
A user defined code (system 00, type UM) that identifies the unit of measurement for pressure, volume, weight, diameter, or height. | ||||
| mnVolumeCorrectionFactors | VCF | MATH_NUMERIC | NONE | NONE |
A calculated number to convert ambient volume to volume at standard density and temperature. This value identifies the primary stock
| ||||
| mnStockTotalVolume | STOK | MATH_NUMERIC | NONE | NONE |
The volume after it has been converted to a standard base. Conversions are made according to published standard routines for density
| ||||
| szUnitofMeasure4 | BUM4 | char | NONE | NONE |
A user defined code (system 00, type UM) that identifies the unit of measurement for pressure, volume, weight, diameter, or height.
Note that
| ||||
| mnWeightResult | WGTR | MATH_NUMERIC | NONE | NONE |
The weight of the product at standard temperature. The system calculates the weight by multiplying the volume by the density and applying
| ||||
| szUnitofMeasure5 | BUM5 | char | NONE | NONE |
A user defined code (system 00, type UM) that identifies the unit of measurement for pressure, volume, weight, diameter, or height.
Note that
| ||||
| mnStockTotalinPrimaryUOM | STUM | MATH_NUMERIC | NONE | NONE |
The quantity as converted to the primary stock accounting unit of measure identified for this item (product). This primary stock accounting
| ||||
| szUnitofMeasure6 | BUM6 | char | NONE | NONE |
A user defined code (system 00, type UM) that identifies the unit of measurement for pressure, volume, weight, diameter, or height.
Note that
| ||||
| 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
| ||||
| mnAmountUnitCost | UNCS | MATH_NUMERIC | NONE | NONE |
The amount per unit, derived by dividing the total cost by the unit quantity. | ||||
| mnAmtExtendedCost | PAID | MATH_NUMERIC | NONE | NONE |
The extended cost or price value of an inventory transaction for an inventory item. | ||||
| jdDtForGLAndVouch1 | DGL | JDEDATE | NONE | NONE |
A date that identifies the financial period to which the transaction is to be posted.
The company constants specify the date range for each
| ||||
| mnBatchNumber | ICU | MATH_NUMERIC | NONE | NONE |
A number that identifies a group of transactions that the system processes and balances as a unit. When you enter a batch, you can either
| ||||
| szBatchType | ICUT | char | NONE | NONE |
A code that specifies the system and type of transactions entered in a batch. The system assigns the value when you enter a transaction.
| ||||
| szGlCategory | GLPT | char | NONE | NONE |
A user defined code (41/9) that identifies the G/L offset that system uses when it searches for the account to which it posts the transaction. If
| ||||
| mnUniqueKeyIDInternal | UKID | MATH_NUMERIC | NONE | NONE |
This field is a unique number used to identify a record in a file. | ||||
| cUpdateGeneralLedger | UPGL | char | NONE | NONE |
Indicates when the system updates the general ledger. Valid values are:
Y Journal entries will be written as soon as the quantity moves
| ||||
| szReasonCode | RCD | char | NONE | NONE |
A user defined code (42/RC) that explains the purpose for a transaction. For example, you can indicate the reason that you are returning
| ||||
| cCreatePO | CRPO | char | NONE | NONE |
A flag used to denote whether purchase order is to be created. | ||||
| cCreateSO | CRSO | char | NONE | NONE |
A flag that identifies if the system should create a sales order from the adjustment information. Valid values are:
Y or 1
Yes, create a
| ||||
| cCloseContractFlag | CDMC | char | NONE | NONE |
Use this flag to denote whether an agreement is closed. | ||||
| jdDateCancellation | CAND | JDEDATE | NONE | NONE |
The date on which the agreement was or will be cancelled. If an agreement is cancelled, it is considered an inactive agreement. | ||||
| szCancellationReason | CANR | char | NONE | NONE |
Reason code for cancellation of this agreement. | ||||
| 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
| ||||
| szCurrencyCodeFrom | CRCD | char | NONE | NONE |
A code that identifies the currency of a transaction. | ||||
| cBulkPackedFlag | BPFG | char | NONE | NONE |
A code that indicates if the item is a bulk liquid product. If it is a bulk product, you must perform temperature and density/gravity
| ||||
| mnSequenceNumber1 | SEQ | MATH_NUMERIC | NONE | NONE |
A number that specifies the sequence of information. | ||||
| cVolumeAdjusttoZero | ADZR | char | NONE | NONE |
A flag used to indicate whether the contract should be adjusted to a zero value when the contract period is complete. | ||||
| szWorkStationId | JOBN | char | NONE | NONE |
The code that identifies the work station ID that executed a particular job. | ||||
| cReconciliationStatus | RECS | char | NONE | NONE |
Identifies whether the reading has been reconciled. Valid values are:
Y The record has been fully reconciled.
N The record has not been
| ||||
| mnStockTotalinPrimaryUOM_2 | STUM | MATH_NUMERIC | NONE | NONE |
The quantity as converted to the primary stock accounting unit of measure identified for this item (product). This primary stock accounting
| ||||
| jdDateStockValuationPosted | SVPD | JDEDATE | NONE | NONE |
Date of posting for stock valuation expressed in the Julian format. | ||||
| cStockValuationPosted | SVPF | char | NONE | NONE |
Flag indicating whether or not stock valuation has been posted. Values Y and 1 indicate posted, N or 0 indicate not posted. | ||||
| mnTimeOfDay | TDAY | MATH_NUMERIC | NONE | NONE |
The computer clock in hours:minutes:seconds. | ||||
| jdDateUpdated | UPMJ | JDEDATE | NONE | NONE |
The date that specifies the last update to the file record. | ||||
| szUserId | USER | char | NONE | NONE |
The code that identifies a user profile. | ||||
| cErrorCode1 | ERRC | char | NONE | NONE |
This error code indicates if any errors occurred during the creation of the Trip Document Detail (F4914) records by the Delivery Document
| ||||
| cErrorCode_2 | ERRC | char | NONE | NONE |
This error code indicates if any errors occurred during the creation of the Trip Document Detail (F4914) records by the Delivery Document
| ||||
| None |
| None |