RD_ALT_CAP_VW

(SQL View)
Index Back

Alternate Capacity with BO_ID

Alternate Capacity View with BO_ID

SELECT BO_ID , ALT_CAP_ID , TIN , TIN_TYPE , LEGAL_FORM , CHAM_OF_COMM_NBR , SETID , ROW_LASTMANT_OPRID , ROW_LASTMANT_DTTM FROM PS_RBF_ALT_CAP

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 BO_ID Signed Number(32,0) DECIMAL(31) NOT NULL Business Object ID
2 ALT_CAP_ID Character(15) VARCHAR2(15) NOT NULL Alternate Capacity ID

Default Value: NEXT

3 TIN Character(20) VARCHAR2(20) NOT NULL TIN
4 TIN_TYPE Character(1) VARCHAR2(1) NOT NULL Tin Type
F=Federal Employer ID
S=Social Security Number
5 LEGAL_FORM Character(30) VARCHAR2(30) NOT NULL legal form
6 CHAM_OF_COMM_NBR Character(18) VARCHAR2(18) NOT NULL Chamber of Commerce
7 SETID Character(5) VARCHAR2(5) NOT NULL This field is used to store the value of SetID on various setup tables.

Default Value: OPR_DEF_TBL_RB.SETID

Prompt Table: SP_SETID_NONVW

8 ROW_LASTMANT_OPRID Character(30) VARCHAR2(30) NOT NULL ID of user who last modified the row.
9 ROW_LASTMANT_DTTM DateTime(26) TIMESTAMP The date and time that the row was last updated.