| Table | Table Description | Column# | Prefix | Alias | Column Description | Data Type | Edit Type | Length | Decimals |
---|
TOP15L: Adv Real Estate Forecasting |
1 | F15L108 | AREF Base Account Definition | 5 | AD | FY | Fiscal Year | Numeric | Generic Edit | 2 | 0 |
2 | F15L111 | AREF Account Status Detail | 5 | AD | FY | Fiscal Year | Numeric | Generic Edit | 2 | 0 |
TOP42I: Outbound Inventory Management |
3 | F42I011 | Outbound Inventory Agreement Details | 18 | OQ | ADFY | Audit Frequency | Character | UDC | 1 | 0 |
4 | F42I07 | Outbound Inventory Agreement Details Change History | 44 | OQ | ADFY | Audit Frequency | Character | UDC | 1 | 0 |
User Defined Codes are, by design, customisable and thus will differ from system to system depending on the business requirements.
TOPUDC 42I / AF (Audit Frequency) stock values
| Value | Description | Special Handling Code | Hard Coded |
---|
1 | | . | | N |
2 | D | Daily | | Y |
3 | H | Semiannually | | Y |
4 | M | Monthly | | Y |
5 | Q | Quarterly | | Y |
6 | W | Weekly | | Y |
7 | Y | Annually | | Y |