CA_PGP_CST_SRCH(SQL View) |
Index Back |
|---|
| SELECT B.BUSINESS_UNIT ,A.CONTRACT_NUM ,B.DESCR ,CA_PGP_SEQ ,B.BILL_TO_CUST_ID ,CA_PGP_AMT ,REMAINING_AMOUNT ,CA_PGP_LIQ_RATE ,CA_PGP_RATE ,CA_PGP_STATUS ,A.CURRENCY_CD FROM PS_CA_PGP_TERMS A , PS_CA_CONTR_HDR B WHERE A.CONTRACT_NUM = B.CONTRACT_NUM |
| # | 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_CA.BUSINESS_UNIT Prompt Table: SP_BU_CA_NONVW |
| 2 | CONTRACT_NUM |
Character(25) | VARCHAR2(25) NOT NULL |
Contract
Prompt Table: CA_PREPAID_SRCH |
| 3 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
| 4 | CA_PGP_SEQ |
Number(3,0) | SMALLINT NOT NULL | Progress Payment Sequence |
| 5 | BILL_TO_CUST_ID | Character(15) | VARCHAR2(15) NOT NULL | Customer |
| 6 | CA_PGP_AMT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Progress Payment Amount |
| 7 | REMAINING_AMOUNT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Remaining Amount |
| 8 | CA_PGP_LIQ_RATE | Number(6,2) | DECIMAL(5,2) NOT NULL |
Liquidation rate
Default Value: BUS_UNIT_TBL_CA.CA_PGP_LIQ_RATE |
| 9 | CA_PGP_RATE | Number(6,2) | DECIMAL(5,2) NOT NULL |
Progress Payment Rate
Default Value: BUS_UNIT_TBL_CA.CA_PGP_RATE |
| 10 | CA_PGP_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Progress Payment Status
A=Ready C=Completed P=Pending X=Cancelled Default Value: P |
| 11 | CURRENCY_CD | Character(3) | VARCHAR2(3) NOT NULL | Currency Code |