D41B0260 - Get F41511 Record
| Parameter Name | Data Item | Data Type | Req/Opt | I/O/Both | 
|---|---|---|---|---|
| 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.  | ||||
| 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 
  | ||||
| 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 
  | ||||
| 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 
  | ||||
| szTankID | TKID | char | NONE | NONE | 
An 8-character field identifying the tank as defined on the Branch/Plant Constants form.  | ||||
| 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 
  | ||||
| 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 
  | ||||
| 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 
  | ||||
| szMeterNumber | METN | char | NONE | NONE | 
Identifies the meter.  | ||||
| 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.  | ||||
| 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.  | ||||
| mnUniqueKeyIDInternal | UKID | MATH_NUMERIC | NONE | NONE | 
This field is a unique number used to identify a record in a file.  | ||||
| None | 
| None |