Diccionario de Datos
Diccionario de datos de los modelos de COÉXITO
| 🏠 Menú principal | ← Volver a tablas |
STADW.ST_TRANSACTIONLINE_AR_HIST
Base de datos origen: ADW COEXITO
Columnas
| # | Columna | Tipo | Nulo | Default | Comentario |
|---|---|---|---|---|---|
| 1 | CUSTOMERTRXLINEID | NUMBER | SI | ||
| 2 | TRANSACTIONLINECUSTOMERTRXID | NUMBER | SI | ||
| 3 | SOLDTOCUSTACCTCUSTACCOUNTID | NUMBER(18,0) | SI | ||
| 4 | SOLDTOCUSTACCTPARTYID | NUMBER(18,0) | SI | ||
| 5 | SOLDTOPARTYSITEPARTYSITEID | NUMBER(18,0) | SI | ||
| 6 | TRANSACTIONLINEDESCRIPTION | VARCHAR2(2000) | SI | ||
| 7 | TRANSACTIONLINELINENUMBER | NUMBER(10,0) | SI | ||
| 8 | TRANSACTIONLINELINETYPE | VARCHAR2(100) | SI | ||
| 9 | TRANSACTIONLINEPRODUCTTYPE | VARCHAR2(100) | SI | ||
| 10 | TRANSACTIONLINEGROSSUNITSELLINGPRICE | NUMBER(20,10) | SI | ||
| 11 | TRANSACTIONLINEQUANTITYCREDITED | NUMBER(20,10) | SI | ||
| 12 | TRANSACTIONLINEQUANTITYINVOICED | NUMBER(20,10) | SI | ||
| 13 | TRANSACTIONLINEQUANTITYORDERED | NUMBER(20,10) | SI | ||
| 14 | TRANSACTIONLINEREVENUEAMOUNT | NUMBER(30,10) | SI | ||
| 15 | TRANSACTIONHEADERTRXDATE | DATE | SI | ||
| 16 | TRANSACTIONLINESALESORDER | VARCHAR2(50) | SI | ||
| 17 | TRANSACTIONLINESALESORDERDATE | DATE | SI | ||
| 18 | TRANSACTIONLINESALESORDERLINE | NUMBER(38,0) | SI | ||
| 19 | TRANSACTIONLINEUNITSTANDARDPRICE | NUMBER(20,6) | SI | ||
| 20 | TRANSACTIONLINEUOMCODE | VARCHAR2(30) | SI | ||
| 21 | TRANSACTIONLINEINVENTORYITEMID | NUMBER(18,0) | SI | ||
| 22 | TRANSACTIONLINEWAREHOUSEID | NUMBER(18,0) | SI | ||
| 23 | TRANSACTIONLINELASTUPDATEDATE | DATE | SI | ||
| 24 | IDMAESTROCARGUE | NUMBER | NO | ||
| 25 | TRANSACTIONHEADERINVOICECURRENCYCODE | VARCHAR2(30) | SI |
Restricciones
CHECK: SYS_C00210353
- Estado: ENABLED
- Columnas: IDMAESTROCARGUE
- Condición:
"IDMAESTROCARGUE" IS NOT NULL
DDL
CREATE TABLE "STADW"."ST_TRANSACTIONLINE_AR_HIST"
( "CUSTOMERTRXLINEID" NUMBER,
"TRANSACTIONLINECUSTOMERTRXID" NUMBER,
"SOLDTOCUSTACCTCUSTACCOUNTID" NUMBER(18,0),
"SOLDTOCUSTACCTPARTYID" NUMBER(18,0),
"SOLDTOPARTYSITEPARTYSITEID" NUMBER(18,0),
"TRANSACTIONLINEDESCRIPTION" VARCHAR2(2000) COLLATE "USING_NLS_COMP",
"TRANSACTIONLINELINENUMBER" NUMBER(10,0),
"TRANSACTIONLINELINETYPE" VARCHAR2(100) COLLATE "USING_NLS_COMP",
"TRANSACTIONLINEPRODUCTTYPE" VARCHAR2(100) COLLATE "USING_NLS_COMP",
"TRANSACTIONLINEGROSSUNITSELLINGPRICE" NUMBER(20,10),
"TRANSACTIONLINEQUANTITYCREDITED" NUMBER(20,10),
"TRANSACTIONLINEQUANTITYINVOICED" NUMBER(20,10),
"TRANSACTIONLINEQUANTITYORDERED" NUMBER(20,10),
"TRANSACTIONLINEREVENUEAMOUNT" NUMBER(30,10),
"TRANSACTIONHEADERTRXDATE" DATE,
"TRANSACTIONLINESALESORDER" VARCHAR2(50) COLLATE "USING_NLS_COMP",
"TRANSACTIONLINESALESORDERDATE" DATE,
"TRANSACTIONLINESALESORDERLINE" NUMBER(38,0),
"TRANSACTIONLINEUNITSTANDARDPRICE" NUMBER(20,6),
"TRANSACTIONLINEUOMCODE" VARCHAR2(30) COLLATE "USING_NLS_COMP",
"TRANSACTIONLINEINVENTORYITEMID" NUMBER(18,0),
"TRANSACTIONLINEWAREHOUSEID" NUMBER(18,0),
"TRANSACTIONLINELASTUPDATEDATE" DATE,
"IDMAESTROCARGUE" NUMBER NOT NULL ENABLE,
"TRANSACTIONHEADERINVOICECURRENCYCODE" VARCHAR2(30) COLLATE "USING_NLS_COMP"
) DEFAULT COLLATION "USING_NLS_COMP" ;