| Tabela | |||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|
| GWM | RATEIO CONTABIL DE FRETE | ||||||||||
| Campo | Tipo | Tamanho | Decimal | Titulo | Formato | Validacao | F3 | Contexto | Lista | Condicao | PYME |
| GWM_FILIAL | C | 2 | 0 | Filial | S | ||||||
| GWM_TPDOC | C | 1 | 0 | Tipo Docto | Pertence("1234") | R | 1=Calculo Frete;2=CTRC/NFS;3=Contrato Autonomo;4=Estimativa | inclui | S | ||
| GWM_CDESP | C | 5 | 0 | Especie DF | @! | ExistCpo("GVT") | GVTFRT | R | INCLUI | S | |
| GWM_CDTRP | C | 14 | 0 | Transp. | @! | ExistCpo("GU3") | GU3TRP | R | inclui | S | |
| GWM_DSTRP | C | 80 | 0 | Nome | V | S | |||||
| GWM_SERDOC | C | 5 | 0 | Serie Docto | @! | R | inclui | S | |||
| GWM_NRDOC | C | 16 | 0 | Nr Docto | @! | R | inclui | S | |||
| GWM_DTEMIS | D | 8 | 0 | Data Emissao | R | S | |||||
| GWM_CDTPDC | C | 5 | 0 | Tipo DC | @! | ExistCpo("GV5",M->GWM_CDTPDC) | GV5 | R | inclui | S | |
| GWM_DSTPDC | C | 50 | 0 | Descricao | @! | V | S | ||||
| GWM_EMISDC | C | 14 | 0 | Emissor DC | @! | ExistCpo("GU3") | GU3GUC | R | inclui | S | |
| GWM_NMEMIT | C | 80 | 0 | Nome | V | S | |||||
| GWM_SERDC | C | 3 | 0 | Serie DC | @! | R | inclui | S | |||
| GWM_NRDC | C | 16 | 0 | Nr DC | @! | R | inclui | S | |||
| GWM_SEQGW8 | C | 5 | 0 | Sequencia | 99999 | R | S | ||||
| GWM_DTEMDC | D | 8 | 0 | Data Emis DC | S | ||||||
| GWM_ITEM | C | 16 | 0 | Item | @! | NAOVAZIO() .AND. TEXTO() | R | S | |||
| GWM_UNINEG | C | 3 | 0 | Unid Negocio | R | S | |||||
| GWM_GRPCTB | C | 140 | 0 | Grupo Ctbl | @! | R | S | ||||
| GWM_GRP1 | C | 20 | 0 | Grupo 1 | @! | R | inclui | S | |||
| GWM_GRP2 | C | 20 | 0 | Grupo 2 | @! | R | inclui | S | |||
| GWM_GRP3 | C | 20 | 0 | Grupo 3 | @! | R | inclui | S | |||
| GWM_GRP4 | C | 20 | 0 | Grupo 4 | @! | R | inclui | S | |||
| GWM_GRP5 | C | 20 | 0 | Grupo 5 | @! | R | inclui | S | |||
| GWM_GRP6 | C | 20 | 0 | Grupo 6 | @! | R | inclui | S | |||
| GWM_GRP7 | C | 20 | 0 | Grupo 7 | @! | R | inclui | S | |||
| GWM_CTINAU | C | 20 | 0 | INSS Aut | @! | ExistCpo("GUE") | GUE | R | S | ||
| GWM_CCINAU | C | 20 | 0 | C C INSS Aut | @! | Vazio() .OR. ExistCpo("GUH") | R | S | |||
| GWM_DSCTIA | C | 50 | 0 | Descricao | @! | V | S | ||||
| GWM_DSCCIA | C | 60 | 0 | Descricao CC | @! | V | S | ||||
| GWM_CTINEM | C | 20 | 0 | INSS Embarc | @! | ExistCpo("GU3") | GUE | R | S | ||
| GWM_DSCTIE | C | 50 | 0 | Desc Conta | @! | V | S | ||||
| GWM_CCINEM | C | 20 | 0 | CC INSS Emb | @! | Vazio() .OR. ExistCpo("GUH") | R | S | |||
| GWM_DSCCIE | C | 60 | 0 | Desc CCusto | @! | V | S | ||||
| GWM_CTIRRF | C | 20 | 0 | IRRF | @! | ExistCpo("GUE") | GUE | R | S | ||
| GWM_DSCTIR | C | 50 | 0 | Descricao | @! | V | S | ||||
| GWM_CCIRRF | C | 20 | 0 | C C IRRF | @! | Vazio() .OR. ExistCpo("GUH") | R | S | |||
| GWM_DSCCIR | C | 60 | 0 | Descricao CC | @! | V | S | ||||
| GWM_CTSEST | C | 20 | 0 | SEST/SENAT | @! | ExistCpo("GUE") | GUE | R | S | ||
| GWM_DSCTSE | C | 50 | 0 | Descricao | @! | V | S | ||||
| GWM_CCSEST | C | 20 | 0 | C C SEST | @! | Vazio() .OR. ExistCpo("GUH") | R | S | |||
| GWM_DSCCSE | C | 60 | 0 | Descricao CC | @! | V | S | ||||
| GWM_CTISS | C | 20 | 0 | ISS | @! | ExistCpo("GUE") | GUE | R | S | ||
| GWM_DSCTIS | C | 50 | 0 | Descricao | @! | V | S | ||||
| GWM_CCISS | C | 20 | 0 | C C ISS | @! | Vazio() .OR. ExistCpo("GUH") | R | S | |||
| GWM_DSCCIS | C | 60 | 0 | Descricao CC | @! | V | S | ||||
| GWM_CTICMS | C | 20 | 0 | ICMS | @! | ExistCpo("GU3") | GUE | R | S | ||
| GWM_DSCTIC | C | 50 | 0 | Descricao | @! | V | S | ||||
| GWM_CCICMS | C | 20 | 0 | C C ICMS | @! | Vazio() .OR. ExistCpo("GUH") | R | S | |||
| GWM_DSCCIC | C | 60 | 0 | Descricao CC | @! | V | S | ||||
| GWM_CTPIS | C | 20 | 0 | PIS | @! | ExistCpo("GU3") | GUE | R | S | ||
| GWM_DSCTPI | C | 50 | 0 | Descricao | @! | V | S | ||||
| GWM_CCPIS | C | 20 | 0 | C C PIS | @! | Vazio() .OR. ExistCpo("GUH") | R | S | |||
| GWM_DSCCPI | C | 60 | 0 | Descricao CC | @! | V | S | ||||
| GWM_CTCOFI | C | 20 | 0 | COFINS | @! | ExistCpo("GU3") | GUE | R | S | ||
| GWM_DSCTCO | C | 50 | 0 | Descricao | @! | V | S | ||||
| GWM_CCCOFI | C | 20 | 0 | C C COFI | @! | Vazio() .OR. ExistCpo("GUH") | R | S | |||
| GWM_DSCCCO | C | 60 | 0 | Descricao CC | @! | V | S | ||||
| GWM_CTFRET | C | 20 | 0 | Fretes | @! | ExistCpo("GU3") | GUE | R | S | ||
| GWM_DSCTFR | C | 50 | 0 | Descricao | @! | V | S | ||||
| GWM_CCFRET | C | 20 | 0 | C C Frete | @! | Vazio() .OR. ExistCpo("GUH") | R | S | |||
| GWM_DSCCFR | C | 60 | 0 | Descricao CC | @! | V | S | ||||
| GWM_VLINAU | N | 12 | 2 | Pes INSS Aut | @E 999,999,999.99 | R | S | ||||
| GWM_VLINEM | N | 12 | 2 | Pes INSS Emb | @E 999,999,999.99 | R | S | ||||
| GWM_VLIRRF | N | 12 | 2 | Peso IRRF | @E 999,999,999.99 | R | S | ||||
| GWM_VLSEST | N | 12 | 2 | Peso SEST | @E 999,999,999.99 | R | S | ||||
| GWM_VLISS | N | 12 | 2 | Peso ISS | @E 999,999,999.99 | R | S | ||||
| GWM_VLICMS | N | 12 | 2 | Peso ICMS | @E 999,999,999.99 | R | S | ||||
| GWM_VLPIS | N | 12 | 2 | Peso PIS | @E 999,999,999.99 | R | S | ||||
| GWM_VLCOFI | N | 12 | 2 | Peso COFINS | @E 999,999,999.99 | R | S | ||||
| GWM_VLFRET | N | 12 | 2 | Peso Frete | @E 999,999,999.99 | R | S | ||||
| GWM_VLINA1 | N | 12 | 2 | Val INSS Aut | @E 999,999,999.99 | R | S | ||||
| GWM_VLINE1 | N | 12 | 2 | Val INSS Emb | @E 999,999,999.99 | R | S | ||||
| GWM_VLIRR1 | N | 12 | 2 | Val IRRF | @E 999,999,999.99 | R | S | ||||
| GWM_VLSES1 | N | 12 | 2 | Val SEST | @E 999,999,999.99 | R | S | ||||
| GWM_VLISS1 | N | 12 | 2 | Val ISS | @E 999,999,999.99 | R | S | ||||
| GWM_VLICM1 | N | 12 | 2 | Val ICMS | @E 999,999,999.99 | R | S | ||||
| GWM_VLPIS1 | N | 12 | 2 | Val PIS | @E 999,999,999.99 | R | S | ||||
| GWM_VLCOF1 | N | 12 | 2 | Val COFINS | @E 999,999,999.99 | R | S | ||||
| GWM_VLFRE1 | N | 12 | 2 | Val Frete | @E 999,999,999.99 | R | S | ||||
| GWM_VLINA2 | N | 12 | 2 | Qtd INSS Aut | @E 999,999,999.99 | R | S | ||||
| GWM_VLINE2 | N | 12 | 2 | Qtd INSS Emb | @E 999,999,999.99 | R | S | ||||
| GWM_VLICM2 | N | 12 | 2 | Qtd ICMS | @E 999,999,999.99 | R | S | ||||
| GWM_VLIRR2 | N | 12 | 2 | Qtd IRRF | @E 999,999,999.99 | R | S | ||||
| GWM_VLSES2 | N | 12 | 2 | Qtd SEST | @E 999,999,999.99 | R | S | ||||
| GWM_VLISS2 | N | 12 | 2 | Qtd ISS | @E 999,999,999.99 | R | S | ||||
| GWM_VLPIS2 | N | 12 | 2 | Qtd PIS | @E 999,999,999.99 | R | S | ||||
| GWM_VLCOF2 | N | 12 | 2 | Qtd COFINS | @E 999,999,999.99 | R | S | ||||
| GWM_VLFRE2 | N | 12 | 2 | Qtd Frete | @E 999,999,999.99 | R | S | ||||
| GWM_VLINA3 | N | 12 | 2 | Vol INSS Aut | @E 999,999,999.99 | R | S | ||||
| GWM_VLINE3 | N | 12 | 2 | Vol INSS Emb | @E 999,999,999.99 | R | S | ||||
| GWM_VLIRR3 | N | 12 | 2 | Vol IRRF | @E 999,999,999.99 | R | S | ||||
| GWM_VLSES3 | N | 12 | 2 | Vol SEST | @E 999,999,999.99 | R | S | ||||
| GWM_VLISS3 | N | 12 | 2 | Vol ISS | @E 999,999,999.99 | R | S | ||||
| GWM_VLICM3 | N | 12 | 2 | Vol ICMS | @E 999,999,999.99 | R | S | ||||
| GWM_VLPIS3 | N | 12 | 2 | Vol PIS | @E 999,999,999.99 | R | S | ||||
| GWM_VLCOF3 | N | 12 | 2 | Vol COFINS | @E 999,999,999.99 | R | S | ||||
| GWM_VLFRE3 | N | 12 | 2 | Vol Frete | @E 999,999,999.99 | R | S | ||||
| GWM_PCRAT | N | 9 | 5 | % Rateio | @E 999.99999 | R | S | ||||
| GWM_PEDAG | N | 9 | 2 | Pes Pedagio | @E 999,999.99 | Positivo() | R | S | |||
| GWM_PEDAG1 | N | 9 | 2 | Val Pedagio | @E 999,999.99 | Positivo() | R | S | |||
| GWM_PEDAG2 | N | 9 | 2 | Qtd Pedagio | @E 999,999.99 | Positivo() | R | S | |||
| GWM_PEDAG3 | N | 9 | 2 | Vol Pedagio | @E 999,999.99 | Positivo() | R | S | |||
| GWM_SDOCDC | C | 3 | 0 | Serie Doc. | !!! | R | S | ||||