🏠 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

-- Error obteniendo DDL completo: ORA-01745: invalid host/bind variable name

---

← Volver a tablas de DWADW

🏠 Volver al menú principal