Diccionario de Datos
Diccionario de datos de los modelos de COÉXITO
| 🏠 Menú principal | ← Volver a tablas |
STADW.ST_ITEMREF
Base de datos origen: ADW COEXITO
Columnas
| # | Columna | Tipo | Nulo | Default | Comentario |
|---|---|---|---|---|---|
| 1 | ID | NUMBER | NO | “STADW”.”ISEQ$$_184220”.nextval | |
| 2 | IDMAESTROCARGUE | NUMBER(18,0) | NO | ||
| 3 | DISTRIBUTIONRULEPEOACCOUNTINGOBJECTVERSIONNUMBER | NUMBER(9,0) | NO | ||
| 4 | DISTRIBUTIONRULEPEOACCOUNTINGRULEID | NUMBER(18,0) | NO | ||
| 5 | DISTRIBUTIONRULEPEOINVOICINGOBJECTVERSIONNUMBER | NUMBER(9,0) | NO | ||
| 6 | DISTRIBUTIONRULEPEOINVOICINGRULEID | NUMBER(18,0) | NO | ||
| 7 | FORCEPURCHASELEADTIMEFLAG | VARCHAR2(1) | SI | ||
| 8 | INVENTORYRULEPEORULEID | NUMBER(18,0) | NO | ||
| 9 | ITEMBASEPEOALLOWEDUNITSLOOKUPCODE | NUMBER(8,0) | SI | ||
| 10 | ITEMBASEPEOAPPROVALSTATUS | VARCHAR2(30) | SI | ||
| 11 | ITEMBASEPEOASSETCLASS | VARCHAR2(30) | SI | ||
| 12 | ITEMBASEPEOASSETTRACKEDFLAG | VARCHAR2(1) | SI | ||
| 13 | ITEMBASEPEOATPCOMPONENTSFLAG | VARCHAR2(1) | SI | ||
| 14 | ITEMBASEPEOATPFLAG | VARCHAR2(1) | SI | ||
| 15 | ITEMBASEPEOBOMITEMTYPE | NUMBER(8,0) | SI | ||
| 16 | ITEMBASEPEOBULKPICKEDFLAG | VARCHAR2(1) | SI | ||
| 17 | ITEMBASEPEOCOSTINGENABLEDFLAG | VARCHAR2(1) | SI | ||
| 18 | ITEMBASEPEOCURRENTPHASECODE | VARCHAR2(120) | SI | ||
| 19 | ITEMBASEPEOCUSTOMERORDERENABLEDFLAG | VARCHAR2(1) | SI | ||
| 20 | ITEMBASEPEOCUSTOMERORDERFLAG | VARCHAR2(1) | SI | ||
| 21 | ITEMBASEPEOCYCLECOUNTENABLEDFLAG | VARCHAR2(1) | SI | ||
| 22 | ITEMBASEPEODEFAULTINCLUDEINROLLUPFLAG | VARCHAR2(1) | SI | ||
| 23 | ITEMBASEPEODIMENSIONUOMCODE | VARCHAR2(3) | SI | ||
| 24 | ITEMBASEPEODUALUOMCONTROL | NUMBER(8,0) | SI | ||
| 25 | ITEMBASEPEOEFFECTIVITYCONTROL | NUMBER(8,0) | SI | ||
| 26 | ITEMBASEPEOENABLEDFLAG | VARCHAR2(1) | SI | ||
| 27 | ITEMBASEPEOENDASSEMBLYPEGGINGFLAG | VARCHAR2(1) | SI | ||
| 28 | ITEMBASEPEOEQUIPMENTTYPE | NUMBER(8,0) | SI | ||
| 29 | ITEMBASEPEOEXCLUDEFROMBUDGETFLAG | NUMBER(8,0) | SI | ||
| 30 | ITEMBASEPEOFULLLEADTIME | NUMBER(8,0) | SI | ||
| 31 | ITEMBASEPEOGRADECONTROLFLAG | VARCHAR2(1) | SI | ||
| 32 | ITEMBASEPEOHAZARDOUSMATERIALFLAG | VARCHAR2(1) | SI | ||
| 33 | ITEMBASEPEOINDIVISIBLEFLAG | VARCHAR2(1) | SI | ||
| 34 | ITEMBASEPEOINTERNALORDERENABLEDFLAG | VARCHAR2(1) | SI | ||
| 35 | ITEMBASEPEOINTERNALORDERFLAG | VARCHAR2(1) | SI | ||
| 36 | ITEMBASEPEOINVENTORYASSETFLAG | VARCHAR2(1) | SI | ||
| 37 | ITEMBASEPEOINVENTORYITEMFLAG | VARCHAR2(1) | SI | ||
| 38 | ITEMBASEPEOINVENTORYITEMID | NUMBER(18,0) | NO | ||
| 39 | ITEMBASEPEOINVENTORYITEMSTATUSCODE | VARCHAR2(10) | SI | ||
| 40 | ITEMBASEPEOINVENTORYORGANIZATIONID | NUMBER(18,0) | SI | ||
| 41 | ITEMBASEPEOINVENTORYPLANNINGCODE | NUMBER(8,0) | SI | ||
| 42 | ITEMBASEPEOINVOICEENABLEDFLAG | VARCHAR2(1) | SI | ||
| 43 | ITEMBASEPEOINVOICEABLEITEMFLAG | VARCHAR2(1) | SI | ||
| 44 | ITEMBASEPEOITEMCATALOGGROUPID | NUMBER(18,0) | SI | ||
| 45 | ITEMBASEPEOITEMNUMBER | VARCHAR2(300) | SI | ||
| 46 | ITEMBASEPEOITEMTYPE | VARCHAR2(30) | SI | ||
| 47 | ITEMBASEPEOJOBDEFINITIONNAME | VARCHAR2(100) | SI | ||
| 48 | ITEMBASEPEOJOBDEFINITIONPACKAGE | VARCHAR2(900) | SI | ||
| 49 | ITEMBASEPEOLASTUPDATEDATE | DATE | NO | ||
| 50 | ITEMBASEPEOLISTPRICEPERUNIT | NUMBER(8,0) | SI | ||
| 51 | ITEMBASEPEOLOCATIONCONTROLCODE | NUMBER(8,0) | SI | ||
| 52 | ITEMBASEPEOLOTCONTROLCODE | NUMBER(8,0) | SI | ||
| 53 | ITEMBASEPEOLOTSTATUSENABLED | VARCHAR2(1) | SI | ||
| 54 | ITEMBASEPEOLOTTRANSLATEENABLED | VARCHAR2(1) | SI | ||
| 55 | ITEMBASEPEOMARKETPRICE | NUMBER(8,0) | SI | ||
| 56 | ITEMBASEPEOMATCHAPPROVALLEVEL | NUMBER(8,0) | SI | ||
| 57 | ITEMBASEPEOORGANIZATIONID | NUMBER(18,0) | NO | ||
| 58 | ITEMORGANIZATIONPARAMETERPEOLASTUPDATEDATE | DATE | NO | ||
| 59 | ITEMTRANSLATIONPEOLASTUPDATEDATE | DATE | NO | ||
| 60 | ORGANIZATIONUNITPEOLASTUPDATEDATE | DATE | NO | ||
| 61 | ORGANIZATIONUNITTLPEOLASTUPDATEDATE | DATE | NO |
Restricciones
CHECK: SYS_C0034312
- Estado: ENABLED
- Columnas: ID
- Condición:
"ID" IS NOT NULL
CHECK: SYS_C0034313
- Estado: ENABLED
- Columnas: IDMAESTROCARGUE
- Condición:
"IDMAESTROCARGUE" IS NOT NULL
CHECK: SYS_C0034314
- Estado: ENABLED
- Columnas: DISTRIBUTIONRULEPEOACCOUNTINGOBJECTVERSIONNUMBER
- Condición:
"DISTRIBUTIONRULEPEOACCOUNTINGOBJECTVERSIONNUMBER" IS NOT NULL
CHECK: SYS_C0034315
- Estado: ENABLED
- Columnas: DISTRIBUTIONRULEPEOACCOUNTINGRULEID
- Condición:
"DISTRIBUTIONRULEPEOACCOUNTINGRULEID" IS NOT NULL
CHECK: SYS_C0034316
- Estado: ENABLED
- Columnas: DISTRIBUTIONRULEPEOINVOICINGOBJECTVERSIONNUMBER
- Condición:
"DISTRIBUTIONRULEPEOINVOICINGOBJECTVERSIONNUMBER" IS NOT NULL
CHECK: SYS_C0034317
- Estado: ENABLED
- Columnas: DISTRIBUTIONRULEPEOINVOICINGRULEID
- Condición:
"DISTRIBUTIONRULEPEOINVOICINGRULEID" IS NOT NULL
CHECK: SYS_C0034318
- Estado: ENABLED
- Columnas: INVENTORYRULEPEORULEID
- Condición:
"INVENTORYRULEPEORULEID" IS NOT NULL
CHECK: SYS_C0034319
- Estado: ENABLED
- Columnas: ITEMBASEPEOINVENTORYITEMID
- Condición:
"ITEMBASEPEOINVENTORYITEMID" IS NOT NULL
CHECK: SYS_C0034320
- Estado: ENABLED
- Columnas: ITEMBASEPEOLASTUPDATEDATE
- Condición:
"ITEMBASEPEOLASTUPDATEDATE" IS NOT NULL
CHECK: SYS_C0034321
- Estado: ENABLED
- Columnas: ITEMBASEPEOORGANIZATIONID
- Condición:
"ITEMBASEPEOORGANIZATIONID" IS NOT NULL
CHECK: SYS_C0034322
- Estado: ENABLED
- Columnas: ITEMORGANIZATIONPARAMETERPEOLASTUPDATEDATE
- Condición:
"ITEMORGANIZATIONPARAMETERPEOLASTUPDATEDATE" IS NOT NULL
CHECK: SYS_C0034323
- Estado: ENABLED
- Columnas: ITEMTRANSLATIONPEOLASTUPDATEDATE
- Condición:
"ITEMTRANSLATIONPEOLASTUPDATEDATE" IS NOT NULL
CHECK: SYS_C0034324
- Estado: ENABLED
- Columnas: ORGANIZATIONUNITPEOLASTUPDATEDATE
- Condición:
"ORGANIZATIONUNITPEOLASTUPDATEDATE" IS NOT NULL
CHECK: SYS_C0034325
- Estado: ENABLED
- Columnas: ORGANIZATIONUNITTLPEOLASTUPDATEDATE
- Condición:
"ORGANIZATIONUNITTLPEOLASTUPDATEDATE" IS NOT NULL
PK: SYS_C0034326
- Estado: ENABLED
- Columnas: ID
DDL
-- Error obteniendo DDL completo: ORA-01745: invalid host/bind variable name