| Column | Field | Description | Data Type | Edit Type | Length | Decimals | SQL Create Statement |
---|
| 1 | BCMCU | Business Unit | String | Generic Edit | 12 | 0 | Allow NULL? |
| 2 | BCRVNB | Revision Number | Numeric | Generic Edit | 3 | 0 | Allow NULL? |
| 3 | BCEPRD | E.P. Rules ID | String | Generic Edit | 10 | 0 | Allow NULL? |
| 4 | BCASSD | Assumption ID | String | Generic Edit | 10 | 0 | Allow NULL? |
| 5 | BCSOID | Sales Overage ID | String | Generic Edit | 10 | 0 | Allow NULL? |
| 6 | BCBCRI | Bill Code Rules ID | String | Generic Edit | 10 | 0 | Allow NULL? |
| 7 | BCUDGP | Growth Pattern Unit Default | String | Generic Edit | 10 | 0 | Allow NULL? |
| 8 | BCAIPP | Initial Purchase Price | Numeric | Generic Edit | 15 | 2 | Allow NULL? |
| 9 | BCACPE | Cap Rate Percent | Numeric | Generic Edit | 6 | 3 | Allow NULL? |
| 10 | BCADPE | Discount Rate Percent | Numeric | Generic Edit | 6 | 3 | Allow NULL? |
| 11 | BCASPE | Selling Cost Percent | Numeric | Generic Edit | 6 | 3 | Allow NULL? |
| 12 | BCASCA | Selling Cost Amount | Numeric | Generic Edit | 15 | 2 | Allow NULL? |
| 13 | BCANPV | Net Present Value Amount | Numeric | Generic Edit | 15 | 2 | Allow NULL? |
| 14 | BCANPB | Net Present Value Bill Code | String | Generic Edit | 4 | 0 | Allow NULL? |
| 15 | BCIRRN | Internal Rate of Return | Numeric | Generic Edit | 15 | 2 | Allow NULL? |
| 16 | BCIRRB | Internal Rate of Return Bill Code | String | Generic Edit | 4 | 0 | Allow NULL? |
| 17 | BCABSP | Building Sales Price | Numeric | Generic Edit | 15 | 2 | Allow NULL? |
| 18 | BCNPFS | Net Proceeds From Sale | Numeric | Generic Edit | 15 | 2 | Allow NULL? |
| 19 | BCAYSN | Year For Stabilized Net Operating Income | Numeric | Generic Edit | 4 | 0 | Allow NULL? |
| 20 | BCANOI | Stabilized Net Operating Income Amount | Numeric | Generic Edit | 15 | 2 | Allow NULL? |
| 21 | BCATMP | Time Period | Numeric | Generic Edit | 3 | 0 | Allow NULL? |
| 22 | BCATPT | Time Period Type | String | Generic Edit | 2 | 0 | Allow NULL? |
| 23 | BCARAC | Account Association Code | String | Generic Edit | 4 | 0 | Allow NULL? |
| 24 | BCXPCT | X Percentage | Numeric | Generic Edit | 7 | 4 | Allow NULL? |
| 25 | BCGLC | G/L Offset | String | Generic Edit | 4 | 0 | Allow NULL? |
| 26 | BCGLC3 | G/L Class | String | Generic Edit | 4 | 0 | Allow NULL? |
| 27 | BCFERT | Fee Rate | Numeric | Generic Edit | 15 | 6 | Allow NULL? |
| 28 | BCMIND | Dollars-Minimum | Numeric | Generic Edit | 15 | 2 | Allow NULL? |
| 29 | BCDMAX | Dollars-Maximum | Numeric | Generic Edit | 15 | 2 | Allow NULL? |
| 30 | BCURCD | User Reserved Code | String | Generic Edit | 2 | 0 | Allow NULL? |
| 31 | BCURDT | User Reserved Date | Date | Generic Edit | 6 | 0 | |
| 32 | BCURAT | User Reserved Amount | Numeric | Generic Edit | 15 | 2 | Allow NULL? |
| 33 | BCURAB | User Reserved Number | Numeric | Generic Edit | 8 | 0 | Allow NULL? |
| 34 | BCURRF | User Reserved Reference | String | Generic Edit | 15 | 0 | Allow NULL? |
| 35 | BCTORG | Transaction Originator | String | Generic Edit | 10 | 0 | Allow NULL? |
| 36 | BCENTJ | Date - Entered | Date | Generic Edit | 6 | 0 | |
| 37 | BCJOBN | Work Station ID | String | Generic Edit | 10 | 0 | Allow NULL? |
| 38 | BCUSER | User ID | String | Generic Edit | 10 | 0 | Allow NULL? |
| 39 | BCPID | Program ID | String | Generic Edit | 10 | 0 | Allow NULL? |
| 40 | BCUPMJ | Date - Updated | Date | Generic Edit | 6 | 0 | |
| 41 | BCUPMT | Time - Last Updated | Numeric | Generic Edit | 6 | 0 | Allow NULL? |
| 42 | BCOPFL | Option Flag | Character | Generic Edit | 1 | 0 | Allow NULL? |
| 43 | BCAACT | Assumption Action 01 | String | UDC (15L UA) | 2 | 0 | Allow NULL? |
| 44 | BCARRID | Recycle Assumption Rule ID | String | Generic Edit | 10 | 0 | Allow NULL? |
| 45 | BCRONLY | Building Constants Rule Option | Character | Generic Edit | 1 | 0 | Allow NULL? |