| Table | Table Description | Column# | Prefix | Alias | Column Description | Data Type | Edit Type | Length | Decimals |
---|
TOP43: Procurement |
1 | F74U0141 | ACM - Application / Certificate Master | 6 | AC | UKAPNM | Application Number | Numeric | Generic Edit | 6 | 0 |
TOP74U: United Kingdom Localizations |
2 | F74U0405 | SPC Certificate Holding Table - UK - 43 | 11 | CH | UKAPNM | Application Number | Numeric | Generic Edit | 6 | 0 |
3 | F74U0408 | SPC Lower Level Retention - UK - 43 | 8 | LR | UKAPNM | Application Number | Numeric | Generic Edit | 6 | 0 |
4 | F74U0409 | SPC Lower Level MCD - UK - 43 | 8 | LM | UKAPNM | Application Number | Numeric | Generic Edit | 6 | 0 |
5 | F74U0420 | SPC - Application Master - UK - 43 | 1 | SE | UKAPNM | Application Number | Numeric | Generic Edit | 6 | 0 |
6 | F74U0421 | Application Approval Invoice Overrides | 4 | IO | UKAPNM | Application Number | Numeric | Generic Edit | 6 | 0 |
7 | F74U0422 | SPC Application/Certificate Cross Reference File - UK - 43 | 5 | AC | UKAPNM | Application Number | Numeric | Generic Edit | 6 | 0 |
8 | F74U0425 | SPC - Certificate Master - UK - 43 | 12 | SF | UKAPNM | Application Number | Numeric | Generic Edit | 6 | 0 |
9 | F74U420A | SPC Application Amount Drill Down - UK - 43 | 1 | PA | UKAPNM | Application Number | Numeric | Generic Edit | 6 | 0 |
10 | F74U421A | SPC Application Approval History - UK - 43 | 4 | AH | UKAPNM | Application Number | Numeric | Generic Edit | 6 | 0 |