|
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 , 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 , PAY_WS_TYPE FROM PS_DEPOSIT_CONTROL WHERE DEP_POST_STATUS <> 'C'
|
| # |
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.
Prompt Table:
SP_BUARDS_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.
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.
Prompt Table:
OPRID_VW
|
| 5 |
BUSINESS_UNIT |
Character(5) |
VARCHAR2(5) NOT NULL |
Business Unit
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
|
| 13 |
DEP_POST_STATUS |
Character(1) |
VARCHAR2(1) NOT NULL |
Posting Status
A=All
C=Complete
N=Not Posted
P=Partial
|
| 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 |
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.
|
| 22 |
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).
|
| 23 |
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).
|
| 24 |
POST_DT |
Date(10) |
DATE |
The Date a transaction was Posted.
|
| 25 |
ACCOUNTING_DT |
Date(10) |
DATE NOT NULL |
The accounting entry construction date for a given transaction (a generic field that crosses multiple
|
| 26 |
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
|
| 27 |
DEPOSIT_STATUS |
Character(1) |
VARCHAR2(1) NOT NULL |
Deposit Status
A=Fully Applied
C=Complete
N=None Applied
P=Partially Applied
Default Value: N
|
| 28 |
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
|
| 29 |
LOCKBOX_BATCH_ID |
Character(5) |
VARCHAR2(5) NOT NULL |
Lockbox Batch Id
|
| 30 |
LOCKBOX_RUN_ID |
Number(10,0) |
DECIMAL(10) NOT NULL |
Lockbox Run Id
|
| 31 |
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.
|
| 32 |
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.
|
| 33 |
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.
|
| 34 |
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.
|
| 35 |
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
|
| 36 |
PAY_WS_TYPE |
Character(1) |
VARCHAR2(1) NOT NULL |
Payment Worksheet Type
C=Credit Card Worksheet
E=ePayment Worksheet
P=Payment Worksheet
|