Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/PMR10000
Product: Manufacturing (346)
Series:
Display Name: PM_Vendor Group Display Name: Manufacturing POP
Physical Name: PMR10000
Technical Name: PM_Vendor
Group Technical Name: Manufacturing POP
| Seq No | Physical Name | Display Name | Dexterity Data Type | SQL Data Type | Length | |
|---|---|---|---|---|---|---|
| 1 | VENDORID  | Vendor ID | String | STR_15_Vendor_ID | 15 | |
Key to the PM Vendor Master File (PM00200).
Click to show/hideSELECT
['PM_Vendor'].VENDORID AS 'PM_Vendor-Vendor ID'
,['PM Vendor Master File'].VENDORID AS 'PM Vendor Master File-Vendor ID'
FROM
PMR10000 AS ['PM_Vendor']
INNER JOIN
PM00200 AS ['PM Vendor Master File']
ON
['PM_Vendor'].VENDORID = ['PM Vendor Master File'].VENDORID | ||||||
| 2 | POFOB_I | PO FOB | String | STR15 | 15 | |