Cargue Nomina Localizada Colombia

download Cargue Nomina Localizada Colombia

of 50

  • date post

    26-Feb-2018
  • Category

    Documents

  • view

    215
  • download

    0

Embed Size (px)

Transcript of Cargue Nomina Localizada Colombia

  • 7/25/2019 Cargue Nomina Localizada Colombia

    1/50

    "#$%&' (' )*+,$-#").* (' *.-)*#",/,-0)#*#

    "1234541267 )24548967

    !"# %&'"# %( )(#*+'&%"# %( ,-./,& 0)"1(%(,'(# %( #/#'(. (2'(),"# 3 4*(1"))(#0",%(, & 0()5"%"# %( ,-./,& 3& (6(1*'&%"#7 %(8(, ')&,#9()/)#( & :;< 1"." #(/,%/1& & 1",'/,*&1/-,=

    ! >)(&) &)1?/@"# 0+&,"# 4*( 1",'(,A&, +"# %&'"# )(4*()/%"# 0") :;< /,%/1&%"# &+" +&)A" %( (#'( %"1*.(,'"B !"# &)1?/@"# 0+&,"# %(8(, '(,() +& (#')*1'*)&/,%/1&%& +& 1*&+ (# (2&1'&.(,'( /A*&+ & + '&8+ /,'().(%/ %/#(C&% 0&)&'&+ 9/,B

    ! >&%& +5,(& %(+ &)1?/@" 0+&," )(0)(#(,'& (+ )(A/#')" %( *, (.0+(&%" 3 *,1",1(0'" (, *, 0()5"%" %('()./,&%"B

    ! D+ @&+") %( +"# 1&.0"# %(8( 1".0+('&)#( 1", 1()"# E0&)& 1&.0"# ,*.F)/1"#G" 8+&,1"# E0&)& 1&.0"# '/0" 1&)H1'()G (, (+ 1" (, 4*( +& +",A/'*% %(+ @&+")#(& .(,") & +& (#'&8+(1/%& E," %(8(, %(6&)#( (#0&1/"# (, 8+&,1" (,')(1&.0"#GB

    ! I"%"# +"# 1&.0"# )(9()(,'(# & 9(1? %(8(, '(,() (+ 9").&'" ;;;;JJKKB

    ! !"# 1&.0"# ,*.F)/1"# %(8(, ++(@&) &+ 9/,&+ (+ #/A,"B :/ #", 0"#/'/@"# #( %(6&*, (#0&1/" (, 8+&,1" 3 #/ #", ,(A&'/@"# #( 1"+"1& (+ #/A," .(,"# ELGB

  • 7/25/2019 Cargue Nomina Localizada Colombia

    2/50

    + % % + + " % 8 % 5 S +

    ",*:'*)(,

    1. DIAGRAMA DE CARGUE DE ACUMULADOS ................................................... 32. CARGUE DE ACUMULADOS................................................................................. 42.1 Requerimientos de Importacin .............................................................................. 42.2 Estructura del Archivo ............................................................................................ 43. CARGUE DE CESANTAS ....................................................................................... 93.1 Requerimientos de Importacin .............................................................................. 9

    3.2 Estructura del Archivo - Tabla de cluster: COSEV ................................................ 94. CARGUE DE VACACIONES ................................................................................. 124.1 Requerimientos de Importacin ............................................................................ 124.2 Estructura del Archivo PlanoTabla de Cluster: COAVA ................................. 185. CARGUE DE ABSENTISMOS ............................................................................... 225.1 Requerimientos de Importacin ............................................................................ 225.2 Estructura del Archivo PlanoTabla de Cluster: COABS .................................. 236. CARGUE DE APORTES VOLUNTARIOS Y BENEFICIO TRIBUTARIO......... 27

    6.1 Requerimientos de Importacin ............................................................................ 276.2 Estructura del Archivo PlanoTabla de Cluster: COBTR .................................. 276.3 Conceptos a Importar en la tabla RT .................................................................... 327. CARGUE DE SEGURIDAD SOCIAL Y APORTES PARAFISCALES ............... 347.1 Estructura del Archivo PlanoTabla de Cluster COSSO .................................... 347.2 Conceptos a Importar en la tabla RT .................................................................... 398. CARGUE DE EMBARGOS..................................................................................... 438.1 Estructura del Archivo PlanoTabla de Cluster COGAR................................... 439. CARGUE DE PROVISIONES ................................................................................. 469.1 Requerimientos de importacin ............................................................................ 469.2 Estructura del Archivo PlanoTabla de Cluster COPRO ................................... 46

  • 7/25/2019 Cargue Nomina Localizada Colombia

    3/50

    ;VW!XIY7 (#'( )(0")'( )(&+/Z& +& 1&)A& & '&8+')&,#0&)(,'(#7 +*(A" 1", (+ %)/@() %( ,"./,& #( %(8( 1"))() (+ (#4*(.& >V!XB

    HCOULKT0

    IQQ[M &1*.*+&%"# D#'& 1&)A& #( %(8(IQQ[> &1*.*+&%"# )(&+/Z&) &+ ./#." '/(.0"BI\>VIP 1"##" :(A*)/%&% :"1/&+I\>VIR 1"##& L ;*'"+/4*/%&1/-,I\>VIS 1"#(@ L >(#&,'5I\>VI] 1"&8# L ^,1&0&1/%&%(#I\>VIQ 1"8') ;0")'(# _"+*,'&)/"# 3 M(,(9/1/" IBI\>VI` 1"A&) L D.8&)A"#I\>VI\ 1"'&2 L N('(,1/",I\>VI[ 1"&@& L _&1&1/",(#I\>VIa 1"0)" L VI; 1"/11 L

    COLK

    Con este reporte secargan las tablastransparentes contodas la informacinnecesaria para elproceso de nomina.

    Con el driver de

    nomina ejecuto elesquema COLK.

    CLUSTER CO

    Fecha inicial y finalde los archivos

  • 7/25/2019 Cargue Nomina Localizada Colombia

    4/50

    > '7CA@5C@A8 369 #A5F4G1

    !& (#')*1'*)& %( +"# &)1?/@"# 4*( #( %(#1)/8(, & 1",'/,*&1/-,7 #()H /.0")'&%& (, +'&8+ ')&,#0&)(,'(# $%%&' ( $%%&) )(#0(1'/@&.(,'(B

    !& '&8+& $%%&'1",'/(,( & .&,()& %( %/)(1'")/"7 /,9").&1/-, &1()1& %( +"# 0()5"%"#%( ,-./,&B !& '&8+& $%%&) 1",'/(,( +"# 1",1(0'"# %( ,-./,& 4*( #( A(,()&, (,

    1&%& 0()5"%"B D+ 1+/(,'( %(8( %(1/%/) 1*H+(# 1",1(0'"# %(+ #/#'(.& &,'()/") %(#(&'(,() (, NbSB

  • 7/25/2019 Cargue Nomina Localizada Colombia

    5/50

    Cargue de Informacin Nmina Localizada Colombia. 2005. Pgina 5 de 50

    *+,-./)0,1+

    2+345678 9/:; $51+ 8/906+

    9/>/?,1+.60:5=3

    cT.()" %( 0()#",&+ cT.()" %( 0()#",&+

    :DdcN Q Y cWJ> cT.()" &1'*&+ %(+ 0()5"%" %( 1H+1*+"%( ,-./,&

  • 7/25/2019 Cargue Nomina Localizada Colombia

    6/50

    Cargue de Informacin Nmina Localizada Colombia. 2005. Pgina 6 de 50

    *+,-./)0,1+

    2+345678 9/:; $51+ 8/906+

    9/>/?,1+.60:5=3

    f

  • 7/25/2019 Cargue Nomina Localizada Colombia

    7/50

    Cargue de Informacin Nmina Localizada Colombia. 2005. Pgina 7 de 50

  • 7/25/2019 Cargue Nomina Localizada Colombia

    8/50

  • 7/25/2019 Cargue Nomina Localizada Colombia

    9/50

    H8+ )/

  • 7/25/2019 Cargue Nomina Localizada Colombia

    10/50

    Cargue de Informacin Nmina Localizada Colombia. 2005. Pgina 10 de 50

  • 7/25/2019 Cargue Nomina Localizada Colombia

    11/50

    Cargue de Informacin Nmina Localizada Colombia. 2005. Pgina 11 de 50

    *+,-./)0,1+

    2+345678 9/:; $51+ 8/906+

    9/>/?,1+.60:5=3

    MDIM: PQ R cWJ> M( %( 1&+1*+" %(+ &,'/1/0" %(1(#&,'5

    +&@( %( .",(%& ;#/A,&) #/(.0)(COP en este campo.

    V>N:c ] Y >U;N J"'/@" 0B1H+1*+" %( ,-./,& (#0(1/&+ ;#/A,&) (#0&1/"# (, (#'( 1&.0"BU;N I/0" %( ,-./,& ;#/A,&) (#0&1/"# (, (#'( 1&.0"BU;N ^%(,'/9/1&%") %( ,-./,& ;#/A,&) (#0&1/"# (, (#'( 1&.0"BMVcKI [ Y K;I: f(1?& 0&A" 1H+1*+" ,-./,& (#0(1/&+ ;#/A,&) (#0&1/"# (, (#'( 1&.0"B

    'N6BD91 #A5F4G1L

  • 7/25/2019 Cargue Nomina Localizada Colombia

    12/50

    O

  • 7/25/2019 Cargue Nomina Localizada Colombia

    13/50

    L;!;F )0.47/ 8/ B365:51+< 8/ M/47.5808 M+:50>

    !"# 1",1(0'"# &,'/1/0&%"# %( #(A*)/%&% #"1/&+ #( 0)(#(,'&, 1*&,%" #( +(%(#1*(,'&, &+ (.0+(&%" +"# &0")'(# "8+/A&'")/"# %( #(A*)/%&% #"1/&+ E#&+*%70(,#/-, 3 #"+/%&)/%&%G %(+ .(# #/A*/(,'( &+ %( /,/1/" %( + @&1&1/",(#B :( '".&,1"." (6(.0+" +"# #/A*/(,'(# 1"#=

    ;

  • 7/25/2019 Cargue Nomina Localizada Colombia

    14/50

    Cargue de Informacin Nmina Localizada Colombia. 2005. Pgina 14 de 50

    "1256DC1 (675A4D54E2 )2345831A "Q95@91RS;82C454D17

    S>G858541267T

    U6AV131 89 ?@651AA67D1236 6982C454D1L 62 98

    C8K9851AA67D1236 89

    58BD1periodo en y

    periodo para

    +65F8)245489

    +65F8+4289

    "82C4383 M891A

    #$%% &'() *+,)-./)&01 2+345 67 8 67)6$)9668 7:)6$)9668 7: 786;666#$5+/>5+5 67 8 67)6$)9668 7:)6$)9668 7: 7$8;666

    RB @,1>/08+ T7/ / ,/< 8/ 580 /3 D5D+ ( ./4./ ?0 67 8 67)6$)9668 78)6$)9668 78 75+/>5+5 67 % 7%)6$)9668 $6)6$)9668 78 7:6;666#$%% &'() *+,)-./)&01 2+345 67 < 67)6:)9668 68)6:)9668 68 88;666#$5+/>5+5 67 < 67)6:)9668 68)6:)9668 68 :%;%%8+V 9/>60 8/ R0:0:5+3/< ( '0,() 2> .3.D'3.+5( .= =+3+/>( >01.E/+341>3>F+/ .3 ,(0,.'1( A696)

    67 8 67)6$)9668 69)6$)9668 9 98$;$$$

    #%G* B+=. H22 *+,+,>(0.=I .0.=1. ,(0,.'1( =. ,+/E+ .3J+3(/ 5. $6 5K+= 5.3 HBL ,(0.3 M4. =. 3>M4>5+/(0 3(=5.=,4.01(= 5. =.E4/>5+5=(,>+3 =(N/. 3+= J+,+,>(0.=)

    67 8 67)6$)9668 9:)6$)9668 9: $;GD)*+,)2.E2(, H01I .=.3 D>=D( ,(0,.'1( +01./>(/'./( .3 J+3(/ =. 5.N. ,+/E+/0.E+1>J()

    67 8 67)6$)9668 9:)6$)9668 9: $;G 0") +"#%5 %( @&1&1/",(# %( (#& 9)&11/-, %( .(#7 (, (#'( 1" [B

  • 7/25/2019 Cargue Nomina Localizada Colombia

    16/50

    ;%/1/",&+.(,'( & +"# ')(# 1",1(0'"# &,'()/")(# #( %(8( 1&)A&) +& 8( 9/6& 3@&)/&8+( '".&%& 0&)& (+ 0&A" %( + @&1&1/",(#B V8+/A&'")/&.(,'( #( %(8( 1&)A&)+& 8( 9/6& 3& 4*( (, 1" %( *, )(')"&1'/@" #( )(1&+1*+& +& 0&)'( 9/6& #"+&.(,'(BD2/#'(, %"# 1",1(0'"# 0&)& +&