AR_CRCARD_ADD(SQL View) |
Index Back |
|---|
| SELECT B.PAY_WS_TYPE , A.DEPOSIT_BU , A.DEPOSIT_ID , A.BILL_TO_CUST_ID , A.PAYMENT_CURRENCY FROM PS_PAYMENT A , PS_DEPOSIT_CONTROL B WHERE A.POST_DT IS NULL AND A.MISC_PAYMENT = 'N' AND A.DEPOSIT_BU = B.DEPOSIT_BU AND A.DEPOSIT_ID = B.DEPOSIT_ID AND A.PROCESS_INSTANCE = 0 AND B.CASH_CNTRL = A.CASH_CNTRL_USE AND ((A.CASH_CNTRL_USE = 'Y' AND A.CASH_CNTRL_DONE = 'Y') OR A.CASH_CNTRL_USE = 'N') AND B.LB_FORMAT_ERROR = 'N' |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  PAY_WS_TYPE |
Character(1) | VARCHAR2(1) NOT NULL |
Payment Worksheet Type
C=Credit Card Worksheet E=ePayment Worksheet P=Payment Worksheet Default Value: C |
| 2 | 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 |
| 3 | 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.
Default Value: NEXT |
| 4 | BILL_TO_CUST_ID |
Character(15) | VARCHAR2(15) NOT NULL |
Customer
Prompt Table:
CUST_BI_VW
|
| 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.
Prompt Table: CURRENCY_CD_TBL |