Z_BLPWAWF_1A |
Default Table Name | Z_BLPWAWF_1A |
Definition |
Z_BLPWAWF_1A Columns |
ColumnName | Domain | Datatype | NULL | Definition |
PROJ_ID | VARCHAR2(30) | YES | ||
LINE_ITEM_TYPE_CD | VARCHAR2(1) | YES | ||
PRIME_CONTR_ID | VARCHAR2(20) | YES | ||
CUST_PO_ID | VARCHAR2(20) | YES | ||
S_CRNCY_CD | VARCHAR2(3) | YES | ||
BILL_NO_ID | VARCHAR2(15) | YES | ||
INVC_DT | DATE | YES | ||
INVC_ID | VARCHAR2(15) | YES | ||
BILL_DESC | VARCHAR2(254) | YES | ||
MU_INVC_AMT | NUMBER(14, 4) | YES | ||
ITEM_KEY | NUMBER(10, 0) | YES | ||
ITEM_DESC | VARCHAR2(60) | YES | ||
BILL_QTY | NUMBER(14, 4) | YES | ||
MU_AMT | NUMBER(14, 4) | YES | ||
ITEM_ID | VARCHAR2(50) | YES | ||
S_TRN_TYPE | VARCHAR2(6) | YES | ||
ACRN_CD | VARCHAR2(3) | YES | ||
ACRN_AMT | NUMBER(14, 2) | YES | ||
SDN_CD | VARCHAR2(3) | YES | ||
LINE_ITEM_CD | VARCHAR2(20) | YES | ||
ACCT_ID | VARCHAR2(15) | YES | ||
BILL_EDIT_KEY | NUMBER(10, 0) | YES | ||
WAWF_INVC_TYPE_CD | VARCHAR2(5) | YES | ||
WAWF_TASK_ORDER_ID | VARCHAR2(30) | YES | ||
WAWF_LAST_INVC_FL | VARCHAR2(1) | YES | ||
WAWF_SEND_CAGE_CD | VARCHAR2(13) | 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(13) | YES | ||
WAWF_LOCAL_PROC_ID | VARCHAR2(6) | YES | ||
WAWF_ISSUE_ID | VARCHAR2(6) | YES | ||
WAWF_ATTACHMENT | VARCHAR2(100) | YES | ||
WAWF_LAST_SHIP_FL | VARCHAR2(1) | YES | ||
WAWF_SHIP_FROM_ID | VARCHAR2(13) | YES | ||
WAWF_MARK_DELIV_ID | VARCHAR2(13) | YES | ||
WAWF_COMMENTS | VARCHAR2(75) | YES | ||
WAWF_2ND_COMMENTS | VARCHAR2(75) | YES | ||
WAWF_CERT_FL | VARCHAR2(1) | YES | ||
WAWF_SUPPLY_SVC_CD | VARCHAR2(3) | YES | ||
WAWF_INSPECT_PT_CD | VARCHAR2(1) | YES | ||
WAWF_ACCEPT_PT_CD | VARCHAR2(1) | YES | ||
WAWF_FOB_CD | VARCHAR2(1) | YES | ||
WAWF_APR_FL | VARCHAR2(1) | YES | ||
WAWF_FMS_FL | VARCHAR2(1) | YES | ||
WAWF_FIN_INFO_DT | DATE | YES | ||
PROJ_START_DT | DATE | YES | ||
PROJ_END_DT | DATE | YES | ||
WAWF_CLIN_MAP_CD | VARCHAR2(1) | YES | ||
WAWF_DFLT_CLIN | VARCHAR2(10) | YES | ||
WAWF_MOCAS_FL | VARCHAR2(1) | YES | ||
WAWF_INSPECT_OTHER | VARCHAR2(6) | YES | ||
WAWF_ACCEPT_OTHER | VARCHAR2(6) | YES | ||
WAWF_PREV_REQ_NO | VARCHAR2(8) | YES | ||
STOCK_NO | VARCHAR2(17) | YES | ||
PROD_SVC_TYPE_CD | VARCHAR2(3) | YES | ||
STEP | NUMBER(10, 0) | YES | ||
UM_CD | VARCHAR2(3) | YES | ||
MU_UNIT_PRICE_AMT | NUMBER(14, 4) | YES | ||
MU_BILL_AMT | NUMBER(14, 2) | YES | ||
WAWF_CAGE_EXT_CD | VARCHAR2(6) | YES | ||
WAWF_DISC_CLIN_FL | VARCHAR2(1) | YES | ||
WAWF_UNIT_MAP_CD | VARCHAR2(1) | YES | ||
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) | YES | ||
WAWF_FAST_PAY_FL | VARCHAR2(1) | YES | ||
WAWF_LN_HAUL_CD | VARCHAR2(1) | YES | ||
INSPECT_OTH_EXT_CD | VARCHAR2(6) | YES | ||
ACCEPT_OTH_EXT_CD | VARCHAR2(6) | YES | ||
ITEM_COUNT | NUMBER(10, 0) | YES | ||
ACRN_COUNT | NUMBER(10, 0) | YES | ||
MODIFIED_BY | VARCHAR2(20) | YES | ||
TIME_STAMP | DATE | YES | ||
ROWVERSION | NUMBER(10, 0) | YES |
Z_BLPWAWF_1A Primary and Unique Keys |
Key Name | Key Type | Keys |
Z_BLPWAWF_1A 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 |