HpConnect
| CompanyID | Company Identifier | SmallID | 12 | ||
| HpConnectID | BigID | 12 | |||
| Name | Varchar | 50 | |||
| CarrierID | Carrier Identifier | BigID | 12 | ||
| HpTransSetIDCode | Transaction Set Identifier Code | Long | 12 | ||
| DataElemSep | Data Element Separator | Varchar | 1 | ||
| SubElemSep | Subelement Separator | Varchar | 1 | ||
| SegmentTerm | Segment Terminator | Varchar | 1 | ||
| CharSetCase | Character Set Case: mixed or upper | Enum | 1 | Enum | |
| CharSetPunct | Character set punctuation choices. | Enum | 1 | Enum | |
| SpecPunct | Specific punctuation if CharSetPunt = "Allow Specific". Memo field | Varchar | 40 | ||
| UserID | Varchar | 50 | |||
| Password | Varchar | 50 | |||
| SenderIDType | Enum | 3 | Enum | ||
| SenderID | Varchar | 15 | |||
| SenderAppCode | Varchar | 80 | |||
| RecvIDType | Enum | 3 | Enum | ||
| RecvID | Varchar | 15 | |||
| RecvAppCode | Varchar | 80 | |||
| LastSuccTransTS | Timestamp of last successful transmission of this package | Timestamp | 32 | ||
| LastSuccTransmID | ID of transmission record for last successful transmission of this connection | BigID | 12 | ||
| SubscribeFlg | Varchar | 1 | |||
| AdvancedFlg | Varchar | 1 | |||
| LstModBy | Last Modified By Name | Varchar | 40 | ||
| LstModDate | Last Modified Date | Date | 32 | ||
| LockSeqNbr | *SYSTEM* Row Sequence Nbr | Long | 12 |