datamap inbound voucher
DESCRIPTION
Datamap Inbound VoucherTRANSCRIPT
Inbound VoucherEnterpriseOneOTMF47041F47042F47044F49T60AliasNew / ExistingDescriptionTypeSizeDataCommentsAliasXSD LocationTypeSizeTypeSizeOTM Mapped FieldsXXXVINVExistingSupplier Invoice NumberString25OTM Vendor Invoice Number size 128 will be truncated to the E1 size of 25InvoiceNumberVoucher.Payment.PaymentHeader.InvoiceNumString128XOTVINVNewNo mappingString200XDIVJExistingInvoice DateDate6Invoice DateVoucher.Payment.PaymentHeader.Invoicedate.GLogDateDateXXVR01ExistingSupplier numberNumeric8Though OTM size is more, this data should not be changed in OTM. If invalid data is passed in, Voucher will not get generated in E1.Service ProviderVoucher.Payment.PaymentHeader.ServiceProviderGID.GID.XIDString50XOTVXIDNewOTM Voucher XidString100Voucher XidVoucher.VoucherGID.GID.XIDString50XXAAGExistingVoucher Amount - GrossNumeric15If voucher currency is same as (after xref) company currency, map voucher amountAmountToPay or amounttopay with taxVoucher.AmountToPay.FinancialAmount.MonetoryAmount (or) Voucher.AmountToPaWithTax.FinancialAmount.MonetoryAmountNumberXXAPExistingVoucher Amount - OpenNumeric9If voucher currency is same as (after xref) company currency, map voucher amountXXFEAExistingForeign Voucher Amount-GrossNumeric15If voucher currency is different from (after xref) company currency, map voucher amountXXACRExistingForeign Voucher Amount-OpenNumeric9If voucher currency is different from (after xref) company currency, map voucher amountXXATXAExistingAmount TaxableNumeric9If AmountToPay is different from Amounttopaywithtax, then map amouttopaywithtax to Grossfields as above. If they are the same or amounttopaywith tax doesnt exist, map the amounttopay to the taxable field.XXCTXAExisitingForeign Amount TaxableNumeric9Same as aboveexcept check for currency codeXXCRRMExisitingCharacter1If currencies are same, hardcode 'D', else hardcode 'F'XXXCRCDExistingCurrency CodeString3Cross ReferenceGlobal CurrencyCodeVoucher.AmountToPay.FinancialAmount.GlobalCurrencyCodeString50CRDCExistingCompany Currency CodeString6Just used in integration logic.Mapped from first ship from location of the first shipmentLocation Reference Number Qualifier ValueMap the followingvalue Voucher.Shipment.Location.LocationRefNum.LocationRefNumQualifierValue if the following condition is true: This locationGId.xid's shipment.shipmentstop.stopsequence == 1 && shipment.location.locationtype == shipfrom/to && shipment.location.locationRefNum.LocationRefnumQualifier == CURRENCY_CODEString256XXXCOExistingString5Mapped from first ship from location of the first shipmentLocation Reference Number Qualifier ValueMap the followingvalue Voucher.Shipment.Location.LocationRefNum.LocationRefNumQualifierValue if the following condition is true: This locationGId.xid's shipment.shipmentstop.stopsequence == 1 && shipment.location.locationtype == shipfrom/to && shipment.location.locationRefNum.LocationRefnumQualifier == COMPANY_NUMBERString256XXXXEKCOExistingEDI Document CompanyString5XANIExistingNo mappingString29Mapped from first ship from location of the first shipment. If it is blank, mapped from the service provider location referenceLocation Reference Number Qualifier ValueMap the followingvalue Voucher.Shipment.Location.LocationRefNum.LocationRefNumQualifierValue if the following condition is true: This locationGId.xid's shipment.shipmentstop.stopsequence == 1 && shipment.location.locationtype == shipfrom/to && shipment.location.locationRefNum.LocationRefnumQualifier == ACCOUNT_NUMBERString256Hardcoded or Generated FieldsXEDLNExistingNo mappingNumeric7Hard code to 1.000XDGLExistingNo mappingDate6Today's date formatted to E1 per integration OptionsXXXEDSTExistingEDI Transaction SetString6Hard coded to 810XXEDERExistingSend/Receive indicatorCharacter1Hard coded to RXXXXEDOCExistingEDI Document NumberNumeric9Generated by a call to N4700050. EDI Next number generationXXXXEDCTExistingEDI Document TypeString2XXXXUPMJExistingDate UpdatedDate6Call to GetAuditInfo BSFN will get these valuesXXXXUSERExistingUserIDString10XXXXPIDExistingProgramIDString10XXXXJOBNExistingWorkstationIDString10