| Column | Field | Description | Data Type | Edit Type | Length | Decimals | SQL Create Statement |
---|
| 1 | TBWTBID | Trial Blend ID | Integer | Generic Edit | 11 | 0 | Allow NULL? |
| 2 | TBWTBNAME | Trial Blend Name | String | Generic Edit | 30 | 0 | Allow NULL? |
| 3 | TBWTBDESC | Trial Blend Description | String | Generic Edit | 30 | 0 | Allow NULL? |
| 4 | TBMCU | Business Unit | String | Generic Edit | 12 | 0 | Allow NULL? |
| 5 | TBWTBST | Trial Blend Status | Character | UDC (31B SJ) | 1 | 0 | Allow NULL? |
| 6 | TBWDCJ | Date Created | Date | Generic Edit | 6 | 0 | |
| 7 | TBWTBAN8 | Creator ID | Numeric | Generic Edit | 8 | 0 | Allow NULL? |
| 8 | TBNCPATHID | Named Calculation Path Id | Numeric | Generic Edit | 8 | 0 | Allow NULL? |
| 9 | TBWTBSCT | Significant Change Threshold | Numeric | Generic Edit | 15 | 4 | Allow NULL? |
| 10 | TBEURID | EUR Identifier | Numeric | Generic Edit | 10 | 0 | Allow NULL? |
| 11 | TBWTBQTY | Target Quantity | Numeric | Generic Edit | 15 | 4 | Allow NULL? |
| 12 | TBWVSPID | Validation Spec Identifier | Numeric | Generic Edit | 10 | 0 | Allow NULL? |
| 13 | TBWTBWS | Trial Blend Wine Status Short Code | String | Generic Edit | 6 | 0 | Allow NULL? |
| 14 | TBWBBVOL | Bench Blend Volume | Numeric | Generic Edit | 15 | 4 | Allow NULL? |
| 15 | TBWBBUOM | Bench Blend UOM | String | UDC (31B UM) | 2 | 0 | Allow NULL? |
| 16 | TBWTBCAT1 | Trial Blend Category Code 1 | String | UDC (31B T3) | 10 | 0 | Allow NULL? |
| 17 | TBWTBCAT2 | Trial Blend Category Code 2 | String | UDC (31B T4) | 10 | 0 | Allow NULL? |
| 18 | TBWTBCAT3 | Trial Blend Category Code 3 | String | UDC (31B T5) | 10 | 0 | Allow NULL? |
| 19 | TBWTBCAT4 | Trial Blend Category Code 4 | String | UDC (31B T6) | 10 | 0 | Allow NULL? |
| 20 | TBWTBCAT5 | Trial Blend Category Code 5 | String | UDC (31B T7) | 10 | 0 | Allow NULL? |
| 21 | TBWTBLSTD | Date Last Refresh | Date | Generic Edit | 8 | 0 | |
| 22 | TBURAB | User Reserved Number | Numeric | Generic Edit | 8 | 0 | Allow NULL? |
| 23 | TBURAT | User Reserved Amount | Numeric | Generic Edit | 15 | 2 | Allow NULL? |
| 24 | TBURCD | User Reserved Code | String | Generic Edit | 2 | 0 | Allow NULL? |
| 25 | TBURDT | User Reserved Date | Date | Generic Edit | 6 | 0 | |
| 26 | TBURRF | User Reserved Reference | String | Generic Edit | 15 | 0 | Allow NULL? |
| 27 | TBWAB | Blend Mgmt Number | Numeric | Generic Edit | 8 | 0 | Allow NULL? |
| 28 | TBWNUM | Blend Mgmt Numeric | Numeric | Generic Edit | 15 | 4 | Allow NULL? |
| 29 | TBWCD | Blend Mgmt Code | String | Generic Edit | 3 | 0 | Allow NULL? |
| 30 | TBWMDT | Blend Mgmt Date | Date | Generic Edit | 6 | 0 | |
| 31 | TBWRF | Blend Mgmt Reference | String | Generic Edit | 30 | 0 | Allow NULL? |
| 32 | TBUSER | User ID | String | Generic Edit | 10 | 0 | Allow NULL? |
| 33 | TBUPMJ | Date - Updated | Date | Generic Edit | 6 | 0 | |
| 34 | TBUPMT | Time - Last Updated | Numeric | Generic Edit | 6 | 0 | Allow NULL? |
| 35 | TBJOBN | Work Station ID | String | Generic Edit | 10 | 0 | Allow NULL? |
| 36 | TBMKEY | Machine Key | String | Generic Edit | 15 | 0 | Allow NULL? |
| 37 | TBPID | Program ID | String | Generic Edit | 10 | 0 | Allow NULL? |
| 38 | TBWTBDBMET | Default TB BlendID Method | String | UDC (31B DB) | 10 | 0 | Allow NULL? |
| 39 | TBBNCHID | Bench Blend Sample Number | Integer | Generic Edit | 11 | 0 | Allow NULL? |
| 40 | TBUSRQDT | Sample Request Date | JDE UTime | Generic Edit | 11 | 0 | |