PROJ_WAWF_INFO |
Default Table Name | PROJ_WAWF_INFO |
Definition |
PROJ_WAWF_INFO Columns |
ColumnName | Domain | Datatype | NULL | Definition |
PROJ_ID![]() |
VARCHAR2(30) | NO | ||
WAWF_SEND_CAGE_CD | VARCHAR2(13) | NO | ||
WAWF_INVC_TYPE_CD | VARCHAR2(5) | NO | ||
WAWF_SRCE_FILE_CD | VARCHAR2(1) | NO | ||
WAWF_ADMIN_ID | VARCHAR2(6) | YES | ||
WAWF_PMT_OFFICE_ID | VARCHAR2(6) | YES | ||
WAWF_SHIP_TO_ID | VARCHAR2(13) | YES | ||
WAWF_MARK_DELIV_ID | VARCHAR2(13) | YES | ||
WAWF_INSPECT_ID | VARCHAR2(6) | YES | ||
WAWF_LOCAL_PROC_ID | VARCHAR2(6) | YES | ||
WAWF_SHIP_FROM_ID | VARCHAR2(13) | YES | ||
WAWF_ISSUE_ID | VARCHAR2(6) | YES | ||
WAWF_TASK_ORDER_ID | VARCHAR2(30) | YES | ||
WAWF_LAST_INVC_FL | VARCHAR2(1) | NO | ||
WAWF_LAST_SHIP_FL | VARCHAR2(1) | NO | ||
WAWF_ATTACHMENT | VARCHAR2(100) | YES | ||
WAWF_COMMENTS | VARCHAR2(75) | YES | ||
WAWF_2ND_COMMENTS | VARCHAR2(75) | YES | ||
WAWF_CERT_FL | VARCHAR2(1) | NO | ||
WAWF_SUPPLY_SVC_CD | VARCHAR2(3) | NO | ||
WAWF_INSPECT_PT_CD | VARCHAR2(1) | NO | ||
WAWF_ACCEPT_PT_CD | VARCHAR2(1) | NO | ||
WAWF_FOB_CD | VARCHAR2(1) | NO | ||
WAWF_APR_FL | VARCHAR2(1) | NO | ||
WAWF_FMS_FL | VARCHAR2(1) | NO | ||
WAWF_DELIV_FL | VARCHAR2(1) | NO | ||
WAWF_FIN_INFO_DT | DATE | YES | ||
WAWF_CLIN_MAP_CD | VARCHAR2(1) | NO | ||
WAWF_DFLT_CLIN | VARCHAR2(10) | YES | ||
WAWF_MOCAS_FL | VARCHAR2(1) | NO | ||
WAWF_INSPECT_OTHER | VARCHAR2(6) | YES | ||
WAWF_ACCEPT_OTHER | VARCHAR2(6) | YES | ||
WAWF_PREV_REQ_NO | VARCHAR2(8) | YES | ||
MODIFIED_BY | VARCHAR2(20) | NO | ||
TIME_STAMP | DATE | NO | ||
ROWVERSION | NUMBER(10, 0) | NO | ||
WAWF_CAGE_EXT_CD | VARCHAR2(6) | YES | ||
WAWF_DISC_CLIN_FL | VARCHAR2(1) | NO | ||
WAWF_UNIT_MAP_CD | VARCHAR2(1) | NO | ||
INSPECT_EXT_CD | VARCHAR2(6) | YES | ||
LOCAL_PROC_EXT_CD | VARCHAR2(6) | YES | ||
SHIP_FROM_EXT_CD | VARCHAR2(6) | YES | ||
SHIP_TO_EXT_CD | VARCHAR2(6) | YES | ||
MARK_DELIV_EXT_CD | VARCHAR2(6) | YES | ||
WAWF_ATTACHMENT_FL | VARCHAR2(1) | NO | ||
WAWF_FAST_PAY_FL | VARCHAR2(1) | NO | ||
WAWF_LN_HAUL_CD | VARCHAR2(1) | YES | ||
INSPECT_OTH_EXT_CD | VARCHAR2(6) | YES | ||
ACCEPT_OTH_EXT_CD | VARCHAR2(6) | YES |
PROJ_WAWF_INFO Primary and Unique Keys |
Key Name | Key Type | Keys |
PI_7075 | PrimaryKey | PROJ_ID |
PROJ_WAWF_INFO Foreign Keys |
Parent Relationships: |
Table Name | Type | Cardinality | Constraint Name | VerbPhrase | InversePhrase | Foreign Keys | Is Supertype | Deferrable | Initially Deferred |
Child Relationships: |
Table Name | Type | Cardinality | Constraint Name | VerbPhrase | InversePhrase | Foreign Keys | Is Subtype | Deferrable | Initially Deferred |
PROJ_WAWF_CLIN | Identifying | One To Zero or More | F21759 | NO | NO | NO |