Diccionario de Datos
Diccionario de datos de los modelos de COÉXITO
| 🏠 Menú principal | ← Volver a tablas |
STADW.ST_RECEIPTACCOUNTING_GL_TMP_13912
Base de datos origen: ADW COEXITO
Columnas
| # | Columna | Tipo | Nulo | Default | Comentario |
|---|---|---|---|---|---|
| 1 | ACCTLINETYPELOOKUPPEOMEANING | VARCHAR2(200) | SI | ||
| 2 | CMRRCVEVENTCOSTSPEODESTINATIONTYPECODE | VARCHAR2(50) | SI | ||
| 3 | CMRRCVEVENTCOSTSPEOEVENTUNITCOST | NUMBER | SI | ||
| 4 | CMRRCVTRANSACTIONRPTPEORECEIPTNUMBER | VARCHAR2(100) | SI | ||
| 5 | CMRRCVTRANSACTIONRPTPEOTRANSACTIONDATE | DATE | SI | ||
| 6 | CMRSUBLEDGERID | NUMBER | SI | ||
| 7 | EFFECTIVESTARTDATE | DATE | SI | ||
| 8 | EVENTTYPETRANSLATIONPEOEVENTCLASSCODE | VARCHAR2(50) | SI | ||
| 9 | EVENTTYPETRANSLATIONPEOEVENTTYPECODE | VARCHAR2(50) | SI | ||
| 10 | EVENTTYPETRANSLATIONPEONAME | VARCHAR2(200) | SI | ||
| 11 | PERSONNAMEPEODISPLAYNAME | VARCHAR2(200) | SI | ||
| 12 | PERSONNAMEPEOFULLNAME | VARCHAR2(200) | SI | ||
| 13 | PURCHASEORDERDISTRIBUTIONDISTRIBUTIONNUM | VARCHAR2(200) | SI | ||
| 14 | PURCHASEORDERDISTRIBUTIONREQDISTRIBUTIONID | NUMBER | SI | ||
| 15 | PURCHASEORDERDTLSPEOPONUMBER | VARCHAR2(50) | SI | ||
| 16 | PURCHASEORDERDTLSPEOVENDORID | NUMBER | SI | ||
| 17 | PURCHASINGDOCUMENTHEADERCOMMENTS | VARCHAR2(500) | SI | ||
| 18 | PURCHASINGDOCUMENTHEADERCURRENCYCODE | VARCHAR2(50) | SI | ||
| 19 | PURCHASINGDOCUMENTHEADERSEGMENT1 | VARCHAR2(50) | SI | ||
| 20 | PURCHASINGDOCUMENTLINELINENUM | NUMBER | SI | ||
| 21 | PURCHASINGDOCUMENTLINELINESTATUS | VARCHAR2(50) | SI | ||
| 22 | RCVEVENTTYPESPEOTRANSACTIONTYPE | VARCHAR2(50) | SI | ||
| 23 | RECEIVINGACCOUNTINGEVENTSEOACCOUNTEDFLAG | VARCHAR2(50) | SI | ||
| 24 | RECEIVINGACCOUNTINGEVENTSEOACCOUNTINGEVENTID | NUMBER | SI | ||
| 25 | RECEIVINGACCOUNTINGEVENTSEOCREATEDBY | VARCHAR2(100) | SI | ||
| 26 | RECEIVINGACCOUNTINGEVENTSEOCREATIONDATE | DATE | SI | ||
| 27 | RECEIVINGACCOUNTINGEVENTSEOEVENTCLASSCODE | VARCHAR2(50) | SI | ||
| 28 | RECEIVINGACCOUNTINGEVENTSEOEVENTID | NUMBER | SI | ||
| 29 | RECEIVINGACCOUNTINGEVENTSEOGLDATE | DATE | SI | ||
| 30 | RECEIVINGACCOUNTINGEVENTSEOLEDGERID | NUMBER | SI | ||
| 31 | RECEIVINGACCOUNTINGEVENTSEOLEGALENTITYID | NUMBER | SI | ||
| 32 | RECEIVINGACCOUNTINGEVENTSEOSLATRANSACTIONNUMBER | VARCHAR2(100) | SI | ||
| 33 | RECEIVINGACCOUNTINGEVENTSEOSOURCEDOCNUMBER | VARCHAR2(100) | SI | ||
| 34 | RECEIVINGACCOUNTINGEVENTSEOTRANSACTIONAMT | NUMBER | SI | ||
| 35 | RECEIVINGACCOUNTINGEVENTSEOTRANSACTIONDATE | DATE | SI | ||
| 36 | RECEIVINGACCOUNTINGEVENTSPEOENCUMBRANCEACCOUNTINGFLAG | VARCHAR2(5) | SI | ||
| 37 | RECEIVINGACCOUNTINGEVENTSPEOFUNDRESERVATIONSTATUS | VARCHAR2(50) | SI | ||
| 38 | RECEIVINGDISTRIBUTIONSEOACCOUNTINGEVENTID | NUMBER | SI | ||
| 39 | RECEIVINGDISTRIBUTIONSEOACCOUNTINGLINETYPE | VARCHAR2(50) | SI | ||
| 40 | RECEIVINGDISTRIBUTIONSEOCODECOMBINATIONID | NUMBER | SI | ||
| 41 | RECEIVINGDISTRIBUTIONSEOCREATEDBY | VARCHAR2(50) | SI | ||
| 42 | RECEIVINGDISTRIBUTIONSEOCREATIONDATE | DATE | SI | ||
| 43 | RECEIVINGDISTRIBUTIONSEOENTEREDCURRENCYAMOUNT | NUMBER | SI | ||
| 44 | RECEIVINGDISTRIBUTIONSEOENTEREDCURRENCYCODE | VARCHAR2(50) | SI | ||
| 45 | RECEIVINGDISTRIBUTIONSEOLEDGERCURRENCYCODE | VARCHAR2(50) | SI | ||
| 46 | REQUISITIONHEADERPEOREQUISITIONNUMBER | VARCHAR2(100) | SI | ||
| 47 | SUPERVISORNAMEPEOEFFECTIVESTARTDATE | DATE | SI | ||
| 48 | SUPERVISORNAMEPEOFULLNAME | VARCHAR2(2000) | SI | ||
| 49 | IDMAESTROCARGUE | NUMBER(18,0) | NO | ||
| 50 | RECEIVINGACCOUNTINGEVENTSEOLASTUPDATEDATE | DATE | SI |
Restricciones
CHECK: SYS_C00230813
- Estado: ENABLED
- Columnas: IDMAESTROCARGUE
- Condición:
"IDMAESTROCARGUE" IS NOT NULL
DDL
CREATE TABLE "STADW"."ST_RECEIPTACCOUNTING_GL_TMP_13912"
( "ACCTLINETYPELOOKUPPEOMEANING" VARCHAR2(200) COLLATE "USING_NLS_COMP",
"CMRRCVEVENTCOSTSPEODESTINATIONTYPECODE" VARCHAR2(50) COLLATE "USING_NLS_COMP",
"CMRRCVEVENTCOSTSPEOEVENTUNITCOST" NUMBER,
"CMRRCVTRANSACTIONRPTPEORECEIPTNUMBER" VARCHAR2(100) COLLATE "USING_NLS_COMP",
"CMRRCVTRANSACTIONRPTPEOTRANSACTIONDATE" DATE,
"CMRSUBLEDGERID" NUMBER,
"EFFECTIVESTARTDATE" DATE,
"EVENTTYPETRANSLATIONPEOEVENTCLASSCODE" VARCHAR2(50) COLLATE "USING_NLS_COMP",
"EVENTTYPETRANSLATIONPEOEVENTTYPECODE" VARCHAR2(50) COLLATE "USING_NLS_COMP",
"EVENTTYPETRANSLATIONPEONAME" VARCHAR2(200) COLLATE "USING_NLS_COMP",
"PERSONNAMEPEODISPLAYNAME" VARCHAR2(200) COLLATE "USING_NLS_COMP",
"PERSONNAMEPEOFULLNAME" VARCHAR2(200) COLLATE "USING_NLS_COMP",
"PURCHASEORDERDISTRIBUTIONDISTRIBUTIONNUM" VARCHAR2(200) COLLATE "USING_NLS_COMP",
"PURCHASEORDERDISTRIBUTIONREQDISTRIBUTIONID" NUMBER,
"PURCHASEORDERDTLSPEOPONUMBER" VARCHAR2(50) COLLATE "USING_NLS_COMP",
"PURCHASEORDERDTLSPEOVENDORID" NUMBER,
"PURCHASINGDOCUMENTHEADERCOMMENTS" VARCHAR2(500) COLLATE "USING_NLS_COMP",
"PURCHASINGDOCUMENTHEADERCURRENCYCODE" VARCHAR2(50) COLLATE "USING_NLS_COMP",
"PURCHASINGDOCUMENTHEADERSEGMENT1" VARCHAR2(50) COLLATE "USING_NLS_COMP",
"PURCHASINGDOCUMENTLINELINENUM" NUMBER,
"PURCHASINGDOCUMENTLINELINESTATUS" VARCHAR2(50) COLLATE "USING_NLS_COMP",
"RCVEVENTTYPESPEOTRANSACTIONTYPE" VARCHAR2(50) COLLATE "USING_NLS_COMP",
"RECEIVINGACCOUNTINGEVENTSEOACCOUNTEDFLAG" VARCHAR2(50) COLLATE "USING_NLS_COMP",
"RECEIVINGACCOUNTINGEVENTSEOACCOUNTINGEVENTID" NUMBER,
"RECEIVINGACCOUNTINGEVENTSEOCREATEDBY" VARCHAR2(100) COLLATE "USING_NLS_COMP",
"RECEIVINGACCOUNTINGEVENTSEOCREATIONDATE" DATE,
"RECEIVINGACCOUNTINGEVENTSEOEVENTCLASSCODE" VARCHAR2(50) COLLATE "USING_NLS_COMP",
"RECEIVINGACCOUNTINGEVENTSEOEVENTID" NUMBER,
"RECEIVINGACCOUNTINGEVENTSEOGLDATE" DATE,
"RECEIVINGACCOUNTINGEVENTSEOLEDGERID" NUMBER,
"RECEIVINGACCOUNTINGEVENTSEOLEGALENTITYID" NUMBER,
"RECEIVINGACCOUNTINGEVENTSEOSLATRANSACTIONNUMBER" VARCHAR2(100) COLLATE "USING_NLS_COMP",
"RECEIVINGACCOUNTINGEVENTSEOSOURCEDOCNUMBER" VARCHAR2(100) COLLATE "USING_NLS_COMP",
"RECEIVINGACCOUNTINGEVENTSEOTRANSACTIONAMT" NUMBER,
"RECEIVINGACCOUNTINGEVENTSEOTRANSACTIONDATE" DATE,
"RECEIVINGACCOUNTINGEVENTSPEOENCUMBRANCEACCOUNTINGFLAG" VARCHAR2(5) COLLATE "USING_NLS_COMP",
"RECEIVINGACCOUNTINGEVENTSPEOFUNDRESERVATIONSTATUS" VARCHAR2(50) COLLATE "USING_NLS_COMP",
"RECEIVINGDISTRIBUTIONSEOACCOUNTINGEVENTID" NUMBER,
"RECEIVINGDISTRIBUTIONSEOACCOUNTINGLINETYPE" VARCHAR2(50) COLLATE "USING_NLS_COMP",
"RECEIVINGDISTRIBUTIONSEOCODECOMBINATIONID" NUMBER,
"RECEIVINGDISTRIBUTIONSEOCREATEDBY" VARCHAR2(50) COLLATE "USING_NLS_COMP",
"RECEIVINGDISTRIBUTIONSEOCREATIONDATE" DATE,
"RECEIVINGDISTRIBUTIONSEOENTEREDCURRENCYAMOUNT" NUMBER,
"RECEIVINGDISTRIBUTIONSEOENTEREDCURRENCYCODE" VARCHAR2(50) COLLATE "USING_NLS_COMP",
"RECEIVINGDISTRIBUTIONSEOLEDGERCURRENCYCODE" VARCHAR2(50) COLLATE "USING_NLS_COMP",
"REQUISITIONHEADERPEOREQUISITIONNUMBER" VARCHAR2(100) COLLATE "USING_NLS_COMP",
"SUPERVISORNAMEPEOEFFECTIVESTARTDATE" DATE,
"SUPERVISORNAMEPEOFULLNAME" VARCHAR2(2000) COLLATE "USING_NLS_COMP",
"IDMAESTROCARGUE" NUMBER(18,0) NOT NULL ENABLE,
"RECEIVINGACCOUNTINGEVENTSEOLASTUPDATEDATE" DATE
) DEFAULT COLLATION "USING_NLS_COMP" ;