Histórico da Página
...
Produto: | Datasul |
Ocorrência: | Documentação de API |
| Nome Físico | cdp/cdapiitem.p |
Tabelas Temporárias
Tabela Temporária | Descrição | Entrada/Saída | |||||
RowErrors | Erros ocorridos no processo. | Saída | |||||
Atributo | Tipo | Formato | Descrição | Obrig. | Evol. | ||
ErrorSequence | int |
| Sequencia do erro |
|
| ||
ErrorNumber | int |
| Código do erro |
|
| ||
ErrorDescription | char |
| Descrição do erro |
|
| ||
ErrorParameters | char |
| Parâmetros do erro |
|
| ||
ErrorType | char |
| Tipo do erro |
|
| ||
ErrorHelp | char |
| Ajuda |
|
| ||
ErrorSubType | char |
| Sub-tipo do erro |
|
| ||
...
| DEFINE TEMP-TABLE ttItem | |
| FIELD it-codigo | AS CHARACTER |
| FIELD descricao-1 | AS CHARACTER |
| FIELD descricao-2 | AS CHARACTER |
| FIELD un | AS CHARACTER |
| FIELD compr-fabric | AS INTEGER |
| FIELD ge-codigo | AS INTEGER |
| FIELD fm-codigo | AS CHARACTER |
| FIELD data-implant | AS DATE |
| FIELD data-liberac | AS DATE |
| FIELD path | AS CHARACTER |
| FIELD codigo-refer | AS CHARACTER |
| FIELD inform-compl | AS CHARACTER |
| FIELD niv-mais-bai | AS INTEGER |
| FIELD loc-unica | AS LOGICAL |
| FIELD tipo-con-est | AS INTEGER |
| FIELD deposito-pad | AS CHARACTER |
| FIELD ciclo-contag | AS INTEGER |
| FIELD data-ult-con | AS DATE |
| FIELD variac-acum | AS DECIMAL |
| FIELD curva-abc | AS LOGICAL |
| FIELD data-ult-ent | AS DATE |
| FIELD data-ult-sai | AS DATE |
| FIELD data-base | AS DATE |
| FIELD data-ult-rep | AS DATE |
| FIELD cod-obsoleto | AS INTEGER |
| FIELD consumo-prev | AS DECIMAL |
| FIELD consumo-aad | AS DECIMAL |
| FIELD cod-comprado | AS CHARACTER |
| FIELD demanda | AS INTEGER |
| FIELD emissao-ord | AS INTEGER |
| FIELD classif-abc | AS INTEGER |
| FIELD politica | AS INTEGER |
| FIELD periodo-fixo | AS INTEGER |
| FIELD tempo-segur | AS INTEGER |
| FIELD quant-segur | AS DECIMAL |
| FIELD res-int-comp | AS INTEGER |
| FIELD res-for-comp | AS INTEGER |
| FIELD res-cq-comp | AS INTEGER |
| FIELD ressup-fabri | AS INTEGER |
| FIELD res-cq-fabri | AS INTEGER |
| FIELD lote-multipl | AS DECIMAL |
| FIELD tipo-lote-ec | AS INTEGER |
| FIELD lote-economi | AS DECIMAL |
| FIELD fator-refugo | AS DECIMAL |
| FIELD quant-perda | AS DECIMAL |
| FIELD classe-repro | AS INTEGER |
| FIELD contr-qualid | AS LOGICAL |
| FIELD class-fiscal | AS CHARACTER |
| FIELD aliquota-ipi | AS DECIMAL |
| FIELD codigo-orig | AS INTEGER |
| FIELD cd-trib-icm | AS INTEGER |
| FIELD cd-trib-ipi | AS INTEGER |
| FIELD peso-liquido | AS DECIMAL |
| FIELD fator-conver | AS DECIMAL |
| FIELD tipo-desc-nt | AS INTEGER |
| FIELD baixa-estoq | AS LOGICAL |
| FIELD moeda-padrao | AS INTEGER |
| FIELD preco-base | AS DECIMAL |
| FIELD preco-ul-ent | AS DECIMAL |
| FIELD preco-repos | AS DECIMAL |
| FIELD cd-planejado | AS CHARACTER |
| FIELD nr-linha | AS INTEGER |
| FIELD tipo-requis | AS INTEGER |
| FIELD cap-est-fabr | AS DECIMAL |
| FIELD tipo-contr | AS INTEGER |
| FIELD tipo-est-seg | AS INTEGER |
| FIELD dt-ult-ben | AS DATE |
| FIELD ft-conversao | AS DECIMAL |
| FIELD dec-ftcon | AS INTEGER |
| FIELD pm-ja-calc | AS LOGICAL |
| FIELD fraciona | AS LOGICAL |
| FIELD reporte-mob | AS INTEGER |
| FIELD ind-item-fat | AS LOGICAL |
| FIELD peso-bruto | AS DECIMAL |
| FIELD cd-trib-iss | AS INTEGER |
| FIELD aliquota-ISS | AS DECIMAL |
| FIELD ind-imp-desc | AS INTEGER |
| FIELD ind-ipi-dife | AS LOGICAL |
| FIELD lote-minimo | AS DECIMAL |
| FIELD ind-inf-qtf | AS LOGICAL |
| FIELD vl-mat-ant | AS DECIMAL |
| FIELD vl-mob-ant | AS DECIMAL |
| FIELD responsavel | AS CHARACTER |
| FIELD usuario-alt | AS CHARACTER |
| FIELD data-obsol | AS DATE |
| FIELD usuario-obsol | AS CHARACTER |
| FIELD criticidade | AS INTEGER |
| FIELD horiz-fixo | AS INTEGER |
| FIELD horiz-liber | AS INTEGER |
| FIELD lote-mulven | AS DECIMAL |
| FIELD cod-servico | AS INTEGER |
| FIELD comprim | AS DECIMAL |
| FIELD largura | AS DECIMAL |
| FIELD altura | AS DECIMAL |
| FIELD qt-max-ordem | AS DECIMAL |
| FIELD perm-saldo-neg | AS INTEGER |
| FIELD dt-pr-fisc | AS DATE |
| FIELD preco-fiscal | AS DECIMAL |
| FIELD ct-codigo | AS CHARACTER |
| FIELD sc-codigo | AS CHARACTER |
| FIELD pr-sem-tx | AS DECIMAL |
| FIELD div-ordem | AS INTEGER |
| FIELD cod-estabel | AS CHARACTER |
| FIELD cod-produto | AS CHARACTER |
| FIELD fm-cod-com | AS CHARACTER |
| FIELD ft-conv-fmcoml | AS DECIMAL |
| FIELD volume | AS DECIMAL |
| FIELD desc-nacional | AS CHARACTER |
| FIELD desc-inter | AS CHARACTER |
| FIELD ind-especifico | AS LOGICAL |
| FIELD per-min-luc | AS DECIMAL |
| FIELD ind-backorder | AS LOGICAL |
| FIELD rep-prod | AS INTEGER |
| FIELD cd-formula | AS INTEGER |
| FIELD cd-origem | AS INTEGER |
| FIELD tp-cons-prev | AS DECIMAL |
| FIELD tp-aloc-lote | AS INTEGER |
| FIELD tp-desp-padrao | AS INTEGER |
| FIELD id-grade | AS LOGICAL |
| FIELD nat-despesa | AS INTEGER |
| FIELD tp-adm-lote | AS INTEGER |
| FIELD per-rest-icms | AS DECIMAL |
| FIELD niv-rest-icms | AS CHARACTER |
| FIELD concentracao | AS DECIMAL |
| FIELD rendimento | AS DECIMAL |
| FIELD nivel | AS INTEGER |
| FIELD tipo-insp | AS INTEGER |
| FIELD perc-nqa | AS DECIMAL |
| FIELD per-rest-fora | AS DECIMAL |
| FIELD niv-rest-fora | AS CHARACTER |
| FIELD nr-item-dcr | AS INTEGER |
| FIELD tx-importacao | AS DECIMAL |
| FIELD prioridade | AS INTEGER |
| FIELD tipo-sched | AS INTEGER |
| FIELD atu-conf | AS LOGICAL |
| FIELD isencao-import | AS INTEGER |
| FIELD resumo-mp | AS INTEGER |
| FIELD ind-serv-mat | AS INTEGER |
| FIELD cod-refer | AS CHARACTER |
| FIELD niv-mps | AS INTEGER |
| FIELD calc-cons-prev | AS INTEGER |
| FIELD var-transf | AS DECIMAL |
| FIELD var-rep | AS DECIMAL |
| FIELD var-req-maior | AS DECIMAL |
| FIELD var-req-menor | AS DECIMAL |
| FIELD de-codigo-prin | AS CHARACTER |
| FIELD contr-plan | AS INTEGER |
| FIELD calc-lead-time | AS INTEGER |
| FIELD dec-conv-fmcoml | AS INTEGER |
| FIELD fase-medio | AS INTEGER |
| FIELD cod-auxiliar | AS CHARACTER |
| FIELD var-mob-maior | AS DECIMAL |
| FIELD var-mob-menor | AS DECIMAL |
| FIELD it-demanda | AS CHARACTER |
| FIELD perc-demanda | AS DECIMAL |
| FIELD cd-folh-lote | AS CHARACTER |
| FIELD cd-folh-item | AS CHARACTER |
| FIELD valor-ipi-beb | AS DECIMAL |
| FIELD esp-beb | AS INTEGER |
| FIELD enquad-beb | AS INTEGER |
| FIELD tipo-recip-beb | AS INTEGER |
| FIELD capac-recip-beb | AS INTEGER |
| FIELD rot-quant | AS LOGICAL |
| FIELD rot-revis | AS LOGICAL |
| FIELD rot-refer | AS LOGICAL |
| FIELD alt-refer | AS LOGICAL |
| FIELD tipo-atp | AS INTEGER |
| FIELD fator-reaj-icms | AS DECIMAL |
| FIELD incentivado | AS LOGICAL |
| FIELD prefixo-lote | AS CHARACTER |
| FIELD Nr-ult-peca | AS INTEGER |
| FIELD tp-lote-minimo | AS LOGICAL |
| FIELD tp-lote-multiplo | AS LOGICAL |
| FIELD tp-lote-econom | AS LOGICAL |
| FIELD quant-pacote | AS DECIMAL |
| FIELD conta-aplicacao | AS CHARACTER |
| FIELD ct-aplicacao | AS CHARACTER |
| FIELD sc-aplicacao | AS CHARACTER |
| FIELD cod-localiz | AS CHARACTER |
| FIELD sit-aloc | AS INTEGER |
| FIELD cd-tag | AS CHARACTER |
| FIELD cod-tax | AS INTEGER |
| FIELD cod-tax-serv | AS INTEGER |
| FIELD desc-item | AS CHARACTER |
| FIELD narrativa | AS CHARACTER |
| FIELD log-carac-tec | AS LOGICAL |
| FIELD cod-lista-destino | AS CHARACTER |
| FIELD log-atualiz-via-mmp | AS LOGICAL |
| FIELD vl-var-max | AS DECIMAL |
| FIELD vl-var-min | AS DECIMAL |
| FIELD qt-var-max | AS DECIMAL |
| FIELD qt-var-min | AS DECIMAL |
| FIELD reporte-ggf | AS INTEGER |
| FIELD cod-imagem | AS CHARACTER |
| FIELD cd-referencia | AS CHARACTER |
| FIELD conv-tempo-seg | AS LOGICAL |
| FIELD char-1 | AS CHARACTER |
| FIELD char-2 | AS CHARACTER |
| FIELD dec-1 | AS DECIMAL |
| FIELD dec-2 | AS DECIMAL |
| FIELD INT-1 | AS INTEGER |
| FIELD int-2 | AS INTEGER |
| FIELD log-1 | AS LOGICAL |
| FIELD log-2 | AS LOGICAL |
| FIELD data-1 | AS DATE |
| FIELD data-2 | AS DATE |
| FIELD ind-confprodcom | AS LOGICAL |
| FIELD nivel-apr-requis | AS INTEGER |
| FIELD nivel-apr-solic | AS INTEGER |
| FIELD nivel-apr-manut | AS INTEGER |
| FIELD nivel-apr-compra | AS INTEGER |
| FIELD ind-prev-demanda | AS INTEGER |
| FIELD ind-calc-meta | AS INTEGER |
| FIELD val-fator-custo-dis | AS DECIMAL |
| FIELD qtd-refer-custo-dis | AS DECIMAL |
| FIELD qtd-batch-padrao | AS DECIMAL |
| FIELD log-utiliza-batch-padrao | AS LOGICAL |
| FIELD ind-quotas | AS LOGICAL |
| FIELD nr-pontos-quotas | AS INTEGER |
| FIELD check-sum | AS CHARACTER |
| FIELD num-id-item | AS INTEGER |
| FIELD ind-refugo | AS INTEGER |
| FIELD log-necessita-li | AS LOGICAL |
| FIELD dias-estoq-aloc | AS CHARACTER |
| FIELD pto-repos | AS DECIMAL |
| FIELD aliquota-ii | AS DECIMAL |
| FIELD cod-trib-ii | AS INTEGER |
| FIELD geracao-ordem | AS INTEGER |
| FIELD cons-produto | AS LOGICAL |
| FIELD cons-saldo | AS LOGICAL |
| FIELD mp-restrit | AS LOGICAL |
| FIELD qtde-max | AS DECIMAL |
| FIELD qtde-fixa | AS DECIMAL |
| FIELD lote-repos | AS DECIMAL |
| FIELD cons-consumo | AS LOGICAL |
| FIELD cod-malha | AS CHARACTER |
| FIELD cod-pulmao | AS CHARACTER |
| FIELD politica-aps | AS INTEGER |
| FIELD tipo-formula | AS INTEGER |
| FIELD per-ppm | AS DECIMAL |
| FIELD cod-tab-preco-aps | AS CHARACTER |
| FIELD cod-pulmao-proces | AS CHARACTER |
| FIELD log-tax-produc | AS LOGICAL |
| FIELD log-control-estoq-refugo | AS LOGICAL |
| FIELD log-refugo-preco-fisc | AS LOGICAL |
| FIELD cod-item-refugo | AS CHARACTER |
| FIELD val-relac-refugo-item | AS DECIMAL |
| FIELD log-multi-malha | AS LOGICAL |
| FIELD cod-destaq | AS INTEGER |
| FIELD dsl-destaq | AS CHARACTER |
| FIELD cod-unid-negoc | AS CHARACTER |
| FIELD idi-classif-item | AS INTEGER |
| FIELD log-consid-aloc-ativid | AS LOGICAL |
| FIELD val-overlap | AS DECIMAL |
| FIELD log-programac-sfc | AS LOGICAL |
| FIELD cod-dcr-item | AS CHARACTER |
| FIELD log-orig-ext | AS LOGICAL |
| FIELD log-altera-valid-lote | AS LOGICAL |
| FIELD log-inspec-lote | AS LOGICAL |
| FIELD reab-estoq | AS CHARACTER |
| FIELD tp-item | AS CHARACTER |
| FIELD tp-ressup | LIKE item-mat.tp-ressup |
| FIELD cd-freq | LIKE item-mat.cd-freq |
| FIELD lim-var-qtd | LIKE item-mat.lim-var-qtd |
| FIELD lim-var-valor | LIKE item-mat.lim-var-valor |
| FIELD var-val-re-maior | LIKE item-mat.var-val-re-maior |
| FIELD var-qtd-re | LIKE item-mat.var-qtd-re |
| FIELD cod-grp-compra | LIKE item-mat.cod-grp-compra |
| FIELD cod-ean | LIKE item-mat.cod-ean |
| FIELD variacao-perm | LIKE item-mat.variacao-perm |
| FIELD ponto-encomenda | LIKE item-mat.ponto-encomenda |
| FIELD ind-cons-prv | LIKE item-mat.ind-cons-prv |
| FIELD lote-per-max | LIKE item-mat.lote-per-max |
| FIELD val-lim-absor | LIKE item-mat.val-lim-absor |
| FIELD fator-ponder | LIKE item-mat.fator-ponder |
| FIELD crit-cc | LIKE item-mat.crit-cc |
| FIELD crit-ce | LIKE item-mat.crit-ce |
| FIELD cod-fat-ponder | LIKE item-mat.cod-fat-ponder |
| FIELD data-pr-fisc | LIKE item-uni-estab.data-pr-fisc |
| FIELD altera-conta | LIKE item-mat.altera-conta |
| FIELD idi-tip-apurac-ipi | LIKE it-doc-fisc.idi-tip-apurac-ipi |
| FIELD cod-familia-impto | LIKE item-mat.cod-familia-impto |
| FIELD cdn-sefazsp | LIKE item-dist.cdn-sefazsp |
| FIELD log-combust | LIKE item-dist.log-combust |
| FIELD idi-forma-calc-pis | LIKE item-dist.idi-forma-calc-pis |
| FIELD val-unit-pis | LIKE item-dist.val-unit-pis |
| FIELD val-unit-cofins | LIKE item-dist.val-unit-cofins |
| FIELD cdd-perc-retenc-pis | LIKE item-dist.cdd-perc-retenc-pis |
| FIELD cdd-perc-retenc-cofins | LIKE item-dist.cdd-perc-retenc-cofins |
| FIELD log-orig-retenc-pis | LIKE item-dist.log-orig-retenc-pis |
| FIELD log-orig-retenc-cofins | LIKE item-dist.log-orig-retenc-cofins |
| FIELD idi-forma-calc-cofins | LIKE item-dist.idi-forma-calc-cofins |
| FIELD log-orig-retenc-csll | LIKE item-dist.log-orig-retenc-csll |
| FIELD cdd-perc-retenc-csll | LIKE item-dist.cdd-perc-retenc-csll |
| FIELD vli-capac-vol | LIKE item-dist.vli-capac-vol |
| FIELD idi-classif-bebida | LIKE item-dist.idi-classif-bebida |
| FIELD idi-enquad-ipi | AS CHARACTER |
| FIELD prioridade-aprov | LIKE item-uni-estab.prioridade-aprov |
| FIELD prior-mrp | LIKE item-uni-estab.prior-mrp |
| FIELD qt-min-res-fabr | LIKE item-uni-estab.qt-min-res-fabr |
| FIELD res-min-fabri | LIKE item-uni-estab.res-min-fabri |
| FIELD var-tempo-res-fabr | LIKE item-uni-estab.var-tempo-res-fabr |
| FIELD var-qtd-res-fabr | LIKE item-uni-estab.var-qtd-res-fabr |
| FIELD cod-estab-gestor | LIKE item-uni-estab.cod-estab-gestor |
| FIELD metodo-custeio | LIKE item-uni-estab.metodo-custeio |
| FIELD dat-cust-padr-impltad | LIKE item-uni-estab.dat-cust-padr-impltad |
| FIELD log-cust-padr-impltad | LIKE item-uni-estab.log-cust-padr-impltad |
| FIELD ind-lista-csp | LIKE item-uni-estab.ind-lista-csp |
| FIELD cod-estabel-uni | LIKE item-uni-estab.cod-estabel |
| FIELD log-suspens-impto-import | LIKE item-mat.log-suspens-impto-import |
| FIELD log-suspens-ipi-import | LIKE item-mat.log-suspens-ipi-import |
| FIELD cdn-fabrican | LIKE item-mat.cdn-fabrican |
| FIELD cdn-pais-orig | LIKE item-mat.cdn-pais-orig |
| FIELD val-tax-basic-seguro | LIKE item-mat.val-tax-basic-seguro |
| FIELD val-tax-impto-seguro | LIKE item-mat.val-tax-impto-seguro |
| FIELD idi-tributac-pis | LIKE item-mat.idi-tributac-pis |
| FIELD val-unit-vol-pis | LIKE item-mat.val-unit-vol-pis |
| FIELD val-aliq-ext-pis | LIKE item-mat.val-aliq-ext-pis |
| FIELD idi-tributac-cofins | LIKE item-mat.idi-tributac-cofins |
| FIELD val-unit-vol-cofins | LIKE item-mat.val-unit-vol-cofins |
| FIELD val-aliq-ext-cofins | LIKE item-mat.val-aliq-ext-cofins |
| FIELD val-base-pis-substto | LIKE item-mat.val-base-pis-substto |
| FIELD val-base-cofins-substto | LIKE item-mat.val-base-cofins-substto |
| FIELD ind-lista-mrp | AS INTEGER |
| FIELD descricao1 | AS CHARACTER |
| FIELD log-aloc-neg | AS LOGICAL |
| FIELD cod-workflow | AS CHARACTER. |
Métodos (Procedures Internas)
...
Visão Geral
Import HTML Content
Conteúdo das Ferramentas
Tarefas