| Column | Field | Description | Data Type | Edit Type | Length | Decimals | SQL Create Statement |
---|
| 1 | SGMCU | Business Unit | String | Generic Edit | 12 | 0 | Allow NULL? |
| 2 | SGRVNB | Revision Number | Numeric | Generic Edit | 3 | 0 | Allow NULL? |
| 3 | SGTEXR | EP Tenant Exclusion Rule | String | Generic Edit | 10 | 0 | Allow NULL? |
| 4 | SGMCUS | Business Unit - Subsequent | String | Generic Edit | 12 | 0 | Allow NULL? |
| 5 | SGECMP | Computation Method | Character | Generic Edit | 1 | 0 | Allow NULL? |
| 6 | SGCRCD | Currency Code - From | String | Generic Edit | 3 | 0 | Allow NULL? |
| 7 | SGEFTB | Date - Beginning Effective | Date | Generic Edit | 6 | 0 | |
| 8 | SGEFTE | Date - Ending Effective | Date | Generic Edit | 6 | 0 | |
| 9 | SGGLMD | Area Calculation Method | Character | UDC (15 OM) | 1 | 0 | Allow NULL? |
| 10 | SGUNIT | Unit | String | Generic Edit | 8 | 0 | Allow NULL? |
| 11 | SGGLC | G/L Offset | String | Generic Edit | 4 | 0 | Allow NULL? |
| 12 | SGSFDM | Area Method | Character | UDC (15 DM) | 1 | 0 | Allow NULL? |
| 13 | SGARDEFID | Area Definition ID | String | Generic Edit | 10 | 0 | Allow NULL? |
| 14 | SGSTMB | Lessee Flag | Character | UDC (15 LF) | 1 | 0 | Allow NULL? |
| 15 | SGEXCLRB | Exclusion Reconcile Billings | Character | Generic Edit | 1 | 0 | Allow NULL? |
| 16 | SGEXCLTOT | Tenant Exclusion Rule Total | Numeric | Generic Edit | 15 | 2 | Allow NULL? |
| 17 | SGAOUTE | Area Of Unit To Exclude | Numeric | Generic Edit | 15 | 2 | Allow NULL? |
| 18 | SGUSER | User ID | String | Generic Edit | 10 | 0 | Allow NULL? |
| 19 | SGMKEY | Machine Key | String | Generic Edit | 15 | 0 | Allow NULL? |
| 20 | SGPID | Program ID | String | Generic Edit | 10 | 0 | Allow NULL? |
| 21 | SGUPMJ | Date - Updated | Date | Generic Edit | 6 | 0 | |
| 22 | SGUPMT | Time - Last Updated | Numeric | Generic Edit | 6 | 0 | Allow NULL? |
| 23 | SGTORG | Transaction Originator | String | Generic Edit | 10 | 0 | Allow NULL? |
| 24 | SGENTJ | Date - Entered | Date | Generic Edit | 6 | 0 | |
| 25 | SGOCCROA | AREF Occupancy REM Or AREF | Character | Generic Edit | 1 | 0 | Allow NULL? |
| 26 | SGAREFODO | AREF Occupancy Data Option | Character | Generic Edit | 1 | 0 | Allow NULL? |
| 27 | SGAM01 | EP Unit Type | String | UDC (15 EU) | 3 | 0 | Allow NULL? |
| 28 | SGEXCLRT | Exclusion Retrieval Type | Character | Generic Edit | 1 | 0 | Allow NULL? |
| 29 | SGTUATE | Threshold Unit Area To Exclude | Numeric | Generic Edit | 15 | 2 | Allow NULL? |
| 30 | SGEXCLAMT | Exclusion Amount By Bill Code | Numeric | Generic Edit | 15 | 2 | Allow NULL? |
| 31 | SGCENTYR | Century/Year | Numeric | Generic Edit | 4 | 0 | Allow NULL? |
| 32 | SGARTY | Area Type | String | UDC (15 AR) | 3 | 0 | Allow NULL? |