BUSINESS_UNITPrompt Table: SP_BU_AM_NONVW
DEPTIDPrompt Table: DEPT_TBL
ACQUISITION_CDC=Constructed
D=Donated
I=Trade In
K=Like Exchange
L=Leased
P=Purchased
T=Transferred
CATEGORYPrompt Table: CATEGORY_TBL
PI_EXTRACT_CAT(SQL Table) |
Index Back |
|---|---|
Asset Physical InventoryStores exceptions to the physical inventory extract. |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | BUSINESS_UNIT |
Character(5) | VARCHAR2(5) NOT NULL |
Business Unit
Prompt Table: SP_BU_AM_NONVW |
| 2 | DEPTID |
Character(10) | VARCHAR2(10) NOT NULL |
Department
Prompt Table: DEPT_TBL |
| 3 | 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 |
| 4 | CATEGORY |
Character(5) | VARCHAR2(5) NOT NULL |
Asset Category
Prompt Table: CATEGORY_TBL |
| 5 | CYCLE_YEAR | Number(3,0) | SMALLINT NOT NULL | Cycle Year |