D31B0330A - Create Barrel Profiles Cache
| 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.  | ||||
| szCacheActionCode | CACTN | char | OPT | 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 | OPT | NONE | 
The number of keys in an index that will be used to retrieve, delete, or update a record.  | ||||
| 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 
  | ||||
| idCacheCursor | GENLNG | ID | OPT | NONE | 
General purpose ID variable.  | ||||
| nCacheIndex | INT01 | integer | OPT | NONE | 
Number of Days in Future to Query for Responses Due.  | ||||
| szBarrelProfileCacheKey | DL01 | char | OPT | NONE | 
A user defined name or remark.  | ||||
| mnJobnumberA | JOBS | MATH_NUMERIC | OPT | NONE | 
The job number (work station ID) which executed the particular job.  | ||||
| szComputerID | CTID | char | OPT | NONE | 
| mnProcessID | PEID | MATH_NUMERIC | OPT | NONE | 
A code that identifies the Inter-Process Communication ID.  | ||||
| mnTransactionID | TCID | MATH_NUMERIC | OPT | NONE | 
| 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.  | ||||
| mnOriginalDocW | WODOC | MATH_NUMERIC | OPT | NONE | 
A number stored and used to reference a document that records the original receipt of a group of barrels.  | ||||
| mnVirtualBarrelID | VBID | MATH_NUMERIC | OPT | NONE | 
A value representing to which virtual barrel group a barrel belongs.  | ||||
| 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.  | ||||
| mnOtherYearCode | OYRC | MATH_NUMERIC | OPT | NONE | 
A secondary to indicate a calendar year.  | ||||
| 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.  | ||||
| mnBarrelNumber | BANUM | MATH_NUMERIC | OPT | NONE | 
A system-generated number that uniquely identifies an individual barrel. This number is not user modifiable.  | ||||
| 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 
  | ||||
| szBarrelRecLoc | BRLC | char | OPT | NONE | 
Location where barrels were received.  | ||||
| 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.  | ||||
| szVersion | VERS | char | OPT | NONE | 
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 
  | ||||
| mnBarrelNumberMath | 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 | 
| szRackNumberBrl | RKNMR | char | OPT | NONE | 
A unique string that identifies a particular barrel storage rack.  | ||||
| mnShaveBy | SHAVEBY | MATH_NUMERIC | OPT | NONE | 
An indication of the Winery staff member who performed a barrel shave operation.  | ||||
| szBarrelCategoryCode1 | SCTM | char | OPT | NONE | 
A barrel Category Code defined by the user in 31B/R1.  | ||||
| szBarrelCategoryCode2 | SDRM | char | OPT | NONE | 
A barrel Category Code defined by the user in 31B/R2.  | ||||
| szBarrelCategoryCode3 | SBDM | char | OPT | NONE | 
A barrel Category Code defined by the user in 31B/R3.  | ||||
| szBarrelCategoryCode4 | SDRL | char | OPT | NONE | 
A barrel Category Code defined by the user in 31B/R4.  | ||||
| szBarrelCategoryCode5 | 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.  | ||||
| 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 |