Diccionario de Datos
Diccionario de datos de los modelos de COÉXITO
| 🏠 Menú principal | ← Volver a tablas |
STADW.ST_MARGINDETAILSEXTRACT_OM_HIST
Base de datos origen: ADW COEXITO
Columnas
| # | Columna | Tipo | Nulo | Default | Comentario |
|---|---|---|---|---|---|
| 1 | CSTGROSSMARGINDETAILSPEOGROSSMARGINDETAILID | NUMBER(18,0) | NO | ||
| 2 | CSTGROSSMARGINDETAILSPEORECOGNIZEDCOGSAMOUNT | NUMBER | SI | ||
| 3 | CSTGROSSMARGINDETAILSPEOGLDATE | DATE | SI | ||
| 4 | CSTGROSSMARGINDETAILSPEOCURRENCYCODE | VARCHAR2(30) | SI | ||
| 5 | CSTGROSSMARGINDETAILSPEOCOGSACCOUNTID | NUMBER(18,0) | SI | ||
| 6 | CSTGROSSMARGINDETAILSPEOCOSTBOOKID | NUMBER(18,0) | SI | ||
| 7 | CSTGROSSMARGINDETAILSPEOCOSTORGID | NUMBER(18,0) | SI | ||
| 8 | CSTGROSSMARGINDETAILSPEOPROFITCENTERBUID | NUMBER(18,0) | SI | ||
| 9 | CSTGROSSMARGINDETAILSPEOINVENTORYITEMID | NUMBER(18,0) | SI | ||
| 10 | CSTGROSSMARGINDETAILSPEOINVENTORYORGID | NUMBER(18,0) | SI | ||
| 11 | CSTGROSSMARGINDETAILSPEOITEMORGANIZATIONID | NUMBER(18,0) | SI | ||
| 12 | CSTGROSSMARGINDETAILSPEOCUSTOMERID | NUMBER(18,0) | SI | ||
| 13 | CSTGROSSMARGINDETAILSPEODOCLINEID | NUMBER(18,0) | SI | ||
| 14 | CSTGROSSMARGINDETAILSPEODOOORDERNUMBER | VARCHAR2(240) | SI | ||
| 15 | CSTGROSSMARGINDETAILSPEODOOORDERTYPE | VARCHAR2(50) | SI | ||
| 16 | CSTGROSSMARGINDETAILSPEOORDERTYPECODE | VARCHAR2(30) | SI | ||
| 17 | CSTGROSSMARGINDETAILSPEOINVOICEID | NUMBER(18,0) | SI | ||
| 18 | CSTGROSSMARGINDETAILSPEOINVOICELINEID | NUMBER(18,0) | SI | ||
| 19 | CSTGROSSMARGINDETAILSPEOINVOICENUMBER | VARCHAR2(20) | SI | ||
| 20 | CSTGROSSMARGINDETAILSPEOINVOICESOURCE | VARCHAR2(30) | SI | ||
| 21 | CSTGROSSMARGINDETAILSPEOSHIPMENTNUMBER | VARCHAR2(240) | SI | ||
| 22 | CSTGROSSMARGINDETAILSPEOSHIPMENTTYPE | VARCHAR2(50) | SI | ||
| 23 | CSTGROSSMARGINDETAILSPEORECOGNIZEDGROSSMARGIN | NUMBER | SI | ||
| 24 | CSTGROSSMARGINDETAILSPEORECOGNIZEDREV | NUMBER | SI | ||
| 25 | CSTGROSSMARGINDETAILSPEOCREATIONDATE | TIMESTAMP(6) | SI | ||
| 26 | CSTGROSSMARGINDETAILSPEOCREATEDBY | VARCHAR2(64) | SI | ||
| 27 | CSTGROSSMARGINDETAILSPEOLASTUPDATEDATE | TIMESTAMP(6) | NO | ||
| 28 | CSTGROSSMARGINDETAILSPEOLASTUPDATEDBY | VARCHAR2(64) | SI | ||
| 29 | IDMAESTROCARGUE | NUMBER(18,0) | NO |
Restricciones
CHECK: SYS_C00290263
- Estado: ENABLED
- Columnas: CSTGROSSMARGINDETAILSPEOGROSSMARGINDETAILID
- Condición:
"CSTGROSSMARGINDETAILSPEOGROSSMARGINDETAILID" IS NOT NULL
CHECK: SYS_C00290264
- Estado: ENABLED
- Columnas: CSTGROSSMARGINDETAILSPEOLASTUPDATEDATE
- Condición:
"CSTGROSSMARGINDETAILSPEOLASTUPDATEDATE" IS NOT NULL
CHECK: SYS_C00290265
- Estado: ENABLED
- Columnas: IDMAESTROCARGUE
- Condición:
"IDMAESTROCARGUE" IS NOT NULL
DDL
CREATE TABLE "STADW"."ST_MARGINDETAILSEXTRACT_OM_HIST"
( "CSTGROSSMARGINDETAILSPEOGROSSMARGINDETAILID" NUMBER(18,0) NOT NULL ENABLE,
"CSTGROSSMARGINDETAILSPEORECOGNIZEDCOGSAMOUNT" NUMBER,
"CSTGROSSMARGINDETAILSPEOGLDATE" DATE,
"CSTGROSSMARGINDETAILSPEOCURRENCYCODE" VARCHAR2(30) COLLATE "USING_NLS_COMP",
"CSTGROSSMARGINDETAILSPEOCOGSACCOUNTID" NUMBER(18,0),
"CSTGROSSMARGINDETAILSPEOCOSTBOOKID" NUMBER(18,0),
"CSTGROSSMARGINDETAILSPEOCOSTORGID" NUMBER(18,0),
"CSTGROSSMARGINDETAILSPEOPROFITCENTERBUID" NUMBER(18,0),
"CSTGROSSMARGINDETAILSPEOINVENTORYITEMID" NUMBER(18,0),
"CSTGROSSMARGINDETAILSPEOINVENTORYORGID" NUMBER(18,0),
"CSTGROSSMARGINDETAILSPEOITEMORGANIZATIONID" NUMBER(18,0),
"CSTGROSSMARGINDETAILSPEOCUSTOMERID" NUMBER(18,0),
"CSTGROSSMARGINDETAILSPEODOCLINEID" NUMBER(18,0),
"CSTGROSSMARGINDETAILSPEODOOORDERNUMBER" VARCHAR2(240) COLLATE "USING_NLS_COMP",
"CSTGROSSMARGINDETAILSPEODOOORDERTYPE" VARCHAR2(50) COLLATE "USING_NLS_COMP",
"CSTGROSSMARGINDETAILSPEOORDERTYPECODE" VARCHAR2(30) COLLATE "USING_NLS_COMP",
"CSTGROSSMARGINDETAILSPEOINVOICEID" NUMBER(18,0),
"CSTGROSSMARGINDETAILSPEOINVOICELINEID" NUMBER(18,0),
"CSTGROSSMARGINDETAILSPEOINVOICENUMBER" VARCHAR2(20) COLLATE "USING_NLS_COMP",
"CSTGROSSMARGINDETAILSPEOINVOICESOURCE" VARCHAR2(30) COLLATE "USING_NLS_COMP",
"CSTGROSSMARGINDETAILSPEOSHIPMENTNUMBER" VARCHAR2(240) COLLATE "USING_NLS_COMP",
"CSTGROSSMARGINDETAILSPEOSHIPMENTTYPE" VARCHAR2(50) COLLATE "USING_NLS_COMP",
"CSTGROSSMARGINDETAILSPEORECOGNIZEDGROSSMARGIN" NUMBER,
"CSTGROSSMARGINDETAILSPEORECOGNIZEDREV" NUMBER,
"CSTGROSSMARGINDETAILSPEOCREATIONDATE" TIMESTAMP (6),
"CSTGROSSMARGINDETAILSPEOCREATEDBY" VARCHAR2(64) COLLATE "USING_NLS_COMP",
"CSTGROSSMARGINDETAILSPEOLASTUPDATEDATE" TIMESTAMP (6) NOT NULL ENABLE,
"CSTGROSSMARGINDETAILSPEOLASTUPDATEDBY" VARCHAR2(64) COLLATE "USING_NLS_COMP",
"IDMAESTROCARGUE" NUMBER(18,0) NOT NULL ENABLE
) DEFAULT COLLATION "USING_NLS_COMP" ;