Columns
Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
---|---|---|---|---|---|---|---|---|
GLOBALPRODUCT | varchar | 20 | √ | null |
|
|
||
GLOBALDOCUMENTFUNCTIONCODE | varchar | 40 | null |
|
|
|||
GLOBALDOCFUNCTIONDESCRIPTION | varchar | 60 | null |
|
|
|||
DOCVERSION | varchar | 10 | √ | null |
|
|
||
DOCDATETIME | datetime | 16,3 | (getdate()) |
|
|
|||
DOCIDENTIFIER | varchar | 40 | null |
|
|
|||
DOCCOMPANY | smallint | 2 | √ | null |
|
|
||
DOCBRANCH | smallint | 2 | √ | null |
|
|
||
DOCNAME | varchar | 60 | √ | null |
|
|
||
DOCFEDERALID | varchar | 20 | √ | null |
|
|
||
OPERATIONTYPE | varchar | 1 | null |
|
|
|||
QUEUETYPE | int | 4 | null |
|
|
|||
QUEUEDATASERVER | varchar | 40 | null |
|
|
|||
QUEUEREFS | varchar | 255 | √ | null |
|
|
||
QUEUESTATUS | int | 4 | (0) |
|
|
|||
QUEUEPROCESSDATETIME | datetime | 16,3 | √ | null |
|
|
||
QUEUEATTEMPT | int | 4 | (0) |
|
|
|||
QUEUEERROR | MEMO | 2147483647 | √ | null |
|
|
||
MESSAGE | MEMO | 2147483647 | null |
|
|
|||
DOCTYPE | int | 4 | √ | null |
|
|
||
BUSINESSMESSAGE | MEMO | 2147483647 | √ | null |
|
|
||
MSGRETORNO | MEMO | 2147483647 | √ | null |
|
|
||
DELIVERYTYPE | varchar | 5 | √ | null |
|
|
||
ORIGINALMESSAGE | MEMO | 2147483647 | √ | null |
|
|
||
DESTINYPRODUCT | varchar | 40 | √ | null |
|
|
||
RECCREATEDBY | varchar | 50 | √ | null |
|
|
||
RECCREATEDON | datetime | 16,3 | √ | null |
|
|
||
RECMODIFIEDBY | varchar | 50 | √ | null |
|
|
||
RECMODIFIEDON | datetime | 16,3 | √ | null |
|
|
Indexes
Constraint Name | Type | Sort | Column(s) |
---|---|---|---|
PKHCFILAINTEGRACAO | Primary key | Asc | DOCIDENTIFIER |
Diagram producer might be missing
No diagrams were produced please see application output for any errors