ORDENT_SHKEY_VW (SQL View)	Index Back
BUIN key fields with name BUIN_SHP_KEYFLD with names.

ORDENT_SHKEY_VW

(SQL View)

BUIN key fields with name

BUIN_SHP_KEYFLD with names.

SELECT i.business_unit , i.fieldname , l.longname FROM PSDBFLDLABL l , ps_inv_shpfld_dtl i WHERE l.fieldname = i.fieldname AND l.default_label = 1

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 SHIP_FROM_BU Character(5) VARCHAR2(5) NOT NULL Ship from INV BU

2 FIELDNAME Character(18) VARCHAR2(18) NOT NULL Field Name (see PSDBFIELD).
Prompt Table: PSDBFIELD

3 LONGNAME Character(30) VARCHAR2(30) NOT NULL Long Name

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	SHIP_FROM_BU	Character(5)	VARCHAR2(5) NOT NULL	Ship from INV BU
2	FIELDNAME	Character(18)	VARCHAR2(18) NOT NULL	Field Name (see PSDBFIELD). Prompt Table: PSDBFIELD
3	LONGNAME	Character(30)	VARCHAR2(30) NOT NULL	Long Name