Z_BLPWAWF_3 |
Default Table Name | Z_BLPWAWF_3 |
Definition |
Z_BLPWAWF_3 Columns |
ColumnName | Domain | Datatype | NULL | Definition |
PROJ_ID | VARCHAR2(30) | YES | ||
PRIME_CONTR_ID | VARCHAR2(20) | YES | ||
AWARD_YR_NO | NUMBER(5, 0) | YES | ||
AWARD_MO_NO | NUMBER(5, 0) | YES | ||
BILL_NO_ID | VARCHAR2(20) | YES | ||
INVC_ID | VARCHAR2(15) | YES | ||
INVC_END_DT | DATE | YES | ||
SMALL_BUS_FL | VARCHAR2(1) | YES | ||
CONTR_PRICE_AMT | NUMBER(14, 2) | YES | ||
PRG_PMT_RT | NUMBER(10, 8) | YES | ||
LIQUID_RT | NUMBER(10, 8) | YES | ||
LINE_19_AMT | NUMBER(14, 2) | YES | ||
LINE_9_AMT | NUMBER(14, 2) | YES | ||
LINE_10_AMT | NUMBER(14, 2) | YES | ||
LINE_11_AMT | NUMBER(14, 2) | YES | ||
LINE_12A_AMT | NUMBER(14, 2) | YES | ||
LINE_12B_AMT | NUMBER(14, 2) | YES | ||
LINE_13_AMT | NUMBER(14, 2) | YES | ||
LINE_14A_AMT | NUMBER(14, 2) | YES | ||
LINE_14B_AMT | NUMBER(14, 2) | YES | ||
LINE_14C_AMT | NUMBER(14, 2) | YES | ||
LINE_14D_AMT | NUMBER(14, 2) | YES | ||
LINE_14E_AMT | NUMBER(14, 2) | YES | ||
LINE_15_AMT | NUMBER(14, 2) | YES | ||
LINE_16_AMT | NUMBER(14, 2) | YES | ||
LINE_17_AMT | NUMBER(14, 2) | YES | ||
LINE_18_AMT | NUMBER(14, 2) | YES | ||
LINE_25_AMT | NUMBER(14, 2) | YES | ||
LINE_20A_AMT | NUMBER(14, 2) | YES | ||
LINE_20B_AMT | NUMBER(14, 2) | YES | ||
LINE_20C_AMT | NUMBER(14, 2) | YES | ||
LINE_20D_AMT | NUMBER(14, 2) | YES | ||
LINE_20E_AMT | NUMBER(14, 2) | YES | ||
LINE_21A_AMT | NUMBER(14, 2) | YES | ||
LINE_21B_AMT | NUMBER(14, 2) | YES | ||
LINE_21C_AMT | NUMBER(14, 2) | YES | ||
LINE_21D_AMT | NUMBER(14, 2) | YES | ||
LINE_21E_AMT | NUMBER(14, 2) | YES | ||
LINE_22_AMT | NUMBER(14, 2) | YES | ||
LINE_23_AMT | NUMBER(14, 2) | YES | ||
LINE_24_AMT | NUMBER(14, 2) | YES | ||
LINE_26_AMT | NUMBER(14, 2) | YES | ||
S_CRNCY_CD | VARCHAR2(3) | YES | ||
BILL_DESC | VARCHAR2(254) | YES | ||
CUST_PO_ID | VARCHAR2(20) | YES | ||
WAWF_INVC_TYPE_CD | VARCHAR2(5) | YES | ||
WAWF_DELIV_FL | VARCHAR2(1) | YES | ||
WAWF_FMS_FL | VARCHAR2(1) | YES | ||
WAWF_SEND_CAGE_CD | VARCHAR2(5) | YES | ||
WAWF_ADMIN_ID | VARCHAR2(6) | YES | ||
WAWF_INSPECT_ID | VARCHAR2(6) | YES | ||
WAWF_PMT_OFFICE_ID | VARCHAR2(6) | YES | ||
WAWF_SHIP_TO_ID | VARCHAR2(6) | YES | ||
WAWF_LOCAL_PROC_ID | VARCHAR2(6) | YES | ||
WAWF_ISSUE_ID | VARCHAR2(6) | YES | ||
WAWF_FIN_INFO_DT | DATE | YES | ||
WAWF_CERT_FL | VARCHAR2(1) | YES | ||
WAWF_ATTACHMENT | VARCHAR2(100) | YES | ||
WAWF_ACRN_FMS_CD | VARCHAR2(4) | YES | ||
WAWF_ACRN_CD | VARCHAR2(3) | YES | ||
WAWF_ACRN_AMT | NUMBER(14, 2) | YES | ||
WAWF_PREV_REQ_NO | VARCHAR2(8) | YES | ||
MODIFIED_BY | VARCHAR2(20) | YES | ||
TIME_STAMP | DATE | YES | ||
ROWVERSION | NUMBER(10, 0) | YES | ||
WAWF_CAGE_EXT_CD | VARCHAR2(6) | YES | ||
INSPECT_EXT_CD | VARCHAR2(6) | YES | ||
LOCAL_PROC_EXT_CD | VARCHAR2(6) | YES | ||
SHIP_TO_EXT_CD | VARCHAR2(6) | YES | ||
MARK_DELIV_EXT_CD | VARCHAR2(6) | YES | ||
WAWF_ATTACHMENT_FL | VARCHAR2(1) | YES |
Z_BLPWAWF_3 Primary and Unique Keys |
Key Name | Key Type | Keys |
Z_BLPWAWF_3 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 |