Compartir a través de


ReleaseUpdateTransformDB40_Ledger.updateFDocFromVendInvoiceJourDelta_BR Upgrade Script

Applies To: Microsoft Dynamics AX 2012 R3, Microsoft Dynamics AX 2012 R2

Class

ReleaseUpdateTransformDB40_Ledger

Method

updateFDocFromVendInvoiceJourDelta_BR

Description

This script is used for updating the fiscal document related to vendor invoices.

Script Type

Preprocessing 60: Delta

Pre-processing60: Delta

Ax Version

Microsoft Dynamics AX 4.0

Affected Modules and Tables

Affected Modules

General ledger

Affected Tables

FiscalDocument_BR

LogisticsPostalAddress

DEL_VendInvoiceJourUpgrade_BR

FiscalDocumentLine_BR

FiscalDocumentCustVendTrans_BR

FiscalDocumentInstallment_BR

FiscalDocumentReferencedProcess_BR

FisalDocumentShipmentStat_BR

Data Migration Section

From Table: VendInvoiceJour

To Table: FiscalDocument_BR

RecId

RefRecId

TableId

RefTableId

Status_BR

Status

InvoiceDate

FiscalDocumentDate

InvoiceDate

AccountingDate

InvoiceNumber

FiscalDocumentNumber

InvoiceSeries

FiscalDocumentSeries

InvoiceModel_BR

Model

LedgerVoucher

Voucher

InvoiceAccount

FiscalDocumentAccountNum

InvoiceAmountMST

TotalAmount

From Table: CompanyInfo

To Table: FiscalDocument_BR

Name

FiscalEstablishmentName

CNPJCPFNum

FiscalEstablishmentCNPJCPF

CCMNum

FiscalEstablishmentCCMNum

IEnum

FiscalEstablishmentIE

Phone

FiscalEstablishmentPhone

TributarySubstitutionRegistry

FiscalEstablishmentTribSubstitutionReg

From Table: VendTable

To Table: FiscalDocument_BR

Name

ThirdPartyName

CNPJCPFNum

ThirdPartyCNPJCPF

CCMNum

ThirdPartyCCMNum

IENum

ThirdPartyIE

Phone

ThirdPartyPhone

TeleFax

ThirdPartyFax

From Table: VendInvoiceJour

To Table: LogisticsPostalAddress

InvoiceAddress

Address

InvoiceCountryRegionId

CountryRegionId

InvoiceState

State

InvoiceZipCode

ZipCode

InvoiceCity

City

InvoiceStreet

Street

InvoiceAddressNumber

StreetNumber

InvoiceDistrict

DistrictName

InvoiceAddressComplement

BuildingCompliment

DeliveryAddress

Address

DeliveryCountryRegion

CountryRegionId

DeliveryState

State

DeliveryZipCode

ZipCode

DeliveryCity

City

DeliveryStreet

Street

DeliveryAddressNumber

StreetNumber

DeliveryDistrict

DistrictName

DeliveryAddressComplement

BuildingCompliment

DlvTransportBrand

PackingBrand

DlvNoOfCarrier

VehicleLicensePlateNumber

DlvMode

DeliveryMode

DlvTerm

DeliveryTerm

From Table: SalesCarrier

To Table: FiscalDocument_BR

RecId

SalesCarrier

From Table: LogisticsPostalAddress

To Table: FiscalDocument_BR

RecId

SalesCarrierLogisticsPostalAddress

From Table: FiscalDocument_BR

To Table: FiscalDocumentLine_BR

RecId

FiscalDocument

From Table: VendInvoiceTrans

To Table: FiscalDocumentLine_BR

TableId

RefTableId

RecId

RefRecId

LineNum

LineNum

ItemId

ItemId

VendCFOPId

CFOP

Name

Description

TaxFiscalClassificationId

FiscalClassification

ExceptionCode_BR

ExceptionCode

TaxationOrigin

Origin

InventTransId

InventTransId

PurchUnit

Unit

Qty

Quantity

ServiceCodeId

ServiceCode

From Table: FiscalDocument_BR

To Table: FiscalDocumentCustVendTrans_BR

RecId

FiscalDocument

TotalAmount

Amount

From Table: VendInvoiceJour

To Table: FiscalDocumentCustVendTrans_BR

PrimaryMethod_BR

PrimaryMethod

DueDate

DueDate

From Table: FiscalDocumentCustVendTrans_BR

To Table: FiscalDocumentInstallment_BR

RecId

FiscalDocumentCustVendTrans

From Table: CustPaymSchedLine

To Table: FiscalDocumentInstallment_BR

DueAmount

Amount

DueDate

DueDate

From Table: FiscalDocument_BR

To Table: FiscalDocumentReferencedProcess_BR

Recid

FiscalDocument

From Table: VendInvoiceJour

To Table: FiscalDocumentReferencedProcess_BR

Agency_BR

Agency

RefProcessNo_BR

ProcessNumber

From Table: FiscalDocument_BR

To Table: FiscalDocumentShipmentStat_BR

RecId

FiscalDocument

From Table: VendInvoiceJour

To Table: FiscalDocumentShipmentStat_BR

Weight

GrossWeight

Weight

NetWeight

From Table: BrazilParameters

To Table: FiscalDocumentShipmentStat_BR

VolumeType_BR

VolumeType

VolumeQty_BR

VolumeQunatity

New Tables or Fields

Table

Field

Extended Data Type

-or- Base Enum

FiscalDocument_BR

FiscalDocumentLine_BR

FiscalDocumentCustVendTrans_BR

FiscalDocumentInstallment_BR

FiscalDocumentReferencedProcess_BR

FiscalDocumentShipmentStat_BR