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 |