Skip to main content

Q35InsertF0911Z1Record

Q35InsertF0911Z1Record inserts a record into the F0911Z1 interface table.

How to Use

Please refer to the Oracle documentation available at https://docs.oracle.com/cd/E64610_01/EOAGA/mapfieldjebatchprocessing.htm#EOAGA01053 on the operation of the F0911Z1 interface table.

This function provides the following parameter defaults:

szEdiUserId - If blank then set to the currently logged in user

szEdiTransactNumber - If blank then set to "1"

szEdiDocumentType - If blank then set to "JE"

szEdiLineNumber - If blank or zero then set to "1"

szEdiTransactionAction - If blank then set to "A"

szEdiTransactionType - If blank then set to "J"

szEdiBatchNumber If blank then retrieve Next Number 00|6

Data Structure

NameTypeInclusionDirection
szEdiUserIdSTRINGOPTIONALBOTH
cEDITypeUDCOPTIONALIN
mnEDISeqINTEGEROPTIONALIN
szEdiTransactNumberSTRINGOPTIONALBOTH
szEdiDocumentTypeSTRINGOPTIONALIN
mnEdiLineNumberFLOATOPTIONALBOTH
szEdiTransSetSTRINGOPTIONALIN
szEdiTranslationFormatSTRINGOPTIONALIN
jdEdiTransmissionDateDATEOPTIONALIN
cEdiSendRcvIndicatorUDCOPTIONALIN
mnEdiDetailLinesProcessINTEGEROPTIONALIN
cEdiSuccessfullyProcessCHARACTEROPTIONALIN
cEdiTransactionActionCHARACTEROPTIONALIN
cEdiTransactionTypeCHARACTEROPTIONALIN
szEdiBatchNumberSTRINGOPTIONALBOTH
cEdiCreateGlCHARACTEROPTIONALIN
mnUserAddressNumberINTEGEROPTIONALIN
szCompanyKeyCOMPANYOPTIONALIN
szDocumentTypeUDCOPTIONALIN
mnDocVoucherInvoiceEINTEGEROPTIONALIN
jdDateForGLandVoucherJULIADATEOPTIONALIN
mnJournalEntryLineNoFLOATOPTIONALIN
szLineExtensionCodeSTRINGOPTIONALIN
cGLPostedCodeCHARACTEROPTIONALIN
mnBatchNumberINTEGEROPTIONALIN
szBatchTypeUDCOPTIONALIN
jdDateBatchJulianDATEOPTIONALIN
jdDateBatchSystemDateJuliADATEOPTIONALIN
mnBatchTimeINTEGEROPTIONALIN
szCompanyCOMPANYOPTIONALIN
szAcctNoInputModeSTRINGOPTIONALIN
cAccountModeGLUDCOPTIONALIN
szAccountIdACCOUNTIDOPTIONALIN
szCostCenterBUSINESSUNITOPTIONALIN
szObjectAccountSTRINGOPTIONALIN
szSubsidiarySTRINGOPTIONALIN
szSubledgerSTRINGOPTIONALIN
cSubledgerTypeUDCOPTIONALIN
szLedgerTypeUDCOPTIONALIN
mnPeriodNoGeneralLedgeINTEGEROPTIONALIN
mnCenturyINTEGEROPTIONALIN
mnFiscalYear1INTEGEROPTIONALIN
szFiscalQtrFutureUseUDCOPTIONALIN
szCurrencyCodeFromSTRINGOPTIONALIN
mnCurrencyConverRateOvFLOATOPTIONALIN
mnHistoricalCurrencyConverFLOATOPTIONALIN
jdHistoricalDateJulianDATEOPTIONALIN
mnAmountFieldFLOATOPTIONALIN
mnUnitsFLOATOPTIONALIN
szUnitOfMeasureUDCOPTIONALIN
szGlClassSTRINGOPTIONALIN
cReverseOrVoidRVUDCOPTIONALIN
szNameAlphaExplanationSTRINGOPTIONALIN
szNameRemarkExplanationSTRINGOPTIONALIN
szReference1JeVouchInSTRINGOPTIONALIN
szReference2STRINGOPTIONALIN
szReference3AccountReconciSTRINGOPTIONALIN
szDocumentPayItemSTRINGOPTIONALIN
mnOriginalDocumentNoINTEGEROPTIONALIN
szOriginalDocumentTypeUDCOPTIONALIN
szOriginalDocPayItemSTRINGOPTIONALIN
szCompanyKeyPurchaseCOMPANYOPTIONALIN
szCompanyKeyOriginalCOMPANYOPTIONALIN
szDocumentTypePurchaseUDCOPTIONALIN
mnAddressNumberADDRESSNUMBEROPTIONALIN
szCheckNumberSTRINGOPTIONALIN
jdDateCheckJDATEOPTIONALIN
jdDateCheckClearedDATEOPTIONALIN
szSerialTagNumberSTRINGOPTIONALIN
cBatchRearEndPostCodeUDCOPTIONALIN
cReconciledROrBlankUDCOPTIONALIN
cSummarizedCodeCHARACTEROPTIONALIN
cPurgeCodeCHARACTEROPTIONALIN
cFlagFor1099CHARACTEROPTIONALIN
cGLPostCodeAlt001CHARACTEROPTIONALIN
cGLPostCodeAlt002CHARACTEROPTIONALIN
cGLPostCodeAlt003CHARACTEROPTIONALIN
cGLPostCodeAlt004CHARACTEROPTIONALIN
cGLPostCodeAlt005CHARACTEROPTIONALIN
cGLPostCodeAlt006CHARACTEROPTIONALIN
cCommitmentReliefFlagCHARACTEROPTIONALIN
cBillingControlCHARACTEROPTIONALIN
cGLPostCodeAlt009CHARACTEROPTIONALIN
cGLPostCodeAlt000CHARACTEROPTIONALIN
cGLPostingCodeAlternateTCHARACTEROPTIONALIN
cGLPostingCodeAlternateUCHARACTEROPTIONALIN
cGLPostingCodeAlternateVCHARACTEROPTIONALIN
cGLPostingCodeAlternateWCHARACTEROPTIONALIN
cGLPostCodeAlt00xCHARACTEROPTIONALIN
cGLPostingCodeAlternateZ_ACHARACTEROPTIONALIN
cDeleteNotAllowedCHARACTEROPTIONALIN
cClientFreeForm1CHARACTEROPTIONALIN
cClientFreeForm2CHARACTEROPTIONALIN
cAssetInputModeCHARACTEROPTIONALIN
cBillCodeUDCOPTIONALIN
szVendorInvoiceNumberSTRINGOPTIONALIN
jdDateInvoiceJulianDATEOPTIONALIN
szCategoriesWorkOrder001UDCOPTIONALIN
szPurchaseOrderSTRINGOPTIONALIN
szPurchaseOrderSuffixSTRINGOPTIONALIN
szOrderTypeUDCOPTIONALIN
mnLineNumberFLOATOPTIONALIN
mnWeeklyYearINTEGEROPTIONALIN
mnWeeklyPeriodINTEGEROPTIONALIN
cFinalPaymentCHARACTEROPTIONALIN
mnSequenceNoOperationsFLOATOPTIONALIN
szJobCategoryUDCOPTIONALIN
szJobStepUDCOPTIONALIN
szCostCenterHomeBUSINESSUNITOPTIONALIN
mnDoiSubINTEGEROPTIONALIN
szOutsiderLeaseOrWelIdSTRINGOPTIONALIN
szIdTypeUDCOPTIONALIN
jdDateServiceCurrencyDATEOPTIONALIN
szTransactionOriginatorSTRINGOPTIONALIN
mnRegistrationNumberINTEGEROPTIONALIN
mnPaymentIDINTEGEROPTIONALIN
szUserIdSTRINGOPTIONALIN
szProgramIdSTRINGOPTIONALIN
szWorkStationIdSTRINGOPTIONALIN
jdDateUpdatedDATEOPTIONALIN
mnTimeLastUpdatedINTEGEROPTIONALIN
cCurrencyModeUDCOPTIONALIN
mnAmountCurrencyFLOATOPTIONALIN
mnDtForGLAndVouchMoINTEGEROPTIONALIN
mnDtForGLAndVouchDaINTEGEROPTIONALIN
mnDtForGLAndVouchYrINTEGEROPTIONALIN
mnDtForGLAndVouchCtINTEGEROPTIONALIN
mnDateBatch1MoINTEGEROPTIONALIN
mnDateBatch1DaINTEGEROPTIONALIN
mnDateBatch1YrINTEGEROPTIONALIN
mnDateBatch1CtryINTEGEROPTIONALIN
mnDteBatchSysDate1MoINTEGEROPTIONALIN
mnDteBatchSysDate1DaINTEGEROPTIONALIN
mnDteBatchSysDate1YrINTEGEROPTIONALIN
mnDteBatchSysDate1CtINTEGEROPTIONALIN
mnDateCheck1MoINTEGEROPTIONALIN
mnDateCheck1DaINTEGEROPTIONALIN
mnDateCheck1YrINTEGEROPTIONALIN
mnDateCheck1CtryINTEGEROPTIONALIN
mnDteServiceShipProdMoINTEGEROPTIONALIN
mnDteServiceShipProdDaINTEGEROPTIONALIN
mnDteServiceShipProdYrINTEGEROPTIONALIN
mnDteServiceShipProdCtINTEGEROPTIONALIN
mnHistoricalDateMoINTEGEROPTIONALIN
mnHistoricalDateDaINTEGEROPTIONALIN
mnHistoricalDateYrINTEGEROPTIONALIN
mnHistoricalDateCtryINTEGEROPTIONALIN
mnDateCheckClearedMOINTEGEROPTIONALIN
mnDateCheckClearedDAINTEGEROPTIONALIN
mnDateCheckClearedYRINTEGEROPTIONALIN
mnDateCheckClearedCTRYINTEGEROPTIONALIN
mnDateInvoiceMonthINTEGEROPTIONALIN
mnDateInvoiceDAINTEGEROPTIONALIN
mnDateInvoiceYEARINTEGEROPTIONALIN
mnDateInvoiceCENTURYINTEGEROPTIONALIN
szManagerialAnalysisCode1STRINGOPTIONALIN
szManagerialAnalysisCode2STRINGOPTIONALIN
szManagerialAnalysisCode3STRINGOPTIONALIN
szManagerialAnalysisCode4STRINGOPTIONALIN
cManagerialAnalysisType1CHARACTEROPTIONALIN
cManagerialAnalysisType2CHARACTEROPTIONALIN
cManagerialAnalysisType3CHARACTEROPTIONALIN
cManagerialAnalysisType4CHARACTEROPTIONALIN
mnIdentifierShortItemSHORTITEMOPTIONALIN
cPostingCode1ManagerialAccCHARACTEROPTIONALIN
cPostingCode2ManagerialAccCHARACTEROPTIONALIN
cPostingCode3ManagerialAccCHARACTEROPTIONALIN
cPostingCode4ManagerialAccCHARACTEROPTIONALIN
cPostingCode5ManagerialAccCHARACTEROPTIONALIN
cPostingCode6ManagerialAccCHARACTEROPTIONALIN
cPostingCode7ManagerialAccCHARACTEROPTIONALIN
cPostingCode8ManagerialAccCHARACTEROPTIONALIN
cPostingCode9ManagerialAccCHARACTEROPTIONALIN
cPostingCode10ManagerialAcCHARACTEROPTIONALIN
szCurrencyCodeBaseSTRINGOPTIONALIN
szTaxExplanationCode1UDCOPTIONALIN
szTaxArea1STRINGOPTIONALIN
mnTaxItemNumberINTEGEROPTIONALIN
szActivityCodeSTRINGOPTIONALIN
mnAmtTax2FLOATOPTIONALIN
mnForeignTaxAmountFLOATOPTIONALIN
mnAmountGrossFLOATOPTIONALIN
mnForeignAmountGrossFLOATOPTIONALIN
cTrackTaxesCHARACTEROPTIONALIN
mnDistributionLineNumberFLOATOPTIONALIN
szCkNumberSTRINGOPTIONALIN
cBurdeningPostedCodeCHARACTEROPTIONALIN
szAlternateHomeBusinessUnitBUSINESSUNITOPTIONALIN
szEmployeePoolGroupingCodeUDCOPTIONALIN
szJobPoolGroupingCodeUDCOPTIONALIN
mnFileLineIdentifier50INTEGEROPTIONALIN
mnPayItemExtensionNumberINTEGEROPTIONALIN
cAutoOffMethodCHARACTEROPTIONALIN
cSuppressErrorMessageCHARACTEROPTIONALIN
szErrorCodeSTRINGOPTIONALOUT
JavaScript errors detected

Please note, these errors can depend on your browser setup.

If this problem persists, please contact our support.