PO_SETTINGS |
Default Table Name | PO_SETTINGS |
Definition |
PO_SETTINGS Columns |
ColumnName | Domain | Datatype | NULL | Definition |
CALC_TAX_FL | VARCHAR2(1) | NO | ||
INCL_BLKT_CMMIT_FL | VARCHAR2(1) | NO | ||
S_PO_STATUS_TYPE | VARCHAR2(1) | NO | ||
S_PO_AUTO_NUM_TYPE | VARCHAR2(1) | NO | ||
LAST_PO_ID | VARCHAR2(10) | NO | ||
DFLT_CNFRM_FL | VARCHAR2(1) | NO | ||
DFLT_SHIP_ID![]() |
VARCHAR2(20) | 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 | ||
S_PO_TAXABLE_TYPE | VARCHAR2(1) | NO | ||
MODIFIED_BY | VARCHAR2(20) | NO | ||
TIME_STAMP | DATE | NO | ||
COMPANY_ID![]() |
VARCHAR2(10) | NO | ||
ALLOW_OPEN_FL | VARCHAR2(1) | NO | ||
S_REQD_REQ_ID_CD | VARCHAR2(1) | NO | ||
S_BUYER_PAO_CD | VARCHAR2(1) | NO | ||
BUYER_LIMIT_FL | VARCHAR2(1) | NO | ||
DFLT_SAVE_CHNG_FL | VARCHAR2(1) | NO | ||
ALLOW_CHNG_FL | VARCHAR2(1) | NO | ||
ROWVERSION | NUMBER(10, 0) | YES | ||
DFLT_CMMIT_TYP_D | VARCHAR2(1) | YES | ||
ALLOW_PEND_FL | VARCHAR2(1) | NO | ||
PORTAL_EMAIL_FL | VARCHAR2(1) | YES | ||
PORT_EMAIL_EDIT_FL | VARCHAR2(1) | YES | ||
ALLOW_QLTY_CHNG_FL | VARCHAR2(1) | YES | ||
ALL_VCHDSC_CHNG_FL | VARCHAR2(1) | YES | ||
S_LT_CAL_CD | VARCHAR2(1) | NO | ||
EDIT_OR_DUE_DT_FL | VARCHAR2(1) | YES |
PO_SETTINGS Primary and Unique Keys |
Key Name | Key Type | Keys |
PI_0174 | PrimaryKey | COMPANY_ID |
PO_SETTINGS Foreign Keys |
Parent Relationships: |
Table Name | Type | Cardinality | Constraint Name | VerbPhrase | InversePhrase | Foreign Keys | Is Supertype | Deferrable | Initially Deferred |
SHIP_ID | Non-Identifying | Zero or One to Zero or More | F06447 | DFLT_SHIP_ID | NO | NO | NO |
Child Relationships: |
Table Name | Type | Cardinality | Constraint Name | VerbPhrase | InversePhrase | Foreign Keys | Is Subtype | Deferrable | Initially Deferred |