| Table | Table Description | Column# | Prefix | Alias | Column Description | Data Type | Edit Type | Length | Decimals | |
|---|---|---|---|---|---|---|---|---|---|---|
| 09E: Expense Reimbursment | ||||||||||
| 1 | F20112 | Expense Report Detail | 15 | ED | EXPSTAT | Expense Status | String | UDC | 2 | 0 |
User Defined Codes are, by design, customisable and thus will differ from system to system depending on the business requirements.
UDC 09E / ES (Expense Status) stock values
| Value | Description | Special Handling Code | Hard Coded | |
|---|---|---|---|---|
| 1 | 10 | Approved | N | Y |
| 2 | 15 | Incomplete | N | Y |
| 3 | 20 | Preferred Vendor Not Used | N | Y |
| 4 | 30 | Allowance Amount Exceeded | N | Y |
| 5 | 32 | Allow Amt Exceed, No Pref Vend | N | Y |
| 6 | 40 | Audit Amount Exceeded | N | Y |
| 7 | 42 | Audit Amt Exceed, No Pref Vend | N | Y |
| 8 | 50 | Allowance & Audit Amt Exceeded | N | Y |
| 9 | 52 | Except:Allow, Audit, Pref Vend | N | Y |
| 10 | 60 | Dup Expense on Current Rpt | N | Y |
| 11 | 70 | Dup Expense on Previous Rpt | N | Y |
| 12 | 80 | Dup Expense on Current & Prev | N | Y |
| 13 | 90 | Combination of Exceptions | N | Y |