APR Payroll Vendors (APR_PIP40100)

azurecurve Products Payroll Integration to Payable (4522)PayrollAPR Payroll Vendors (APR_PIP40100)

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
Physical Name: APR_PIP40100
Technical Name: APR_PayrollVendorSetup

Group Display Name: Payroll Integration to Payables
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/hide SELECT ['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/hide SELECT ['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/hide SELECT ['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

azurecurve Products Payroll Integration to Payable (4522)PayrollAPR Payroll Vendors (APR_PIP40100)

Leave a Reply Cancel reply