| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 PROCESS_INSTANCE |
Number(10,0) |
DECIMAL(10) NOT NULL |
Process Instance
|
| 2 |
OLD_TAG_NUMBER |
Character(12) |
VARCHAR2(12) NOT NULL |
Old Tag Number
|
| 3 |
OLD_DESCR |
Character(30) |
VARCHAR2(30) NOT NULL |
Old Description
|
| 4 |
OLD_FIN_ASSET_SW |
Character(1) |
VARCHAR2(1) NOT NULL |
Capitalized Asset
N=Not a Capitalized Asset
Y=Capitalized Asset
|
| 5 |
OLD_CAP_NUM |
Character(15) |
VARCHAR2(15) NOT NULL |
Capital Acquisition Plan #
|
| 6 |
OLD_CAP_SEQUENCE |
Number(3,0) |
SMALLINT NOT NULL |
CAP Sequence
|
| 7 |
OLD_MANUFACTURER |
Character(60) |
VARCHAR2(60) NOT NULL |
Old Manufacturer
|
| 8 |
OLD_MODEL |
Character(30) |
VARCHAR2(30) NOT NULL |
Old Model
|
| 9 |
OLD_SERIAL_ID |
Character(20) |
VARCHAR2(20) NOT NULL |
Old Serial Id
|
| 10 |
OLD_EMPLID |
Character(11) |
VARCHAR2(11) NOT NULL |
Old Emplid
|
| 11 |
OLD_CUSTODIAN |
Character(30) |
VARCHAR2(30) NOT NULL |
Old Custodian
|
| 12 |
OLD_LOCATION |
Character(10) |
VARCHAR2(10) NOT NULL |
Old Location
|
| 13 |
NEW_FIN_ASSET_SW |
Character(1) |
VARCHAR2(1) NOT NULL |
Capitalized Asset
N=Not a Capitalized Asset
Y=Capitalized Asset
|
| 14 |
NEW_PROFILE_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Asset Profile ID
|
| 15 |
PROF_CH |
Character(1) |
VARCHAR2(1) NOT NULL |
Profile Change
|
| 16 |
SERIAL_ID |
Character(20) |
VARCHAR2(20) NOT NULL |
Serial ID
|
| 17 |
MFG_ID |
Character(50) |
VARCHAR2(50) NOT NULL |
Manufacturer ID
|
| 18 |
MANUFACTURER |
Character(60) |
VARCHAR2(60) NOT NULL |
Manufacturer Name
|
| 19 |
MODEL |
Character(30) |
VARCHAR2(30) NOT NULL |
Model
|
| 20 |
VIN |
Character(18) |
VARCHAR2(18) NOT NULL |
VIN
|
| 21 |
UPC_ID |
Character(18) |
VARCHAR2(18) NOT NULL |
Uniform Product Code ID
|
| 22 |
CAP_NUM |
Character(15) |
VARCHAR2(15) NOT NULL |
Capital Acquisition Plan #
|
| 23 |
CAP_SEQUENCE |
Number(3,0) |
SMALLINT NOT NULL |
CAP Sequence
|
| 24 |
CUSTODIAN |
Character(30) |
VARCHAR2(30) NOT NULL |
Custodian
|
| 25 |
EMPLID |
Character(11) |
VARCHAR2(11) NOT NULL |
Employee ID
|
| 26 |
LOCATION |
Character(10) |
VARCHAR2(10) NOT NULL |
Location Code
|
| 27 |
LOCATION_EFFSEQ |
Number(3,0) |
SMALLINT NOT NULL |
Asset Location Effective Seq
|
| 28 |
CUSTODIAN_EFFSEQ |
Number(3,0) |
SMALLINT NOT NULL |
Asset Custodian Effective Seq
|
| 29 |
ASSET_CLASS |
Character(10) |
VARCHAR2(10) NOT NULL |
Asset Class
|
| 30 |
COSTADD |
Character(1) |
VARCHAR2(1) NOT NULL |
costadd
|
| 31 |
COSTADD2 |
Character(1) |
VARCHAR2(1) NOT NULL |
costadd
|
| 32 |
CURRENT_COST_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
CURRENT_COST_FLG
|
| 33 |
INV_ITEM_ID |
Character(18) |
VARCHAR2(18) NOT NULL |
Item ID
|
| 34 |
VENDOR_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Vendor Identifier
|
| 35 |
INVOICE_ID |
Character(30) |
VARCHAR2(30) NOT NULL |
Invoice Number
|
| 36 |
INVOICE_DT |
Date(10) |
DATE |
Invoice Date
|
| 37 |
OPERATING_UNIT |
Character(8) |
VARCHAR2(8) NOT NULL |
Operating Unit ChartField
Prompt Table:
OPERUNT_BUGL_VW
|
| 38 |
PRODUCT |
Character(6) |
VARCHAR2(6) NOT NULL |
Product ChartField
Prompt Table:
PRODUCT_BUGL_VW
|
| 39 |
FUND_CODE |
Character(5) |
VARCHAR2(5) NOT NULL |
Fund Code
Prompt Table:
FUND_BUGL_VW
|
| 40 |
CLASS_FLD |
Character(5) |
VARCHAR2(5) NOT NULL |
Class Field
Prompt Table:
CLASSCF_BUGL_VW
|
| 41 |
PROGRAM_CODE |
Character(5) |
VARCHAR2(5) NOT NULL |
Program Code ChartField
Prompt Table:
PROGRAM_BUGL_VW
|
| 42 |
BUDGET_REF |
Character(8) |
VARCHAR2(8) NOT NULL |
Budget Reference
Prompt Table:
BUD_REF_BUGL_VW
|
| 43 |
AFFILIATE |
Character(5) |
VARCHAR2(5) NOT NULL |
Affiliate
Prompt Table:
AFFILIATE_VW
|
| 44 |
AFFILIATE_INTRA1 |
Character(10) |
VARCHAR2(10) NOT NULL |
IntraUnit Affiliate1
Prompt Table:
%EDIT_INTRA01
|
| 45 |
AFFILIATE_INTRA2 |
Character(10) |
VARCHAR2(10) NOT NULL |
Operating Unit Affiliate
Prompt Table:
%EDIT_INTRA02
|
| 46 |
CHARTFIELD1 |
Character(10) |
VARCHAR2(10) NOT NULL |
Expansion chartfield 1
Prompt Table:
CF1_BUGL_VW
|
| 47 |
CHARTFIELD2 |
Character(10) |
VARCHAR2(10) NOT NULL |
Expansion Chartfield 2
Prompt Table:
CF2_BUGL_VW
|
| 48 |
CHARTFIELD3 |
Character(10) |
VARCHAR2(10) NOT NULL |
Expansion Chartfield 3
Prompt Table:
CF3_BUGL_VW
|
| 49 |
NUM_OF_ASSETS |
Number(5,0) |
INTEGER NOT NULL |
Count Work Field
|
| 50 |
ASSET_ALLOC_QTY |
Signed Number(17,2) |
DECIMAL(15,2) NOT NULL |
Asset Allocation Basis Qty
|
| 51 |
REQUEST_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Request ID
|
| 52 |
SALETX_CD |
Character(8) |
VARCHAR2(8) NOT NULL |
Sales Tax Code
|
| 53 |
USETAX_CD |
Character(8) |
VARCHAR2(8) NOT NULL |
Use Tax Code
|
| 54 |
CURRENCY_CD |
Character(3) |
VARCHAR2(3) NOT NULL |
Currency Code
|
| 55 |
LINE_NBR |
Number(5,0) |
INTEGER NOT NULL |
Line Number:
11/24/08 - Added TARGET label [PC product]
|
| 56 |
ASSET_ID_PO |
Character(12) |
VARCHAR2(12) NOT NULL |
Asset Identification
|
| 57 |
ASSET_ID_AP |
Character(12) |
VARCHAR2(12) NOT NULL |
Asset Identification
|
| 58 |
BUSINESS_UNIT_PC |
Character(5) |
VARCHAR2(5) NOT NULL |
PC Business Unit
|
| 59 |
ACTIVITY_ID |
Character(15) |
VARCHAR2(15) NOT NULL |
Activity ID
|
| 60 |
ANALYSIS_TYPE |
Character(3) |
VARCHAR2(3) NOT NULL |
Analysis Type
|
| 61 |
RESOURCE_CATEGORY |
Character(5) |
VARCHAR2(5) NOT NULL |
Category
|
| 62 |
RESOURCE_SUB_CAT |
Character(5) |
VARCHAR2(5) NOT NULL |
Subcategory
|
| 63 |
TXN_CURRENCY_CD |
Character(3) |
VARCHAR2(3) NOT NULL |
Transaction Currency
|
| 64 |
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
|
| 65 |
RESOURCE_TYPE |
Character(5) |
VARCHAR2(5) NOT NULL |
Source Type
|
| 66 |
ASSET_UE |
Character(1) |
VARCHAR2(1) NOT NULL |
Asset User Entered
|
| 67 |
PARENT_ID |
Character(12) |
VARCHAR2(12) NOT NULL |
Parent ID
|
| 68 |
REPLACE_SW |
Character(1) |
VARCHAR2(1) NOT NULL |
Replacement Asset
|
| 69 |
REPLACE_ASSET_ID |
Character(12) |
VARCHAR2(12) NOT NULL |
Replaced Asset ID
|
| 70 |
CONVERSION_ID |
Character(15) |
VARCHAR2(15) NOT NULL |
Old Asset ID
|
| 71 |
NEW_ASSET_SW |
Character(1) |
VARCHAR2(1) NOT NULL |
New Asset
N=Used Asset
Y=New Asset
|
| 72 |
AVAIL_SW |
Character(1) |
VARCHAR2(1) NOT NULL |
Asset is Available
|
| 73 |
AVAIL_CONTACT |
Character(30) |
VARCHAR2(30) NOT NULL |
Availability Contact
|
| 74 |
AVAIL_PHONE |
Character(12) |
VARCHAR2(12) NOT NULL |
Availability Phone
|
| 75 |
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
|
| 76 |
FINANCING_CD |
Character(5) |
VARCHAR2(5) NOT NULL |
Financing Code
|
| 77 |
REPLACEMENT_COST |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Replacement Cost
|
| 78 |
LEASE_ASSET_ID |
Character(12) |
VARCHAR2(12) NOT NULL |
Lease Asset ID
|
| 79 |
PROD_VERSION |
Character(10) |
VARCHAR2(10) NOT NULL |
Product Version
|
| 80 |
PRODUCTION_DT |
Date(10) |
DATE |
Production Date
|
| 81 |
PLANT |
Character(30) |
VARCHAR2(30) NOT NULL |
Manufacturing Plant
|
| 82 |
MANUFACTUR_CONTACT |
Character(30) |
VARCHAR2(30) NOT NULL |
Manufacturing Contact
|
| 83 |
BUSINESS_UNIT_JV |
Character(5) |
VARCHAR2(5) NOT NULL |
Joint Venture BUS Unit
|
| 84 |
INDEX_NAME |
Character(20) |
VARCHAR2(20) NOT NULL |
Index Name
|
| 85 |
INDEX_DETAIL_NAME |
Character(35) |
VARCHAR2(35) NOT NULL |
SubIndex Name
|
| 86 |
LAST_INDEX_VALUE |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Last Index Value
|
| 87 |
COMPOSITE_SW |
Character(1) |
VARCHAR2(1) NOT NULL |
Composite Asset
|
| 88 |
COMPOSITE_ID |
Character(12) |
VARCHAR2(12) NOT NULL |
Composite Asset ID
|
| 89 |
FERC_CD |
Character(10) |
VARCHAR2(10) NOT NULL |
FERC Code
|
| 90 |
GROUP_ASSET_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Group Asset Flag
G=Group Asset
M=Group Member
N=None
|
| 91 |
REPLACE_COST_DT |
Date(10) |
DATE |
Last Update
|
| 92 |
REFERENCE_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Reference ID
|
| 93 |
VENDOR_NAME |
Character(30) |
VARCHAR2(30) NOT NULL |
Supplier Name
|
| 94 |
NUM_RECORDS |
Number(15,0) |
DECIMAL(15) NOT NULL |
Number of Records
|
| 95 |
BASIS_RED_RECAP |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Basis Reduction Recapture
|
| 96 |
SEC179_TAKEN_SW |
Character(1) |
VARCHAR2(1) NOT NULL |
Section 179 Taken switch
N=Section 179 Expense not taken
Y=Section 179 Expense Taken
|
| 97 |
SEC179_AMT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Section 179 Taken Amount
|
| 98 |
ACTIVITY_SW |
Signed Number(2,0) |
DECIMAL(1) NOT NULL |
Activity Switch
|
| 99 |
TRANSFER_BU |
Character(5) |
VARCHAR2(5) NOT NULL |
Transfer Business Unit
|
| 100 |
TRANSFER_ASSET_ID |
Character(12) |
VARCHAR2(12) NOT NULL |
Transfer Asset ID
|
| 101 |
TRANSFER_BOOK |
Character(10) |
VARCHAR2(10) NOT NULL |
Transfer From Book
|
| 102 |
FISCAL_YEAR |
Number(4,0) |
SMALLINT NOT NULL |
Fiscal Year
|
| 103 |
START_PD |
Number(3,0) |
SMALLINT NOT NULL |
Start Period
|
| 104 |
END_PD |
Number(3,0) |
SMALLINT NOT NULL |
End Period
|
| 105 |
YTD_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Original Reserve
|
| 106 |
DEPR |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Depreciation Amt
|
| 107 |
DEPR_YTD |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Year to Date Depreciation
|
| 108 |
RETIRE_CONVENTION |
Character(2) |
VARCHAR2(2) NOT NULL |
Retirement Convention
|
| 109 |
END_DEPR_DT |
Date(10) |
DATE |
End Depreciation Date
|
| 110 |
VOLUNTARY |
Character(1) |
VARCHAR2(1) NOT NULL |
Voluntary Conversion
I=Involuntary
V=Voluntary Conversion
|
| 111 |
TRADE_IN_ASSET_ID |
Character(12) |
VARCHAR2(12) NOT NULL |
Trade In Asset
|
| 112 |
TRADE_IN_DTTM_STMP |
DateTime(26) |
TIMESTAMP |
Trade In DateTime Stamp
|
| 113 |
TRADE_IN_AMT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Trade In Amount
|
| 114 |
CASH |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Cash Received/Paid
|
| 115 |
TRADE_IN_VALUE |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Trade In value
|
| 116 |
LIABILITY_ASSUMED |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Liabilities Assumed
|
| 117 |
NON_LIKE_KIND |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
FMV Non Like Kind Property
|
| 118 |
REFERENCE |
Character(30) |
VARCHAR2(30) NOT NULL |
Field to show when a variable is a reference variable.
|
| 119 |
PROCEEDS |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Retirement Proceeds
|
| 120 |
REMOVAL_COST |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Removal Cost
|
| 121 |
RETIREMENT_RSV |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Accum Depr
|
| 122 |
GAIN_LOSS |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Retirement Gain/Loss
|
| 123 |
LEASE_REM_PAYMNTS |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Lease Remaining Payments
|
| 124 |
NEXT_OPEN_TRANS_ID |
Number(10,0) |
DECIMAL(10) NOT NULL |
Open Transaction ID
|
| 125 |
CALC_DEPR_STATUS |
Character(1) |
VARCHAR2(1) NOT NULL |
Depreciation Calc Status
C=Completed Depreciation
H=Held For Transfer In
I=In Processing
N=Never Calculate Depreciation
P=Pending Depreciation
|
| 126 |
CALC_DIST_STATUS |
Character(1) |
VARCHAR2(1) NOT NULL |
Acctg Entry Creation Status
C=Completed Distribution
N=Never Calculate Distribution
P=Pending Distribution
R=Reconcilie Clearing
|
| 127 |
MESSAGE_SET_NBR |
Number(5,0) |
INTEGER NOT NULL |
Message Set Number. This field refers to the Message Set Number in the Message Catalog.
|
| 128 |
MESSAGE_NBR |
Number(5,0) |
INTEGER NOT NULL |
Message Number. This field refers to the Message Number in the Message Catalog.
|
| 129 |
LIFE_END_DT |
Date(10) |
DATE |
Useful Life End Date
|
| 130 |
DEPR_LOW_LIMIT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Depr Low Limit Amount
|
| 131 |
SUSPEND_STATUS |
Character(1) |
VARCHAR2(1) NOT NULL |
Suspend Status
N=Depreciation Has Been Resumed
Y=Depreciation Is Suspended
|
| 132 |
SUSPEND_DT |
Date(10) |
DATE |
Suspend Date
|
| 133 |
RESUME_DT |
Date(10) |
DATE |
Resume Date
|
| 134 |
SUSPENDED_PERIODS |
Number(4,0) |
SMALLINT NOT NULL |
Number of Suspended Periods
|
| 135 |
COST_BASIS_LIMIT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Cost Basis Limit
|
| 136 |
DEPR_AVG_OPTION |
Character(1) |
VARCHAR2(1) NOT NULL |
Depreciation Averaging Option
M=Monthly Averaging
N=No Averaging
Y=Yearly Averaging
|
| 137 |
UOP_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Units of Production ID
|
| 138 |
IU_MAP_KEY |
Number(7,0) |
INTEGER NOT NULL |
InterUnit transfer map key
|
| 139 |
MC_DEFN_ID |
Character(30) |
VARCHAR2(30) NOT NULL |
Mass Change Definition
|
| 140 |
GROUP_ASSET_ID |
Character(12) |
VARCHAR2(12) NOT NULL |
Group Asset ID
|
| 141 |
UD_METHOD_ID |
Character(5) |
VARCHAR2(5) NOT NULL |
Method ID
|
| 142 |
INCLUDE_CAP_GAINS |
Character(1) |
VARCHAR2(1) NOT NULL |
CGT Applicable
|
| 143 |
REDUCED_COST |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Reduced Cost Basis
|
| 144 |
CAPITAL_G_L |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Capital Gains and Loss
|
| 145 |
RET_NON_CAP_AMT2 |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Non Capitalized CGT Amount
|
| 146 |
AM_BK_UD_CHAR1 |
Character(10) |
VARCHAR2(10) NOT NULL |
User Defined Char Field1
|
| 147 |
AM_BK_UD_CHAR2 |
Character(10) |
VARCHAR2(10) NOT NULL |
User Defined Char Field2
|
| 148 |
AM_BK_UD_DATE1 |
Date(10) |
DATE |
User Defined Date Field1
|
| 149 |
AM_BK_UD_NUM1 |
Number(19,3) |
DECIMAL(18,3) NOT NULL |
User Defined Number Field1
|
| 150 |
AM_BK_UD_NUM2 |
Number(19,3) |
DECIMAL(18,3) NOT NULL |
User Defined Number Field2
|
| 151 |
INCREASE_RATE |
Signed Number(11,6) |
DECIMAL(9,6) NOT NULL |
Increased Rate
|
| 152 |
ADDRESS_SEQ_NUM |
Number(5,0) |
INTEGER NOT NULL |
Address Sequence Number
|
| 153 |
ASSET_ID_SEQNO |
Number(5,0) |
INTEGER NOT NULL |
Asset ID Sequence Number
|
| 154 |
BILL_SOURCE_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Bill Source
|
| 155 |
BILL_TO_CUST_ID |
Character(15) |
VARCHAR2(15) NOT NULL |
Customer
|
| 156 |
DEPR_BONUS_PCT |
Number(6,2) |
DECIMAL(5,2) NOT NULL |
Depreciation Bonus Percent
|
| 157 |
DEPR_BONUS_SW |
Character(3) |
VARCHAR2(3) NOT NULL |
Resolution Date Description
-------------- ------- ------------------
753343 03/13/08 New depreciation bonus:Stimulus Act is added.
0=None
1=Section 101 - Federal
2=New York Liberty Zone
3=Section 101 - Local
4=Gulf Opportunity Zone
5=Stimulus Act
6=American Recovery&Reinvestment
Prompt Table:
AM_DEPR_BONUS
|
| 158 |
RATE_DIV_2 |
Number(16,8) |
DECIMAL(15,8) NOT NULL |
Rate Divisor
|
| 159 |
RATE_MULT_2 |
Signed Number(17,8) |
DECIMAL(15,8) NOT NULL |
Rate Multiplier
|
| 160 |
RT_EFFDT |
Date(10) |
DATE |
The effective date for a given item of market rate data.
|
| 161 |
SHIP_FROM_LOC |
Character(10) |
VARCHAR2(10) NOT NULL |
Ship From Location
|
| 162 |
SHIP_TO_ADDR_NUM |
Number(5,0) |
INTEGER NOT NULL |
Ship To Address Sequence Num
|
| 163 |
SHIP_TO_CUST_ID |
Character(15) |
VARCHAR2(15) NOT NULL |
Ship To Customer
|
| 164 |
SOLD_TO_ADDR_NUM |
Number(5,0) |
INTEGER NOT NULL |
Sold To Address Sequence Num
|
| 165 |
SOLD_TO_CUST_ID |
Character(15) |
VARCHAR2(15) NOT NULL |
Sold To Customer
|
| 166 |
TOT_OBLIGATION |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Lease Total Obligation
|
| 167 |
TXN_CASH |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Transaction Cash
|
| 168 |
TXN_CURRENCY_CD2 |
Character(3) |
VARCHAR2(3) NOT NULL |
Transaction Currency Display
|
| 169 |
TXN_LIAB_ASSUMED |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Transaction Liability Assumed
|
| 170 |
TXN_NON_LIKE_KIND |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
FMV Non Like-Kind
|
| 171 |
TXN_PROCEEDS |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Transaction Proceeds
|
| 172 |
TXN_REMOVAL_COST |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Transaction Removal Cost
|
| 173 |
TXN_TRADE_IN_VALUE |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Transaction Trade-In Value
|
| 174 |
PARENT_DESCR |
Character(30) |
VARCHAR2(30) NOT NULL |
Parent Asset Description
|
| 175 |
PARENT_DESCRLONG50 |
Character(50) |
VARCHAR2(50) NOT NULL |
Parent Asset Long Description
|
| 176 |
MASTER_PROJECT |
Character(15) |
VARCHAR2(15) NOT NULL |
Master Project
|
| 177 |
OFFSITE_SW |
Character(1) |
VARCHAR2(1) NOT NULL |
This Asset is Offsite
|
| 178 |
AUTH_STATUS |
Character(1) |
VARCHAR2(1) NOT NULL |
Authorization Status
A=Authorized
N=Not Authorized
P=Authorization Pending
|
| 179 |
AUTHORIZATION_NAME |
Character(30) |
VARCHAR2(30) NOT NULL |
Authorization Name
|
| 180 |
AUTHORIZATION_DT |
Date(10) |
DATE |
Date Authorized
|
| 181 |
INVENTORY_DT |
Date(10) |
DATE |
Inventory Date
|
| 182 |
PERFORMED_BY |
Character(30) |
VARCHAR2(30) NOT NULL |
Performed By
|
| 183 |
DOCUMENT_ID |
Character(12) |
VARCHAR2(12) NOT NULL |
Document
|
| 184 |
LOC_AUTH_STATUS |
Character(1) |
VARCHAR2(1) NOT NULL |
Location Authorization Status
|
| 185 |
LOC_AUTH_NAME |
Character(30) |
VARCHAR2(30) NOT NULL |
Location Authorization Name
|
| 186 |
LOC_AUTH_DT |
Date(10) |
DATE |
Location Authorization Date
|
| 187 |
RD_PLANT_ASSET |
Character(1) |
VARCHAR2(1) NOT NULL |
R and D Plant Asset
|
| 188 |
RD_START_DT |
Date(10) |
DATE |
R and D Start Date
|
| 189 |
RD_USE_NBV |
Character(1) |
VARCHAR2(1) NOT NULL |
Use NBV for R and D
|
| 190 |
AM_AST_UD_CHAR1 |
Character(10) |
VARCHAR2(10) NOT NULL |
User Defined Char Field1
|
| 191 |
AM_AST_UD_CHAR2 |
Character(10) |
VARCHAR2(10) NOT NULL |
User Defined Char Field2
|
| 192 |
AM_AST_UD_DATE1 |
Date(10) |
DATE |
User Defined Date Field1
|
| 193 |
AM_AST_UD_NUM1 |
Number(19,3) |
DECIMAL(18,3) NOT NULL |
User Defined Number Field1
|
| 194 |
AM_AST_UD_NUM2 |
Number(19,3) |
DECIMAL(18,3) NOT NULL |
User Defined Number Field2
|
| 195 |
TXN_AMOUNT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Transaction Amount
|
| 196 |
AREA_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Area ID
|
| 197 |
VAT_SETID |
Character(5) |
VARCHAR2(5) NOT NULL |
VAT SetID
|
| 198 |
VAT_USE_ID |
Character(6) |
VARCHAR2(6) NOT NULL |
VAT Use Type
|
| 199 |
BUSINESS_UNIT_VAT |
Character(5) |
VARCHAR2(5) NOT NULL |
Vat Apportionment Business Uni
|
| 200 |
CHARTFIELD_PR1_VAL |
Character(20) |
VARCHAR2(20) NOT NULL |
Chartfield Priority 1 Value
|
| 201 |
CHARTFIELD_PR2_VAL |
Character(20) |
VARCHAR2(20) NOT NULL |
Chartfield Priority 2 Value
|
| 202 |
VAT_RECOVERY_PCT |
Signed Number(7,2) |
DECIMAL(5,2) NOT NULL |
VAT Recovery Percent
|
| 203 |
VAT_CONSTRAINT_PCT |
Number(6,2) |
DECIMAL(5,2) NOT NULL |
Coefficient of Constraint
|
| 204 |
VAT_TAXATION_PCT |
Number(6,2) |
DECIMAL(5,2) NOT NULL |
Coefficient of Taxation
|
| 205 |
VAT_ADMISSION_PCT |
Number(6,2) |
DECIMAL(5,2) NOT NULL |
Coefficient of Admission
|
| 206 |
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.
|
| 207 |
PO_GROUP_ID |
Character(18) |
VARCHAR2(18) NOT NULL |
GroupID
|
| 208 |
PO_GRP_SEQ_NUM |
Number(8,0) |
INTEGER NOT NULL |
Procurement Group Sequence
|
| 209 |
PRIMARY_UNIT |
Character(1) |
VARCHAR2(1) NOT NULL |
Primary Unit
N=No
Y=Yes
Y/N Table Edit
|
| 210 |
DESCR_LONG |
Character(254) |
VARCHAR2(254) NOT NULL |
Long Description
|
| 211 |
FINANCIAL_ASSET_SW |
Character(1) |
VARCHAR2(1) NOT NULL |
Capitalized Asset
N=Non Cap
Y=Capitalize
|