🏠 Menú principal

← Volver a tablas

---

DWADW.DW_CASHRECEIPT

Base de datos origen: ADW COEXITO

Columnas

#	Columna	Tipo	Nulo	Default	Comentario
1	RECEIPTID	NUMBER	NO
2	ACCOUNT_NAME	VARCHAR2(500)	SI
3	ACCOUNT_NUMBER	VARCHAR2(500)	SI
4	PARTY_ID	NUMBER	SI
5	PARTY_NAME	VARCHAR2(500)	SI
6	PARTY_NUMBER	VARCHAR2(500)	SI
7	SCHEDULE_AMOUNT_APPLIED	NUMBER	SI
8	SCHEDULE_AMOUNT_ORIGINAL	NUMBER	SI
9	SCHDULE_DUE_DATE	DATE	SI
10	SCHEDULE_LAST_UPDATE	DATE	SI
11	REC_ACCOUNTED_AMOUNT	NUMBER	SI
12	REC_VALUE_DATE	DATE	SI
13	RECEIPT_AMOUNT	NUMBER	SI
14	REC_BATCH_ID	NUMBER	SI
15	REC_BATCH_NAME	VARCHAR2(50)	SI
16	REC_COMMENTS	VARCHAR2(2500)	SI
17	REC_CONFIRMED_FLAG	VARCHAR2(10)	SI
18	REC_CREATED_BY	VARCHAR2(100)	SI
19	REC_CREATION_DATE	DATE	SI
20	REC_DEPOSIT_DATE	DATE	SI
21	REC_LAST_UPDATE	DATE	SI
22	RECEIPT_DATE	DATE	SI
23	RECEIPT_NUMBER	VARCHAR2(100)	SI
24	FISCAL_CODE	VARCHAR2(100)	SI

Restricciones

CHECK: SYS_C0024878

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

PK: SYS_C0024879

• Estado: ENABLED
• Columnas: RECEIPTID

DDL

CREATE TABLE "DWADW"."DW_CASHRECEIPT" 
   (	"RECEIPTID" NUMBER(*,0) NOT NULL ENABLE, 
	"ACCOUNT_NAME" VARCHAR2(500) COLLATE "USING_NLS_COMP", 
	"ACCOUNT_NUMBER" VARCHAR2(500) COLLATE "USING_NLS_COMP", 
	"PARTY_ID" NUMBER, 
	"PARTY_NAME" VARCHAR2(500) COLLATE "USING_NLS_COMP", 
	"PARTY_NUMBER" VARCHAR2(500) COLLATE "USING_NLS_COMP", 
	"SCHEDULE_AMOUNT_APPLIED" NUMBER, 
	"SCHEDULE_AMOUNT_ORIGINAL" NUMBER, 
	"SCHDULE_DUE_DATE" DATE, 
	"SCHEDULE_LAST_UPDATE" DATE, 
	"REC_ACCOUNTED_AMOUNT" NUMBER, 
	"REC_VALUE_DATE" DATE, 
	"RECEIPT_AMOUNT" NUMBER, 
	"REC_BATCH_ID" NUMBER, 
	"REC_BATCH_NAME" VARCHAR2(50) COLLATE "USING_NLS_COMP", 
	"REC_COMMENTS" VARCHAR2(2500) COLLATE "USING_NLS_COMP", 
	"REC_CONFIRMED_FLAG" VARCHAR2(10) COLLATE "USING_NLS_COMP", 
	"REC_CREATED_BY" VARCHAR2(100) COLLATE "USING_NLS_COMP", 
	"REC_CREATION_DATE" DATE, 
	"REC_DEPOSIT_DATE" DATE, 
	"REC_LAST_UPDATE" DATE, 
	"RECEIPT_DATE" DATE, 
	"RECEIPT_NUMBER" VARCHAR2(100) COLLATE "USING_NLS_COMP", 
	"FISCAL_CODE" VARCHAR2(100) COLLATE "USING_NLS_COMP", 
	 PRIMARY KEY ("RECEIPTID")
  USING INDEX  ENABLE
   )  DEFAULT COLLATION "USING_NLS_COMP" ;

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

CREATE UNIQUE INDEX "DWADW"."SYS_C0024879" ON "DWADW"."DW_CASHRECEIPT" ("RECEIPTID") 
  ;

---

← Volver a tablas de DWADW

🏠 Volver al menú principal