project QadFinancials > class BMfgProductLine > business logic query ProductLineDetForMatchingAcc
Description
ProductLineDetForMatchingAcc
Parameters
| icDomainCode | character | DomainCode |
| icProductLineCode | character | ProductLineCode |
| icSite | character | |
| icLocation | character | |
query condition
each pld_det where
pld_det.pld_domain = icDomainCode AND
pld_det.pld_prodline = icProductLineCode AND
pld_det.pld_site = icSite AND
pld_det.pld_loc = icLocation
query resultset tqProductLineDetForMatchingAcc
| field name | data type | db field | description |
|---|
| tdoid_pld_det | decimal | pld_det.oid_pld_det | |
| tcpld_cchg_acc | character | pld_det.pld_cchg_acc | Cost Revalue Acct |
| tcpld_cchg_cc | character | pld_det.pld_cchg_cc | Inv Cost Change Cost Ctr |
| tcpld_cchg_sub | character | pld_det.pld_cchg_sub | Cost Revalue Sub-Acct |
| tcpld_domain | character | pld_det.pld_domain | Domain |
| tcpld_dscr_cc | character | pld_det.pld_dscr_cc | Inv Discrep Cost Ctr |
| tcpld_dscr_sub | character | pld_det.pld_dscr_sub | Inv Discrep Sub-Acct |
| tcpld_dscracct | character | pld_det.pld_dscracct | Inv Discrep Acct |
| tcpld_inv_acct | character | pld_det.pld_inv_acct | Inventory Acct |
| tcpld_inv_cc | character | pld_det.pld_inv_cc | Inventory Cost Ctr |
| tcpld_inv_sub | character | pld_det.pld_inv_sub | Inventory Sub-Acct |
| tcpld_loc | character | pld_det.pld_loc | Location |
| tcpld_prodline | character | pld_det.pld_prodline | Product Line |
| tcpld_scrp_cc | character | pld_det.pld_scrp_cc | Scrap Cost Ctr |
| tcpld_scrp_sub | character | pld_det.pld_scrp_sub | Scrap Sub-Acct |
| tcpld_scrpacct | character | pld_det.pld_scrpacct | Scrap Acct |
| tcpld_site | character | pld_det.pld_site | Site |
Internal usage
QadFinancials