CUST_CMP_DRF_VW(SQL View) |
Index Back |
|---|---|
Pending Drafts Detail View |
| SELECT S.SETID , A.BUSINESS_UNIT , A.CUST_ID , A.DRAFT_BU , A.DRAFT_ID , A.ID_SEQ_NUM , '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_ID_CUST A , PS_DRAFT_CONTROL B , PS_SET_CNTRL_REC S WHERE A.BUSINESS_UNIT <> ' ' AND A.CUST_ID <> ' ' AND S.SETCNTRLVALUE = A.BUSINESS_UNIT AND S.RECNAME = 'CUSTOMER' AND A.DRAFT_BU = B.DRAFT_BU AND A.DRAFT_ID = B.DRAFT_ID AND B.DRAFT_STATUS = 'C' |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  SETID |
Character(5) | VARCHAR2(5) NOT NULL | SetID |
| 2 | BUSINESS_UNIT |
Character(5) | VARCHAR2(5) NOT NULL |
Business Unit
Default Value: OPR_DEF_TBL_FS.BUSINESS_UNIT Prompt Table: SP_BUARDS_NONVW |
| 3 | CUST_ID |
Character(15) | VARCHAR2(15) NOT NULL |
Uniquely identifies an organizational entity that purchases goods or services from the enterprise. Represents the sold-to customer which is the customer organization that places orders. The CUST_ID may or may not be the same as the identifiers for the bill-to and ship-to locations.
Prompt Table:
CUST_SRCH_VW
|
| 4 | DEPOSIT_BU |
Character(5) | VARCHAR2(5) NOT NULL | Identifies the business unit to which a deposit is posted. |
| 5 | 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. |
| 6 | 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. |
| 7 | 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 |
| 8 | PAYMENT_AMT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Specifies the amount of a customer payment. |
| 9 | 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. |
| 10 | PAY_AMT_BASE | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Payment Amt - Base Curr |
| 11 | CURRENCY_CD | Character(3) | VARCHAR2(3) NOT NULL | Currency Code |
| 12 | ACCOUNTING_DT | Date(10) | DATE | The accounting entry construction date for a given transaction (a generic field that crosses multiple |