project QadFinancials > class BMfgSite > business logic query SiteByShiptoForShippers
Parameters
| icDomainCode | character | |
| icShiptoCode | character | |
query condition
each si_mstr where
si_mstr.si_domain = icDomainCode
first abs_mstr (inner-join) where
abs_mstr.abs_domain = si_mstr.si_domain AND
abs_mstr.abs_shipfrom = si_mstr.si_site AND
abs_mstr.abs_shipto = icShiptoCode
query resultset tqSiteByShiptoForShippers
| field name | data type | db field | description |
|---|
| tcabs_domain | character | abs_mstr.abs_domain | Domain |
| tcabs_shipfrom | character | abs_mstr.abs_shipfrom | Ship-from Id |
| tcabs_shipto | character | abs_mstr.abs_shipto | Ship-to Id |
| tdoid_si_mstr | decimal | si_mstr.oid_si_mstr | |
| tcsi__chr01 | character | si_mstr.si__chr01 | |
| tcsi__chr02 | character | si_mstr.si__chr02 | |
| tcsi__chr03 | character | si_mstr.si__chr03 | |
| tcsi__chr04 | character | si_mstr.si__chr04 | |
| tcsi__chr05 | character | si_mstr.si__chr05 | |
| tdsi__dec01 | decimal | si_mstr.si__dec01 | |
| tdsi__dec02 | decimal | si_mstr.si__dec02 | |
| ttsi__dte01 | date | si_mstr.si__dte01 | |
| ttsi__dte02 | date | si_mstr.si__dte02 | |
| tlsi__log01 | logical | si_mstr.si__log01 | |
| tlsi_auto_loc | logical | si_mstr.si_auto_loc | Automatic Locations |
| tcsi_btb_vend | character | si_mstr.si_btb_vend | EMT Supplier |
| tcsi_canrun | character | si_mstr.si_canrun | Roles |
| tcsi_cur_set | character | si_mstr.si_cur_set | Current Cost Set |
| tcsi_db | character | si_mstr.si_db | Domain |
| tcsi_decl | character | si_mstr.si_decl | Declarant |
| tcsi_desc | character | si_mstr.si_desc | Description |
| tcsi_domain | character | si_mstr.si_domain | Domain |
| tcsi_entity | character | si_mstr.si_entity | Entity |
| tlsi_ext_vd | logical | si_mstr.si_ext_vd | External Supplier |
| tcsi_git_acct | character | si_mstr.si_git_acct | Goods In Transit Acct |
| tcsi_git_cc | character | si_mstr.si_git_cc | Cost Center |
| tcsi_git_location | character | si_mstr.si_git_location | PO Transit Location |
| tcsi_git_sub | character | si_mstr.si_git_sub | GIT Sub-Acct |
| tcsi_gl_set | character | si_mstr.si_gl_set | GL Cost Set |
| tcsi_insp_loc | character | si_mstr.si_insp_loc | Inspection Location |
| tcsi_site | character | si_mstr.si_site | Site |
| tcsi_status | character | si_mstr.si_status | Default Inventory Status |
| tlsi_type | logical | si_mstr.si_type | Type |
| tcsi_user1 | character | si_mstr.si_user1 | Ufld1 |
| tcsi_user2 | character | si_mstr.si_user2 | Ufld2 |
| tcsi_xfer_acct | character | si_mstr.si_xfer_acct | Transfer Variance Acct |
| tcsi_xfer_cc | character | si_mstr.si_xfer_cc | Transfer Variance Cost Ctr |
| tlsi_xfer_ownership | logical | si_mstr.si_xfer_ownership | Transfer Ownership |
| tcsi_xfer_sub | character | si_mstr.si_xfer_sub | Transfer Variance Sub |
Internal usage
QadFinancials