CST_PUBINTERXENTITY (ver 15.5.1)
This table is a standalone table. It is a join table for entity types and interchanges. Note: Each entry must have a unique CST_PUBINTERXID, CST_PUBENTITYTYPEID, and PUBLISHORDER. This table is available for all states/provinces and may or may not be utilized for your state/province.
Column Name | Version | Data Type | Description |
|---|---|---|---|
ID | 15.5.1 | NUMBER(19,0) | The internal ID for the CST_PUBINTERXENTITY record to which the record is associated. Required. (Default – Next value in CST_PUBINTERXENTITY_SQ sequence) |
CST_PUBINTERXID | 15.5.1 | NUMBER(19,0) | The internal ID for the CST_PUBINTERX record to which the record is associated. Required. |
CST_PUBENTITYTYPEID | 15.5.1 | NUMBER(19,0) | The internal ID for the CST_PUBENTITYTYPE record to which the record is associated. Required. |
PUBLISHORDER | 15.5.1 | NUMBER(3,0) | The publish order of the interchange. Required. |
PUBLISHDIRECTION | 15.5.1 | CHAR(1) | The publish direction of the interchange. Required. (i.e. ‘U’-Upload, ‘D’-Download, ‘B’-Both) |
ACTIVE | 15.5.1 | NUMBER(1,0) | A flag used to specify if the interchange is enabled/active or disabled/inactive. (i.e. 0-Inactive, 1-Active) (Default - 0) |