🏠 Menú principal

← Volver a tablas

---

DWADW.DIM_TRANSACTIONHEADER_OM

Base de datos origen: ADW COEXITO

Descripción: Español: Catálogo de cabeceras de transacciones de facturación. Contiene número y fecha de transacción, cliente, moneda, condiciones de pago, referencias y dirección de envío, y permite relacionar las órdenes con sus documentos de facturación. English: Billing transaction header catalog. It contains transaction number and date, customer, currency, payment terms, references, and shipping address and supports linking orders with their billing documents.

Columnas

#	Columna	Tipo	Nulo	Default	Comentario
1	TRANSACTIONHEADER_OM_ID	NUMBER	NO	“DWADW”.”ISEQ$$_378172”.nextval
2	CUSTOMERTRXID	NUMBER(18,0)	NO
3	BUSINESSUNITNAME	VARCHAR2(240)	SI
4	TRANSACTIONBATCHSOURCENAME	VARCHAR2(50)	SI
5	CUSTACCTCUSTACCOUNTID	NUMBER(18,0)	SI
6	CUSTACCTACCOUNTNUMBER	VARCHAR2(30)	SI
7	TRANSACTIONHEADERTRXNUMBER	VARCHAR2(20)	SI
8	TRANSACTIONHEADERTRXDATE	DATE	SI
9	TRANSACTIONHEADERDOCSEQUENCEVALUE	NUMBER(18,0)	SI
10	TRANSACTIONHEADERTRXCLASS	VARCHAR2(20)	SI
11	TRXCLASSLOOKUPCODE	VARCHAR2(30)	SI
12	TRXCLASSMEANING	VARCHAR2(80)	SI
13	TRANSACTIONHEADERCUSTTRXTYPESEQID	NUMBER(18,0)	SI
14	TRANSACTIONHEADERCOMPLETEFLAG	VARCHAR2(1)	SI
15	TRANSACTIONHEADERSTATUSTRX	VARCHAR2(30)	SI
16	TRANSACTIONHEADERINVOICECURRENCYCODE	VARCHAR2(15)	SI
17	TRANSACTIONHEADERTERMID	NUMBER(18,0)	SI
18	TRANSACTIONHEADERTERMDUEDATE	DATE	SI
19	TRANSACTIONHEADERCUSTOMERREFERENCE	VARCHAR2(30)	SI
20	TRANSACTIONHEADERPURCHASEORDER	VARCHAR2(50)	SI
21	TRANSACTIONHEADERBILLTOSITEUSEID	NUMBER(18,0)	SI
22	SHIPTOPARTYSITEPARTYSITEID	NUMBER(18,0)	SI
23	SHIPTOADDRLOCATIONLOCATIONID	NUMBER(18,0)	SI
24	SHIPTOADDRLOCATIONADDRESS1	VARCHAR2(240)	SI
25	SHIPTOADDRLOCATIONCITY	VARCHAR2(60)	SI
26	SHIPTOADDRLOCATIONSTATE	VARCHAR2(60)	SI
27	SHIPTOADDRLOCATIONCOUNTRY	VARCHAR2(2)	SI
28	SHIPTOADDRLOCATIONPOSTALCODE	VARCHAR2(60)	SI
29	TRANSACTIONHEADERCREATEDBY	VARCHAR2(64)	SI
30	TRANSACTIONHEADERCREATIONDATE	TIMESTAMP(6)	SI
31	TRANSACTIONHEADERLASTUPDATEDBY	VARCHAR2(64)	SI
32	TRANSACTIONHEADERLASTUPDATEDATE	TIMESTAMP(6)	SI
33	ROW_ACTIVE	CHAR(1)	NO	‘A’
34	AUDIT_ID	NUMBER	NO
35	DIM_TYPESTRX_OM_ID	NUMBER	SI

Restricciones

CHECK: DIM_TRANSACTIONHEADER_OM_CK

• Estado: ENABLED
• Columnas: ROW_ACTIVE
• Condición: row_active IN ('A','I')

CHECK: SYS_C00304882

• Estado: ENABLED
• Columnas: TRANSACTIONHEADER_OM_ID
• Condición: "TRANSACTIONHEADER_OM_ID" IS NOT NULL

CHECK: SYS_C00304883

• Estado: ENABLED
• Columnas: CUSTOMERTRXID
• Condición: "CUSTOMERTRXID" IS NOT NULL

CHECK: SYS_C00304884

• Estado: ENABLED
• Columnas: ROW_ACTIVE
• Condición: "ROW_ACTIVE" IS NOT NULL

CHECK: SYS_C00304885

• Estado: ENABLED
• Columnas: AUDIT_ID
• Condición: "AUDIT_ID" IS NOT NULL

PK: DIM_TRANSACTIONHEADER_OM_PK

• Estado: ENABLED
• Columnas: TRANSACTIONHEADER_OM_ID

FK: DIM_TRANSACTIONHEADER_OM_DIM_TYPETRX_OM_FK

• Estado: ENABLED
• Columnas: DIM_TYPESTRX_OM_ID
• Referencia: DWADW.DIM_TYPESTRX_OM (constraint DIM_TYPESTRX_OM_PK)

UK: DIM_TRANSACTIONHEADER_OM__UN

• Estado: ENABLED
• Columnas: CUSTOMERTRXID

DDL

CREATE TABLE "DWADW"."DIM_TRANSACTIONHEADER_OM" 
   (	"TRANSACTIONHEADER_OM_ID" NUMBER GENERATED BY DEFAULT AS IDENTITY MINVALUE 1 MAXVALUE 9999999999999999999999999999 INCREMENT BY 1 START WITH 1 CACHE 20 NOORDER  NOCYCLE  NOKEEP  NOSCALE  NOT NULL ENABLE, 
	"CUSTOMERTRXID" NUMBER(18,0) NOT NULL ENABLE, 
	"BUSINESSUNITNAME" VARCHAR2(240) COLLATE "USING_NLS_COMP", 
	"TRANSACTIONBATCHSOURCENAME" VARCHAR2(50) COLLATE "USING_NLS_COMP", 
	"CUSTACCTCUSTACCOUNTID" NUMBER(18,0), 
	"CUSTACCTACCOUNTNUMBER" VARCHAR2(30) COLLATE "USING_NLS_COMP", 
	"TRANSACTIONHEADERTRXNUMBER" VARCHAR2(20) COLLATE "USING_NLS_COMP", 
	"TRANSACTIONHEADERTRXDATE" DATE, 
	"TRANSACTIONHEADERDOCSEQUENCEVALUE" NUMBER(18,0), 
	"TRANSACTIONHEADERTRXCLASS" VARCHAR2(20) COLLATE "USING_NLS_COMP", 
	"TRXCLASSLOOKUPCODE" VARCHAR2(30) COLLATE "USING_NLS_COMP", 
	"TRXCLASSMEANING" VARCHAR2(80) COLLATE "USING_NLS_COMP", 
	"TRANSACTIONHEADERCUSTTRXTYPESEQID" NUMBER(18,0), 
	"TRANSACTIONHEADERCOMPLETEFLAG" VARCHAR2(1) COLLATE "USING_NLS_COMP", 
	"TRANSACTIONHEADERSTATUSTRX" VARCHAR2(30) COLLATE "USING_NLS_COMP", 
	"TRANSACTIONHEADERINVOICECURRENCYCODE" VARCHAR2(15) COLLATE "USING_NLS_COMP", 
	"TRANSACTIONHEADERTERMID" NUMBER(18,0), 
	"TRANSACTIONHEADERTERMDUEDATE" DATE, 
	"TRANSACTIONHEADERCUSTOMERREFERENCE" VARCHAR2(30) COLLATE "USING_NLS_COMP", 
	"TRANSACTIONHEADERPURCHASEORDER" VARCHAR2(50) COLLATE "USING_NLS_COMP", 
	"TRANSACTIONHEADERBILLTOSITEUSEID" NUMBER(18,0), 
	"SHIPTOPARTYSITEPARTYSITEID" NUMBER(18,0), 
	"SHIPTOADDRLOCATIONLOCATIONID" NUMBER(18,0), 
	"SHIPTOADDRLOCATIONADDRESS1" VARCHAR2(240) COLLATE "USING_NLS_COMP", 
	"SHIPTOADDRLOCATIONCITY" VARCHAR2(60) COLLATE "USING_NLS_COMP", 
	"SHIPTOADDRLOCATIONSTATE" VARCHAR2(60) COLLATE "USING_NLS_COMP", 
	"SHIPTOADDRLOCATIONCOUNTRY" VARCHAR2(2) COLLATE "USING_NLS_COMP", 
	"SHIPTOADDRLOCATIONPOSTALCODE" VARCHAR2(60) COLLATE "USING_NLS_COMP", 
	"TRANSACTIONHEADERCREATEDBY" VARCHAR2(64) COLLATE "USING_NLS_COMP", 
	"TRANSACTIONHEADERCREATIONDATE" TIMESTAMP (6), 
	"TRANSACTIONHEADERLASTUPDATEDBY" VARCHAR2(64) COLLATE "USING_NLS_COMP", 
	"TRANSACTIONHEADERLASTUPDATEDATE" TIMESTAMP (6), 
	"ROW_ACTIVE" CHAR(1) COLLATE "USING_NLS_COMP" DEFAULT 'A' NOT NULL ENABLE, 
	"AUDIT_ID" NUMBER NOT NULL ENABLE, 
	"DIM_TYPESTRX_OM_ID" NUMBER, 
	 CONSTRAINT "DIM_TRANSACTIONHEADER_OM_CK" CHECK (row_active IN ('A','I')) ENABLE, 
	 CONSTRAINT "DIM_TRANSACTIONHEADER_OM_PK" PRIMARY KEY ("TRANSACTIONHEADER_OM_ID")
  USING INDEX  ENABLE, 
	 CONSTRAINT "DIM_TRANSACTIONHEADER_OM__UN" UNIQUE ("CUSTOMERTRXID")
  USING INDEX  ENABLE, 
	 CONSTRAINT "DIM_TRANSACTIONHEADER_OM_DIM_TYPETRX_OM_FK" FOREIGN KEY ("DIM_TYPESTRX_OM_ID")
	  REFERENCES "DWADW"."DIM_TYPESTRX_OM" ("TYPESTRX_OM_ID") ENABLE
   )  DEFAULT COLLATION "USING_NLS_COMP" ;

COMMENT ON TABLE "DWADW"."DIM_TRANSACTIONHEADER_OM"  IS 'Español: Catálogo de cabeceras de transacciones de facturación. Contiene número y fecha de transacción, cliente, moneda, condiciones de pago, referencias y dirección de envío, y permite relacionar las órdenes con sus documentos de facturación.
English: Billing transaction header catalog. It contains transaction number and date, customer, currency, payment terms, references, and shipping address and supports linking orders with their billing documents.';

CREATE UNIQUE INDEX "DWADW"."DIM_TRANSACTIONHEADER_OM_PK" ON "DWADW"."DIM_TRANSACTIONHEADER_OM" ("TRANSACTIONHEADER_OM_ID") 
  ;
  CREATE UNIQUE INDEX "DWADW"."DIM_TRANSACTIONHEADER_OM__UN" ON "DWADW"."DIM_TRANSACTIONHEADER_OM" ("CUSTOMERTRXID") 
  ;

---

← Volver a tablas de DWADW

🏠 Volver al menú principal