Diccionario de Datos
Diccionario de datos de los modelos de COÉXITO
| 🏠 Menú principal | ← Volver a tablas |
STADW.ST_TRANSACTIONLINEDISTRIBUTION_AR_HIST
Base de datos origen: ADW COEXITO
Columnas
| # | Columna | Tipo | Nulo | Default | Comentario |
|---|---|---|---|---|---|
| 1 | TRANSACTIONLINECUSTOMERTRXLINEID | NUMBER(18,0) | SI | ||
| 2 | CUSTTRXLINEGLDISTID | NUMBER(18,0) | SI | ||
| 3 | TRANSACTIONLINEDISTRIBUTIONCODECOMBINATIONID | NUMBER(18,0) | SI | ||
| 4 | TRANSACTIONHEADERDISTEXCHANGERATE | NUMBER(10,5) | SI | ||
| 5 | TRANSACTIONHEADERDISTEXCHANGEDATE | DATE | SI | ||
| 6 | TRANSACTIONLINEDISTRIBUTIONGLDATE | DATE | SI | ||
| 7 | TRANSACTIONLINEDISTRIBUTIONORIGINALGLDATE | DATE | SI | ||
| 8 | TRANSACTIONLINEDISTRIBUTIONACCTDAMOUNT | NUMBER(20,10) | SI | ||
| 9 | TRANSACTIONLINELASTUPDATEDATE | DATE | SI | ||
| 10 | IDMAESTROCARGUE | NUMBER | NO |
Restricciones
CHECK: SYS_C00209620
- Estado: ENABLED
- Columnas: IDMAESTROCARGUE
- Condición:
"IDMAESTROCARGUE" IS NOT NULL
DDL
CREATE TABLE "STADW"."ST_TRANSACTIONLINEDISTRIBUTION_AR_HIST"
( "TRANSACTIONLINECUSTOMERTRXLINEID" NUMBER(18,0),
"CUSTTRXLINEGLDISTID" NUMBER(18,0),
"TRANSACTIONLINEDISTRIBUTIONCODECOMBINATIONID" NUMBER(18,0),
"TRANSACTIONHEADERDISTEXCHANGERATE" NUMBER(10,5),
"TRANSACTIONHEADERDISTEXCHANGEDATE" DATE,
"TRANSACTIONLINEDISTRIBUTIONGLDATE" DATE,
"TRANSACTIONLINEDISTRIBUTIONORIGINALGLDATE" DATE,
"TRANSACTIONLINEDISTRIBUTIONACCTDAMOUNT" NUMBER(20,10),
"TRANSACTIONLINELASTUPDATEDATE" DATE,
"IDMAESTROCARGUE" NUMBER NOT NULL ENABLE
) DEFAULT COLLATION "USING_NLS_COMP" ;