D4101060B - Edit Retrieve Delete Bulk Data
| Parameter Name | Data Item | Data Type | Req/Opt | I/O/Both | 
|---|---|---|---|---|
| szBranchPlant | MCU | char | OPT | INPUT | 
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 | OPT | BOTH | 
An inventory item number. The system provides three separate item numbers plus an extensive cross-reference capability to other item 
  | ||||
| cStatus | STAW | char | OPT | INPUT | 
A user-defined code (00/WS) that indicates the approval status.  | ||||
| jdEffectiveThruDate | EFFT | JDEDATE | OPT | INPUT | 
A date that indicates one of the following:
    o When a component part is no longer in effect on a bill of material
    o When a routing step is no 
  | ||||
| mnDocVoucherInvoiceE | DOC | MATH_NUMERIC | OPT | BOTH | 
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 | OPT | INPUT | 
A user defined code (00/DT) that identifies the origin and purpose of the transaction.  PeopleSoft reserves several prefixes for document 
  | ||||
| jdEffectiveFromDate | EFFF | JDEDATE | OPT | INPUT | 
A date that indicates one of the following:
    o When a component part goes into effect on a bill of material
    o When a routing step goes into 
  | ||||
| mnKeyValueSerialNumber | SERK | MATH_NUMERIC | OPT | INPUT | 
A key identification number used internally to identify a composite key structure.  The actual key items must be stored in another file and 
  | ||||
| szTransactionAction | TNAC | char | REQ | INPUT | 
A code that indicates the activity you want to perform on the transaction. In an EDI transaction, this code represents the Transaction Set 
  | ||||
| cUpdateMasterFile | EV01 | char | OPT | INPUT | 
An option that specifies the type of processing for an event.  | ||||
| cProcessEdits | EV01 | char | OPT | INPUT | 
An option that specifies the type of processing for an event.  | ||||
| cWorkflow | EV01 | char | OPT | INPUT | 
An option that specifies the type of processing for an event.  | ||||
| cInteroperability | EV01 | char | OPT | INPUT | 
An option that specifies the type of processing for an event.  | ||||
| cPendingProcessing | EV01 | char | OPT | INPUT | 
An option that specifies the type of processing for an event.  | ||||
| cSuppressErrorMessage | SUPPS | char | OPT | INPUT | 
A flag indicating whether or not runtime error messaging will occur when an error message is issued from a business function.
       0 = allow 
  | ||||
| szErrorMessageId | DTAI | char | OPT | OUTPUT | 
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 
  | ||||
| szProgramId | PID | char | OPT | INPUT | 
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 | OPT | INPUT | 
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 
  | ||||
| szProductGroupFrom | PDGR | char | OPT | BOTH | 
A line of products whose similarity allows them to be grouped together.  This grouping can be used to select products for other tasks or 
  | ||||
| szDispatchGrp | DSGP | char | OPT | BOTH | 
A user defined code that identifies the dispatch group. A dispatch group is a grouping you make for products according to the physical 
  | ||||
| szDensityTable | DNTB | char | OPT | BOTH | 
Identifies the density conversion algorithm to be used in calculations.  | ||||
| szStandardTempConvTableFor | STCN | char | OPT | BOTH | 
Indicates which of the standard ASTM-IP-API tables to use to calculate standard stock accounting units.  | ||||
| szReportingTemperatureTabl | RPTM | char | OPT | BOTH | 
Identifies the temperature table to use for reporting purposes. Fill in this field only if you use a table that is different than the Temperature 
  | ||||
| cRequiresTemperatureConve | RQTC | char | OPT | BOTH | 
Indicates whether the item requires a temperature conversion.
For WorldSoftware, valid values are:
   Y Yes, the item requires a temperature 
  | ||||
| cLPGProductYN | LPGP | char | OPT | BOTH | 
Identifies LPG (liquified petroleum gas) product. Valid values are:
   Y  Product is LPG. You may also use 1. 
   N Product is NOT LPG. You 
  | ||||
| cCalculateVapour | CAVP | char | OPT | BOTH | 
Indicates whether the product requires a calculation of the vapour volume.
Valid values are:
   Y   Product requires the calculation. You may 
  | ||||
| mnDensity | DNTY | MATH_NUMERIC | OPT | BOTH | 
Identifies your company's standard for density. You can also use this field for pack size and weight information.  | ||||
| cDensityTypeAtStandardTem | DNTP | char | OPT | BOTH | 
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 | OPT | BOTH | 
Indicates the temperature at which the density was measured. The system uses the density temperature type from Branch/Plant Constants - 
  | ||||
| cDensityTemperatureUnit | DTPU | char | OPT | BOTH | 
Identifies the type of temperature. Valid values are: F Fahrenheit C Celsius  | ||||
| mnCoefficientofExpansion | COEX | MATH_NUMERIC | OPT | BOTH | 
The co-efficient of expansion of products which cannot be calculated via a standard algorithm. The calculation is as follows:
       VCF = 1 + 
  | ||||
| mnTemperatureMinimum | TMMN | MATH_NUMERIC | OPT | BOTH | 
The minimum temperature allowed for the product. If allowed to default from the table entered, the values are:
   Table Min./Max.
   6B 0 - 300 
  | ||||
| cTemperatureUnit | TPUM | char | OPT | BOTH | 
A code used to identify the type of temperature. F Fahrenheit C Celsius  | ||||
| mnTemperatureMaximum | TMMX | MATH_NUMERIC | OPT | BOTH | 
The maximum temperature allowed for the product. If allowed to default from the table entered, the values will be:
   Table Min./Max.
   6B 0 - 
  | ||||
| cTemperatureUnitMaximum | TPUX | char | OPT | BOTH | 
A code used to identify the type of temperature. F Fahrenheit C Celsius  | ||||
| mnDensityMinimum | DSMN | MATH_NUMERIC | OPT | BOTH | 
The minimum density allowed for this product.
If allowed to default from the table entered, the values will be:
   Table Minimum - Maximum
   
  | ||||
| cDensityTypeMinimum | DNTM | char | OPT | BOTH | 
A code used to identify the type of density. A Absolute density G API Specific Gravity R Relative density  | ||||
| mnDensityMaximum | DNMX | MATH_NUMERIC | OPT | BOTH | 
The maximum density allowed for this product.
If allowed to default from the table entered, the values will be:
   Table Minimum - Maximum
   
  | ||||
| cDensityTypeMaximum | DNTX | char | OPT | BOTH | 
A code used to identify the type of density. A Absolute density G API Specific Gravity R Relative density  | ||||
| mnLPGVapourTemperature | LPGV | MATH_NUMERIC | OPT | BOTH | 
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 | OPT | BOTH | 
A code used to identify the type of temperature. F Fahrenheit C Celsius  | ||||
| mnMinimumVolumeCorrectionF | MNVC | MATH_NUMERIC | OPT | BOTH | 
This field is used during bulk load and delivery confirmation.  It represents the minimum Volume Correction Factor tolerance for a particular 
  | ||||
| mnMaximumVolumeCorrectionF | MXVC | MATH_NUMERIC | OPT | BOTH | 
This field is used during bulk load and delivery confirmation.  It represents the maximum Volume Correction Factor tolerance for a particular 
  | ||||
| szUserReservedCode | URCD | char | OPT | BOTH | 
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 | OPT | BOTH | 
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 | OPT | BOTH | 
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 | OPT | BOTH | 
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 | OPT | BOTH | 
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.  | ||||
| cReconcileTOB | RTOB | char | OPT | BOTH | 
This code indicates whether the Item or Tank should be included in the reconciliation process as follows:
   T  Include this item in the 
  | ||||
| cErrorsExist | ERRC | char | OPT | OUTPUT | 
This error code indicates if any errors occurred during the creation of the Trip Document Detail (F4914) records by the Delivery Document 
  | ||||
| mnCopyIdentifierShort | ITM | MATH_NUMERIC | OPT | BOTH | 
An inventory item number. The system provides three separate item numbers plus an extensive cross-reference capability to other item 
  | ||||
| szCopyBranchPlant | MCU | char | OPT | INPUT | 
An alphanumeric code that identifies a separate entity within a business for which you want to track costs. For example, a business unit 
  | ||||
| mnStrategicVolume | STVL | MATH_NUMERIC | OPT | BOTH | 
Identifies the government-mandated, strategic stock level assigned to the depot for a specific product.  The system displays a warning 
  | ||||
| szUnitofMeasure10 | BUM0 | char | OPT | BOTH | 
A user defined code (system 00, type UM) that identifies the unit of measurement for pressure, volume, weight, diameter, or height.  | ||||
| cLoadRackFlag | LRFG | char | OPT | BOTH | 
Indicates whether a gantry (loading rack) is used. Valid values are:
    Y  Yes. You may also use 1. 
   N  No. You may also use 10.
If you leave 
  | ||||
| cHydrometerCorrection | HCOR | char | OPT | BOTH | 
Indicates whether this product must include the appropriate stem correction for the thermal expansion of the glass hydrometer. Valid values 
  | ||||
| cAutoBatchBlend | ABBL | char | OPT | BOTH | 
Indicates if this product at this depot will be used by an automated batch blending system. Valid values are:
     Y Yes. You may also use 1
     
  | ||||
| cAutoWarehouse | ATWH | char | OPT | BOTH | 
Indicates if this product at this depot will be used by an automated warehouse system. Valid values are:
     Y Yes. You may also use 1.
     N 
  | ||||
| szReplenishmentType | RPLT | char | OPT | BOTH | 
Indicates the method of supply, for example, blended product, purchased product, or filled product. The Replenishment Type field is also 
  | ||||
| szBlendCategory | BCAT | char | OPT | BOTH | 
A user defined code (system 39/type BC) that indicates the valid product groups (or categories) that can be put into a specific blending 
  | ||||
| szFillCategory | FCAT | char | OPT | BOTH | 
A user defined code (system 39/type FC) that identifies the different filling categories. Fill categories are used to specify 
  | ||||
| jdReconciledThruDate | RECD | JDEDATE | OPT | BOTH | 
The date, up to and including this date, on which all transactions have been reconciled.  | ||||
| cAirCorrectYN | ACOR | char | OPT | BOTH | 
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 
  | ||||
| cUpdateItemBranch | ITBR | char | OPT | INPUT | 
A code that controls the level of item information that the system will update. Valid values are:
   1   Update the item level only
   2   Update the 
  | ||||
| idPointerBulk | GENLNG | ID | OPT | NONE | 
General purpose ID variable.  | ||||
| None | 
| None |