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 |