C360_WS_PNDD_VW(SQL View) |
Index Back |
|---|---|
Pending DD Detail View |
| SELECT DISTINCT S.SETID , I.BUSINESS_UNIT , I.CUST_ID , D.DD_BU , D.DD_ID , 'DD' , D.DD_STATUS , X.XLATLONGNAME , D.ACCOUNTING_DT , D.CREATE_DATE , D.DD_DUE_DT , D.DD_AMT , D.DD_CURRENCY , D.DD_AMT_BASE , D.CURRENCY_CD , D.BANK_CD , D.BANK_ACCT_KEY , D.DEPOSIT_ACCT_NUM , D.BNK_ID_NBR FROM PS_DD_CONTROL D , PS_DD_ITEM I , PS_SET_CNTRL_REC S , PSXLATITEM X WHERE D.DD_STATUS <> 'C' AND D.DD_BU = I.DD_BU AND D.DD_ID = I.DD_ID AND I.ITEM_SELECTED = 'Y' AND S.SETCNTRLVALUE = D.DD_BU AND S.RECNAME = 'CUSTOMER' AND X.FIELDNAME = 'DD_STATUS' AND X.FIELDVALUE = D.DD_STATUS AND X.EFFDT = ( SELECT MAX(effdt) FROM PSXLATITEM WHERE FIELDNAME = 'DD_STATUS' AND FIELDVALUE = D.DD_STATUS AND effdt <= %CurrentDateIn AND eff_status='A') |
| # | 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 |
| 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_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 |
| 7 | DD_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
A flag that indicates the stage of processing of a direct debit payment in receivables. This field is maintained by the Direct Debit generation process.
A=Accepted C=Complete E=Rejected N=No Action P=Pending R=Remitted Z=All |
| 8 | STATUS_DESCR | Character(30) | VARCHAR2(30) NOT NULL | Status Description |
| 9 | ACCOUNTING_DT | Date(10) | DATE | The accounting entry construction date for a given transaction (a generic field that crosses multiple |
| 10 | ENTRY_DT | Date(10) | DATE | 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). |
| 11 | DUE_DATE | Date(10) | DATE | Delivery Due Date from PO |
| 12 | PAYMENT_AMT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Specifies the amount of a customer payment. |
| 13 | 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. |
| 14 | PAY_AMT_BASE | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Payment Amt - Base Curr |
| 15 | CURRENCY_CD | Character(3) | VARCHAR2(3) NOT NULL | Currency Code |
| 16 | BANK_CD | Character(5) | VARCHAR2(5) NOT NULL | Bank Code |
| 17 | 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 |
| 18 | BANK_ACCOUNT_NUM | Character(35) | VARCHAR2(35) NOT NULL | The literal unique identifier associated with a given bank/counterparty account. |
| 19 | BNK_ID_NBR | Character(20) | VARCHAR2(20) NOT NULL | A literal alphanumeric attribute that uniquely identifies a given bank or counterparty. |