Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/PA40101
Product: Project Accounting (258)
Series:
Display Name: PA U of M Schedule Setup
Physical Name: PA40101
Technical Name: PA_UofM_SETP_HDR
Seq No | Physical Name | Display Name | Dexterity Data Type | SQL Data Type | Length | |
---|---|---|---|---|---|---|
1 | UOMSCHDL | U Of M Schedule | String | STR10_Schedule | 10 | |
Key to the Inventory U of M Schedule Setup (IV40201).
Click to show/hideSELECT
['PA U of M Schedule Setup'].UOMSCHDL AS 'PA U of M Schedule Setup-U Of M Schedule'
,['Inventory U of M Schedule Setup'].UOMSCHDL AS 'Inventory U of M Schedule Setup-U Of M Schedule'
FROM
PA40101 AS ['PA U of M Schedule Setup']
INNER JOIN
IV40201 AS ['Inventory U of M Schedule Setup']
ON
['PA U of M Schedule Setup'].UOMSCHDL = ['Inventory U of M Schedule Setup'].UOMSCHDL | ||||||
2 | UMSCHDSC | U Of M Schedule Description | String | STR30 | 30 | |
3 | NOTEINDX | Note Index | Currency | DLR14 | 14 | |
Key to the Record Notes Master (SY03900).
Click to show/hideSELECT
['PA U of M Schedule Setup'].NOTEINDX AS 'PA U of M Schedule Setup-Note Index'
,['Record Notes Master'].NOTEINDX AS 'Record Notes Master-Note Index'
FROM
PA40101 AS ['PA U of M Schedule Setup']
INNER JOIN
SY03900 AS ['Record Notes Master']
ON
['PA U of M Schedule Setup'].NOTEINDX = ['Record Notes Master'].NOTEINDX | ||||||
4 | BASEUOFM | Base U Of M | String | U_Of_M | 8 | |
5 | UMDPQTYS | U Of M Decimal Places QTYS | Integer | DDL_Decimal_Places_QTYS | 0 |