🏠 Menú principal

← Volver a tablas

---

STADW.ST_ARTRXHEADER

Base de datos origen: ADW COEXITO

Columnas

#	Columna	Tipo	Nulo	Default	Comentario
1	CUSTOMERTRXID	NUMBER	NO
2	TRANSACTIONHEADERTRXNUMBER	NUMBER	SI
3	DOCSEQHDRNAME	VARCHAR2(500)	SI
4	TRANSACTIONBATCHSOURCENAME	VARCHAR2(200)	SI
5	TRANSACTIONHEADERTRXCLASS	VARCHAR2(10)	SI
6	CUSTACCTACCOUNTNUMBER	VARCHAR2(500)	SI
7	TRANSACTIONHEADERCOMMENTS	VARCHAR2(1000)	SI
8	TRANSACTIONHEADERCOMPLETEFLAG	VARCHAR2(10)	SI
9	TRANSACTIONHEADERCTREFERENCE	VARCHAR2(200)	SI
10	TRANSACTIONHEADERCUSTTRXTYPESEQID	NUMBER	SI
11	TRANSACTIONHEADERSTATUSTRX	VARCHAR2(10)	SI
12	TRANSACTIONHEADERTERMDUEDATE	DATE	SI
13	TRANSACTIONHEADERTRXDATE	DATE	SI
14	TRANSACTIONHEADERTERMID	NUMBER	SI
15	TRANSACTIONHEADEREXCHANGEDATE	DATE	SI
16	TRANSACTIONHEADERINTERFACEHEADERCONTEXT	VARCHAR2(100)	SI
17	TRANSACTIONHEADERINVOICECURRENCYCODE	VARCHAR2(10)	SI
18	TRANSACTIONHEADERPRINTINGPENDING	VARCHAR2(10)	SI
19	TRANSACTIONHEADERREASONCODE	VARCHAR2(10)	SI
20	CUSTACCTCUSTACCOUNTID	NUMBER	SI
21	CUSTACCTPARTYID	NUMBER	SI
22	SHIPTOADDRLOCATIONLOCATIONID	NUMBER	SI
23	SHIPTOPARTYSITEPARTYSITEID	NUMBER	SI
24	TRANSACTIONHEADERSHIPTOCONTACTID	NUMBER	SI
25	TRANSACTIONHEADERBILLTOCONTACTID	NUMBER	SI
26	TRANSACTIONHEADERBILLTOSITEUSEID	NUMBER	SI
27	TRANSACTIONHEADERPRIMARYRESOURCESALESREPID	NUMBER	SI

Restricciones

CHECK: SYS_C0024721

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

PK: ST_ARTRXHEADER_PK

• Estado: ENABLED
• Columnas: CUSTOMERTRXID

DDL

CREATE TABLE "STADW"."ST_ARTRXHEADER" 
   (	"CUSTOMERTRXID" NUMBER NOT NULL ENABLE, 
	"TRANSACTIONHEADERTRXNUMBER" NUMBER, 
	"DOCSEQHDRNAME" VARCHAR2(500) COLLATE "USING_NLS_COMP", 
	"TRANSACTIONBATCHSOURCENAME" VARCHAR2(200) COLLATE "USING_NLS_COMP", 
	"TRANSACTIONHEADERTRXCLASS" VARCHAR2(10) COLLATE "USING_NLS_COMP", 
	"CUSTACCTACCOUNTNUMBER" VARCHAR2(500) COLLATE "USING_NLS_COMP", 
	"TRANSACTIONHEADERCOMMENTS" VARCHAR2(1000) COLLATE "USING_NLS_COMP", 
	"TRANSACTIONHEADERCOMPLETEFLAG" VARCHAR2(10) COLLATE "USING_NLS_COMP", 
	"TRANSACTIONHEADERCTREFERENCE" VARCHAR2(200) COLLATE "USING_NLS_COMP", 
	"TRANSACTIONHEADERCUSTTRXTYPESEQID" NUMBER, 
	"TRANSACTIONHEADERSTATUSTRX" VARCHAR2(10) COLLATE "USING_NLS_COMP", 
	"TRANSACTIONHEADERTERMDUEDATE" DATE, 
	"TRANSACTIONHEADERTRXDATE" DATE, 
	"TRANSACTIONHEADERTERMID" NUMBER, 
	"TRANSACTIONHEADEREXCHANGEDATE" DATE, 
	"TRANSACTIONHEADERINTERFACEHEADERCONTEXT" VARCHAR2(100) COLLATE "USING_NLS_COMP", 
	"TRANSACTIONHEADERINVOICECURRENCYCODE" VARCHAR2(10) COLLATE "USING_NLS_COMP", 
	"TRANSACTIONHEADERPRINTINGPENDING" VARCHAR2(10) COLLATE "USING_NLS_COMP", 
	"TRANSACTIONHEADERREASONCODE" VARCHAR2(10) COLLATE "USING_NLS_COMP", 
	"CUSTACCTCUSTACCOUNTID" NUMBER, 
	"CUSTACCTPARTYID" NUMBER, 
	"SHIPTOADDRLOCATIONLOCATIONID" NUMBER, 
	"SHIPTOPARTYSITEPARTYSITEID" NUMBER, 
	"TRANSACTIONHEADERSHIPTOCONTACTID" NUMBER, 
	"TRANSACTIONHEADERBILLTOCONTACTID" NUMBER, 
	"TRANSACTIONHEADERBILLTOSITEUSEID" NUMBER, 
	"TRANSACTIONHEADERPRIMARYRESOURCESALESREPID" NUMBER, 
	 CONSTRAINT "ST_ARTRXHEADER_PK" PRIMARY KEY ("CUSTOMERTRXID")
  USING INDEX  ENABLE
   )  DEFAULT COLLATION "USING_NLS_COMP" ;

GRANT INDEX ON "STADW"."ST_ARTRXHEADER" TO "BICC";
  GRANT REFERENCES ON "STADW"."ST_ARTRXHEADER" TO "BICC";
  GRANT ON COMMIT REFRESH ON "STADW"."ST_ARTRXHEADER" TO "BICC";
  GRANT QUERY REWRITE ON "STADW"."ST_ARTRXHEADER" TO "BICC";
  GRANT FLASHBACK ON "STADW"."ST_ARTRXHEADER" TO "BICC";
  GRANT DELETE ON "STADW"."ST_ARTRXHEADER" TO "BICC";
  GRANT INSERT ON "STADW"."ST_ARTRXHEADER" TO "BICC";
  GRANT SELECT ON "STADW"."ST_ARTRXHEADER" TO "BICC";
  GRANT UPDATE ON "STADW"."ST_ARTRXHEADER" TO "BICC";
  GRANT ALTER ON "STADW"."ST_ARTRXHEADER" TO "BICC";
  GRANT DELETE ON "STADW"."ST_ARTRXHEADER" TO "MANAGE_DW_ST";
  GRANT INSERT ON "STADW"."ST_ARTRXHEADER" TO "MANAGE_DW_ST";
  GRANT SELECT ON "STADW"."ST_ARTRXHEADER" TO "MANAGE_DW_ST";
  GRANT UPDATE ON "STADW"."ST_ARTRXHEADER" TO "MANAGE_DW_ST";
  GRANT ALTER ON "STADW"."ST_ARTRXHEADER" TO "MANAGE_DW_ST";
  GRANT READ ON "STADW"."ST_ARTRXHEADER" TO "MANAGE_DW_ST";
  GRANT DEBUG ON "STADW"."ST_ARTRXHEADER" TO "MANAGE_DW_ST";
  GRANT READ ON "STADW"."ST_ARTRXHEADER" TO "BICC";
  GRANT DEBUG ON "STADW"."ST_ARTRXHEADER" TO "BICC";
  GRANT ASSERTION REFERENCES ON "STADW"."ST_ARTRXHEADER" TO "BICC";

CREATE UNIQUE INDEX "STADW"."ST_ARTRXHEADER_PK" ON "STADW"."ST_ARTRXHEADER" ("CUSTOMERTRXID") 
  ;

---

← Volver a tablas de STADW

🏠 Volver al menú principal