PM_Vendor (PMR10000)

azurecurve Products Manufacturing (346)3rd PartyPM_Vendor (PMR10000)

Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/PMR10000

Product: Manufacturing (346)
Series:

Display Name: PM_Vendor
Physical Name: PMR10000
Technical Name: PM_Vendor

Group Display Name: Manufacturing POP
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/hide SELECT ['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

Seq No

Physical Name

Display Name

Dexterity Data Type

SQL Data Type

Length

VENDORID

Vendor ID

String

STR_15_Vendor_ID

Key to the PM Vendor Master File (PM00200).

Click to show/hide

SELECT
       ['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

POFOB_I

PO FOB

String

STR15

azurecurve Products Manufacturing (346)3rd PartyPM_Vendor (PMR10000)

Click to show/hide

Leave a Reply Cancel reply