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
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 |
mnUserAddressNumber | INTEGER | OPTIONAL | IN |
szCompanyKey | COMPANY | OPTIONAL | IN |
szDocumentType | UDC | OPTIONAL | IN |
mnDocVoucherInvoiceE | INTEGER | OPTIONAL | IN |
jdDateForGLandVoucherJULIA | DATE | OPTIONAL | IN |
mnJournalEntryLineNo | FLOAT | OPTIONAL | IN |
szLineExtensionCode | STRING | OPTIONAL | IN |
cGLPostedCode | CHARACTER | OPTIONAL | IN |
mnBatchNumber | INTEGER | OPTIONAL | IN |
szBatchType | UDC | OPTIONAL | IN |
jdDateBatchJulian | DATE | OPTIONAL | IN |
jdDateBatchSystemDateJuliA | DATE | OPTIONAL | IN |
mnBatchTime | INTEGER | OPTIONAL | IN |
szCompany | COMPANY | OPTIONAL | IN |
szAcctNoInputMode | STRING | OPTIONAL | IN |
cAccountModeGL | UDC | OPTIONAL | IN |
szAccountId | ACCOUNTID | OPTIONAL | IN |
szCostCenter | BUSINESSUNIT | OPTIONAL | IN |
szObjectAccount | STRING | OPTIONAL | IN |
szSubsidiary | STRING | OPTIONAL | IN |
szSubledger | STRING | OPTIONAL | IN |
cSubledgerType | UDC | OPTIONAL | IN |
szLedgerType | UDC | OPTIONAL | IN |
mnPeriodNoGeneralLedge | INTEGER | OPTIONAL | IN |
mnCentury | INTEGER | OPTIONAL | IN |
mnFiscalYear1 | INTEGER | OPTIONAL | IN |
szFiscalQtrFutureUse | UDC | OPTIONAL | IN |
szCurrencyCodeFrom | STRING | OPTIONAL | IN |
mnCurrencyConverRateOv | FLOAT | OPTIONAL | IN |
mnHistoricalCurrencyConver | FLOAT | OPTIONAL | IN |
jdHistoricalDateJulian | DATE | OPTIONAL | IN |
mnAmountField | FLOAT | OPTIONAL | IN |
mnUnits | FLOAT | OPTIONAL | IN |
szUnitOfMeasure | UDC | OPTIONAL | IN |
szGlClass | STRING | OPTIONAL | IN |
cReverseOrVoidRV | UDC | OPTIONAL | IN |
szNameAlphaExplanation | STRING | OPTIONAL | IN |
szNameRemarkExplanation | STRING | OPTIONAL | IN |
szReference1JeVouchIn | STRING | OPTIONAL | IN |
szReference2 | STRING | OPTIONAL | IN |
szReference3AccountReconci | STRING | OPTIONAL | IN |
szDocumentPayItem | STRING | OPTIONAL | IN |
mnOriginalDocumentNo | INTEGER | OPTIONAL | IN |
szOriginalDocumentType | UDC | OPTIONAL | IN |
szOriginalDocPayItem | STRING | OPTIONAL | IN |
szCompanyKeyPurchase | COMPANY | OPTIONAL | IN |
szCompanyKeyOriginal | COMPANY | OPTIONAL | IN |
szDocumentTypePurchase | UDC | OPTIONAL | IN |
mnAddressNumber | ADDRESSNUMBER | OPTIONAL | IN |
szCheckNumber | STRING | OPTIONAL | IN |
jdDateCheckJ | DATE | OPTIONAL | IN |
jdDateCheckCleared | DATE | OPTIONAL | IN |
szSerialTagNumber | STRING | OPTIONAL | IN |
cBatchRearEndPostCode | UDC | OPTIONAL | IN |
cReconciledROrBlank | UDC | OPTIONAL | IN |
cSummarizedCode | CHARACTER | OPTIONAL | IN |
cPurgeCode | CHARACTER | OPTIONAL | IN |
cFlagFor1099 | CHARACTER | OPTIONAL | IN |
cGLPostCodeAlt001 | CHARACTER | OPTIONAL | IN |
cGLPostCodeAlt002 | CHARACTER | OPTIONAL | IN |
cGLPostCodeAlt003 | CHARACTER | OPTIONAL | IN |
cGLPostCodeAlt004 | CHARACTER | OPTIONAL | IN |
cGLPostCodeAlt005 | CHARACTER | OPTIONAL | IN |
cGLPostCodeAlt006 | CHARACTER | OPTIONAL | IN |
cCommitmentReliefFlag | CHARACTER | OPTIONAL | IN |
cBillingControl | CHARACTER | OPTIONAL | IN |
cGLPostCodeAlt009 | CHARACTER | OPTIONAL | IN |
cGLPostCodeAlt000 | CHARACTER | OPTIONAL | IN |
cGLPostingCodeAlternateT | CHARACTER | OPTIONAL | IN |
cGLPostingCodeAlternateU | CHARACTER | OPTIONAL | IN |
cGLPostingCodeAlternateV | CHARACTER | OPTIONAL | IN |
cGLPostingCodeAlternateW | CHARACTER | OPTIONAL | IN |
cGLPostCodeAlt00x | CHARACTER | OPTIONAL | IN |
cGLPostingCodeAlternateZ_A | CHARACTER | OPTIONAL | IN |
cDeleteNotAllowed | CHARACTER | OPTIONAL | IN |
cClientFreeForm1 | CHARACTER | OPTIONAL | IN |
cClientFreeForm2 | CHARACTER | OPTIONAL | IN |
cAssetInputMode | CHARACTER | OPTIONAL | IN |
cBillCode | UDC | OPTIONAL | IN |
szVendorInvoiceNumber | STRING | OPTIONAL | IN |
jdDateInvoiceJulian | DATE | OPTIONAL | IN |
szCategoriesWorkOrder001 | UDC | OPTIONAL | IN |
szPurchaseOrder | STRING | OPTIONAL | IN |
szPurchaseOrderSuffix | STRING | OPTIONAL | IN |
szOrderType | UDC | OPTIONAL | IN |
mnLineNumber | FLOAT | OPTIONAL | IN |
mnWeeklyYear | INTEGER | OPTIONAL | IN |
mnWeeklyPeriod | INTEGER | OPTIONAL | IN |
cFinalPayment | CHARACTER | OPTIONAL | IN |
mnSequenceNoOperations | FLOAT | OPTIONAL | IN |
szJobCategory | UDC | OPTIONAL | IN |
szJobStep | UDC | OPTIONAL | IN |
szCostCenterHome | BUSINESSUNIT | OPTIONAL | IN |
mnDoiSub | INTEGER | OPTIONAL | IN |
szOutsiderLeaseOrWelId | STRING | OPTIONAL | IN |
szIdType | UDC | OPTIONAL | IN |
jdDateServiceCurrency | DATE | OPTIONAL | IN |
szTransactionOriginator | STRING | OPTIONAL | IN |
mnRegistrationNumber | INTEGER | OPTIONAL | IN |
mnPaymentID | INTEGER | OPTIONAL | IN |
szUserId | STRING | OPTIONAL | IN |
szProgramId | STRING | OPTIONAL | IN |
szWorkStationId | STRING | OPTIONAL | IN |
jdDateUpdated | DATE | OPTIONAL | IN |
mnTimeLastUpdated | INTEGER | OPTIONAL | IN |
cCurrencyMode | UDC | OPTIONAL | IN |
mnAmountCurrency | FLOAT | OPTIONAL | IN |
mnDtForGLAndVouchMo | INTEGER | OPTIONAL | IN |
mnDtForGLAndVouchDa | INTEGER | OPTIONAL | IN |
mnDtForGLAndVouchYr | INTEGER | OPTIONAL | IN |
mnDtForGLAndVouchCt | INTEGER | OPTIONAL | IN |
mnDateBatch1Mo | INTEGER | OPTIONAL | IN |
mnDateBatch1Da | INTEGER | OPTIONAL | IN |
mnDateBatch1Yr | INTEGER | OPTIONAL | IN |
mnDateBatch1Ctry | INTEGER | OPTIONAL | IN |
mnDteBatchSysDate1Mo | INTEGER | OPTIONAL | IN |
mnDteBatchSysDate1Da | INTEGER | OPTIONAL | IN |
mnDteBatchSysDate1Yr | INTEGER | OPTIONAL | IN |
mnDteBatchSysDate1Ct | INTEGER | OPTIONAL | IN |
mnDateCheck1Mo | INTEGER | OPTIONAL | IN |
mnDateCheck1Da | INTEGER | OPTIONAL | IN |
mnDateCheck1Yr | INTEGER | OPTIONAL | IN |
mnDateCheck1Ctry | INTEGER | OPTIONAL | IN |
mnDteServiceShipProdMo | INTEGER | OPTIONAL | IN |
mnDteServiceShipProdDa | INTEGER | OPTIONAL | IN |
mnDteServiceShipProdYr | INTEGER | OPTIONAL | IN |
mnDteServiceShipProdCt | INTEGER | OPTIONAL | IN |
mnHistoricalDateMo | INTEGER | OPTIONAL | IN |
mnHistoricalDateDa | INTEGER | OPTIONAL | IN |
mnHistoricalDateYr | INTEGER | OPTIONAL | IN |
mnHistoricalDateCtry | INTEGER | OPTIONAL | IN |
mnDateCheckClearedMO | INTEGER | OPTIONAL | IN |
mnDateCheckClearedDA | INTEGER | OPTIONAL | IN |
mnDateCheckClearedYR | INTEGER | OPTIONAL | IN |
mnDateCheckClearedCTRY | INTEGER | OPTIONAL | IN |
mnDateInvoiceMonth | INTEGER | OPTIONAL | IN |
mnDateInvoiceDA | INTEGER | OPTIONAL | IN |
mnDateInvoiceYEAR | INTEGER | OPTIONAL | IN |
mnDateInvoiceCENTURY | INTEGER | OPTIONAL | IN |
szManagerialAnalysisCode1 | STRING | OPTIONAL | IN |
szManagerialAnalysisCode2 | STRING | OPTIONAL | IN |
szManagerialAnalysisCode3 | STRING | OPTIONAL | IN |
szManagerialAnalysisCode4 | STRING | OPTIONAL | IN |
cManagerialAnalysisType1 | CHARACTER | OPTIONAL | IN |
cManagerialAnalysisType2 | CHARACTER | OPTIONAL | IN |
cManagerialAnalysisType3 | CHARACTER | OPTIONAL | IN |
cManagerialAnalysisType4 | CHARACTER | OPTIONAL | IN |
mnIdentifierShortItem | SHORTITEM | OPTIONAL | IN |
cPostingCode1ManagerialAcc | CHARACTER | OPTIONAL | IN |
cPostingCode2ManagerialAcc | CHARACTER | OPTIONAL | IN |
cPostingCode3ManagerialAcc | CHARACTER | OPTIONAL | IN |
cPostingCode4ManagerialAcc | CHARACTER | OPTIONAL | IN |
cPostingCode5ManagerialAcc | CHARACTER | OPTIONAL | IN |
cPostingCode6ManagerialAcc | CHARACTER | OPTIONAL | IN |
cPostingCode7ManagerialAcc | CHARACTER | OPTIONAL | IN |
cPostingCode8ManagerialAcc | CHARACTER | OPTIONAL | IN |
cPostingCode9ManagerialAcc | CHARACTER | OPTIONAL | IN |
cPostingCode10ManagerialAc | CHARACTER | OPTIONAL | IN |
szCurrencyCodeBase | STRING | OPTIONAL | IN |
szTaxExplanationCode1 | UDC | OPTIONAL | IN |
szTaxArea1 | STRING | OPTIONAL | IN |
mnTaxItemNumber | INTEGER | OPTIONAL | IN |
szActivityCode | STRING | OPTIONAL | IN |
mnAmtTax2 | FLOAT | OPTIONAL | IN |
mnForeignTaxAmount | FLOAT | OPTIONAL | IN |
mnAmountGross | FLOAT | OPTIONAL | IN |
mnForeignAmountGross | FLOAT | OPTIONAL | IN |
cTrackTaxes | CHARACTER | OPTIONAL | IN |
mnDistributionLineNumber | FLOAT | OPTIONAL | IN |
szCkNumber | STRING | OPTIONAL | IN |
cBurdeningPostedCode | CHARACTER | OPTIONAL | IN |
szAlternateHomeBusinessUnit | BUSINESSUNIT | OPTIONAL | IN |
szEmployeePoolGroupingCode | UDC | OPTIONAL | IN |
szJobPoolGroupingCode | UDC | OPTIONAL | IN |
mnFileLineIdentifier50 | INTEGER | OPTIONAL | IN |
mnPayItemExtensionNumber | INTEGER | OPTIONAL | IN |
cAutoOffMethod | CHARACTER | OPTIONAL | IN |
cSuppressErrorMessage | CHARACTER | OPTIONAL | IN |
szErrorCode | STRING | OPTIONAL | OUT |