D31B0450A - Create Barrel Master
| Parameter Name | Data Item | Data Type | Req/Opt | I/O/Both |
|---|---|---|---|---|
| szBarrelType | BATP | char | OPT | NONE |
A user-defined value indicating a particular type or class of barrel. | ||||
| szBarrelTypeVariation | BATV | char | OPT | NONE |
A string that identifies a variation of a particular type. Along with Barrel Type (BATP), this string will be concatenated to create a Barrel
| ||||
| szBarrelProfileCode | BPCO | char | OPT | NONE |
| szCostCenter | MCU | char | OPT | NONE |
An alphanumeric code that identifies a separate entity within a business for which you want to track costs. For example, a business unit
| ||||
| szOriginCountry | CTRO | char | OPT | NONE |
The origin country for the shipment. | ||||
| szOrigLocality | OLOC | char | OPT | NONE |
An indication of a region or location within a country. | ||||
| mnBarrelSupplier | SUPL | MATH_NUMERIC | OPT | NONE |
A number indicating the address book number of the supplier of a tank, barrel, or other equipment . | ||||
| mnCooperNumber | CPNUM | MATH_NUMERIC | OPT | NONE |
A number indicating the address book number of the Cooper (manufacturer) of a barrel, insert, plank, or other wine vessel. | ||||
| szForest | FORES | char | OPT | NONE |
Value to describe which forest wood was harvested from. | ||||
| szToastLevel | TLEV | char | OPT | NONE |
A user-defined value indicated the level of toast (charring) to the interior of the barrel. | ||||
| cBarrelHeadToast | TSTH | char | OPT | NONE |
A value that indicates whether or not the head(s) of a barrel have been toasted. | ||||
| mnBarrelTotalCapacity | TOCAP | MATH_NUMERIC | OPT | NONE |
A value that stores the total capacity of a barrel. | ||||
| szBarrelCapUOM | BCUOM | char | OPT | NONE |
The Volume Unit of Measure (typically volume) associated with the Total Barrel Capacity. | ||||
| mnFermentationCapacity | FCAP | MATH_NUMERIC | OPT | NONE |
A value which stores the total fermentation capacity of a barrel. | ||||
| mnNumberHoops | NUMHP | MATH_NUMERIC | OPT | NONE |
Barrel future use. | ||||
| szStaveGrain | GRAIN | char | OPT | NONE |
Barrel future use. | ||||
| szBarrelSmoke | BSMK | char | OPT | NONE |
Barrel future use. | ||||
| mnBarrelMonthSeas | BNMS | MATH_NUMERIC | OPT | NONE |
Barrel future use. | ||||
| mnInsertSupplier | INSU | MATH_NUMERIC | OPT | NONE |
The address book number for the supplier of a barrel insert. | ||||
| szInsertUOM | IUOM | char | OPT | NONE |
Barrel future use. | ||||
| mnInsertLength | INLG | MATH_NUMERIC | OPT | NONE |
Barrel future use. | ||||
| mnInsertWidth | INWD | MATH_NUMERIC | OPT | NONE |
Barrel future use. | ||||
| mnInsertHeight | INHG | MATH_NUMERIC | OPT | NONE |
Barrel future use. | ||||
| szInsertGrain | INGR | char | OPT | NONE |
Barrel future use. | ||||
| mnInsertQuantity | INQT | MATH_NUMERIC | OPT | NONE |
Barrel future use. | ||||
| szInsertToast | INTS | char | OPT | NONE |
Barrel future use. | ||||
| mnInsertMthSeas | INMS | MATH_NUMERIC | OPT | NONE |
Barrel future use. | ||||
| szSysArrangement | SYAR | char | OPT | NONE |
Barrel future use. | ||||
| szInsertOrigin | INOO | char | OPT | NONE |
Barrel future use. | ||||
| mnInsertSurfArea | ISAR | MATH_NUMERIC | OPT | NONE |
Barrel future use. | ||||
| szInsertSurfAreaUOM | IUMSA | char | OPT | NONE |
Barrel future use. | ||||
| mnInsertSAVR | ISVR | MATH_NUMERIC | OPT | NONE |
A number representing the ratio between the insert surface area (displacement) and total volume of a barrel. | ||||
| cInsertFlag | INSF | char | OPT | NONE |
A flag that identifies whether or not a barrel (or other vessel) contains an Insert. Values are:
Unchecked or 0
Vessel does not contain an
| ||||
| mnUserReservedAmount | URAT | MATH_NUMERIC | OPT | 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. | ||||
| szUserReservedCode | URCD | char | OPT | 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. | ||||
| jdUserReservedDate | URDT | JDEDATE | OPT | 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. | ||||
| mnUserReservedNumber | URAB | MATH_NUMERIC | OPT | 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 | OPT | 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. | ||||
| szUserId | USER | char | OPT | NONE |
The code that identifies a user profile. | ||||
| jdDateUpdated | UPMJ | JDEDATE | OPT | NONE |
The date that specifies the last update to the file record. | ||||
| mnTimeLastUpdated | UPMT | MATH_NUMERIC | OPT | NONE |
The time that specifies when the program executed the last update to this record. | ||||
| szWorkStationId | JOBN | char | OPT | NONE |
The code that identifies the work station ID that executed a particular job. | ||||
| szMachineKey | MKEY | char | OPT | NONE |
The Location or Machine Key indicates the name of the machine on the network (server or workstation). | ||||
| szProgramId | PID | char | OPT | NONE |
The number that identifies the batch or interactive program (batch or interactive object). For example, the number of the Sales Order Entry
| ||||
| cStatusBarrelProfile | SCDPR | char | OPT | NONE |
A code to indicate the status of a Barrel Profile record. | ||||
| cSuppressErrorMessage | EV01 | char | OPT | NONE |
An option that specifies the type of processing for an event. | ||||
| szErrorMessageID | DTAI | char | OPT | 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
| ||||
| szBarrelProfileCacheKey | DL01 | char | OPT | NONE |
A user defined name or remark. | ||||
| mnLeaseCompany | LESCO | MATH_NUMERIC | OPT | NONE |
A value that indicates the address book number of the company that barrels are leased from if barrels are not owned. | ||||
| jdLeaseDate | LESDT | JDEDATE | OPT | NONE |
Date when a lease contract was entered. | ||||
| szLocation | LOCN | char | OPT | NONE |
The storage location from which goods will be moved. | ||||
| szLeaseCoName | LESCN | char | OPT | NONE |
The text name of the Barrel leasing company. | ||||
| mnLeaseTerm | LESTM | MATH_NUMERIC | OPT | NONE |
A value indicating the number of months (typically) in the term of a barrel lease. | ||||
| mnLeaseDocNum | LESDN | MATH_NUMERIC | OPT | NONE |
A number that references the Document Number associated with a lease contract. | ||||
| mnYearReceived | RECY | MATH_NUMERIC | OPT | NONE |
A value to indicate the year a barrel (or other vessel) was received. | ||||
| mnPreviousOwner | POWN | MATH_NUMERIC | OPT | NONE |
A number correlating to the address book number of the previous owner of a vessel. | ||||
| jdDateOutService | DAOS | JDEDATE | OPT | NONE |
Date indicating when a barrel was taken out of service. | ||||
| mnAssetNumberWine | ANUMW | MATH_NUMERIC | OPT | NONE |
A number that identifies an asset. | ||||
| szIDMethod | IDMTHD | char | OPT | NONE |
Method used for identification of barrels. | ||||
| szBarrel_ID | BARID | char | OPT | NONE |
A string that uniquely identifies an individual barrel (or collection of barrels). This is a string comprised of 3 segments. The length of
| ||||
| szBarrelAvailCode | BAVC | char | OPT | NONE |
A user-defined value indicating the availability status of a barrel. | ||||
| szAdjReasonCode | AJRS | char | OPT | NONE |
A user-defined code that identifies the reason why a barrel adjustment or change was made. | ||||
| szBarrelColorStatus | BCST | char | OPT | NONE |
A value used to indicate the color status inside a barrel. | ||||
| cBarrelCondition | BARCO | char | OPT | NONE |
A value indicating the condition of the barrel (New, Used, Reconditioned) | ||||
| jdDateFirstUse | DAFU | JDEDATE | OPT | NONE |
Date representing the Date when a barrel was first used. | ||||
| mnNumberFills | NUMFL | MATH_NUMERIC | OPT | NONE |
Over the useable life of a barrel, this value represents the cumulative number of times a barrel has been filled. | ||||
| szCurrentUse | CUSE | char | OPT | NONE |
A user-defined value that indicates the current use of a wine barrel. | ||||
| szNextUse | NXUSE | char | OPT | NONE |
A user-defined value indicating the intended next-use of a particular barrel. | ||||
| szMethodLastTreat | MTDLT | char | OPT | NONE |
The most recent treatment method that has been applied to a barrel. | ||||
| jdDateLastTreat | DALT | JDEDATE | OPT | NONE |
Date when the last treatment operation was performed on a barrel. | ||||
| mnIDNumFr | IDNOFR | MATH_NUMERIC | OPT | NONE |
The "starting point" when using the COPY Barrel Functionality. | ||||
| szBarrelVolStatus | BVST | char | OPT | NONE |
A value indicating the fill status of a barrel. | ||||
| jdDateLastSulfur | DALS | JDEDATE | OPT | NONE |
Date when SO2 (Sulfur Dioxide) treatment was last performed to a barrel. | ||||
| cToastReworkYN | TSTR | char | OPT | NONE |
Barrel future use. | ||||
| cBarrelShave | SHAV | char | OPT | NONE |
A flag indicating whether or not the interior of a barrel has been shaved to expose a fresh wood surface. | ||||
| szShavedBy | SHAVB | char | OPT | NONE |
An indication of the Winery staff member who performed a barrel shave operation. | ||||
| jdShaveDate | SHAVD | JDEDATE | OPT | NONE |
Date a barrel shave operation was completed. | ||||
| mnBarrelOwner | BOWN | MATH_NUMERIC | OPT | NONE |
A number corresponding to the Address Book number for the owner of a barrel. | ||||
| mnQuantityOriginal | QTOR | MATH_NUMERIC | OPT | NONE |
| mnQuantityReceived | QTRC | MATH_NUMERIC | OPT | NONE |
| mnInsertNumber | INUM | MATH_NUMERIC | OPT | NONE |
A unique number that identifies a barrel insert. | ||||
| mnInsertNumUse | INUS | MATH_NUMERIC | OPT | NONE |
Barrel future use. | ||||
| jdDateFirstCommissioned | DAFC | JDEDATE | OPT | NONE |
Date representing when a barrel was first brought into service. | ||||
| mnBarrelPO | WBPO | MATH_NUMERIC | OPT | NONE |
The Purchase Order that the original barrel order was completed on. | ||||
| mnBarrelCollNum | BARCN | MATH_NUMERIC | OPT | NONE |
A number that designates the group or collection of barrels a barrel belongs to. | ||||
| mnStaveThickness | STAVT | MATH_NUMERIC | OPT | NONE |
Barrel future use. | ||||
| szGeneralComments | GECM | char | OPT | NONE |
A field that contains general comments. The system does not verify this information. You can enter any alphanumeric string. | ||||
| szLeaseDocRef | LDREF | char | OPT | NONE |
| cLeasedYN | LEAS | char | OPT | NONE |
A flag indicating whether a barrel is leased or not. | ||||
| jdStaveDryDate | SDDR | JDEDATE | OPT | NONE |
Barrel future use. | ||||
| mnBarrelNumber | BRLNUM | MATH_NUMERIC | OPT | NONE |
A system generated number which uniquely identifies an individual barrel within the winery. | ||||
| szBarrelProfileDescription | BPDESC | char | OPT | NONE |
A string that is a concatenation of Barrel Type and Barrel Type Variation to identify a Barrel Profile. This code provides a method to
| ||||
| szBarrelClassification | BRLCLA | char | OPT | NONE |
| szBarrelCatCode1 | SCTM | char | OPT | NONE |
A barrel Category Code defined by the user in 31B/R1. | ||||
| szBarrelCatCode2 | SDRM | char | OPT | NONE |
A barrel Category Code defined by the user in 31B/R2. | ||||
| szBarrelCatCode3 | SBDM | char | OPT | NONE |
A barrel Category Code defined by the user in 31B/R3. | ||||
| szBarrelCatCode4 | SDRL | char | OPT | NONE |
A barrel Category Code defined by the user in 31B/R4. | ||||
| szBarrelCatCode5 | INFO | char | OPT | NONE |
A barrel Category Code defined by the user in 31B/R5. | ||||
| mnBarrelAge | RKNUM | MATH_NUMERIC | OPT | NONE |
A number that identifies barrel age. | ||||
| szRackNumberBrl | RKNMR | char | OPT | NONE |
A unique string that identifies a particular barrel storage rack. | ||||
| cOneTimeCost | WOTC | char | OPT | NONE |
One-time cost flag indicates whether non-recurring costs associated with the initial use of a vessel have been applied to the vessel. | ||||
| szBlendMgmtReference | WRF | char | OPT | NONE |
Reserved for Blend Management. | ||||
| szBlendMgmtCode | WCD | char | OPT | NONE |
Reserved for Blend Management. | ||||
| mnBlendMgmtAB | WAB | MATH_NUMERIC | OPT | NONE |
Reserved for Blend Management. | ||||
| mnBlendMgmtNumeric | WNUM | MATH_NUMERIC | OPT | NONE |
Reserved for Blend Management. | ||||
| jdBlendMgmtDate | WMDT | JDEDATE | OPT | NONE |
Reserved for Blend Management. | ||||
| szCostGroup | WCG | char | OPT | NONE |
An alphanumeric code that identifies a set of one or more cost components associated with a Blend Operation. For example, a Cost Group
| ||||
| None |
| None |