| Column | Field | Description | Data Type | Edit Type | Length | Decimals | SQL Create Statement |
|---|
| 1 | BPDFMCU | Branch/Plant | String | Generic Edit | 12 | 0 | Allow NULL? |
| 2 | BPFSCID | Scenario ID | Numeric | Generic Edit | 15 | 0 | Allow NULL? |
| 3 | BPDFBDESC | Branch Description | String | Generic Edit | 30 | 0 | Allow NULL? |
| 4 | BPSYM1 | Symbol to Identify Short Inv Number | Character | Generic Edit | 1 | 0 | Allow NULL? |
| 5 | BPSYM2 | Symbol to Identify Long Inv Number | Character | Generic Edit | 1 | 0 | Allow NULL? |
| 6 | BPSYM3 | Symbol to Identify 3rd Inv Number | Character | Generic Edit | 1 | 0 | Allow NULL? |
| 7 | BPNUMSHF | Number of Shifts | Numeric | Generic Edit | 8 | 0 | Allow NULL? |
| 8 | BPDFWRHR1 | Shift Hours 1 | Numeric | Generic Edit | 15 | 2 | Allow NULL? |
| 9 | BPDFWRHR2 | Shift Hours 2 | Numeric | Generic Edit | 15 | 2 | Allow NULL? |
| 10 | BPDFWRHR3 | Shift Hours 3 | Numeric | Generic Edit | 15 | 2 | Allow NULL? |
| 11 | BPDFWRHR4 | Shift Hours 4 | Numeric | Generic Edit | 15 | 2 | Allow NULL? |
| 12 | BPDFWRHR5 | Shift Hours 5 | Numeric | Generic Edit | 15 | 2 | Allow NULL? |
| 13 | BPDFWRHR6 | Shift Hours 6 | Numeric | Generic Edit | 15 | 2 | Allow NULL? |
| 14 | BPDFSHF1 | Shift Code 1 | Character | UDC (06 SH) | 1 | 0 | Allow NULL? |
| 15 | BPDFSHF2 | Shift Code 2 | Character | UDC (06 SH) | 1 | 0 | Allow NULL? |
| 16 | BPDFSHF3 | Shift Code 3 | Character | UDC (06 SH) | 1 | 0 | Allow NULL? |
| 17 | BPDFSHF4 | Shift Code 4 | Character | UDC (06 SH) | 1 | 0 | Allow NULL? |
| 18 | BPDFSHF5 | Shift Code 5 | Character | UDC (06 SH) | 1 | 0 | Allow NULL? |
| 19 | BPDFSHF6 | Shift Code 6 | Character | UDC (06 SH) | 1 | 0 | Allow NULL? |
| 20 | BPSEPL | Separator - Location | Character | Generic Edit | 1 | 0 | Allow NULL? |
| 21 | BPSE01 | Number - Characters (Aisle) | Numeric | Generic Edit | 1 | 0 | Allow NULL? |
| 22 | BPSE02 | Number - Characters (Bin) | Numeric | Generic Edit | 1 | 0 | Allow NULL? |
| 23 | BPSE03 | Number - Characters (Code 3) | Numeric | Generic Edit | 1 | 0 | Allow NULL? |
| 24 | BPSE04 | Number - Characters (Code 4) | Numeric | Generic Edit | 1 | 0 | Allow NULL? |
| 25 | BPSE05 | Number - Characters (Code 5) | Numeric | Generic Edit | 1 | 0 | Allow NULL? |
| 26 | BPSE06 | Number - Characters (Code 6) | Numeric | Generic Edit | 1 | 0 | Allow NULL? |
| 27 | BPSE07 | Number - Characters (Code 7) | Numeric | Generic Edit | 1 | 0 | Allow NULL? |
| 28 | BPSE08 | Number - Characters (Code 8) | Numeric | Generic Edit | 1 | 0 | Allow NULL? |
| 29 | BPSE09 | Number - Characters (Code 9) | Numeric | Generic Edit | 1 | 0 | Allow NULL? |
| 30 | BPSE10 | Number - Characters (Code 10) | Numeric | Generic Edit | 1 | 0 | Allow NULL? |
| 31 | BPLR01 | Justify - Aisle | Character | UDC (H40 LR) | 1 | 0 | Allow NULL? |
| 32 | BPLR02 | Justify - Bin | Character | UDC (H40 LR) | 1 | 0 | Allow NULL? |
| 33 | BPLR03 | Justify - Code 3 | Character | UDC (H40 LR) | 1 | 0 | Allow NULL? |
| 34 | BPLR04 | Justify - Code 4 | Character | UDC (H40 LR) | 1 | 0 | Allow NULL? |
| 35 | BPLR05 | Justify - Code 5 | Character | UDC (H40 LR) | 1 | 0 | Allow NULL? |
| 36 | BPLR06 | Justify - Code 6 | Character | UDC (H40 LR) | 1 | 0 | Allow NULL? |
| 37 | BPLR07 | Justify - Code 7 | Character | UDC (H40 LR) | 1 | 0 | Allow NULL? |
| 38 | BPLR08 | Justify - Code 8 | Character | UDC (H40 LR) | 1 | 0 | Allow NULL? |
| 39 | BPLR09 | Justify - Code 9 | Character | UDC (H40 LR) | 1 | 0 | Allow NULL? |
| 40 | BPLR10 | Justify - Code 10 | Character | UDC (H40 LR) | 1 | 0 | Allow NULL? |
| 41 | BPURCD | User Reserved Code | String | Generic Edit | 2 | 0 | Allow NULL? |
| 42 | BPURDT | User Reserved Date | Date | Generic Edit | 6 | 0 | |
| 43 | BPURAT | User Reserved Amount | Numeric | Generic Edit | 15 | 2 | Allow NULL? |
| 44 | BPURAB | User Reserved Number | Numeric | Generic Edit | 8 | 0 | Allow NULL? |
| 45 | BPURRF | User Reserved Reference | String | Generic Edit | 15 | 0 | Allow NULL? |
| 46 | BPUSER | User ID | String | Generic Edit | 10 | 0 | Allow NULL? |
| 47 | BPMKEY | Machine Key | String | Generic Edit | 15 | 0 | Allow NULL? |
| 48 | BPPID | Program ID | String | Generic Edit | 10 | 0 | Allow NULL? |
| 49 | BPUUPMJ | Universal Date Updated | JDE UTime | Generic Edit | 11 | 0 | |
