🏠 Menú principal

← Volver a tablas

---

DWADW.DW_PAYTMENT

Base de datos origen: ADW COEXITO

Columnas

#	Columna	Tipo	Nulo	Default	Comentario
1	CHECKID	NUMBER	NO
2	VALUE_DATE	DATE	SI
3	ADDRESS_LINE1	VARCHAR2(500)	SI
4	AMOUNT	NUMBER	SI
5	CHECK_DATE	DATE	SI
6	CHECK_NUMBER	NUMBER	SI
7	RUN_NAME	VARCHAR2(500)	SI
8	CITY	VARCHAR2(500)	SI
9	CLEARED_AMOUNT	NUMBER	SI
10	CLEARED_DATE	DATE	SI
11	COUNTRY	VARCHAR2(500)	SI
12	CREATED_BY	VARCHAR2(100)	SI
13	CREATION_DATE	DATE	SI
14	CORRENCY_CODE	VARCHAR2(50)	SI
15	SEQUENCE_VALUE	VARCHAR2(100)	SI
16	CHANGE_DATE	DATE	SI
17	LAST_UPDATE_DATE	DATE	SI
18	LAST_UPDATE_BY	VARCHAR2(100)	SI
19	METHOD_CODE	VARCHAR2(100)	SI
20	RECON_FLAG	VARCHAR2(10)	SI
21	ADDRESS_NAME	VARCHAR2(500)	SI
22	SUPPLIER_NAME	VARCHAR2(500)	SI
23	STATE	VARCHAR2(500)	SI
24	LOOKUP_CODE	VARCHAR2(50)	SI
25	VENDOR_NAME	VARCHAR2(500)	SI
26	DOC_SEQUENCE_NAME	VARCHAR2(50)	SI
27	PARTY_NAME	VARCHAR2(500)	SI
28	PARTY_SITE_NAME	VARCHAR2(500)	SI
29	PAYMENT_DOC_NAME	VARCHAR2(100)	SI
30	PAYMENT_PROFILE_NAME	VARCHAR2(150)	SI
31	UPDATE_BY_NAME	VARCHAR2(500)	SI
32	VENDORID	NUMBER	SI
33	PARTYID	NUMBER	SI
34	FISCAL_CODE	VARCHAR2(100)	SI

Restricciones

CHECK: SYS_C0024785

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

PK: SYS_C0024786

• Estado: ENABLED
• Columnas: CHECKID

DDL

CREATE TABLE "DWADW"."DW_PAYTMENT" 
   (	"CHECKID" NUMBER(*,0) NOT NULL ENABLE, 
	"VALUE_DATE" DATE, 
	"ADDRESS_LINE1" VARCHAR2(500) COLLATE "USING_NLS_COMP", 
	"AMOUNT" NUMBER, 
	"CHECK_DATE" DATE, 
	"CHECK_NUMBER" NUMBER, 
	"RUN_NAME" VARCHAR2(500) COLLATE "USING_NLS_COMP", 
	"CITY" VARCHAR2(500) COLLATE "USING_NLS_COMP", 
	"CLEARED_AMOUNT" NUMBER, 
	"CLEARED_DATE" DATE, 
	"COUNTRY" VARCHAR2(500) COLLATE "USING_NLS_COMP", 
	"CREATED_BY" VARCHAR2(100) COLLATE "USING_NLS_COMP", 
	"CREATION_DATE" DATE, 
	"CORRENCY_CODE" VARCHAR2(50) COLLATE "USING_NLS_COMP", 
	"SEQUENCE_VALUE" VARCHAR2(100) COLLATE "USING_NLS_COMP", 
	"CHANGE_DATE" DATE, 
	"LAST_UPDATE_DATE" DATE, 
	"LAST_UPDATE_BY" VARCHAR2(100) COLLATE "USING_NLS_COMP", 
	"METHOD_CODE" VARCHAR2(100) COLLATE "USING_NLS_COMP", 
	"RECON_FLAG" VARCHAR2(10) COLLATE "USING_NLS_COMP", 
	"ADDRESS_NAME" VARCHAR2(500) COLLATE "USING_NLS_COMP", 
	"SUPPLIER_NAME" VARCHAR2(500) COLLATE "USING_NLS_COMP", 
	"STATE" VARCHAR2(500) COLLATE "USING_NLS_COMP", 
	"LOOKUP_CODE" VARCHAR2(50) COLLATE "USING_NLS_COMP", 
	"VENDOR_NAME" VARCHAR2(500) COLLATE "USING_NLS_COMP", 
	"DOC_SEQUENCE_NAME" VARCHAR2(50) COLLATE "USING_NLS_COMP", 
	"PARTY_NAME" VARCHAR2(500) COLLATE "USING_NLS_COMP", 
	"PARTY_SITE_NAME" VARCHAR2(500) COLLATE "USING_NLS_COMP", 
	"PAYMENT_DOC_NAME" VARCHAR2(100) COLLATE "USING_NLS_COMP", 
	"PAYMENT_PROFILE_NAME" VARCHAR2(150) COLLATE "USING_NLS_COMP", 
	"UPDATE_BY_NAME" VARCHAR2(500) COLLATE "USING_NLS_COMP", 
	"VENDORID" NUMBER, 
	"PARTYID" NUMBER, 
	"FISCAL_CODE" VARCHAR2(100) COLLATE "USING_NLS_COMP", 
	 PRIMARY KEY ("CHECKID")
  USING INDEX  ENABLE
   )  DEFAULT COLLATION "USING_NLS_COMP" ;

GRANT INDEX ON "DWADW"."DW_PAYTMENT" TO "BICC";
  GRANT REFERENCES ON "DWADW"."DW_PAYTMENT" TO "BICC";
  GRANT ON COMMIT REFRESH ON "DWADW"."DW_PAYTMENT" TO "BICC";
  GRANT QUERY REWRITE ON "DWADW"."DW_PAYTMENT" TO "BICC";
  GRANT FLASHBACK ON "DWADW"."DW_PAYTMENT" TO "BICC";
  GRANT SELECT ON "DWADW"."DW_PAYTMENT" TO "POWER_BI";
  GRANT ALTER ON "DWADW"."DW_PAYTMENT" TO "BICC";
  GRANT DELETE ON "DWADW"."DW_PAYTMENT" TO "BICC";
  GRANT INSERT ON "DWADW"."DW_PAYTMENT" TO "BICC";
  GRANT SELECT ON "DWADW"."DW_PAYTMENT" TO "BICC";
  GRANT UPDATE ON "DWADW"."DW_PAYTMENT" TO "BICC";
  GRANT READ ON "DWADW"."DW_PAYTMENT" TO "BICC";
  GRANT DEBUG ON "DWADW"."DW_PAYTMENT" TO "BICC";

CREATE UNIQUE INDEX "DWADW"."SYS_C0024786" ON "DWADW"."DW_PAYTMENT" ("CHECKID") 
  ;

---

← Volver a tablas de DWADW

🏠 Volver al menú principal