API query BankImpLineByBankImp

Description

This query returns all fields of Bank Import Line for selected Bank Import fields.

query filter (table tFilter)

tcBusinessFieldName	tcDataType	tcOperator
icFileName	c	=
icTransDirection	c	=
icOwnBankNumber	c	=
icActions	c	can-do
itTransFromDate	t	>=
itUploadFromDate	t	>=
itTransToDate	t	<=
itUploadToDate	t	<=
tBankImp.BankImpFileName	c	=,>=,>,<>,<=,<,begins,can-do,matches
tBankImpLine.BankImpLineAction	c	=,>=,>,<>,<=,<,begins,can-do,matches
tBankImpLine.BankImpLineAddressCity	c	=,>=,>,<>,<=,<,begins,can-do,matches
tBankImpLine.BankImpLineAddressCountry	c	=,>=,>,<>,<=,<,begins,can-do,matches
tBankImpLine.BankImpLineAddressLine	c	=,>=,>,<>,<=,<,begins,can-do,matches
tBankImpLine.BankImpLineAddressZip	c	=,>=,>,<>,<=,<,begins,can-do,matches
tBankImpLine.BankImpLineAmountTC	d	=,>=,>,<>,<=,<
tBankImpLine.BankImpLineBankNumber	c	=,>=,>,<>,<=,<,begins,can-do,matches
tBankImpLine.BankImpLineBatchNbr	i	=,>=,>,<>,<=,<
tBankImpLine.BankImpLineBusRelType	c	=,>=,>,<>,<=,<,begins,can-do,matches
tBankImpLine.BankImpLineCost	c	=,>=,>,<>,<=,<,begins,can-do,matches
tBankImpLine.BankImpLineCreditorCode	c	=,>=,>,<>,<=,<,begins,can-do,matches
tBankImpLine.BankImpLineCreditorName	c	=,>=,>,<>,<=,<,begins,can-do,matches
tBankImpLine.BankImpLineCurrencyCode	c	=,>=,>,<>,<=,<,begins,can-do,matches
tBankImpLine.BankImpLineDebtorCode	c	=,>=,>,<>,<=,<,begins,can-do,matches
tBankImpLine.BankImpLineDebtorName	c	=,>=,>,<>,<=,<,begins,can-do,matches
tBankImpLine.BankImpLineDescription	c	=,>=,>,<>,<=,<,begins,can-do,matches
tBankImpLine.BankImpLineDiscAmtTC	d	=,>=,>,<>,<=,<
tBankImpLine.BankImpLineExchangeRate	d	=,>=,>,<>,<=,<
tBankImpLine.BankImpLineFileFormatCode	c	=,>=,>,<>,<=,<,begins,can-do,matches
tBankImpLine.BankImpLineInfo	c	=,>=,>,<>,<=,<,begins,can-do,matches
tBankImpLine.BankImpLineInOut	c	=,>=,>,<>,<=,<,begins,can-do,matches
tBankImpLine.BankImpLineInvRefList	c	=,>=,>,<>,<=,<,begins,can-do,matches
tBankImpLine.BankImpLineOrigAmountTC	d	=,>=,>,<>,<=,<
tBankImpLine.BankImpLineOrigCurrCode	c	=,>=,>,<>,<=,<,begins,can-do,matches
tBankImpLine.BankImpLineOrigTransDate	t	=,>=,>,<>,<=,<
tBankImpLine.BankImpLineOwnBankNumber	c	=,>=,>,<>,<=,<,begins,can-do,matches
tBankImpLine.BankImpLinePaymentNbr	c	=,>=,>,<>,<=,<,begins,can-do,matches
tBankImpLine.BankImpLinePaymentRef	c	=,>=,>,<>,<=,<,begins,can-do,matches
tBankImpLine.BankImpLineProcessedStatus	c	=,>=,>,<>,<=,<,begins,can-do,matches
tBankImpLine.BankImpLineRateScale	d	=,>=,>,<>,<=,<
tBankImpLine.BankImpLineReference	c	=,>=,>,<>,<=,<,begins,can-do,matches
tBankImpLine.BankImpLineSeq	i	=,>=,>,<>,<=,<
tBankImpLine.BankImpLineStatNumber	c	=,>=,>,<>,<=,<,begins,can-do,matches
tBankImpLine.BankImpLineTransType	c	=,>=,>,<>,<=,<,begins,can-do,matches
tBankImpLine.BankImpLineValueDate	t	=,>=,>,<>,<=,<
tBankImp.BankImpLoadedDate	t	=,>=,>,<>,<=,<

Parameters (internal)

icFileName	character	Bank Import File Name
icTransDirection	character	Transaction Direction
icOwnBankNumber	character	Own Bank Number
icActions	character	Actions
itTransFromDate	date	Transaction From Date
itUploadFromDate	date	Upload From Date
itTransToDate	date	Transaction To Date
itUploadToDate	date	Upload To Date

query condition

each BankImpLine where

BankImpLine.BankImpLineOwnBankNumber = icOwnBankNumber AND
BankImpLine.BankImpLineInOut = icTransDirection AND
BankImpLine.BankImpLineAction can-do icActions AND
BankImpLine.BankImpLineValueDate >= itTransFromDate AND
BankImpLine.BankImpLineValueDate <= itTransToDate AND
BankImpLine.BankImpLineProcessedStatus <> {&BANKIMPPROCSTATUS-PROCESSED-OK} AND
BankImpLine.ProcessInCompany_ID >= 0

first BankImp (inner-join) where

BankImp.BankImp_ID = BankImpLine.BankImp_ID AND
BankImp.BankImpFileName = icFileName AND
BankImp.BankImpLoadedDate >= itUploadFromDate AND
BankImp.BankImpLoadedDate <= itUploadToDate

query sort order

BankImpLine.BankImp_ID (ascending)
BankImpLine.BankImpLine_ID (ascending)
BankImpLine.BankImpLineSeq (ascending)

query resultset tqBankImpLineByBankImp

field name	data type	db field	description
tiBankImp_ID	integer	BankImpLine.BankImp_ID	Link to BankImp
tcBankImpFileName	character	BankImp.BankImpFileName	Bank File Name
tiBankImpLine_ID	integer	BankImpLine.BankImpLine_ID	Record ID
tcBankImpLineAction	character	BankImpLine.BankImpLineAction	Action
tcBankImpLineAddressCity	character	BankImpLine.BankImpLineAddressCity	Address City
tcBankImpLineAddressCountry	character	BankImpLine.BankImpLineAddressCountry	Address Country
tcBankImpLineAddressLine	character	BankImpLine.BankImpLineAddressLine	Address Line
tcBankImpLineAddressZip	character	BankImpLine.BankImpLineAddressZip	Address Zip
tdBankImpLineAmountTC	decimal	BankImpLine.BankImpLineAmountTC	Amount TC
tcBankImpLineBankNumber	character	BankImpLine.BankImpLineBankNumber	Bank Number
tiBankImpLineBatchNbr	integer	BankImpLine.BankImpLineBatchNbr	Batch Number
tcBankImpLineBusRelType	character	BankImpLine.BankImpLineBusRelType	Business Relation Type
tcBankImpLineCost	character	BankImpLine.BankImpLineCost	Cost
tcBankImpLineCreditorCode	character	BankImpLine.BankImpLineCreditorCode	Supplier Code
tcBankImpLineCreditorName	character	BankImpLine.BankImpLineCreditorName	Supplier Name
tcBankImpLineCurrencyCode	character	BankImpLine.BankImpLineCurrencyCode	Currency
tcBankImpLineDebtorCode	character	BankImpLine.BankImpLineDebtorCode	Customer Code
tcBankImpLineDebtorName	character	BankImpLine.BankImpLineDebtorName	Customer Name
tcBankImpLineDescription	character	BankImpLine.BankImpLineDescription	Description
tdBankImpLineDiscAmtTC	decimal	BankImpLine.BankImpLineDiscAmtTC	TC Discount Amount
tdBankImpLineExchangeRate	decimal	BankImpLine.BankImpLineExchangeRate	Exchange Rate
tcBankImpLineFileFormatCode	character	BankImpLine.BankImpLineFileFormatCode	Format Code
tcBankImpLineInfo	character	BankImpLine.BankImpLineInfo	Info
tcBankImpLineInOut	character	BankImpLine.BankImpLineInOut	Direction
tcBankImpLineInvRefList	character	BankImpLine.BankImpLineInvRefList	Invoices
tdBankImpLineOrigAmountTC	decimal	BankImpLine.BankImpLineOrigAmountTC	Original Amount TC
tcBankImpLineOrigCurrCode	character	BankImpLine.BankImpLineOrigCurrCode	Original Currency
ttBankImpLineOrigTransDate	date	BankImpLine.BankImpLineOrigTransDate	Original Transaction Date
tcBankImpLineOwnBankNumber	character	BankImpLine.BankImpLineOwnBankNumber	Account Number
tcBankImpLinePaymentNbr	character	BankImpLine.BankImpLinePaymentNbr	Payment Number
tcBankImpLinePaymentRef	character	BankImpLine.BankImpLinePaymentRef	Payment Reference
tcBankImpLineProcessedStatus	character	BankImpLine.BankImpLineProcessedStatus	Process Status
tdBankImpLineRateScale	decimal	BankImpLine.BankImpLineRateScale	Exchange Scale
tcBankImpLineReference	character	BankImpLine.BankImpLineReference	Reference
tiBankImpLineSeq	integer	BankImpLine.BankImpLineSeq	Sequence
tcBankImpLineStatNumber	character	BankImpLine.BankImpLineStatNumber	Statement Number
tcBankImpLineTransType	character	BankImpLine.BankImpLineTransType	Transaction Type
ttBankImpLineValueDate	date	BankImpLine.BankImpLineValueDate	Value Date
ttBankImpLoadedDate	date	BankImp.BankImpLoadedDate	Upload Date
tiBankState_ID	integer	BankImpLine.BankState_ID	Link to BankState
tiCDocument_ID	integer	BankImpLine.CDocument_ID	Link to CDocument
tiCreditor_ID	integer	BankImpLine.Creditor_ID	Link to Creditor
tiDDocument_ID	integer	BankImpLine.DDocument_ID	Link to DDocument
tiDebtor_ID	integer	BankImpLine.Debtor_ID	Link to Debtor
tiPayFormatCode_ID	integer	BankImpLine.PayFormatCode_ID	Link to PayFormatCode
BankImpLineCustom	character	calculated	custom fields
BankImpCustom	character	calculated	custom fields
ti_sequence	integer	calculated	primary index
tc_rowid	character	calculated	= rowid(BankImpLine),rowid(BankImp)

Internal usage

QadFinancials

method BBankImportLine.GetBankImpLineByFilter

Sample code: how to call this query through RPCRequestService (QXtend Inbound)

define temp-table ttContext no-undo
    field propertyQualifier as character
    field propertyName as character
    field propertyValue as character
    index entityContext is primary unique
        propertyQualifier
        propertyName
    index propertyQualifier
        propertyQualifier.

define dataset dsContext for ttContext.

define variable vhContextDS as handle no-undo.
define variable vhExceptionDS as handle no-undo.
define variable vhServer as handle no-undo.
define variable vhInputDS as handle no-undo.
define variable vhInputOutputDS as handle no-undo.
define variable vhOutputDS as handle no-undo.
define variable vhParameter as handle no-undo.

/* Create context */
create ttContext.
assign ttContext.propertyName = "programName"
       ttContext.propertyValue = "BBankImportLine".
create ttContext.
assign ttContext.propertyName = "methodName"
       ttContext.propertyValue = "BankImpLineByBankImp".
create ttContext.
assign ttContext.propertyName = "applicationId"
       ttContext.propertyValue = "fin".
create ttContext.
assign ttContext.propertyName = "entity"
       ttContext.propertyValue = "1000".
create ttContext.
assign ttContext.propertyName = "userName"
       ttContext.propertyValue = "mfg".
create ttContext.
assign ttContext.propertyName = "password"
       ttContext.propertyValue = "".

/* Create input dataset */
create dataset vhInputDS.
vhInputDS:read-xmlschema("file", "xml/bbankimportline.bankimplinebybankimp.i.xsd", ?).
vhParameter = vhInputDS:get-buffer-handle("tParameterI").
vhParameter:buffer-create().

assign vhParameter::icRange = "A"
       vhParameter::icRowid = ""
       vhParameter::iiRownum = 0
       vhParameter::iiNumber = 5 /* Number of records to read */
       vhParameter::icSortColumns = ""
       vhParameter::ilCountOnly = false
       vhParameter::ilForwardRead = true
       vhParameter::iiMaximumBrowseRecordsToCount = 0.

vhParameter = vhInputDS:get-buffer-handle("tFilter").
vhParameter:buffer-create().

assign vhParameter::<field-name-1> = <field-value-1>
       vhParameter::<field-name-2> = <field-value-2>
       ...

/* Connect the AppServer */
create server vhServer.
vhServer:connect("-URL <appserver-url>").

if not vhServer:connected()
then do:
    message "Could not connect AppServer" view-as alert-box error title "Error".
    return.
end.

/* Run */
assign vhContextDS = dataset dsContext:handle.

run program/rpcrequestservice.p on vhServer
    (input-output dataset-handle vhContextDS by-reference,
           output dataset-handle vhExceptionDS,
     input        dataset-handle vhInputDS by-reference,
     input-output dataset-handle vhInputOutputDS by-reference,
           output dataset-handle vhOutputDS).

/* Handle output however you want, in this example, we dump it to xml */
if valid-handle(vhExceptionDS)
then vhExceptionDS:write-xml("file", "Exceptions.xml", true).

if valid-handle(vhOutputDS)
then vhOutputDS:write-xml("file", "Output.xml", true).

/* Cleanup */
vhServer:disconnect().
assign vhServer = ?.

if valid-handle(vhInputDS)
then delete object vhInputDS.

if valid-handle(vhOutputDS)
then delete object vhOutputDS.

if valid-handle(vhExceptionDS)
then delete object vhExceptionDS.