🏠 Menú principal

← Volver a tablas

---

DWADW.FACT_TRXHEADER_AP

Base de datos origen: ADW COEXITO

Descripción: Español: Cabecera de facturas de proveedor en cuentas por pagar, utilizada para controlar facturas, aprobación, estado contable y pagos asociados. English: Supplier invoice header in Accounts Payable, used to control invoices, approval status, accounting status, and related payments.

Columnas

#	Columna	Tipo	Nulo	Default	Comentario
1	TRXHEADER_AP_ID	NUMBER	NO	“DWADW”.”ISEQ$$_306925”.nextval
2	DESCRIPTION	VARCHAR2(500)	SI
3	SEQUENCE_NAME	VARCHAR2(50)	SI
4	INV_DIST_COUNT	NUMBER	SI
5	POSTED_COUNTED	NUMBER	SI
6	BATCH_ID	NUMBER	SI
7	BATCH_NAME	VARCHAR2(100)	SI
8	ACCOUNTING_STATUS_CODE	VARCHAR2(50)	SI
9	VALIDATION_STATUS_CODE	VARCHAR2(50)	SI
10	APPROVAL_STATUS	VARCHAR2(50)	SI
11	CREATED_BY	VARCHAR2(100)	SI
12	CREATION_DATE	DATE	SI
13	INVOICE_DESCRIPTION	VARCHAR2(500)	SI
14	CATEGORY_CODE	VARCHAR2(100)	SI
15	SEQUENCE_VALUE	NUMBER	SI
16	EXCLUSIVE_PAYMENT_FLAG	VARCHAR2(10)	SI
17	GL_DATE	DATE	SI
18	INTERCOMPANY_FLAG	VARCHAR2(10)	SI
19	CURRENCY_CODE	VARCHAR2(30)	SI
20	INVOICE_DATE	DATE	SI
21	INVOICE_NUM	VARCHAR2(100)	SI
22	TYPE_LOOKUP_CODE	VARCHAR2(100)	SI
23	LAST_UPDATE_DATE	DATE	SI
24	LAST_UPDATE_BY	VARCHAR2(100)	SI
25	PAY_GROUP_LOOKUP_CODE	VARCHAR2(50)	SI
26	PAYMENT_STATUS_FLAG	VARCHAR2(50)	SI
27	ROUTING_STATUS_LOOKUP	VARCHAR2(50)	SI
28	TAXATION_COUNTRY	VARCHAR2(50)	SI
29	TERMS_DATE	DATE	SI
30	INVOICEID	NUMBER	NO
31	CREATED_BY_NAME	VARCHAR2(500)	SI
32	VENDORID	NUMBER	SI
33	AUDIT_ID	NUMBER	NO
34	ROW_ACTIVE	CHAR(1)	NO	‘A’
35	DIM_SUPPLIER_AP_ID	NUMBER	SI

Restricciones

CHECK: FACT_TRXHEADER_AP_AI_CK

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

CHECK: SYS_C00202924

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

CHECK: SYS_C00202925

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

CHECK: SYS_C00202926

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

CHECK: SYS_C00202927

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

PK: FACT_TRXHEADER_AP_PK

• Estado: ENABLED
• Columnas: TRXHEADER_AP_ID

FK: FACT_TRXHEADER_AP_DIM_SUPPLIER_AP_FK

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

UK: FACT_TRXHEADER_AP_INVOICE_UN

• Estado: ENABLED
• Columnas: INVOICEID

DDL

CREATE TABLE "DWADW"."FACT_TRXHEADER_AP" 
   (	"TRXHEADER_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, 
	"DESCRIPTION" VARCHAR2(500) COLLATE "USING_NLS_COMP", 
	"SEQUENCE_NAME" VARCHAR2(50) COLLATE "USING_NLS_COMP", 
	"INV_DIST_COUNT" NUMBER, 
	"POSTED_COUNTED" NUMBER, 
	"BATCH_ID" NUMBER, 
	"BATCH_NAME" VARCHAR2(100) COLLATE "USING_NLS_COMP", 
	"ACCOUNTING_STATUS_CODE" VARCHAR2(50) COLLATE "USING_NLS_COMP", 
	"VALIDATION_STATUS_CODE" VARCHAR2(50) COLLATE "USING_NLS_COMP", 
	"APPROVAL_STATUS" VARCHAR2(50) COLLATE "USING_NLS_COMP", 
	"CREATED_BY" VARCHAR2(100) COLLATE "USING_NLS_COMP", 
	"CREATION_DATE" DATE, 
	"INVOICE_DESCRIPTION" VARCHAR2(500) COLLATE "USING_NLS_COMP", 
	"CATEGORY_CODE" VARCHAR2(100) COLLATE "USING_NLS_COMP", 
	"SEQUENCE_VALUE" NUMBER(*,0), 
	"EXCLUSIVE_PAYMENT_FLAG" VARCHAR2(10) COLLATE "USING_NLS_COMP", 
	"GL_DATE" DATE, 
	"INTERCOMPANY_FLAG" VARCHAR2(10) COLLATE "USING_NLS_COMP", 
	"CURRENCY_CODE" VARCHAR2(30) COLLATE "USING_NLS_COMP", 
	"INVOICE_DATE" DATE, 
	"INVOICE_NUM" VARCHAR2(100) COLLATE "USING_NLS_COMP", 
	"TYPE_LOOKUP_CODE" VARCHAR2(100) COLLATE "USING_NLS_COMP", 
	"LAST_UPDATE_DATE" DATE, 
	"LAST_UPDATE_BY" VARCHAR2(100) COLLATE "USING_NLS_COMP", 
	"PAY_GROUP_LOOKUP_CODE" VARCHAR2(50) COLLATE "USING_NLS_COMP", 
	"PAYMENT_STATUS_FLAG" VARCHAR2(50) COLLATE "USING_NLS_COMP", 
	"ROUTING_STATUS_LOOKUP" VARCHAR2(50) COLLATE "USING_NLS_COMP", 
	"TAXATION_COUNTRY" VARCHAR2(50) COLLATE "USING_NLS_COMP", 
	"TERMS_DATE" DATE, 
	"INVOICEID" NUMBER(*,0) NOT NULL ENABLE, 
	"CREATED_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_TRXHEADER_AP_AI_CK" CHECK (row_active IN ('A','I')) ENABLE, 
	 CONSTRAINT "FACT_TRXHEADER_AP_PK" PRIMARY KEY ("TRXHEADER_AP_ID")
  USING INDEX  ENABLE, 
	 CONSTRAINT "FACT_TRXHEADER_AP_INVOICE_UN" UNIQUE ("INVOICEID")
  USING INDEX  ENABLE, 
	 CONSTRAINT "FACT_TRXHEADER_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_TRXHEADER_AP"  IS 'Español: Cabecera de facturas de proveedor en cuentas por pagar, utilizada para controlar facturas, aprobación, estado contable y pagos asociados.
English: Supplier invoice header in Accounts Payable, used to control invoices, approval status, accounting status, and related payments.';

CREATE INDEX "DWADW"."FACT_TRXHEADER_AP__IDX" ON "DWADW"."FACT_TRXHEADER_AP" ("DESCRIPTION") 
  ;
  CREATE UNIQUE INDEX "DWADW"."FACT_TRXHEADER_AP_PK" ON "DWADW"."FACT_TRXHEADER_AP" ("TRXHEADER_AP_ID") 
  ;
  CREATE UNIQUE INDEX "DWADW"."FACT_TRXHEADER_AP_INVOICE_UN" ON "DWADW"."FACT_TRXHEADER_AP" ("INVOICEID") 
  ;

---

← Volver a tablas de DWADW

🏠 Volver al menú principal