SETIDPrompt Table: SP_SETID_NONVW
CUST_IDPrompt Table: CUSTOMER
Prompt Table: DISPUTE_TBL
Prompt Table: COLLECTION_TBL
FO_CUS_CRDT_CUR(SQL View) |
Index Back |
|---|---|
Customer Credit InformationDATE INIT ISSUE DESCR 051101 MC 7304301 Deleted defaults for cur cd & rate type 072401 JJM DI-EDWONG-17 Added fields for Receivables |
| SELECT A.setid , A.cust_id ,A.dispute_status , A.collection_status FROM %Table(cust_credit) A WHERE %EffdtCheck(CUST_CREDIT B, A, %currentdatein) |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | SETID |
Character(5) | VARCHAR2(5) NOT NULL |
SetID
Prompt Table: SP_SETID_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: CUSTOMER |
| 3 | DISPUTE_STATUS | Character(3) | VARCHAR2(3) NOT NULL |
Specifies the reason that an item or customer is in dispute. For example the dispute status code might represent pricing error.
Prompt Table: DISPUTE_TBL |
| 4 | COLLECTION_STATUS | Character(3) | VARCHAR2(3) NOT NULL |
Specifies a collection agency or the reason for placing a customer in collection. Collection status indicates that the customer is delinquent in making payments or the invoice is more than 120 days past due.
Prompt Table: COLLECTION_TBL |