Diccionario de Datos
Diccionario de datos de los modelos de COÉXITO
| 🏠 Menú principal | ← Volver a tablas |
STADW.ST_MARGINDETAILSEXTRACT_OM
Base de datos origen: ADW COEXITO
Descripción: Español: Almacena el detalle de costos de ventas reconocidos (COGS) y margen bruto asociado a transacciones comerciales. Contiene información de artículos, organizaciones, clientes, órdenes, facturas, despachos, cuentas contables e importes reconocidos para el análisis de costos y rentabilidad. English: Stores detailed recognized Cost of Goods Sold (COGS) and gross margin information associated with business transactions. It contains item, organization, customer, order, invoice, shipment, accounting account, and recognized amount information for cost and profitability analysis.
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_C00284982
- Estado: ENABLED
- Columnas: CSTGROSSMARGINDETAILSPEOGROSSMARGINDETAILID
- Condición:
"CSTGROSSMARGINDETAILSPEOGROSSMARGINDETAILID" IS NOT NULL
CHECK: SYS_C00284983
- Estado: ENABLED
- Columnas: CSTGROSSMARGINDETAILSPEOLASTUPDATEDATE
- Condición:
"CSTGROSSMARGINDETAILSPEOLASTUPDATEDATE" IS NOT NULL
CHECK: SYS_C00284984
- Estado: ENABLED
- Columnas: IDMAESTROCARGUE
- Condición:
"IDMAESTROCARGUE" IS NOT NULL
DDL
CREATE TABLE "STADW"."ST_MARGINDETAILSEXTRACT_OM"
( "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" ;
COMMENT ON TABLE "STADW"."ST_MARGINDETAILSEXTRACT_OM" IS 'Español: Almacena el detalle de costos de ventas reconocidos (COGS) y margen bruto asociado a transacciones comerciales. Contiene información de artículos, organizaciones, clientes, órdenes, facturas, despachos, cuentas contables e importes reconocidos para el análisis de costos y rentabilidad.
English: Stores detailed recognized Cost of Goods Sold (COGS) and gross margin information associated with business transactions. It contains item, organization, customer, order, invoice, shipment, accounting account, and recognized amount information for cost and profitability analysis.';
CREATE INDEX "STADW"."ST_MARGINDETAILSEXTRACT_OM_IDX" ON "STADW"."ST_MARGINDETAILSEXTRACT_OM" ("CSTGROSSMARGINDETAILSPEOGROSSMARGINDETAILID")
;