Columns
Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | ||
---|---|---|---|---|---|---|---|---|---|---|
CODCOLIGADA | DCODCOLIGADA | 2 | null |
|
|
|||||
IDCONTAANT | int | 4 | null |
|
|
|||||
IDCONTROLEPLANOCTA | int | 4 | null |
|
|
|||||
CODCONTAANT | DCODCONTA | 40 | null |
|
|
|||||
DESCRICAOCONTAANT | varchar | 40 | √ | null |
|
|
||||
CODCOLCONTAATUAL | DCODCOLIGADANULL | 2 | √ | null |
|
|
||||
CODCONTAATUAL | DCODCONTA | 40 | √ | null |
|
|
||||
CODCCUSTO | varchar | 25 | √ | null |
|
|
||||
CODCONTAGER | DCODCONTA | 40 | √ | null |
|
|
||||
ORIGEMREGISTRO | smallint | 2 | √ | null |
|
|
||||
VALORSALDOFINAL | RMDVALOR2 | 17,2 | √ | null |
|
|
||||
INDICADORSALDOFINAL | char | 1 | √ | null |
|
|
||||
RECCREATEDBY | varchar | 50 | √ | null |
|
|
||||
RECCREATEDON | datetime | 16,3 | √ | null |
|
|
||||
RECMODIFIEDBY | varchar | 50 | √ | null |
|
|
||||
RECMODIFIEDON | datetime | 16,3 | √ | null |
|
|
||||
CODFILIAL | smallint | 2 | √ | null |
|
|
||||
CODCCUSTOATUAL | varchar | 25 | √ | null |
|
|
||||
NOMECCUSTOANTERIOR | varchar | 60 | √ | null |
|
|
||||
CODCONTAGERATUAL | DCODCONTA | 40 | √ | null |
|
|
||||
CODCOLCONTAGERATUAL | DCODCOLIGADANULL | 2 | √ | null |
|
|
||||
DESCRICAOCONTAGERANTERIOR | varchar | 40 | √ | null |
|
|
Indexes
Constraint Name | Type | Sort | Column(s) |
---|---|---|---|
PKCCTAANTERIORSPED | Primary key | Asc/Asc | CODCOLIGADA + IDCONTAANT |