Diccionario de Datos
Diccionario de datos de los modelos de COÉXITO
| 🏠 Menú principal | ← Volver a tablas |
STADW.ST_SALESINVOICECUSTOMERTRXLINE_OM_HIST
Base de datos origen: ADW COEXITO
Columnas
| # | Columna | Tipo | Nulo | Default | Comentario |
|---|---|---|---|---|---|
| 1 | CUSTOMERTRXLINEID | NUMBER(18,0) | NO | ||
| 2 | TRANSACTIONLINECUSTOMERTRXID | NUMBER(18,0) | NO | ||
| 3 | TRANSACTIONLINEINVENTORYITEMID | NUMBER(18,0) | SI | ||
| 4 | TRANSACTIONLINEORGID | NUMBER(18,0) | NO | ||
| 5 | TRANSACTIONLINEWAREHOUSEID | NUMBER(18,0) | SI | ||
| 6 | TRANSACTIONLINELINENUMBER | NUMBER | SI | ||
| 7 | TRANSACTIONLINESALESORDER | VARCHAR2(50) | SI | ||
| 8 | TRANSACTIONLINESALESORDERLINE | VARCHAR2(30) | SI | ||
| 9 | TRANSACTIONLINESOURCEDOCUMENTLINEID | NUMBER(18,0) | SI | ||
| 10 | TRANSACTIONLINEDESCRIPTION | VARCHAR2(240) | SI | ||
| 11 | TRANSACTIONLINEQUANTITYORDERED | NUMBER | SI | ||
| 12 | TRANSACTIONLINEQUANTITYINVOICED | NUMBER | SI | ||
| 13 | TRANSACTIONLINEQUANTITYCREDITED | NUMBER | SI | ||
| 14 | TRANSACTIONLINEUNITSTANDARDPRICE | NUMBER | SI | ||
| 15 | TRANSACTIONLINEUNITSELLINGPRICE | NUMBER | SI | ||
| 16 | TRANSACTIONLINEEXTENDEDAMOUNT | NUMBER | SI | ||
| 17 | TRANSACTIONHEADERCUSTOMERTRXID | NUMBER(18,0) | NO | ||
| 18 | TRANSACTIONHEADERTRXNUMBER | VARCHAR2(20) | NO | ||
| 19 | TRANSACTIONHEADERTRXDATE | DATE | NO | ||
| 20 | TRANSACTIONHEADERBILLTOCUSTOMERID | NUMBER(18,0) | SI | ||
| 21 | TRANSACTIONHEADERSOLDTOCUSTOMERID | NUMBER(18,0) | SI | ||
| 22 | TRANSACTIONHEADERSOLDTOPARTYID | NUMBER(18,0) | SI | ||
| 23 | TRANSACTIONHEADERSHIPTOCUSTOMERID | NUMBER(18,0) | SI | ||
| 24 | TRANSACTIONHEADERSHIPTOPARTYID | NUMBER(18,0) | SI | ||
| 25 | TRANSACTIONHEADERLEGALENTITYID | NUMBER(18,0) | SI | ||
| 26 | TRANSACTIONHEADERPRIMARYRESOURCESALESREPID | NUMBER(18,0) | SI | ||
| 27 | BUSINESSUNITBUSINESSUNITID | NUMBER(18,0) | NO | ||
| 28 | BUSINESSUNITNAME | VARCHAR2(240) | SI | ||
| 29 | TRANSACTIONLINECREATIONDATE | TIMESTAMP(6) | NO | ||
| 30 | TRANSACTIONLINELASTUPDATEDATE | TIMESTAMP(6) | NO | ||
| 31 | TRANSACTIONLINECREATEDBY | VARCHAR2(64) | NO | ||
| 32 | TRANSACTIONLINELASTUPDATEDBY | VARCHAR2(64) | NO | ||
| 33 | IDMAESTROCARGUE | NUMBER | NO |
Restricciones
CHECK: SYS_C00291152
- Estado: ENABLED
- Columnas: CUSTOMERTRXLINEID
- Condición:
"CUSTOMERTRXLINEID" IS NOT NULL
CHECK: SYS_C00291153
- Estado: ENABLED
- Columnas: TRANSACTIONLINECUSTOMERTRXID
- Condición:
"TRANSACTIONLINECUSTOMERTRXID" IS NOT NULL
CHECK: SYS_C00291154
- Estado: ENABLED
- Columnas: TRANSACTIONLINEORGID
- Condición:
"TRANSACTIONLINEORGID" IS NOT NULL
CHECK: SYS_C00291155
- Estado: ENABLED
- Columnas: TRANSACTIONHEADERCUSTOMERTRXID
- Condición:
"TRANSACTIONHEADERCUSTOMERTRXID" IS NOT NULL
CHECK: SYS_C00291156
- Estado: ENABLED
- Columnas: TRANSACTIONHEADERTRXNUMBER
- Condición:
"TRANSACTIONHEADERTRXNUMBER" IS NOT NULL
CHECK: SYS_C00291157
- Estado: ENABLED
- Columnas: TRANSACTIONHEADERTRXDATE
- Condición:
"TRANSACTIONHEADERTRXDATE" IS NOT NULL
CHECK: SYS_C00291158
- Estado: ENABLED
- Columnas: BUSINESSUNITBUSINESSUNITID
- Condición:
"BUSINESSUNITBUSINESSUNITID" IS NOT NULL
CHECK: SYS_C00291159
- Estado: ENABLED
- Columnas: TRANSACTIONLINECREATIONDATE
- Condición:
"TRANSACTIONLINECREATIONDATE" IS NOT NULL
CHECK: SYS_C00291160
- Estado: ENABLED
- Columnas: TRANSACTIONLINELASTUPDATEDATE
- Condición:
"TRANSACTIONLINELASTUPDATEDATE" IS NOT NULL
CHECK: SYS_C00291161
- Estado: ENABLED
- Columnas: TRANSACTIONLINECREATEDBY
- Condición:
"TRANSACTIONLINECREATEDBY" IS NOT NULL
CHECK: SYS_C00291162
- Estado: ENABLED
- Columnas: TRANSACTIONLINELASTUPDATEDBY
- Condición:
"TRANSACTIONLINELASTUPDATEDBY" IS NOT NULL
CHECK: SYS_C00291163
- Estado: ENABLED
- Columnas: IDMAESTROCARGUE
- Condición:
"IDMAESTROCARGUE" IS NOT NULL
DDL
CREATE TABLE "STADW"."ST_SALESINVOICECUSTOMERTRXLINE_OM_HIST"
( "CUSTOMERTRXLINEID" NUMBER(18,0) NOT NULL ENABLE,
"TRANSACTIONLINECUSTOMERTRXID" NUMBER(18,0) NOT NULL ENABLE,
"TRANSACTIONLINEINVENTORYITEMID" NUMBER(18,0),
"TRANSACTIONLINEORGID" NUMBER(18,0) NOT NULL ENABLE,
"TRANSACTIONLINEWAREHOUSEID" NUMBER(18,0),
"TRANSACTIONLINELINENUMBER" NUMBER,
"TRANSACTIONLINESALESORDER" VARCHAR2(50) COLLATE "USING_NLS_COMP",
"TRANSACTIONLINESALESORDERLINE" VARCHAR2(30) COLLATE "USING_NLS_COMP",
"TRANSACTIONLINESOURCEDOCUMENTLINEID" NUMBER(18,0),
"TRANSACTIONLINEDESCRIPTION" VARCHAR2(240) COLLATE "USING_NLS_COMP",
"TRANSACTIONLINEQUANTITYORDERED" NUMBER,
"TRANSACTIONLINEQUANTITYINVOICED" NUMBER,
"TRANSACTIONLINEQUANTITYCREDITED" NUMBER,
"TRANSACTIONLINEUNITSTANDARDPRICE" NUMBER,
"TRANSACTIONLINEUNITSELLINGPRICE" NUMBER,
"TRANSACTIONLINEEXTENDEDAMOUNT" NUMBER,
"TRANSACTIONHEADERCUSTOMERTRXID" NUMBER(18,0) NOT NULL ENABLE,
"TRANSACTIONHEADERTRXNUMBER" VARCHAR2(20) COLLATE "USING_NLS_COMP" NOT NULL ENABLE,
"TRANSACTIONHEADERTRXDATE" DATE NOT NULL ENABLE,
"TRANSACTIONHEADERBILLTOCUSTOMERID" NUMBER(18,0),
"TRANSACTIONHEADERSOLDTOCUSTOMERID" NUMBER(18,0),
"TRANSACTIONHEADERSOLDTOPARTYID" NUMBER(18,0),
"TRANSACTIONHEADERSHIPTOCUSTOMERID" NUMBER(18,0),
"TRANSACTIONHEADERSHIPTOPARTYID" NUMBER(18,0),
"TRANSACTIONHEADERLEGALENTITYID" NUMBER(18,0),
"TRANSACTIONHEADERPRIMARYRESOURCESALESREPID" NUMBER(18,0),
"BUSINESSUNITBUSINESSUNITID" NUMBER(18,0) NOT NULL ENABLE,
"BUSINESSUNITNAME" VARCHAR2(240) COLLATE "USING_NLS_COMP",
"TRANSACTIONLINECREATIONDATE" TIMESTAMP (6) NOT NULL ENABLE,
"TRANSACTIONLINELASTUPDATEDATE" TIMESTAMP (6) NOT NULL ENABLE,
"TRANSACTIONLINECREATEDBY" VARCHAR2(64) COLLATE "USING_NLS_COMP" NOT NULL ENABLE,
"TRANSACTIONLINELASTUPDATEDBY" VARCHAR2(64) COLLATE "USING_NLS_COMP" NOT NULL ENABLE,
"IDMAESTROCARGUE" NUMBER NOT NULL ENABLE
) DEFAULT COLLATION "USING_NLS_COMP" ;