| # |
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 |
RUN_CNTL_ID |
Character(30) |
VARCHAR2(30) NOT NULL |
Run Control ID
|
| 3 |
GROUP_BU |
Character(5) |
VARCHAR2(5) NOT NULL |
Represents the high level grouping of multiple general ledger business units.
Default Value: OPR_DEF_TBL_AR.GROUP_BU
Prompt Table:
SP_BUARGR_NONVW
|
| 4 |
POST_FR_DT |
Date(10) |
DATE NOT NULL |
Unknown - non-Treasury product.
|
| 5 |
POST_TO_DT |
Date(10) |
DATE NOT NULL |
Unknown - non-Treasury product.
Default Value: %date
|
| 6 |
PROCESS_FREQUENCY |
Character(1) |
VARCHAR2(1) NOT NULL |
Process Frequency
A=Always Process
N=Don't Run
O=Process Once
Default Value: N
|
| 7 |
PROCESS_STATUS |
Character(1) |
VARCHAR2(1) NOT NULL |
Process Status
A=Active
C=Successfully Completed
E=Completed With Errors
N=Not Yet Processed
P=Processing Now
X=No Success
Default Value: N
|
| 8 |
PROCESS_INSTANCE |
Number(10,0) |
DECIMAL(10) NOT NULL |
Process Instance
|
| 9 |
PROCESS_ORIG |
Character(1) |
VARCHAR2(1) NOT NULL |
Process Origin
N=Other Source
P=Process Scheduler
|
| 10 |
LAST_RUN_DTM |
DateTime(26) |
TIMESTAMP |
Last Run On
|
| 11 |
PROCESS_U_HIST |
Character(1) |
VARCHAR2(1) NOT NULL |
User Defined
Y/N Table Edit
Default Value: N
|
| 12 |
PROCESS_P_HIST |
Character(1) |
VARCHAR2(1) NOT NULL |
Payment Performance
Y/N Table Edit
Default Value: N
|
| 13 |
PROCESS_D_HIST |
Character(1) |
VARCHAR2(1) NOT NULL |
Process DSO History
Y/N Table Edit
Default Value: N
|
| 14 |
SUBCUST_USE |
Character(1) |
VARCHAR2(1) NOT NULL |
SubCustomer
Y/N Table Edit
Default Value: N
|
| 15 |
CALC_YEAR |
Number(4,0) |
SMALLINT NOT NULL |
The calculation year for a given data set within the Position tools.
|
| 16 |
CALC_PERIOD |
Number(3,0) |
SMALLINT NOT NULL |
The calculation data horizons for a given data set within the Position tools.
|
| 17 |
CALC_DATE_OPT |
Character(1) |
VARCHAR2(1) NOT NULL |
Unknown - non Treasury product.
C=Calc Date
R=Run Date
Default Value: R
|
| 18 |
CALC_EFFDT |
Date(10) |
DATE |
Unknown - non Treasury product.
|
| 19 |
POSTNOW_TYPE |
Character(1) |
VARCHAR2(1) NOT NULL |
POSTING_REQUEST.POSTNOW_TYPE is blank if AR_POSTING is called from batch Posting Request page. It contains the group type of the group being posted if called from an online Post Now action page.
|
| 20 |
PREV_PROC_INSTANCE |
Number(10,0) |
DECIMAL(10) NOT NULL |
Process Instance
|
| 21 |
PROCESS_PENDITEM |
Character(1) |
VARCHAR2(1) NOT NULL |
Pending Items
Y/N Table Edit
Default Value: Y
|
| 22 |
ARUPDATE_PAYMENT |
Character(1) |
VARCHAR2(1) NOT NULL |
Payments
Y/N Table Edit
Default Value: Y
|
| 23 |
PROCESS_DRAFT |
Character(1) |
VARCHAR2(1) NOT NULL |
Drafts
Y/N Table Edit
Default Value: Y
|
| 24 |
PROCESS_MAINT |
Character(1) |
VARCHAR2(1) NOT NULL |
Maintenance Transactions
Y/N Table Edit
Default Value: Y
|
| 25 |
PROCESS_TRANSFERS |
Character(1) |
VARCHAR2(1) NOT NULL |
Transfers
Y/N Table Edit
Default Value: Y
|
| 26 |
PROCESS_UNPOST |
Character(1) |
VARCHAR2(1) NOT NULL |
Unpost Transactions
Y/N Table Edit
Default Value: Y
|
| 27 |
PROCESS_DD |
Character(1) |
VARCHAR2(1) NOT NULL |
Direct Debits
Y/N Table Edit
Default Value: Y
|
| 28 |
ARUPDATE_ALL |
Character(1) |
VARCHAR2(1) NOT NULL |
ALL
Y/N Table Edit
Default Value: Y
|
| 29 |
PROCESS_OVERDUE |
Character(1) |
VARCHAR2(1) NOT NULL |
Overdue Charges
Y/N Table Edit
Default Value: Y
|
| 30 |
AR_POST_OPTION |
Character(1) |
VARCHAR2(1) NOT NULL |
Post for all BU's/Dates option
Default Value: N
|