| Column | Field | Description | Data Type | Edit Type | Length | Decimals | SQL Create Statement |
|---|
| 1 | BHKCOO | Order Company (Order Number) | String | Generic Edit | 5 | 0 | Allow NULL? |
| 2 | BHDOCO | Document (Order No Invoice etc.) | Numeric | Generic Edit | 8 | 0 | Allow NULL? |
| 3 | BHDCTO | Order Type | String | UDC (00 DT) | 2 | 0 | Allow NULL? |
| 4 | BHSFXO | Order Suffix | String | Generic Edit | 3 | 0 | Allow NULL? |
| 5 | BHHBAREA | HomeBuilder Area ID | String | UDC (00 05) | 3 | 0 | Allow NULL? |
| 6 | BHMCU | Business Unit | String | Generic Edit | 12 | 0 | Allow NULL? |
| 7 | BHR001 | Category Code - G/L1 | String | UDC (09 01) | 3 | 0 | Allow NULL? |
| 8 | BHBIDTYPE | Bid Type | String | UDC (44H6 BT) | 2 | 0 | Allow NULL? |
| 9 | BHBUDONLY | Budget Only | Character | Generic Edit | 1 | 0 | Allow NULL? |
| 10 | BHVNDAOVR | Vendor Assignment Override | Character | Generic Edit | 1 | 0 | Allow NULL? |
| 11 | BHUNIDOC | Unique Document | Character | Generic Edit | 1 | 0 | Allow NULL? |
| 12 | BHVNDTBD | Supplier TBD | Character | Generic Edit | 1 | 0 | Allow NULL? |
| 13 | BHAVEL | Autovoucher Eligible Flag | Character | Generic Edit | 1 | 0 | Allow NULL? |
| 14 | BHDESC | Description | String | Generic Edit | 30 | 0 | Allow NULL? |
| 15 | BHAN8 | Address Number | Numeric | UDC | 8 | 0 | Allow NULL? |
| 16 | BHSHAN | Address Number - Ship To | Numeric | Generic Edit | 8 | 0 | Allow NULL? |
| 17 | BHRMK | Name - Remark | String | Generic Edit | 30 | 0 | Allow NULL? |
| 18 | BHANBY | Buyer Number | Numeric | Generic Edit | 8 | 0 | Allow NULL? |
| 19 | BHDGL | Date - For G/L (and Voucher) | Date | Generic Edit | 6 | 0 | |
| 20 | BHPEFJ | Date - Price Effective Date | Date | Generic Edit | 6 | 0 | |
| 21 | BHCNDJ | Date - Cancel | Date | Generic Edit | 6 | 0 | |
| 22 | BHDRQJ | Date - Requested | Date | Generic Edit | 6 | 0 | |
| 23 | BHTRDJ | Date - Order/Transaction | Date | Generic Edit | 6 | 0 | |
| 24 | BHPDDJ | Date - Scheduled Pick | Date | Generic Edit | 6 | 0 | |
| 25 | BHOPDJ | Date - Original Promised Delivery | Date | Generic Edit | 6 | 0 | |
| 26 | BHADDJ | Date - Actual Ship Date | Date | Generic Edit | 6 | 0 | |
| 27 | BHPPDJ | Date - Promised Shipment | Date | Generic Edit | 6 | 0 | |
| 28 | BHPSDJ | Date - Future Date 2 | Date | Generic Edit | 6 | 0 | |
| 29 | BHPDP1 | Reporting Code 1 - Purchasing | String | UDC (41 P1) | 3 | 0 | Allow NULL? |
| 30 | BHPDP2 | Reporting Code 2 - Purchasing | String | UDC (41 P2) | 3 | 0 | Allow NULL? |
| 31 | BHPDP3 | Reporting Code 3 - Purchasing | String | UDC (41 P3) | 3 | 0 | Allow NULL? |
| 32 | BHPDP4 | Reporting Code 4 - Purchasing | String | UDC (41 P4) | 3 | 0 | Allow NULL? |
| 33 | BHPDP5 | Reporting Code 5 - Purchasing | String | UDC (41 P5) | 3 | 0 | Allow NULL? |
| 34 | BHFUF1 | AIA Document Flag | Character | UDC (H40 FU) | 1 | 0 | Allow NULL? |
| 35 | BHPTC | Payment Terms Code | String | Generic Edit | 3 | 0 | Allow NULL? |
| 36 | BHTXA1 | Tax Rate/Area | String | Generic Edit | 10 | 0 | Allow NULL? |
| 37 | BHEXR1 | Tax Expl Code 1 | String | UDC (00 EX) | 2 | 0 | Allow NULL? |
| 38 | BHPCRT | Percent - Retainage | Numeric | Generic Edit | 7 | 3 | Allow NULL? |
| 39 | BHRTNR | Retainage Rule | String | Generic Edit | 3 | 0 | Allow NULL? |
| 40 | BHOSTS | Status - Purchase Order | Character | Generic Edit | 1 | 0 | Allow NULL? |
| 41 | BHCRRM | Currency Mode-Foreign or Domestic Entry | Character | UDC (H00 CY) | 1 | 0 | Allow NULL? |
| 42 | BHCRCD | Currency Code - From | String | Generic Edit | 3 | 0 | Allow NULL? |
| 43 | BHCRR | Currency Conversion Rate - Spot Rate | Numeric | Generic Edit | 15 | 0 | Allow NULL? |
| 44 | BHHBST1 | HomeBuilder Status Code 1 | Character | Generic Edit | 1 | 0 | Allow NULL? |
| 45 | BHHBST2 | HomeBuilder Status Code 2 | Character | Generic Edit | 1 | 0 | Allow NULL? |
| 46 | BHHBST3 | HomeBuilder Status Code 3 | Character | Generic Edit | 1 | 0 | Allow NULL? |
| 47 | BHHBST4 | HomeBuilder Status Code 4 | Character | Generic Edit | 1 | 0 | Allow NULL? |
| 48 | BHHBST5 | HomeBuilder Status Code 5 | Character | Generic Edit | 1 | 0 | Allow NULL? |
| 49 | BHCRTU | Created by user | String | Generic Edit | 10 | 0 | Allow NULL? |
| 50 | BHCRTJ | Date - Created | Date | Generic Edit | 6 | 0 | |
| 51 | BHCRTT | Time - Created | Numeric | Generic Edit | 6 | 0 | Allow NULL? |
| 52 | BHWRKSTNID | Original Work Station ID | String | Generic Edit | 10 | 0 | Allow NULL? |
| 53 | BHHBOPID | Original Program ID | String | Generic Edit | 10 | 0 | Allow NULL? |
| 54 | BHUPMB | Updated By - User | String | Generic Edit | 10 | 0 | Allow NULL? |
| 55 | BHUPMJ | Date - Updated | Date | Generic Edit | 6 | 0 | |
| 56 | BHUPMT | Time - Last Updated | Numeric | Generic Edit | 6 | 0 | Allow NULL? |
| 57 | BHJOBN | Work Station ID | String | Generic Edit | 10 | 0 | Allow NULL? |
| 58 | BHPID | Program ID | String | Generic Edit | 10 | 0 | Allow NULL? |
