BUSINESS_UNITACQUISITION_CDC=Constructed
D=Donated
I=Trade In
K=Like Exchange
L=Leased
P=Purchased
T=Transferred
PI_ACQUISITN_VW(SQL View) |
Index Back |
|---|---|
PI ACQUISITION VIEWPI ACQUISITION VIEW |
| SELECT DISTINCT A.BUSINESS_UNIT , A.ACQUISITION_CD FROM PS_PI_EXTRACT_VW A WHERE A.ACQUISITION_CD <> ' ' |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | BUSINESS_UNIT |
Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
| 2 | ACQUISITION_CD |
Character(1) | VARCHAR2(1) NOT NULL |
Acquisition Code
C=Constructed D=Donated I=Trade In K=Like Exchange L=Leased P=Purchased T=Transferred |