| Table | Table Description | Column# | Prefix | Alias | Column Description | Data Type | Edit Type | Length | Decimals |
---|
TOP00: Foundation Environment |
1 | F4096 | Sales Flex Accounting | 13 | FA | SFIT | Data Item | 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 40 / DI (Data Item) stock values
| Value | Description | Special Handling Code | Hard Coded |
---|
1 | AC01 | Category Code 1 | 1 | Y |
2 | AC02 | Category Code 02 | 1 | Y |
3 | AC03 | Category Code 03 | 1 | Y |
4 | AC04 | Category Code 04 | 1 | Y |
5 | AC05 | Region | 1 | Y |
6 | AC06 | Category Code 06 | 1 | Y |
7 | AC07 | Category Code 07 | 1 | Y |
8 | AC08 | Category Code 08 | 1 | Y |
9 | AC09 | Category Code09 | 1 | Y |
10 | AC10 | Category Code 10 | 1 | Y |
11 | AC11 | Category Code 11 | 1 | Y |
12 | AC12 | Category Code 12 | 1 | Y |
13 | AC13 | Category Code 13 | 1 | Y |
14 | AC14 | Category Code 14 | 1 | Y |
15 | AC15 | Category Code 15 | 1 | Y |
16 | AC16 | Category Code 16 | 1 | Y |
17 | AC17 | Category Code 17 | 1 | Y |
18 | AC18 | Category Code 18 | 1 | Y |
19 | AC19 | Category Code 19 | 1 | Y |
20 | AC20 | Category Code 20 | 1 | Y |
21 | AC21 | Category Code 21 | 1 | Y |
22 | AC22 | Category Code 22 | 1 | Y |
23 | AC23 | Category Code 23 | 1 | Y |
24 | AC24 | Category Code 24 | 1 | Y |
25 | AC25 | Category Code 25 | 1 | Y |
26 | AC26 | Category Code 26 | 1 | Y |
27 | AC27 | Area | 1 | Y |
28 | AC28 | Category Code 28 | 1 | Y |
29 | AC29 | Category Code 29 | 1 | Y |
30 | AC30 | Category Code 30 | 1 | Y |
31 | AN8 | Address Number | 3 | Y |
32 | AST | Price Adjustment Name | 4 | Y |
33 | CYCL | Cycle Count Category | 2 | Y |
34 | DOC | Document Number | 3 | Y |
35 | DOCO | Sales Order Number | 3 | Y |
36 | EMCU | Business Unit - Header | 3 | Y |
37 | GLPT | GL Category | 2 | Y |
38 | ITM | Item Number - Short | 3 | Y |
39 | MCU | SO Revenue Business Unit | 3 | Y |
40 | MKFR | Mark for Address | 3 | Y |
41 | PA01 | Rebate Beneficiary | 4 | Y |
42 | PRP6 | Group - Item Dimension | 2 | Y |
43 | PRP7 | Group - Warehouse Process 1 | 2 | Y |
44 | PRP8 | Group - Warehouse Process 2 | 2 | Y |
45 | PRP9 | Group - Warehouse Process 3 | 2 | Y |
46 | SHAN | Address Number - Ship To | 3 | Y |
47 | SHCM | Shipping Commodity Class | 2 | Y |
48 | SHCN | Shipping Conditions Code | 2 | Y |
49 | SLM2 | SO Salesman Number 2 | 3 | Y |
50 | SLSM | SO Salesman Number 1 | 3 | Y |
51 | SRP1 | Sales Catalog Section | 3 | Y |
52 | SRP2 | Subsection | 3 | Y |
53 | SRP3 | Sales Category Code 3 | 3 | Y |
54 | SRP4 | Sales Category Code 4 | 3 | Y |
55 | SRP5 | Sales Category Code 5 | 3 | Y |
56 | SRP6 | Category Code 6 | 2 | Y |
57 | SRP7 | Category Code 7 | 2 | Y |
58 | SRP8 | Category Code 8 | 2 | Y |
59 | SRP9 | Category Code 9 | 2 | Y |
60 | SRPO | Category Code 10 | 2 | Y |
61 | TXA1 | Tax Area | 3 | Y |