PIP_INSTANCE_DEF Table
This table stores the same information as the PIP_DEF table, but is used for any customizations of the PIP. When you create a Rosettanet contract, the related PIP definition is stored in this table. Trading partners can customize their PIP definition based on their contract/agreement and the modified PIP definition is stored in this table. The original PIP_DEF table is not modified.
| Column Name | Data Type | Column Size | Whether the default value is Null |
|---|---|---|---|
| OBJECT_ID | VARCHAR | 255 | NOT NULL |
| PIP_CODE | VARCHAR | 32 | NOT NULL |
| TO_ROLE | VARCHAR | 255 | NOT NULL |
| FROM_ROLE | VARCHAR | 255 | NOT NULL |
| TO_SERVICE | VARCHAR | 255 | NOT NULL |
| FROM_SERVICE | VARCHAR | 255 | NOT NULL |
| PIP_VERSION | VARCHAR | 10 | NOT NULL |
| RNIF_VERSION | VARCHAR | 50 | NULL |
| PIP_DESCRIPTION | VARCHAR | 255 | NULL |
| EDITED_BY | VARCHAR | 32 | NULL |
| STATUS | INTEGER | 11 | NULL |
| TYPE | INTEGER | 11 | NULL |
| LAST_MOD_DATE | DATETIME | NULL | |
| RESPONSE_MODE | INTEGER | 11 | NULL |
| SENDER_WFD_NAME | VARCHAR | 255 | NULL |
| RESPONDER_WFD_NAME | VARCHAR | 255 | NULL |
| NON_REPUDIATION_REQ | INTEGER | 11 | NULL |
| TIME_TO_ACK | INTEGER | 11 | NULL |
| TIME_TO_ACK_ACCEPTANCE | INTEGER | 11 | NULL |
| TIME_TO_PERFORM | INTEGER | 11 | NULL |
| RETRY_COUNT | INTEGER | 11 | NULL |
| AUTH_REQ | INTEGER | 11 | NULL |
| NON_REPUDIATION_OF_ORIGIN | INTEGER | 11 | NULL |