AR_RUNCNTL_CM(SQL Table) |
Index Back |
---|---|
Condition Monitor Run ControlCondition Monitor Run Control |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | Character(30) | VARCHAR2(30) NOT NULL | A user's ID (see PSOPRDEFN). | |
2 | Character(30) | VARCHAR2(30) NOT NULL | Run Control ID | |
3 | SETID | Character(5) | VARCHAR2(5) NOT NULL |
SetID
Default Value: OPR_DEF_TBL_FS.SETID Prompt Table: SP_SETID_NONVW |
4 | CUST_ID | Character(15) | VARCHAR2(15) NOT NULL |
Uniquely identifies an organizational entity that purchases goods or services from the enterprise. Represents the sold-to customer which is the customer organization that places orders. The CUST_ID may or may not be the same as the identifiers for the bill-to and ship-to locations.
Prompt Table:
CUST_ALL_A2_VW
|
5 | CUSTOMER_GROUP | Character(10) | VARCHAR2(10) NOT NULL |
Customer Group
Prompt Table:
AR_CUSTGP_VW
|
6 | ANCHOR_DATE | Date(10) | DATE |
Anchor Date
Default Value: %date |
7 | ANCHOR_CURRENCY | Character(3) | VARCHAR2(3) NOT NULL |
The base currency of the business unit that generates a given deal transaction.
Default Value: OPR_DEF_TBL_AR.FORMAT_CURRENCY Prompt Table: AR_CNTL_CUR_VW |
8 | ANCHOR_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.
Default Value: BUS_UNIT_OPT_AR.RT_TYPE Prompt Table: AR_SS_RTYPE_VW |
9 | USE_SYSTEM_DATE | Character(1) | VARCHAR2(1) NOT NULL |
Use System Date
A=As of Date N=Anchor Date Y=Use System Date Default Value: N |