ReleaseUpdateTransformDB50_Ledger.updateFiscalDocuments_BR Upgrade Script

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

Class

ReleaseUpdateTransformDB50_Ledger

Method

updateFiscalDocuments_BR

Description

This script is used for updating the fiscal documents.

Script Type

Preprocessing 60: Live

Pre-processing60: Delta

Ax Version

Microsoft Dynamics AX 2009

Affected Modules and Tables

Affected Modules

General ledger

Affected Tables

DEL_FiscalDocJourUpgrade_BR

FiscalDocument_BR

FiscalDocTrans_BR

FiscalDocumentLine_BR

LogisticsPostalAddres

DEL_FiscalDocJourUpgrade_BR

FiscalDocumentCustVendTrans_BR

FiscalDocumentInstallment_BR

FiscalDocumentReferencedProcess_BR

FiscalDocumentShipmentStat_BR

Remarks

The script creates the new fiscal document model based on <c>FiscalDocJour</c> and <c>FiscalDocTrans</c> tables information.

Data Migration Section

From Table: FiscalDocJour

To Table: FiscalDocument_BR

RefRecId

RefRecId

RefTableId

RefTableId

Status

Status

InvoiceDate

FiscalDocumentDate

InvoiceDate

AccountingDate

FiscalDocNumber

FiscalDocumentNumber

InvoiceSeries

FiscalDocumentSeries

InventoryDirection

Direction

Voucher

Voucher

CFOPName

OperationDescription

InvoiceAccount

FiscalDocumentAccountNum

DeliveryCNPJCPFNum

DeliveryCNPJCPF

DeliveryIENum

DeliveryIE

DeliveryVehicleBrand

PackingBrand

DeliveryVehicleLicense

VehicleLicensePlateNumber

DeliveryVehicleLicenseState

VehicleLicensePlateState

ComplementaryInvoice

ComplementaryInvoice

DlvMode

DeliveryMode

DlvTerm

DeliveryTerm

ComplementaryType

ComplementaryType

TotalAmount

TotalAmount

TotalGoodsAmount

TotalGoodsAmount

TotalServicesAmount

TotalServicesAmount

TotalDiscountAmount

TotalDiscountAmount

SumMarkupFreight

TotalMarkupFreightAmount

SumMarkupInsurance

TotalMarkupInsuranceAmount

SumMarkupOthers

TotalMarkupOtherAmount

From Table: CompanyInfo

To Table: FiscalDocument_BR

Name

FiscalEstablishmentName

CNPJCPFNum

FiscalEstablishmentCNPJCPF

CCMNum

FiscalEstablishmentCCMNum

IENum

FiscalEstablishmentIE

Phone

FiscalEstablishmentPhone

TributarySubstitutionRegistry

FiscalEstablishmentTribSubstitutionReg

From Table: LogisticsPostalAddress

To Table: FiscalDocument_BR

RecId

FiscalEstablishmentPostalAddress

RecId

SalesCarrierLogisticsPostalAddress

From Table: CustTable

To Table: FiscalDocument_BR

Name

ThirdPartyName

CNPJCPFNum

ThirdPartyCNPJCPF

CCMNum

ThirdPartyCCMNum

IENum

ThirdPartyIE

Phone

ThirdPartyPhone

TeleFax

ThirdPartyFax

From Table: VendTable

To Table: FiscalDocument_BR

Name

ThirdPartyName

CNPJCPFNum

ThirdPartyCNPJCPF

CCMNum

ThirdPartyCCMNum

IENum

ThirdPartyIE

Phone

ThirdPartyPhone

TeleFax

ThirdPartyFax

From Table: CustInvoiceJour

To Table: LogisticsPostalAddress

InvoicingName

Address

InvCountryRegionId

CountryRegionId

InvState

State

InvZipCode

ZipCode

InvoiceCity

City

InvoiceStreet

Street

InvAddressNumber

StreetNumber

InvDistrictName

DistrictName

InvAddressComplement

BuildingCompliment

From Table: VendInvoiceJour

To Table: LogisticsPostalAddress

InvoiceAddress

Address

InvoiceCountryRegion

CountryRegionId

InvoiceState

State

InvoiceZipCode

ZipCode

InvoiceCity

City

InvoiceStreet

Street

InvoiceAddressNumber

StreetNumber

InvoiceDistrict

DistrictName

InvoiceAddressComplement

BuildingCompliment

From Table: CustPackingSlipJour

To Table: LogisticsPostalAddress

DeliveryAddress

Address

DlvCountryRegionId

CountryRegionId

DlvState

State

DlvZipCode

ZipCode

DeliveryCity

City

DeliveryStreet

Street

DlvAddressNumber

StreetNumber

DlvDistrictName

DistrictName

DlvAddressComplement

BuildingCompliment

From Table: FiscalDocJour

To Table: LogisticsPostalAddress

DeliveryAddress

Address

DeliveryAddressCountryRegion

CountryRegionId

DeliveryAddressState

State

DeliveryAddressZipCode

ZipCode

DeliveryAddressCity

City

DeliveryAddressStreet

Street

DeliveryAddressStreetNumber

StreetNumber

DeliveryAddressDistrict

DistrictName

DeliveryAddressComplement

BuldingCompliment

From Table: SalesCarrier

To Table: FiscalDocument_BR

RecId

SalesCarrier

From Table: FiscalDocument_BR

To Table: FiscalDocumentLine_BR

RecId

FiscalDocument

From Table: FiscalDocTrans

To Table: FiscalDocumentLine_BR

RefTableId

RefTableId

RefRecId

RefRecId

CFOPId

CFOP

ItemName

Description

LineNum

LineNum

ItemId

ItemId

InventTransId

InventTransId

LineUnit

Unit

Qty

Quantity

LineDiscAmount

LineDiscount

LineUnitPrice

UnitPrice

TaxationOrigin

Origin

ServiceCodeId

ServiceCode

LineUnitPrice

UnitPrice

From Table: FiscalDocJour

To Table: DEL_FiscalDocJourUpgrade_BR

RecId

FiscalDocJourRecId

RecVersion

RecVersionId

From Table: FiscalDocument_BR

To Table: DEL_FiscalDocJourUpgrade_BR

RecId

FiscalDocumentRecId

From Table: FiscalDocument_BR

To Table: FiscalDocumentCustVendTrans_BR

RecId

FiscalDocument

From Table: FiscalDocJour

To Table: FiscalDocumentCustVendTrans_BR

PrimaryMethod

DocumentType

PaymentDueDate

DueDate

TotalAmount

Amount

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: FiscalDocJour

To Table: FiscalDocumentReferencedProcess_BR

ProcessAgency

Agency

ProcessNumber

ProcessNumber

From Table: FiscalDocument_BR

To Table: FiscalDocumentShipmentStat_BR

RecId

FiscalDocument

From Table: FiscalDocJour

To Table: FiscalDocumentShipmentStat_BR

GrossWeight

GrossWeight

NetWeight

NetWeight

VolumeType

VolumeType

VolumeQty

VolumeQuantity

New Tables or Fields

Table

Field

Extended Data Type

-or- Base Enum

FiscalDocument_BR

FiscalDocumentLine_BR

FiscalDocumentCustVendTrans_BR

FiscalDocumentInstallment_BR

FiscalDocumentReferencedProcess_BR

FiscalDocumentShipmentStat_BR