Skip to main content

Q35CreateF0411Z1Line

Q35InsertF0411Z1Record inserts a record into the F0411Z1 interface table.

How to Use

Please refer to the Oracle documentation available at https://docs.oracle.com/cd/E64610_01/EOAAP/map_vcher_trsctn_to_btch_ip.htm#EOAAP00422 on the operation of the F0411Z1 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"

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

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
cBatchFileDiscountHandlinCHARACTEROPTIONALIN
mnUserAddressNumberINTEGEROPTIONALIN
szCompanyKeyCOMPANYOPTIONALIN
mnDocVoucherInvoiceEINTEGEROPTIONALIN
szDocumentTypeUDCOPTIONALIN
szDocumentPayItemSTRINGOPTIONALIN
mnPayItemExtensionNumberINTEGEROPTIONALIN
szDocumentTypeAdjustingUDCOPTIONALIN
mnAddressNumberADDRESSNUMBEROPTIONALIN
mnPayeeAddressNumberADDRESSNUMBEROPTIONALIN
mnAddressNumberSentToADDRESSNUMBEROPTIONALIN
jdDateInvoiceJDATEOPTIONALIN
jdDateServiceCurrencyDATEOPTIONALIN
jdDateDueJulianDATEOPTIONALIN
jdDateDiscountDueJulianDATEOPTIONALIN
jdDateForGLandVoucherJULIADATEOPTIONALIN
mnFiscalYear1INTEGEROPTIONALIN
mnCenturyINTEGEROPTIONALIN
mnPeriodNoGeneralLedgeINTEGEROPTIONALIN
szCompanyCOMPANYOPTIONALIN
mnBatchNumberINTEGEROPTIONALIN
szBatchTypeUDCOPTIONALIN
jdDateBatchJulianDATEOPTIONALIN
cBalancedJournalEntriesUDCOPTIONALIN
cPayStatusCodeUDCOPTIONALIN
mnAmountGrossFLOATOPTIONALIN
mnAmountOpenFLOATOPTIONALIN
mnAmtDiscountAvailableFLOATOPTIONALIN
mnAmountDiscountTakenFLOATOPTIONALIN
mnAmountTaxableFLOATOPTIONALIN
mnAmountTaxExemptFLOATOPTIONALIN
mnAmtTax2FLOATOPTIONALIN
szTaxArea1STRINGOPTIONALIN
szTaxExplanationCode1UDCOPTIONALIN
cCurrencyModeUDCOPTIONALIN
szCurrencyCodeFromSTRINGOPTIONALIN
mnCurrencyConverRateOvFLOATOPTIONALIN
mnAmountCurrencyFLOATOPTIONALIN
mnAmountForeignOpenFLOATOPTIONALIN
mnForeignDiscountAvailFLOATOPTIONALIN
mnForeignDiscountTakenFLOATOPTIONALIN
mnForeignTaxableAmountFLOATOPTIONALIN
mnForeignTaxExemptFLOATOPTIONALIN
mnForeignTaxAmountFLOATOPTIONALIN
szGlClassSTRINGOPTIONALIN
szGlBankAccountSTRINGOPTIONALIN
cGLPostedCodeCHARACTEROPTIONALIN
cAccountModeGLUDCOPTIONALIN
szAccountId2ACCOUNTIDOPTIONALIN
szCostCenterBUSINESSUNITOPTIONALIN
szObjectAccountSTRINGOPTIONALIN
szSubsidiarySTRINGOPTIONALIN
cSubledgerTypeUDCOPTIONALIN
szSubledgerSTRINGOPTIONALIN
szBankTransitShortIdSTRINGOPTIONALIN
szPaymentTermsCode01STRINGOPTIONALIN
cVoidFlagCHARACTEROPTIONALIN
szCompanyKeyOriginalCOMPANYOPTIONALIN
szOriginalDocumentTypeUDCOPTIONALIN
mnOriginalDocumentNoINTEGEROPTIONALIN
szOriginalDocPayItemSTRINGOPTIONALIN
szCheckRoutingCodeUDCOPTIONALIN
szVendorInvoiceNumberSTRINGOPTIONALIN
szCompanyKeyPurchaseCOMPANYOPTIONALIN
szPurchaseOrderSTRINGOPTIONALIN
szDocumentTypePurchaseUDCOPTIONALIN
mnLineNumberFLOATOPTIONALIN
szOrderSuffixSTRINGOPTIONALIN
mnSequenceNoOperationsFLOATOPTIONALIN
szReference1STRINGOPTIONALIN
szUnitNoSTRINGOPTIONALIN
szCostCenter2BUSINESSUNITOPTIONALIN
szNameRemarkSTRINGOPTIONALIN
szFrequencyRecurringUDCOPTIONALIN
mnRecurFrequencyOfPaymINTEGEROPTIONALIN
szAPChecksControlFieldSTRINGOPTIONALIN
cFinalPaymentCHARACTEROPTIONALIN
mnUnitsFLOATOPTIONALIN
szUnitOfMeasureUDCOPTIONALIN
cPaymentInstrumentUDCOPTIONALIN
szTaxRateArea3WithholdingSTRINGOPTIONALIN
szTaxExplCode3WithhholdingUDCOPTIONALIN
cArApMiscCode1CHARACTEROPTIONALIN
cArApMiscCode2CHARACTEROPTIONALIN
cArApMiscCode3CHARACTEROPTIONALIN
szReportCodeAddBook007UDCOPTIONALIN
cFlagFor1099CHARACTEROPTIONALIN
cDomesticEntryWMultCurrencyCHARACTEROPTIONALIN
mnIdentifierShortItemSHORTITEMOPTIONALIN
mnHistoricalCurrencyConverFLOATOPTIONALIN
jdHistoricalDateJulianDATEOPTIONALIN
szUserReserveCodeSTRINGOPTIONALIN
jdUserReservedDateDATEOPTIONALIN
mnUserReservedAmountFLOATOPTIONALIN
mnUserReservedNumberINTEGEROPTIONALIN
szUserReservedReferenceSTRINGOPTIONALIN
szTransactionOriginatorSTRINGOPTIONALIN
szUserIdSTRINGOPTIONALIN
szProgramIdSTRINGOPTIONALIN
jdDateUpdatedDATEOPTIONALIN
mnTimeLastUpdatedINTEGEROPTIONALIN
szWorkStationIdSTRINGOPTIONALIN
mnDateInvoiceMoINTEGEROPTIONALIN
mnDateInvoiceDaAINTEGEROPTIONALIN
mnDateInvoiceYrINTEGEROPTIONALIN
mnDteServiceShipProdMoINTEGEROPTIONALIN
mnDteServiceShipProdDaINTEGEROPTIONALIN
mnDteServiceShipProdYrINTEGEROPTIONALIN
mnDateDueMoINTEGEROPTIONALIN
mnDateDueDaINTEGEROPTIONALIN
mnDateDueYrINTEGEROPTIONALIN
mnDiscountDueMonthINTEGEROPTIONALIN
mnDiscountDueDaysINTEGEROPTIONALIN
mnDiscountDueYearINTEGEROPTIONALIN
mnDtForGLAndVouchMoINTEGEROPTIONALIN
mnDtForGLAndVouchDaINTEGEROPTIONALIN
mnDtForGLAndVouchYrINTEGEROPTIONALIN
mnDateBatch1MoINTEGEROPTIONALIN
mnDateBatch1DaINTEGEROPTIONALIN
mnDateBatch1YrINTEGEROPTIONALIN
mnHistoricalDateMoINTEGEROPTIONALIN
mnHistoricalDateDaINTEGEROPTIONALIN
mnHistoricalDateYrINTEGEROPTIONALIN
mnDocMatchingCheckOrINTEGEROPTIONALIN
szBankTransitNumberSTRINGOPTIONALIN
szCategoryCodeAccountsP001UDCOPTIONALIN
szCategoryCodeAccountsP002UDCOPTIONALIN
szCategoryCodeAccountsP003UDCOPTIONALIN
szCategoryCodeAccountsP004UDCOPTIONALIN
szCategoryCodeAccountsP005UDCOPTIONALIN
szCategoryCodeAccountsP006UDCOPTIONALIN
szCategoryCodeAccountsP007UDCOPTIONALIN
szCategoryCodeAccountsP008UDCOPTIONALIN
szCategoryCodeAccountsP009UDCOPTIONALIN
szCategoryCodeAccountsP010UDCOPTIONALIN
cDeferredTaxStatusVATCHARACTEROPTIONALIN
szCurrencyCodeBaseSTRINGOPTIONALIN
mnAmountToDistributeFLOATOPTIONALIN
mnAmountToDistributeCurFLOATOPTIONALIN
mnNonRecoverableTaxAmtFLOATOPTIONALIN
mnForeignNonRecoverableTaxFLOATOPTIONALIN
cPurchasingTaxableYNCHARACTEROPTIONALIN
cPurgeFlagCHARACTEROPTIONALIN
cGenericFlag5CHARACTEROPTIONALIN
cGenericFlag6CHARACTEROPTIONALIN
mnGenericAmount1FLOATOPTIONALIN
mnGenericAmount2FLOATOPTIONALIN
szGenericString4STRINGOPTIONALIN
szGenericString5STRINGOPTIONALIN
mnAmountwithholdingtaxdomFLOATOPTIONALIN
mnAmountwithholdingtaxforFLOATOPTIONALIN
cSummarizedFlagCHARACTEROPTIONALIN
cPayWhenPaidCHARACTEROPTIONALIN
mnPayWhenPaidGroupNumberINTEGEROPTIONALIN
cNetStatusCodeUDCOPTIONALIN
cAutomationFlagCHARACTEROPTIONALIN
szAutomationRuleSTRINGOPTIONALIN
mnJobnumberAINTEGEROPTIONALIN
cProcessTypeCHARACTEROPTIONALIN
mnDateInvoiceCtryINTEGEROPTIONALIN
mnDteServiceShipProdCtINTEGEROPTIONALIN
mnDateDueCtryINTEGEROPTIONALIN
mnDateDueNetDaysCtryINTEGEROPTIONALIN
mnDtForGLAndVouchCtINTEGEROPTIONALIN
mnDateBatch1CtryINTEGEROPTIONALIN
mnHistoricalDateCtryINTEGEROPTIONALIN
cSuppressErrorMessagesCHARACTEROPTIONALIN
szErrorMessageCodeSTRINGOPTIONALOUT
JavaScript errors detected

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

If this problem persists, please contact our support.