BUSINESS_UNITDefault Value: OPR_DEF_TBL_FS.BUSINESS_UNIT
Prompt Table: SP_BUARDS_NONVW
CUST_IDPrompt Table: CUST_BI_A2_VW
CUST_PEND_PY_VW(SQL View) |
Index Back |
|---|---|
Customer w/Pending Payments |
| select distinct A.business_unit, A.cust_id from PS_PAYMENT_ID_CUST A, PS_PAYMENT B where a.business_unit <> ' ' and a.cust_id <> ' ' and A.deposit_bu = B.deposit_bu and A.deposit_id = B.deposit_id and A.payment_seq_num = B.payment_seq_num and (B.GROUP_ID = ' ' or (B.GROUP_ID <> ' ' AND EXISTS (SELECT 'X' FROM PS_GROUP_CONTROL WHERE GROUP_BU = B.DEPOSIT_BU AND GROUP_ID = B.GROUP_ID AND POST_STATUS <> 'C' ) ) or (B.GROUP_ID <> ' ' AND NOT EXISTS (SELECT 'X' FROM PS_GROUP_CONTROL WHERE GROUP_BU = B.DEPOSIT_BU AND GROUP_ID = B.GROUP_ID ) ) ) |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | BUSINESS_UNIT |
Character(5) | VARCHAR2(5) NOT NULL |
Business Unit
Default Value: OPR_DEF_TBL_FS.BUSINESS_UNIT Prompt Table: SP_BUARDS_NONVW |
| 2 | 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_BI_A2_VW |