Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/APR_PIP40100
Product: Payroll Integration to Payable (4522)
Series:
Display Name: APR Payroll Vendors Group Display Name: Payroll Integration to Payables
Physical Name: APR_PIP40100
Technical Name: APR_PayrollVendorSetup
Group Technical Name: Payroll Integration to Payables
Seq No | Physical Name | Display Name | Dexterity Data Type | SQL Data Type | Length | |
---|---|---|---|---|---|---|
1 | APR_PR_VendorRecordType | APR PR Vendor Record Type | Integer | APR_Payroll_Vendor_Setup | 0 | |
2 | PAYROLCD | Payroll Code | String | STR6_Payroll_Code | 6 | |
3 | EMPLOYID | Employee ID | String | STR15_Employee_ID | 15 | |
4 | VENDORID | Vendor ID | String | STR_15_Vendor_ID | 15 | |
Key to the PM Vendor Master File (PM00200).
Click to show/hideSELECT
['APR Payroll Vendors'].VENDORID AS 'APR Payroll Vendors-Vendor ID'
,['PM Vendor Master File'].VENDORID AS 'PM Vendor Master File-Vendor ID'
FROM
APR_PIP40100 AS ['APR Payroll Vendors']
INNER JOIN
PM00200 AS ['PM Vendor Master File']
ON
['APR Payroll Vendors'].VENDORID = ['PM Vendor Master File'].VENDORID | ||||||
5 | APR_Voucher_Desc | APR Voucher Desc | String | APR_Voucher_Desc | 30 | |
6 | APR_Voucher_Doc_Number | APR Voucher Doc Number | String | APR_Voucher_Number | 20 | |
7 | CHANGEBY_I | Change By | String | STR15_User_ID | 15 | |
8 | CHANGEDATE_I | Change Date | Date | DT | 8 | |
9 | ADRSCODE | Address Code | String | STR15_Address_Code | 15 | |
10 | ACTINDX | Account Index | Long Integer | LI_14 | 14 | |
Key to the Account Index Master (GL00105).
Click to show/hideSELECT
['APR Payroll Vendors'].ACTINDX AS 'APR Payroll Vendors-Account Index'
,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index'
FROM
APR_PIP40100 AS ['APR Payroll Vendors']
INNER JOIN
GL00105 AS ['Account Index Master']
ON
['APR Payroll Vendors'].ACTINDX = ['Account Index Master'].ACTINDX | ||||||
11 | VADCDTRO | Vendor Address Code - Remit To | String | STR15_Address_Code | 15 | |
Partial key to the PM Address MSTR (PM00300).
Click to show/hideSELECT
['APR Payroll Vendors'].VADCDTRO AS 'APR Payroll Vendors-Vendor Address Code - Remit To'
,['PM Address MSTR'].ADRSCODE AS 'PM Address MSTR-Address Code'
FROM
APR_PIP40100 AS ['APR Payroll Vendors']
INNER JOIN
PM00300 AS ['PM Address MSTR']
ON
['APR Payroll Vendors'].VADCDTRO = ['PM Address MSTR'].ADRSCODE
AND
['APR Payroll Vendors'].VENDORID = ['PM Address MSTR'].VENDORID |