| Table | Table Description | Column# | Prefix | Alias | Column Description | Data Type | Edit Type | Length | Decimals |
|---|
| TOP43Q: Strategic Sourcing |
| 1 | F43Q90 | Sourcing Constants | 5 | SC | AT6 | Search Type | String | UDC | 3 | 0 |
User Defined Codes are, by design, customisable and thus will differ from system to system depending on the business requirements.
TOPUDC 01 / ST (Search Type) stock values
| Value | Description | Special Handling Code | Hard Coded |
|---|
| 1 | A | Applicants | | N |
| 2 | B | Bidder | | N |
| 3 | C | Customers | | N |
| 4 | CMQ | Case Provider Group | | Y |
| 5 | D | Competitor | | Y |
| 6 | DL | Workflow Distribution List | | Y |
| 7 | E | Employees | | N |
| 8 | EXU | Excise Unit | | N |
| 9 | F | Facilities | | N |
| 10 | I | Investors | | N |
| 11 | J | Jobs | | N |
| 12 | JP | Junction Point/Port | | N |
| 13 | LI | Delivery Address | | N |
| 14 | M | Mail Distribution List | | N |
| 15 | N | New Hire | | N |
| 16 | O | Company | | N |
| 17 | P | Prospects | | N |
| 18 | PA | Partner | | N |
| 19 | Q | Participants | | N |
| 20 | R | Role | | Y |
| 21 | S | Subcontractors | | N |
| 22 | SG | Sales Group | | Y |
| 23 | SVQ | Service Order Queue | | Y |
| 24 | T | Tenants | | N |
| 25 | TAX | Tax Authorities | | N |
| 26 | TC | Transportation Carriers | | N |
| 27 | V | Suppliers | | N |
| 28 | W | Warehouse | | N |
| 29 | X | Ex-employees | | N |
| 30 | Z2 | Data Rep Test | | N |
