| Tabela | |||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|
| SW9 | Capa de Invoices | ||||||||||
| Campo | Tipo | Tamanho | Decimal | Titulo | Formato | Validacao | F3 | Contexto | Lista | Condicao | PYME |
| W9_FILIAL | C | 2 | 0 | Filial | N | ||||||
| W9_INVOICE | C | 15 | 0 | Invoice | @! | DI500InvValid() | N | ||||
| W9_DT_EMIS | D | 8 | 0 | Emissao | @D | N | |||||
| W9_HAWB | C | 17 | 0 | Processo | @! | N | |||||
| W9_FORN | C | 6 | 0 | Fornecedor | @! | DI500InvValid() | SA2 | N | |||
| W9_FORLOJ | C | 2 | 0 | Loja Fo. | @! | S | |||||
| W9_NOM_FOR | C | 20 | 0 | Nome Fornec. | @! | N | |||||
| W9_MOE_FOB | C | 3 | 0 | Moeda | @! | DI500InvValid() | SYF | N | |||
| W9_FOB_TOT | N | 13 | 2 | Preco Itens | @E 9,999,999,999.99 | Positivo() | N | ||||
| W9_INCOTER | C | 3 | 0 | Incoterm | @! | ExistCpo("SYJ",M->W9_INCOTER) | SYJ | N | |||
| W9_TX_FOB | N | 15 | 8 | Taxa Reais | @E 999,999.99999999 | Positivo() | DI400ENC(6) | N | |||
| W9_NUM | C | 9 | 0 | Nro.Titulo | @! | N | |||||
| W9_DTLANC | D | 8 | 0 | Dt. Lancam. | @D | .F. | N | ||||
| W9_COND_PA | C | 5 | 0 | Condicao Pag | @! | ExistCpo("SY6") | Y6A | N | |||
| W9_DIAS_PA | N | 3 | 0 | Dias Pagto. | 999 | ExistCpo("SY6",M->W9_COND_PA+STR(M->W9_DIAS_PA,3,0)) | N | ||||
| W9_RAT_POR | C | 1 | 0 | Rateado Por | @! | Pertence("123") | 1=Peso;2=Preco;3=Quantidade | N | |||
| W9_FREINC | C | 1 | 0 | Frete Incl. | @! | Pertence("12") .AND. DI500INVVALID() | 1=Sim;2=Nao | N | |||
| W9_SEGINC | C | 1 | 0 | Seguro Incl. | @! | Pertence("12") | 1=Sim;2=Nao | N | |||
| W9_SEGURO | N | 15 | 2 | Seguro | @E 999,999,999,999.99 | Positivo() | DI400ENC(6) | N | |||
| W9_FRETEIN | N | 15 | 2 | Intl Freigh | @E 999,999,999,999.99 | Positivo() .AND. DI500INVVALID() | DI400ENC(6) | N | |||
| W9_INLAND | N | 15 | 2 | Inland Charg | @E 999,999,999,999.99 | Positivo() .AND. DI500INVVALID() | N | ||||
| W9_PACKING | N | 15 | 2 | Packing Char | @E 999,999,999,999.99 | Positivo() .AND. DI500INVVALID() | N | ||||
| W9_OUTDESP | N | 15 | 2 | Outr. Desp. | @E 999,999,999,999.99 | Positivo() .AND. DI500INVVALID() | N | ||||
| W9_DESCONT | N | 15 | 2 | Desconto | @E 999,999,999,999.99 | Positivo() .AND. DI500INVVALID() | N | ||||
| W9_TUDO_OK | C | 1 | 0 | Invoice OK | 1=Sim;2=Nao | N | |||||
| W9_FORNECC | C | 6 | 0 | Forn. Com. | @! | Vazio(M->W9_FORNECC) .OR. ExistCpo("SA2",M->W9_FORNECC) | FOR | R | N | ||
| W9_LOJAC | C | 2 | 0 | Loja | @! | R | N | ||||
| W9_COMPV | C | 1 | 0 | Tp. Vl. Com. | @! | Empty(M->W9_COMPV) .or. (Pertence("12 ") .and. DI500InvValid()) | R | 1=Valor;2=Percentual | N | ||
| W9_PERCOM | N | 6 | 2 | Comissao % | @E 999.99 | Positivo() .and. DI500InvValid() | R | M->W9_COMPV = "2" | N | ||
| W9_VALCOM | N | 16 | 2 | Vl. Comissao | @E 9,999,999,999,999.99 | Positivo() | R | M->W9_COMPV = "1" | N | ||
| W9_TIPOCOM | C | 1 | 0 | Tp. Comissao | @! | Empty(M->W9_TIPOCOM) .or. Pertence("123 ") | R | 1=A Remeter;2=A deduzir da fatura;3=Conta Grafica | N | ||
| W9_RATFRT | C | 1 | 0 | Rateia Frete | @! | V | 1=SIM;2=NAO | N | |||