ReleaseUpdateTransformDB40_Ledger.updateFDocFromCustInvoiceJour_BR Upgrade Script

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

Class	ReleaseUpdateTransformDB40_Ledger
Method	updateFDocFromCustInvoiceJour_BR
Description	This script is used for updating the fiscal document related to customer 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_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