Compartir a través de


ReleaseUpdateTransformDB40_Ledger.updateFDocFromCustInvoiceJourDelta_BR Upgrade Script

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

Class

ReleaseUpdateTransformDB40_Ledger

Method

updateFDocFromCustInvoiceJourDelta_BR

Description

This script is used for updating the fiscal document related to customer 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_CustInvoiceJourUpgrade_BR

FiscalDocumentLine_BR

FiscalDocumentCustVendTrans_BR

FiscalDocumentInstallment_BR

FiscalDocumentReferencedProcess_BR

FisalDocumentShipmentStat_BR

Data Migration Section

From Table: CustInvoiceJour

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

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

DeliveryAddress

Address

DlvCountryRegionId

CountryRegionId

DlvState

State

DlvZipCode

ZipCode

DeliveryCity

City

DeliveryStreet

Street

DlvAddressNumber

StreetNumber

DlvDistrictName

DistrictName

DlvAddressComplement

BuildingCompliment

DlvTransportBrand

PackingBrand

DlvNoOfCarrier

VehicleLicensePlateNumber

DlvMode

DeliveryMode

DlvTerm

DeliveryTerm

InvoiceComplementaryType

ComplementaryType

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

To Table: FiscalDocumentLine_BR

TableId

RefTableId

RecId

RefRecId

LineNum

LineNum

ItemId

ItemId

CustCFOPId

CFOP

Name

Description

TaxFiscalClassificationId

FiscalClassification

ExceptionCode_BR

ExceptionCode

TaxationOrigin

Origin

InventTransId

InventTransId

SalesUnit

Unit

Qty

Quantity

ServiceCodeId

ServiceCode

From Table: FiscalDocument_BR

To Table: FiscalDocumentCustVendTrans_BR

RecId

FiscalDocument

TotalAmount

Amount

From Table: CustInvoiceJour

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

To Table: FiscalDocumentReferencedProcess_BR

Agency_BR

Agency

RefProcessNo_BR

ProcessNumber

From Table: FiscalDocument_BR

To Table: FiscalDocumentShipmentStat_BR

RecId

FiscalDocument

From Table: SalesShipmentStat

To Table: FiscalDocumentShipmentStat_BR

GrossWeight

GrossWeight

NetWeight

NetWeight

VolumeType_BR

VolumeType

VolumeQty_BR

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