|
SELECT A.DEPOSIT_BU ,A.DEPOSIT_ID ,A.OPRID ,A.ASSN_OPRID ,A.BUSINESS_UNIT ,A.DEPOSIT_TYPE ,A.BANK_SETID ,A.BANK_CD ,A.BANK_ACCT_KEY ,A.BNK_ID_NBR ,A.BANK_ACCOUNT_NUM ,A.BAL_STATUS ,A.DEP_POST_STATUS ,A.CONTROL_AMT ,A.CONTROL_CNT ,A.ENTERED_AMT ,A.ENTERED_CNT ,A.POSTED_TOTAL ,A.POSTED_COUNT ,A.MISC_DST_TOTAL ,A.MISC_DST_COUNT ,A.GROUP_SEQ_NUM ,A.RECEIVED_DT ,A.ENTRY_DT ,A.POST_DT ,A.ACCOUNTING_DT ,A.GL_DISTRIB_STATUS ,A.DEPOSIT_STATUS ,A.LB_FORMAT_ERROR ,A.LOCKBOX_BATCH_ID ,A.LOCKBOX_RUN_ID ,A.CONTROL_CURRENCY ,A.FORMAT_CURRENCY ,A.PYMT_RT_TYPE ,A.PYMNT_RATE_MULT ,A.PYMNT_RATE_DIV ,A.PROCESS_INSTANCE ,A.RECON_TYPE ,A.RECONCILE_DT ,A.RECON_STATUS ,A.RECON_CYCLE_NBR ,A.RECORD_SEQ_NUMBER ,A.RECONCILE_OPRID ,A.STTLMNT_DT_ACTUAL ,A.CASH_CNTRL ,B.BANK_ACCT_RVL_AMT ,A.RECON_RUN_ID ,B.CURRENCY_CD FROM PS_BNK_RCN_DEPOSIT A , PS_BNK_RCN_PYMR1_S B WHERE B.DEPOSIT_BU = A.DEPOSIT_BU AND B.DEPOSIT_ID = A.DEPOSIT_ID AND B.BNK_ID_NBR = A.BNK_ID_NBR AND B.BANK_ACCOUNT_NUM = A.BANK_ACCOUNT_NUM
|
| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 DEPOSIT_BU |
Character(5) |
VARCHAR2(5) NOT NULL |
Identifies the business unit to which a deposit is posted.
|
| 2 |
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.
|
| 3 |
OPRID |
Character(30) |
VARCHAR2(30) NOT NULL |
A user's ID (see PSOPRDEFN).
|
| 4 |
ASSN_OPRID |
Character(30) |
VARCHAR2(30) NOT NULL |
Specifies the operator ID of the person who will enter items in a group. This is used when one person enters the control totals and another person enters the actual transactions. The assigned operator is also the person who processes the group and the person who is shown on group inquiry and processing panels.
|
| 5 |
BUSINESS_UNIT |
Character(5) |
VARCHAR2(5) NOT NULL |
Business Unit
|
| 6 |
DEPOSIT_TYPE |
Character(1) |
VARCHAR2(1) NOT NULL |
Deposit Type
A=Amount
B=Balance of Net Pay
P=Percent
|
| 7 |
BANK_SETID |
Character(5) |
VARCHAR2(5) NOT NULL |
The PeopleSoft tableset ID associated with a given bank/counterparty.
|
| 8 |
BANK_CD |
Character(5) |
VARCHAR2(5) NOT NULL |
Bank Code
|
| 9 |
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
|
| 10 |
BNK_ID_NBR |
Character(20) |
VARCHAR2(20) NOT NULL |
A literal alphanumeric attribute that uniquely identifies a given bank or counterparty.
|
| 11 |
BANK_ACCOUNT_NUM |
Character(35) |
VARCHAR2(35) NOT NULL |
The literal unique identifier associated with a given bank/counterparty account.
|
| 12 |
BAL_STATUS |
Character(1) |
VARCHAR2(1) NOT NULL |
A flag that indicates whether or not the control totals for a deposit match the entered totals. A deposit is considered "balanced" when the two sets of totals are equal.
I=Balanced
O=Not Balanced
Default Value: O
|
| 13 |
DEP_POST_STATUS |
Character(1) |
VARCHAR2(1) NOT NULL |
Posting Status
A=All
C=Complete
N=Not Posted
P=Partial
Default Value: N
|
| 14 |
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.
|
| 15 |
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
|
| 16 |
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.
|
| 17 |
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.
|
| 18 |
POSTED_TOTAL |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Represents the total monetary amount of all pending items in a group that have been posted to customer accounts. The Receivables Update program automatically calculates this total.
|
| 19 |
POSTED_COUNT |
Number(6,0) |
INTEGER NOT NULL |
Represents the total number of pending items in a group that have been posted to customer accounts. The Receivables Update program automatically calculates this total.
|
| 20 |
MISC_DST_TOTAL |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Journalled Dist Total
|
| 21 |
MISC_DST_COUNT |
Number(5,0) |
INTEGER NOT NULL |
Miscellaneous Dist Count
|
| 22 |
GROUP_SEQ_NUM |
Number(6,0) |
INTEGER NOT NULL |
Specifies the system-assigned sequence number of a pending item within a group. A group is a postable entity that may be entered online or created by the system. In either case the group sequence number is automatically generated.
|
| 23 |
RECEIVED_DT |
Date(10) |
DATE NOT NULL |
Specifies the date that a group of pending items was received by the organization. This date may be earlier or the same as the date that the items were actually entered into the system (ENTRY_DT).
Default Value: %date
|
| 24 |
ENTRY_DT |
Date(10) |
DATE NOT NULL |
Specifies the date that a group of pending items was entered into the system. This date may be later or the same as the date that the items were received by the organization (See RECEIVED_DT).
Default Value: %date
|
| 25 |
POST_DT |
Date(10) |
DATE |
The Date a transaction was Posted.
|
| 26 |
ACCOUNTING_DT |
Date(10) |
DATE NOT NULL |
The accounting entry construction date for a given transaction (a generic field that crosses multiple
Default Value: %date
|
| 27 |
GL_DISTRIB_STATUS |
Character(1) |
VARCHAR2(1) NOT NULL |
Distribution Status
C=Available to Contracts
D=Distributed
G=Generated
H=Hold
I=Ignored
J=Creating Journals
M=Modified
N=None
P=To be processed
X=Waiting for Reversal
Default Value: N
|
| 28 |
DEPOSIT_STATUS |
Character(1) |
VARCHAR2(1) NOT NULL |
Deposit Status
A=Fully Applied
C=Complete
N=None Applied
P=Partially Applied
Default Value: N
|
| 29 |
LB_FORMAT_ERROR |
Character(1) |
VARCHAR2(1) NOT NULL |
Lockbox Format Error
D=Duplicate Deposit
N=No Errors
O=Out of Balance
Y=Error - Blank Payment ID
Default Value: N
|
| 30 |
LOCKBOX_BATCH_ID |
Character(5) |
VARCHAR2(5) NOT NULL |
Lockbox Batch Id
|
| 31 |
LOCKBOX_RUN_ID |
Number(10,0) |
DECIMAL(10) NOT NULL |
Lockbox Run Id
|
| 32 |
CONTROL_CURRENCY |
Character(3) |
VARCHAR2(3) NOT NULL |
Specifies the currency for all Receivables items in a control group. If this field is not blank the system will accept items with the specified currency only.
|
| 33 |
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.
|
| 34 |
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.
|
| 35 |
PYMNT_RATE_MULT |
Number(16,8) |
DECIMAL(15,8) NOT NULL |
An internal convention utilized for determining whether a currency exchange rate is stored
|
| 36 |
PYMNT_RATE_DIV |
Number(16,8) |
DECIMAL(15,8) NOT NULL |
An internal convention utilized for determining whether a currency exchange rate is store
|
| 37 |
PROCESS_INSTANCE |
Number(10,0) |
DECIMAL(10) NOT NULL |
Process Instance
|
| 38 |
RECON_TYPE |
Character(1) |
VARCHAR2(1) NOT NULL |
Represents a series of options as to how a treasury wishes to perform reconciliation for a given bank
A=Automatically Reconciled
B=Balance System(s) to BankTran
F=Forced to Reconcile
M=Manually Reconciled
S=Semi Manual
U=Unreconciled
Default Value: U
|
| 39 |
RECONCILE_DT |
Date(10) |
DATE |
The transaction reconciliation date.
|
| 40 |
RECON_STATUS |
Character(3) |
VARCHAR2(3) NOT NULL |
Reconciliation Status
ALG=Alignment Check
AMB=Ambiguous Match
AMT=Amounts Not Equal
CUR=Currency not Defined
DAT=Tran Date <> Value Date
DPI=Duplicate Input Transactions
DUP=Duplicate Transaction
MSC=Miscellaneous Transaction
NAM=Payee Names Not Equal
NTB=Not Found in Statement
NTF=Not Found In System
NTP=Not Found in POS Data
NUL=Null Transaction ID Ref
OVR=Overflow
PND=Pending Reconciliation
REC=Reconciled
RPR=Reprinted Check
RR=Requires Review - BSAC
STP=Stop Payment
TYP=Wrong Transaction Type
UNR=Unreconciled
VOI=Voided Check
|
| 41 |
RECON_CYCLE_NBR |
Number(10,0) |
DECIMAL(10) NOT NULL |
The bank statement ID.
|
| 42 |
RECORD_SEQ_NUMBER |
Number(10,0) |
DECIMAL(10) NOT NULL |
An internal work field utilized to enumerate database records in bank statement processing.
|
| 43 |
RECONCILE_OPRID |
Character(30) |
VARCHAR2(30) NOT NULL |
The user ID that performed the reconciliation for a given transaction.
|
| 44 |
STTLMNT_DT_ACTUAL |
Date(10) |
DATE |
Date in which a deal transaction is actually settled with a counterparty.
|
| 45 |
CASH_CNTRL |
Character(1) |
VARCHAR2(1) NOT NULL |
Cash Control
|
| 46 |
BANK_ACCT_RVL_AMT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Field used to store the amount on a transaction revalued in the base currency of the transactions bank account.
|
| 47 |
RECON_RUN_ID |
Character(15) |
VARCHAR2(15) NOT NULL |
Recon Run ID
|
| 48 |
BASE_CURRENCY_BNK |
Character(3) |
VARCHAR2(3) NOT NULL |
The base currency of the subject bank general ledger business unit.
|