D31B0100A - Block Vintage
Parameter Name | Data Item | Data Type | Req/Opt | I/O/Both |
---|---|---|---|---|
szBlockShortCode | BLSCD | char | OPT | NONE |
A unique identifier of a Block entered by the user. | ||||
mnBlockIdentifier | BLUID | MATH_NUMERIC | OPT | NONE |
A Parcel of land that is the smallest entity of varietal details for a grower, vineyard or ranch. | ||||
szBlockName | BLNAM | char | OPT | NONE |
Name of a Block that represent a small parcel of land within a vineyard. | ||||
szVineyardName | VRLNAM | char | OPT | NONE |
Name of the vineyard from where the grapes are purchased. | ||||
szVineyardShortCode | VRCODE | char | OPT | NONE |
A unique Identifier of a Vineyard. | ||||
szVarietyCode | VARCODE | char | OPT | NONE |
A code that represents a particular variety of grape. | ||||
mnVintage | VINTAG | MATH_NUMERIC | OPT | NONE |
The year when Grapes were harvested. | ||||
mnHarvestEstimate | HAREST | MATH_NUMERIC | OPT | NONE |
The Estimated quantity of harvest in tons or kg. | ||||
cStatusCode | SCODE | char | OPT | NONE |
Use to identify if an entity is Active or Inactive. | ||||
szAppellationCode | APPLLAT | char | OPT | NONE |
The official geographical area determined by the relevant authorities AVA (US) & AWBC (Aus). | ||||
szUserId | USER | char | OPT | NONE |
The code that identifies a user profile. | ||||
szWorkStationId | JOBN | char | OPT | NONE |
The code that identifies the work station ID that executed a particular job. | ||||
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. | ||||
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
| ||||
szGeographicArea | GOAREA | char | OPT | NONE |
Geographic Area consists of the following:
1
Appellation. The official geographically area determined by the relevant authorities AVA (US)
| ||||
cErrorReturned | EV01 | char | OPT | NONE |
An option that specifies the type of processing for an event. | ||||
mnVarietyID | VARID | MATH_NUMERIC | OPT | NONE |
This is the Key to the Variety Master File. | ||||
mnAppellationID | APPID | MATH_NUMERIC | OPT | NONE |
A number that identifies an entity, such as, an Appellation in the Block Vintage Master file. | ||||
mnGeographicAreaID | GOAID | MATH_NUMERIC | OPT | NONE |
A number that identifies an entity such as an Appellation, or Growing Area in the Geographic Area Master file. | ||||
mnGrowerNumber | AN8 | MATH_NUMERIC | OPT | NONE |
A number that identifies an entry in the Address Book system, such as employee, applicant, participant, customer, supplier, tenant, or
| ||||
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
|
None |
None |