A1_COD - Codigo
Tabela
SA1
Descrição do Campo
Codigo do Cliente
Tipo
C
Tamanho
6
Validação
IIF(Empty(M->A1_LOJA),.T.,ExistChav("SA1",M->A1_COD+M->A1_LOJA,,"EXISTCLI")) .And. FatVldStr()
Ajuda
Código que individualiza cada um dos clientes da empresa. É complementado pelo código da loja.
Relacionamentos
| Tabela | Campo |
|---|---|
| DCK | DCK_CODCLI |
| DCK | DCK_CODOPL |
| DYF | DYF_CLIDES |
| MB1 | MB1_CLIENT |
| N01 | N01_PROPRI |
| N04 | N04_CODCLI |
| N05 | N05_PROPRI |
| N0E | N0E_CODCLI |
| N43 | N43_CODCON |
| N45 | N45_COD |
| SA1 | A1_CLIFAT |
| SAA | AA_CLIENTE |
| SAO | AO_CLIENTE |
| SFM | FM_CLIENTE |
| SS2 | S2_CLIFAT |
| SW2 | W2_CLIENTE |
| TMW | TMW_CLIATE |
| TMW | TMW_CLIDE |
| VZF | VZF_CODCLI |
| FOJ | FOJ_CLIENT |
| OHF | OHF_CCLIEN |
| MEN | MEN_BANCO |
| CD3 | CD3_RECEP |
| CDE | CDE_PARREF |
| CF6 | CF6_CLIFOR |
| CF7 | CF7_CLIE |
| CF8 | CF8_CLIFOR |
| CIE | CIE_PART |
| CII | CII_PARTIC |
| F0M | F0M_CLIFOR |
| SF9 | F9_CLIENTE |
| SFU | FU_RECEP |
| SFX | FX_RECEP |
| VA7 | VA7_CODCLI |
| VAR | VAR_BCOCLI |
| VMY | VMY_CLIENT |
| VRJ | VRJ_CLIENT |
| VRJ | VRJ_CLIRET |
| VRJ | VRJ_CODCLI |
| VRL | VRL_E1CLIE |
| VZO | VZO_CLIENT |
| SC6 | C6_CLI |
| B6U | B6U_CODIGO |
| BJM | BJM_CODCLI |
| BJP | BJP_CODCLI |
| CTK | CTK_CODCLI |
| DAH | DAH_CODCLI |
| DDO | DDO_CLIATE |
| DDO | DDO_CLIDE |
| DDO | DDO_CODCLI |
| DE6 | DE6_CODCLI |
| DE7 | DE7_CODCLI |
| DEC | DEC_CODCLI |
| DIZ | DIZ_CODCLI |
| DL4 | DL4_CLIDEV |
| DUO | DUO_CODCLI |
| DVN | DVN_CODCLI |
| DW7 | DW7_CODCLI |
| FRA | FRA_CLIENT |
| MA8 | MA8_CODEMP |
| MAS | MAS_CODCLI |
| MAX | MAX_CODCLI |
| MBO | MBO_CODCLI |
| MBR | MBR_CODCLI |
| SA2 | A2_CLIENTE |
| SCB | CB_CLIENTE |
| SLJ | LJ_CLIENTE |
| SNM | NM_CLIENTE |
| TO0 | TO0_CLIENT |
| FPN | FPN_CLIENT |
| MGK | MGK_CODCLI |
| RDN | RDN_CODCLI |
| VMD | VMD_CODCLI |
| VME | VME_CODCLI |
| VMF | VMF_CODCLI |
| VMG | VMG_CODCLI |
| VMH | VMH_CODCLI |
| VMI | VMI_CODCLI |
| VMJ | VMJ_CODCLI |
| VMK | VMK_CODCLI |
| VML | VML_CODCLI |
| VMM | VMM_CODCLI |
| VMN | VMN_CODCLI |
| VMO | VMO_CODCLI |
| VMP | VMP_CODCLI |
| VMQ | VMQ_CODCLI |
| VMR | VMR_CODCLI |
| VMS | VMS_CODCLI |
| VMT | VMT_CODCLI |
| VMU | VMU_CODCLI |
| VMV | VMV_CODCLI |
| VMW | VMW_CODCLI |
| VMX | VMX_CODCLI |
| VMZ | VMZ_CODCLI |
| VP6 | VP6_CODCLI |
| VV0 | VV0_CODAVA |
| TEW | TEW_CODCLI |