FO_ASSGN_VW

(SQL View)
 Index Back

Workflow triggering logic from

Workflow triggering logic from this Record.

SELECT A.ASSIGNMENT_ID , A.EMPLID , A.SYSTEM_SOURCE , A.BUSINESS_UNIT , A.SO_ID , A.CUST_ID , A.ADDRESS_SEQ_NUM , A.JOBCODE , B.SETID , B.STATE , B.COUNTRY , A.COMPANY FROM PS_RS_ASSIGNMENT A , PS_CUST_ADDRESS B WHERE A.CUST_ID = B.CUST_ID AND A.ADDRESS_SEQ_NUM = B.ADDRESS_SEQ_NUM AND %EffdtCheck(CUST_ADDRESS B_ED,B,%CurrentDateIn)

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 ASSIGNMENT_ID Character(15) VARCHAR2(15) NOT NULL Work Assignment ID

Default Value: NEXT

2 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID

Prompt Table: RS_WRKR_ADD_VW

3 SYSTEM_SOURCE Character(3) VARCHAR2(3) NOT NULL Identifies the application or source system that generated a journal entry. Release 8.80 - 11/14/2002 - RVlasic - Removed GDM (JrnlGen - Deduction Management) from Translate Values. SUJ---Included a label as Product. Release 8.9 - 05/11/2005 - RVlasic - Added PRV (Variance Pricing) and PKK (KK Budget Journal) and deleted GLK for Project Costing per Brian Cohen.

Default Value: RS

4 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit

Prompt Table: SP_BU_PC_NONVW

5 SO_ID Character(15) VARCHAR2(15) NOT NULL Service Order ID

Prompt Table: %EDITTABLE2

6 CUST_ID Character(15) VARCHAR2(15) NOT NULL Uniquely identifies an organizational entity that purchases goods or services from the enterprise. Represents the sold-to customer which is the customer organization that places orders. The CUST_ID may or may not be the same as the identifiers for the bill-to and ship-to locations.

Prompt Table: RS_CUSTOMER_VW

7 ADDRESS_SEQ_NUM Number(5,0) INTEGER NOT NULL Address Sequence Number

Prompt Table: %EDITTABLE7

8 JOBCODE Character(6) VARCHAR2(6) NOT NULL Job Code
9 SETID Character(5) VARCHAR2(5) NOT NULL SetID
10 STATE Character(6) VARCHAR2(6) NOT NULL State
11 COUNTRY Character(3) VARCHAR2(3) NOT NULL Country
12 COMPANY Character(3) VARCHAR2(3) NOT NULL Company