🏠 Menú principal

← Volver a tablas

---

DWADW.FACT_PAYMENT_AP

Base de datos origen: ADW COEXITO

Descripción: Español: Registro de pagos y desembolsos realizados a proveedores, incluyendo cheques, montos, fechas de pago y estado de conciliación. English: Record of payments and disbursements made to suppliers, including checks, amounts, payment dates, and reconciliation status.

Columnas

#	Columna	Tipo	Nulo	Default	Comentario
1	PAYMENT_AP_ID	NUMBER	NO	“DWADW”.”ISEQ$$_306917”.nextval
2	CHECKID	NUMBER	NO
3	VALUE_DATE	DATE	SI
4	ADDRESS_LINE1	VARCHAR2(500)	SI
5	AMOUNT	NUMBER	SI
6	CHECK_DATE	DATE	SI
7	CHECK_NUMBER	NUMBER	SI
8	RUN_NAME	VARCHAR2(500)	SI
9	CITY	VARCHAR2(500)	SI
10	CLEARED_AMOUNT	NUMBER	SI
11	CLEARED_DATE	DATE	SI
12	COUNTRY	VARCHAR2(500)	SI
13	CREATED_BY	VARCHAR2(100)	SI
14	CREATION_DATE	DATE	SI
15	CURRENCY_CODE	VARCHAR2(50)	SI
16	SEQUENCE_VALUE	VARCHAR2(100)	SI
17	CHANGE_DATE	DATE	SI
18	LAST_UPDATE_DATE	DATE	SI
19	LAST_UPDATE_BY	VARCHAR2(100)	SI
20	METHOD_CODE	VARCHAR2(100)	SI
21	RECON_FLAG	VARCHAR2(10)	SI
22	ADDRESS_NAME	VARCHAR2(500)	SI
23	STATE	VARCHAR2(500)	SI
24	LOOKUP_CODE	VARCHAR2(50)	SI
25	DOC_SEQUENCE_NAME	VARCHAR2(50)	SI
26	PARTY_SITE_NAME	VARCHAR2(500)	SI
27	PAYMENT_DOC_NAME	VARCHAR2(100)	SI
28	PAYMENT_PROFILE_NAME	VARCHAR2(150)	SI
29	UPDATE_BY_NAME	VARCHAR2(500)	SI
30	VENDORID	NUMBER	SI
31	AUDIT_ID	NUMBER	NO
32	ROW_ACTIVE	CHAR(1)	NO	‘A’
33	DIM_SUPPLIER_AP_ID	NUMBER	SI

Restricciones

CHECK: FACT_PAYMENT_AP_AI_CK

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

CHECK: SYS_C00202911

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

CHECK: SYS_C00202912

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

CHECK: SYS_C00202913

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

CHECK: SYS_C00202914

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

PK: FACT_PAYMENT_AP_PK

• Estado: ENABLED
• Columnas: PAYMENT_AP_ID

FK: FACT_PAYMENT_AP_DIM_SUPPLIER_AP_FK

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

UK: FACT_PAYMENT_PO_CHECKID_UN

• Estado: ENABLED
• Columnas: CHECKID

DDL

CREATE TABLE "DWADW"."FACT_PAYMENT_AP" 
   (	"PAYMENT_AP_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, 
	"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, 
	"CURRENCY_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", 
	"STATE" VARCHAR2(500) COLLATE "USING_NLS_COMP", 
	"LOOKUP_CODE" VARCHAR2(50) COLLATE "USING_NLS_COMP", 
	"DOC_SEQUENCE_NAME" VARCHAR2(50) 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, 
	"AUDIT_ID" NUMBER NOT NULL ENABLE, 
	"ROW_ACTIVE" CHAR(1) COLLATE "USING_NLS_COMP" DEFAULT 'A' NOT NULL ENABLE, 
	"DIM_SUPPLIER_AP_ID" NUMBER, 
	 CONSTRAINT "FACT_PAYMENT_AP_AI_CK" CHECK (row_active IN ('A','I')) ENABLE, 
	 CONSTRAINT "FACT_PAYMENT_AP_PK" PRIMARY KEY ("PAYMENT_AP_ID")
  USING INDEX  ENABLE, 
	 CONSTRAINT "FACT_PAYMENT_PO_CHECKID_UN" UNIQUE ("CHECKID")
  USING INDEX  ENABLE, 
	 CONSTRAINT "FACT_PAYMENT_AP_DIM_SUPPLIER_AP_FK" FOREIGN KEY ("DIM_SUPPLIER_AP_ID")
	  REFERENCES "DWADW"."DIM_SUPPLIER_AP" ("SUPPLIER_AP_ID") ENABLE
   )  DEFAULT COLLATION "USING_NLS_COMP" ;

COMMENT ON TABLE "DWADW"."FACT_PAYMENT_AP"  IS 'Español: Registro de pagos y desembolsos realizados a proveedores, incluyendo cheques, montos, fechas de pago y estado de conciliación.
English: Record of payments and disbursements made to suppliers, including checks, amounts, payment dates, and reconciliation status.';

CREATE UNIQUE INDEX "DWADW"."FACT_PAYMENT_AP_PK" ON "DWADW"."FACT_PAYMENT_AP" ("PAYMENT_AP_ID") 
  ;
  CREATE UNIQUE INDEX "DWADW"."FACT_PAYMENT_PO_CHECKID_UN" ON "DWADW"."FACT_PAYMENT_AP" ("CHECKID") 
  ;

---

← Volver a tablas de DWADW

🏠 Volver al menú principal