Q35CreateF0411Z1Line
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 |