OIUE2_ESCH_HOLD - Proc 2.0 - Escheat - ASCII - Holder Record
Proc 2.0 - Escheat - ASCII - Holder Record information is stored in SAP table OIUE2_ESCH_HOLD.
It is part of development package OIU_E2 in software component IS-OIL-PRA-REV. This development package consists of objects that can be grouped under "Proc 2.0 - Escheat / Wyoming Escrow".
It is part of development package OIU_E2 in software component IS-OIL-PRA-REV. This development package consists of objects that can be grouped under "Proc 2.0 - Escheat / Wyoming Escrow".
Fields for table OIUE2_ESCH_HOLD
Field Name | Description | Is Key | Data Element | Data Type | Length | Check Table |
|---|---|---|---|---|---|---|
| MANDT | Client | X | MANDT | CLNT | 6 | T000 |
| BUKRS | Company Code | X | BUKRS | CHAR | 8 | |
| TAX_ID | Proc 2.0 - Escheat - ASCII - Tax ID | OIUE2_ESCHEAT_TAX_ID | NUMC | 18 | ||
| TAX_ID_EXT | Proc 2.0 - Escheat - ASCII - Tax ID Extension | OIUE2_ESCHEAT_TAX_ID_EXTENSION | NUMC | 8 | ||
| SIC_CODE | Proc 2.0 - Escheat - ASCII - SIC Code | OIUE2_ESCHEAT_SIC_CODE | CHAR | 8 | ||
| INCORPORATION_ST | Proc 2.0 - Escheat - ASCII - Incorporation State | OIUE2_ESCHEAT_INCORPORATION_ST | CHAR | 4 | ||
| INCORPORATION_DT | Proc 2.0 - Escheat - ASCII - Incorporation Date | OIUE2_ESCHEAT_INCORPORATION_DT | DATS | 16 | ||
| COMPANY_NAME | Proc 2.0 - Escheat - ASCII - Company Name | OIUE2_ESCHEAT_COMPANY_NAME | CHAR | 80 | ||
| COMPANY_CITY | Proc 2.0 - Escheat - ASCII - Company City | OIUE2_ESCHEAT_COMPANY_CITY | CHAR | 60 | ||
| COMPANY_COUNTY | Proc 2.0 - Escheat - ASCII - Company County | OIUE2_ESCHEAT_COMPANY_COUNTY | CHAR | 40 | ||
| COMPANY_STATE | Proc 2.0 - Escheat - ASCII - Company State | OIUE2_ESCHEAT_COMPANY_STATE | CHAR | 4 | ||
| CONTACT1_NAME | Proc 2.0 - Escheat - ASCII - Contact Name | OIUE2_ESCHEAT_CONTACT_NAME | CHAR | 80 | ||
| CONTACT1_ADDR1 | Proc 2.0 - Escheat - ASCII - Contact Address Line 1 | OIUE2_ESCHEAT_CONTACT_ADDR1 | CHAR | 60 | ||
| CONTACT1_ADDR2 | Proc 2.0 - Escheat - ASCII - Contact Address Line 2 | OIUE2_ESCHEAT_CONTACT_ADDR2 | CHAR | 60 | ||
| CONTACT1_ADDR3 | Proc 2.0 - Escheat - ASCII - Contact Address Line 3 | OIUE2_ESCHEAT_CONTACT_ADDR3 | CHAR | 60 | ||
| CONTACT1_CITY | Proc 2.0 - Escheat - ASCII - Contact City | OIUE2_ESCHEAT_CONTACT_CITY | CHAR | 60 | ||
| CONTACT1_STATE | Proc 2.0 - Escheat - ASCII - Contact State | OIUE2_ESCHEAT_CONTACT_STATE | CHAR | 4 | ||
| CONTACT1_ZIP | Proc 2.0 - Escheat - ASCII - Contact Zip | OIUE2_ESCHEAT_CONTACT_ZIP | NUMC | 10 | ||
| CONTACT1_PLUS_4 | Proc 2.0 - Escheat - ASCII - Contact Zip+4 | OIUE2_ESCHEAT_CONTACT_ZIP_P4 | NUMC | 8 | ||
| CONTACT1_COUNTRY | Proc 2.0 - Escheat - ASCII - Contact Country/Region | OIUE2_ESCHEAT_CONTACT_COUNTRY | CHAR | 6 | ||
| CONTACT1_AREA_CD | Proc 2.0 - Escheat - ASCII - Contact Area Code | OIUE2_ESCHEAT_CONTACT_AREA_CD | NUMC | 6 | ||
| CONTACT1_PHONE | Proc 2.0 - Escheat - ASCII - Contact Telephone Number | OIUE2_ESCHEAT_CONTACT_PHONE | NUMC | 14 | ||
| CONTACT1_EXT | Proc 2.0 - Escheat - ASCII - Contact Telephone Extension | OIUE2_ESCHEAT_CONTACT_PHONE_EX | CHAR | 8 | ||
| CONTACT1_EMAIL | Proc 2.0 - Escheat - ASCII - Contact Email | OIUE2_ESCHEAT_CONTACT_EMAIL | CHAR | 100 | ||
| CONTACT2_NAME | Proc 2.0 - Escheat - ASCII - Contact Name | OIUE2_ESCHEAT_CONTACT_NAME | CHAR | 80 | ||
| CONTACT2_ADDR1 | Proc 2.0 - Escheat - ASCII - Contact Address Line 1 | OIUE2_ESCHEAT_CONTACT_ADDR1 | CHAR | 60 | ||
| CONTACT2_ADDR2 | Proc 2.0 - Escheat - ASCII - Contact Address Line 2 | OIUE2_ESCHEAT_CONTACT_ADDR2 | CHAR | 60 | ||
| CONTACT2_ADDR3 | Proc 2.0 - Escheat - ASCII - Contact Address Line 3 | OIUE2_ESCHEAT_CONTACT_ADDR3 | CHAR | 60 | ||
| CONTACT2_CITY | Proc 2.0 - Escheat - ASCII - Contact City | OIUE2_ESCHEAT_CONTACT_CITY | CHAR | 60 | ||
| CONTACT2_STATE | Proc 2.0 - Escheat - ASCII - Contact State | OIUE2_ESCHEAT_CONTACT_STATE | CHAR | 4 | ||
| CONTACT2_ZIP | Proc 2.0 - Escheat - ASCII - Contact Zip | OIUE2_ESCHEAT_CONTACT_ZIP | NUMC | 10 | ||
| CONTACT2_PLUS_4 | Proc 2.0 - Escheat - ASCII - Contact Zip+4 | OIUE2_ESCHEAT_CONTACT_ZIP_P4 | NUMC | 8 | ||
| CONTACT2_COUNTRY | Proc 2.0 - Escheat - ASCII - Contact Country/Region | OIUE2_ESCHEAT_CONTACT_COUNTRY | CHAR | 6 | ||
| CONTACT2_AREA_CD | Proc 2.0 - Escheat - ASCII - Contact Area Code | OIUE2_ESCHEAT_CONTACT_AREA_CD | NUMC | 6 | ||
| CONTACT2_PHONE | Proc 2.0 - Escheat - ASCII - Contact Telephone Number | OIUE2_ESCHEAT_CONTACT_PHONE | NUMC | 14 | ||
| CONTACT2_EXT | Proc 2.0 - Escheat - ASCII - Contact Telephone Extension | OIUE2_ESCHEAT_CONTACT_PHONE_EX | CHAR | 8 | ||
| CONTACT2_EMAIL | Proc 2.0 - Escheat - ASCII - Contact Email | OIUE2_ESCHEAT_CONTACT_EMAIL | CHAR | 100 | ||
| FAX_AREA_CODE | Proc 2.0 - Escheat - ASCII - Fax Area Code | OIUE2_ESCHEAT_FAX_AREA_CODE | NUMC | 6 | ||
| FAX_NUMBER | Proc 2.0 - Escheat - ASCII - Fax Number | OIUE2_ESCHEAT_FAX_NUMBER | NUMC | 14 | ||
| NAICS_CODE | Proc 2.0 - Escheat - ASCII - NAICS Code | OIUE2_ESCHEAT_NAICS_CODE | CHAR | 12 | ||
| .INCLUDE | ROIUX3_LAST_CHANGED | ROIUX3_LAST_CHANGED | 0 | |||
| CHANGE_USER | Last Changed By | OIUX3_LAST_CHANGED_USER | CHAR | 24 | ||
| CHANGE_DATE | Date of Last Change | OIUX3_LAST_CHANGED_DATE | DATS | 16 | ||
| CHANGE_TIME | Time of Last Change | OIUX3_LAST_CHANGED_TIME | TIMS | 12 |