27 20 1 5excel Clientes Junio 2015 3
27 20 1 5excel Clientes Junio 2015 3
27 20 1 5excel Clientes Junio 2015 3
tDebtor.Debtor_ID
209969 SERVICE
SERVICE
SERVICE
SERVICE
SERVICE
SERVICE
SERVICE
SERVICE
SERVICE
SERVICE
SERVICE
SERVICE
SERVICE
SERVICE
SERVICE
SERVICE
SERVICE
SERVICE
SERVICE
SERVICE
SERVICE
SERVICE
SERVICE
SERVICE
SERVICE
SERVICE
SERVICE
SERVICE
SERVICE
SERVICE
SERVICE
SERVICE
SERVICE
SERVICE
SERVICE
SERVICE
SERVICE
SERVICE
SERVICE
SERVICE
SERVICE
SERVICE
C101663
C150028
C120059
C120061
C120060
C120058
C120057
C110001
C110146
C110147
C150015
C150017
C150022
C150019
C150027
C150014
C150021
C101682
C101686
C101688
C101690
C101693
C101694
C101695
C101696
C101697
C101698
C101699
C101700
C101701
C101702
C101703
C101704
C101705
C101706
C101707
C101708
C101709
C101710
C101711
C101712
C101713
SERVICE
SERVICE
C101714
C101715
Activo
tDebtor.DebtorIsActive
NONE
NONE
Imprimir Estado
tDebtor.DebtorIsPrintStatement
Imprimir Recordatorio
tDebtor.DebtorIsPrintReminder
1
Nmero Domicilio
tDebtor.DomiciliationNumber
Cliente Gravable
tDebtor.DebtorIsTaxable
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
Impuesto en la Ciudad
tDebtor.DebtorIsTaxInCity
Impuesto Incluido
tDebtor.DebtorIsTaxIncluded
1
Impuesto Federal
tDebtor.DebtorTaxIDF
0 REC950222RR4
CAC011026NX4
AEZA320501UC2
MACU851111UL5
MELP721108V36
MOMN8509183UA
RATR710706FJ6
COAM550517DD2
VERA660120494
VIVS600907DB3
APS931217911
DIP0311275A5
EGE9608087C2
LCM7003027A6
PPA4310222S3
SACM791206KC0
SGR0509287Q0
MAPA630912SV1
GUTJ8007217G6
SRC141008CB2
GESC860526PNA
SAMJ840116707
RALM740119BE6
MAGG680202SV3
NASA860413CMA
SIVS780219PV5
GGA081113CX3
SDL060620A11
SOHL690414SG0
GACF69091674A
GMP141013GWA
SANV680107A29
CURC870731QV8
MAHR630321B15
HEEC6811282P8
LOGS630908FL8
LUML631113CA4
AGL011218HP1
MASS431028831
SASJ670118CB4
GACG670402CK9
MEA1210252L2
RARJ850206KQA
YRYE821104LF3
Impuesto Estatal
tDebtor.DebtorTaxIDState
Impuesto Miscelneos 1
tDebtor.DebtorTaxIDMisc1
Impuesto Miscelneos 2
tDebtor.DebtorTaxIDMisc2
Impuesto Miscelneos 3
tDebtor.DebtorTaxIDMisc3
Declaracin de Impuesto
tDebtor.DebtorTaxDeclaration
0
0
Aplicar % de Facturacin
tDebtor.DebtorIsTurnOverCredLim
0
0
0
Porcentaje de Facturacin
tDebtor.DebtorPercTurnOverCredLim
0
0
0
0
Incluir Pre-Facturas
tDebtor.ObsoleteInclPreInvCredLim
Incluir Pagars
tDebtor.DebtorIsInclDraftCredLim
% Techo Advertencia
tDebtor.DebtorPercWarningCredLim
Anular Permitido
tDebtor.DebtorIsOverruleSOCredLim
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
Anular Permitido
tDebtor.ObsoleteOverrulePICredLim
Anular Permitido
tDebtor.DebtorIsOverruleDICredLim
0
Retencin Crdito
tDebtor.DebtorIsLockedCredLim
Grupo en Pre-Factura
tDebtor.ObsoleteGroupingSOOnPreInv
Cargos Financieros
tDebtor.DebtorIsFinanceCharge
0
Ciclo Estado
tDebtor.DebtorStatementCycle
30D
30D
30D
30D
30D
30D
30D
30D
30D
30D
30D
30D
30D
30D
30D
30D
30D
30D
30D
30D
30D
30D
30D
30D
30D
30D
30D
30D
30D
30D
30D
30D
30D
30D
30D
30D
30D
30D
30D
30D
30D
30D
30D
30D
Crdito Alto
tDebtor.DebtorHighCredit
110000
Nota de Comentario
tDebtor.DebtorCommentNote
0
0
N de Facturas pagas
tDebtor.DebtorTotalNbrOfInvoices
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
Zona Impuesto
tDebtor.TxzTaxZone
0 MEXICO
MEXICO
MEXICO
MEXICO
MEXICO
MEXICO
MEXICO
MEXICO
MEXICO
MEXICO
MEXICO
MEXICO
MEXICO
MEXICO
MEXICO
MEXICO
MEXICO
MEXICO
MEXICO
MEXICO
MEXICO
MEXICO
MEXICO
MEXICO
MEXICO
MEXICO
MEXICO
MEXICO
MEXICO
MEXICO
MEXICO
MEXICO
MEXICO
MEXICO
MEXICO
MEXICO
MEXICO
MEXICO
MEXICO
MEXICO
MEXICO
MEXICO
Clases de Impuestos
tDebtor.TxclTaxCls
VDE
V16
V16
V16
V16
V16
V16
V16
V16
V16
V16
V16
V16
V16
V16
V16
V16
V16
V16
V16
V16
V16
V16
V16
V16
V16
V16
V16
V16
V16
V16
V16
V16
V16
V16
V16
V16
V16
V16
V16
V16
V16
MEXICO
MEXICO
V16
V16
Uso de Impuesto
tDebtor.TxuTaxUsage
Intercompaa
tDebtor.tlBusinessRelationIsInterco
0
NORMAL
NORMAL
NORMAL
NORMAL
NORMAL
NORMAL
NORMAL
NORMAL
NORMAL
NORMAL
NORMAL
NORMAL
NORMAL
NORMAL
NORMAL
NORMAL
NORMAL
NORMAL
NORMAL
NORMAL
NORMAL
NORMAL
NORMAL
NORMAL
NORMAL
NORMAL
NORMAL
NORMAL
NORMAL
NORMAL
NORMAL
NORMAL
NORMAL
NORMAL
NORMAL
NORMAL
NORMAL
NORMAL
NORMAL
NORMAL
NORMAL
NORMAL
ARP-CTENAC
ARP-CTENAC
ARP-CTENAC
ARP-CTENAC
ARP-CTENAC
ARP-CTENAC
ARP-CTENAC
ARP-CTENAC
ARP-CTENAC
ARP-CTENAC
ARP-CTENAC
ARP-CTENAC
ARP-CTENAC
ARP-CTENAC
ARP-CTENAC
ARP-CTENAC
ARP-CTENAC
ARP-CTENAC
ARP-CTENAC
ARP-CTENAC
ARP-CTENAC
ARP-CTENAC
ARP-CTENAC
ARP-CTENAC
ARP-CTENAC
ARP-CTENAC
ARP-CTENAC
ARP-CTENAC
ARP-CTENAC
ARP-CTENAC
ARP-CTENAC
ARP-CTENAC
ARP-CTENAC
ARP-CTENAC
ARP-CTENAC
ARP-CTENAC
ARP-CTENAC
ARP-CTENAC
ARP-CTENAC
ARP-CTENAC
ARP-CTENAC
ARP-CTENAC
NORMAL
NORMAL
ARP-CTENAC
ARP-CTENAC
ARP-CTENAC
ARP-VTASCRAP
ARP-VTASCRAP
ARP-VTASCRAP
ARP-VTASCRAP
ARP-VTASCRAP
ARP-VTASCRAP
ARP-VTASCRAP
ARP-VTASCRAP
ARP-VTASCRAP
ARP-VTASCRAP
ARP-VTASCRAP
ARP-VTASCRAP
ARP-VTASCRAP
ARP-VTASCRAP
ARP-VTASCRAP
ARP-VTASCRAP
ARP-VTASCRAP
ARP-VTASCRAP
ARP-VTASCRAP
ARP-VTASCRAP
ARP-VTASCRAP
ARP-VTASCRAP
ARP-VTASCRAP
ARP-VTASCRAP
ARP-VTASCRAP
ARP-VTASCRAP
ARP-VTASCRAP
ARP-VTASCRAP
ARP-VTASCRAP
ARP-VTASCRAP
ARP-VTASCRAP
ARP-VTASCRAP
ARP-VTASCRAP
ARP-VTASCRAP
ARP-VTASCRAP
ARP-VTASCRAP
ARP-VTASCRAP
ARP-VTASCRAP
ARP-VTASCRAP
ARP-VTASCRAP
ARP-VTASCRAP
ARP-VTASCRAP
ARP-CTENAC
ARP-CTENAC
ARP-CTENAC
ARP-CTENAC
ARP-CTENAC
ARP-CTENAC
ARP-CTENAC
ARP-CTENAC
ARP-CTENAC
ARP-CTENAC
ARP-CTENAC
ARP-CTENAC
ARP-CTENAC
ARP-CTENAC
ARP-CTENAC
ARP-CTENAC
ARP-CTENAC
ARP-CTENAC
ARP-CTENAC
ARP-CTENAC
ARP-CTENAC
ARP-CTENAC
ARP-CTENAC
ARP-CTENAC
ARP-CTENAC
ARP-CTENAC
ARP-CTENAC
ARP-CTENAC
ARP-CTENAC
ARP-CTENAC
ARP-CTENAC
ARP-CTENAC
ARP-CTENAC
ARP-CTENAC
ARP-CTENAC
ARP-CTENAC
ARP-CTENAC
ARP-CTENAC
ARP-CTENAC
ARP-CTENAC
ARP-CTENAC
ARP-CTENAC
ARP-CTENAC
ARP-VTASCRAP
ARP-VTASCRAP
Perfil de Subcuenta
tDebtor.tcDivisionProfileCode
ARP-VTASCRAP
ARP-VTASCRAP
Grupo BLWI
tDebtor.tcBLWIGroupCode
ARP-CTENAC
ARP-CTENAC
Trm Crd
tDebtor.tcNormalPaymentConditionCode
15D
CONTADO
CONTADO
CONTADO
CONTADO
CONTADO
CONTADO
30D
30D
CONTADO
20D
30D
30D
30D
CONTADO
CONTADO
CONTADO
CONTADO
CONTADO
CONTADO
CONTADO
CONTADO
CONTADO
CONTADO
CONTADO
CONTADO
CONTADO
CONTADO
CONTADO
CONTADO
CONTADO
CONTADO
CONTADO
CONTADO
CONTADO
CONTADO
CONTADO
CONTADO
CONTADO
CONTADO
CONTADO
CONTADO
CONTADO
CONTADO
C101663
C150028
C120059
C120061
C120060
C120058
C120057
C110001
C110146
C110147
C150015
C150017
C150022
C150019
C150027
C150014
C150021
C101682
C101686
C101688
C101690
C101693
C101694
C101695
C101696
C101697
C101698
C101699
C101700
C101701
C101702
C101703
C101704
C101705
C101706
C101707
C101708
C101709
C101710
C101711
C101712
C101713
C101714
C101715
Mon
tDebtor.tcCurrencyCode
Tipo de Cliente
tDebtor.tcDebtorTypeCode
MXN
MXN
MXN
MXN
MXN
MXN
MXN
MXN
MXN
MXN
MXN
MXN
MXN
MXN
MXN
MXN
MXN
MXN
MXN
MXN
MXN
MXN
MXN
MXN
MXN
MXN
MXN
MXN
MXN
MXN
MXN
MXN
MXN
MXN
MXN
MXN
MXN
MXN
MXN
MXN
MXN
MXN
C020
C020
C020
C020
C020
C020
C020
C020
C020
C020
C020
C020
C020
C020
C020
C020
C020
C020
C020
C020
C020
C020
C020
C020
C020
C020
C020
C020
C020
C020
C020
C020
C020
C020
C020
C020
C020
C020
C020
C020
C020
C020
MXN
MXN
C020
C020
Cobrar-A
tDebtor.tcBillToDebtorCode
C101663
C150028
C120059
C120061
C120060
C120058
C120057
C110001
C110146
C110147
C150015
C150017
C150022
C150019
C150027
C150014
C150021
C101682
C101686
C101688
C101690
C101693
C101694
C101695
C101696
C101697
C101698
C101699
C101700
C101701
C101702
C101703
C101704
C101705
C101706
C101707
C101708
C101709
C101710
C101711
C101712
C101713
Clasificacin Crediticia
tDebtor.tcDebtorCreditRatingCode
C101714
C101715
Recolectora de Facturas
tDebtor.tcEmployeeCode
ARP-VTANAC
ARP-VTANAC
Cdigo SAF
tDebtorSafDefault.tcSafCode