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 |