|
SELECT B.DEPOSIT_BU , B.DEPOSIT_ID , B.PAYMENT_SEQ_NUM , B.PAYMENT_ID , B.PAYMENT_AMT , B.PAYMENT_CURRENCY , B.REMIT_FROM_SETID , B.REMIT_FROM_CUST_ID , B.PAYMENT_STATUS , B.PAYMENT_METHOD , B.PP_METHOD , B.ALGORITHM_GROUP , B.ALGORITHM , B.AMT_SEL , B.AMT_ADJ , B.AMT_REM , B.DISC_TAKEN , B.DISC_EARNED , B.DISC_UNEARNED , B.GL_DISTRIB_STATUS , B.GROUP_ID , B.PP_STATUS , B.PP_RQ , B.PP_RQ_HIT , B.PP_SW , B.PROCESS_INSTANCE , B.BUSINESS_UNIT_GL , B.DOC_TYPE , B.DOC_SEQ_NBR , B.DOC_SEQ_DATE , B.ENTRY_EVENT , B.ACCOUNTING_DT , B.ENTRY_DT , A.DEP_POST_STATUS , A.BANK_SETID , A.BANK_CD , A.BNK_ID_NBR , A.BANK_ACCT_KEY , A.BANK_ACCOUNT_NUM , A.BAL_STATUS , A.CONTROL_AMT , A.CONTROL_CURRENCY , A.CONTROL_CNT , A.ENTERED_AMT , A.ENTERED_CNT , A.POSTED_TOTAL , A.POSTED_COUNT , A.DEPOSIT_STATUS FROM PS_PAYMENT B , PS_DEPOSIT_CONTROL A , PS_PP_SEARCH_VW S WHERE A.DEPOSIT_BU=B.DEPOSIT_BU AND A.DEPOSIT_ID=B.DEPOSIT_ID AND A.DEPOSIT_BU = S.DEPOSIT_BU AND (B.PP_METHOD <> ' ' OR B.PP_RQ <> 0) AND A.DEP_POST_STATUS <> 'C' AND B.PP_STATUS <> 'N'
|
| # |
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.
|
| 3 |
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.
|
| 4 |
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.
|
| 5 |
PAYMENT_AMT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Specifies the amount of a customer payment.
|
| 6 |
PAYMENT_CURRENCY |
Character(3) |
VARCHAR2(3) NOT NULL |
Identifies the currency of a customer payment. This is generally the same as the currency specified for the deposit but it can be different.
Prompt Table:
AR_PAY_CUR_VW
|
| 7 |
REMIT_FROM_SETID |
Character(5) |
VARCHAR2(5) NOT NULL |
SetID
|
| 8 |
REMIT_FROM_CUST_ID |
Character(15) |
VARCHAR2(15) NOT NULL |
Remit From Customer
|
| 9 |
PAYMENT_STATUS |
Character(1) |
VARCHAR2(1) NOT NULL |
Payment Status
A=Applied
B=Bounced
C=Complete
E=Identified - Express
I=Identified
J=Directly Journalled
R=Unposted Direct Journal
U=Unidentified
W=Worksheet
Default Value: U
|
| 10 |
PAYMENT_METHOD |
Character(3) |
VARCHAR2(3) NOT NULL |
Specifies the preferred method of payment by a customer. Examples of payment method are check direct debit and draft.
10/28/2003 edw 655070000 - Removed LTC and CSH xlats.
ACH=ACH
CC=Credit Card
CHK=Check
CSH=Cash
DD=Direct Debit
DR=Draft
EC=Electronic Check
EFT=Electronic Fund Transfer
GE=Giro - EFT
PL=PayPal
WIR=Wire Report
Default Value: CHK
|
| 11 |
PP_METHOD |
Character(15) |
VARCHAR2(15) NOT NULL |
Payment Predictor Method
|
| 12 |
ALGORITHM_GROUP |
Character(15) |
VARCHAR2(15) NOT NULL |
Algorithm Group for Payment Predictor
|
| 13 |
ALGORITHM |
Character(7) |
VARCHAR2(7) NOT NULL |
Algorithm Identifier
|
| 14 |
AMT_SEL |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Amount selected
|
| 15 |
AMT_ADJ |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Amount Adjusted
|
| 16 |
AMT_REM |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Amount Remaining
|
| 17 |
DISC_TAKEN |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Discount Taken
|
| 18 |
DISC_EARNED |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Discounts Earned
|
| 19 |
DISC_UNEARNED |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Unearned Discounts
|
| 20 |
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
|
| 21 |
GROUP_ID |
Character(15) |
VARCHAR2(15) NOT NULL |
Uniquely identifies a collection of pending items that are to be posted to accounts receivable. The identifier is manually entered or automatically generated by the system.
|
| 22 |
PP_STATUS |
Character(1) |
VARCHAR2(1) NOT NULL |
Payment Predictor Status
A=Applied
N=Not Processed
P=Processed
W=Worksheet Generated
Default Value: N
|
| 23 |
PP_RQ |
Number(7,0) |
INTEGER NOT NULL |
Reference Qualifier Count
|
| 24 |
PP_RQ_HIT |
Number(7,0) |
INTEGER NOT NULL |
Reference Qualifier Hits
|
| 25 |
PP_SW |
Character(1) |
VARCHAR2(1) NOT NULL |
Payment Predictor
Y/N Table Edit
Default Value: N
|
| 26 |
PROCESS_INSTANCE |
Number(10,0) |
DECIMAL(10) NOT NULL |
Process Instance
|
| 27 |
BUSINESS_UNIT_GL |
Character(5) |
VARCHAR2(5) NOT NULL |
GL Business Unit
|
| 28 |
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.
|
| 29 |
DOC_SEQ_NBR |
Character(12) |
VARCHAR2(12) NOT NULL |
Specifies the sequence number assigned to each financial transaction (a document). The sequence number may be manually entered or system-generated.
|
| 30 |
DOC_SEQ_DATE |
Date(10) |
DATE |
Specifies the date that a document sequence number is assigned to a document or the date the document was created.
|
| 31 |
ENTRY_EVENT |
Character(10) |
VARCHAR2(10) NOT NULL |
Entry Event
Prompt Table:
EE_AR_CODE2_VW
|
| 32 |
ACCOUNTING_DT |
Date(10) |
DATE NOT NULL |
The accounting entry construction date for a given transaction (a generic field that crosses multiple
Default Value: DEPOSIT_CONTROL.ACCOUNTING_DT
|
| 33 |
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
|
| 34 |
DEP_POST_STATUS |
Character(1) |
VARCHAR2(1) NOT NULL |
Posting Status
A=All
C=Complete
N=Not Posted
P=Partial
Default Value: N
|
| 35 |
BANK_SETID |
Character(5) |
VARCHAR2(5) NOT NULL |
The PeopleSoft tableset ID associated with a given bank/counterparty.
|
| 36 |
BANK_CD |
Character(5) |
VARCHAR2(5) NOT NULL |
Bank Code
Prompt Table:
BANK_AR_BD_VW
|
| 37 |
BNK_ID_NBR |
Character(20) |
VARCHAR2(20) NOT NULL |
A literal alphanumeric attribute that uniquely identifies a given bank or counterparty.
|
| 38 |
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
Prompt Table:
BANK_AR_D_VW
|
| 39 |
BANK_ACCOUNT_NUM |
Character(35) |
VARCHAR2(35) NOT NULL |
The literal unique identifier associated with a given bank/counterparty account.
|
| 40 |
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
|
| 41 |
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.
|
| 42 |
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:
AR_CNTL_CUR_VW
|
| 43 |
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
|
| 44 |
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.
|
| 45 |
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.
|
| 46 |
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.
|
| 47 |
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.
|
| 48 |
DEPOSIT_STATUS |
Character(1) |
VARCHAR2(1) NOT NULL |
Deposit Status
A=Fully Applied
C=Complete
N=None Applied
P=Partially Applied
Default Value: N
|