TRN2483_CPNYEQU

(SQL Table)
Index Back

Facility Equipment Details

Facility Equipment Details(2483 Report)

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 COMPANY Character(3) VARCHAR2(3) NOT NULL Company

Prompt Table: COMPANY_TBL

2 DECL_YR_2483_FRA Number(4,0) SMALLINT NOT NULL French Report 2483 : Declaring Year
3 FACILITY Character(6) VARCHAR2(6) NOT NULL Facility

Prompt Table: %EDITTABLE3

4 EQUIP_CD Character(4) VARCHAR2(4) NOT NULL Equipment/Materials Code

Prompt Table: %EDITTABLE4

5 PER_UNIT_COST Number(19,3) DECIMAL(18,3) NOT NULL Per Unit Cost
6 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code

Default Value: BUS_UNIT_OPT_HR.EXCHNG_TO_CURRENCY

Prompt Table: CURRENCY_CD_TBL

7 COST_UNIT_CD Character(10) VARCHAR2(10) NOT NULL Cost Unit

Prompt Table: CP_COST_UNIT_VW