Diccionario de Datos
Diccionario de datos de los modelos de COÉXITO
| 🏠 Menú principal | ← Volver a tablas |
STADW.ST_CASHRECEIPT
Base de datos origen: ADW COEXITO
Columnas
| # | Columna | Tipo | Nulo | Default | Comentario |
|---|---|---|---|---|---|
| 1 | CASHRECEIPTID | NUMBER | NO | ||
| 2 | CUSTACCTACCOUNTNAME | VARCHAR2(500) | SI | ||
| 3 | CUSTACCTACCOUNTNUMBER | VARCHAR2(500) | SI | ||
| 4 | CUSTACCTPARTYID | NUMBER | SI | ||
| 5 | PARTYPARTYNAME | VARCHAR2(500) | SI | ||
| 6 | PARTYPARTYNUMBER | VARCHAR2(500) | SI | ||
| 7 | PAYMENTSCHEDULEAMOUNTAPPLIED | NUMBER | SI | ||
| 8 | PAYMENTSCHEDULEAMOUNTDUEORIGINAL | NUMBER | SI | ||
| 9 | PAYMENTSCHEDULEDUEDATE | DATE | SI | ||
| 10 | PAYMENTSCHEDULELASTUPDATEDATE | DATE | SI | ||
| 11 | RECEIPTACCOUNTEDAMOUNT | NUMBER | SI | ||
| 12 | RECEIPTACTUALVALUEDATE | DATE | SI | ||
| 13 | RECEIPTAMOUNT | NUMBER | SI | ||
| 14 | RECEIPTBATCHBATCHID | NUMBER | SI | ||
| 15 | RECEIPTBATCHNAME | VARCHAR2(50) | SI | ||
| 16 | RECEIPTCOMMENTS | VARCHAR2(2500) | SI | ||
| 17 | RECEIPTCONFIRMEDFLAG | VARCHAR2(10) | SI | ||
| 18 | RECEIPTCREATEDBY | VARCHAR2(100) | SI | ||
| 19 | RECEIPTCREATIONDATE | DATE | SI | ||
| 20 | RECEIPTDEPOSITDATE | DATE | SI | ||
| 21 | RECEIPTLASTUPDATEDATE | DATE | SI | ||
| 22 | RECEIPTRECEIPTDATE | DATE | SI | ||
| 23 | RECEIPTRECEIPTNUMBER | VARCHAR2(100) | SI |
Restricciones
CHECK: SYS_C0024876
- Estado: ENABLED
- Columnas: CASHRECEIPTID
- Condición:
"CASHRECEIPTID" IS NOT NULL
PK: SYS_C0024877
- Estado: ENABLED
- Columnas: CASHRECEIPTID
DDL
CREATE TABLE "STADW"."ST_CASHRECEIPT"
( "CASHRECEIPTID" NUMBER(*,0) NOT NULL ENABLE,
"CUSTACCTACCOUNTNAME" VARCHAR2(500) COLLATE "USING_NLS_COMP",
"CUSTACCTACCOUNTNUMBER" VARCHAR2(500) COLLATE "USING_NLS_COMP",
"CUSTACCTPARTYID" NUMBER,
"PARTYPARTYNAME" VARCHAR2(500) COLLATE "USING_NLS_COMP",
"PARTYPARTYNUMBER" VARCHAR2(500) COLLATE "USING_NLS_COMP",
"PAYMENTSCHEDULEAMOUNTAPPLIED" NUMBER,
"PAYMENTSCHEDULEAMOUNTDUEORIGINAL" NUMBER,
"PAYMENTSCHEDULEDUEDATE" DATE,
"PAYMENTSCHEDULELASTUPDATEDATE" DATE,
"RECEIPTACCOUNTEDAMOUNT" NUMBER,
"RECEIPTACTUALVALUEDATE" DATE,
"RECEIPTAMOUNT" NUMBER,
"RECEIPTBATCHBATCHID" NUMBER,
"RECEIPTBATCHNAME" VARCHAR2(50) COLLATE "USING_NLS_COMP",
"RECEIPTCOMMENTS" VARCHAR2(2500) COLLATE "USING_NLS_COMP",
"RECEIPTCONFIRMEDFLAG" VARCHAR2(10) COLLATE "USING_NLS_COMP",
"RECEIPTCREATEDBY" VARCHAR2(100) COLLATE "USING_NLS_COMP",
"RECEIPTCREATIONDATE" DATE,
"RECEIPTDEPOSITDATE" DATE,
"RECEIPTLASTUPDATEDATE" DATE,
"RECEIPTRECEIPTDATE" DATE,
"RECEIPTRECEIPTNUMBER" VARCHAR2(100) COLLATE "USING_NLS_COMP",
PRIMARY KEY ("CASHRECEIPTID")
USING INDEX ENABLE
) DEFAULT COLLATION "USING_NLS_COMP" ;
GRANT INDEX ON "STADW"."ST_CASHRECEIPT" TO "BICC";
GRANT REFERENCES ON "STADW"."ST_CASHRECEIPT" TO "BICC";
GRANT ON COMMIT REFRESH ON "STADW"."ST_CASHRECEIPT" TO "BICC";
GRANT QUERY REWRITE ON "STADW"."ST_CASHRECEIPT" TO "BICC";
GRANT FLASHBACK ON "STADW"."ST_CASHRECEIPT" TO "BICC";
GRANT ALTER ON "STADW"."ST_CASHRECEIPT" TO "BICC";
GRANT DELETE ON "STADW"."ST_CASHRECEIPT" TO "BICC";
GRANT INSERT ON "STADW"."ST_CASHRECEIPT" TO "BICC";
GRANT SELECT ON "STADW"."ST_CASHRECEIPT" TO "BICC";
GRANT UPDATE ON "STADW"."ST_CASHRECEIPT" TO "BICC";
GRANT READ ON "STADW"."ST_CASHRECEIPT" TO "BICC";
GRANT DEBUG ON "STADW"."ST_CASHRECEIPT" TO "BICC";
GRANT ASSERTION REFERENCES ON "STADW"."ST_CASHRECEIPT" TO "BICC";
CREATE UNIQUE INDEX "STADW"."SYS_C0024877" ON "STADW"."ST_CASHRECEIPT" ("CASHRECEIPTID")
;