Z_AOPITEM_PRT_UPD |
Default Table Name | Z_AOPITEM_PRT_UPD |
Definition |
Z_AOPITEM_PRT_UPD Columns |
ColumnName | Domain | Datatype | NULL | Definition |
INPUT_LINE_NO | NUMBER(10, 0) | YES | ||
ITEM_KEY | NUMBER(10, 0) | YES | ||
ITEM_ID | VARCHAR2(50) | YES | ||
ITEM_RVSN_ID | VARCHAR2(10) | YES | ||
CERT_OF_CNFRM_FL | VARCHAR2(1) | YES | ||
QC_REQD_FL | VARCHAR2(1) | YES | ||
SRCE_INSP_FL | VARCHAR2(1) | YES | ||
FLOOR_STOCK_FL | VARCHAR2(1) | YES | ||
BKFLSH_FL | VARCHAR2(1) | YES | ||
DFLT_WHSE_ID | VARCHAR2(8) | YES | ||
DFLT_INVT_LOC_ID | VARCHAR2(15) | YES | ||
SCRAP_FACT_PCT_RT | NUMBER(10, 8) | YES | ||
S_MAKE_BUY_CD | VARCHAR2(1) | YES | ||
S_PLAN_TYPE | VARCHAR2(1) | YES | ||
INVT_FL | VARCHAR2(1) | YES | ||
MIN_LOT_SIZE_QTY | NUMBER(14, 4) | YES | ||
MULT_LOT_SIZE_QTY | NUMBER(14, 4) | YES | ||
PD_ORD_DAYS_NO | NUMBER(5, 0) | YES | ||
S_ORD_POLICY_TYPE | VARCHAR2(1) | YES | ||
PLANNER_ID | VARCHAR2(12) | YES | ||
ABC_CLASSIF_CD | VARCHAR2(1) | YES | ||
COUNT_TOL_PCT_RT | NUMBER(10, 8) | YES | ||
COUNT_FREQ_NO | NUMBER(5, 0) | YES | ||
ALWAYS_QT_FL | VARCHAR2(1) | YES | ||
S_PART_TYPE | VARCHAR2(1) | YES | ||
MIL_SPEC_ID | VARCHAR2(20) | YES | ||
S_STATUS_TYPE | VARCHAR2(1) | YES | ||
NSN_ID | VARCHAR2(20) | YES | ||
LOT_REQD_FL | VARCHAR2(1) | YES | ||
SERIAL_REQD_FL | VARCHAR2(1) | YES | ||
SHELF_LIFE_DAYS_NO | NUMBER(5, 0) | YES | ||
LAST_SERIAL_ID | VARCHAR2(20) | YES | ||
AS_REQD_FL | VARCHAR2(1) | YES | ||
COMMON_STK_FL | VARCHAR2(1) | YES | ||
S_EFFECT_TYPE | VARCHAR2(1) | YES | ||
WEIGHT_NO | NUMBER(14, 4) | YES | ||
LAST_ALT_SEQ_NO | NUMBER(5, 0) | YES | ||
STATUS_CHNG_DT | DATE | YES | ||
CAGE_ID_FLD | VARCHAR2(6) | YES | ||
ASY_ENTR_DTT | DATE | YES | ||
ASY_ENTR_USER_ID | VARCHAR2(20) | YES | ||
ASY_LAST_CHNG_DTT | DATE | YES | ||
ASY_CHNG_USER_ID | VARCHAR2(20) | YES | ||
S_BOM_CHNG_CD | VARCHAR2(1) | YES | ||
S_ASY_REL_CD | VARCHAR2(1) | YES | ||
ASY_NOTES | VARCHAR2(254) | YES | ||
LOW_LVL_CD_NO | NUMBER(5, 0) | YES | ||
ASY_LLCD_UPDATE_FL | VARCHAR2(1) | YES | ||
BOM_EXIST_FL | VARCHAR2(1) | YES | ||
YIELD_PCT_RT | NUMBER(10, 8) | YES | ||
DFLT_LT_OFFSET_NO | NUMBER(5, 0) | YES | ||
NET_CHG_FL | VARCHAR2(1) | YES | ||
MODIFIED_BY | VARCHAR2(20) | YES | ||
LAST_LOT_ID | VARCHAR2(20) | YES | ||
MAX_LOT_SIZE_QTY | NUMBER(14, 4) | YES | ||
SO_CFG_LOT_REQD_FL | VARCHAR2(1) | YES | ||
SO_CFG_SER_REQD_FL | VARCHAR2(1) | YES | ||
CS_INVT_ABBRV_CD | VARCHAR2(20) | YES | ||
LST_CHNG_NOTICE_ID | VARCHAR2(15) | YES | ||
ECN_PENDING_FL | VARCHAR2(1) | YES | ||
IND_CLASS_CD | VARCHAR2(8) | YES | ||
UPC_CD | VARCHAR2(14) | YES | ||
MPS_FENCE_NO | NUMBER(5, 0) | YES | ||
SO_FENCE_NO | NUMBER(5, 0) | YES | ||
CUM_LT_DAYS_NO | NUMBER(5, 0) | YES | ||
S_VEND_RESTRICT_CD | VARCHAR2(1) | YES | ||
S_PLAN_ORDER_CD | VARCHAR2(2) | YES |
Z_AOPITEM_PRT_UPD Primary and Unique Keys |
Key Name | Key Type | Keys |
Z_AOPITEM_PRT_UPD 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 |