SII_INV_PPS_BI

(SQL Table)
Index Back

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance
2 SETID Character(5) VARCHAR2(5) NOT NULL SetID

Default Value: OPR_DEF_TBL_FS.SETID

Prompt Table: SP_SETID_NONVW

3 SII_PURPOSE_CD Character(5) VARCHAR2(5) NOT NULL Purpose Code
4 EFFDT Date(10) DATE NOT NULL Effective Date

Default Value: %date

5 SII_INV_DESCR Character(50) VARCHAR2(50) NOT NULL Invoice Purpuse