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