SmartList Payroll Master (ASIEXP05)

azurecurve Products SmartList (1493)PathnameSmartList Payroll Master (ASIEXP05)

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

Display Name: SmartList Payroll Master
Physical Name: ASIEXP05
Technical Name: ASI_UPR_MSTR_Explorer

Group Display Name: SmartList Master
Group Technical Name: ASI_Explorer_Logical_MSTR

Seq No	Physical Name	Display Name	Dexterity Data Type	SQL Data Type	Length
1	ASI_Order_By	ASI_Order_By	Long Integer	LI_14	14
2	EMPLOYID	Employee ID	String	STR15_Employee_ID	15
3	EMPLCLAS	Employee Class	String	STR15_Employee_Class	15
4	INACTIVE	Inactive	Boolean	CB_Inactive	0
5	LASTNAME	Last Name	String	STR20	20
6	FRSTNAME	First Name	String	STR15	15
7	MIDLNAME	Middle Name	String	STR15	15
8	ADDRESS1	Address 1	String	STR60	60
9	ADDRESS2	Address 2	String	STR60	60
10	ADDRESS3	Address 3	String	STR60	60
11	CITY	City	String	STR35	35
12	STATE	State	String	STR30_State	29
13	COUNTRY	Country	String	STR60	60
14	ZIPCODE	Zip Code	String	STR10	10
15	SOCSCNUM	Social Security Number	String	STR15_Social_Security_Number	15
16	BRTHDATE	Birth Date	Date	DT	8
17	GENDER	Gender	Integer	DDL_Gender	0
18	ETHNORGN	Ethnic Origin	Integer	DDL_Ethnic Origin	0
19	Calc_Min_Wage_Bal	Calc Min Wage Bal	Boolean	CB_CalcMinWageBal	0
20	DEPRTMNT	Department	String	STR6_Payroll_Code	6
21	JOBTITLE	Job Title	String	STR6_Payroll_Code	6
22	WCACFPAY	Which Cash Account For Pay	Integer	GB	0
23	ACTINDX	Account Index	Long Integer	LI_14	14
	Key to the Account Index Master (GL00105). Click to show/hide SELECT ['SmartList Payroll Master'].ACTINDX AS 'SmartList Payroll Master-Account Index' ,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index' FROM ASIEXP05 AS ['SmartList Payroll Master'] INNER JOIN GL00105 AS ['Account Index Master'] ON ['SmartList Payroll Master'].ACTINDX = ['Account Index Master'].ACTINDX
24	WKHRPRYR	Work Hours Per Year	Integer	INT4_U0	4
25	STRTDATE	Start Date	Date	DT	8
26	DEMPINAC	Date Employee Inactivated	Date	DT	8
27	RSNEMPIN	Reason Employee Inactivated	String	STR30	30
28	MINETPAY	Minimum Net Pay	Currency	DLR11_$U2	14
29	SUTASTAT	Suta State	String	STR2_State_Code	2
30	WRKRCOMP	Workers Comp	String	STR6_Payroll_Code	6
31	ATACRVAC	Auto Accrue Vacation	Boolean	CB_Accrue_Vacation:	0
32	VACCRAMT	Vacation Accrual Amount	Long Integer	LI6_U2	6
33	VACCRMTH	Vacation Accrual Method	Integer	GB	0
34	VACAPRYR	Vacation Hours Per Year	Long Integer	LI6_U2	6
35	VACAVLBL	Vacation Available	Long Integer	LI6_S2	6
36	ATACRSTM	Auto Accrue Sick Time	Boolean	CB_Accrue_Sick_Time:	0
37	STMACMTH	Sick Time Accrual Method	Integer	GB	0
38	SKTMACAM	Sick Time Accrual Amount	Long Integer	LI6_U2	6
39	SIKTIMAV	Sick Time Available	Long Integer	LI6_S2	6
40	SKTMHPYR	Sick Time Hours Per Year	Long Integer	LI6_U2	6
41	USERDEF1	User Defined 1	String	STR20	20
42	USERDEF2	User Defined 2	String	STR20	20
43	NOTEINDX	Note Index	Currency	DLR14	14
	Key to the Record Notes Master (SY03900). Click to show/hide SELECT ['SmartList Payroll Master'].NOTEINDX AS 'SmartList Payroll Master-Note Index' ,['Record Notes Master'].NOTEINDX AS 'Record Notes Master-Note Index' FROM ASIEXP05 AS ['SmartList Payroll Master'] INNER JOIN SY03900 AS ['Record Notes Master'] ON ['SmartList Payroll Master'].NOTEINDX = ['Record Notes Master'].NOTEINDX
44	EXMFRFED	Exempt From Federal	Boolean	CB_Exempt_From_Federal_Withholding	0
45	FDFLGSTS	Federal Filing Status	String	STR6_Payroll_Code	6
46	FEDEXMPT	Federal Exemptions	Integer	INT2_U0	2
47	ADFDWHDG	Additional Federal Withholding	Currency	DLR11_$S2	14
48	ESTFEDWH	Estimated Federal Withholding	Currency	DLR11_$U2	14
49	STATECD	State Code	String	STR2_State_Code	2
50	LOCALTAX	Local Tax	String	STR6_Payroll_Code	6
51	W2BF942E	W2 Box For 942 Employee	Boolean	CB_942_Employee	0
52	W2BFDCSD	W2 Box For Deceased	Boolean	CB_Deceased	0
53	W2BFDCMP	W2 Box For Deferred Compensation	Boolean	CB_Deferred_Compensation	0
54	W2BFLREP	W2 Box For Legal Representative	Boolean	CB_Legal_Representative	0
55	W2BFPPLN	W2 Box For Pension Plan	Boolean	CB_Pension_Plan	0
56	W2BFSTEM	W2 Box For Statutory Employee	Boolean	CB_Statutory_Employee	0
57	MCRQGEMP	Medicare Qualified Govt Employee	Boolean	CB_Medicare_Qualified_Govt_Employee	0
58	EICFLGST	EIC Filing Status	String	STR6_Payroll_Code	6
59	NYTXDiff	Withhold NY Tax Diff	Boolean	CB_Withhold_NY_Diff	0
60	ASI_Favorite_Sequence	ASI_Favorite_Sequence	Long Integer	ASI_LI_10_RU	10
61	ADRSCODE	Address Code	String	STR15_Address_Code	15
62	ALTERNATENAME	Alternate Name	String	STR20	20
63	BENADJDATE	Ben Adj Date	Date	DT	8
64	BENEFITEXPIRE_I	Benefit Expire	Date	DT	8
65	BIRTHDAY	Birth Day	Integer	INT	0
66	BIRTHMONTH	Birth Month	Integer	INT	0
67	CHANGEBY_I	Change By	String	STR15_User_ID	15
68	CHANGEDATE_I	Change Date	Date	DT	8
69	CITIZEN	Citizen	Boolean	CB_Citizen	0
70	DATEOFLASTREVIEW_I	Date Of Last Review	Date	DT	8
71	DATEOFNEXTREVIEW_I	Date Of Next Review	Date	DT	8
72	DISABLEDVETERAN	Disabled Veteran	Boolean	CB_DisableVet	0
73	DIVISIONCODE_I	Division Code	String	STR6_Payroll_Code	6
74	FEDCLSSCD	Federal Classification Code	String	STR10_LBAU	10
75	HANDICAPPED	Handicapped	Boolean	CB_Handicap	0
76	HRSTATUS	HR Status	Integer	DDL_HRStatus	0
77	I9RENEW	I9renew	Date	DT	8
78	LASTDAYWORKED_I	Last Day Worked	Date	DT	8
79	LOCATNID	Location ID	String	STR15_Location_ID	15
80	MARITALSTATUS	MaritalStatus	Integer	DDL_MaritalStatus	0
81	NICKNAME	NickName	String	STR20	20
82	NOTEINDX2	Note Index2	Currency	DLR14	14
83	Primary_Pay_Record	Primary Pay Record	String	STR6_Payroll_Code	6
84	RATECLSS	Rate Class	String	STR15	15
85	SMOKER_I	Smoker	Boolean	CB_Smoker	0
86	SPOUSE	Spouse	String	STR15	15
87	SPOUSESSN	Spouse SSN	String	STR15_Social_Security_Number	15
88	SUPERVISORCODE_I	Supervisor Code	String	STR6_U	6
89	EMPLOYMENTTYPE	Type of Employment	Integer	DDL_Employment_Type	0
90	UNIONCD	Union Code	String	STR6	6
91	UNIONEMPLOYEE	Union Employee	Boolean	CB_Union_Emp	0
92	VERIFIED	Verified	Boolean	CB_Verifed	0
93	VETERAN	Veteran	Boolean	CB_Military	0
94	VIETNAMVETERAN	Vietnam Veteran	Boolean	CB_Vietnam	0
95	WRNSTFLSBLWZR	Warn Sick Time Falls Below Zero	Boolean	CB_WarnSickTimeFallsBelowZero	0
96	WRNVCNFLSBLWZR	Warn Vacation Falls Below Zero	Boolean	CB_WarnVacationFallsBelowZero	0
97	COUNTY	County	String	STR60	60
98	PHONE1	Phone 1	String	Phone_Number	14
99	PHONE2	Phone 2	String	Phone_Number	14
100	PHONE3	Phone 3	String	Phone_Number3	14
101	FAX	Fax	String	STR14_FAX	14
102	Foreign_Address	Foreign Address	Boolean	CB_Foreign_Address	0
103	Foreign_StateProvince	Foreign State/Province	String	STR23	23
104	Foreign_Postal_Code	Foreign Postal Code	String	STR15_LBAU	15
105	CCode	Country Code	String	STR6_VAT	6
	Key to the VAT Country Code MSTR (VAT10001). Click to show/hide SELECT ['SmartList Payroll Master'].CCode AS 'SmartList Payroll Master-Country Code' ,['VAT Country Code MSTR'].CCode AS 'VAT Country Code MSTR-Country Code' FROM ASIEXP05 AS ['SmartList Payroll Master'] INNER JOIN VAT10001 AS ['VAT Country Code MSTR'] ON ['SmartList Payroll Master'].CCode = ['VAT Country Code MSTR'].CCode
106	OTHERVET	Other Veterans	Boolean	CB_OtherVet	0

azurecurve Products SmartList (1493)PathnameSmartList Payroll Master (ASIEXP05)

Click to show/hide

Click to show/hide

Click to show/hide

Leave a Reply Cancel reply