Skip to main content

Q35CreateF03B11Z1Line

Q35InsertF03B11Z1Record inserts a record into the F03B11Z1 interface table.

How to Use

Please refer to the Oracle documentation available at https://docs.oracle.com/cd/E64610_01/EOAAR/mapfieldforbatchinvoice.htm#EOAAR00870 on the operation of the F03B11Z1 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"

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

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
mnDocVoucherInvoiceEINTEGEROPTIONALIN
szDocumentTypeUDCOPTIONALIN
szCompanyKeyCOMPANYOPTIONALIN
szDocumentPayItemSTRINGOPTIONALIN
mnAddressNumberADDRESSNUMBEROPTIONALIN
jdDateForGLandVoucherJULIADATEOPTIONALIN
szBatchTypeUDCOPTIONALIN
mnBatchNumberINTEGEROPTIONALIN
jdDateBatchJulianDATEOPTIONALIN
mnFiscalYear1INTEGEROPTIONALIN
mnCenturyINTEGEROPTIONALIN
mnPeriodNoGeneralLedgeINTEGEROPTIONALIN
szCompanyCOMPANYOPTIONALIN
szGlClassSTRINGOPTIONALIN
szAccountIdACCOUNTIDOPTIONALIN
mnAddressNumberParentADDRESSNUMBEROPTIONALIN
mnAddNoAlternatePayeeADDRESSNUMBEROPTIONALIN
mnPayorAddressNumberADDRESSNUMBEROPTIONALIN
cGLPostedCodeCHARACTEROPTIONALIN
cPostStatusReceivablesCHARACTEROPTIONALIN
cBalancedJournalEntriesUDCOPTIONALIN
cPayStatusCodeUDCOPTIONALIN
mnAmountGrossFLOATOPTIONALIN
mnAmountOpenFLOATOPTIONALIN
mnAmtDiscountAvailableFLOATOPTIONALIN
mnAmountDiscountTakenFLOATOPTIONALIN
mnAmountTaxableFLOATOPTIONALIN
mnAmountTaxExemptFLOATOPTIONALIN
mnAmtTax2FLOATOPTIONALIN
cCurrencyModeUDCOPTIONALIN
szCurrencyCodeFromSTRINGOPTIONALIN
mnCurrencyConverRateOvFLOATOPTIONALIN
cDomesticEntryWMultCurrencyCHARACTEROPTIONALIN
mnAmountCurrencyFLOATOPTIONALIN
mnAmountForeignOpenFLOATOPTIONALIN
mnForeignDiscountAvailFLOATOPTIONALIN
mnForeignDiscountTakenFLOATOPTIONALIN
mnForeignTaxableAmountFLOATOPTIONALIN
mnForeignTaxExemptFLOATOPTIONALIN
mnForeignTaxAmountFLOATOPTIONALIN
szTaxArea1STRINGOPTIONALIN
szTaxExplanationCode1UDCOPTIONALIN
szGlBankAccountSTRINGOPTIONALIN
cAccountModeGLUDCOPTIONALIN
szAccountId2ACCOUNTIDOPTIONALIN
cAccountModeGL2UDCOPTIONALIN
szCostCenterBUSINESSUNITOPTIONALIN
szObjectAccountSTRINGOPTIONALIN
szSubsidiarySTRINGOPTIONALIN
cSubledgerTypeUDCOPTIONALIN
szSubledgerSTRINGOPTIONALIN
szPaymentTermsCode01STRINGOPTIONALIN
jdDateDueJulianDATEOPTIONALIN
jdDateDiscountDueJulianDATEOPTIONALIN
jdDateofLastSentReminderJUDATEOPTIONALIN
jdDateReminderStopUntilDatDATEOPTIONALIN
jdDateStatementJulianDATEOPTIONALIN
cNumberRemindersUDCOPTIONALIN
cLevelLastReminderCHARACTEROPTIONALIN
mnTotalSentRemindersINTEGEROPTIONALIN
cCollectionReportUDCOPTIONALIN
szCollectReasonCodeUDCOPTIONALIN
cApplyFinChargesYNUDCOPTIONALIN
szReasnCodeUDCOPTIONALIN
szCkNumberSTRINGOPTIONALIN
mnOriginalDocumentNoINTEGEROPTIONALIN
szOriginalDocumentTypeUDCOPTIONALIN
szCompanyKeyOriginalCOMPANYOPTIONALIN
szOriginalDocPayItemSTRINGOPTIONALIN
szVendorInvoiceNumberSTRINGOPTIONALIN
szPurchaseOrderSTRINGOPTIONALIN
szDocumentTypePurchaseUDCOPTIONALIN
szCompanyKeyPurchaseCOMPANYOPTIONALIN
szOrderTypeUDCOPTIONALIN
mnLineNumberFLOATOPTIONALIN
mnDocumentSalesINTEGEROPTIONALIN
szDocumentTypeSalesUDCOPTIONALIN
szCompanyKeySalesOrdCOMPANYOPTIONALIN
szOrderSuffixSTRINGOPTIONALIN
jdDateValueDATEOPTIONALIN
mnCommissionCode1ADDRESSNUMBEROPTIONALIN
szReference1STRINGOPTIONALIN
szUnitNoSTRINGOPTIONALIN
szCostCenter2BUSINESSUNITOPTIONALIN
szNameRemarkSTRINGOPTIONALIN
szNameAlphaSTRINGOPTIONALIN
szFrequencyRecurringUDCOPTIONALIN
mnRecurFrequencyOfPaymINTEGEROPTIONALIN
szAPChecksControlFieldSTRINGOPTIONALIN
cFinalPaymentCHARACTEROPTIONALIN
mnIdentifierShortItemSHORTITEMOPTIONALIN
mnUnitsFLOATOPTIONALIN
szUnitOfMeasureUDCOPTIONALIN
cGLPostCodeAlt006CHARACTEROPTIONALIN
cPaymentInstrumentAUDCOPTIONALIN
jdVoidDateForGLJulianDATEOPTIONALIN
szVoidReasonCodeUDCOPTIONALIN
cArApMiscCode1CHARACTEROPTIONALIN
cArApMiscCode2CHARACTEROPTIONALIN
cArApMiscCode3CHARACTEROPTIONALIN
szARreportingCode1nUDCOPTIONALIN
szARreportingCode2UDCOPTIONALIN
szARreportingCode3UDCOPTIONALIN
szARreportingCode4UDCOPTIONALIN
szARreportingCode5UDCOPTIONALIN
szARReportingCode6UDCOPTIONALIN
szARReportingCode7UDCOPTIONALIN
szARReportingCode8UDCOPTIONALIN
szARReportingCode9UDCOPTIONALIN
szARReportingCode10UDCOPTIONALIN
szUserReserveCodeSTRINGOPTIONALIN
jdUserReservedDateDATEOPTIONALIN
mnUserReservedAmountFLOATOPTIONALIN
mnUserReservedNumberINTEGEROPTIONALIN
szUserReservedReferenceSTRINGOPTIONALIN
szTransactionOriginatorSTRINGOPTIONALIN
szUserIdSTRINGOPTIONALIN
szProgramIdSTRINGOPTIONALIN
jdDateUpdatedDATEOPTIONALIN
mnTimeLastUpdatedINTEGEROPTIONALIN
szWorkStationIdSTRINGOPTIONALIN
mnHistoricalCurrencyConverFLOATOPTIONALIN
jdHistoricalDateJulianDATEOPTIONALIN
mnDateInvoiceMoINTEGEROPTIONALIN
mnDateInvoiceDaAINTEGEROPTIONALIN
mnDateInvoiceYrINTEGEROPTIONALIN
mnDtForGLAndVouchMoINTEGEROPTIONALIN
mnDtForGLAndVouchDaINTEGEROPTIONALIN
mnDtForGLAndVouchYrINTEGEROPTIONALIN
mnDateBatch1MoINTEGEROPTIONALIN
mnDateBatch1DaINTEGEROPTIONALIN
mnDateBatch1YrINTEGEROPTIONALIN
mnDteServiceShipProdMoINTEGEROPTIONALIN
mnDteServiceShipProdDaINTEGEROPTIONALIN
mnDteServiceShipProdYrINTEGEROPTIONALIN
mnDateDueMoINTEGEROPTIONALIN
mnDateDueDaINTEGEROPTIONALIN
mnDateDueYrINTEGEROPTIONALIN
mnDiscountDueMonthINTEGEROPTIONALIN
mnDiscountDueDaysINTEGEROPTIONALIN
mnDiscountDueYearINTEGEROPTIONALIN
mnDateStatementMoINTEGEROPTIONALIN
mnDateStatementDaINTEGEROPTIONALIN
mnDateStatementYrINTEGEROPTIONALIN
mnDateLastReminderMoINTEGEROPTIONALIN
mnDateLastReminderDaINTEGEROPTIONALIN
mnDateLastReminderYrINTEGEROPTIONALIN
mnReminderStopUntilMoINTEGEROPTIONALIN
mnReminderStopUntilDaINTEGEROPTIONALIN
mnReminderStopUntilYrINTEGEROPTIONALIN
mnHistoricalDateMoINTEGEROPTIONALIN
mnHistoricalDateDaINTEGEROPTIONALIN
mnHistoricalDateYrINTEGEROPTIONALIN
mnShipmentNumberINTEGEROPTIONALIN
cDeferredTaxStatusVATCHARACTEROPTIONALIN
cOriginatingSystemUDCOPTIONALIN
szCollectionManagerUDCOPTIONALIN
szCreditManagerUDCOPTIONALIN
mnAmountToDistributeFLOATOPTIONALIN
mnAmountToDistributeCurFLOATOPTIONALIN
mnNonRecoverableTaxAmtFLOATOPTIONALIN
mnForeignNonRecoverableTaxFLOATOPTIONALIN
cPurgeFlagCHARACTEROPTIONALIN
cGenericFlag1CHARACTEROPTIONALIN
cGenericFlag2CHARACTEROPTIONALIN
mnDocumentOrderInvoiceEINTEGEROPTIONALIN
szCompanyKeyOrderNoCOMPANYOPTIONALIN
cSalesOrderTaxFlagCHARACTEROPTIONALIN
jdNotification_Payment_DateDATEOPTIONALIN
jdExchangeRateDateDATEOPTIONALIN
cNetStatusCodeUDCOPTIONALIN
szReceiptMatchingReference1STRINGOPTIONALIN
cSuppressErrorsCHARACTEROPTIONALIN
szErrorMessageItemSTRINGOPTIONALOUT
mnDateInvoiceCtryINTEGEROPTIONALIN
jdDateServiceCurrencyDATEOPTIONALIN
mnDtForGLAndVouchCtINTEGEROPTIONALIN
mnDateBatch1CtryINTEGEROPTIONALIN
mnDteServiceShipProdCtINTEGEROPTIONALIN
mnDateDueCtryINTEGEROPTIONALIN
mnDateDueNetDaysCtryINTEGEROPTIONALIN
mnDateStatementCtryINTEGEROPTIONALIN
mnDateLastReminderCtryINTEGEROPTIONALIN
mnReminderStopUntilCtryINTEGEROPTIONALIN
mnHistoricalDateCtryINTEGEROPTIONALIN
jdDateInvoiceJDATEOPTIONALIN
JavaScript errors detected

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

If this problem persists, please contact our support.