| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 PROCESS_INSTANCE |
Number(10,0) |
DECIMAL(10) NOT NULL |
Process Instance
|
| 2 |
IU_SYS_TRAN_CD |
Character(8) |
VARCHAR2(8) NOT NULL |
System Transactions are delivered system data, representing the activities that can require interunit or intraunit accounting entries.
|
| 3 |
DESCR |
Character(30) |
VARCHAR2(30) NOT NULL |
Description
|
| 4 |
MULTIPLE_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Allow Multiple Values per Attr
Y/N Table Edit
Default Value: N
|
| 5 |
RECNAME_HEADER |
Character(15) |
VARCHAR2(15) NOT NULL |
Header Record
Prompt Table:
PSRECDEFN
|
| 6 |
RECNAME_LINE |
Character(15) |
VARCHAR2(15) NOT NULL |
Line Record
Prompt Table:
PSRECDEFN
|
| 7 |
FIELDNAME_BU_GL |
Character(18) |
VARCHAR2(18) NOT NULL |
Business Unit GL Field Name
Prompt Table:
RECFIELD_LN_VW
|
| 8 |
FIELDNAME_ACCTDATE |
Character(18) |
VARCHAR2(18) NOT NULL |
Accounting Date field name
Prompt Table:
%EDITTABLE
|
| 9 |
FIELDNAME_FRN_CUR |
Character(18) |
VARCHAR2(18) NOT NULL |
Foreign Currency
Prompt Table:
RECFIELD_LN_VW
|
| 10 |
FIELDNAME_FRN_AMT |
Character(18) |
VARCHAR2(18) NOT NULL |
Foreign Amount
Prompt Table:
RECFIELD_LN_VW
|
| 11 |
FIELDNAME_BASE_CUR |
Character(18) |
VARCHAR2(18) NOT NULL |
Base Currency
Prompt Table:
RECFIELD_LN_VW
|
| 12 |
FIELDNAME_BASE_AMT |
Character(18) |
VARCHAR2(18) NOT NULL |
Base Amount
Prompt Table:
RECFIELD_LN_VW
|
| 13 |
FIELDNAME_RT_MULT |
Character(18) |
VARCHAR2(18) NOT NULL |
Rate Multiplier Field Name
Prompt Table:
RECFIELD_LN_VW
|
| 14 |
FIELDNAME_RT_DIV |
Character(18) |
VARCHAR2(18) NOT NULL |
Rate Divisor Field Name
Prompt Table:
RECFIELD_LN_VW
|
| 15 |
FIELDNAME_DESCR |
Character(18) |
VARCHAR2(18) NOT NULL |
Fieldname Journal Line Descr
Prompt Table:
RECFIELD_LN_VW
|
| 16 |
FIELDNAME_LOCK |
Character(18) |
VARCHAR2(18) NOT NULL |
Document Locking Field
Prompt Table:
%EDITTABLE4
|
| 17 |
FIELDNAME_RT_TYPE |
Character(18) |
VARCHAR2(18) NOT NULL |
Rate Type
Prompt Table:
%EDITTABLE2
|
| 18 |
FIELDNAME_CUREFFDT |
Character(18) |
VARCHAR2(18) NOT NULL |
Currency Effective Date
Prompt Table:
%EDITTABLE3
|
| 19 |
FIELDNAME_IU_FLAG |
Character(18) |
VARCHAR2(18) NOT NULL |
InterUnit Balancing Line ID
Prompt Table:
RECFIELD_LN_VW
|
| 20 |
FIELDNAME_SEQ_FLD |
Character(18) |
VARCHAR2(18) NOT NULL |
Sequence Field
Prompt Table:
RECFIELD_LN_VW
|
| 21 |
FIELD_VALUE_LOCK |
Character(30) |
VARCHAR2(30) NOT NULL |
Locked Value
|
| 22 |
FIELD_VALUE_INTERP |
Character(30) |
VARCHAR2(30) NOT NULL |
InterUnit Payable Value
|
| 23 |
FIELD_VALUE_INTERR |
Character(30) |
VARCHAR2(30) NOT NULL |
InterUnit Receivable Value
|
| 24 |
FIELD_VALUE_INTRAP |
Character(30) |
VARCHAR2(30) NOT NULL |
IntraUnit Payable Value
|
| 25 |
FIELD_VALUE_INTRAR |
Character(30) |
VARCHAR2(30) NOT NULL |
IntraUnit Receivable Value
|
| 26 |
SEQUENCE_NBR_9 |
Number(9,0) |
DECIMAL(9) NOT NULL |
Sequence
|
| 27 |
COMMIT_AFTER_LOCK |
Character(1) |
VARCHAR2(1) NOT NULL |
Commit After Lock
Y/N Table Edit
Default Value: Y
|
| 28 |
HEADER_LINE_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Header or Line
H=From Header
L=From Line
Default Value: L
|
| 29 |
HEADER_LINE_FLAG2 |
Character(1) |
VARCHAR2(1) NOT NULL |
Header or Line
H=From Header
L=From Line
Default Value: L
|
| 30 |
HEADER_LINE_FLAG3 |
Character(1) |
VARCHAR2(1) NOT NULL |
Currency Date Source
H=From Header
L=From Line
Default Value: L
|
| 31 |
IU_TRANS_COMPLETE |
Character(1) |
VARCHAR2(1) NOT NULL |
Transaction Completion Flag
E=Offset Manually Entered
G=Offset System Generated
Default Value: G
|
| 32 |
IU_ANCHOR_BAL_OPTN |
Character(1) |
VARCHAR2(1) NOT NULL |
Anchor Due to/from ChartFields
1=Use Receivable ChartFields
2=Use Payable ChartFields
3=Use ChartFields Based on Sign
Default Value: 3
|
| 33 |
IU_SUMMARIZATION |
Character(1) |
VARCHAR2(1) NOT NULL |
Controls whether or not a final summarization is performed on the balancing lines created by the InterUnit Processor.
D=Default to Installation Option
N=No Summarization
S=Summarize
|
| 34 |
ACT_BAL_GRP_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Account Balancing Groups Used
Y/N Table Edit
Default Value: N
|
| 35 |
WHERE_CLAUSE |
Character(254) |
VARCHAR2(254) NOT NULL |
Where Clause
|