Z_AOPSOPP_H_SO_HDR |
Default Table Name | Z_AOPSOPP_H_SO_HDR |
Definition |
Z_AOPSOPP_H_SO_HDR Columns |
ColumnName | Domain | Datatype | NULL | Definition |
INPUT_LINE_NO | NUMBER(10, 0) | YES | ||
PROCESS_FLAG | VARCHAR2(1) | YES | ||
BILL_PMT_ADDR_CD | VARCHAR2(6) | YES | ||
BILL_TO_ADDR_DC | VARCHAR2(10) | YES | ||
CUST_ID | VARCHAR2(12) | YES | ||
DUE_DT | DATE | YES | ||
EXT_CUST_PO_ID | VARCHAR2(30) | YES | ||
ORD_DT | DATE | YES | ||
ACRN_ID | VARCHAR2(30) | YES | ||
BILL_CYCLE_CD | VARCHAR2(6) | YES | ||
BLKT_AMT | NUMBER(17, 2) | YES | ||
CHG_PROJ_ID | VARCHAR2(30) | YES | ||
CNTACT_FIRST_NAME | VARCHAR2(25) | YES | ||
CNTACT_LAST_NAME | VARCHAR2(25) | YES | ||
CONTR_ADDR_CD | VARCHAR2(6) | YES | ||
CUST_TERMS_KEY | NUMBER(10, 0) | YES | ||
DEL_TO_FLD | VARCHAR2(25) | YES | ||
DESIRED_DT | DATE | YES | ||
EXT_CUST_MOD_ID | VARCHAR2(10) | YES | ||
FAX_ID | VARCHAR2(25) | YES | ||
FOB_FLD | VARCHAR2(15) | YES | ||
INTL_SHIP_FL | VARCHAR2(1) | YES | ||
ISSUE_BY_ADDR_CD | VARCHAR2(6) | YES | ||
MARK_FOR_ADDR_DC | VARCHAR2(10) | YES | ||
OVRSHP_ALLOW_FL | VARCHAR2(1) | YES | ||
PARTIAL_SHIP_FL | VARCHAR2(1) | YES | ||
PERF_END_DT | DATE | YES | ||
PERF_START_DT | DATE | YES | ||
PHONE_ID | VARCHAR2(25) | YES | ||
PRICE_CATLG_CD | VARCHAR2(10) | YES | ||
PRICE_PROJ_ID | VARCHAR2(30) | YES | ||
PRIME_CONTR_ID | VARCHAR2(30) | YES | ||
QUOTE_ID | VARCHAR2(10) | YES | ||
RECUR_END_DT | DATE | YES | ||
RECUR_START_DT | DATE | YES | ||
REMIT_ADDR_CD | VARCHAR2(6) | YES | ||
SALES_ABBRV_CD | VARCHAR2(6) | YES | ||
SALES_REP_ID | VARCHAR2(12) | YES | ||
SHIP_BY_DT | DATE | YES | ||
SHIP_FROM_ADDR_CD | VARCHAR2(6) | YES | ||
SHIP_ID | VARCHAR2(20) | YES | ||
SO_CHNG_ORD_NO | NUMBER(5, 0) | YES | ||
SO_ID | VARCHAR2(10) | YES | ||
SO_NOTES_NT | VARCHAR2(254) | YES | ||
SO_RLSE_NO | NUMBER(5, 0) | YES | ||
TOT_RLSED_AMT | NUMBER(17, 2) | YES | ||
VOL_DISC_PCT_RT | NUMBER(5, 4) | YES | ||
DISC_AMT | NUMBER(17, 2) | YES | ||
ACKN_PRNTD_FL | VARCHAR2(1) | YES | ||
ACKN_PRNT_DT | DATE | YES | ||
ACKN_REQD_FL | VARCHAR2(1) | YES | ||
AR_ACCT_ID | VARCHAR2(15) | YES | ||
AR_ORG_ID | VARCHAR2(20) | YES | ||
AR_PROJ_ID | VARCHAR2(30) | YES | ||
AR_REF1_ID | VARCHAR2(20) | YES | ||
AR_REF2_ID | VARCHAR2(20) | YES | ||
DD250_INVC_FL | VARCHAR2(1) | YES | ||
DD250_PS_FL | VARCHAR2(1) | YES | ||
DFLT_TAXABLE_FL | VARCHAR2(1) | YES | ||
DMS_DPS_CD | VARCHAR2(6) | YES | ||
EXCD_BLKT_TOT_FL | VARCHAR2(1) | YES | ||
GROSS_UNIT_CST_FL | VARCHAR2(1) | YES | ||
GSA_FL | VARCHAR2(1) | YES | ||
INVC_FL | VARCHAR2(1) | YES | ||
INVT_ABBRV_CD | VARCHAR2(20) | YES | ||
LIQ_ACCT_ID | VARCHAR2(15) | YES | ||
LIQ_ORG_ID | VARCHAR2(20) | YES | ||
LIQ_PROJ_ID | VARCHAR2(30) | YES | ||
LIQ_REF1_ID | VARCHAR2(20) | YES | ||
LIQ_REF2_ID | VARCHAR2(20) | YES | ||
LOCK_FL | VARCHAR2(1) | YES | ||
OE_APPR_PROC_CD | VARCHAR2(8) | YES | ||
PARTIAL_ALLOW_NO | NUMBER(5, 0) | YES | ||
PICK_LIST_PRNT_FL | VARCHAR2(1) | YES | ||
PS_FL | VARCHAR2(1) | YES | ||
RETAIN_SO_FL | VARCHAR2(1) | YES | ||
RLSE_FROM_BLKT_FL | VARCHAR2(1) | YES | ||
RLSE_LN_TOT_FL | VARCHAR2(1) | YES | ||
ROWVERSION | NUMBER(10, 0) | YES | ||
RVSN_NO | NUMBER(5, 0) | YES | ||
SALES_TAX_AMT | NUMBER(17, 2) | YES | ||
SHIPMENT_NO_ID | VARCHAR2(8) | YES | ||
SHIP_VIA_FLD | VARCHAR2(15) | YES | ||
SO_TOT_AMT | NUMBER(17, 2) | YES | ||
SUBST_FL | VARCHAR2(1) | YES | ||
S_REV_RECOG_CD | VARCHAR2(1) | YES | ||
S_SO_STATUS_CD | VARCHAR2(1) | YES | ||
S_SO_TYPE | VARCHAR2(1) | YES | ||
INVC_FRGHT_CHG_FL | VARCHAR2(1) | YES | ||
EDI_GEN_DT | DATE | YES | ||
EDI_GEN_FL | VARCHAR2(1) | YES | ||
EUR_TO_FUNC_RT | NUMBER(28, 15) | YES | ||
RATE_GRP_ID | VARCHAR2(6) | YES | ||
TRN_DISC_AMT | NUMBER(17, 2) | YES | ||
TRN_CRNCY_CD | VARCHAR2(3) | YES | ||
TRN_CRNCY_DT | DATE | YES | ||
TRN_FREEZE_RT_FL | VARCHAR2(1) | YES | ||
TRN_SO_TOT_AMT | NUMBER(17, 2) | YES | ||
TRN_SALES_TAX_AMT | NUMBER(17, 2) | YES | ||
TRN_TO_EUR_RT | NUMBER(28, 15) | YES | ||
TRN_TO_EUR_RT_FL | VARCHAR2(1) | YES | ||
VAT_TAX_ID | VARCHAR2(20) | YES | ||
EC_COUNTRY_DEST_CD | VARCHAR2(3) | YES | ||
PERMIT_ID | VARCHAR2(15) | YES | ||
DECL_POINT_CD | VARCHAR2(5) | YES | ||
TRAFFIC_DIR_CD | VARCHAR2(1) | YES | ||
MODE_OF_TRANSP_NO | NUMBER(5, 0) | YES | ||
INTRASTAT_REF_NO | VARCHAR2(14) | YES | ||
COMPANY_ID | VARCHAR2(10) | YES | ||
COMM_PCT_RT | NUMBER(5, 4) | YES | ||
S_SO_STATUS_CD_OLD | VARCHAR2(1) | YES | ||
INSPECT_BY_ADDR_CD | VARCHAR2(6) | YES | ||
LOCAL_PROC_ADDR_CD | VARCHAR2(6) | YES | ||
OTHER_OFFC_ADDR_CD | VARCHAR2(6) | YES | ||
USE_WAWF_FL | VARCHAR2(1) | YES | ||
S_INSPECT_PT_CD | VARCHAR2(1) | YES | ||
S_ACCEPT_PT_CD | VARCHAR2(1) | YES | ||
S_WAWF_FOB_CD | VARCHAR2(1) | YES | ||
ARP_FL | VARCHAR2(1) | YES | ||
CONSTR_FL | VARCHAR2(1) | YES | ||
COC_FL | VARCHAR2(1) | YES | ||
CONTR_CAGE_ID | VARCHAR2(5) | YES |
Z_AOPSOPP_H_SO_HDR Primary and Unique Keys |
Key Name | Key Type | Keys |
Z_AOPSOPP_H_SO_HDR 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 |