ReleaseUpdateTransformDB40_Ledger.updateFDocFromVendInvoiceJour_BR Upgrade Script

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

Class	ReleaseUpdateTransformDB40_Ledger
Method	updateFDocFromVendInvoiceJour_BR
Description	This script is used for updating the fiscal document related to vendor invoices.
Script Type	Preprocessing 60: Live 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