| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 TEST_CASE |
Character(30) |
VARCHAR2(30) NOT NULL |
BTF Test Case
|
| 2 |
COMPARE_TYPE |
Character(1) |
VARCHAR2(1) NOT NULL |
Compare report type
1=Delta (Results v.s Expected)
2=Expected data not in Results
3=Unexpected data in Results
|
| 3 |
COMPARE_SOURCE |
Character(1) |
VARCHAR2(1) NOT NULL |
Compare data source (Actuals or Expected results).
A=Actuals
E=Expected
|
| 4 |
INTFC_ID |
Number(8,0) |
INTEGER NOT NULL |
Interface ID
|
| 5 |
INTFC_LINE_NUM |
Number(8,0) |
INTEGER NOT NULL |
Interface Line Number
|
| 6 |
BUSINESS_UNIT |
Character(5) |
VARCHAR2(5) NOT NULL |
Business Unit
Default Value: OPR_DEF_TBL_FS.BUSINESS_UNIT
Prompt Table:
SP_BU_AM_CLSVW
|
| 7 |
ASSET_ID |
Character(12) |
VARCHAR2(12) NOT NULL |
Asset Identification
|
| 8 |
INTFC_TYPE |
Character(3) |
VARCHAR2(3) NOT NULL |
Trans Load Type
|
| 9 |
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.
|
| 10 |
MC_DEFN_ID |
Character(30) |
VARCHAR2(30) NOT NULL |
Mass Change Definition
|
| 11 |
APPROVAL_SW |
Character(1) |
VARCHAR2(1) NOT NULL |
Auto Approval Status
Y/N Table Edit
Default Value: Y
|
| 12 |
INTFC_STATUS |
Character(3) |
VARCHAR2(3) NOT NULL |
Interface Status
CON=Consolidated
DON=Mass Changes Generated
ERR=Error
NEW=Mass Changes Not Generated
REP=Replaced by Other Records (AP)
UNI=Unitized
Default Value: DON
|
| 13 |
LOAD_STATUS |
Character(3) |
VARCHAR2(3) NOT NULL |
/* -> JMZ. PSOFT. 11-OCT-2002 */
New Status were added : HLD and INP for Asset Management.
/* <- JMZ. PSOFT. 11-OCT-2002 */
CON=Consolidated
DON=Loaded
ERR=Errored
EXC=Excluded
HLD=On Hold
INP=In Process
NEW=Pending
PGI=PO Grp Incomplete
REP=Replaced
UNI=Unitized
Default Value: NEW
|
| 14 |
ATTRIBUTE_EFFDT |
Date(10) |
DATE |
Asset Attribute Effective Date
|
| 15 |
ASSET_COLOR |
Character(15) |
VARCHAR2(15) NOT NULL |
Asset Color
|
| 16 |
ASSET_WEIGHT |
Number(13,3) |
DECIMAL(12,3) NOT NULL |
Asset Weight
|
| 17 |
WEIGHT_UM |
Character(3) |
VARCHAR2(3) NOT NULL |
Asset Weight Unit of Measure
|
| 18 |
ASSET_HEIGHT |
Number(13,3) |
DECIMAL(12,3) NOT NULL |
Asset Height
|
| 19 |
HEIGHT_UM |
Character(3) |
VARCHAR2(3) NOT NULL |
Asset Height Unit of Measure
|
| 20 |
ASSET_WIDTH |
Number(13,3) |
DECIMAL(12,3) NOT NULL |
Asset Width
|
| 21 |
WIDTH_UM |
Character(3) |
VARCHAR2(3) NOT NULL |
Asset Width Unit of Measure
|
| 22 |
ASSET_LENGTH |
Number(13,3) |
DECIMAL(12,3) NOT NULL |
Asset Length
|
| 23 |
LENGTH_UM |
Character(3) |
VARCHAR2(3) NOT NULL |
Asset Length Unit of Measure
|
| 24 |
ASSET_CAPACITY |
Number(13,3) |
DECIMAL(12,3) NOT NULL |
Asset Capacity
|
| 25 |
CAPACITY_UM |
Character(3) |
VARCHAR2(3) NOT NULL |
Capacity Units
|
| 26 |
POWER_RATING |
Number(13,3) |
DECIMAL(12,3) NOT NULL |
Power Rating
|
| 27 |
POWER_RATING_UM |
Character(3) |
VARCHAR2(3) NOT NULL |
Power Rating Units
|
| 28 |
COMMENT_DTTM_STAMP |
DateTime(26) |
TIMESTAMP |
Asset Comments Date Time Stamp
|
| 29 |
NAME |
Character(50) |
VARCHAR2(50) NOT NULL |
Name
|
| 30 |
COMMENTS50 |
Character(50) |
VARCHAR2(50) NOT NULL |
Asset Comments
|
| 31 |
AGENCY_ID |
Character(20) |
VARCHAR2(20) NOT NULL |
Agency ID
|
| 32 |
LICENSE_VENDOR_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Asset Licence Supplier Id
|
| 33 |
REGISTRATION_NO |
Character(25) |
VARCHAR2(25) NOT NULL |
Registration #
|
| 34 |
INSPECTION_SW |
Character(1) |
VARCHAR2(1) NOT NULL |
Inspection Required
N=Not Inspected
Y=Inspected
|
| 35 |
LIC_START_DT |
Date(10) |
DATE |
License Effective Date
|
| 36 |
LIC_END_DT |
Date(10) |
DATE |
License Expiry Date
|
| 37 |
REGISTER_NAME |
Character(30) |
VARCHAR2(30) NOT NULL |
Name
|
| 38 |
COUNTRY |
Character(3) |
VARCHAR2(3) NOT NULL |
Country
Prompt Table:
COUNTRY_TBL
|
| 39 |
ADDRESS1 |
Character(55) |
VARCHAR2(55) NOT NULL |
Address 1
|
| 40 |
ADDRESS2 |
Character(55) |
VARCHAR2(55) NOT NULL |
Address 2
|
| 41 |
ADDRESS3 |
Character(55) |
VARCHAR2(55) NOT NULL |
Address 3
|
| 42 |
ADDRESS4 |
Character(55) |
VARCHAR2(55) NOT NULL |
Address 4
|
| 43 |
CITY |
Character(30) |
VARCHAR2(30) NOT NULL |
City
|
| 44 |
NUM1 |
Character(6) |
VARCHAR2(6) NOT NULL |
Number 1
|
| 45 |
NUM2 |
Character(6) |
VARCHAR2(6) NOT NULL |
Number 2
|
| 46 |
HOUSE_TYPE |
Character(2) |
VARCHAR2(2) NOT NULL |
House Type
AB=House Boat
WW=Trailer
|
| 47 |
ADDR_FIELD1 |
Character(2) |
VARCHAR2(2) NOT NULL |
Address Field 1
|
| 48 |
ADDR_FIELD2 |
Character(4) |
VARCHAR2(4) NOT NULL |
Address Field 2
|
| 49 |
ADDR_FIELD3 |
Character(4) |
VARCHAR2(4) NOT NULL |
Address Field 3
|
| 50 |
COUNTY |
Character(30) |
VARCHAR2(30) NOT NULL |
County
|
| 51 |
STATE |
Character(6) |
VARCHAR2(6) NOT NULL |
State
Prompt Table:
%EDIT_STATE
|
| 52 |
POSTAL |
Character(12) |
VARCHAR2(12) NOT NULL |
Postal
|
| 53 |
GEO_CODE |
Character(11) |
VARCHAR2(11) NOT NULL |
Geo Code
|
| 54 |
IN_CITY_LIMIT |
Character(1) |
VARCHAR2(1) NOT NULL |
In City Limit
Y/N Table Edit
|
| 55 |
JURISDICTION |
Character(5) |
VARCHAR2(5) NOT NULL |
Jurisdiction
|
| 56 |
LICENSE_COMMENTS50 |
Character(50) |
VARCHAR2(50) NOT NULL |
Asset License Comments
|
| 57 |
WARRANTY_EFFDT |
Date(10) |
DATE |
Asset Warranty Effdt
|
| 58 |
EFF_STATUS |
Character(1) |
VARCHAR2(1) NOT NULL |
Effective Status
A=Active
I=Inactive
|
| 59 |
WARRANTY_VENDOR_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Warranty Supplier ID
|
| 60 |
WARRANTY_NUM |
Character(30) |
VARCHAR2(30) NOT NULL |
Warranty Number
|
| 61 |
WARRANTY_DURATION |
Number(5,0) |
INTEGER NOT NULL |
Warranty Duration (months)
|
| 62 |
COVERAGE50 |
Character(50) |
VARCHAR2(50) NOT NULL |
Warranty Coverage
|
| 63 |
AM_AST_UD_CHAR1 |
Character(10) |
VARCHAR2(10) NOT NULL |
User Defined Char Field1
|
| 64 |
AM_AST_UD_CHAR2 |
Character(10) |
VARCHAR2(10) NOT NULL |
User Defined Char Field2
|
| 65 |
AM_AST_UD_DATE1 |
Date(10) |
DATE |
User Defined Date Field1
|
| 66 |
AM_AST_UD_NUM1 |
Number(19,3) |
DECIMAL(18,3) NOT NULL |
User Defined Number Field1
|
| 67 |
AM_AST_UD_NUM2 |
Number(19,3) |
DECIMAL(18,3) NOT NULL |
User Defined Number Field2
|
| 68 |
PROCESS_INSTANCE |
Number(10,0) |
DECIMAL(10) NOT NULL |
Process Instance
|