RUN_AR30009(SQL Table) |
Index Back |
---|---|
Aging by dept run controlAging by Department Run Control Record. |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | OPRID | Character(30) | VARCHAR2(30) NOT NULL |
A user's ID (see PSOPRDEFN).
Prompt Table: OPRID_VW |
2 | RUN_CNTL_ID | Character(30) | VARCHAR2(30) NOT NULL | Run Control ID |
3 | LANGUAGE_CD | Character(3) | VARCHAR2(3) NOT NULL | Language Code |
4 | AS_OF_DATE | Date(10) | DATE NOT NULL |
As of Date
Default Value: %date |
5 | SETID | Character(5) | VARCHAR2(5) NOT NULL |
SetID
Default Value: OPR_DEF_TBL_FS.SETID Prompt Table: SP_SETID_NONVW |
6 | 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_BI_A2_VW |
7 | AGING_ID | Character(5) | VARCHAR2(5) NOT NULL | Aging ID |
8 | CONTRACT_NUM | Character(25) | VARCHAR2(25) NOT NULL |
Contract
Prompt Table: %EDITTABLE |
9 | CURRENCY_AMT_TYPE | Character(1) | VARCHAR2(1) NOT NULL |
Amount Type
B=Base Curr E=Entry Curr Default Value: B |
10 | 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 |
11 | DEPTID | Character(10) | VARCHAR2(10) NOT NULL |
Department
Prompt Table: DEPT_TBL |
12 | AGE_DISPLAY_OPTION | Character(1) | VARCHAR2(1) NOT NULL |
Aging Display Option
A=Include All C=Collections Only D=Disputes Only E=Deductions Only Default Value: A |
13 | 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 |