🏠 Menú principal

← Volver a tablas

---

DWADW.DW_RECEIPTACCOINTING

Base de datos origen: ADW COEXITO

Columnas

#	Columna	Tipo	Nulo	Default	Comentario
1	LOOKUP_MEANING	VARCHAR2(200)	SI
2	CMR_DEST_TYPE_CODE	VARCHAR2(50)	SI
3	CMR_EVENT_UNIT_COST	NUMBER	SI
4	CMR_RECEIPT_NUMBER	VARCHAR2(100)	SI
5	CMR_TRXACTION_DATE	DATE	SI
6	CMR_SUBLEDGERID	NUMBER	SI
7	START_DATE	DATE	SI
8	EVENT_CLASS_CODE	VARCHAR2(50)	SI
9	EVENT_TYPE_CODE	VARCHAR2(50)	SI
10	TRXALTION_NAME	VARCHAR2(200)	SI
11	PERSON_DISPLAY_NAME	VARCHAR2(200)	SI
12	PERSON_FULL_NAME	VARCHAR2(200)	SI
13	PO_DIST_NUMBER	VARCHAR2(200)	SI
14	PO_DIST_ID	NUMBER	SI
15	PO_NUMBER	VARCHAR2(50)	SI
16	PO_VENDOR_ID	NUMBER	SI
17	PO_HEADER_COMMENTS	VARCHAR2(500)	SI
18	PO_CURRENCY_CODE	VARCHAR2(50)	SI
19	PO_SEGMENT1	VARCHAR2(50)	SI
20	PO_DOCUMENT_LINE	NUMBER	SI
21	PO_DOCUMENT_LINE_STATUS	VARCHAR2(50)	SI
22	REC_TRX_TYPE	VARCHAR2(50)	SI
23	REC_ACCOUNT_FLAG	VARCHAR2(50)	SI
24	REC_ACCOUNT_EVENTID	NUMBER	SI
25	REC_ACCOUNT_CREATED_BY	VARCHAR2(100)	SI
26	REC_ACCOUNT_CREATION_DATE	DATE	SI
27	REC_CLASS_CODE	VARCHAR2(50)	SI
28	REC_EVENT_ID	NUMBER	SI
29	REC_GL_DATE	DATE	SI
30	REC_LEDGER_ID	NUMBER	SI
31	REC_LEGALENTITY_ID	NUMBER	SI
32	REC_TRX_NUMBER	VARCHAR2(100)	SI
33	REC_DOC_NUMBER	VARCHAR2(100)	SI
34	REC_TRX_AMOUNT	NUMBER	SI
35	REC_TRX_DATE	DATE	SI
36	REC_ACCOUNTED_FLAG	VARCHAR2(5)	SI
37	REC_RESERVATION_STATUS	VARCHAR2(50)	SI
38	REC_ACCOUNTING_EVENTID	NUMBER	SI
39	REC_ACCOUNTING_GL_TYPE	VARCHAR2(50)	SI
40	REC_CODECOMBINATIONID	NUMBER	SI
41	REC_CREATED_BY	VARCHAR2(50)	SI
42	REC_CREATION_DATE	DATE	SI
43	REC_CURRENCY_AMOUNT	NUMBER	SI
44	REC_COURRENCY_CODE	VARCHAR2(50)	SI
45	REC_CURRENCY_CODE	VARCHAR2(50)	SI
46	REC_REQUISITION_NUMBER	VARCHAR2(100)	SI
47	SUPERVISOR_FULLNAME	VARCHAR2(2000)	SI
48	PARTY_NAME	VARCHAR2(200)	SI
49	PARTY_ID	NUMBER	SI
50	FISCAL_CODE	VARCHAR2(100)	SI

Restricciones

Sin restricciones visibles (P/R/U/C).

DDL

CREATE TABLE "DWADW"."DW_RECEIPTACCOINTING" 
   (	"LOOKUP_MEANING" VARCHAR2(200) COLLATE "USING_NLS_COMP", 
	"CMR_DEST_TYPE_CODE" VARCHAR2(50) COLLATE "USING_NLS_COMP", 
	"CMR_EVENT_UNIT_COST" NUMBER, 
	"CMR_RECEIPT_NUMBER" VARCHAR2(100) COLLATE "USING_NLS_COMP", 
	"CMR_TRXACTION_DATE" DATE, 
	"CMR_SUBLEDGERID" NUMBER, 
	"START_DATE" DATE, 
	"EVENT_CLASS_CODE" VARCHAR2(50) COLLATE "USING_NLS_COMP", 
	"EVENT_TYPE_CODE" VARCHAR2(50) COLLATE "USING_NLS_COMP", 
	"TRXALTION_NAME" VARCHAR2(200) COLLATE "USING_NLS_COMP", 
	"PERSON_DISPLAY_NAME" VARCHAR2(200) COLLATE "USING_NLS_COMP", 
	"PERSON_FULL_NAME" VARCHAR2(200) COLLATE "USING_NLS_COMP", 
	"PO_DIST_NUMBER" VARCHAR2(200) COLLATE "USING_NLS_COMP", 
	"PO_DIST_ID" NUMBER, 
	"PO_NUMBER" VARCHAR2(50) COLLATE "USING_NLS_COMP", 
	"PO_VENDOR_ID" NUMBER, 
	"PO_HEADER_COMMENTS" VARCHAR2(500) COLLATE "USING_NLS_COMP", 
	"PO_CURRENCY_CODE" VARCHAR2(50) COLLATE "USING_NLS_COMP", 
	"PO_SEGMENT1" VARCHAR2(50) COLLATE "USING_NLS_COMP", 
	"PO_DOCUMENT_LINE" NUMBER, 
	"PO_DOCUMENT_LINE_STATUS" VARCHAR2(50) COLLATE "USING_NLS_COMP", 
	"REC_TRX_TYPE" VARCHAR2(50) COLLATE "USING_NLS_COMP", 
	"REC_ACCOUNT_FLAG" VARCHAR2(50) COLLATE "USING_NLS_COMP", 
	"REC_ACCOUNT_EVENTID" NUMBER, 
	"REC_ACCOUNT_CREATED_BY" VARCHAR2(100) COLLATE "USING_NLS_COMP", 
	"REC_ACCOUNT_CREATION_DATE" DATE, 
	"REC_CLASS_CODE" VARCHAR2(50) COLLATE "USING_NLS_COMP", 
	"REC_EVENT_ID" NUMBER, 
	"REC_GL_DATE" DATE, 
	"REC_LEDGER_ID" NUMBER, 
	"REC_LEGALENTITY_ID" NUMBER, 
	"REC_TRX_NUMBER" VARCHAR2(100) COLLATE "USING_NLS_COMP", 
	"REC_DOC_NUMBER" VARCHAR2(100) COLLATE "USING_NLS_COMP", 
	"REC_TRX_AMOUNT" NUMBER, 
	"REC_TRX_DATE" DATE, 
	"REC_ACCOUNTED_FLAG" VARCHAR2(5) COLLATE "USING_NLS_COMP", 
	"REC_RESERVATION_STATUS" VARCHAR2(50) COLLATE "USING_NLS_COMP", 
	"REC_ACCOUNTING_EVENTID" NUMBER, 
	"REC_ACCOUNTING_GL_TYPE" VARCHAR2(50) COLLATE "USING_NLS_COMP", 
	"REC_CODECOMBINATIONID" NUMBER, 
	"REC_CREATED_BY" VARCHAR2(50) COLLATE "USING_NLS_COMP", 
	"REC_CREATION_DATE" DATE, 
	"REC_CURRENCY_AMOUNT" NUMBER, 
	"REC_COURRENCY_CODE" VARCHAR2(50) COLLATE "USING_NLS_COMP", 
	"REC_CURRENCY_CODE" VARCHAR2(50) COLLATE "USING_NLS_COMP", 
	"REC_REQUISITION_NUMBER" VARCHAR2(100) COLLATE "USING_NLS_COMP", 
	"SUPERVISOR_FULLNAME" VARCHAR2(2000) COLLATE "USING_NLS_COMP", 
	"PARTY_NAME" VARCHAR2(200) COLLATE "USING_NLS_COMP", 
	"PARTY_ID" NUMBER, 
	"FISCAL_CODE" VARCHAR2(100) COLLATE "USING_NLS_COMP"
   )  DEFAULT COLLATION "USING_NLS_COMP" ;

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

---

← Volver a tablas de DWADW

🏠 Volver al menú principal