| Table | Table Description | Column# | Prefix | Alias | Column Description | Data Type | Edit Type | Length | Decimals | |
|---|---|---|---|---|---|---|---|---|---|---|
| 15: Property Management | ||||||||||
| 1 | F15011 | Billings Generation Control Master | 3 | NK | GENT | Generation Type | Character | UDC | 1 | 0 |
| 2 | F15011B | BIllings Generation Control | 3 | NK | GENT | Generation Type | Character | UDC | 1 | 0 |
| 3 | F15016 | Tenant Escalation Master | 46 | NU | GENT | Generation Type | Character | UDC | 1 | 0 |
| 4 | F15016B | Tenant Escalation Master | 48 | NU | GENT | Generation Type | Character | UDC | 1 | 0 |
| 5 | F1502 | Recurring Billings Master | 41 | NF | GENT | Generation Type | Character | UDC | 1 | 0 |
| 6 | F15020 | Extended Billings Master | 4 | NN | GENT | Generation Type | Character | UDC | 1 | 0 |
| 7 | F1502B | Recurring Billings Master | 41 | NF | GENT | Generation Type | Character | UDC | 1 | 0 |
| 8 | F1502WB | Estimated EP Recurring Billings | 43 | N4 | GENT | Generation Type | Character | UDC | 1 | 0 |
| 9 | F1511 | Tenant/Lease Billings Detail | 1 | NJ | GENT | Generation Type | Character | UDC | 1 | 0 |
| 10 | F1511B | Lease Billings Master | 1 | NJ | GENT | Generation Type | Character | UDC | 1 | 0 |
| 11 | F1511B1 | Billing Batches Summary | 1 | NW | GENT | Generation Type | Character | UDC | 1 | 0 |
| 12 | F1511H | Tenant/Lease Billings Detail History | 1 | N# | GENT | Generation Type | Character | UDC | 1 | 0 |
| 13 | F1511HB | Lease Billings History | 1 | NC | GENT | Generation Type | Character | UDC | 1 | 0 |
| 14 | F15153 | Lease Cap History | 12 | LC | GENT | Generation Type | Character | UDC | 1 | 0 |
| 15 | F15303 | E.P. Class Expenses History | 13 | CH | GENT | Generation Type | Character | UDC | 1 | 0 |
| 17: Customer Service Management | ||||||||||
| 16 | F1794 | Billing/Amort Control Master | 6 | NK | GENT | Generation Type | Character | UDC | 1 | 0 |
User Defined Codes are, by design, customisable and thus will differ from system to system depending on the business requirements.
UDC 15 / GE (Generation Type) stock values
| Value | Description | Special Handling Code | Hard Coded | |
|---|---|---|---|---|
| 1 | 1 | Recurring Billings | N | Y |
| 2 | 2 | Expense Participation | N | Y |
| 3 | 3 | Sales Overage | N | Y |
| 4 | 4 | Escalation | N | Y |
| 5 | 5 | A/R Fees and Interest | N | Y |
| 6 | 6 | Estimated Exp. Participation | N | Y |
| 7 | 7 | Manual Invoice | N | Y |
| 8 | 8 | Product Scales Weekly Record | N | Y |
| 9 | A | CSMS Domestic Amortizations | N | Y |
| 10 | B | CSMS Domestic Billings | N | Y |
| 11 | C | CSMS Domestic Reallocations | N | Y |
| 12 | D | CSMS Foreign Amortizations | N | Y |
| 13 | E | CSMS Foreign Billings | N | Y |
| 14 | F | CSMS Foreign Reallocations | N | Y |
| 15 | G | CSMS Domestic Cancel Recongniz | N | Y |
| 16 | H | CSMS Domestic Cancel Long Term | N | Y |
| 17 | I | CSMS Domestic Cancel Short Ter | N | Y |
| 18 | J | CSMS Domestic Cancel Recognize | N | Y |
| 19 | K | CSMS Domestic Cancel Long Term | N | Y |
| 20 | L | CSMS Domestic Cancel Short Ter | N | Y |