PRODGP_TRFTLNG(SQL View) |
Index Back |
---|---|
Product Frt Group view RLangThis view is the related language control record for PRODGP% views. |
SELECT setid , prod_grp_type , product_group , effdt , language_cd , descr , descrshort FROM PS_PROD_GROUP_LNG WHERE prod_grp_type IN ('FRT', 'TRFT') |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | SETID | Character(5) | VARCHAR2(5) NOT NULL |
SetID
Prompt Table: SP_SETID_NONVW |
2 | PROD_GRP_TYPE | Character(4) | VARCHAR2(4) NOT NULL |
Product Group Type
ACCT=Accounting BO=Backorder/Reservations CA=Contract CLMB=Claimback Contract CTLG=Product Catalogs FCST=Forecast FRT=Freight PRC=Pricing RPT=Reporting SCON=Buying Agreement SSRC=Alternate Sources of Supply TAX=Tax TRPT=Transportations VAT=VAT WEB=WEB Order Entry |
3 | PRODUCT_GROUP | Character(10) | VARCHAR2(10) NOT NULL | Product Group |
4 | EFFDT | Date(10) | DATE NOT NULL | Effective Date |
5 | LANGUAGE_CD | Character(3) | VARCHAR2(3) NOT NULL | Language Code |
6 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
7 | DESCRSHORT | Character(10) | VARCHAR2(10) NOT NULL | Short Description |