| # |
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 |
REPORT_ID |
Character(8) |
VARCHAR2(8) NOT NULL |
Report Identifier
|
| 4 |
LANGUAGE_CD |
Character(3) |
VARCHAR2(3) NOT NULL |
Language Code
|
| 5 |
AS_OF_DATE |
Date(10) |
DATE NOT NULL |
As of Date
Default Value: %date
|
| 6 |
AS_OF_DT_TYPE |
Character(1) |
VARCHAR2(1) NOT NULL |
As Of Date used for Open Liability Reports.
10/16/2002 - Removed Due Date from available Translates.
A=Accounting Date
D=Due Date
I=Invoice Date
Default Value: A
|
| 7 |
BUSINESS_UNIT_OPTN |
Character(1) |
VARCHAR2(1) NOT NULL |
Business Unit Option
A=All Business Units
V=Specific Business Unit
Default Value: A
|
| 8 |
VENDOR_SELECT_OPTN |
Character(1) |
VARCHAR2(1) NOT NULL |
Vendor Selection option
A=Select All Suppliers
S=Specify Supplier(s)
Default Value: A
|
| 9 |
UNREC_LIAB_IND |
Character(1) |
VARCHAR2(1) NOT NULL |
Include Unrecorded Liabilities
Y/N Table Edit
|
| 10 |
INCLUDE_PREPAY |
Character(1) |
VARCHAR2(1) NOT NULL |
Include Prepayment
Y/N Table Edit
Default Value: N
|
| 11 |
INCLUDE_DRAFT |
Character(1) |
VARCHAR2(1) NOT NULL |
Include Unmatured Drafts Paid
Y/N Table Edit
Default Value: N
|
| 12 |
INCLUDE_DISCOUNT |
Character(1) |
VARCHAR2(1) NOT NULL |
Include Available Discount
Y/N Table Edit
Default Value: N
|
| 13 |
APAGING_CYCLE_ID |
Character(5) |
VARCHAR2(5) NOT NULL |
Aging Cycle ID
Prompt Table:
AP_AGING_CYCLE
|
| 14 |
CURRENCY_OPTION4 |
Character(1) |
VARCHAR2(1) NOT NULL |
Currency option field
B=Base Currency
S=Selected Foreign Currency
T=Transaction Currency
Default Value: B
|
| 15 |
CURRENCY_CD |
Character(3) |
VARCHAR2(3) NOT NULL |
Currency Code
Prompt Table:
CURR_TXN_VW
|
| 16 |
CUR_RT_TYPE |
Character(5) |
VARCHAR2(5) NOT NULL |
Currency Rate Type
Prompt Table:
RT_TYPE_TBL
|
| 17 |
CUR_EFFDT |
Date(10) |
DATE |
Specifies the effective date associated with the currency used as the base currency for the Business Unit on the Journal Entry Header.
|
| 18 |
VENDOR_OPTN |
Character(1) |
VARCHAR2(1) NOT NULL |
Report Supplier By
I=Invoice Supplier
R=Remit Supplier
Default Value: I
|
| 19 |
GROUP_BY_OPT |
Character(1) |
VARCHAR2(1) NOT NULL |
Report Group By
B=Business Unit / Supplier
V=Supplier / Business Unit
Default Value: B
|
| 20 |
DET_SUM_SW |
Character(1) |
VARCHAR2(1) NOT NULL |
Detail or Summary
D=Detail
S=Summary
Default Value: S
|
| 21 |
BASIS_DT_AGE |
Character(1) |
VARCHAR2(1) NOT NULL |
Aging Basis Date
N=Net Due Date
S=Scheduled Pay Date
|