🏠 Menú principal

← Volver a tablas

---

DWADW.FACT_RECEIPTACCOUNTING_GL

Base de datos origen: ADW COEXITO

Descripción: Español: Información contable de recepciones de compras y movimientos asociados a órdenes de compra, proveedores y contabilización en General Ledger. English: Accounting information for purchase receipts and movements associated with purchase orders, suppliers, and General Ledger posting.

Columnas

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

Restricciones

CHECK: FACT_RECEIPTACCOUNTING_GL_AI_CK

• Estado: ENABLED
• Columnas: ROW_ACTIVE
• Condición: row_active IN ('A','I')

CHECK: SYS_C00202918

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

CHECK: SYS_C00202919

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

CHECK: SYS_C00202920

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

PK: FACT_RECEIPTACCOUNTING_GL_PK

• Estado: ENABLED
• Columnas: RECEIPTACCOUNTING_GL_ID

FK: FACT_RECEIPTACCOINTING_GL_DIM_CODECOMBINATION_GL_FK

• Estado: ENABLED
• Columnas: DIM_CODECOMBINATION_GL_ID
• Referencia: DWADW.DIM_CODECOMBINATION_GL (constraint DIM_CODECOMBINATION_GL_PK)

FK: FACT_RECEIPTACCOUNTING_GL_DIM_SUPPLIER_AP_FK

• Estado: ENABLED
• Columnas: DIM_SUPPLIER_AP_ID
• Referencia: DWADW.DIM_SUPPLIER_AP (constraint DIM_SUPPLIER_AP_PK)

UK: FACT_RECEIPTACCOUNTING_GL__UN

• Estado: ENABLED
• Columnas: CMR_SUBLEDGERID

DDL

CREATE TABLE "DWADW"."FACT_RECEIPTACCOUNTING_GL" 
   (	"RECEIPTACCOUNTING_GL_ID" NUMBER GENERATED BY DEFAULT AS IDENTITY MINVALUE 1 MAXVALUE 9999999999999999999999999999 INCREMENT BY 1 START WITH 1 CACHE 20 NOORDER  NOCYCLE  NOKEEP  NOSCALE  NOT NULL ENABLE, 
	"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_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", 
	"AUDIT_ID" NUMBER NOT NULL ENABLE, 
	"ROW_ACTIVE" CHAR(1) COLLATE "USING_NLS_COMP" DEFAULT 'A' NOT NULL ENABLE, 
	"DIM_SUPPLIER_AP_ID" NUMBER, 
	"DIM_CODECOMBINATION_GL_ID" NUMBER, 
	 CONSTRAINT "FACT_RECEIPTACCOUNTING_GL_AI_CK" CHECK (row_active IN ('A','I')) ENABLE, 
	 CONSTRAINT "FACT_RECEIPTACCOUNTING_GL_PK" PRIMARY KEY ("RECEIPTACCOUNTING_GL_ID")
  USING INDEX  ENABLE, 
	 CONSTRAINT "FACT_RECEIPTACCOUNTING_GL__UN" UNIQUE ("CMR_SUBLEDGERID")
  USING INDEX  ENABLE, 
	 CONSTRAINT "FACT_RECEIPTACCOUNTING_GL_DIM_SUPPLIER_AP_FK" FOREIGN KEY ("DIM_SUPPLIER_AP_ID")
	  REFERENCES "DWADW"."DIM_SUPPLIER_AP" ("SUPPLIER_AP_ID") ENABLE, 
	 CONSTRAINT "FACT_RECEIPTACCOINTING_GL_DIM_CODECOMBINATION_GL_FK" FOREIGN KEY ("DIM_CODECOMBINATION_GL_ID")
	  REFERENCES "DWADW"."DIM_CODECOMBINATION_GL" ("CODECOMBINATION_GL_ID") ENABLE
   )  DEFAULT COLLATION "USING_NLS_COMP" ;

COMMENT ON TABLE "DWADW"."FACT_RECEIPTACCOUNTING_GL"  IS 'Español: Información contable de recepciones de compras y movimientos asociados a órdenes de compra, proveedores y contabilización en General Ledger.
English: Accounting information for purchase receipts and movements associated with purchase orders, suppliers, and General Ledger posting.';

CREATE UNIQUE INDEX "DWADW"."FACT_RECEIPTACCOUNTING_GL_PK" ON "DWADW"."FACT_RECEIPTACCOUNTING_GL" ("RECEIPTACCOUNTING_GL_ID") 
  ;
  CREATE UNIQUE INDEX "DWADW"."FACT_RECEIPTACCOUNTING_GL__UN" ON "DWADW"."FACT_RECEIPTACCOUNTING_GL" ("CMR_SUBLEDGERID") 
  ;

---

← Volver a tablas de DWADW

🏠 Volver al menú principal