Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/APR_PIP00400
Product: Payroll Integration to Payable (4522)
Series:
Display Name: APR PIP Key MSTR Group Display Name: Payroll Integration to Payables
Physical Name: APR_PIP00400
Technical Name: APR_PIP_Key_MSTR
Group Technical Name: Payroll Integration to Payables
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
['APR PIP Key MSTR'].VENDORID AS 'APR PIP Key MSTR-Vendor ID'
,['PM Vendor Master File'].VENDORID AS 'PM Vendor Master File-Vendor ID'
FROM
APR_PIP00400 AS ['APR PIP Key MSTR']
INNER JOIN
PM00200 AS ['PM Vendor Master File']
ON
['APR PIP Key MSTR'].VENDORID = ['PM Vendor Master File'].VENDORID | ||||||
2 | CNTRLNUM | Control Number | String | STR20_LBAU | 20 |