Q35InsertF0911Z1Record | Rinami Knowledge Garden

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