Diccionario de Datos
Diccionario de datos de los modelos de COÉXITO
| 🏠 Menú principal | ← Volver a tablas |
STADW.ST_MARGINDETAILSEXTRACT_OM_TMP_39507
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 | CSTGROSSMARGINDETAILSPEOINVOICESOURCE | VARCHAR2(30) | SI | ||
| 20 | CSTGROSSMARGINDETAILSPEOSHIPMENTNUMBER | VARCHAR2(240) | SI | ||
| 21 | CSTGROSSMARGINDETAILSPEOSHIPMENTTYPE | VARCHAR2(50) | SI | ||
| 22 | CSTGROSSMARGINDETAILSPEORECOGNIZEDGROSSMARGIN | NUMBER | SI | ||
| 23 | CSTGROSSMARGINDETAILSPEORECOGNIZEDREV | NUMBER | SI | ||
| 24 | CSTGROSSMARGINDETAILSPEOCREATIONDATE | TIMESTAMP(6) | SI | ||
| 25 | CSTGROSSMARGINDETAILSPEOCREATEDBY | VARCHAR2(64) | SI | ||
| 26 | CSTGROSSMARGINDETAILSPEOLASTUPDATEDATE | TIMESTAMP(6) | NO | ||
| 27 | CSTGROSSMARGINDETAILSPEOLASTUPDATEDBY | VARCHAR2(64) | SI | ||
| 28 | IDMAESTROCARGUE | NUMBER(18,0) | NO | ||
| 29 | CSTGROSSMARGINDETAILSPEOINVOICENUMBER | NUMBER(18,0) | SI |
Restricciones
CHECK: SYS_C00356153
- Estado: ENABLED
- Columnas: CSTGROSSMARGINDETAILSPEOGROSSMARGINDETAILID
- Condición:
"CSTGROSSMARGINDETAILSPEOGROSSMARGINDETAILID" IS NOT NULL
CHECK: SYS_C00356154
- Estado: ENABLED
- Columnas: CSTGROSSMARGINDETAILSPEOLASTUPDATEDATE
- Condición:
"CSTGROSSMARGINDETAILSPEOLASTUPDATEDATE" IS NOT NULL
CHECK: SYS_C00356155
- Estado: ENABLED
- Columnas: IDMAESTROCARGUE
- Condición:
"IDMAESTROCARGUE" IS NOT NULL
DDL
CREATE TABLE "STADW"."ST_MARGINDETAILSEXTRACT_OM_TMP_39507"
( "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),
"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,
"CSTGROSSMARGINDETAILSPEOINVOICENUMBER" NUMBER(18,0)
) DEFAULT COLLATION "USING_NLS_COMP" ;