Z_INPREORD_RQ |
Default Table Name | Z_INPREORD_RQ |
Definition |
Z_INPREORD_RQ Columns |
ColumnName | Domain | Datatype | NULL | Definition |
GRP_ID | VARCHAR2(40) | YES | ||
RQ_ID | VARCHAR2(10) | YES | ||
RQ_LN_KEY | NUMBER(10, 0) | YES | ||
S_RQ_STATUS_CD | VARCHAR2(1) | YES | ||
ITEM_KEY | NUMBER(10, 0) | YES | ||
ITEM_ID | VARCHAR2(50) | YES | ||
ITEM_RVSN_ID | VARCHAR2(10) | YES | ||
INVT_ABBRV_CD | VARCHAR2(20) | YES | ||
PROJ_ID_L | VARCHAR2(30) | YES | ||
PROJ_ID_H | VARCHAR2(30) | YES | ||
PROJ_ABBRV_CD_L | VARCHAR2(6) | YES | ||
PROJ_ABBRV_CD_H | VARCHAR2(6) | YES | ||
RQSTD_QTY | NUMBER(14, 4) | YES | ||
RQST_DT | DATE | YES | ||
TGT_PLACE_DT | DATE | YES | ||
APPROVAL_DT | DATE | YES | ||
PLANNER_ID | VARCHAR2(12) | YES | ||
WHSE_ID | VARCHAR2(8) | YES | ||
SHIP_ID | VARCHAR2(20) | YES | ||
BUYER_ID_L | VARCHAR2(12) | YES | ||
BUYER_ID_H | VARCHAR2(12) | YES | ||
BUYER_ASSIGN_DT_L | DATE | YES | ||
BUYER_ASSIGN_DT_H | DATE | YES | ||
RQ_LN_DESC | VARCHAR2(60) | YES | ||
CERT_OF_CNFRM_FL | VARCHAR2(1) | YES | ||
OVRSHP_ALLOW_FL | VARCHAR2(1) | YES | ||
QC_REQD_FL | VARCHAR2(1) | YES | ||
SRCE_INSP_FL | VARCHAR2(1) | YES | ||
RECPT_TOL_PCT_RT | NUMBER(10, 8) | YES | ||
STOP_EXPL_FL | VARCHAR2(1) | YES | ||
BOM_EXIST_FL | VARCHAR2(1) | YES | ||
BOM_CONFIG_ID | VARCHAR2(10) | YES | ||
EFF_DT | DATE | YES | ||
COMM_CD | VARCHAR2(8) | YES | ||
MIL_SPEC_ID | VARCHAR2(20) | YES | ||
NSN_ID | VARCHAR2(20) | YES | ||
PO_LN_UM_CD | VARCHAR2(3) | YES | ||
RQ_LN_UM_CD | VARCHAR2(3) | YES | ||
INVT_UM_CD | VARCHAR2(3) | YES | ||
RQ_APPR_PROC_CD_H | VARCHAR2(8) | YES | ||
RQ_APPR_PROC_CD_L | VARCHAR2(8) | YES | ||
RQST_EMPL_ID | VARCHAR2(12) | YES | ||
RQST_ORG_ID | VARCHAR2(20) | YES | ||
RQST_PHONE_ID | VARCHAR2(20) | YES | ||
RQST_PHONE_EXT_CD | VARCHAR2(6) | YES | ||
RQ_EST_CST_TYPE_CD | VARCHAR2(2) | YES | ||
SUG_BLKT_PO_ID | VARCHAR2(10) | YES | ||
SUG_BLKT_RLSE_NO | NUMBER(5, 0) | YES | ||
SUG_BLKT_LN_KEY | NUMBER(10, 0) | YES | ||
PREF_VEND_ID | VARCHAR2(12) | YES | ||
VEND_ADDR_DC | VARCHAR2(10) | YES | ||
VEND_PART_ID | VARCHAR2(30) | YES | ||
VEND_PART_RVSN_ID | VARCHAR2(3) | YES | ||
MANUF_ID | VARCHAR2(10) | YES | ||
MANUF_PART_ID | VARCHAR2(30) | YES | ||
MANUF_PART_RVSN_ID | VARCHAR2(3) | YES | ||
EST_NET_UNIT_AMT | NUMBER(14, 4) | YES | ||
EST_RQ_LN_EXT_AMT | NUMBER(14, 2) | YES | ||
EST_SALES_TAX_AMT | NUMBER(14, 2) | YES | ||
TAXABLE_FL | VARCHAR2(1) | YES | ||
RQ_LN_PO_FL | VARCHAR2(1) | YES | ||
RQ_PO_QTY | NUMBER(14, 4) | YES | ||
RQ_PO_DISC_PCT_RT | NUMBER(10, 8) | YES | ||
RQ_PO_GRS_UNIT_AMT | NUMBER(14, 4) | YES | ||
RQ_PO_NET_UNIT_AMT | NUMBER(14, 4) | YES | ||
RQ_PO_EXT_AMT | NUMBER(14, 2) | YES | ||
RQ_PO_SLS_TAX_AMT | NUMBER(14, 2) | YES | ||
USER_RVSN_FLD | VARCHAR2(10) | YES | ||
ORG_ID | VARCHAR2(20) | YES | ||
ORG_ABBRV_CD | VARCHAR2(6) | YES | ||
ACCT_ID | VARCHAR2(15) | YES | ||
INVT_RQ_QTY | NUMBER(14, 4) | YES | ||
S_ORD_REF_TYPE_CD | VARCHAR2(1) | YES | ||
ORDER_REF_ID | VARCHAR2(10) | YES | ||
ORDER_REF_RLSE_NO | NUMBER(5, 0) | YES | ||
ORDER_REF_LN_KEY | NUMBER(10, 0) | YES | ||
MISC_LN_CHG_TYPE | VARCHAR2(6) | YES | ||
LN_CHG_TYPE | VARCHAR2(6) | YES | ||
EST_RQ_LN_CHG_AMT | NUMBER(14, 2) | YES | ||
EST_LN_CHG_TAX_AMT | NUMBER(14, 2) | YES | ||
RQ_NOTES | VARCHAR2(254) | YES | ||
RQ_LN_NOTES | CLOB | YES | ||
RQST_INT_NOTES | VARCHAR2(254) | YES | ||
PROCURE_TYPE_CD | VARCHAR2(2) | YES | ||
DEL_TO_FLD | VARCHAR2(20) | YES | ||
S_PO_LN_TYPE | VARCHAR2(1) | YES | ||
AUTO_ASSIGN_FL | VARCHAR2(1) | YES | ||
SHIP_VIA_FLD | VARCHAR2(15) | YES | ||
OP_ID | VARCHAR2(12) | YES | ||
IND_CLASS_CD | VARCHAR2(8) | YES | ||
RATE_GRP_ID | VARCHAR2(6) | YES | ||
TRN_CRNCY_CD | VARCHAR2(3) | YES | ||
TRN_CRNCY_DT | DATE | YES | ||
TRN_TO_EUR_RT | NUMBER(14, 7) | YES | ||
TRN_TO_EUR_RT_FL | VARCHAR2(1) | YES | ||
TRN_FREEZE_RT_FL | VARCHAR2(1) | YES | ||
EUR_TO_FUNC_RT | NUMBER(14, 7) | YES | ||
TRN_NET_UNIT_AMT | NUMBER(14, 4) | YES | ||
TRN_RQ_LN_EXT_AMT | NUMBER(14, 2) | YES | ||
TRN_SALES_TAX_AMT | NUMBER(14, 2) | YES | ||
TRN_RQ_LN_CHG_AMT | NUMBER(14, 2) | YES | ||
TRN_LN_CHG_TAX_AMT | NUMBER(14, 2) | YES | ||
TRN_RP_GR_UNIT_AMT | NUMBER(14, 4) | YES | ||
TRN_RP_NT_UNIT_AMT | NUMBER(14, 4) | YES | ||
TRN_RQ_PO_EXT_AMT | NUMBER(14, 2) | YES | ||
TRN_RP_SLS_TAX_AMT | NUMBER(14, 2) | YES | ||
SO_LN_COMP_KEY | NUMBER(10, 0) | YES | ||
RQ_DT | DATE | YES | ||
STATION_ID | NUMBER(5, 0) | YES | ||
LOT_REQD_FL | VARCHAR2(1) | NO | ||
SERIAL_REQD_FL | VARCHAR2(1) | NO |
Z_INPREORD_RQ Primary and Unique Keys |
Key Name | Key Type | Keys |
Z_INPREORD_RQ 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 |