Z_AOPITEM_PART2 |
Default Table Name | Z_AOPITEM_PART2 |
Definition |
Z_AOPITEM_PART2 Columns |
ColumnName | Domain | Datatype | NULL | Definition |
ITEM_ID | VARCHAR2(50) | YES | ||
ITEM_RVSN_ID | VARCHAR2(10) | YES | ||
ITEM_DESC | VARCHAR2(60) | YES | ||
DFLT_UM_CD | VARCHAR2(3) | YES | ||
COMM_CD | VARCHAR2(8) | YES | ||
S_MAKE_BUY_CD | VARCHAR2(1) | YES | ||
S_STATUS_TYPE | VARCHAR2(1) | YES | ||
S_PART_TYPE | VARCHAR2(1) | YES | ||
AS_REQD_FL | VARCHAR2(1) | YES | ||
S_PLAN_TYPE | VARCHAR2(1) | YES | ||
BUYER_ID | VARCHAR2(12) | YES | ||
PLANNER_ID | VARCHAR2(12) | YES | ||
PROD_CLASSIF_CD | VARCHAR2(6) | YES | ||
HAZMAT_FL | VARCHAR2(1) | YES | ||
OVRSHP_ALLOW_FL | VARCHAR2(1) | YES | ||
RECPT_TOL_PCT_RT | NUMBER(10, 8) | YES | ||
CAGE_ID_FLD | VARCHAR2(6) | YES | ||
MIL_SPEC_ID | VARCHAR2(20) | YES | ||
NSN_ID | VARCHAR2(20) | YES | ||
QC_REQD_FL | VARCHAR2(1) | YES | ||
CERT_OF_CNFRM_FL | VARCHAR2(1) | YES | ||
SRCE_INSP_FL | VARCHAR2(1) | YES | ||
LOT_REQD_FL | VARCHAR2(1) | YES | ||
SERIAL_REQD_FL | VARCHAR2(1) | YES | ||
LAST_LOT_ID | VARCHAR2(20) | YES | ||
LAST_SERIAL_ID | VARCHAR2(20) | YES | ||
SHELF_LIFE_DAYS_NO | NUMBER(10, 0) | YES | ||
SO_CFG_LOT_REQD_FL | VARCHAR2(1) | YES | ||
SO_CFG_SER_REQD_FL | VARCHAR2(1) | YES | ||
WEIGHT_NO | NUMBER(14, 4) | YES | ||
S_ORD_POLICY_TYPE | VARCHAR2(1) | YES | ||
PD_ORD_DAYS_NO | NUMBER(10, 0) | YES | ||
MIN_LOT_SIZE_QTY | NUMBER(14, 4) | YES | ||
MULT_LOT_SIZE_QTY | NUMBER(14, 4) | YES | ||
MAX_LOT_SIZE_QTY | NUMBER(14, 4) | YES | ||
ORDER_UM_CD | VARCHAR2(3) | YES | ||
SALES_UM_CD | VARCHAR2(3) | YES | ||
INVT_FL | VARCHAR2(1) | YES | ||
DFLT_WHSE_ID | VARCHAR2(8) | YES | ||
DFLT_INVT_LOC_ID | VARCHAR2(15) | YES | ||
FLOOR_STOCK_FL | VARCHAR2(1) | YES | ||
COMMON_STK_FL | VARCHAR2(1) | YES | ||
BKFLSH_FL | VARCHAR2(1) | YES | ||
DFLT_LT_OFFSET_NO | NUMBER(10, 0) | YES | ||
SCRAP_FACT_PCT_RT | NUMBER(10, 8) | YES | ||
YIELD_PCT_RT | NUMBER(10, 8) | YES | ||
ABC_CLASSIF_CD | VARCHAR2(1) | YES | ||
COUNT_FREQ_NO | NUMBER(10, 0) | YES | ||
COUNT_TOT_PCT_RT | NUMBER(10, 8) | YES | ||
ITEM_NT | VARCHAR2(254) | YES | ||
ALWAYS_QT_FL | VARCHAR2(1) | YES | ||
ACTIVE_FL | VARCHAR2(1) | YES | ||
INSP_TYPE | VARCHAR2(1) | YES | ||
ITEM_ADDED_DT | DATE | YES | ||
LAST_ORD_DATE | DATE | YES | ||
LAST_ORD_ID | VARCHAR2(10) | YES | ||
STATUS_CHNG_DT | DATE | YES | ||
S_EFFECT_TYPE | VARCHAR2(1) | YES | ||
MODIFIED_BY | VARCHAR2(20) | YES | ||
CS_INVT_ABBRV_CD | VARCHAR2(20) | YES | ||
LST_CHNG_NOTICE_ID | VARCHAR2(15) | YES | ||
S_ITEM_TYPE | VARCHAR2(1) | YES | ||
NET_CHG_FL | VARCHAR2(1) | YES | ||
ROWVERSION | NUMBER(10, 0) | YES | ||
TIME_STAMP | DATE | YES | ||
TOT_LT_DAYS_NO | NUMBER(10, 0) | YES | ||
ITEM_KEY | NUMBER(10, 0) | YES | ||
ASY_CHNG_USER_ID | VARCHAR2(20) | YES | ||
ASY_ENTR_DTT | DATE | YES | ||
ASY_ENTR_USER_ID | VARCHAR2(20) | YES | ||
ASY_LAST_CHNG_DT | DATE | YES | ||
ASY_LLCD_UPDATE_FL | VARCHAR2(1) | YES | ||
LAST_RVSN_ID | VARCHAR2(10) | YES | ||
ASY_NOTES | VARCHAR2(254) | YES | ||
BOM_EXIST_FL | VARCHAR2(1) | YES | ||
S_ASY_REL_CD | VARCHAR2(1) | YES | ||
S_BOM_CHNG_CD | VARCHAR2(1) | YES | ||
LAST_ALT_SEQ_NO | NUMBER(10, 0) | YES | ||
LOW_LVL_CD_NO | NUMBER(10, 0) | 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 |
Z_AOPITEM_PART2 Primary and Unique Keys |
Key Name | Key Type | Keys |
Z_AOPITEM_PART2 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 |