Diccionario de Datos
Diccionario de datos de los modelos de COÉXITO
| 🏠 Menú principal | ← Volver a tablas |
STADW.ST_FULFILLLINE_HIST
Base de datos origen: ADW COEXITO
Columnas
| # | Columna | Tipo | Nulo | Default | Comentario |
|---|---|---|---|---|---|
| 1 | IDMAESTROCARGUE | NUMBER(18,0) | NO | ||
| 2 | BILLTOCUSTOMERACCOUNTACCOUNTESTABLISHEDDATE | DATE | SI | ||
| 3 | BILLTOCUSTOMERACCOUNTLASTUPDATEDATE | DATE | NO | ||
| 4 | COVERAGEFLINEDETAILSFULFILLLINENUMBER | NUMBER(9,0) | NO | ||
| 5 | COVERAGEFLINEDETAILSSOURCEREVISIONNUMBER | NUMBER(18,0) | NO | ||
| 6 | COVEREDFLINEDETAILSFULFILLLINENUMBER | NUMBER(9,0) | NO | ||
| 7 | COVEREDFLINEDETAILSSOURCEREVISIONNUMBER | NUMBER(18,0) | NO | ||
| 8 | DOCUMENTREFERENCESDOCALTUSERKEY | VARCHAR2(150) | SI | ||
| 9 | DOCUMENTREFERENCESDOCCONTEXTID | VARCHAR2(50) | SI | ||
| 10 | DOCUMENTREFERENCESDOCLINEID | VARCHAR2(50) | SI | ||
| 11 | DOCUMENTREFERENCESDOCLINEUSERKEY | VARCHAR2(150) | SI | ||
| 12 | DOCUMENTREFERENCESDOCREFTYPE | VARCHAR2(30) | SI | ||
| 13 | DOCUMENTREFERENCESDOCSUBLINEID | VARCHAR2(50) | SI | ||
| 14 | DOCUMENTREFERENCESDOCSUBLINEUSERKEY | VARCHAR2(150) | SI | ||
| 15 | DOCUMENTREFERENCESDOCUSERKEY | VARCHAR2(150) | SI | ||
| 16 | FULFILLLINEACTUALCOMPLETIONDATE | DATE | SI | ||
| 17 | FULFILLLINEACTUALSHIPDATE | DATE | SI | ||
| 18 | FULFILLLINEASSETTRACKEDFLAG | VARCHAR2(1) | SI | ||
| 19 | FULFILLLINEBILLTOSITEUSEID | NUMBER(18,0) | SI | ||
| 20 | FULFILLLINECANCELREASONCODE | VARCHAR2(30) | SI | ||
| 21 | FULFILLLINECANCELEDFLAG | VARCHAR2(1) | SI | ||
| 22 | FULFILLLINECANCELEDQTY | NUMBER(8,0) | SI | ||
| 23 | FULFILLLINECATEGORYCODE | VARCHAR2(8) | SI | ||
| 24 | FULFILLLINECREATEDBY | VARCHAR2(9) | NO | ||
| 25 | FULFILLLINECREATIONDATE | DATE | NO | ||
| 26 | FULFILLLINECUSTOMERPONUMBER | VARCHAR2(8) | SI | ||
| 27 | FULFILLLINEESTIMATEFULFILLMENTCOST | NUMBER(8,0) | SI | ||
| 28 | FULFILLLINEFULFILLFLAG | VARCHAR2(18) | SI | ||
| 29 | FULFILLLINEFULFILLLINENUMBER | NUMBER(9,0) | NO | ||
| 30 | FULFILLLINEFULFILLORGID | NUMBER(18,0) | SI | ||
| 31 | FULFILLLINEFULFILLEDQTY | NUMBER(8,0) | SI | ||
| 32 | FULFILLLINEFULFILLMENTDATE | DATE | SI | ||
| 33 | FULFILLLINEFULFILLMENTSPLITREFID | NUMBER(18,0) | SI | ||
| 34 | FULFILLLINEHEADERID | NUMBER(18,0) | NO | ||
| 35 | FULFILLLINEID | NUMBER(18,0) | NO | ||
| 36 | FULFILLLINEINVENTORYINTERFACEDFLAG | VARCHAR2(8) | SI | ||
| 37 | FULFILLLINEINVENTORYITEMID | NUMBER(18,0) | NO | ||
| 38 | FULFILLLINEINVENTORYTRANSACTIONFLAG | VARCHAR2(18) | SI | ||
| 39 | FULFILLLINEITEMSUBTYPECODE | VARCHAR2(9) | SI | ||
| 40 | FULFILLLINEITEMTYPECODE | VARCHAR2(18) | SI | ||
| 41 | FULFILLLINELASTUPDATEDATE | DATE | NO | ||
| 42 | FULFILLLINELASTUPDATEDBY | VARCHAR2(18) | NO | ||
| 43 | FULFILLLINELINEID | NUMBER(18,0) | NO | ||
| 44 | FULFILLLINELINETYPECODE | VARCHAR2(8) | SI | ||
| 45 | FULFILLLINEONHOLD | VARCHAR2(8) | SI | ||
| 46 | FULFILLLINEOPENFLAG | VARCHAR2(18) | SI | ||
| 47 | FULFILLLINEORDEREDQTY | NUMBER(8,0) | NO | ||
| 48 | FULFILLLINEORDEREDUOM | VARCHAR2(18) | NO | ||
| 49 | FULFILLLINEPACKINGINSTRUCTIONS | VARCHAR2(18) | SI | ||
| 50 | FULFILLLINEPARENTFULFILLLINEIDPK | NUMBER(18,0) | NO | ||
| 51 | FULFILLLINEPARENTFULFILLLINENUMBER | NUMBER(9,0) | NO | ||
| 52 | FULFILLLINEPARTIALSHIPALLOWEDFLAG | VARCHAR2(18) | SI | ||
| 53 | FULFILLLINEPAYMENTTERMID | NUMBER(18,0) | SI | ||
| 54 | FULFILLLINEREQUESTARRIVALDATE | DATE | SI | ||
| 55 | FULFILLLINEREQUESTCANCELDATE | DATE | SI | ||
| 56 | FULFILLLINEREQUESTSHIPDATE | DATE | SI | ||
| 57 | FULFILLLINERESERVABLEFLAG | VARCHAR2(18) | SI | ||
| 58 | FULFILLLINERESERVEDQTY | NUMBER(8,0) | SI | ||
| 59 | FULFILLLINERETURNREASONCODE | VARCHAR2(8) | SI | ||
| 60 | FULFILLLINERMADELIVEREDQTY | NUMBER(8,0) | SI | ||
| 61 | FULFILLLINEROOTPARENTFULFILLLINEIDPK | NUMBER(18,0) | NO | ||
| 62 | FULFILLLINEROOTPARENTFULFILLLINENUMBER | NUMBER(9,0) | NO | ||
| 63 | FULFILLLINESCHEDULEARRIVALDATE | DATE | SI | ||
| 64 | FULFILLLINESCHEDULESHIPDATE | DATE | SI | ||
| 65 | FULFILLLINESHIPCLASSOFSERVICE | VARCHAR2(30) | SI | ||
| 66 | FULFILLLINESHIPMODEOFTRANSPORT | VARCHAR2(30) | SI | ||
| 67 | FULFILLLINESHIPTOPARTYCONTACTID | NUMBER(18,0) | SI | ||
| 68 | FULFILLLINESHIPTOPARTYID | NUMBER(18,0) | SI | ||
| 69 | FULFILLLINESHIPTOPARTYSITEID | NUMBER(18,0) | SI | ||
| 70 | FULFILLLINESHIPPABLEFLAG | VARCHAR2(8) | SI | ||
| 71 | FULFILLLINESHIPPEDQTY | NUMBER(8,0) | SI | ||
| 72 | FULFILLLINESHIPPINGINSTRUCTIONS | VARCHAR2(8) | SI | ||
| 73 | FULFILLLINESOURCELINEID | VARCHAR2(18) | SI | ||
| 74 | FULFILLLINESOURCELINENUMBER | VARCHAR2(18) | SI | ||
| 75 | FULFILLLINESOURCEORDERID | VARCHAR2(18) | SI | ||
| 76 | FULFILLLINESOURCEORDERNUMBER | VARCHAR2(18) | SI | ||
| 77 | FULFILLLINESTATUSCODE | VARCHAR2(18) | SI | ||
| 78 | FULFILLLINETAXCLASSIFICATIONCODE | VARCHAR2(18) | SI | ||
| 79 | FULFILLLINETAXEXEMPTFLAG | VARCHAR2(18) | SI | ||
| 80 | FULFILLLINEUNITLISTPRICE | NUMBER(8,0) | SI | ||
| 81 | FULFILLLINEUNITSELLINGPRICE | NUMBER(8,0) | SI | ||
| 82 | FULFILLLINEUNREFERENCEDRETURNFLAG | VARCHAR2(18) | SI | ||
| 83 | HEADERCANCELREASONCODE | VARCHAR2(18) | SI | ||
| 84 | HEADERCANCELEDFLAG | VARCHAR2(18) | SI | ||
| 85 | HEADERCHANGEVERSIONNUMBER | NUMBER(18,0) | SI | ||
| 86 | HEADERCREATEDBY | VARCHAR2(8) | NO | ||
| 87 | HEADERCREATIONDATE | DATE | NO | ||
| 88 | HEADERCUSTOMERPONUMBER | VARCHAR2(8) | SI | ||
| 89 | HEADERHEADERID | NUMBER(18,0) | NO | ||
| 90 | HEADERLASTUPDATEDATE | DATE | NO | ||
| 91 | HEADERLASTUPDATEDBY | VARCHAR2(64) | NO | ||
| 92 | HEADERLEGALENTITYID | NUMBER(18,0) | SI | ||
| 93 | HEADERONHOLD | VARCHAR2(18) | SI | ||
| 94 | HEADEROPENFLAG | VARCHAR2(18) | SI | ||
| 95 | HEADERORDERNUMBER | VARCHAR2(18) | NO | ||
| 96 | HEADERORDERTYPECODE | VARCHAR2(18) | SI | ||
| 97 | HEADERORDEREDDATE | DATE | SI | ||
| 98 | HEADERORGID | NUMBER(18,0) | NO | ||
| 99 | HEADERREQUESTSHIPDATE | DATE | SI | ||
| 100 | HEADERSALESPERSONID | NUMBER(18,0) | SI | ||
| 101 | HEADERSOLDTOPARTYCONTACTID | NUMBER(18,0) | SI | ||
| 102 | HEADERSOLDTOPARTYID | NUMBER(18,0) | SI | ||
| 103 | HEADERSOURCEDOCUMENTTYPECODE | VARCHAR2(8) | SI | ||
| 104 | HEADERSOURCEORDERSYSTEM | VARCHAR2(8) | SI | ||
| 105 | HEADERSOURCEORGID | NUMBER(18,0) | NO | ||
| 106 | HEADERSTATUSCODE | VARCHAR2(8) | SI | ||
| 107 | HEADERSUBMITTEDBY | VARCHAR2(64) | SI | ||
| 108 | HEADERSUBMITTEDDATE | DATE | SI | ||
| 109 | HEADERSUBMITTEDFLAG | VARCHAR2(1) | SI | ||
| 110 | HEADERTRANSACTIONALCURRENCYCODE | VARCHAR2(15) | SI | ||
| 111 | LINEACTUALSHIPDATE | DATE | SI | ||
| 112 | LINECANCELEDFLAG | VARCHAR2(1) | SI | ||
| 113 | LINECANCELEDQTY | NUMBER(8,0) | SI | ||
| 114 | LINECATEGORYCODE | VARCHAR2(18) | SI | ||
| 115 | LINECREATEDBY | VARCHAR2(18) | NO | ||
| 116 | LINECREATIONDATE | DATE | NO | ||
| 117 | LINEDISPLAYLINENUMBER | VARCHAR2(9) | SI | ||
| 118 | LINEFULFILLMENTDATE | DATE | SI | ||
| 119 | LINEHEADERID | NUMBER(18,0) | NO | ||
| 120 | LINEINVENTORYITEMID | NUMBER(18,0) | SI | ||
| 121 | LINEITEMTYPECODE | VARCHAR2(8) | SI | ||
| 122 | LINELASTUPDATEDATE | DATE | NO | ||
| 123 | LINELASTUPDATEDBY | VARCHAR2(64) | NO | ||
| 124 | LINELINEID | NUMBER(18,0) | NO | ||
| 125 | LINELINENUMBER | NUMBER(9,0) | NO | ||
| 126 | LINEONHOLD | VARCHAR2(8) | SI | ||
| 127 | LINEOPENFLAG | VARCHAR2(8) | SI | ||
| 128 | LINEORDEREDQTY | NUMBER(8,0) | SI | ||
| 129 | LINEORDEREDUOM | VARCHAR2(8) | SI | ||
| 130 | LINESCHEDULESHIPDATE | DATE | SI | ||
| 131 | LINESHIPPEDQTY | NUMBER(8,0) | SI | ||
| 132 | LINESOURCELINEID | VARCHAR2(8) | SI | ||
| 133 | LINESOURCELINENUMBER | VARCHAR2(8) | SI | ||
| 134 | LINESOURCEORDERID | VARCHAR2(50) | SI | ||
| 135 | LINESOURCEORDERNUMBER | VARCHAR2(50) | SI | ||
| 136 | LINESOURCESCHEDULENUMBER | VARCHAR2(50) | SI | ||
| 137 | LINESTATUSCODE | VARCHAR2(30) | SI | ||
| 138 | LINEUNITLISTPRICE | NUMBER(8,0) | SI | ||
| 139 | LINEUNITSELLINGPRICE | NUMBER(8,0) | SI |
Restricciones
CHECK: SYS_C0041055
- Estado: ENABLED
- Columnas: IDMAESTROCARGUE
- Condición:
"IDMAESTROCARGUE" IS NOT NULL
CHECK: SYS_C0041056
- Estado: ENABLED
- Columnas: BILLTOCUSTOMERACCOUNTLASTUPDATEDATE
- Condición:
"BILLTOCUSTOMERACCOUNTLASTUPDATEDATE" IS NOT NULL
CHECK: SYS_C0041057
- Estado: ENABLED
- Columnas: COVERAGEFLINEDETAILSFULFILLLINENUMBER
- Condición:
"COVERAGEFLINEDETAILSFULFILLLINENUMBER" IS NOT NULL
CHECK: SYS_C0041058
- Estado: ENABLED
- Columnas: COVERAGEFLINEDETAILSSOURCEREVISIONNUMBER
- Condición:
"COVERAGEFLINEDETAILSSOURCEREVISIONNUMBER" IS NOT NULL
CHECK: SYS_C0041059
- Estado: ENABLED
- Columnas: COVEREDFLINEDETAILSFULFILLLINENUMBER
- Condición:
"COVEREDFLINEDETAILSFULFILLLINENUMBER" IS NOT NULL
CHECK: SYS_C0041060
- Estado: ENABLED
- Columnas: COVEREDFLINEDETAILSSOURCEREVISIONNUMBER
- Condición:
"COVEREDFLINEDETAILSSOURCEREVISIONNUMBER" IS NOT NULL
CHECK: SYS_C0041061
- Estado: ENABLED
- Columnas: FULFILLLINECREATEDBY
- Condición:
"FULFILLLINECREATEDBY" IS NOT NULL
CHECK: SYS_C0041062
- Estado: ENABLED
- Columnas: FULFILLLINECREATIONDATE
- Condición:
"FULFILLLINECREATIONDATE" IS NOT NULL
CHECK: SYS_C0041063
- Estado: ENABLED
- Columnas: FULFILLLINEFULFILLLINENUMBER
- Condición:
"FULFILLLINEFULFILLLINENUMBER" IS NOT NULL
CHECK: SYS_C0041064
- Estado: ENABLED
- Columnas: FULFILLLINEHEADERID
- Condición:
"FULFILLLINEHEADERID" IS NOT NULL
CHECK: SYS_C0041065
- Estado: ENABLED
- Columnas: FULFILLLINEID
- Condición:
"FULFILLLINEID" IS NOT NULL
CHECK: SYS_C0041066
- Estado: ENABLED
- Columnas: FULFILLLINEINVENTORYITEMID
- Condición:
"FULFILLLINEINVENTORYITEMID" IS NOT NULL
CHECK: SYS_C0041067
- Estado: ENABLED
- Columnas: FULFILLLINELASTUPDATEDATE
- Condición:
"FULFILLLINELASTUPDATEDATE" IS NOT NULL
CHECK: SYS_C0041068
- Estado: ENABLED
- Columnas: FULFILLLINELASTUPDATEDBY
- Condición:
"FULFILLLINELASTUPDATEDBY" IS NOT NULL
CHECK: SYS_C0041069
- Estado: ENABLED
- Columnas: FULFILLLINELINEID
- Condición:
"FULFILLLINELINEID" IS NOT NULL
CHECK: SYS_C0041070
- Estado: ENABLED
- Columnas: FULFILLLINEORDEREDQTY
- Condición:
"FULFILLLINEORDEREDQTY" IS NOT NULL
CHECK: SYS_C0041071
- Estado: ENABLED
- Columnas: FULFILLLINEORDEREDUOM
- Condición:
"FULFILLLINEORDEREDUOM" IS NOT NULL
CHECK: SYS_C0041072
- Estado: ENABLED
- Columnas: FULFILLLINEPARENTFULFILLLINEIDPK
- Condición:
"FULFILLLINEPARENTFULFILLLINEIDPK" IS NOT NULL
CHECK: SYS_C0041073
- Estado: ENABLED
- Columnas: FULFILLLINEPARENTFULFILLLINENUMBER
- Condición:
"FULFILLLINEPARENTFULFILLLINENUMBER" IS NOT NULL
CHECK: SYS_C0041074
- Estado: ENABLED
- Columnas: FULFILLLINEROOTPARENTFULFILLLINEIDPK
- Condición:
"FULFILLLINEROOTPARENTFULFILLLINEIDPK" IS NOT NULL
CHECK: SYS_C0041075
- Estado: ENABLED
- Columnas: FULFILLLINEROOTPARENTFULFILLLINENUMBER
- Condición:
"FULFILLLINEROOTPARENTFULFILLLINENUMBER" IS NOT NULL
CHECK: SYS_C0041076
- Estado: ENABLED
- Columnas: HEADERCREATEDBY
- Condición:
"HEADERCREATEDBY" IS NOT NULL
CHECK: SYS_C0041077
- Estado: ENABLED
- Columnas: HEADERCREATIONDATE
- Condición:
"HEADERCREATIONDATE" IS NOT NULL
CHECK: SYS_C0041078
- Estado: ENABLED
- Columnas: HEADERHEADERID
- Condición:
"HEADERHEADERID" IS NOT NULL
CHECK: SYS_C0041079
- Estado: ENABLED
- Columnas: HEADERLASTUPDATEDATE
- Condición:
"HEADERLASTUPDATEDATE" IS NOT NULL
CHECK: SYS_C0041080
- Estado: ENABLED
- Columnas: HEADERLASTUPDATEDBY
- Condición:
"HEADERLASTUPDATEDBY" IS NOT NULL
CHECK: SYS_C0041081
- Estado: ENABLED
- Columnas: HEADERORDERNUMBER
- Condición:
"HEADERORDERNUMBER" IS NOT NULL
CHECK: SYS_C0041082
- Estado: ENABLED
- Columnas: HEADERORGID
- Condición:
"HEADERORGID" IS NOT NULL
CHECK: SYS_C0041083
- Estado: ENABLED
- Columnas: HEADERSOURCEORGID
- Condición:
"HEADERSOURCEORGID" IS NOT NULL
CHECK: SYS_C0041084
- Estado: ENABLED
- Columnas: LINECREATEDBY
- Condición:
"LINECREATEDBY" IS NOT NULL
CHECK: SYS_C0041085
- Estado: ENABLED
- Columnas: LINECREATIONDATE
- Condición:
"LINECREATIONDATE" IS NOT NULL
CHECK: SYS_C0041086
- Estado: ENABLED
- Columnas: LINEHEADERID
- Condición:
"LINEHEADERID" IS NOT NULL
CHECK: SYS_C0041087
- Estado: ENABLED
- Columnas: LINELASTUPDATEDATE
- Condición:
"LINELASTUPDATEDATE" IS NOT NULL
CHECK: SYS_C0041088
- Estado: ENABLED
- Columnas: LINELASTUPDATEDBY
- Condición:
"LINELASTUPDATEDBY" IS NOT NULL
CHECK: SYS_C0041089
- Estado: ENABLED
- Columnas: LINELINEID
- Condición:
"LINELINEID" IS NOT NULL
CHECK: SYS_C0041090
- Estado: ENABLED
- Columnas: LINELINENUMBER
- Condición:
"LINELINENUMBER" IS NOT NULL
DDL
-- Error obteniendo DDL completo: ORA-01745: invalid host/bind variable name