| Table | Table Description | Column# | Prefix | Alias | Column Description | Data Type | Edit Type | Length | Decimals |
|---|
| TOP09E: Expense Reimbursment |
| 1 | F09E105 | Tax Mapping | 2 | TM | LOCATN | Location | String | UDC | 10 | 0 |
| 2 | F09E108 | Policy Edit Rules | 7 | PR | LOCATN | Location | String | UDC | 10 | 0 |
| 3 | F09E118 | Expense Category / Report Type to Pay Type Mapping | 4 | PM | LOCATN | Location | String | UDC | 10 | 0 |
| 4 | F09E150 | Credit Card Transaction Interface Table | 28 | CI | LOCATN | Location | String | UDC | 10 | 0 |
| 5 | F20112 | Expense Report Detail | 55 | ED | LOCATN | Location | String | UDC | 10 | 0 |
User Defined Codes are, by design, customisable and thus will differ from system to system depending on the business requirements.
TOPUDC 09E / EL (Expense Locations) stock values
| Value | Description | Special Handling Code | Hard Coded |
|---|
| 1 | ALHA | Alaska & Hawaii | | N |
| 2 | ARG | Argentina | | N |
| 3 | BRAZ | Brazil | | N |
| 4 | CAN | Canada | | N |
| 5 | DEN | Denver | | N |
| 6 | ENG | England | | N |
| 7 | FRAN | France | | N |
| 8 | GERM | Germany | | N |
| 9 | HONG | Hong Kong | | N |
| 10 | JAPAN | Japan | | N |
| 11 | LAV | Las Vegas | | N |
| 12 | MEX | Mexico | | N |
| 13 | NYSF | New York City & San Francisco | | N |
| 14 | PR | Paris | N | N |
| 15 | QUEB | Quebec | | N |
| 16 | SF | San Francisco | | N |
| 17 | SING | Singapore | | N |
| 18 | SNT | San Antonio | | N |
| 19 | TOKYO | Tokyo | | N |
| 20 | US | United States | | N |
