[General]
ID=Import Definition
Version=1
Header=True
SkipEmptyLines=True
SingleLineRecord=False
QuoteChar="
CommentLine=
ImportLinesStart=1
ImportLinesEnd=10000
TableOwner=ARIUS
OracleTable=CTB_T_TMP_IMPORTA_IMOB
InitializingScript=
FinalizingScript=
OverwriteDuplicates=True
CommitCount=0
Filter=
EmptyTable=False

[ODBC]
DSN=
UserName=
Command=
Kind=0

[Fields]
Field=0
FieldStart=0
FieldStartValue=0
FieldEnd=2
FieldEndValue=|
OracleSQL=
OracleField=ID_CATEGORIA (NUMBER)
OracleType=1
ODBCField=
ODBCFieldNo=0
ODBCType=0
ODBCCType=0
ODBCLength=0
OracleParamNo=0

Field=1
FieldStart=0
FieldStartValue=|
FieldEnd=2
FieldEndValue=|
OracleSQL=
OracleField=ID_EMPRESA (NUMBER)
OracleType=1
ODBCField=
ODBCFieldNo=0
ODBCType=0
ODBCCType=0
ODBCLength=0
OracleParamNo=0

Field=2
FieldStart=0
FieldStartValue=|
FieldEnd=2
FieldEndValue=|
OracleSQL=
OracleField=NUM_PATRIMONIO (VARCHAR2)
OracleType=0
ODBCField=
ODBCFieldNo=0
ODBCType=0
ODBCCType=0
ODBCLength=0
OracleParamNo=0

Field=3
FieldStart=0
FieldStartValue=|
FieldEnd=2
FieldEndValue=|
OracleSQL=
OracleField=INCORPORACAO (NUMBER)
OracleType=1
ODBCField=
ODBCFieldNo=0
ODBCType=0
ODBCCType=0
ODBCLength=0
OracleParamNo=0

Field=4
FieldStart=0
FieldStartValue=|
FieldEnd=2
FieldEndValue=|
OracleSQL=substr(#,1,60)
OracleField=DESC_PATRIMONIO (VARCHAR2)
OracleType=0
ODBCField=
ODBCFieldNo=0
ODBCType=0
ODBCCType=0
ODBCLength=0
OracleParamNo=0

Field=5
FieldStart=0
FieldStartValue=|
FieldEnd=2
FieldEndValue=|
OracleSQL=to_date('#','DD/MM/RRRR')
OracleField=DATA_AQUISICAO (DATE)
OracleType=2
ODBCField=
ODBCFieldNo=0
ODBCType=0
ODBCCType=0
ODBCLength=0
OracleParamNo=0

Field=6
FieldStart=0
FieldStartValue=|
FieldEnd=2
FieldEndValue=|
OracleSQL=
OracleField=VALOR_AQUISICAO (NUMBER)
OracleType=1
ODBCField=
ODBCFieldNo=0
ODBCType=0
ODBCCType=0
ODBCLength=0
OracleParamNo=0

Field=7
FieldStart=0
FieldStartValue=|
FieldEnd=2
FieldEndValue=|
OracleSQL=
OracleField=VALOR_ICMS (NUMBER)
OracleType=1
ODBCField=
ODBCFieldNo=0
ODBCType=0
ODBCCType=0
ODBCLength=0
OracleParamNo=0

Field=8
FieldStart=0
FieldStartValue=|
FieldEnd=2
FieldEndValue=|
OracleSQL=
OracleField=VALOR_IPI (NUMBER)
OracleType=1
ODBCField=
ODBCFieldNo=0
ODBCType=0
ODBCCType=0
ODBCLength=0
OracleParamNo=0

Field=9
FieldStart=0
FieldStartValue=|
FieldEnd=2
FieldEndValue=|
OracleSQL=
OracleField=VALOR_DEPRECIADO (NUMBER)
OracleType=1
ODBCField=
ODBCFieldNo=0
ODBCType=0
ODBCCType=0
ODBCLength=0
OracleParamNo=0

Field=10
FieldStart=0
FieldStartValue=|
FieldEnd=2
FieldEndValue=|
OracleSQL=
OracleField=VALOR_COMPENSADO_ICMS (NUMBER)
OracleType=1
ODBCField=
ODBCFieldNo=0
ODBCType=0
ODBCCType=0
ODBCLength=0
OracleParamNo=0

Field=11
FieldStart=0
FieldStartValue=|
FieldEnd=2
FieldEndValue=|
OracleSQL=
OracleField=VALOR_COMPENSADO_PIS (NUMBER)
OracleType=1
ODBCField=
ODBCFieldNo=0
ODBCType=0
ODBCCType=0
ODBCLength=0
OracleParamNo=0

Field=12
FieldStart=0
FieldStartValue=|
FieldEnd=2
FieldEndValue=|
OracleSQL=
OracleField=VALOR_COMPENSADO_COFINS (NUMBER)
OracleType=1
ODBCField=
ODBCFieldNo=0
ODBCType=0
ODBCCType=0
ODBCLength=0
OracleParamNo=0

Field=13
FieldStart=0
FieldStartValue=|
FieldEnd=2
FieldEndValue=|
OracleSQL=
OracleField=NUM_LRE (NUMBER)
OracleType=1
ODBCField=
ODBCFieldNo=0
ODBCType=0
ODBCCType=0
ODBCLength=0
OracleParamNo=0

Field=14
FieldStart=0
FieldStartValue=|
FieldEnd=2
FieldEndValue=|
OracleSQL=
OracleField=FOLHA_LRE (NUMBER)
OracleType=1
ODBCField=
ODBCFieldNo=0
ODBCType=0
ODBCCType=0
ODBCLength=0
OracleParamNo=0

Field=15
FieldStart=0
FieldStartValue=|
FieldEnd=2
FieldEndValue=|
OracleSQL=
OracleField=COD_CENTRO_CUSTO (NUMBER)
OracleType=1
ODBCField=
ODBCFieldNo=0
ODBCType=0
ODBCCType=0
ODBCLength=0
OracleParamNo=0

Field=16
FieldStart=0
FieldStartValue=|
FieldEnd=2
FieldEndValue=|
OracleSQL=
OracleField=NUM_DOC (VARCHAR2)
OracleType=0
ODBCField=
ODBCFieldNo=0
ODBCType=0
ODBCCType=0
ODBCLength=0
OracleParamNo=0

Field=17
FieldStart=0
FieldStartValue=|
FieldEnd=2
FieldEndValue=|
OracleSQL=
OracleField=COD_PART (VARCHAR2)
OracleType=0
ODBCField=
ODBCFieldNo=0
ODBCType=0
ODBCCType=0
ODBCLength=0
OracleParamNo=0

Field=18
FieldStart=0
FieldStartValue=|
FieldEnd=2
FieldEndValue=|
OracleSQL=
OracleField=
OracleType=0
ODBCField=
ODBCFieldNo=0
ODBCType=0
ODBCCType=0
ODBCLength=0
OracleParamNo=0

Field=19
FieldStart=0
FieldStartValue=|
FieldEnd=2
FieldEndValue=|
OracleSQL=
OracleField=COD_ITEM (VARCHAR2)
OracleType=0
ODBCField=
ODBCFieldNo=0
ODBCType=0
ODBCCType=0
ODBCLength=0
OracleParamNo=0

Field=20
FieldStart=0
FieldStartValue=|
FieldEnd=2
FieldEndValue=|
OracleSQL=
OracleField=COD_MOD (VARCHAR2)
OracleType=0
ODBCField=
ODBCFieldNo=0
ODBCType=0
ODBCCType=0
ODBCLength=0
OracleParamNo=0

Field=21
FieldStart=0
FieldStartValue=|
FieldEnd=2
FieldEndValue=|
OracleSQL=
OracleField=SERIE (VARCHAR2)
OracleType=0
ODBCField=
ODBCFieldNo=0
ODBCType=0
ODBCCType=0
ODBCLength=0
OracleParamNo=0

Field=22
FieldStart=0
FieldStartValue=|
FieldEnd=2
FieldEndValue=|
OracleSQL=
OracleField=CHV_NFE (VARCHAR2)
OracleType=0
ODBCField=
ODBCFieldNo=0
ODBCType=0
ODBCCType=0
ODBCLength=0
OracleParamNo=0

