|
SELECT DEPOSIT_BU , DEPOSIT_ID , OPRID , ASSN_OPRID , BUSINESS_UNIT , DEPOSIT_TYPE , BANK_SETID , BANK_CD , BNK_ID_NBR , BANK_ACCT_KEY , BANK_ACCOUNT_NUM , BAL_STATUS , DEP_POST_STATUS , CONTROL_AMT , CONTROL_CNT , ENTERED_AMT , ENTERED_CNT , POSTED_TOTAL , POSTED_COUNT , MISC_DST_TOTAL , MISC_DST_COUNT , GROUP_SEQ_NUM , RECEIVED_DT , ENTRY_DT , POST_DT , ACCOUNTING_DT , GL_DISTRIB_STATUS , DEPOSIT_STATUS , LB_FORMAT_ERROR , LOCKBOX_BATCH_ID , LOCKBOX_RUN_ID , CONTROL_CURRENCY , FORMAT_CURRENCY , PYMT_RT_TYPE , PYMT_RATE_MULT , PYMT_RATE_DIV , RECON_TYPE , RECONCILE_DT , RECON_STATUS , RECON_CYCLE_NBR , RECONCILE_OPRID , STTLMNT_DT_ACTUAL , CASH_CNTRL , PAY_WS_TYPE , ENTERED_AMT - CONTROL_AMT , ENTERED_CNT - CONTROL_CNT FROM PS_DEPOSIT_CONTROL
|
| # |
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.
Default Value: OPR_DEF_TBL_AR.DEPOSIT_BU
Prompt Table:
SP_BUARDE_NONVW
|
| 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.
Default Value: NEXT
Prompt Table:
DEPOSIT_CONTROL
|
| 3 |
OPRID |
Character(30) |
VARCHAR2(30) NOT NULL |
A user's ID (see PSOPRDEFN).
Prompt Table:
OPRID_VW
|
| 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.
Default Value: DEPOSIT_CONTROL.OPRID
Prompt Table:
OPRID_VW
|
| 5 |
BUSINESS_UNIT |
Character(5) |
VARCHAR2(5) NOT NULL |
Business Unit
Default Value: DEPOSIT_CONTROL.DEPOSIT_BU
Prompt Table:
SP_BUARED_NONVW
|
| 6 |
DEPOSIT_TYPE |
Character(1) |
VARCHAR2(1) NOT NULL |
Deposit Type
A=Amount
B=Balance of Net Pay
P=Percent
Prompt Table:
DEPOST_TYPE_TBL
|
| 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 |
BNK_ID_NBR |
Character(20) |
VARCHAR2(20) NOT NULL |
A literal alphanumeric attribute that uniquely identifies a given bank or counterparty.
|
| 10 |
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
|
| 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.
Prompt Table:
CURRENCY_CD_TBL
|
| 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.
Prompt Table:
PYMT_RT_TYPE_VW
|
| 35 |
PYMT_RATE_MULT |
Number(16,8) |
DECIMAL(15,8) NOT NULL |
Specifies the number (the multiplier) required to convert a payment amount from its entry currency to the business unit base currency. The number is based on the exchange rate specified for the transaction. It is used in conjunction with PYMT_ RATE_DIV. Refer to documentation on the Triangulation Process for the exact calculation.
|
| 36 |
PYMT_RATE_DIV |
Number(16,8) |
DECIMAL(15,8) NOT NULL |
Specifies the number (the divisor) required to convert a payment amount from its entry currency to the business unit base currency. The number is based on the exchange rate specified for the transaction. It is used in conjunction with PYMT_RATE_MULT. Refer to documentation on the Triangulation Process for the exact calculation.
Default Value: 1
|
| 37 |
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
|
| 38 |
RECONCILE_DT |
Date(10) |
DATE |
The transaction reconciliation date.
|
| 39 |
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
|
| 40 |
RECON_CYCLE_NBR |
Number(10,0) |
DECIMAL(10) NOT NULL |
The bank statement ID.
|
| 41 |
RECONCILE_OPRID |
Character(30) |
VARCHAR2(30) NOT NULL |
The user ID that performed the reconciliation for a given transaction.
|
| 42 |
STTLMNT_DT_ACTUAL |
Date(10) |
DATE |
Date in which a deal transaction is actually settled with a counterparty.
|
| 43 |
CASH_CNTRL |
Character(1) |
VARCHAR2(1) NOT NULL |
Cash Control
Y/N Table Edit
|
| 44 |
PAY_WS_TYPE |
Character(1) |
VARCHAR2(1) NOT NULL |
Payment Worksheet Type
C=Credit Card Worksheet
E=ePayment Worksheet
P=Payment Worksheet
|
| 45 |
DIFFERENCE_AMT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Difference Amount
|
| 46 |
DIFFERENCE_CNT |
Signed Number(7,0) |
DECIMAL(6) NOT NULL |
Difference Count
|