| Column | Field | Description | Data Type | Edit Type | Length | Decimals | SQL Create Statement |
---|
| 1 | BTWOPID | Operation ID | Integer | Generic Edit | 11 | 0 | Allow NULL? |
| 2 | BTLNID | Line Number | Numeric | Generic Edit | 6 | 3 | Allow NULL? |
| 3 | BTMCU | Business Unit | String | Generic Edit | 12 | 0 | Allow NULL? |
| 4 | BTWCOPCD | Configured Operation Short Code | String | Generic Edit | 10 | 0 | Allow NULL? |
| 5 | BTWOCDATE | Operation Closed Date | Date | Generic Edit | 6 | 0 | |
| 6 | BTWLOTN | Blend Lot Number | String | Generic Edit | 30 | 0 | Allow NULL? |
| 7 | BTMATYP | Material Type Code | String | Generic Edit | 4 | 0 | Allow NULL? |
| 8 | BTWISSC | Wine Status | String | Generic Edit | 6 | 0 | Allow NULL? |
| 9 | BTU | Units | Numeric | Generic Edit | 15 | 2 | Allow NULL? |
| 10 | BTWVUM | Quantity UOM | String | UDC (31B UM) | 3 | 0 | Allow NULL? |
| 11 | BTUNCS | Amount - Unit Cost | Numeric | Generic Edit | 15 | 4 | Allow NULL? |
| 12 | BTAA | Amount | Numeric | Generic Edit | 15 | 2 | Allow NULL? |
| 13 | BTDCT | Document Type | String | UDC (00 DT) | 2 | 0 | Allow NULL? |
| 14 | BTKCO | Document Company | String | Generic Edit | 5 | 0 | Allow NULL? |
| 15 | BTDOC | Document (Voucher Invoice etc.) | Numeric | Generic Edit | 8 | 0 | Allow NULL? |
| 16 | BTDGL | Date - For G/L (and Voucher) | Date | Generic Edit | 6 | 0 | |
| 17 | BTGLPT | Category - G/L | String | UDC (41 9) | 4 | 0 | Allow NULL? |
| 18 | BTITM | Item Number - Short | Numeric | Generic Edit | 8 | 0 | Allow NULL? |
| 19 | BTWPA | Percent Alcohol | Numeric | Generic Edit | 15 | 4 | Allow NULL? |
| 20 | BTWTEMP | Temperature | Numeric | Generic Edit | 15 | 4 | Allow NULL? |
| 21 | BTWLN | Line Number 702 | Numeric | Generic Edit | 4 | 0 | Allow NULL? |
| 22 | BTWTT | Transaction Type | Character | Generic Edit | 1 | 0 | Allow NULL? |
| 23 | BTWPF | Posted Flag | Character | Generic Edit | 1 | 0 | Allow NULL? |
| 24 | BTUSER | User ID | String | Generic Edit | 10 | 0 | Allow NULL? |
| 25 | BTJOBN | Work Station ID | String | Generic Edit | 10 | 0 | Allow NULL? |
| 26 | BTUPMJ | Date - Updated | Date | Generic Edit | 6 | 0 | |
| 27 | BTTDAY | Time of Day | Numeric | Generic Edit | 6 | 0 | Allow NULL? |
| 28 | BTPID | Program ID | String | Generic Edit | 10 | 0 | Allow NULL? |
| 29 | BTWCFGID | Configured Operation ID | Integer | Generic Edit | 11 | 0 | Allow NULL? |
| 30 | BTEURID | EUR Identifier | Numeric | Generic Edit | 10 | 0 | Allow NULL? |
| 31 | BTSTUNCS | Standard Amount Unit Cost | Numeric | Generic Edit | 15 | 4 | Allow NULL? |
| 32 | BTSTDAA | Standard Cost Total Amount | Numeric | Generic Edit | 15 | 2 | Allow NULL? |
| 33 | BTWOPN | Operation Number | Numeric | Generic Edit | 8 | 0 | Allow NULL? |
| 34 | BTWAB | Blend Mgmt Number | Numeric | Generic Edit | 8 | 0 | Allow NULL? |
| 35 | BTWMDT | Blend Mgmt Date | Date | Generic Edit | 6 | 0 | |
| 36 | BTWNUM | Blend Mgmt Numeric | Numeric | Generic Edit | 15 | 4 | Allow NULL? |
| 37 | BTWCD | Blend Mgmt Code | String | Generic Edit | 3 | 0 | Allow NULL? |
| 38 | BTWRF | Blend Mgmt Reference | String | Generic Edit | 30 | 0 | Allow NULL? |
| 39 | BTGFL1 | Generic Flag 1 | Character | Generic Edit | 1 | 0 | Allow NULL? |
| 40 | BTGFL2 | Generic Flag 2 | Character | Generic Edit | 1 | 0 | Allow NULL? |
| 41 | BTWOPRVF | Operation Reverse Flag | Character | Generic Edit | 1 | 0 | Allow NULL? |
| 42 | BTWTBOQTY | Original Lot Quantity | Numeric | Generic Edit | 15 | 4 | Allow NULL? |
| 43 | BTWDLOSFL | Declared Loss Control Flag | Character | Generic Edit | 1 | 0 | Allow NULL? |
| 44 | BTWMVF | Blend Movement Flag | Character | Generic Edit | 1 | 0 | Allow NULL? |
| 45 | BTWFTF | From To Flag | Character | Generic Edit | 1 | 0 | Allow NULL? |
| 46 | BTWCYVF | Conversion Yield Variance Flag | Character | Generic Edit | 1 | 0 | Allow NULL? |
| 47 | BTWOGLF | Operation Gain Loss Flag | Character | Generic Edit | 1 | 0 | Allow NULL? |
| 48 | BTWFVTY | From Vessel Class | Character | UDC (31B CV) | 1 | 0 | Allow NULL? |
| 49 | BTWTVTY | To Vessel Class | Character | UDC (31B CV) | 1 | 0 | Allow NULL? |
| 50 | BTIDOC | Inventory Document Number | Numeric | Generic Edit | 8 | 0 | Allow NULL? |
| 51 | BTIDCT | Inventory Document Type | String | UDC (00 DT) | 2 | 0 | Allow NULL? |
| 52 | BTIKCO | Inv Document Company | String | Generic Edit | 5 | 0 | Allow NULL? |
| 53 | BTILNID | Inventory Line Number | Numeric | Generic Edit | 6 | 3 | Allow NULL? |
| 54 | BTGPBT | Batch Number | Numeric | Generic Edit | 8 | 0 | Allow NULL? |
| 55 | BTITPTY | Inv Transaction Process Type | Numeric | Generic Edit | 15 | 4 | Allow NULL? |
| 56 | BTLOCN | Location | String | Generic Edit | 20 | 0 | Allow NULL? |
| 57 | BTLOTN | Lot/Serial Number | String | Generic Edit | 30 | 0 | Allow NULL? |
| 58 | BTWAEJDT | Actual End Date | Date | Generic Edit | 6 | 0 | |
| 59 | BTWBALT | Before-After Lot Type | Character | Generic Edit | 1 | 0 | Allow NULL? |