project QadFinancials > class BMfgPOAccountingControl > API query POAccountingControlByDomain


query filter (table tFilter)


tcBusinessFieldNametcDataTypetcOperator
icDomainc=
tpoc_ctrl.poc_ack_reql=,<>
tpoc_ctrl.poc_apv_reql=,<>
tpoc_ctrl.poc_billc=,>=,>,<>,<=,<,begins,can-do,matches
tpoc_ctrl.poc_crtacc_acctc=,>=,>,<>,<=,<,begins,can-do,matches
tpoc_ctrl.poc_crtacc_ccc=,>=,>,<>,<=,<,begins,can-do,matches
tpoc_ctrl.poc_crtacc_subc=,>=,>,<>,<=,<,begins,can-do,matches
tpoc_ctrl.poc_crtapp_acctc=,>=,>,<>,<=,<,begins,can-do,matches
tpoc_ctrl.poc_crtapp_ccc=,>=,>,<>,<=,<,begins,can-do,matches
tpoc_ctrl.poc_crtapp_subc=,>=,>,<>,<=,<,begins,can-do,matches
tpoc_ctrl.poc_date_based_rlse_idl=,<>
tpoc_ctrl.poc_dflt_dybksetc=,>=,>,<>,<=,<,begins,can-do,matches
tpoc_ctrl.poc_domainc=,>=,>,<>,<=,<,begins,can-do,matches
tpoc_ctrl.poc_dybk_on_invoicel=,<>
tpoc_ctrl.poc_dybkset_by_sitel=,<>
tpoc_ctrl.poc_ers_optc=,>=,>,<>,<=,<,begins,can-do,matches
tpoc_ctrl.poc_ers_procl=,<>
tpoc_ctrl.poc_ex_ratetypec=,>=,>,<>,<=,<,begins,can-do,matches
tpoc_ctrl.poc_fst_idc=,>=,>,<>,<=,<,begins,can-do,matches
tpoc_ctrl.poc_hcmmtsl=,<>
tpoc_ctrl.poc_insp_locc=,>=,>,<>,<=,<,begins,can-do,matches
tpoc_ctrl.poc_lcmmtsl=,<>
tpoc_ctrl.poc_ln_fmtl=,<>
tpoc_ctrl.poc_ln_statc=,>=,>,<>,<=,<,begins,can-do,matches
tpoc_ctrl.poc_multi_due_datesl=,<>
tpoc_ctrl.poc_next_batchi=,>=,>,<>,<=,<
tpoc_ctrl.poc_pc_linel=,<>
tpoc_ctrl.poc_pl_reql=,<>
tpoc_ctrl.poc_po_histl=,<>
tpoc_ctrl.poc_po_nbri=,>=,>,<>,<=,<
tpoc_ctrl.poc_po_prec=,>=,>,<>,<=,<,begins,can-do,matches
tpoc_ctrl.poc_pst_idc=,>=,>,<>,<=,<,begins,can-do,matches
tpoc_ctrl.poc_pt_reql=,<>
tpoc_ctrl.poc_rcv_alll=,<>
tpoc_ctrl.poc_rcv_nbrd=,>=,>,<>,<=,<
tpoc_ctrl.poc_rcv_prec=,>=,>,<>,<=,<,begins,can-do,matches
tpoc_ctrl.poc_rcv_typed=,>=,>,<>,<=,<
tpoc_ctrl.poc_req_nbri=,>=,>,<>,<=,<
tpoc_ctrl.poc_req_prec=,>=,>,<>,<=,<,begins,can-do,matches
tpoc_ctrl.poc_sched_disc_tbl_reql=,<>
tpoc_ctrl.poc_shipc=,>=,>,<>,<=,<,begins,can-do,matches
tpoc_ctrl.poc_sort_byl=,<>
tpoc_ctrl.poc_tol_cstd=,>=,>,<>,<=,<
tpoc_ctrl.poc_tol_pctd=,>=,>,<>,<=,<
tpoc_ctrl.poc_user1c=,>=,>,<>,<=,<,begins,can-do,matches
tpoc_ctrl.poc_user2c=,>=,>,<>,<=,<,begins,can-do,matches
tpoc_ctrl.poc_zero_schedi=,>=,>,<>,<=,<


Parameters (internal)


icDomaincharacter


query condition


  each poc_ctrl where
poc_ctrl.poc_domain = icDomain


query resultset tqPOAccountingControlByDomain


field namedata typedb fielddescription
tlpoc_ack_reqlogicalpoc_ctrl.poc_ack_reqRequire Acknowledgment
tlpoc_apv_reqlogicalpoc_ctrl.poc_apv_reqApproved Reqs Needed for POs
tcpoc_billcharacterpoc_ctrl.poc_billBill-To
tcpoc_crtacc_acctcharacterpoc_ctrl.poc_crtacc_acctPO Interest Accrued Acct
tcpoc_crtacc_cccharacterpoc_ctrl.poc_crtacc_ccPO Interest Accrued CC
tcpoc_crtacc_subcharacterpoc_ctrl.poc_crtacc_subPO Int Accrued Sub-Acct
tcpoc_crtapp_acctcharacterpoc_ctrl.poc_crtapp_acctPO Interest Applied Acct
tcpoc_crtapp_cccharacterpoc_ctrl.poc_crtapp_ccPO Interest Applied CC
tcpoc_crtapp_subcharacterpoc_ctrl.poc_crtapp_subPO Int Applied Sub-Acct
tlpoc_date_based_rlse_idlogicalpoc_ctrl.poc_date_based_rlse_idGenerate Date Based Release ID
tcpoc_dflt_dybksetcharacterpoc_ctrl.poc_dflt_dybksetDefault Daybook Set
tcpoc_domaincharacterpoc_ctrl.poc_domainDomain
tlpoc_dybk_on_invoicelogicalpoc_ctrl.poc_dybk_on_invoiceAllow Supplier Invoice Daybook Update
tlpoc_dybkset_by_sitelogicalpoc_ctrl.poc_dybkset_by_siteUse Daybook Set by Site
tcpoc_ers_optcharacterpoc_ctrl.poc_ers_optERS Option
tlpoc_ers_proclogicalpoc_ctrl.poc_ers_procERS Processing
tcpoc_ex_ratetypecharacterpoc_ctrl.poc_ex_ratetypeRate Type
tcpoc_fst_idcharacterpoc_ctrl.poc_fst_idCompany FST ID
tlpoc_hcmmtslogicalpoc_ctrl.poc_hcmmtsPO Header Comments
tcpoc_insp_loccharacterpoc_ctrl.poc_insp_locInspection Location
tlpoc_lcmmtslogicalpoc_ctrl.poc_lcmmtsPO Line Comments
tlpoc_ln_fmtlogicalpoc_ctrl.poc_ln_fmtLn Format S/M
tcpoc_ln_statcharacterpoc_ctrl.poc_ln_statCancel Backorders
tlpoc_multi_due_dateslogicalpoc_ctrl.poc_multi_due_datesMulti Due Dates
tipoc_next_batchintegerpoc_ctrl.poc_next_batchNext Fiscal Batch
tlpoc_pc_linelogicalpoc_ctrl.poc_pc_linePrice by PO Line Due Date
tlpoc_pl_reqlogicalpoc_ctrl.poc_pl_reqPrice List Required
tlpoc_po_histlogicalpoc_ctrl.poc_po_histKeep Booking History
tipoc_po_nbrintegerpoc_ctrl.poc_po_nbrNext Purchase Order
tcpoc_po_precharacterpoc_ctrl.poc_po_prePO Prefix
tcpoc_pst_idcharacterpoc_ctrl.poc_pst_idPST ID
tlpoc_pt_reqlogicalpoc_ctrl.poc_pt_reqPrice Table Required
tlpoc_rcv_alllogicalpoc_ctrl.poc_rcv_allReceive All
tdpoc_rcv_nbrdecimalpoc_ctrl.poc_rcv_nbrNext Receiver
tcpoc_rcv_precharacterpoc_ctrl.poc_rcv_preReceiver Prefix
tdpoc_rcv_typedecimalpoc_ctrl.poc_rcv_typeReceiver Type
tipoc_req_nbrintegerpoc_ctrl.poc_req_nbrNext Req
tcpoc_req_precharacterpoc_ctrl.poc_req_preRequistion Prefix
tlpoc_sched_disc_tbl_reqlogicalpoc_ctrl.poc_sched_disc_tbl_reqSched Disc Table Required
tcpoc_shipcharacterpoc_ctrl.poc_shipShip-To
tlpoc_sort_bylogicalpoc_ctrl.poc_sort_bySort PO By
tdpoc_tol_cstdecimalpoc_ctrl.poc_tol_cstTolerance Cost
tdpoc_tol_pctdecimalpoc_ctrl.poc_tol_pctTolerance Percent
tcpoc_user1characterpoc_ctrl.poc_user1Ufld1
tcpoc_user2characterpoc_ctrl.poc_user2Ufld2
tipoc_zero_schedintegerpoc_ctrl.poc_zero_schedZero Schedule
poc_ctrlCustomcharactercalculatedcustom fields
ti_sequenceintegercalculatedprimary index
tc_rowidcharactercalculated = rowid(poc_ctrl)


Internal usage


QadFinancials
method BCInvoice.DefaultValuesDaybookSetCodeSite
method BCInvoice.InitInstance
method BCInvoiceAPMatching.ApiEDICInvoiceAPMatchingImport
method BMfgDaybookSet.ApiGetDaybookCodeByType
method BMfgDaybookSetReport.DaybookSetReport


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 = "BMfgPOAccountingControl".
create ttContext.
assign ttContext.propertyName = "methodName"
       ttContext.propertyValue = "POAccountingControlByDomain".
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/bmfgpoaccountingcontrol.poaccountingcontrolbydomain.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.