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
Name | Type | Inclusion | Direction |
---|---|---|---|
szEdiUserId | STRING | OPTIONAL | BOTH |
cEDIType | UDC | OPTIONAL | IN |
mnEDISeq | INTEGER | OPTIONAL | IN |
szEdiTransactNumber | STRING | OPTIONAL | BOTH |
szEdiDocumentType | STRING | OPTIONAL | IN |
mnEdiLineNumber | FLOAT | OPTIONAL | BOTH |
szEdiTransSet | STRING | OPTIONAL | IN |
szEdiTranslationFormat | STRING | OPTIONAL | IN |
jdEdiTransmissionDate | DATE | OPTIONAL | IN |
cEdiSendRcvIndicator | UDC | OPTIONAL | IN |
mnEdiDetailLinesProcess | INTEGER | OPTIONAL | IN |
cEdiSuccessfullyProcess | CHARACTER | OPTIONAL | IN |
cEdiTransactionAction | CHARACTER | OPTIONAL | IN |
cEdiTransactionType | CHARACTER | OPTIONAL | IN |
szEdiBatchNumber | STRING | OPTIONAL | BOTH |
cEdiCreateGl | CHARACTER | OPTIONAL | IN |
cBatchFileDiscountHandlin | CHARACTER | OPTIONAL | IN |
mnUserAddressNumber | INTEGER | OPTIONAL | IN |
mnDocVoucherInvoiceE | INTEGER | OPTIONAL | IN |
szDocumentType | UDC | OPTIONAL | IN |
szCompanyKey | COMPANY | OPTIONAL | IN |
szDocumentPayItem | STRING | OPTIONAL | IN |
mnAddressNumber | ADDRESSNUMBER | OPTIONAL | IN |
jdDateForGLandVoucherJULIA | DATE | OPTIONAL | IN |
szBatchType | UDC | OPTIONAL | IN |
mnBatchNumber | INTEGER | OPTIONAL | IN |
jdDateBatchJulian | DATE | OPTIONAL | IN |
mnFiscalYear1 | INTEGER | OPTIONAL | IN |
mnCentury | INTEGER | OPTIONAL | IN |
mnPeriodNoGeneralLedge | INTEGER | OPTIONAL | IN |
szCompany | COMPANY | OPTIONAL | IN |
szGlClass | STRING | OPTIONAL | IN |
szAccountId | ACCOUNTID | OPTIONAL | IN |
mnAddressNumberParent | ADDRESSNUMBER | OPTIONAL | IN |
mnAddNoAlternatePayee | ADDRESSNUMBER | OPTIONAL | IN |
mnPayorAddressNumber | ADDRESSNUMBER | OPTIONAL | IN |
cGLPostedCode | CHARACTER | OPTIONAL | IN |
cPostStatusReceivables | CHARACTER | OPTIONAL | IN |
cBalancedJournalEntries | UDC | OPTIONAL | IN |
cPayStatusCode | UDC | OPTIONAL | IN |
mnAmountGross | FLOAT | OPTIONAL | IN |
mnAmountOpen | FLOAT | OPTIONAL | IN |
mnAmtDiscountAvailable | FLOAT | OPTIONAL | IN |
mnAmountDiscountTaken | FLOAT | OPTIONAL | IN |
mnAmountTaxable | FLOAT | OPTIONAL | IN |
mnAmountTaxExempt | FLOAT | OPTIONAL | IN |
mnAmtTax2 | FLOAT | OPTIONAL | IN |
cCurrencyMode | UDC | OPTIONAL | IN |
szCurrencyCodeFrom | STRING | OPTIONAL | IN |
mnCurrencyConverRateOv | FLOAT | OPTIONAL | IN |
cDomesticEntryWMultCurrency | CHARACTER | OPTIONAL | IN |
mnAmountCurrency | FLOAT | OPTIONAL | IN |
mnAmountForeignOpen | FLOAT | OPTIONAL | IN |
mnForeignDiscountAvail | FLOAT | OPTIONAL | IN |
mnForeignDiscountTaken | FLOAT | OPTIONAL | IN |
mnForeignTaxableAmount | FLOAT | OPTIONAL | IN |
mnForeignTaxExempt | FLOAT | OPTIONAL | IN |
mnForeignTaxAmount | FLOAT | OPTIONAL | IN |
szTaxArea1 | STRING | OPTIONAL | IN |
szTaxExplanationCode1 | UDC | OPTIONAL | IN |
szGlBankAccount | STRING | OPTIONAL | IN |
cAccountModeGL | UDC | OPTIONAL | IN |
szAccountId2 | ACCOUNTID | OPTIONAL | IN |
cAccountModeGL2 | UDC | OPTIONAL | IN |
szCostCenter | BUSINESSUNIT | OPTIONAL | IN |
szObjectAccount | STRING | OPTIONAL | IN |
szSubsidiary | STRING | OPTIONAL | IN |
cSubledgerType | UDC | OPTIONAL | IN |
szSubledger | STRING | OPTIONAL | IN |
szPaymentTermsCode01 | STRING | OPTIONAL | IN |
jdDateDueJulian | DATE | OPTIONAL | IN |
jdDateDiscountDueJulian | DATE | OPTIONAL | IN |
jdDateofLastSentReminderJU | DATE | OPTIONAL | IN |
jdDateReminderStopUntilDat | DATE | OPTIONAL | IN |
jdDateStatementJulian | DATE | OPTIONAL | IN |
cNumberReminders | UDC | OPTIONAL | IN |
cLevelLastReminder | CHARACTER | OPTIONAL | IN |
mnTotalSentReminders | INTEGER | OPTIONAL | IN |
cCollectionReport | UDC | OPTIONAL | IN |
szCollectReasonCode | UDC | OPTIONAL | IN |
cApplyFinChargesYN | UDC | OPTIONAL | IN |
szReasnCode | UDC | OPTIONAL | IN |
szCkNumber | STRING | OPTIONAL | IN |
mnOriginalDocumentNo | INTEGER | OPTIONAL | IN |
szOriginalDocumentType | UDC | OPTIONAL | IN |
szCompanyKeyOriginal | COMPANY | OPTIONAL | IN |
szOriginalDocPayItem | STRING | OPTIONAL | IN |
szVendorInvoiceNumber | STRING | OPTIONAL | IN |
szPurchaseOrder | STRING | OPTIONAL | IN |
szDocumentTypePurchase | UDC | OPTIONAL | IN |
szCompanyKeyPurchase | COMPANY | OPTIONAL | IN |
szOrderType | UDC | OPTIONAL | IN |
mnLineNumber | FLOAT | OPTIONAL | IN |
mnDocumentSales | INTEGER | OPTIONAL | IN |
szDocumentTypeSales | UDC | OPTIONAL | IN |
szCompanyKeySalesOrd | COMPANY | OPTIONAL | IN |
szOrderSuffix | STRING | OPTIONAL | IN |
jdDateValue | DATE | OPTIONAL | IN |
mnCommissionCode1 | ADDRESSNUMBER | OPTIONAL | IN |
szReference1 | STRING | OPTIONAL | IN |
szUnitNo | STRING | OPTIONAL | IN |
szCostCenter2 | BUSINESSUNIT | OPTIONAL | IN |
szNameRemark | STRING | OPTIONAL | IN |
szNameAlpha | STRING | OPTIONAL | IN |
szFrequencyRecurring | UDC | OPTIONAL | IN |
mnRecurFrequencyOfPaym | INTEGER | OPTIONAL | IN |
szAPChecksControlField | STRING | OPTIONAL | IN |
cFinalPayment | CHARACTER | OPTIONAL | IN |
mnIdentifierShortItem | SHORTITEM | OPTIONAL | IN |
mnUnits | FLOAT | OPTIONAL | IN |
szUnitOfMeasure | UDC | OPTIONAL | IN |
cGLPostCodeAlt006 | CHARACTER | OPTIONAL | IN |
cPaymentInstrumentA | UDC | OPTIONAL | IN |
jdVoidDateForGLJulian | DATE | OPTIONAL | IN |
szVoidReasonCode | UDC | OPTIONAL | IN |
cArApMiscCode1 | CHARACTER | OPTIONAL | IN |
cArApMiscCode2 | CHARACTER | OPTIONAL | IN |
cArApMiscCode3 | CHARACTER | OPTIONAL | IN |
szARreportingCode1n | UDC | OPTIONAL | IN |
szARreportingCode2 | UDC | OPTIONAL | IN |
szARreportingCode3 | UDC | OPTIONAL | IN |
szARreportingCode4 | UDC | OPTIONAL | IN |
szARreportingCode5 | UDC | OPTIONAL | IN |
szARReportingCode6 | UDC | OPTIONAL | IN |
szARReportingCode7 | UDC | OPTIONAL | IN |
szARReportingCode8 | UDC | OPTIONAL | IN |
szARReportingCode9 | UDC | OPTIONAL | IN |
szARReportingCode10 | UDC | OPTIONAL | IN |
szUserReserveCode | STRING | OPTIONAL | IN |
jdUserReservedDate | DATE | OPTIONAL | IN |
mnUserReservedAmount | FLOAT | OPTIONAL | IN |
mnUserReservedNumber | INTEGER | OPTIONAL | IN |
szUserReservedReference | STRING | OPTIONAL | IN |
szTransactionOriginator | STRING | OPTIONAL | IN |
szUserId | STRING | OPTIONAL | IN |
szProgramId | STRING | OPTIONAL | IN |
jdDateUpdated | DATE | OPTIONAL | IN |
mnTimeLastUpdated | INTEGER | OPTIONAL | IN |
szWorkStationId | STRING | OPTIONAL | IN |
mnHistoricalCurrencyConver | FLOAT | OPTIONAL | IN |
jdHistoricalDateJulian | DATE | OPTIONAL | IN |
mnDateInvoiceMo | INTEGER | OPTIONAL | IN |
mnDateInvoiceDaA | INTEGER | OPTIONAL | IN |
mnDateInvoiceYr | INTEGER | OPTIONAL | IN |
mnDtForGLAndVouchMo | INTEGER | OPTIONAL | IN |
mnDtForGLAndVouchDa | INTEGER | OPTIONAL | IN |
mnDtForGLAndVouchYr | INTEGER | OPTIONAL | IN |
mnDateBatch1Mo | INTEGER | OPTIONAL | IN |
mnDateBatch1Da | INTEGER | OPTIONAL | IN |
mnDateBatch1Yr | INTEGER | OPTIONAL | IN |
mnDteServiceShipProdMo | INTEGER | OPTIONAL | IN |
mnDteServiceShipProdDa | INTEGER | OPTIONAL | IN |
mnDteServiceShipProdYr | INTEGER | OPTIONAL | IN |
mnDateDueMo | INTEGER | OPTIONAL | IN |
mnDateDueDa | INTEGER | OPTIONAL | IN |
mnDateDueYr | INTEGER | OPTIONAL | IN |
mnDiscountDueMonth | INTEGER | OPTIONAL | IN |
mnDiscountDueDays | INTEGER | OPTIONAL | IN |
mnDiscountDueYear | INTEGER | OPTIONAL | IN |
mnDateStatementMo | INTEGER | OPTIONAL | IN |
mnDateStatementDa | INTEGER | OPTIONAL | IN |
mnDateStatementYr | INTEGER | OPTIONAL | IN |
mnDateLastReminderMo | INTEGER | OPTIONAL | IN |
mnDateLastReminderDa | INTEGER | OPTIONAL | IN |
mnDateLastReminderYr | INTEGER | OPTIONAL | IN |
mnReminderStopUntilMo | INTEGER | OPTIONAL | IN |
mnReminderStopUntilDa | INTEGER | OPTIONAL | IN |
mnReminderStopUntilYr | INTEGER | OPTIONAL | IN |
mnHistoricalDateMo | INTEGER | OPTIONAL | IN |
mnHistoricalDateDa | INTEGER | OPTIONAL | IN |
mnHistoricalDateYr | INTEGER | OPTIONAL | IN |
mnShipmentNumber | INTEGER | OPTIONAL | IN |
cDeferredTaxStatusVAT | CHARACTER | OPTIONAL | IN |
cOriginatingSystem | UDC | OPTIONAL | IN |
szCollectionManager | UDC | OPTIONAL | IN |
szCreditManager | UDC | OPTIONAL | IN |
mnAmountToDistribute | FLOAT | OPTIONAL | IN |
mnAmountToDistributeCur | FLOAT | OPTIONAL | IN |
mnNonRecoverableTaxAmt | FLOAT | OPTIONAL | IN |
mnForeignNonRecoverableTax | FLOAT | OPTIONAL | IN |
cPurgeFlag | CHARACTER | OPTIONAL | IN |
cGenericFlag1 | CHARACTER | OPTIONAL | IN |
cGenericFlag2 | CHARACTER | OPTIONAL | IN |
mnDocumentOrderInvoiceE | INTEGER | OPTIONAL | IN |
szCompanyKeyOrderNo | COMPANY | OPTIONAL | IN |
cSalesOrderTaxFlag | CHARACTER | OPTIONAL | IN |
jdNotification_Payment_Date | DATE | OPTIONAL | IN |
jdExchangeRateDate | DATE | OPTIONAL | IN |
cNetStatusCode | UDC | OPTIONAL | IN |
szReceiptMatchingReference1 | STRING | OPTIONAL | IN |
cSuppressErrors | CHARACTER | OPTIONAL | IN |
szErrorMessageItem | STRING | OPTIONAL | OUT |
mnDateInvoiceCtry | INTEGER | OPTIONAL | IN |
jdDateServiceCurrency | DATE | OPTIONAL | IN |
mnDtForGLAndVouchCt | INTEGER | OPTIONAL | IN |
mnDateBatch1Ctry | INTEGER | OPTIONAL | IN |
mnDteServiceShipProdCt | INTEGER | OPTIONAL | IN |
mnDateDueCtry | INTEGER | OPTIONAL | IN |
mnDateDueNetDaysCtry | INTEGER | OPTIONAL | IN |
mnDateStatementCtry | INTEGER | OPTIONAL | IN |
mnDateLastReminderCtry | INTEGER | OPTIONAL | IN |
mnReminderStopUntilCtry | INTEGER | OPTIONAL | IN |
mnHistoricalDateCtry | INTEGER | OPTIONAL | IN |
jdDateInvoiceJ | DATE | OPTIONAL | IN |