| # |
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 |
PROCESS_INSTANCE |
Number(10,0) |
DECIMAL(10) NOT NULL |
Process Instance
|
| 4 |
DEPOSIT_BU |
Character(5) |
VARCHAR2(5) NOT NULL |
Identifies the business unit to which a deposit is posted.
|
| 5 |
DEPOSIT_ID |
Character(15) |
VARCHAR2(15) NOT NULL |
Uniquely identifies a deposit of customer payments. The deposit ID can be manually assigned or system-generated.
|
| 6 |
MESSAGE_NBR |
Number(5,0) |
INTEGER NOT NULL |
Message Number. This field refers to the Message Number in the Message Catalog.
|
| 7 |
DEPOSIT_TBL_NAME |
Character(20) |
VARCHAR2(20) NOT NULL |
Table of Deposit Information
|
| 8 |
PAYMENT_TBL_NAME |
Character(20) |
VARCHAR2(20) NOT NULL |
Table of Payment Information
|
| 9 |
DST_TBL_NAME |
Character(20) |
VARCHAR2(20) NOT NULL |
Table of Distribution Lines
|
| 10 |
NOTHING |
Character(1) |
VARCHAR2(1) NOT NULL |
Work Field
|
| 11 |
CC_CALLER |
Character(1) |
VARCHAR2(1) NOT NULL |
Calling Application
C=Cash Control
O=Online
P=Payment Loader
R=Reconciliation
|
| 12 |
WHERE4_ONLINE |
Character(8) |
VARCHAR2(8) NOT NULL |
Where Clause for Online
|
| 13 |
PAY_COUNT |
Number(5,0) |
INTEGER NOT NULL |
Payment Count
|
| 14 |
DEPOSIT_CNT |
Number(4,0) |
SMALLINT NOT NULL |
Deposit Count
|
| 15 |
AMT_TOTAL |
Number(27,3) |
DECIMAL(26,3) NOT NULL |
Total Amount of Lines
|
| 16 |
AMT_CURRENCY |
Character(18) |
VARCHAR2(18) NOT NULL |
Currency of Line Total
|
| 17 |
LN_CT_CASH |
Number(4,0) |
SMALLINT NOT NULL |
Number of Cash Lines
|
| 18 |
LN_CT_CNTL |
Number(4,0) |
SMALLINT NOT NULL |
Number of Control Lines
|
| 19 |
AMOUNT_1 |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Amount Work Field
|
| 20 |
AMOUNT_2 |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Amount Work Field
|
| 21 |
COUNT_1 |
Number(3,0) |
SMALLINT NOT NULL |
Count Work Field
|
| 22 |
COUNT_2 |
Number(3,0) |
SMALLINT NOT NULL |
Count Work Field
|
| 23 |
CHAR_WRK_FLD |
Character(20) |
VARCHAR2(20) NOT NULL |
Character Work Field
|
| 24 |
PARM_1 |
Character(30) |
VARCHAR2(30) NOT NULL |
First Parameter
|
| 25 |
PARM_2 |
Character(20) |
VARCHAR2(20) NOT NULL |
Second Parameter
|
| 26 |
PARM_3 |
Character(80) |
VARCHAR2(80) NOT NULL |
Third Parameter
|
| 27 |
PARM_4 |
Character(20) |
VARCHAR2(20) NOT NULL |
Fourth Parameter
|
| 28 |
PARM_5 |
Character(20) |
VARCHAR2(20) NOT NULL |
Fifth Parameter
|
| 29 |
WORK_CNT |
Number(10,0) |
DECIMAL(10) NOT NULL |
Count of Anything
|
| 30 |
WORK_CNT2 |
Number(10,0) |
DECIMAL(10) NOT NULL |
Work Count 2
|
| 31 |
FORMAT_CURRENCY |
Character(3) |
VARCHAR2(3) NOT NULL |
Specifies the currency that controls the precision of the amount totals for a group of pending items. If CONTROL_CURRENCY is entered then the same currency code should be used here.
|
| 32 |
OPR_DEP_BU |
Character(5) |
VARCHAR2(5) NOT NULL |
Operator Deposit BU Default
|
| 33 |
ACTION_TYPE |
Character(1) |
VARCHAR2(1) NOT NULL |
Broadcast
D=log Deletedsequence number
E=Check doc seq enable option
G=Generate sequence number
R=Reset for 1099C Submission
X=Deleted from 1099C Prep Table
|
| 34 |
RECNAME |
Character(15) |
VARCHAR2(15) NOT NULL |
Record (Table) Name (see PSRECDEFN).
|
| 35 |
FIELDNAME_BU_GL |
Character(18) |
VARCHAR2(18) NOT NULL |
Business Unit GL Field Name
|
| 36 |
FIELDNAME_ACCTDATE |
Character(18) |
VARCHAR2(18) NOT NULL |
Accounting Date field name
|
| 37 |
WHERE_OPTION |
Character(1) |
VARCHAR2(1) NOT NULL |
Where Option
B=Both
N=None
P=Process Instance
V=By Value
|
| 38 |
RETURN_CD |
Character(1) |
VARCHAR2(1) NOT NULL |
Return Code
0=Return OK
1=Return error
|
| 39 |
DO_MATCH |
Character(1) |
VARCHAR2(1) NOT NULL |
Match Split Stream Data
|
| 40 |
LOAD_LB |
Character(1) |
VARCHAR2(1) NOT NULL |
Load Lockbox
|
| 41 |
LOAD_820 |
Character(1) |
VARCHAR2(1) NOT NULL |
Load 820
|
| 42 |
LOAD_CRX |
Character(1) |
VARCHAR2(1) NOT NULL |
Load EDIFACT CREEXT
|
| 43 |
LOAD_BNK_STMT |
Character(1) |
VARCHAR2(1) NOT NULL |
Load bank statement
|
| 44 |
LOAD_CDR |
Character(1) |
VARCHAR2(1) NOT NULL |
Cash Drawer Receipts
N=No
Y=Yes
|
| 45 |
LOAD_APP |
Character(1) |
VARCHAR2(1) NOT NULL |
Accounts Payable Payments
N=No
Y=Yes
|
| 46 |
LOAD_EXCEL_PYMT |
Character(1) |
VARCHAR2(1) NOT NULL |
Upload from Excel
|
| 47 |
MIN_DEPOSIT_ID |
Number(15,0) |
DECIMAL(15) NOT NULL |
Minimum Deposit ID
|
| 48 |
HOLD_DEPOSIT_ID |
Number(15,0) |
DECIMAL(15) NOT NULL |
Deposit ID Holder
|
| 49 |
MAX_DEPOSIT_ID |
Number(15,0) |
DECIMAL(15) NOT NULL |
Maximum Deposit ID
|
| 50 |
BANK_CD |
Character(5) |
VARCHAR2(5) NOT NULL |
Bank Code
|
| 51 |
BANK_ACCT_KEY |
Character(4) |
VARCHAR2(4) NOT NULL |
A user defined unique identifier that facilitates the identification of a given account with a given bank
|
| 52 |
EIP_CTL_ID |
Character(25) |
VARCHAR2(25) NOT NULL |
Enterprise Components EIP (enterprise integration point) control field
|
| 53 |
LB_FILE_NAME |
Character(80) |
VARCHAR2(80) NOT NULL |
Name of Lockbox File
|
| 54 |
LOCKBOX_RUN_STATUS |
Character(1) |
VARCHAR2(1) NOT NULL |
Lockbox Run Status
C=Complete
D=Duplicate Found
E=Errors Found
N=Not Run Yet
|
| 55 |
CONTROL_CNT |
Number(6,0) |
INTEGER NOT NULL |
Represents the number of pending items in a control group. Receivables compares the control count to the actual entry count and calculates the difference in order to help verify that all entries have been made correctly
|
| 56 |
CONTROL_AMT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Specifies the total monetary amount of all transactions within a group of pending items using the entry currency of each item. For mixed currencies this becomes a hash total. Receivables compares the control amount to the actual amount entered and calculates the difference in order to help verify that all entries have been made correctly.
|
| 57 |
ENTERED_CNT |
Number(6,0) |
INTEGER NOT NULL |
Represents the number of pending items actually entered in a group and is compared with the control total count. The Receivables Update program automatically calculates this total.
|
| 58 |
ENTERED_AMT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Represents the total currency amount of all pending items actually entered in a group and is compared with the control total amount. The Receivables Update program automatically calculates this total.
|
| 59 |
LB_BANK_TRANS_ID |
Character(20) |
VARCHAR2(20) NOT NULL |
Bank Transmission ID
|
| 60 |
LOCKBOX_ID |
Character(15) |
VARCHAR2(15) NOT NULL |
Lockbox ID
|
| 61 |
LOCKBOX_BATCH_ID |
Character(5) |
VARCHAR2(5) NOT NULL |
Lockbox Batch Id
|
| 62 |
MICR_SETID |
Character(5) |
VARCHAR2(5) NOT NULL |
MICR Setid
|
| 63 |
MICR_ID |
Character(30) |
VARCHAR2(30) NOT NULL |
MICR ID
|
| 64 |
REMIT_FROM_CUST_ID |
Character(15) |
VARCHAR2(15) NOT NULL |
Remit From Customer
|
| 65 |
REMIT_FROM_SETID |
Character(5) |
VARCHAR2(5) NOT NULL |
SetID
|
| 66 |
RECON_CYCLE_NBR |
Number(10,0) |
DECIMAL(10) NOT NULL |
The bank statement ID.
|
| 67 |
RECORD_SEQ_NUMBER |
Number(10,0) |
DECIMAL(10) NOT NULL |
An internal work field utilized to enumerate database records in bank statement processing.
|
| 68 |
MATCH_AP |
Character(1) |
VARCHAR2(1) NOT NULL |
Payment Amount and Payment ID
|
| 69 |
MATCH_CP |
Character(1) |
VARCHAR2(1) NOT NULL |
Customer ID and Payment ID
|
| 70 |
MATCH_DAP |
Character(1) |
VARCHAR2(1) NOT NULL |
Date, Amount and Payment ID
|
| 71 |
MATCH_TRN |
Character(1) |
VARCHAR2(1) NOT NULL |
EDI Trace Number
|
| 72 |
WHERE_AP |
Character(10) |
VARCHAR2(10) NOT NULL |
Where Clause for Matching AP
|
| 73 |
WHERE_CP |
Character(10) |
VARCHAR2(10) NOT NULL |
Where Clause for Matching CP
|
| 74 |
WHERE_DAP |
Character(10) |
VARCHAR2(10) NOT NULL |
Where Clause for Matching DAP
|
| 75 |
PYMT_RT_TYPE |
Character(5) |
VARCHAR2(5) NOT NULL |
Specifies the type of exchange rate to be used when the currency of a customer payment is converted to the base currency of a business unit. The exchange rate type is also called the market rate type. Examples are spot rate current rate and official rate.
|
| 76 |
FROM_CUR |
Character(3) |
VARCHAR2(3) NOT NULL |
From Currency Code
|
| 77 |
TO_CUR |
Character(3) |
VARCHAR2(3) NOT NULL |
To Currency Code
|
| 78 |
RATE_MULT |
Signed Number(17,8) |
DECIMAL(15,8) NOT NULL |
Rate Multiplier
|
| 79 |
RATE_DIV |
Number(16,8) |
DECIMAL(15,8) NOT NULL |
Rate Divisor
|
| 80 |
ACCOUNTING_DT |
Date(10) |
DATE |
The accounting entry construction date for a given transaction (a generic field that crosses multiple
|
| 81 |
PAYMENT_SEQ_NUM |
Number(6,0) |
INTEGER NOT NULL |
Specifies the system-generated sequence number assigned to each payment as it is entered in a deposit.
|
| 82 |
ABORT_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Abort Process Flag
|
| 83 |
ID_SEQ_NUM |
Number(5,0) |
INTEGER NOT NULL |
Identification Sequence number
|
| 84 |
REF_QUALIFIER_CODE |
Character(2) |
VARCHAR2(2) NOT NULL |
Reference Qualifier Code
|
| 85 |
BANK_ACCOUNT_NUM |
Character(35) |
VARCHAR2(35) NOT NULL |
The literal unique identifier associated with a given bank/counterparty account.
|
| 86 |
BNK_ID_NBR |
Character(20) |
VARCHAR2(20) NOT NULL |
A literal alphanumeric attribute that uniquely identifies a given bank or counterparty.
|
| 87 |
DATA_SOURCE |
Character(3) |
VARCHAR2(3) NOT NULL |
Data Source
820=820 ANSI-X12
APP=Accounts Payable Payment
BST=Bank Statement
CDR=Cash Drawer Receipts
CRX=EDIFACT CREEXT
LBX=Lockbox
ONL=Online
XEL=Excel Upload
|
| 88 |
BUSINESS_UNIT_GL |
Character(5) |
VARCHAR2(5) NOT NULL |
GL Business Unit
|
| 89 |
LEDGER_GROUP |
Character(10) |
VARCHAR2(10) NOT NULL |
Ledger Group
|
| 90 |
COMBO_EDIT_TMPL |
Character(10) |
VARCHAR2(10) NOT NULL |
Record Template
|
| 91 |
EDI_TRACE_NBR |
Number(10,0) |
DECIMAL(10) NOT NULL |
EDI Trace Number
|
| 92 |
AR_REMIT_STATUS |
Character(1) |
VARCHAR2(1) NOT NULL |
Remittance process status
B=Duplicate Pay and Remit
D=Duplicate Match
N=Not Processed
P=Duplicate Payments
R=Duplicate Remittances
U=Unmatched
|
| 93 |
DOC_TYPE |
Character(8) |
VARCHAR2(8) NOT NULL |
Specifies the business purpose of a financial transaction in countries that require all financial transactions to be tracked as "documents". A Document Type is associated with one and only one Journal Code.
|
| 94 |
DOC_SEQ |
Character(1) |
VARCHAR2(1) NOT NULL |
Enable Document Sequencing
|
| 95 |
WHERE_CLAUSE |
Character(254) |
VARCHAR2(254) NOT NULL |
Where Clause
|
| 96 |
SETID |
Character(5) |
VARCHAR2(5) NOT NULL |
SetID
|
| 97 |
CASH_CNTL_METH |
Character(1) |
VARCHAR2(1) NOT NULL |
Debit To Cash Occurs At
E=Payment Entry
R=Bank Reconciliation
|
| 98 |
CASHCNTL_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
CASHCNTL process flag
E=Error
Y=Yes
|
| 99 |
BANK_SETID |
Character(5) |
VARCHAR2(5) NOT NULL |
The PeopleSoft tableset ID associated with a given bank/counterparty.
|
| 100 |
WHERE_PAY |
Character(25) |
VARCHAR2(25) NOT NULL |
Where Clause
|
| 101 |
WHERE_DEP |
Character(25) |
VARCHAR2(25) NOT NULL |
Where Clause
|
| 102 |
WHERE_MTCH |
Character(25) |
VARCHAR2(25) NOT NULL |
Where Clause
|
| 103 |
WHERE_DOCSEQ |
Character(25) |
VARCHAR2(25) NOT NULL |
Where Clause
|
| 104 |
MATCH_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Match FLag
|
| 105 |
MATCH_PAY |
Character(1) |
VARCHAR2(1) NOT NULL |
Flag to indicate whether to match payments already loaded into the system previousely.
N=No
Y=Yes
|
| 106 |
PAYMENT_ID |
Character(15) |
VARCHAR2(15) NOT NULL |
Identifies a customer payment. This is usually a check number but may be some other identifying number.
|
| 107 |
BUSINESS_UNIT |
Character(5) |
VARCHAR2(5) NOT NULL |
Business Unit
|
| 108 |
ITEM |
Character(30) |
VARCHAR2(30) NOT NULL |
Uniquely identifies an invoice credit memo or debit memo. The item ID is also called the invoice number.
|
| 109 |
ITEM_LINE |
Number(6,0) |
INTEGER NOT NULL |
Item Line
|
| 110 |
BAL_CURRENCY |
Character(3) |
VARCHAR2(3) NOT NULL |
Currency Code - Bal Amount
|