Q35CreateF0411Z1Line | Rinami Knowledge Garden

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

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
szCompanyKey	COMPANY	OPTIONAL	IN
mnDocVoucherInvoiceE	INTEGER	OPTIONAL	IN
szDocumentType	UDC	OPTIONAL	IN
szDocumentPayItem	STRING	OPTIONAL	IN
mnPayItemExtensionNumber	INTEGER	OPTIONAL	IN
szDocumentTypeAdjusting	UDC	OPTIONAL	IN
mnAddressNumber	ADDRESSNUMBER	OPTIONAL	IN
mnPayeeAddressNumber	ADDRESSNUMBER	OPTIONAL	IN
mnAddressNumberSentTo	ADDRESSNUMBER	OPTIONAL	IN
jdDateInvoiceJ	DATE	OPTIONAL	IN
jdDateServiceCurrency	DATE	OPTIONAL	IN
jdDateDueJulian	DATE	OPTIONAL	IN
jdDateDiscountDueJulian	DATE	OPTIONAL	IN
jdDateForGLandVoucherJULIA	DATE	OPTIONAL	IN
mnFiscalYear1	INTEGER	OPTIONAL	IN
mnCentury	INTEGER	OPTIONAL	IN
mnPeriodNoGeneralLedge	INTEGER	OPTIONAL	IN
szCompany	COMPANY	OPTIONAL	IN
mnBatchNumber	INTEGER	OPTIONAL	IN
szBatchType	UDC	OPTIONAL	IN
jdDateBatchJulian	DATE	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
szTaxArea1	STRING	OPTIONAL	IN
szTaxExplanationCode1	UDC	OPTIONAL	IN
cCurrencyMode	UDC	OPTIONAL	IN
szCurrencyCodeFrom	STRING	OPTIONAL	IN
mnCurrencyConverRateOv	FLOAT	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
szGlClass	STRING	OPTIONAL	IN
szGlBankAccount	STRING	OPTIONAL	IN
cGLPostedCode	CHARACTER	OPTIONAL	IN
cAccountModeGL	UDC	OPTIONAL	IN
szAccountId2	ACCOUNTID	OPTIONAL	IN
szCostCenter	BUSINESSUNIT	OPTIONAL	IN
szObjectAccount	STRING	OPTIONAL	IN
szSubsidiary	STRING	OPTIONAL	IN
cSubledgerType	UDC	OPTIONAL	IN
szSubledger	STRING	OPTIONAL	IN
szBankTransitShortId	STRING	OPTIONAL	IN
szPaymentTermsCode01	STRING	OPTIONAL	IN
cVoidFlag	CHARACTER	OPTIONAL	IN
szCompanyKeyOriginal	COMPANY	OPTIONAL	IN
szOriginalDocumentType	UDC	OPTIONAL	IN
mnOriginalDocumentNo	INTEGER	OPTIONAL	IN
szOriginalDocPayItem	STRING	OPTIONAL	IN
szCheckRoutingCode	UDC	OPTIONAL	IN
szVendorInvoiceNumber	STRING	OPTIONAL	IN
szCompanyKeyPurchase	COMPANY	OPTIONAL	IN
szPurchaseOrder	STRING	OPTIONAL	IN
szDocumentTypePurchase	UDC	OPTIONAL	IN
mnLineNumber	FLOAT	OPTIONAL	IN
szOrderSuffix	STRING	OPTIONAL	IN
mnSequenceNoOperations	FLOAT	OPTIONAL	IN
szReference1	STRING	OPTIONAL	IN
szUnitNo	STRING	OPTIONAL	IN
szCostCenter2	BUSINESSUNIT	OPTIONAL	IN
szNameRemark	STRING	OPTIONAL	IN
szFrequencyRecurring	UDC	OPTIONAL	IN
mnRecurFrequencyOfPaym	INTEGER	OPTIONAL	IN
szAPChecksControlField	STRING	OPTIONAL	IN
cFinalPayment	CHARACTER	OPTIONAL	IN
mnUnits	FLOAT	OPTIONAL	IN
szUnitOfMeasure	UDC	OPTIONAL	IN
cPaymentInstrument	UDC	OPTIONAL	IN
szTaxRateArea3Withholding	STRING	OPTIONAL	IN
szTaxExplCode3Withhholding	UDC	OPTIONAL	IN
cArApMiscCode1	CHARACTER	OPTIONAL	IN
cArApMiscCode2	CHARACTER	OPTIONAL	IN
cArApMiscCode3	CHARACTER	OPTIONAL	IN
szReportCodeAddBook007	UDC	OPTIONAL	IN
cFlagFor1099	CHARACTER	OPTIONAL	IN
cDomesticEntryWMultCurrency	CHARACTER	OPTIONAL	IN
mnIdentifierShortItem	SHORTITEM	OPTIONAL	IN
mnHistoricalCurrencyConver	FLOAT	OPTIONAL	IN
jdHistoricalDateJulian	DATE	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
mnDateInvoiceMo	INTEGER	OPTIONAL	IN
mnDateInvoiceDaA	INTEGER	OPTIONAL	IN
mnDateInvoiceYr	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
mnDtForGLAndVouchMo	INTEGER	OPTIONAL	IN
mnDtForGLAndVouchDa	INTEGER	OPTIONAL	IN
mnDtForGLAndVouchYr	INTEGER	OPTIONAL	IN
mnDateBatch1Mo	INTEGER	OPTIONAL	IN
mnDateBatch1Da	INTEGER	OPTIONAL	IN
mnDateBatch1Yr	INTEGER	OPTIONAL	IN
mnHistoricalDateMo	INTEGER	OPTIONAL	IN
mnHistoricalDateDa	INTEGER	OPTIONAL	IN
mnHistoricalDateYr	INTEGER	OPTIONAL	IN
mnDocMatchingCheckOr	INTEGER	OPTIONAL	IN
szBankTransitNumber	STRING	OPTIONAL	IN
szCategoryCodeAccountsP001	UDC	OPTIONAL	IN
szCategoryCodeAccountsP002	UDC	OPTIONAL	IN
szCategoryCodeAccountsP003	UDC	OPTIONAL	IN
szCategoryCodeAccountsP004	UDC	OPTIONAL	IN
szCategoryCodeAccountsP005	UDC	OPTIONAL	IN
szCategoryCodeAccountsP006	UDC	OPTIONAL	IN
szCategoryCodeAccountsP007	UDC	OPTIONAL	IN
szCategoryCodeAccountsP008	UDC	OPTIONAL	IN
szCategoryCodeAccountsP009	UDC	OPTIONAL	IN
szCategoryCodeAccountsP010	UDC	OPTIONAL	IN
cDeferredTaxStatusVAT	CHARACTER	OPTIONAL	IN
szCurrencyCodeBase	STRING	OPTIONAL	IN
mnAmountToDistribute	FLOAT	OPTIONAL	IN
mnAmountToDistributeCur	FLOAT	OPTIONAL	IN
mnNonRecoverableTaxAmt	FLOAT	OPTIONAL	IN
mnForeignNonRecoverableTax	FLOAT	OPTIONAL	IN
cPurchasingTaxableYN	CHARACTER	OPTIONAL	IN
cPurgeFlag	CHARACTER	OPTIONAL	IN
cGenericFlag5	CHARACTER	OPTIONAL	IN
cGenericFlag6	CHARACTER	OPTIONAL	IN
mnGenericAmount1	FLOAT	OPTIONAL	IN
mnGenericAmount2	FLOAT	OPTIONAL	IN
szGenericString4	STRING	OPTIONAL	IN
szGenericString5	STRING	OPTIONAL	IN
mnAmountwithholdingtaxdom	FLOAT	OPTIONAL	IN
mnAmountwithholdingtaxfor	FLOAT	OPTIONAL	IN
cSummarizedFlag	CHARACTER	OPTIONAL	IN
cPayWhenPaid	CHARACTER	OPTIONAL	IN
mnPayWhenPaidGroupNumber	INTEGER	OPTIONAL	IN
cNetStatusCode	UDC	OPTIONAL	IN
cAutomationFlag	CHARACTER	OPTIONAL	IN
szAutomationRule	STRING	OPTIONAL	IN
mnJobnumberA	INTEGER	OPTIONAL	IN
cProcessType	CHARACTER	OPTIONAL	IN
mnDateInvoiceCtry	INTEGER	OPTIONAL	IN
mnDteServiceShipProdCt	INTEGER	OPTIONAL	IN
mnDateDueCtry	INTEGER	OPTIONAL	IN
mnDateDueNetDaysCtry	INTEGER	OPTIONAL	IN
mnDtForGLAndVouchCt	INTEGER	OPTIONAL	IN
mnDateBatch1Ctry	INTEGER	OPTIONAL	IN
mnHistoricalDateCtry	INTEGER	OPTIONAL	IN
cSuppressErrorMessages	CHARACTER	OPTIONAL	IN
szErrorMessageCode	STRING	OPTIONAL	OUT