OE_PRNT_OPT |
Default Table Name | OE_PRNT_OPT |
Definition |
OE_PRNT_OPT Columns |
ColumnName | Domain | Datatype | NULL | Definition |
X_OF_Y_FL | VARCHAR2(1) | NO | ||
ORDER_REF_FL | VARCHAR2(1) | NO | ||
DEL_TO_FL | VARCHAR2(1) | NO | ||
PRIME_CONTR_FL | VARCHAR2(1) | NO | ||
SIGN_CLAUSE_FL | VARCHAR2(1) | NO | ||
REMIT_ADDR_FL | VARCHAR2(1) | NO | ||
MISC_TYPE_CD_FL | VARCHAR2(1) | NO | ||
CUST_ITEM_FL | VARCHAR2(1) | NO | ||
MODEL_NO_FL | VARCHAR2(1) | NO | ||
NSN_FL | VARCHAR2(1) | NO | ||
PS_PRNT_AMT_FL | VARCHAR2(1) | NO | ||
S_ACKN_NOTE_CD | VARCHAR2(1) | NO | ||
S_ACKN_TEXT_CD | VARCHAR2(1) | NO | ||
S_PS_NOTE_CD | VARCHAR2(1) | NO | ||
S_PS_TEXT_CD | VARCHAR2(1) | NO | ||
S_INVC_NOTE_CD | VARCHAR2(1) | NO | ||
S_INVC_TEXT_CD | VARCHAR2(1) | NO | ||
HLGHT_ACKN_DUP_FL | VARCHAR2(1) | NO | ||
HLGHT_ACKN_TEXT_FL | VARCHAR2(1) | NO | ||
HLGHT_ACKN_NOTE_FL | VARCHAR2(1) | NO | ||
HLGHT_PS_DUP_FL | VARCHAR2(1) | NO | ||
HLGHT_PS_TEXT_FL | VARCHAR2(1) | NO | ||
HLGHT_PS_NOTE_FL | VARCHAR2(1) | NO | ||
HLGHT_INVC_DUP_FL | VARCHAR2(1) | NO | ||
HLGHT_INVC_TEXT_FL | VARCHAR2(1) | NO | ||
HLGHT_INVC_NOTE_FL | VARCHAR2(1) | NO | ||
MODIFIED_BY | VARCHAR2(20) | NO | ||
COMPANY_ID![]() |
VARCHAR2(10) | NO | ||
TIME_STAMP | DATE | NO | ||
DD250_LINE_NO_FL | VARCHAR2(1) | NO | ||
LN_SALES_TAX_FL | VARCHAR2(1) | NO | ||
CUST_MOD_FL | VARCHAR2(1) | NO | ||
HLGHT_ACKN_TITL_FL | VARCHAR2(1) | NO | ||
HLGHT_PS_TITL_FL | VARCHAR2(1) | NO | ||
HLGHT_INVC_TITL_FL | VARCHAR2(1) | NO | ||
VOL_DISC_FL | VARCHAR2(1) | NO | ||
TERM_DISC_FL | VARCHAR2(1) | NO | ||
S_ACKN_FORMAT_CD | VARCHAR2(1) | NO | ||
S_PS_FORMAT_CD | VARCHAR2(1) | NO | ||
S_INVC_FORMAT_CD | VARCHAR2(1) | NO | ||
ACRN_FL | VARCHAR2(1) | NO | ||
MILSTRIP_FL | VARCHAR2(1) | NO | ||
SHIP_TO_LINE_FL | VARCHAR2(1) | NO | ||
SER_PS_PRNT_FL | VARCHAR2(1) | NO | ||
SER_DDPS_PRNT_FL | VARCHAR2(1) | NO | ||
SER_INVC_PRNT_FL | VARCHAR2(1) | NO | ||
SER_DDI_PRNT_FL | VARCHAR2(1) | NO | ||
CMP_PS_PRNT_FL | VARCHAR2(1) | NO | ||
CMP_INVC_PRNT_FL | VARCHAR2(1) | NO | ||
CMP_ACKN_PRNT_FL | VARCHAR2(1) | NO | ||
SO_LN_NO_FL | VARCHAR2(1) | NO | ||
LN_SALES_TAX_RT_FL | VARCHAR2(1) | NO | ||
TAX_ID_FL | VARCHAR2(1) | NO | ||
ROWVERSION | NUMBER(10, 0) | YES |
OE_PRNT_OPT Primary and Unique Keys |
Key Name | Key Type | Keys |
PI_1249 | PrimaryKey | COMPANY_ID |
OE_PRNT_OPT 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 |