EM_BUY_APPR_CFG(SQL Table) |
Index Back |
|---|---|
Buyer Approval ConfigurationDatatable used to store approval configuration. RSR MarketPay Development |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  BUSINESS_UNIT |
Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
| 2 | APPROVAL_SEQ |
Number(3,0) | SMALLINT NOT NULL |
Approval Sequence
Default Value: 1 |
| 3 | VCHR_APPRVL_FLG | Character(1) | VARCHAR2(1) NOT NULL |
Voucher Approval Flag
D=Default from Higher Level P=Pre-Approved S=Virtual Approver W=Approval Framework Default Value: W |
| 4 | BUSPROCNAME | Character(30) | VARCHAR2(30) NOT NULL | Business Process Name (see PSBUSPROCDEFN). |
| 5 | APPR_RULE_SET | Character(30) | VARCHAR2(30) NOT NULL | Approval Rule Set |
| 6 | ROLENAME | Character(30) | VARCHAR2(30) NOT NULL |
The name of a Role in the Role Definition Table (see PSROLEDEFN).
Prompt Table: ROLE_USRLST_VW |
| 7 | AP_WF_RQSTR_OPTION | Character(1) | VARCHAR2(1) NOT NULL |
Workflow requestor option
L=Last Updated by user O=Originator Default Value: O |
| 8 | REQ_VALID_KKDT | Character(1) | VARCHAR2(1) NOT NULL |
Require Valid Budget Check and Document Tolerance Check
Y/N Table Edit Default Value: Y |