AVN_USER_CONFIG(SQL Table) |
Index Back |
|---|---|
User ConfigUser Config |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  OPRID |
Character(30) | VARCHAR2(30) NOT NULL | A user's ID (see PSOPRDEFN). |
| 2 | ACV_CONFIG_NAME |
Character(40) | VARCHAR2(40) NOT NULL | Search Name |
| 3 | SETID_INQ | Character(5) | VARCHAR2(5) NOT NULL |
SetID
Default Value: OPR_DEF_TBL_FS.SETID Prompt Table: SP_SETVC_NONVW |
| 4 | BUSINESS_UNIT | Character(5) | VARCHAR2(5) NOT NULL |
Business Unit
Prompt Table: SP_BU_AP_NONVW |
| 5 | VENDOR_ID | Character(10) | VARCHAR2(10) NOT NULL |
Vendor Identifier
Prompt Table: VENDOR_HIR_VW |
| 6 | CUST_HIERARCHY | Character(1) | VARCHAR2(1) NOT NULL |
Customer Hierarchy
C=Corporate P=Correspondence R=Remit From Default Value: C |
| 7 | DISPLAY_CURRENCY | Character(3) | VARCHAR2(3) NOT NULL |
Display Currency
Prompt Table: CURRENCY_CD_VW |
| 8 | RT_TYPE | Character(5) | VARCHAR2(5) NOT NULL |
Defines a category of market rates for currency conversion. Some examples of rate types are commercial, average, floating, and historical.
Prompt Table: RT_TYPE_TBL |
| 9 | ACV_NDTPL_ID | Character(8) | VARCHAR2(8) NOT NULL |
Node Template ID
Prompt Table: AVN_OPR_TPL_VW |
| 10 | ACV_ND_VIEW_NAME | Character(16) | VARCHAR2(16) NOT NULL |
Node View Name
Prompt Table: AVN_NODE_VIEW |
| 11 | ACV_FULL_TREE_FLG | Character(1) | VARCHAR2(1) NOT NULL |
Full Hierarchy
N=No Y=Yes |
| 12 | ACV_FULLWIDTH_FLG | Character(1) | VARCHAR2(1) NOT NULL |
Full Width
N=No Y=Yes Default Value: N |
| 13 | DATE_FROM | Date(10) | DATE | Date From |