BUSINESS_UNITDefault Value: OPR_DEF_TBL_CS.BUSINESS_UNIT
Prompt Table: SP_BU_SF_NONVW
EMPLIDDefault Value: NEW
Prompt Table: PERSONAL_DATA
SSF_ACCT_LN_VW(SQL View) |
Index Back |
|---|---|
Pending Billing Line viewProvides a view of the Pending Line Items |
| SELECT A.BUSINESS_UNIT ,A.EMPLID ,A.LINE_AMT ,A.ITEM_TERM ,A.POSTED_DATE ,A.DESCR FROM PS_ITEM_LINE_SF A WHERE A.BILLING_FLAG = 'N' |
| # | 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_CS.BUSINESS_UNIT Prompt Table: SP_BU_SF_NONVW |
| 2 | EMPLID |
Character(11) | VARCHAR2(11) NOT NULL |
Employee ID
Default Value: NEW Prompt Table: PERSONAL_DATA |
| 3 | LINE_AMT | Signed Number(18,2) | DECIMAL(16,2) NOT NULL | Line Amount |
| 4 | ITEM_TERM | Character(4) | VARCHAR2(4) NOT NULL | Item Term |
| 5 | POSTED_DATE | Date(10) | DATE | Date Posted |
| 6 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |