SO_HDR |
Default Table Name | SO_HDR |
Definition |
SO_HDR Columns |
ColumnName | Domain | Datatype | NULL | Definition |
SO_ID![]() |
VARCHAR2(10) | NO | ||
SO_RLSE_NO![]() |
NUMBER(5, 0) | NO | ||
SO_CHNG_ORD_NO | NUMBER(5, 0) | NO | ||
S_SO_TYPE | VARCHAR2(1) | NO | ||
CUST_ID![]() |
VARCHAR2(12) | NO | ||
EXT_CUST_PO_ID | VARCHAR2(30) | NO | ||
EXT_CUST_MOD_ID | VARCHAR2(10) | NO | ||
PRICE_CATLG_CD![]() |
VARCHAR2(10) | YES | ||
PRICE_PROJ_ID![]() |
VARCHAR2(30) | YES | ||
CHG_PROJ_ID![]() |
VARCHAR2(30) | YES | ||
AR_ACCT_ID![]() |
VARCHAR2(15) | NO | ||
AR_ORG_ID![]() |
VARCHAR2(20) | NO | ||
AR_PROJ_ID![]() |
VARCHAR2(30) | YES | ||
RLSE_FROM_BLKT_FL | VARCHAR2(1) | NO | ||
RLSE_LN_TOT_FL | VARCHAR2(1) | NO | ||
GROSS_UNIT_CST_FL | VARCHAR2(1) | NO | ||
EXCD_BLKT_TOT_FL | VARCHAR2(1) | NO | ||
BLKT_AMT | NUMBER(14, 2) | NO | ||
TOT_RLSED_AMT | NUMBER(14, 2) | NO | ||
SO_TOT_AMT | NUMBER(14, 2) | NO | ||
SALES_TAX_AMT | NUMBER(14, 2) | NO | ||
CNTACT_FIRST_NAME | VARCHAR2(25) | NO | ||
CNTACT_LAST_NAME | VARCHAR2(25) | NO | ||
FAX_ID | VARCHAR2(25) | NO | ||
PHONE_ID | VARCHAR2(25) | NO | ||
CUST_TERMS_KEY![]() |
NUMBER(10, 0) | NO | ||
FOB_FLD | VARCHAR2(15) | NO | ||
INTL_SHIP_FL | VARCHAR2(1) | NO | ||
S_SO_STATUS_CD![]() |
VARCHAR2(1) | NO | ||
ORD_DT | DATE | NO | ||
PERF_START_DT | DATE | YES | ||
PERF_END_DT | DATE | YES | ||
SALES_REP_ID![]() |
VARCHAR2(12) | YES | ||
INVC_FL | VARCHAR2(1) | NO | ||
PS_FL | VARCHAR2(1) | NO | ||
DD250_INVC_FL | VARCHAR2(1) | NO | ||
DD250_PS_FL | VARCHAR2(1) | NO | ||
RETAIN_SO_FL | VARCHAR2(1) | NO | ||
ACKN_REQD_FL | VARCHAR2(1) | NO | ||
ACKN_PRNTD_FL | VARCHAR2(1) | NO | ||
ACKN_PRNT_DT | DATE | YES | ||
PARTIAL_SHIP_FL | VARCHAR2(1) | NO | ||
PARTIAL_ALLOW_NO | NUMBER(5, 0) | NO | ||
BILL_TO_ADDR_DC![]() |
VARCHAR2(10) | YES | ||
SHIP_ID![]() |
VARCHAR2(20) | YES | ||
MARK_FOR_ADDR_DC![]() |
VARCHAR2(10) | YES | ||
REMIT_ADDR_CD![]() |
VARCHAR2(6) | YES | ||
BILL_PMT_ADDR_CD![]() |
VARCHAR2(6) | YES | ||
ISSUE_BY_ADDR_CD![]() |
VARCHAR2(6) | YES | ||
SHIP_FROM_ADDR_CD![]() |
VARCHAR2(6) | YES | ||
CONTR_ADDR_CD![]() |
VARCHAR2(6) | YES | ||
OVRSHP_ALLOW_FL | VARCHAR2(1) | NO | ||
SUBST_FL | VARCHAR2(1) | NO | ||
SALES_ABBRV_CD![]() |
VARCHAR2(6) | YES | ||
INVT_ABBRV_CD![]() |
VARCHAR2(20) | YES | ||
VOL_DISC_PCT_RT | NUMBER(5, 4) | NO | ||
QUOTE_ID | VARCHAR2(10) | NO | ||
RECUR_START_DT | DATE | YES | ||
RECUR_END_DT | DATE | YES | ||
DFLT_TAXABLE_FL | VARCHAR2(1) | NO | ||
DEL_TO_FLD | VARCHAR2(25) | NO | ||
SHIP_VIA_FLD | VARCHAR2(15) | NO | ||
DESIRED_DT | DATE | YES | ||
DUE_DT | DATE | YES | ||
SHIP_BY_DT | DATE | YES | ||
SHIPMENT_NO_ID | VARCHAR2(8) | NO | ||
SO_NOTES_NT | VARCHAR2(254) | NO | ||
MODIFIED_BY | VARCHAR2(20) | NO | ||
COMPANY_ID![]() |
VARCHAR2(10) | NO | ||
TIME_STAMP | DATE | NO | ||
LOCK_FL | VARCHAR2(1) | NO | ||
PRIME_CONTR_ID | VARCHAR2(20) | NO | ||
DMS_DPS_CD | VARCHAR2(6) | NO | ||
GSA_FL | VARCHAR2(1) | NO | ||
DISC_AMT | NUMBER(14, 2) | YES | ||
AR_REF1_ID![]() |
VARCHAR2(20) | YES | ||
AR_REF2_ID![]() |
VARCHAR2(20) | YES | ||
BILL_CYCLE_CD![]() |
VARCHAR2(6) | YES | ||
OE_APPR_PROC_CD![]() |
VARCHAR2(8) | YES | ||
RVSN_NO | NUMBER(5, 0) | NO | ||
S_REV_RECOG_CD | VARCHAR2(1) | NO | ||
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 | ||
PICK_LIST_PRNT_FL | VARCHAR2(1) | NO | ||
INVC_FRGHT_CHG_FL | VARCHAR2(1) | NO | ||
EDI_GEN_FL | VARCHAR2(1) | NO | ||
EDI_GEN_DT | DATE | YES | ||
ACRN_ID_S | VARCHAR2(30) | YES | ||
EUR_TO_FUNC_RT | NUMBER(14, 7) | NO | ||
RATE_GRP_ID | VARCHAR2(6) | YES | ||
TRN_BLKT_AMT | NUMBER(14, 2) | NO | ||
TRN_DISC_AMT | NUMBER(14, 2) | YES | ||
TRN_CRNCY_CD | VARCHAR2(3) | NO | ||
TRN_CRNCY_DT | DATE | YES | ||
TRN_FREEZE_RT_FL | VARCHAR2(1) | NO | ||
TRN_SO_TOT_AMT | NUMBER(14, 2) | NO | ||
TRN_SALES_TAX_AMT | NUMBER(14, 2) | NO | ||
TRN_TOT_RLSED_AMT | NUMBER(14, 2) | NO | ||
TRN_TO_EUR_RT | NUMBER(14, 7) | NO | ||
TRN_TO_EUR_RT_FL | VARCHAR2(1) | NO | ||
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 | ||
COMM_PCT_RT | NUMBER(5, 4) | YES | ||
ROWVERSION | NUMBER(10, 0) | 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) | NO | ||
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) | NO | ||
CONSTR_FL | VARCHAR2(1) | NO | ||
COC_FL | VARCHAR2(1) | NO | ||
CONTR_CAGE_ID | VARCHAR2(5) | YES |
SO_HDR Primary and Unique Keys |
Key Name | Key Type | Keys |
PI_1231 | PrimaryKey | SO_ID, SO_RLSE_NO |
SO_HDR Foreign Keys |
Parent Relationships: |
Table Name | Type | Cardinality | Constraint Name | VerbPhrase | InversePhrase | Foreign Keys | Is Supertype | Deferrable | Initially Deferred |
CUST | Non-Identifying | One To Zero or More | F10055 | CUST_ID, COMPANY_ID | NO | NO | NO | ||
PRICE_CATLG | Non-Identifying | Zero or One to Zero or More | F10056 | PRICE_CATLG_CD | NO | NO | NO | ||
PROJ | Non-Identifying | Zero or One to Zero or More | F10057 | PRICE_PROJ_ID | NO | NO | NO | ||
PROJ | Non-Identifying | Zero or One to Zero or More | F10058 | CHG_PROJ_ID | NO | NO | NO | ||
CUST_ADDR | Non-Identifying | Zero or One to Zero or More | F10059 | CUST_ID, BILL_TO_ADDR_DC, COMPANY_ID | NO | NO | NO | ||
SHIP_ID | Non-Identifying | Zero or One to Zero or More | F10060 | SHIP_ID | NO | NO | NO | ||
CUST_ADDR | Non-Identifying | Zero or One to Zero or More | F10061 | CUST_ID, MARK_FOR_ADDR_DC, COMPANY_ID | NO | NO | NO | ||
BILL_REMIT_ADDR | Non-Identifying | Zero or One to Zero or More | F10062 | REMIT_ADDR_CD | NO | NO | NO | ||
BILL_PAYMENT_ADDR | Non-Identifying | Zero or One to Zero or More | F10063 | BILL_PMT_ADDR_CD | NO | NO | NO | ||
CUST_TERMS | Non-Identifying | One To Zero or More | F10064 | CUST_TERMS_KEY | NO | NO | NO | ||
SALES_ABBRV_CD | Non-Identifying | Zero or One to Zero or More | F10065 | SALES_ABBRV_CD | NO | NO | NO | ||
INVT_ABBRV_CD | Non-Identifying | Zero or One to Zero or More | F10066 | INVT_ABBRV_CD | NO | NO | NO | ||
ISSUE_BY_ADDR | Non-Identifying | Zero or One to Zero or More | F10067 | ISSUE_BY_ADDR_CD | NO | NO | NO | ||
CONTR_ADDR | Non-Identifying | Zero or One to Zero or More | F10068 | CONTR_ADDR_CD | NO | NO | NO | ||
S_SO_STATUS_CD | Non-Identifying | One To Zero or More | F10069 | S_SO_STATUS_CD | NO | NO | NO | ||
ORG_ACCT | Non-Identifying | One To Zero or More | F10070 | AR_ACCT_ID, AR_ORG_ID | NO | NO | NO | ||
PROJ | Non-Identifying | Zero or One to Zero or More | F10071 | AR_PROJ_ID | NO | NO | NO | ||
CONTR_ADDR | Non-Identifying | Zero or One to Zero or More | F10072 | SHIP_FROM_ADDR_CD | NO | NO | NO | ||
SALES_REP | Non-Identifying | Zero or One to Zero or More | F10073 | SALES_REP_ID, COMPANY_ID | NO | NO | NO | ||
REF_STRUC | Non-Identifying | Zero or One to Zero or More | F20317 | COMPANY_ID, AR_REF1_ID | NO | NO | NO | ||
REF_STRUC | Non-Identifying | Zero or One to Zero or More | F20318 | COMPANY_ID, AR_REF2_ID | NO | NO | NO | ||
BILL_CYCLE | Non-Identifying | Zero or One to Zero or More | F20319 | BILL_CYCLE_CD | NO | NO | NO | ||
OE_APPRVL_PROC | Non-Identifying | Zero or One to Zero or More | F20336 | COMPANY_ID, OE_APPR_PROC_CD | NO | NO | NO | ||
ORG_ACCT | Non-Identifying | Zero or One to Zero or More | F20508 | LIQ_ACCT_ID, LIQ_ORG_ID | NO | NO | NO | ||
PROJ | Non-Identifying | Zero or One to Zero or More | F20509 | LIQ_PROJ_ID | NO | NO | NO | ||
REF_STRUC | Non-Identifying | Zero or One to Zero or More | F20510 | COMPANY_ID, LIQ_REF1_ID | NO | NO | NO | ||
REF_STRUC | Non-Identifying | Zero or One to Zero or More | F20511 | COMPANY_ID, LIQ_REF2_ID | NO | NO | NO |
Child Relationships: |
Table Name | Type | Cardinality | Constraint Name | VerbPhrase | InversePhrase | Foreign Keys | Is Subtype | Deferrable | Initially Deferred |
SO_LN | Identifying | One To Zero or More | F10074 | NO | NO | NO | |||
SO_TEXT | Identifying | One To Zero or More | F10085 | NO | NO | NO | |||
SO_ISSUE_HDR | Non-Identifying | One To Zero or More | F10094 | NO | NO | NO | |||
SHIP_TRN | Non-Identifying | One To Zero or More | F10103 | NO | NO | NO | |||
SO_INVC_HDR | Non-Identifying | One To Zero or More | F10147 | NO | NO | NO | |||
SO_HDR_APPRVL | Identifying | One To Zero or More | F20645 | NO | NO | NO |