Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/PA40102
Product: Project Accounting (258)
Series: Project
Display Name: PA U of M Schedule Detail Setup
Physical Name: PA40102
Technical Name: PA_UofM_SETP_DTL
Seq No | Physical Name | Display Name | Dexterity Data Type | SQL Data Type | Length | |
---|---|---|---|---|---|---|
1 | UOMSCHDL ![]() | U Of M Schedule | STR10_Schedule | String | 10 | |
Key to the Inventory U of M Schedule Setup (IV40201).
Click to show/hideSELECT
['PA U of M Schedule Detail Setup'].UOMSCHDL AS 'PA U of M Schedule Detail Setup-U Of M Schedule'
,['Inventory U of M Schedule Setup'].UOMSCHDL AS 'Inventory U of M Schedule Setup-U Of M Schedule'
FROM
PA40102 AS ['PA U of M Schedule Detail Setup']
INNER JOIN
IV40201 AS ['Inventory U of M Schedule Setup']
ON
['PA U of M Schedule Detail Setup'].UOMSCHDL = ['Inventory U of M Schedule Setup'].UOMSCHDL | ||||||
2 | UOFM ![]() | U Of M | U_Of_M | String | 8 | |
3 | SEQNUMBR ![]() | Sequence Number | LI_Sequence_Number | Long Integer | 10 | |
4 | EQUIVUOM ![]() | Equivalent U Of M | U_Of_M | String | 8 | |
5 | EQUOMQTY ![]() | Equivalent U Of M QTY | DLR17_QTY_RBS0_UTR | Currency | 17 | |
6 | QTYBSUOM ![]() | QTY In Base U Of M | DLR17_QTY_RBS0_STR | Currency | 17 | |
7 | DEX_ROW_ID ![]() | int | int | 10 | ||
DEX_ROW_ID is an auto-numbered IDENTITY column used internally by Dexterity for lock management; it should not be used by developers to identify any particular piece of information. Microsoft MVP Mariano Gomez has a good write up on the DEX_ROW_ID column. |