RECNAMEFIELDNAME_ORDER_BYLC_RPT_ORDER_VW(SQL View) |
Index Back |
|---|---|
Prompt for LC_RPT Order By |
| SELECT RECNAME , FIELDNAME FROM PS_PSRECFIELD_VW WHERE RECNAME = 'LC_RPT_ST_TA3' AND FIELDNAME IN ('BUSINESS_UNIT', 'VAT_DCLRTN_DT', 'VAT_DST_ACCT_TYPE', 'VAT_DCMNT_ID', 'VAT_TXN_SOURCE', 'VAT_TXN_TYPE_CD', 'TAX_CD_VAT', 'LC_RPT_COL1_AMT', 'CUST_ID', 'VENDOR_ID') |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | RECNAME |
Character(15) | VARCHAR2(15) NOT NULL | Record (Table) Name (see PSRECDEFN). |
| 2 | FIELDNAME_ORDER_BY |
Character(18) | VARCHAR2(18) NOT NULL | Order By Field Name |