| # |
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_NONVW
|
| 7 |
ASSET_ID |
Character(12) |
VARCHAR2(12) NOT NULL |
Asset Identification
|
| 8 |
ASSET_TYPE |
Character(3) |
VARCHAR2(3) NOT NULL |
Asset Type
010=IT Hardware
020=IT Software
040=Equipment
050=Property
060=Fleet
070=Machinery
080=Furniture
090=Facility
100=Intangible
200=Asset Retirement Obligations
999=Other
|
| 9 |
ASSET_SUBTYPE |
Character(15) |
VARCHAR2(15) NOT NULL |
Asset Subtype
|
| 10 |
DTTM_STAMP |
DateTime(26) |
TIMESTAMP |
Specifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.
|
| 11 |
VOUCHER_ID |
Character(8) |
VARCHAR2(8) NOT NULL |
Voucher ID
|
| 12 |
VOUCHER_LINE_NUM |
Number(5,0) |
INTEGER NOT NULL |
Voucher Line Number
|
| 13 |
DISTRIB_LINE_NUM |
Number(5,0) |
INTEGER NOT NULL |
Distribution Line
|
| 14 |
INTFC_TYPE |
Character(3) |
VARCHAR2(3) NOT NULL |
Trans Load Type
|
| 15 |
MC_DEFN_ID |
Character(30) |
VARCHAR2(30) NOT NULL |
Mass Change Definition
|
| 16 |
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.
|
| 17 |
APPROVAL_SW |
Character(1) |
VARCHAR2(1) NOT NULL |
Auto Approval Status
Y/N Table Edit
Default Value: Y
|
| 18 |
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
|
| 19 |
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
|
| 20 |
ORIG_INTFC_ID |
Number(8,0) |
INTEGER NOT NULL |
Original Interface ID
|
| 21 |
ORIG_LINE_NUM |
Number(8,0) |
INTEGER NOT NULL |
Original Interface Line Number
|
| 22 |
DEFAULT_PROFILE_SW |
Character(1) |
VARCHAR2(1) NOT NULL |
Default Books from Profile
Y/N Table Edit
Default Value: N
|
| 23 |
TRANS_IN_OUT |
Character(1) |
VARCHAR2(1) NOT NULL |
Transaction In/Out
I=In
M=IUT Proceeds Markup
O=Out
|
| 24 |
PARENT_ID |
Character(12) |
VARCHAR2(12) NOT NULL |
Parent ID
|
| 25 |
PARENT_DESCR |
Character(30) |
VARCHAR2(30) NOT NULL |
Parent Asset Description
|
| 26 |
PARENT_DESCRLONG50 |
Character(50) |
VARCHAR2(50) NOT NULL |
Parent Asset Long Description
|
| 27 |
COMPONENT_OF_ID |
Character(12) |
VARCHAR2(12) NOT NULL |
Component of Asset
|
| 28 |
ASSET_ASSIGNED_TO |
Character(12) |
VARCHAR2(12) NOT NULL |
Asset Assigned To
|
| 29 |
TAGGABLE_SW |
Character(1) |
VARCHAR2(1) NOT NULL |
Taggable Asset
N=Non Taggable Asset
Y=Taggable Asset
|
| 30 |
TAG_NUMBER |
Character(12) |
VARCHAR2(12) NOT NULL |
Tag Number
|
| 31 |
DESCR |
Character(30) |
VARCHAR2(30) NOT NULL |
Description
|
| 32 |
DESCRSHORT |
Character(10) |
VARCHAR2(10) NOT NULL |
Short Description
Default Value: INTFC_PHY_A.DESCR
|
| 33 |
ASSET_STATUS |
Character(1) |
VARCHAR2(1) NOT NULL |
Asset Status
A=Received (Not in Service)
B=Budgeted
C=Commitment
D=Disposed
I=In Service
M=Suspended
R=Requisitioned
T=Transferred
W=Work In Progress
Default Value: I
|
| 34 |
FINANCIAL_ASSET_SW |
Character(1) |
VARCHAR2(1) NOT NULL |
Capitalized Asset
N=Non Cap
Y=Capitalize
Y/N Table Edit
Default Value: Y
|
| 35 |
REPLACE_SW |
Character(1) |
VARCHAR2(1) NOT NULL |
Replacement Asset
Y/N Table Edit
Default Value: N
|
| 36 |
REPLACE_ASSET_ID |
Character(12) |
VARCHAR2(12) NOT NULL |
Replaced Asset ID
|
| 37 |
CONVERSION_ID |
Character(15) |
VARCHAR2(15) NOT NULL |
Old Asset ID
|
| 38 |
NEW_ASSET_SW |
Character(1) |
VARCHAR2(1) NOT NULL |
New Asset
N=Used Asset
Y=New Asset
Default Value: Y
|
| 39 |
AVAIL_SW |
Character(1) |
VARCHAR2(1) NOT NULL |
Asset is Available
Y/N Table Edit
Default Value: N
|
| 40 |
AVAIL_CONTACT |
Character(30) |
VARCHAR2(30) NOT NULL |
Availability Contact
|
| 41 |
AVAIL_PHONE |
Character(12) |
VARCHAR2(12) NOT NULL |
Availability Phone
|
| 42 |
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
Default Value: P
|
| 43 |
ACQUISITION_DT |
Date(10) |
DATE |
Acquisition Date
|
| 44 |
FINANCING_CD |
Character(5) |
VARCHAR2(5) NOT NULL |
Financing Code
|
| 45 |
ASSET_DTTM_STAMP |
DateTime(26) |
TIMESTAMP |
Asset Date Time Stamp
|
| 46 |
PROFILE_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Asset Profile ID
|
| 47 |
ASSET_CLASS |
Character(10) |
VARCHAR2(10) NOT NULL |
Asset Class
|
| 48 |
CAP_NUM |
Character(15) |
VARCHAR2(15) NOT NULL |
Capital Acquisition Plan #
|
| 49 |
MFG_ID |
Character(50) |
VARCHAR2(50) NOT NULL |
Manufacturer ID
|
| 50 |
MANUFACTURER |
Character(60) |
VARCHAR2(60) NOT NULL |
Manufacturer Name
|
| 51 |
MODEL |
Character(30) |
VARCHAR2(30) NOT NULL |
Model
|
| 52 |
PROD_VERSION |
Character(10) |
VARCHAR2(10) NOT NULL |
Product Version
|
| 53 |
SERIAL_ID |
Character(20) |
VARCHAR2(20) NOT NULL |
Serial ID
|
| 54 |
PRODUCTION_DT |
Date(10) |
DATE |
Production Date
|
| 55 |
PLANT |
Character(30) |
VARCHAR2(30) NOT NULL |
Manufacturing Plant
|
| 56 |
MANUFACTUR_CONTACT |
Character(30) |
VARCHAR2(30) NOT NULL |
Manufacturing Contact
|
| 57 |
CAP_SEQUENCE |
Number(3,0) |
SMALLINT NOT NULL |
CAP Sequence
|
| 58 |
REPLACEMENT_COST |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Replacement Cost
|
| 59 |
LEASE_ASSET_ID |
Character(12) |
VARCHAR2(12) NOT NULL |
Lease Asset ID
|
| 60 |
BUSINESS_UNIT_JV |
Character(5) |
VARCHAR2(5) NOT NULL |
Joint Venture BUS Unit
|
| 61 |
INDEX_NAME |
Character(20) |
VARCHAR2(20) NOT NULL |
Index Name
|
| 62 |
INDEX_DETAIL_NAME |
Character(35) |
VARCHAR2(35) NOT NULL |
SubIndex Name
|
| 63 |
LAST_INDEX_VALUE |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Last Index Value
|
| 64 |
COMPOSITE_SW |
Character(1) |
VARCHAR2(1) NOT NULL |
Composite Asset
Default Value: N
|
| 65 |
COMPOSITE_ID |
Character(12) |
VARCHAR2(12) NOT NULL |
Composite Asset ID
|
| 66 |
FERC_CD |
Character(10) |
VARCHAR2(10) NOT NULL |
FERC Code
|
| 67 |
SEQUENCE_NBR_6 |
Number(6,0) |
INTEGER NOT NULL |
Sequence
|
| 68 |
ACQUISITION_DESCR |
Character(30) |
VARCHAR2(30) NOT NULL |
DESCR field for ACQ_DETAIL
|
| 69 |
CAPITALIZATION_SW |
Character(1) |
VARCHAR2(1) NOT NULL |
Capitalized
0=To Capitalize Later
1=To be Capitalized
2=Already Capitalized
3=Never Capitalize
4=Already Non Capitalized
5=Consolidated
|
| 70 |
BUSINESS_UNIT_AP |
Character(5) |
VARCHAR2(5) NOT NULL |
AP Business Unit
|
| 71 |
TXN_CURRENCY_CD |
Character(3) |
VARCHAR2(3) NOT NULL |
Transaction Currency
|
| 72 |
CURRENCY_CD |
Character(3) |
VARCHAR2(3) NOT NULL |
Currency Code
|
| 73 |
RATE_DIV |
Number(16,8) |
DECIMAL(15,8) NOT NULL |
Rate Divisor
|
| 74 |
RATE_MULT |
Signed Number(17,8) |
DECIMAL(15,8) NOT NULL |
Rate Multiplier
|
| 75 |
RT_TYPE |
Character(5) |
VARCHAR2(5) NOT NULL |
Defines a category of market rates for currency conversion. Some examples of rate types are commercial, average, floating, and historical.
|
| 76 |
BUSINESS_UNIT_PO |
Character(5) |
VARCHAR2(5) NOT NULL |
PO Business Unit
|
| 77 |
PO_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Purchase Order
|
| 78 |
PO_LINE_NBR |
Number(5,0) |
INTEGER NOT NULL |
Purchase Order Line Number
|
| 79 |
SCHED_NBR |
Number(3,0) |
SMALLINT NOT NULL |
Schedule Number
|
| 80 |
PO_DIST_LINE_NUM |
Number(5,0) |
INTEGER NOT NULL |
PO Distribution Line Number
|
| 81 |
REFERENCE_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Reference ID
|
| 82 |
INVOICE_DT |
Date(10) |
DATE |
Invoice Date
|
| 83 |
VENDOR_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Vendor Identifier
|
| 84 |
VENDOR_NAME |
Character(30) |
VARCHAR2(30) NOT NULL |
Supplier Name
|
| 85 |
INVOICE_ID |
Character(30) |
VARCHAR2(30) NOT NULL |
Invoice Number
|
| 86 |
TXN_AMOUNT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Transaction Amount
|
| 87 |
AMOUNT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Amount
|
| 88 |
QUANTITY |
Signed Number(17,4) |
DECIMAL(15,4) NOT NULL |
Qty Interface
|
| 89 |
SALETX_AMT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Sales Tax Amount
|
| 90 |
SALETX_AMT_BSE |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Base Sales Tax Amount
|
| 91 |
SALETX_CD |
Character(8) |
VARCHAR2(8) NOT NULL |
Sales Tax Code
|
| 92 |
USETAX_AMT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Amount
|
| 93 |
USETAX_AMT_BSE |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Base Use Tax Amount
|
| 94 |
USETAX_CD |
Character(8) |
VARCHAR2(8) NOT NULL |
Use Tax Code
|
| 95 |
FREIGHT_AMT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Freight Amount
|
| 96 |
FREIGHT_AMT_BSE |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Base Freight Amount
|
| 97 |
BUSINESS_UNIT_RECV |
Character(5) |
VARCHAR2(5) NOT NULL |
Receiving Business Unit
|
| 98 |
RECEIVER_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Receiver number
|
| 99 |
RECV_LN_NBR |
Number(5,0) |
INTEGER NOT NULL |
Receipt Line
|
| 100 |
RECV_SHIP_SEQ_NBR |
Number(3,0) |
SMALLINT NOT NULL |
Receiver Shipping Sequence
|
| 101 |
RECV_DIST_LINE_NUM |
Number(5,0) |
INTEGER NOT NULL |
Receiver Distrib Line
|
| 102 |
DISTRIB_SEQ_NUM |
Number(5,0) |
INTEGER NOT NULL |
Distribution Sequence
|
| 103 |
INV_ITEM_ID |
Character(18) |
VARCHAR2(18) NOT NULL |
Item ID
|
| 104 |
OPERATING_UNIT |
Character(8) |
VARCHAR2(8) NOT NULL |
Operating Unit ChartField
|
| 105 |
PRODUCT |
Character(6) |
VARCHAR2(6) NOT NULL |
Product ChartField
|
| 106 |
FUND_CODE |
Character(5) |
VARCHAR2(5) NOT NULL |
Fund Code
|
| 107 |
CLASS_FLD |
Character(5) |
VARCHAR2(5) NOT NULL |
Class Field
|
| 108 |
PROGRAM_CODE |
Character(5) |
VARCHAR2(5) NOT NULL |
Program Code ChartField
|
| 109 |
BUDGET_REF |
Character(8) |
VARCHAR2(8) NOT NULL |
Budget Reference
|
| 110 |
AFFILIATE |
Character(5) |
VARCHAR2(5) NOT NULL |
Affiliate
|
| 111 |
AFFILIATE_INTRA1 |
Character(10) |
VARCHAR2(10) NOT NULL |
IntraUnit Affiliate1
|
| 112 |
AFFILIATE_INTRA2 |
Character(10) |
VARCHAR2(10) NOT NULL |
Operating Unit Affiliate
|
| 113 |
CHARTFIELD1 |
Character(10) |
VARCHAR2(10) NOT NULL |
Expansion chartfield 1
|
| 114 |
CHARTFIELD2 |
Character(10) |
VARCHAR2(10) NOT NULL |
Expansion Chartfield 2
|
| 115 |
CHARTFIELD3 |
Character(10) |
VARCHAR2(10) NOT NULL |
Expansion Chartfield 3
|
| 116 |
PROJECT_ID |
Character(15) |
VARCHAR2(15) NOT NULL |
Project Id ChartField
|
| 117 |
DEPTID |
Character(10) |
VARCHAR2(10) NOT NULL |
Department
|
| 118 |
CATEGORY |
Character(5) |
VARCHAR2(5) NOT NULL |
Asset Category
|
| 119 |
COST_TYPE |
Character(1) |
VARCHAR2(1) NOT NULL |
Cost Type
|
| 120 |
BUSINESS_UNIT_PC |
Character(5) |
VARCHAR2(5) NOT NULL |
PC Business Unit
|
| 121 |
MASTER_PROJECT |
Character(15) |
VARCHAR2(15) NOT NULL |
Master Project
|
| 122 |
ACTIVITY_ID |
Character(15) |
VARCHAR2(15) NOT NULL |
Activity ID
|
| 123 |
RESOURCE_TYPE |
Character(5) |
VARCHAR2(5) NOT NULL |
Source Type
|
| 124 |
RESOURCE_SUB_CAT |
Character(5) |
VARCHAR2(5) NOT NULL |
Subcategory
|
| 125 |
ANALYSIS_TYPE |
Character(3) |
VARCHAR2(3) NOT NULL |
Analysis Type
|
| 126 |
RESOURCE_CATEGORY |
Character(5) |
VARCHAR2(5) NOT NULL |
Category
|
| 127 |
CUSTODIAN_EFFDT |
Date(10) |
DATE |
Asset Custodian Effective Dt
|
| 128 |
EFFSEQ |
Number(3,0) |
SMALLINT NOT NULL |
Effective Sequence
|
| 129 |
CUSTODIAN |
Character(30) |
VARCHAR2(30) NOT NULL |
Custodian
|
| 130 |
EMPLID |
Character(11) |
VARCHAR2(11) NOT NULL |
Employee ID
|
| 131 |
CUSTODIAN_DEPTID |
Character(10) |
VARCHAR2(10) NOT NULL |
Asset Custodian Deptid
|
| 132 |
CUSTODIAN_PROJECT |
Character(15) |
VARCHAR2(15) NOT NULL |
Asset Custodian Project
|
| 133 |
OFFSITE_SW |
Character(1) |
VARCHAR2(1) NOT NULL |
This Asset is Offsite
|
| 134 |
AUTH_STATUS |
Character(1) |
VARCHAR2(1) NOT NULL |
Authorization Status
A=Authorized
N=Not Authorized
P=Authorization Pending
|
| 135 |
AUTHORIZATION_NAME |
Character(30) |
VARCHAR2(30) NOT NULL |
Authorization Name
|
| 136 |
AUTHORIZATION_DT |
Date(10) |
DATE |
Date Authorized
|
| 137 |
LOCATION_EFFDT |
Date(10) |
DATE |
Location Effective Date
|
| 138 |
LOCATION_EFFSEQ |
Number(3,0) |
SMALLINT NOT NULL |
Asset Location Effective Seq
|
| 139 |
LOCATION |
Character(10) |
VARCHAR2(10) NOT NULL |
Location Code
|
| 140 |
PI_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Physical Inventory ID
|
| 141 |
INVENTORY_DT |
Date(10) |
DATE |
Inventory Date
|
| 142 |
PERFORMED_BY |
Character(30) |
VARCHAR2(30) NOT NULL |
Performed By
|
| 143 |
DOCUMENT_ID |
Character(12) |
VARCHAR2(12) NOT NULL |
Document
|
| 144 |
LOC_AUTH_STATUS |
Character(1) |
VARCHAR2(1) NOT NULL |
Location Authorization Status
|
| 145 |
LOC_AUTH_NAME |
Character(30) |
VARCHAR2(30) NOT NULL |
Location Authorization Name
|
| 146 |
LOC_AUTH_DT |
Date(10) |
DATE |
Location Authorization Date
|
| 147 |
REPLACE_COST_DT |
Date(10) |
DATE |
Last Update
|
| 148 |
GROUP_ASSET_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Group Asset Flag
G=Group Asset
M=Group Member
N=None
Default Value: N
|
| 149 |
GROUP_ASSET_ID |
Character(12) |
VARCHAR2(12) NOT NULL |
Group Asset ID
|
| 150 |
RD_PLANT_ASSET |
Character(1) |
VARCHAR2(1) NOT NULL |
R and D Plant Asset
|
| 151 |
RD_START_DT |
Date(10) |
DATE |
R and D Start Date
|
| 152 |
RD_USE_NBV |
Character(1) |
VARCHAR2(1) NOT NULL |
Use NBV for R and D
|
| 153 |
INCENTIVE_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Investment Incentive ID
|
| 154 |
IP_ADDRESS |
Character(39) |
VARCHAR2(39) NOT NULL |
Internet Protocol Address
|
| 155 |
IP_ALIAS |
Character(35) |
VARCHAR2(35) NOT NULL |
Internet Address Alias/UNC
|
| 156 |
MERCH_AMT_BSE |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Base Merchandise Amount
|
| 157 |
VAT_INV_AMT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
VAT Invoice Amount
|
| 158 |
VAT_INV_AMT_BSE |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
VAT Invoice Amt Base Curr
|
| 159 |
VAT_NRCVR_AMT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
VAT Non Recoverable
|
| 160 |
VAT_NRCVR_AMT_BSE |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
VAT NonRecoverable Amount
|
| 161 |
VAT_RCVRY_AMT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
VAT Recovery Amt
|
| 162 |
VAT_RCVRY_AMT_BSE |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
VAT Recovery Amt in Base Curr
|
| 163 |
MISC_AMT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Misc. Amount
|
| 164 |
MISC_AMT_BSE |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Base Misc. Amount
|
| 165 |
AM_AST_UD_CHAR1 |
Character(10) |
VARCHAR2(10) NOT NULL |
User Defined Char Field1
|
| 166 |
AM_AST_UD_CHAR2 |
Character(10) |
VARCHAR2(10) NOT NULL |
User Defined Char Field2
|
| 167 |
AM_AST_UD_DATE1 |
Date(10) |
DATE |
User Defined Date Field1
|
| 168 |
AM_AST_UD_NUM1 |
Number(19,3) |
DECIMAL(18,3) NOT NULL |
User Defined Number Field1
|
| 169 |
AM_AST_UD_NUM2 |
Number(19,3) |
DECIMAL(18,3) NOT NULL |
User Defined Number Field2
|
| 170 |
PROCESS_INSTANCE |
Number(10,0) |
DECIMAL(10) NOT NULL |
Process Instance
|
| 171 |
MERCHANDISE_AMT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Merchandise Amt
F_KDHIL_R87H8 062804 MLM: Added new Line Amount Received Label
|
| 172 |
SKU |
Character(50) |
VARCHAR2(50) NOT NULL |
Stock Keeping Unit
|
| 173 |
UPC_ID |
Character(18) |
VARCHAR2(18) NOT NULL |
Uniform Product Code ID
|
| 174 |
VIN |
Character(18) |
VARCHAR2(18) NOT NULL |
VIN
|
| 175 |
ASSET_RESOURCE_SW |
Character(1) |
VARCHAR2(1) NOT NULL |
Field to indicate that an Asset is used as a tool or resource
Y/N Table Edit
|
| 176 |
ALLOW_OVERBOOK_SW |
Character(1) |
VARCHAR2(1) NOT NULL |
Allow Overbooking
Y/N Table Edit
Default Value: N
|
| 177 |
CHARGE_BACK_SW |
Character(1) |
VARCHAR2(1) NOT NULL |
Charge Back Switch
D=Default
N=No
Y=Yes
Default Value: D
|
| 178 |
SCHEDULABLE_SW |
Character(1) |
VARCHAR2(1) NOT NULL |
Schedulable Switch
Y/N Table Edit
Default Value: N
|
| 179 |
EPL_TMPL_ID |
Character(15) |
VARCHAR2(15) NOT NULL |
Parts List Template
Prompt Table:
EPL_LOOKUP_VW
|
| 180 |
REPAIRABLE_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Repairable Flag
Y/N Table Edit
Default Value: N
|
| 181 |
REPAIR_STATUS |
Character(1) |
VARCHAR2(1) NOT NULL |
Repair Status
0=None
1=Needs Repair
2=In Repair
Default Value: 0
|
| 182 |
BUSINESS_UNIT_WO |
Character(5) |
VARCHAR2(5) NOT NULL |
Business Unit Work Order
Prompt Table:
SP_BU_WM_NONVW
|
| 183 |
SHOP_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Shop Identification
Prompt Table:
AM_WM_SHOP
|
| 184 |
UNOWNED_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Non-Owned Asset
Y/N Table Edit
|
| 185 |
WO_LOCATION_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Work Order Location
1=Shop Location
2=Asset Location
3=Other Location
|
| 186 |
OFFLINE_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Asset Offline
Y/N Table Edit
Default Value: N
|
| 187 |
ASSET_CRITICALITY |
Character(2) |
VARCHAR2(2) NOT NULL |
Asset Criticality
Prompt Table:
AM_CRIT_LVL
|
| 188 |
CREW_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Crew Name
Prompt Table:
AM_CREW_VW
|
| 189 |
AVAIL_FOR_USE |
Character(1) |
VARCHAR2(1) NOT NULL |
Available For Use
|
| 190 |
PROPERTY_ID |
Number(10,0) |
DECIMAL(10) NOT NULL |
Property ID
|
| 191 |
PROPERTY_DESCR |
Character(50) |
VARCHAR2(50) NOT NULL |
Property Description
|
| 192 |
PROPERTY_NM |
Character(50) |
VARCHAR2(50) NOT NULL |
Used to store an Asset Property Name
|
| 193 |
PROPERTY_CLASS |
Character(2) |
VARCHAR2(2) NOT NULL |
Property Class
10=Site
20=Building
30=Floor
40=Area
50=Space
|
| 194 |
PROPERTY_SUBCLASS |
Character(20) |
VARCHAR2(20) NOT NULL |
Property Subclass
010=Warehouse
Prompt Table:
AM_PROP_SUBC
|
| 195 |
PARENT_PROPERTY_ID |
Number(10,0) |
DECIMAL(10) NOT NULL |
Parent Property ID
Prompt Table:
%EDITTABLE
|
| 196 |
SITE_PROPERTY_ID |
Number(10,0) |
DECIMAL(10) NOT NULL |
Site ID
Prompt Table:
ASSET_SITE
|
| 197 |
BLDG_PROPERTY_ID |
Number(10,0) |
DECIMAL(10) NOT NULL |
Building ID
Prompt Table:
ASSET_BLDG
|
| 198 |
FLOOR_PROPERTY_ID |
Number(10,0) |
DECIMAL(10) NOT NULL |
Floor ID
Prompt Table:
ASSET_FLOOR
|
| 199 |
AREA_PROPERTY_ID |
Number(10,0) |
DECIMAL(10) NOT NULL |
Area ID
Prompt Table:
ASSET_AREA
|
| 200 |
SPACE_PROPERTY_ID |
Number(10,0) |
DECIMAL(10) NOT NULL |
Space ID
Prompt Table:
ASSET_SPACE
|
| 201 |
PARCEL_NUMBER |
Character(30) |
VARCHAR2(30) NOT NULL |
Parcel Number
|
| 202 |
LOT |
Character(20) |
VARCHAR2(20) NOT NULL |
Lot Number
|
| 203 |
BLOCK |
Character(20) |
VARCHAR2(20) NOT NULL |
Block Number
|
| 204 |
TOTAL_AREA |
Number(18,3) |
DECIMAL(17,3) NOT NULL |
Total Area
|
| 205 |
SPACE_UOM |
Character(3) |
VARCHAR2(3) NOT NULL |
Space Unit of measure (Sq Feet or Sq Meters)
Default Value: 1
|
| 206 |
CURRENT_OCCUPANCY |
Number(7,0) |
INTEGER NOT NULL |
Current Occupancy
|
| 207 |
MAX_OCCUPANCY |
Number(8,0) |
INTEGER NOT NULL |
Maximum Occupancy
Default Value: 0
|
| 208 |
OCCUPANCY_STATUS |
Character(2) |
VARCHAR2(2) NOT NULL |
Occupancy Status
10=Occupied
20=Vacant
Default Value: 10
|
| 209 |
OWNERSHIP_STATUS |
Character(2) |
VARCHAR2(2) NOT NULL |
Ownership Status
10=Owned
20=Leased
Default Value: 10
|
| 210 |
IT_UD_CHAR1 |
Character(50) |
VARCHAR2(50) NOT NULL |
IT User Defined Char Field1
|
| 211 |
IT_UD_CHAR2 |
Character(50) |
VARCHAR2(50) NOT NULL |
IT User Defined Char Field2
|
| 212 |
IT_UD_DATE1 |
Date(10) |
DATE |
IT User Defined Date Field
|
| 213 |
IN_SERVICE_DT |
Date(10) |
DATE |
In Service Date
|
| 214 |
REGION_CD |
Character(10) |
VARCHAR2(10) NOT NULL |
Identifies the Sales Region. Populated on the Item Table to identify the Sales Region the Item is applied to.
|
| 215 |
CC_FLAG |
Character(3) |
VARCHAR2(3) NOT NULL |
Component Changeout Old/New
|
| 216 |
DESCR_LONG |
Character(254) |
VARCHAR2(254) NOT NULL |
Long Description
|
| 217 |
AREA_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Area ID
|
| 218 |
LINEAR_ASSET_SW |
Character(1) |
VARCHAR2(1) NOT NULL |
Linear Asset
Y/N Table Edit
Default Value: N
|
| 219 |
NBR_OF_CPU |
Number(3,0) |
SMALLINT NOT NULL |
Used by ITAM. Servers and Desktops can have multiple CPUs. A separate Software License is needed for each CPU.
|
| 220 |
CAP_THRSHLD_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Threshold ID
|
| 221 |
IN_PHY_USE |
Character(1) |
VARCHAR2(1) NOT NULL |
Describes if entity is in physical use.
Y/N Table Edit
Default Value: N
|
| 222 |
CAPVAL_VALUE |
Character(1) |
VARCHAR2(1) NOT NULL |
Capitalizaion Value
1=FIN to PHY
2=FIN to EXP
3=PHY to EXP
4=PHY to FIN
5=FIN to PHY - Book Level
6=PHY - FIN Book Level
|
| 223 |
VAT_SETID |
Character(5) |
VARCHAR2(5) NOT NULL |
VAT SetID
|
| 224 |
VAT_USE_ID |
Character(6) |
VARCHAR2(6) NOT NULL |
VAT Use Type
|
| 225 |
BUSINESS_UNIT_VAT |
Character(5) |
VARCHAR2(5) NOT NULL |
Vat Apportionment Business Uni
|
| 226 |
CHARTFIELD_PR1_VAL |
Character(20) |
VARCHAR2(20) NOT NULL |
Chartfield Priority 1 Value
|
| 227 |
CHARTFIELD_PR2_VAL |
Character(20) |
VARCHAR2(20) NOT NULL |
Chartfield Priority 2 Value
|
| 228 |
VAT_RECOVERY_PCT |
Signed Number(7,2) |
DECIMAL(5,2) NOT NULL |
VAT Recovery Percent
|
| 229 |
VAT_CONSTRAINT_PCT |
Number(6,2) |
DECIMAL(5,2) NOT NULL |
Coefficient of Constraint
|
| 230 |
VAT_TAXATION_PCT |
Number(6,2) |
DECIMAL(5,2) NOT NULL |
Coefficient of Taxation
|
| 231 |
VAT_ADMISSION_PCT |
Number(6,2) |
DECIMAL(5,2) NOT NULL |
Coefficient of Admission
|
| 232 |
TAX_CD_VAT |
Character(8) |
VARCHAR2(8) NOT NULL |
Defines the VAT (Value Added Tax) percentage (via link to the Tax Authority) and is used to retrieve VAT accounting ChartFields. The VAT code determines how the VAT amount is calculated on a transaction and how that amount is accounted and reported for.
|
| 233 |
ARO_SW |
Character(1) |
VARCHAR2(1) NOT NULL |
Asset Retirement Obligations
N=No
Y=Yes
|
| 234 |
ARO_ID |
Character(12) |
VARCHAR2(12) NOT NULL |
ARO Identification
|
| 235 |
PO_GROUP_ID |
Character(18) |
VARCHAR2(18) NOT NULL |
GroupID
|
| 236 |
PO_GRP_SEQ_NUM |
Number(8,0) |
INTEGER NOT NULL |
Procurement Group Sequence
|
| 237 |
PRIMARY_UNIT |
Character(1) |
VARCHAR2(1) NOT NULL |
Primary Unit
N=No
Y=Yes
Y/N Table Edit
|