HRPAYUS_D_EIWO_O

e-IWO Orders | #transactional | Component: USA
Column Name Description
MANDT Client
CASE_IDENTIFIER IWO Case Identifier
ORDER_IDENTIFIER IWO Order Identifier
SEQUENTIAL_NUMBER Sequence Number for Order Detail Record
CONTROL_NUMBER_INBOUND Control Number for Order
Column Name Description
💲 Currency Key (T500C.WAERS):
DEDUCTION_AMOUNT Garnishment order deduction
CURRENT_CHILD_SUPPORT_AMT Pay Amount
PAST_DUE_CHILD_SUPPORT_AMT Pay Amount
CURRENT_CASH_MEDICAL_SUP_AMT Pay Amount
PAST_DUE_CASH_MEDICAL_SUP_AMT Pay Amount
CURRENT_SPOUSAL_SUPPORT_AMT Pay Amount
PAST_DUE_SPOUSAL_SUPPORT_AMT Pay Amount
OTHER_SUPPORT_AMOUNT Pay Amount
TOTAL_ORDER_AMOUNT Pay Amount
LUMP_SUM_PAYMENT_AMOUNT Pay Amount
WEEKLY_WITHHOLDING_AMOUNT Pay Amount
BIWEEKLY_WITHHOLDING_AMOUNT Pay Amount
SEMIMONTHLY_WITHHOLDING_AMOUNT Pay Amount
MONTHLY_WITHHOLDING_AMOUNT Pay Amount
Column Name Description
Column Name Description
ORDER_RECEIVED_DATE IWO Received Date
EMPLOYEE_BIRTH_DATE Employee Birth Date
CHILD1_BIRTH_DATE Child Birth Date
CHILD2_BIRTH_DATE Child Birth Date
CHILD3_BIRTH_DATE Child Birth Date
CHILD4_BIRTH_DATE Child Birth Date
CHILD5_BIRTH_DATE Child Birth Date
CHILD6_BIRTH_DATE Child Birth Date
LUMP_SUM_PAYMENT_DATE Lump Sum Payment Date
ORDER_PROCESS_DATE IWO Process Date
Column Name Description
DOCUMENT_ACTION_CODE Type of IWO document Show values
MANUAL_OVERRIDE Manual override Show values
EVALUATED_STATUS Order Status Evaluated by the System Show values
RECORD_REASON Acknowledgment Reason Code Show values
MULTI_IWO_STATE_CODE e-IWO Multi State Code Show values
DEDUCTION_UNIT Garnishment order deduction unit Show values
SEND_EMPLOYEE_COPY_INDICATOR Authorization to Send Copy Show values
CURRENT_CHILD_SUPPORT_FREQ Pay Frequency Show values
PAST_DUE_CHILD_SUPPORT_FREQ Pay Frequency Show values
CURRENT_CASH_MEDICAL_SUP_FREQ Pay Frequency Show values
PAST_DUE_CASH_MEDICAL_SUP_FREQ Pay Frequency Show values
CURRENT_SPOUSAL_SUPPORT_FREQ Pay Frequency Show values
PAST_DUE_SPOUSAL_SUPPORT_FREQ Pay Frequency Show values
OTHER_SUPPORT_FREQUENCY Pay Frequency Show values
TOTAL_ORDER_FREQUENCY Pay Frequency Show values
ARREARS_12_WEEKS_OVERDUE Arrears Indicator Show values
Column Name Description Domain name
CONTROL_NUMBER_OUTBOUND Control Number for Order
UUID_PDF 22 char UUID for EIWO HRPAYUS_EIWO_UUID22
UUID_XML_INBOUND 22 char UUID for EIWO HRPAYUS_EIWO_UUID22
UUID_XML_OUTBOUND 22 char UUID for EIWO HRPAYUS_EIWO_UUID22
PAYROLL_AREA Payroll Area ABKRS
PERNR Personnel Number PERNR
GROUPING_VALUE Grouping Value for Personnel Assignments PCCE_GPVAL
EMPLOYEE_SSN Social Security Number CHAR11
REMITTANCE_IDENTIFIER IWO Remittance Identifier
JURISDICTION Garnishment document jurisdiction REGIO
CATEGORY Garnishment document category PB10_GCATE
ORDER_TYPE Garnishment order type PB10_ORDCD
VENDOR_NUMBER Garnishment vendor LIFNR
REMITTANCE_RULE Remittance Rule RULNR
CCPA_LIMIT The highest percentage of income that can be withheld
GARNISHMENT_RULE Rule for calculating the non-exempt amount PB10_EXCEP
SERVICE_CHARGE Service charge rule PB10_SCRUL
EMPLOYER_ID_ORDER e-IWO Employer Identification Number EIDNO
EMPLOYER_ID_CORRECT Correct Employer Identification Number EIDNO
DOCUMENT_IMAGE_TEXT Document Image Text
DOCUMENT_TRACKING_NUMBER Order Tracking Number
EMPLOYEE_LAST_NAME Employee Last Name
EMPLOYEE_FIRST_NAME Employee First Name
OBLIGEE_LAST_NAME Obligee Last Name
OBLIGEE_FIRST_NAME Obligee First Name
CHILD1_LAST_NAME Child Last Name
CHILD1_FIRST_NAME Child First Name
CHILD2_LAST_NAME Child Last Name
CHILD2_FIRST_NAME Child First Name
CHILD3_LAST_NAME Child Last Name
CHILD3_FIRST_NAME Child First Name
CHILD4_LAST_NAME Child Last Name
CHILD4_FIRST_NAME Child First Name
CHILD5_LAST_NAME Child Last Name
CHILD5_FIRST_NAME Child First Name
CHILD6_LAST_NAME Child Last Name
CHILD6_FIRST_NAME Child First Name
PAYEE_NAME Payee Name
PAYEE_REMITTANCE_FIPS_CODE Additional garnishment reference code
PAYEE_ADDRESS_LINE_1 Address Line
PAYEE_ADDRESS_LINE_2 Address Line
PAYEE_ADDRESS_CITY_NAME City Name
PAYEE_ADDRESS_STATE_CODE Payee State Code REGIO
PAYEE_ADDRESS_ZIP_CODE Zip Code
PAYEE_ADDRESS_ZIP_CODE_EXT Zip Code Extention
OTHER_SUPPORT_DESCRIPTION Other Support Description
LOG_NUMBER e-IWO Log Number BALOGNR
PROCESS_ORDER_TIMESTAMP e-IWO - Process Order Timestamp TZNTSTMPS
RECEIVED_JURISDICTION Garnishment document jurisdiction REGIO
ER_CONTACT_NAME Employer State Contact Name
ER_CONTACT_ADDRESS_LINE_1 Address Line
ER_CONTACT_ADDRESS_LINE_2 Address Line
ER_CONTACT_ADDRESS_CITY_NAME City Name
ER_CONTACT_ADDRESS_STATE_CODE State Code REGIO
ER_CONTACT_ADDRESS_ZIP_CODE Zip Code
ER_CONTACT_ADDRESS_ZIP_CODE_EX Zip Code Extention
ER_CONTACT_CONTACT_PHONE Employer State Contact Phone Number
ER_CONTACT_CONTACT_FAX Employer State Contact Fax Number
ER_CONTACT_CONTACT_EMAIL Employer State Contact Email Address