DEPOSIT_BUDEPOSIT_IDACH=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
AR_CMP_DRF_VW(SQL View) |
Index Back |
|---|---|
Complete Drafts Detail View |
| SELECT B.DRAFT_BU , B.DRAFT_ID , 'DR' , B.DRAFT_AMT , B.DRAFT_CURRENCY , %Round(%DecMult(%DecDiv(B.DRAFT_AMT, B.RATE_DIV), B.RATE_MULT), 3) , B.CURRENCY_CD , B.ACCOUNTING_DT FROM PS_DRAFT_CONTROL B WHERE B.DRAFT_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. |
| 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_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 |
| 4 | PAYMENT_AMT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Specifies the amount of a customer payment. |
| 5 | 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. |
| 6 | PAY_AMT_BASE | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Payment Amt - Base Curr |
| 7 | CURRENCY_CD | Character(3) | VARCHAR2(3) NOT NULL | Currency Code |
| 8 | ACCOUNTING_DT | Date(10) | DATE | The accounting entry construction date for a given transaction (a generic field that crosses multiple |