ReleaseUpdateTransformDB50_Ledger.updateFiscalDocumentsDelta_BR Upgrade Script [AX 2012]
Updated: September 25, 2012
Applies To: Microsoft Dynamics AX 2012 R3, Microsoft Dynamics AX 2012 R2
|
Class |
ReleaseUpdateTransformDB50_Ledger |
|
Method |
updateFiscalDocumentsDelta_BR |
|
Description |
This script is used for updating the fiscal documents. |
|
Script Type |
Preprocessing 60: Delta Pre-processing60: Delta |
|
Ax Version |
Microsoft Dynamics AX 2009 |
|
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 |
|
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 |
Announcements: To see known issues and recent fixes, use Issue search in Microsoft Dynamics Lifecycle Services (LCS).