HRPAYUS_D_EIWO_O - e-IWO Orders

e-IWO Orders information is stored in SAP table HRPAYUS_D_EIWO_O.
It is part of development package PC10 in software component PY-US. This development package consists of objects that can be grouped under "HR accounting: USA".

Fields for table HRPAYUS_D_EIWO_O

Field Name	Description	Is Key	Data Element	Data Type	Length
MANDT	Client	X	MANDT	CLNT	6
CASE_IDENTIFIER	IWO Case Identifier	X	HRPAYUS_EIWO_CASE_ID	CHAR	30
ORDER_IDENTIFIER	IWO Order Identifier	X	HRPAYUS_EIWO_ORDER_ID	CHAR	60
SEQUENTIAL_NUMBER	Sequence Number for Order Detail Record	X	HRPAYUS_EIWO_RECORD_SEQ_NUMBER	NUMC	10
CONTROL_NUMBER_INBOUND	Control Number for Order	X	HRPAYUS_EIWO_CONTROL_NUMBER	CHAR	44
CONTROL_NUMBER_OUTBOUND	Control Number for Order		HRPAYUS_EIWO_CONTROL_NUMBER	CHAR	44
UUID_PDF	22 char UUID for EIWO		HRPAYUS_EIWO_UUID	CHAR	44
UUID_XML_INBOUND	22 char UUID for EIWO		HRPAYUS_EIWO_UUID	CHAR	44
UUID_XML_OUTBOUND	22 char UUID for EIWO		HRPAYUS_EIWO_UUID	CHAR	44
DOCUMENT_ACTION_CODE	Type of IWO document		HRPAYUS_EIWO_DOC_ACTION_CODE	CHAR	6
MANUAL_OVERRIDE	Manual override		HRPAYUS_EIWO_MANUAL_OVERRIDE	CHAR	2
EVALUATED_STATUS	Order Status Evaluated by the System		HRPAYUS_EIWO_EVALUATED_STATUS	CHAR	2
RECORD_REASON	Acknowledgment Reason Code		HRPAYUS_EIWO_RECORD_REASON	CHAR	2
ORDER_RECEIVED_DATE	IWO Received Date		HRPAYUS_EIWO_ORD_RECEIVED_DATE	DATS	16
PAYROLL_AREA	Payroll Area		ABKRS	CHAR	4
PERNR	Personnel Number		P_PERNR	NUMC	16
GROUPING_VALUE	Grouping Value for Personnel Assignments		PCCE_GPVAL	CHAR	8
EMPLOYEE_SSN	Social Security Number		PC10_SSN	CHAR	22
REMITTANCE_IDENTIFIER	IWO Remittance Identifier		HRPAYUS_EIWO_REMITTANCE_ID	CHAR	40
JURISDICTION	Garnishment document jurisdiction		PB10_GORIG	CHAR	6
MULTI_IWO_STATE_CODE	e-IWO Multi State Code		HRPAYUS_EIWO_MULTI_STATE_CODE	CHAR	4
CATEGORY	Garnishment document category		PB10_GCATE	CHAR	2
ORDER_TYPE	Garnishment order type		PB10_ORDCD	CHAR	4
VENDOR_NUMBER	Garnishment vendor		PB10_LIFNR	CHAR	20
REMITTANCE_RULE	Remittance Rule		HRPAYUS_EIWO_REMITTANCE_RULE	NUMC	10
DEDUCTION_AMOUNT	Garnishment order deduction		HRPAYUS_EIWO_DEDUCTION_AMOUNT	CURR	8
DEDUCTION_UNIT	Garnishment order deduction unit		PB10_DEDUT	CHAR	2
CCPA_LIMIT	The highest percentage of income that can be withheld		HRPAYUS_EIWO_CCPA_LIMIT	NUMC	4
GARNISHMENT_RULE	Rule for calculating the non-exempt amount		PB10_EXCEP	CHAR	6
SERVICE_CHARGE	Service charge rule		PB10_SCRUL	CHAR	2
EMPLOYER_ID_ORDER	e-IWO Employer Identification Number		HRPAYUS_EIWO_EMPLOYER_ID	CHAR	40
EMPLOYER_ID_CORRECT	Correct Employer Identification Number		HRPAYUS_EIWO_CORRECT_ER_ID	CHAR	40
DOCUMENT_IMAGE_TEXT	Document Image Text		HRPAYUS_EIWO_DOC_IMAGE_TEXT	CHAR	50
DOCUMENT_TRACKING_NUMBER	Order Tracking Number		HRPAYUS_EIWO_ORDER_TRACK_NUM	CHAR	60
EMPLOYEE_LAST_NAME	Employee Last Name		HRPAYUS_EIWO_EE_LAST_NAME	CHAR	60
EMPLOYEE_FIRST_NAME	Employee First Name		HRPAYUS_EIWO_EE_FIRST_NAME	CHAR	60
EMPLOYEE_BIRTH_DATE	Employee Birth Date		HRPAYUS_EIWO_EE_BIRTH_DATE	DATS	16
SEND_EMPLOYEE_COPY_INDICATOR	Authorization to Send Copy		HRPAYUS_EIWO_AUTH_SEND_COPY	CHAR	2
OBLIGEE_LAST_NAME	Obligee Last Name		HRPAYUS_EIWO_OBL_LAST_NAME	CHAR	114
OBLIGEE_FIRST_NAME	Obligee First Name		HRPAYUS_EIWO_OBL_FIRST_NAME	CHAR	60
CHILD1_LAST_NAME	Child Last Name		HRPAYUS_EIWO_CHILD_LAST_NAME	CHAR	60
CHILD1_FIRST_NAME	Child First Name		HRPAYUS_EIWO_CHILD_FIRST_NAME	CHAR	60
CHILD1_BIRTH_DATE	Child Birth Date		HRPAYUS_EIWO_CHILD_BIRTH_DATE	DATS	16
CHILD2_LAST_NAME	Child Last Name		HRPAYUS_EIWO_CHILD_LAST_NAME	CHAR	60
CHILD2_FIRST_NAME	Child First Name		HRPAYUS_EIWO_CHILD_FIRST_NAME	CHAR	60
CHILD2_BIRTH_DATE	Child Birth Date		HRPAYUS_EIWO_CHILD_BIRTH_DATE	DATS	16
CHILD3_LAST_NAME	Child Last Name		HRPAYUS_EIWO_CHILD_LAST_NAME	CHAR	60
CHILD3_FIRST_NAME	Child First Name		HRPAYUS_EIWO_CHILD_FIRST_NAME	CHAR	60
CHILD3_BIRTH_DATE	Child Birth Date		HRPAYUS_EIWO_CHILD_BIRTH_DATE	DATS	16
CHILD4_LAST_NAME	Child Last Name		HRPAYUS_EIWO_CHILD_LAST_NAME	CHAR	60
CHILD4_FIRST_NAME	Child First Name		HRPAYUS_EIWO_CHILD_FIRST_NAME	CHAR	60
CHILD4_BIRTH_DATE	Child Birth Date		HRPAYUS_EIWO_CHILD_BIRTH_DATE	DATS	16
CHILD5_LAST_NAME	Child Last Name		HRPAYUS_EIWO_CHILD_LAST_NAME	CHAR	60
CHILD5_FIRST_NAME	Child First Name		HRPAYUS_EIWO_CHILD_FIRST_NAME	CHAR	60
CHILD5_BIRTH_DATE	Child Birth Date		HRPAYUS_EIWO_CHILD_BIRTH_DATE	DATS	16
CHILD6_LAST_NAME	Child Last Name		HRPAYUS_EIWO_CHILD_LAST_NAME	CHAR	60
CHILD6_FIRST_NAME	Child First Name		HRPAYUS_EIWO_CHILD_FIRST_NAME	CHAR	60
CHILD6_BIRTH_DATE	Child Birth Date		HRPAYUS_EIWO_CHILD_BIRTH_DATE	DATS	16
PAYEE_NAME	Payee Name		HRPAYUS_EIWO_PAYEE_NAME	CHAR	114
PAYEE_REMITTANCE_FIPS_CODE	Additional garnishment reference code		PB10_FIPSC	CHAR	40
PAYEE_ADDRESS_LINE_1	Address Line		HRPAYUS_EIWO_ADDRESS_LINE	CHAR	50
PAYEE_ADDRESS_LINE_2	Address Line		HRPAYUS_EIWO_ADDRESS_LINE	CHAR	50
PAYEE_ADDRESS_CITY_NAME	City Name		HRPAYUS_EIWO_CITY_NAME	CHAR	44
PAYEE_ADDRESS_STATE_CODE	Payee State Code		HRPAYUS_EIWO_PAYEE_STATE_CODE	CHAR	6
PAYEE_ADDRESS_ZIP_CODE	Zip Code		HRPAYUS_EIWO_ZIP_CODE	CHAR	10
PAYEE_ADDRESS_ZIP_CODE_EXT	Zip Code Extention		HRPAYUS_EIWO_ZIP_CODE_EXT	CHAR	8
CURRENT_CHILD_SUPPORT_AMT	Pay Amount		HRPAYUS_EIWO_PAY_AMOUNT	CURR	8
CURRENT_CHILD_SUPPORT_FREQ	Pay Frequency		HRPAYUS_EIWO_PAY_FREQUENCY	CHAR	2
PAST_DUE_CHILD_SUPPORT_AMT	Pay Amount		HRPAYUS_EIWO_PAY_AMOUNT	CURR	8
PAST_DUE_CHILD_SUPPORT_FREQ	Pay Frequency		HRPAYUS_EIWO_PAY_FREQUENCY	CHAR	2
CURRENT_CASH_MEDICAL_SUP_AMT	Pay Amount		HRPAYUS_EIWO_PAY_AMOUNT	CURR	8
CURRENT_CASH_MEDICAL_SUP_FREQ	Pay Frequency		HRPAYUS_EIWO_PAY_FREQUENCY	CHAR	2
PAST_DUE_CASH_MEDICAL_SUP_AMT	Pay Amount		HRPAYUS_EIWO_PAY_AMOUNT	CURR	8
PAST_DUE_CASH_MEDICAL_SUP_FREQ	Pay Frequency		HRPAYUS_EIWO_PAY_FREQUENCY	CHAR	2
CURRENT_SPOUSAL_SUPPORT_AMT	Pay Amount		HRPAYUS_EIWO_PAY_AMOUNT	CURR	8
CURRENT_SPOUSAL_SUPPORT_FREQ	Pay Frequency		HRPAYUS_EIWO_PAY_FREQUENCY	CHAR	2
PAST_DUE_SPOUSAL_SUPPORT_AMT	Pay Amount		HRPAYUS_EIWO_PAY_AMOUNT	CURR	8
PAST_DUE_SPOUSAL_SUPPORT_FREQ	Pay Frequency		HRPAYUS_EIWO_PAY_FREQUENCY	CHAR	2
OTHER_SUPPORT_AMOUNT	Pay Amount		HRPAYUS_EIWO_PAY_AMOUNT	CURR	8
OTHER_SUPPORT_FREQUENCY	Pay Frequency		HRPAYUS_EIWO_PAY_FREQUENCY	CHAR	2
OTHER_SUPPORT_DESCRIPTION	Other Support Description		HRPAYUS_EIWO_OTHER_SUP_DESC	CHAR	70
TOTAL_ORDER_AMOUNT	Pay Amount		HRPAYUS_EIWO_PAY_AMOUNT	CURR	8
TOTAL_ORDER_FREQUENCY	Pay Frequency		HRPAYUS_EIWO_PAY_FREQUENCY	CHAR	2
ARREARS_12_WEEKS_OVERDUE	Arrears Indicator		HRPAYUS_EIWO_ARREARS_INDICATOR	CHAR	2
LUMP_SUM_PAYMENT_AMOUNT	Pay Amount		HRPAYUS_EIWO_PAY_AMOUNT	CURR	8
WEEKLY_WITHHOLDING_AMOUNT	Pay Amount		HRPAYUS_EIWO_PAY_AMOUNT	CURR	8
BIWEEKLY_WITHHOLDING_AMOUNT	Pay Amount		HRPAYUS_EIWO_PAY_AMOUNT	CURR	8
SEMIMONTHLY_WITHHOLDING_AMOUNT	Pay Amount		HRPAYUS_EIWO_PAY_AMOUNT	CURR	8
MONTHLY_WITHHOLDING_AMOUNT	Pay Amount		HRPAYUS_EIWO_PAY_AMOUNT	CURR	8
LOG_NUMBER	e-IWO Log Number		HRPAYUS_EIWO_LOG_NUMBER	CHAR	40
PROCESS_ORDER_TIMESTAMP	e-IWO - Process Order Timestamp		HRPAYUS_EIWO_PROCESS_TIMESTAMP	DEC	8
LUMP_SUM_PAYMENT_DATE	Lump Sum Payment Date		HRPAYUS_EIWO_LUMP_SUM_PAY_DATE	DATS	16
ORDER_PROCESS_DATE	IWO Process Date		HRPAYUS_EIWO_ORDER_PROC_DATE	DATS	16
RECEIVED_JURISDICTION	Garnishment document jurisdiction		PB10_GORIG	CHAR	6
ER_CONTACT_NAME	Employer State Contact Name		HRPAYUS_EIWO_ER_CONTACT_NAME	CHAR	114
ER_CONTACT_ADDRESS_LINE_1	Address Line		HRPAYUS_EIWO_ADDRESS_LINE	CHAR	50
ER_CONTACT_ADDRESS_LINE_2	Address Line		HRPAYUS_EIWO_ADDRESS_LINE	CHAR	50
ER_CONTACT_ADDRESS_CITY_NAME	City Name		HRPAYUS_EIWO_CITY_NAME	CHAR	44
ER_CONTACT_ADDRESS_STATE_CODE	State Code		HRPAYUS_EIWO_STATE_CODE	CHAR	6
ER_CONTACT_ADDRESS_ZIP_CODE	Zip Code		HRPAYUS_EIWO_ZIP_CODE	CHAR	10
ER_CONTACT_ADDRESS_ZIP_CODE_EX	Zip Code Extention		HRPAYUS_EIWO_ZIP_CODE_EXT	CHAR	8
ER_CONTACT_CONTACT_PHONE	Employer State Contact Phone Number		HRPAYUS_EIWO_CONTACT_PHONE	CHAR	20
ER_CONTACT_CONTACT_FAX	Employer State Contact Fax Number		HRPAYUS_EIWO_CONTACT_FAX	CHAR	20
ER_CONTACT_CONTACT_EMAIL	Employer State Contact Email Address		HRPAYUS_EIWO_CONTACT_EMAIL	CHAR	96