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