ReleaseUpdateTransformDB40_Ledger.updateFDocFromCustInvoiceJour_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 |
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 |
|
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 |
Announcements: To see known issues and recent fixes, use Issue search in Microsoft Dynamics Lifecycle Services (LCS).