D41B0240A - Cache Process Bulk Transactions
Parameter Name | Data Item | Data Type | Req/Opt | I/O/Both |
---|---|---|---|---|
szCacheActionCode | CACTN | char | NONE | NONE |
A code that indicates the activity you want to perform. Valid codes:
o Get - Retrieve the cache element
o Add - Add a cache element
o
| ||||
mnNumberKeys | NKEYS | MATH_NUMERIC | NONE | NONE |
The number of keys in an index that will be used to retrieve, delete, or update a record. | ||||
cSuppressErrorMessage | EV01 | char | NONE | NONE |
An option that specifies the type of processing for an event. | ||||
szErrorMessageID | DTAI | char | NONE | NONE |
A code that identifies and defines a unit of information. It is an alphanumeric code up to 8 characters long that does not allow blanks or
| ||||
idCacheCursor | GENLNG | ID | NONE | NONE |
General purpose ID variable. | ||||
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,
| ||||
szTankID | TKID | char | NONE | NONE |
An 8-character field identifying the tank as defined on the Branch/Plant Constants form. | ||||
szMeterNumber | METN | char | NONE | NONE |
Identifies the meter. | ||||
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. | ||||
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
| ||||
mnNoOfLinesOnOrder | NLIN | MATH_NUMERIC | NONE | NONE |
A number representing the number of lines on either a purchase or sales order.
or The number of receivers recorded during the receipts
| ||||
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
| ||||
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. | ||||
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
| ||||
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
| ||||
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
| ||||
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 | ||||
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 | ||||
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 | ||||
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
| ||||
szUnitofMeasure3 | BUM3 | 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
| ||||
mnVolumeAmbientInInventory | AMBI | MATH_NUMERIC | NONE | NONE |
The ambient quantity (prior to conversion to standard volume) which has been converted to the inventory unit of measure for that item. | ||||
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
| ||||
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
| ||||
cUpdateControlFlag | UPCF | char | NONE | NONE |
Controls whether to update the General Ledger (G/L) for commingled product.
Typically, you update the G/L for the product that belongs to
| ||||
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. | ||||
cLotStatusCode | LOTS | char | NONE | NONE |
A user defined code (41/L) that indicates the status of the lot. If you leave this field blank, it indicates that the lot is approved. All other codes
| ||||
jdDateLayerExpiration | MMEJ | JDEDATE | NONE | NONE |
The date on which a lot of items expires.
The system automatically enters this date if you have specified the shelf life days for the item on
| ||||
mnAmountUnitCost | UNCS | MATH_NUMERIC | NONE | NONE |
The amount per unit, derived by dividing the total cost by the unit quantity. | ||||
mnAmountExtendedCost | ECST | MATH_NUMERIC | NONE | NONE |
For accounts receivable and accounts payable, the invoice (gross) amount. For sales orders and purchase orders, the unit cost times the
| ||||
szExplanationTransaction | TREX | char | NONE | NONE |
Text that identifies the reason that a transaction occurred. | ||||
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
| ||||
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
| ||||
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
| ||||
cAirCorrectYN | ACOR | char | NONE | NONE |
Indicates if an air correction must be applied in the volume-to-weight conversion. The weight in air of a liquid differs from its mass (weight in
| ||||
cHydrometerCorrection | HCOR | char | NONE | NONE |
Indicates whether this product must include the appropriate stem correction for the thermal expansion of the glass hydrometer. Valid values
| ||||
cDipType | DIPT | char | NONE | NONE |
A user defined code (system 39/type DP) that identifies the method of measurement that the system uses to calculate the volume from tank
| ||||
mnGrossDip | GDIP | MATH_NUMERIC | NONE | NONE |
This number represents the total dip reading of a tank. (Net volume = Gross dip volume - Water dip volume + Other volumes.) | ||||
mnWaterDip | WDIP | MATH_NUMERIC | NONE | NONE |
This number represents the total dip reading of water in the tank.
(Net volume = gross dip volume - water dip volume + other
| ||||
mnVapourPressure | VAPP | MATH_NUMERIC | NONE | NONE |
This is the observed LPG vapour pressure. The system compares this value to the equilibrium vapour pressure to check for inert gases.
| ||||
szPressureUnitofMeasure | PREU | char | NONE | NONE |
A code BG (Barg - Bar Gauge) is used to identify the unit of measurement for pressure. | ||||
mnLPGVapourTemperature | LPGV | MATH_NUMERIC | NONE | NONE |
At the item level, this is the standard vapour temperature. The observed temperature of the vapour in the LPG tank is recorded as part of
| ||||
cTemperatureUnitLPGVapour | TPU1 | char | NONE | NONE |
A code used to identify the type of temperature. F Fahrenheit C Celsius | ||||
cSlipTubeReadingType | SLIP | char | NONE | NONE |
This field is used when recording a dip reading for an LPG Slip Tube type tank. This field denotes whether this is a long or short slip tube
| ||||
mnVapourWeight | VAPW | MATH_NUMERIC | NONE | NONE |
The weight of the vapour within a tank or containers. | ||||
szUnitofMeasure10 | BUM0 | char | NONE | NONE |
A user defined code (system 00, type UM) that identifies the unit of measurement for pressure, volume, weight, diameter, or height. | ||||
mnVapourVolume | VAPV | MATH_NUMERIC | NONE | NONE |
The vapour volume within a tank or containers. | ||||
szUnitofMeasure9 | BUM9 | 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
| ||||
mnLiquidWeight | LIQW | MATH_NUMERIC | NONE | NONE |
The weight of the liquid. | ||||
szUnitofMeasure7 | BUM7 | 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
| ||||
mnLiquidVolume | LIQV | MATH_NUMERIC | NONE | NONE |
The volume of the liquid. | ||||
szUnitofMeasure8 | BUM8 | 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
| ||||
mnOtherVolume | OVOL | MATH_NUMERIC | NONE | NONE |
This number represents any volumes that will affect the net volume calculation. The default value equals the pipeline volume plus the
| ||||
szUnitofMeasureA | BUM2 | 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
| ||||
mnTimeRead | RDTM | MATH_NUMERIC | NONE | NONE |
The time when the readings were performed. Enter the time in either HHMMSS or HH:MM:SS format. If you leave this field blank, the system
| ||||
jdDate | DTE | JDEDATE | NONE | NONE |
You can enter a date with or without slashes (/) or dashes (-) as separators.
If you leave a date entry field blank, the system supplies the
| ||||
mnUnitsBeginingThroughputQ | OPNR | MATH_NUMERIC | NONE | NONE |
The beginning (opening) meter reading before the product flows through a pipeline. In order to calculate the ambient volume, an after
| ||||
mnUnitsNewTotalThroughputQ | PNCR | MATH_NUMERIC | NONE | NONE |
The closing reading of the meter at the date and time specified by the user.
This indicates the quantity of product that has flowed through the
| ||||
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
| ||||
mnWeightBeforeLoading | BFWT | MATH_NUMERIC | NONE | NONE |
The weight of a vehicle before loading any products. | ||||
szUnitofMeasurebefore | BWTU | char | NONE | NONE |
A user defined code (system 00, type UM) that identifies the unit of measurement for pressure, volume, weight, diameter, or height. | ||||
mnWeightAfterLoading | AFWT | MATH_NUMERIC | NONE | NONE |
The weight of a vehicle after loading products. | ||||
szUnitofMeasureafter | AWTU | char | NONE | NONE |
A user defined code (system 00, type UM) that identifies the unit of measurement for pressure, volume, weight, diameter, or height. | ||||
jdThroughputReconciledDate | THDT | JDEDATE | NONE | NONE |
The date a transaction is throughput reconciled. This is updated in the Update Throughput Operations process. | ||||
jdOperationalReconciledDat | OPDT | JDEDATE | NONE | NONE |
The date the transaction was operationally reconciled. The Update Operational Reconciliations process updates this field. | ||||
mnReconciliationStatusLast | LRST | MATH_NUMERIC | NONE | NONE |
Identifies the current status in the reconciliation process. Entries in this field are User Defined Codes (UDCs).
Important note: Set up your
| ||||
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
| ||||
cProgramStatus | PGMS | char | NONE | NONE |
The status code used in General Stock Movements.
C data returned from Dip Volume Calculator
W data returned from Weighbridge
| ||||
mnGainLossRecordNumber | GLRN | MATH_NUMERIC | NONE | NONE |
The number of the gain/loss record written to the Gain/Loss file as part of the General Stock Movement transaction. | ||||
szUserReservedCode | URCD | char | NONE | NONE |
This is a 2 position code that is reserved for the user. JDE does not currently use this field and will not utilize this field in the future. | ||||
mnUserReservedAmount | URAT | MATH_NUMERIC | NONE | NONE |
This is a 15 position code that is reserved for the user. JDE does not currently use this field and will not utilize this field in the future. | ||||
mnUserReservedNumber | URAB | MATH_NUMERIC | NONE | NONE |
This is a 8 position code that is reserved for the user. JDE does not currently use this field and will not utilize this field in the future. | ||||
szUserReservedReference | URRF | char | NONE | NONE |
A 15-position reference that is reserved for the user. J.D. Edwards does not currently use this field and does not plan to use it in the future. | ||||
jdUserReservedDate | URDT | JDEDATE | NONE | NONE |
This is a 6 position code that is reserved for the user. JDE does not currently use this field and will not utilize this field in the future. | ||||
mnUniqueKeyIDInternal | UKID | MATH_NUMERIC | NONE | NONE |
This field is a unique number used to identify a record in a file. | ||||
szUserId | USER | char | NONE | NONE |
The code that identifies a user profile. | ||||
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
| ||||
szWorkStationId | JOBN | char | NONE | NONE |
The code that identifies the work station ID that executed a particular job. | ||||
jdDateUpdated | UPMJ | JDEDATE | NONE | NONE |
The date that specifies the last update to the file record. | ||||
mnTimeOfDay | TDAY | MATH_NUMERIC | NONE | NONE |
The computer clock in hours:minutes:seconds. | ||||
mnShipmentNumberB73 | PTNR | MATH_NUMERIC | NONE | NONE |
A number that identifies an entry in the Address Book system. The partner is the entity or company with whom you have a contract or
| ||||
mnBulkJobNumber | JOBS | MATH_NUMERIC | NONE | NONE |
The job number (work station ID) which executed the particular job. | ||||
mnTransactionLineNr | TRNO | MATH_NUMERIC | NONE | NONE |
The transaction line number keeps the different From and To lines for one transaction (for example, combining multiple lots into one or
| ||||
cRecordofrecord | TRCD | char | NONE | NONE |
This field is used internally in the Bulk Product Transaction file (F41511).
The valid record types are:
F FROM record in General Stock
| ||||
mnRowIdentifier | MATH01 | MATH_NUMERIC | NONE | NONE |
- - - Good Performance Low Value. | ||||
mnMeterRowNumber | MATH01 | MATH_NUMERIC | NONE | NONE |
- - - Good Performance Low Value. | ||||
szLocation | LOCN | char | NONE | NONE |
The storage location from which goods will be moved. | ||||
szOrderSuffix | SFXO | char | OPT | NONE |
In the A/R and A/P systems, a code that corresponds to the pay item. In the Sales Order and Procurement systems, this code identifies
|
None |
None |