BUSINESS_UNITRECNAMEDefault Value: REQ_LINE_VW
Prompt Table: PV_PNLG_RECNAME
PV_APPR_FLDDefault Value: CATEGORY_ID
Prompt Table: PV_PNLG_FIELDNM
RTE_FROM_VALUERTE_TO_VALUEROLENAMEDefault Value: CommodityApprover
Prompt Table: PSROLEDEFN_VW
PV_COMM_SETUP(SQL Table) |
Index Back |
|---|
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | BUSINESS_UNIT |
Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
| 2 | RECNAME |
Character(15) | VARCHAR2(15) NOT NULL |
Record (Table) Name (see PSRECDEFN).
Default Value: REQ_LINE_VW Prompt Table: PV_PNLG_RECNAME |
| 3 | PV_APPR_FLD |
Character(18) | VARCHAR2(18) NOT NULL |
Approval Field
Default Value: CATEGORY_ID Prompt Table: PV_PNLG_FIELDNM |
| 4 | RTE_FROM_VALUE |
Character(30) | VARCHAR2(30) NOT NULL | From Value |
| 5 | RTE_TO_VALUE |
Character(30) | VARCHAR2(30) NOT NULL | To Value |
| 6 | ROLENAME |
Character(30) | VARCHAR2(30) NOT NULL |
The name of a Role in the Role Definition Table (see PSROLEDEFN).
Default Value: CommodityApprover Prompt Table: PSROLEDEFN_VW |
| 7 | RTE_CNTL_PROFILE | Character(30) | VARCHAR2(30) NOT NULL | Route Control Profile |
| 8 | AMOUNT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Amount |