STADW.ST_SALESINVOICECUSTOMERTRXLINE_OM

Base de datos origen: ADW COEXITO

Descripción: Español: Almacena el detalle de líneas de transacciones de facturación, incluyendo artículos, cantidades, precios, clientes, organizaciones y referencias de venta. English: Stores billing transaction line details, including items, quantities, prices, customers, organizations, and sales references.

Columnas

#	Columna	Tipo	Nulo
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_C00286278

Estado: ENABLED
Columnas: CUSTOMERTRXLINEID
Condición: "CUSTOMERTRXLINEID" IS NOT NULL

CHECK: SYS_C00286279

Estado: ENABLED
Columnas: TRANSACTIONLINECUSTOMERTRXID
Condición: "TRANSACTIONLINECUSTOMERTRXID" IS NOT NULL

CHECK: SYS_C00286280

Estado: ENABLED
Columnas: TRANSACTIONLINEORGID
Condición: "TRANSACTIONLINEORGID" IS NOT NULL

CHECK: SYS_C00286281

Estado: ENABLED
Columnas: TRANSACTIONHEADERCUSTOMERTRXID
Condición: "TRANSACTIONHEADERCUSTOMERTRXID" IS NOT NULL

CHECK: SYS_C00286282

Estado: ENABLED
Columnas: TRANSACTIONHEADERTRXNUMBER
Condición: "TRANSACTIONHEADERTRXNUMBER" IS NOT NULL

CHECK: SYS_C00286283

Estado: ENABLED
Columnas: TRANSACTIONHEADERTRXDATE
Condición: "TRANSACTIONHEADERTRXDATE" IS NOT NULL

CHECK: SYS_C00286284

Estado: ENABLED
Columnas: BUSINESSUNITBUSINESSUNITID
Condición: "BUSINESSUNITBUSINESSUNITID" IS NOT NULL

CHECK: SYS_C00286286

Estado: ENABLED
Columnas: TRANSACTIONLINECREATIONDATE
Condición: "TRANSACTIONLINECREATIONDATE" IS NOT NULL

CHECK: SYS_C00286287

Estado: ENABLED
Columnas: TRANSACTIONLINELASTUPDATEDATE
Condición: "TRANSACTIONLINELASTUPDATEDATE" IS NOT NULL

CHECK: SYS_C00286288

Estado: ENABLED
Columnas: TRANSACTIONLINECREATEDBY
Condición: "TRANSACTIONLINECREATEDBY" IS NOT NULL

CHECK: SYS_C00286289

Estado: ENABLED
Columnas: TRANSACTIONLINELASTUPDATEDBY
Condición: "TRANSACTIONLINELASTUPDATEDBY" IS NOT NULL

CHECK: SYS_C00286290

Estado: ENABLED
Columnas: IDMAESTROCARGUE
Condición: "IDMAESTROCARGUE" IS NOT NULL

DDL

CREATE TABLE "STADW"."ST_SALESINVOICECUSTOMERTRXLINE_OM" 
   (	"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" ;

COMMENT ON TABLE "STADW"."ST_SALESINVOICECUSTOMERTRXLINE_OM"  IS 'Español: Almacena el detalle de líneas de transacciones de facturación, incluyendo artículos, cantidades, precios, clientes, organizaciones y referencias de venta.

English: Stores billing transaction line details, including items, quantities, prices, customers, organizations, and sales references.';

CREATE INDEX "STADW"."ST_SALESINVTRXLINE_ID_IDX" ON "STADW"."ST_SALESINVOICECUSTOMERTRXLINE_OM" ("CUSTOMERTRXLINEID") 
  ;

← Volver a tablas de STADW

🏠 Volver al menú principal