Q35CreateF03B11Z1Line | Rinami Knowledge Garden

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