GM_PE_REVCH_VW(SQL View) |
Index Back |
---|
SELECT BILL_AMT , CURRENCY_CD , CONF_LEVEL , DUE_DT , TITLE56 FROM PS_GM_PROPOSAL |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | BILL_AMT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Bill Amount |
2 | CURRENCY_CD | Character(3) | VARCHAR2(3) NOT NULL | Currency Code |
3 | CONF_LEVEL | Character(1) | VARCHAR2(1) NOT NULL |
Confidence Level
H=01 - High L=O3 - Low M=02 - Medium |
4 | DUE_DT | Date(10) | DATE | Specifies the date that a transaction is due. It is a generic field used in multiple PeopleSoft applications including Receivables Payables and Purchasing. For example it represents the date that payment is due for a voucher or the date that a scheduled shipment is due to be received. |
5 | TITLE56 | Character(56) | VARCHAR2(56) NOT NULL | TITLE56 |