API query SelectBankImpLine

Description

This query returns the key fields of the available Bank Import Line.

query filter (table tFilter)

tcBusinessFieldName	tcDataType	tcOperator
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.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.BankImpLineSeq	i	=,>=,>,<>,<=,<
tBankImpLine.BankImpLineStatNumber	c	=,>=,>,<>,<=,<,begins,can-do,matches
tBankImpLine.BankImpLineTransType	c	=,>=,>,<>,<=,<,begins,can-do,matches
tBankImpLine.BankImpLineValueDate	t	=,>=,>,<>,<=,<

query condition

each BankImpLine where

BankImpLine.ProcessInCompany_ID >= 0

query sort order

BankImpLine.BankImpLineFileFormatCode (ascending)

query resultset tqSelectBankImpLine

field name	data type	db field	description
tiBankImp_ID	integer	BankImpLine.BankImp_ID	Link to BankImp
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
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
tiBankImpLineSeq	integer	BankImpLine.BankImpLineSeq	Sequence
tcBankImpLineStatNumber	character	BankImpLine.BankImpLineStatNumber	Statement Number
tcBankImpLineTransType	character	BankImpLine.BankImpLineTransType	Transaction Type
ttBankImpLineValueDate	date	BankImpLine.BankImpLineValueDate	Value 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
ti_sequence	integer	calculated	primary index
tc_rowid	character	calculated	= rowid(BankImpLine)

Internal usage

unused

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 = "SelectBankImpLine".
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.selectbankimpline.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.