AM_CON_TMP_VW (SQL View)	Index Back
AM Consolidation Temp TAble

AM_CON_TMP_VW

(SQL View)

AM Consolidation Temp TAble

SELECT B.PROCESS_INST_STG , A.INTFC_ID , A.INTFC_LINE_NUM , A.BUSINESS_UNIT , A.ASSET_ID , A.DTTM_STAMP , A.MC_DEFN_ID , A.VOUCHER_ID , A.VOUCHER_LINE_NUM , A.DISTRIB_LINE_NUM , A.INTFC_TYPE , A.SYSTEM_SOURCE , A.APPROVAL_SW , A.INTFC_STATUS , A.LOAD_STATUS , A.DEFAULT_PROFILE_SW , A.TRANS_IN_OUT , A.PARENT_ID , A.PARENT_DESCR , A.PARENT_DESCRLONG50 , A.TAGGABLE_SW , A.TAG_NUMBER , A.DESCR , A.DESCRSHORT , A.ASSET_STATUS , A.FINANCIAL_ASSET_SW , A.REPLACE_SW , A.REPLACE_ASSET_ID , A.CONVERSION_ID , A.NEW_ASSET_SW , A.AVAIL_SW , A.AVAIL_CONTACT , A.AVAIL_PHONE , A.ACQUISITION_CD , A.ACQUISITION_DT , A.FINANCING_CD , A.ASSET_DTTM_STAMP , A.PROFILE_ID , A.ASSET_CLASS , A.CAP_NUM , A.MANUFACTURER , A.MODEL , A.PROD_VERSION , A.SERIAL_ID , A.PRODUCTION_DT , A.PLANT , A.MANUFACTUR_CONTACT , A.CAP_SEQUENCE , A.REPLACEMENT_COST , A.LEASE_ASSET_ID , A.BUSINESS_UNIT_JV , A.COMPOSITE_SW , A.COMPOSITE_ID , A.FERC_CD , A.SEQUENCE_NBR_6 , A.ACQUISITION_DESCR , A.CAPITALIZATION_SW , A.BUSINESS_UNIT_AP , A.CURRENCY_CD , A.BUSINESS_UNIT_PO , A.PO_ID , A.PO_LINE_NBR , A.SCHED_NBR , A.PO_DIST_LINE_NUM , A.REFERENCE_ID , A.INVOICE_DT , A.VENDOR_ID , A.VENDOR_NAME , A.INVOICE_ID , A.TXN_AMOUNT , A.AMOUNT , A.QTY_INV_RECV , A.SALETX_AMT , A.SALETX_AMT_BSE , A.SALETX_CD , A.USETAX_AMT , A.USETAX_AMT_BSE , A.USETAX_CD , A.FREIGHT_AMT , A.FREIGHT_AMT_BSE , A.MISC_AMT , A.MISC_AMT_BSE , A.BUSINESS_UNIT_RECV , A.RECEIVER_ID , A.RECV_LN_NBR , A.RECV_SHIP_SEQ_NBR , A.RECV_DIST_LINE_NUM , A.DISTRIB_SEQ_NUM , A.INV_ITEM_ID , A.BUSINESS_UNIT_PC , A.MASTER_PROJECT , A.ACTIVITY_ID , A.RESOURCE_TYPE , A.CUSTODIAN_EFFDT , A.EFFSEQ , A.CUSTODIAN , A.EMPLID , A.CUSTODIAN_DEPTID , A.CUSTODIAN_PROJECT , A.OFFSITE_SW , A.AUTH_STATUS , A.AUTHORIZATION_NAME , A.AUTHORIZATION_DT , A.LOCATION_EFFDT , A.LOCATION_EFFSEQ , A.LOCATION , A.PI_ID , A.INVENTORY_DT , A.PERFORMED_BY , A.DOCUMENT_ID , A.LOC_AUTH_STATUS , A.LOC_AUTH_NAME , A.LOC_AUTH_DT , A.ORIG_INTFC_ID , A.ORIG_LINE_NUM , A.BOOK , A.COST , A.SALVAGE_VALUE , A.QUANTITY , %subrec(CF14_AN_SBR, A) , A.PROJECT_ID , A.DEPTID , A.CATEGORY , A.COST_TYPE , A.TRANS_DT , A.ACCOUNTING_DT , A.IN_SERVICE_DT , A.CALCULATION_TYPE , A.CALC_DEPR_STATUS , A.CALC_DIST_STATUS , A.OPEN_TRANS_ID , A.OPRID , A.DEPR_IN_SERVICE_SW , A.DEPR_AVG_OPTION , A.MERCH_AMT_BSE , A.VAT_INV_AMT , A.VAT_INV_AMT_BSE , A.VAT_NRCVR_AMT , A.VAT_NRCVR_AMT_BSE , A.VAT_RCVRY_AMT , A.VAT_RCVRY_AMT_BSE , A.TXN_COST , A.TXN_CURRENCY_CD , A.RATE_MULT , A.RATE_DIV , A.RT_TYPE , A.MERCHANDISE_AMT , A.CONVENTION , A.RETIRE_CONVENTION , A.LIFE , A.DEPR_STATUS , A.METHOD , A.DESCR_LONG , A.AREA_ID , A.LINEAR_ASSET_SW , A.NBR_OF_CPU , A.FULLY_DEPR_SW , A.CAP_THRSHLD_ID , A.CAPVAL_VALUE , A.ARO_SW , %subrec(AM_VAT_ATTR_SBR, A) , A.ARO_ID , A.PO_GROUP_ID , A.MFG_ID , A.RT_EFFDT , A.CONSOLIDATION_ID , A.ASSET_TYPE , A.COMPONENT_OF_ID , A.RESOURCE_CATEGORY , A.RESOURCE_SUB_CAT , A.ANALYSIS_TYPE , A.AM_CAP_STATUS_SW , A.AVAIL_FOR_USE , A.CHARGE_BACK_SW , A.IN_PHY_USE , A.OFFLINE_FLG , A.ALLOW_OVERBOOK_SW , A.GROUP_ASSET_FLAG , A.REPAIR_STATUS , A.REPAIRABLE_FLG , A.SCHEDULABLE_SW FROM PS_INTFC_AM_ALL_VW A , %Table(AM_CON_TMP) B WHERE %Join(COMMON_KEYS, AM_CON_TMP B, INTFC_AM_ALL_VW A)

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 PROCESS_INST_STG Number(10,0) DECIMAL(10) NOT NULL Stage Record Process Instance

2 INTFC_ID Number(8,0) INTEGER NOT NULL Interface ID

3 INTFC_LINE_NUM Number(8,0) INTEGER NOT NULL Interface Line Number

4 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
Prompt Table: SP_BU_AM_NONVW

5 ASSET_ID Character(12) VARCHAR2(12) NOT NULL Asset Identification

6 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.

7 MC_DEFN_ID Character(30) VARCHAR2(30) NOT NULL Mass Change Definition

8 VOUCHER_ID Character(8) VARCHAR2(8) NOT NULL Voucher ID

9 VOUCHER_LINE_NUM Number(5,0) INTEGER NOT NULL Voucher Line Number

10 DISTRIB_LINE_NUM Number(5,0) INTEGER NOT NULL Distribution Line

11 INTFC_TYPE Character(3) VARCHAR2(3) NOT NULL Trans Load Type

12 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.

13 APPROVAL_SW Character(1) VARCHAR2(1) NOT NULL Auto Approval Status
Y/N Table Edit
Default Value: Y

14 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

15 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

16 DEFAULT_PROFILE_SW Character(1) VARCHAR2(1) NOT NULL Default Books from Profile
Y/N Table Edit
Default Value: N

17 TRANS_IN_OUT Character(1) VARCHAR2(1) NOT NULL Transaction In/Out
I=In
M=IUT Proceeds Markup
O=Out

18 PARENT_ID Character(12) VARCHAR2(12) NOT NULL Parent ID
Prompt Table: PARENT_ASSET

19 PARENT_DESCR Character(30) VARCHAR2(30) NOT NULL Parent Asset Description

20 PARENT_DESCRLONG50 Character(50) VARCHAR2(50) NOT NULL Parent Asset Long Description

21 TAGGABLE_SW Character(1) VARCHAR2(1) NOT NULL Taggable Asset
N=Non Taggable Asset
Y=Taggable Asset

22 TAG_NUMBER Character(12) VARCHAR2(12) NOT NULL Tag Number

23 DESCR Character(30) VARCHAR2(30) NOT NULL Description

24 DESCRSHORT Character(10) VARCHAR2(10) NOT NULL Short Description
Default Value: INTFC_AM_ALL_VW.DESCR

25 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

26 FINANCIAL_ASSET_SW Character(1) VARCHAR2(1) NOT NULL Capitalized Asset
N=Non Cap
Y=Capitalize
Y/N Table Edit
Default Value: Y

27 REPLACE_SW Character(1) VARCHAR2(1) NOT NULL Replacement Asset
Y/N Table Edit
Default Value: N

28 REPLACE_ASSET_ID Character(12) VARCHAR2(12) NOT NULL Replaced Asset ID
Prompt Table: ASSET

29 CONVERSION_ID Character(15) VARCHAR2(15) NOT NULL Old Asset ID

30 NEW_ASSET_SW Character(1) VARCHAR2(1) NOT NULL New Asset
N=Used Asset
Y=New Asset
Default Value: Y

31 AVAIL_SW Character(1) VARCHAR2(1) NOT NULL Asset is Available
Y/N Table Edit
Default Value: N

32 AVAIL_CONTACT Character(30) VARCHAR2(30) NOT NULL Availability Contact

33 AVAIL_PHONE Character(12) VARCHAR2(12) NOT NULL Availability Phone

34 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

35 ACQUISITION_DT Date(10) DATE Acquisition Date

36 FINANCING_CD Character(5) VARCHAR2(5) NOT NULL Financing Code

37 ASSET_DTTM_STAMP DateTime(26) TIMESTAMP Asset Date Time Stamp

38 PROFILE_ID Character(10) VARCHAR2(10) NOT NULL Asset Profile ID
Prompt Table: PROFILE_TBL

39 ASSET_CLASS Character(10) VARCHAR2(10) NOT NULL Asset Class

40 CAP_NUM Character(15) VARCHAR2(15) NOT NULL Capital Acquisition Plan #
Prompt Table: CAP

41 MANUFACTURER Character(60) VARCHAR2(60) NOT NULL Manufacturer Name

42 MODEL Character(30) VARCHAR2(30) NOT NULL Model

43 PROD_VERSION Character(10) VARCHAR2(10) NOT NULL Product Version

44 SERIAL_ID Character(20) VARCHAR2(20) NOT NULL Serial ID

45 PRODUCTION_DT Date(10) DATE Production Date

46 PLANT Character(30) VARCHAR2(30) NOT NULL Manufacturing Plant

47 MANUFACTUR_CONTACT Character(30) VARCHAR2(30) NOT NULL Manufacturing Contact

48 CAP_SEQUENCE Number(3,0) SMALLINT NOT NULL CAP Sequence

49 REPLACEMENT_COST Signed Number(28,3) DECIMAL(26,3) NOT NULL Replacement Cost

50 LEASE_ASSET_ID Character(12) VARCHAR2(12) NOT NULL Lease Asset ID

51 BUSINESS_UNIT_JV Character(5) VARCHAR2(5) NOT NULL Joint Venture BUS Unit

52 COMPOSITE_SW Character(1) VARCHAR2(1) NOT NULL Composite Asset

53 COMPOSITE_ID Character(12) VARCHAR2(12) NOT NULL Composite Asset ID

54 FERC_CD Character(10) VARCHAR2(10) NOT NULL FERC Code

55 SEQUENCE_NBR_6 Number(6,0) INTEGER NOT NULL Sequence

56 ACQUISITION_DESCR Character(30) VARCHAR2(30) NOT NULL DESCR field for ACQ_DETAIL

57 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

58 BUSINESS_UNIT_AP Character(5) VARCHAR2(5) NOT NULL AP Business Unit

59 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code

60 BUSINESS_UNIT_PO Character(5) VARCHAR2(5) NOT NULL PO Business Unit

61 PO_ID Character(10) VARCHAR2(10) NOT NULL Purchase Order

62 PO_LINE_NBR Number(5,0) INTEGER NOT NULL Purchase Order Line Number

63 SCHED_NBR Number(3,0) SMALLINT NOT NULL Schedule Number

64 PO_DIST_LINE_NUM Number(5,0) INTEGER NOT NULL PO Distribution Line Number

65 REFERENCE_ID Character(10) VARCHAR2(10) NOT NULL Reference ID

66 INVOICE_DT Date(10) DATE Invoice Date

67 VENDOR_ID Character(10) VARCHAR2(10) NOT NULL Vendor Identifier

68 VENDOR_NAME Character(30) VARCHAR2(30) NOT NULL Supplier Name

69 INVOICE_ID Character(30) VARCHAR2(30) NOT NULL Invoice Number

70 TXN_AMOUNT Signed Number(28,3) DECIMAL(26,3) NOT NULL Transaction Amount

71 AMOUNT Signed Number(28,3) DECIMAL(26,3) NOT NULL Amount

72 QTY_INV_RECV Number(16,4) DECIMAL(15,4) NOT NULL Quantity Received

73 SALETX_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Sales Tax Amount

74 SALETX_AMT_BSE Signed Number(28,3) DECIMAL(26,3) NOT NULL Base Sales Tax Amount

75 SALETX_CD Character(8) VARCHAR2(8) NOT NULL Sales Tax Code

76 USETAX_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Amount

77 USETAX_AMT_BSE Signed Number(28,3) DECIMAL(26,3) NOT NULL Base Use Tax Amount

78 USETAX_CD Character(8) VARCHAR2(8) NOT NULL Use Tax Code

79 FREIGHT_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Freight Amount

80 FREIGHT_AMT_BSE Signed Number(28,3) DECIMAL(26,3) NOT NULL Base Freight Amount

81 MISC_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Misc. Amount

82 MISC_AMT_BSE Signed Number(28,3) DECIMAL(26,3) NOT NULL Base Misc. Amount

83 BUSINESS_UNIT_RECV Character(5) VARCHAR2(5) NOT NULL Receiving Business Unit

84 RECEIVER_ID Character(10) VARCHAR2(10) NOT NULL Receiver number

85 RECV_LN_NBR Number(5,0) INTEGER NOT NULL Receipt Line

86 RECV_SHIP_SEQ_NBR Number(3,0) SMALLINT NOT NULL Receiver Shipping Sequence

87 RECV_DIST_LINE_NUM Number(5,0) INTEGER NOT NULL Receiver Distrib Line

88 DISTRIB_SEQ_NUM Number(5,0) INTEGER NOT NULL Distribution Sequence

89 INV_ITEM_ID Character(18) VARCHAR2(18) NOT NULL Item ID

90 BUSINESS_UNIT_PC Character(5) VARCHAR2(5) NOT NULL PC Business Unit

91 MASTER_PROJECT Character(15) VARCHAR2(15) NOT NULL Master Project

92 ACTIVITY_ID Character(15) VARCHAR2(15) NOT NULL Activity ID

93 RESOURCE_TYPE Character(5) VARCHAR2(5) NOT NULL Source Type

94 CUSTODIAN_EFFDT Date(10) DATE Asset Custodian Effective Dt

95 EFFSEQ Number(3,0) SMALLINT NOT NULL Effective Sequence

96 CUSTODIAN Character(30) VARCHAR2(30) NOT NULL Custodian

97 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID

98 CUSTODIAN_DEPTID Character(10) VARCHAR2(10) NOT NULL Asset Custodian Deptid

99 CUSTODIAN_PROJECT Character(15) VARCHAR2(15) NOT NULL Asset Custodian Project

100 OFFSITE_SW Character(1) VARCHAR2(1) NOT NULL This Asset is Offsite

101 AUTH_STATUS Character(1) VARCHAR2(1) NOT NULL Authorization Status
A=Authorized
N=Not Authorized
P=Authorization Pending

102 AUTHORIZATION_NAME Character(30) VARCHAR2(30) NOT NULL Authorization Name

103 AUTHORIZATION_DT Date(10) DATE Date Authorized

104 LOCATION_EFFDT Date(10) DATE Location Effective Date

105 LOCATION_EFFSEQ Number(3,0) SMALLINT NOT NULL Asset Location Effective Seq

106 LOCATION Character(10) VARCHAR2(10) NOT NULL Location Code

107 PI_ID Character(10) VARCHAR2(10) NOT NULL Physical Inventory ID

108 INVENTORY_DT Date(10) DATE Inventory Date

109 PERFORMED_BY Character(30) VARCHAR2(30) NOT NULL Performed By

110 DOCUMENT_ID Character(12) VARCHAR2(12) NOT NULL Document

111 LOC_AUTH_STATUS Character(1) VARCHAR2(1) NOT NULL Location Authorization Status

112 LOC_AUTH_NAME Character(30) VARCHAR2(30) NOT NULL Location Authorization Name

113 LOC_AUTH_DT Date(10) DATE Location Authorization Date

114 ORIG_INTFC_ID Number(8,0) INTEGER NOT NULL Original Interface ID

115 ORIG_LINE_NUM Number(8,0) INTEGER NOT NULL Original Interface Line Number

116 BOOK Character(10) VARCHAR2(10) NOT NULL Asset Book Name

117 COST Signed Number(28,3) DECIMAL(26,3) NOT NULL Total Cost

118 SALVAGE_VALUE Signed Number(28,3) DECIMAL(26,3) NOT NULL Salvage Value

119 QUANTITY Signed Number(17,4) DECIMAL(15,4) NOT NULL Qty Interface

120 OPERATING_UNIT Character(8) VARCHAR2(8) NOT NULL Operating Unit ChartField
Prompt Table: OPER_UNIT_TBL

121 PRODUCT Character(6) VARCHAR2(6) NOT NULL Product ChartField
Prompt Table: PRODUCT_TBL

122 FUND_CODE Character(5) VARCHAR2(5) NOT NULL Fund Code
Prompt Table: FUND_TBL

123 CLASS_FLD Character(5) VARCHAR2(5) NOT NULL Class Field
Prompt Table: CLASS_CF_TBL

124 PROGRAM_CODE Character(5) VARCHAR2(5) NOT NULL Program Code ChartField
Prompt Table: PROGRAM_TBL

125 BUDGET_REF Character(8) VARCHAR2(8) NOT NULL Budget Reference
Prompt Table: BUD_REF_TBL

126 AFFILIATE Character(5) VARCHAR2(5) NOT NULL Affiliate
Prompt Table: AFFILIATE_VW

127 AFFILIATE_INTRA1 Character(10) VARCHAR2(10) NOT NULL IntraUnit Affiliate1
Prompt Table: %EDIT_INTRA01

128 AFFILIATE_INTRA2 Character(10) VARCHAR2(10) NOT NULL Operating Unit Affiliate
Prompt Table: %EDIT_INTRA02

129 CHARTFIELD1 Character(10) VARCHAR2(10) NOT NULL Expansion chartfield 1
Prompt Table: CHARTFIELD1_TBL

130 CHARTFIELD2 Character(10) VARCHAR2(10) NOT NULL Expansion Chartfield 2
Prompt Table: CHARTFIELD2_TBL

131 CHARTFIELD3 Character(10) VARCHAR2(10) NOT NULL Expansion Chartfield 3
Prompt Table: CHARTFIELD3_TBL

132 PROJECT_ID Character(15) VARCHAR2(15) NOT NULL Project Id ChartField
Prompt Table: PROJECT_ID_VW

133 DEPTID Character(10) VARCHAR2(10) NOT NULL Department
Prompt Table: DEPT_TBL

134 CATEGORY Character(5) VARCHAR2(5) NOT NULL Asset Category

135 COST_TYPE Character(1) VARCHAR2(1) NOT NULL Cost Type

136 TRANS_DT Date(10) DATE Transaction Date

137 ACCOUNTING_DT Date(10) DATE The accounting entry construction date for a given transaction (a generic field that crosses multiple

138 IN_SERVICE_DT Date(10) DATE In Service Date

139 CALCULATION_TYPE Character(1) VARCHAR2(1) NOT NULL Calculation Type
L=Life-to-Date
R=Remaining Value

140 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

141 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

142 OPEN_TRANS_ID Number(10,0) DECIMAL(10) NOT NULL Open Transaction ID

143 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).

144 DEPR_IN_SERVICE_SW Character(1) VARCHAR2(1) NOT NULL Depreciate When In Service
N=No
X=Used to be set to 'Y'
Y=Yes

145 DEPR_AVG_OPTION Character(1) VARCHAR2(1) NOT NULL Depreciation Averaging Option
M=Monthly Averaging
N=No Averaging
Y=Yearly Averaging

146 MERCH_AMT_BSE Signed Number(28,3) DECIMAL(26,3) NOT NULL Base Merchandise Amount

147 VAT_INV_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL VAT Invoice Amount

148 VAT_INV_AMT_BSE Signed Number(28,3) DECIMAL(26,3) NOT NULL VAT Invoice Amt Base Curr

149 VAT_NRCVR_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL VAT Non Recoverable

150 VAT_NRCVR_AMT_BSE Signed Number(28,3) DECIMAL(26,3) NOT NULL VAT NonRecoverable Amount

151 VAT_RCVRY_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL VAT Recovery Amt

152 VAT_RCVRY_AMT_BSE Signed Number(28,3) DECIMAL(26,3) NOT NULL VAT Recovery Amt in Base Curr

153 TXN_COST Signed Number(28,3) DECIMAL(26,3) NOT NULL Transaction Cost

154 TXN_CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Transaction Currency

155 RATE_MULT Signed Number(17,8) DECIMAL(15,8) NOT NULL Rate Multiplier

156 RATE_DIV Number(16,8) DECIMAL(15,8) NOT NULL Rate Divisor

157 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.

158 MERCHANDISE_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Merchandise Amt F_KDHIL_R87H8 062804 MLM: Added new Line Amount Received Label

159 CONVENTION Character(2) VARCHAR2(2) NOT NULL Book Depreciation Convention or Cost Convention

160 RETIRE_CONVENTION Character(2) VARCHAR2(2) NOT NULL Retirement Convention

161 LIFE Number(4,0) SMALLINT NOT NULL Useful Life

162 DEPR_STATUS Character(1) VARCHAR2(1) NOT NULL Depreciation Status
D=Depreciable
N=Non Depreciable

163 METHOD Character(2) VARCHAR2(2) NOT NULL Method
DL=DB w/SL By Limit%
DX=Declining Balance w/SL
F1=France Derogatory Balance
FL=Flat Rate %
G1=Germany Staffel Method
J1=Japan- Tangible/Declining Bal
J2=Japan- Tangible/Strt Line
J3=Japan- Intangible/Strt Line
J4=Japan - Lease Depreciation
J5=Japan-Changes DB to SL
J6=Japan - Changes DB to SL 250
J7=Japan-Tangible/Strt Line Rev
J8=Japan - Changes DB to SL 200
J9=JPN - Changes 200/250 DB to SL
JE=Japan - Extended/Strt Line
MN=Manual Depreciation
PC=Declining Balance
SC=Depreciation Schedule
SL=Straight Line
SP=Straight Line Percent
SY=Sum of the Years
UD=User Defined Method
UP=Units of Production

164 DESCR_LONG Character(254) VARCHAR2(254) NOT NULL Long Description

165 AREA_ID Character(10) VARCHAR2(10) NOT NULL Area ID
Prompt Table: AM_AREA_TBL

166 LINEAR_ASSET_SW Character(1) VARCHAR2(1) NOT NULL Linear Asset
Y/N Table Edit

167 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.

168 FULLY_DEPR_SW Character(1) VARCHAR2(1) NOT NULL Retire As Fully Depreciated SW
F=Fully Depr with Future Expense
N=Calculate Gain/Loss
Y=Fully Depr no Future Expense

169 CAP_THRSHLD_ID Character(10) VARCHAR2(10) NOT NULL Threshold ID

170 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

171 ARO_SW Character(1) VARCHAR2(1) NOT NULL Asset Retirement Obligations
N=No
Y=Yes
Y/N Table Edit

172 VAT_SETID Character(5) VARCHAR2(5) NOT NULL VAT SetID

173 VAT_USE_ID Character(6) VARCHAR2(6) NOT NULL VAT Use Type

174 BUSINESS_UNIT_VAT Character(5) VARCHAR2(5) NOT NULL Vat Apportionment Business Uni

175 CHARTFIELD_PR1_VAL Character(20) VARCHAR2(20) NOT NULL Chartfield Priority 1 Value

176 CHARTFIELD_PR2_VAL Character(20) VARCHAR2(20) NOT NULL Chartfield Priority 2 Value

177 VAT_RECOVERY_PCT Signed Number(7,2) DECIMAL(5,2) NOT NULL VAT Recovery Percent

178 VAT_CONSTRAINT_PCT Number(6,2) DECIMAL(5,2) NOT NULL Coefficient of Constraint

179 VAT_TAXATION_PCT Number(6,2) DECIMAL(5,2) NOT NULL Coefficient of Taxation

180 VAT_ADMISSION_PCT Number(6,2) DECIMAL(5,2) NOT NULL Coefficient of Admission

181 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.

182 ARO_ID Character(12) VARCHAR2(12) NOT NULL ARO Identification

183 PO_GROUP_ID Character(18) VARCHAR2(18) NOT NULL GroupID

184 MFG_ID Character(50) VARCHAR2(50) NOT NULL Manufacturer ID

185 RT_EFFDT Date(10) DATE The effective date for a given item of market rate data.

186 CONSOLIDATION_ID Number(8,0) INTEGER NOT NULL Consolidation ID

187 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

188 COMPONENT_OF_ID Character(12) VARCHAR2(12) NOT NULL Component of Asset
Prompt Table: AM_COMPONENT

189 RESOURCE_CATEGORY Character(5) VARCHAR2(5) NOT NULL Category

190 RESOURCE_SUB_CAT Character(5) VARCHAR2(5) NOT NULL Subcategory

191 ANALYSIS_TYPE Character(3) VARCHAR2(3) NOT NULL Analysis Type

192 AM_CAP_STATUS_SW Character(1) VARCHAR2(1) NOT NULL Physical Book Cost

193 AVAIL_FOR_USE Character(1) VARCHAR2(1) NOT NULL Available For Use

194 CHARGE_BACK_SW Character(1) VARCHAR2(1) NOT NULL Charge Back Switch
D=Default
N=No
Y=Yes

195 IN_PHY_USE Character(1) VARCHAR2(1) NOT NULL Describes if entity is in physical use.

196 OFFLINE_FLG Character(1) VARCHAR2(1) NOT NULL Asset Offline

197 ALLOW_OVERBOOK_SW Character(1) VARCHAR2(1) NOT NULL Allow Overbooking

198 GROUP_ASSET_FLAG Character(1) VARCHAR2(1) NOT NULL Group Asset Flag
G=Group Asset
M=Group Member
N=None

199 REPAIR_STATUS Character(1) VARCHAR2(1) NOT NULL Repair Status
0=None
1=Needs Repair
2=In Repair

200 REPAIRABLE_FLG Character(1) VARCHAR2(1) NOT NULL Repairable Flag

201 SCHEDULABLE_SW Character(1) VARCHAR2(1) NOT NULL Schedulable Switch

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	PROCESS_INST_STG	Number(10,0)	DECIMAL(10) NOT NULL	Stage Record Process Instance
2	INTFC_ID	Number(8,0)	INTEGER NOT NULL	Interface ID
3	INTFC_LINE_NUM	Number(8,0)	INTEGER NOT NULL	Interface Line Number
4	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit Prompt Table: SP_BU_AM_NONVW
5	ASSET_ID	Character(12)	VARCHAR2(12) NOT NULL	Asset Identification
6	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.
7	MC_DEFN_ID	Character(30)	VARCHAR2(30) NOT NULL	Mass Change Definition
8	VOUCHER_ID	Character(8)	VARCHAR2(8) NOT NULL	Voucher ID
9	VOUCHER_LINE_NUM	Number(5,0)	INTEGER NOT NULL	Voucher Line Number
10	DISTRIB_LINE_NUM	Number(5,0)	INTEGER NOT NULL	Distribution Line
11	INTFC_TYPE	Character(3)	VARCHAR2(3) NOT NULL	Trans Load Type
12	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.
13	APPROVAL_SW	Character(1)	VARCHAR2(1) NOT NULL	Auto Approval Status Y/N Table Edit Default Value: Y
14	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
15	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
16	DEFAULT_PROFILE_SW	Character(1)	VARCHAR2(1) NOT NULL	Default Books from Profile Y/N Table Edit Default Value: N
17	TRANS_IN_OUT	Character(1)	VARCHAR2(1) NOT NULL	Transaction In/Out I=In M=IUT Proceeds Markup O=Out
18	PARENT_ID	Character(12)	VARCHAR2(12) NOT NULL	Parent ID Prompt Table: PARENT_ASSET
19	PARENT_DESCR	Character(30)	VARCHAR2(30) NOT NULL	Parent Asset Description
20	PARENT_DESCRLONG50	Character(50)	VARCHAR2(50) NOT NULL	Parent Asset Long Description
21	TAGGABLE_SW	Character(1)	VARCHAR2(1) NOT NULL	Taggable Asset N=Non Taggable Asset Y=Taggable Asset
22	TAG_NUMBER	Character(12)	VARCHAR2(12) NOT NULL	Tag Number
23	DESCR	Character(30)	VARCHAR2(30) NOT NULL	Description
24	DESCRSHORT	Character(10)	VARCHAR2(10) NOT NULL	Short Description Default Value: INTFC_AM_ALL_VW.DESCR
25	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
26	FINANCIAL_ASSET_SW	Character(1)	VARCHAR2(1) NOT NULL	Capitalized Asset N=Non Cap Y=Capitalize Y/N Table Edit Default Value: Y
27	REPLACE_SW	Character(1)	VARCHAR2(1) NOT NULL	Replacement Asset Y/N Table Edit Default Value: N
28	REPLACE_ASSET_ID	Character(12)	VARCHAR2(12) NOT NULL	Replaced Asset ID Prompt Table: ASSET
29	CONVERSION_ID	Character(15)	VARCHAR2(15) NOT NULL	Old Asset ID
30	NEW_ASSET_SW	Character(1)	VARCHAR2(1) NOT NULL	New Asset N=Used Asset Y=New Asset Default Value: Y
31	AVAIL_SW	Character(1)	VARCHAR2(1) NOT NULL	Asset is Available Y/N Table Edit Default Value: N
32	AVAIL_CONTACT	Character(30)	VARCHAR2(30) NOT NULL	Availability Contact
33	AVAIL_PHONE	Character(12)	VARCHAR2(12) NOT NULL	Availability Phone
34	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
35	ACQUISITION_DT	Date(10)	DATE	Acquisition Date
36	FINANCING_CD	Character(5)	VARCHAR2(5) NOT NULL	Financing Code
37	ASSET_DTTM_STAMP	DateTime(26)	TIMESTAMP	Asset Date Time Stamp
38	PROFILE_ID	Character(10)	VARCHAR2(10) NOT NULL	Asset Profile ID Prompt Table: PROFILE_TBL
39	ASSET_CLASS	Character(10)	VARCHAR2(10) NOT NULL	Asset Class
40	CAP_NUM	Character(15)	VARCHAR2(15) NOT NULL	Capital Acquisition Plan # Prompt Table: CAP
41	MANUFACTURER	Character(60)	VARCHAR2(60) NOT NULL	Manufacturer Name
42	MODEL	Character(30)	VARCHAR2(30) NOT NULL	Model
43	PROD_VERSION	Character(10)	VARCHAR2(10) NOT NULL	Product Version
44	SERIAL_ID	Character(20)	VARCHAR2(20) NOT NULL	Serial ID
45	PRODUCTION_DT	Date(10)	DATE	Production Date
46	PLANT	Character(30)	VARCHAR2(30) NOT NULL	Manufacturing Plant
47	MANUFACTUR_CONTACT	Character(30)	VARCHAR2(30) NOT NULL	Manufacturing Contact
48	CAP_SEQUENCE	Number(3,0)	SMALLINT NOT NULL	CAP Sequence
49	REPLACEMENT_COST	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Replacement Cost
50	LEASE_ASSET_ID	Character(12)	VARCHAR2(12) NOT NULL	Lease Asset ID
51	BUSINESS_UNIT_JV	Character(5)	VARCHAR2(5) NOT NULL	Joint Venture BUS Unit
52	COMPOSITE_SW	Character(1)	VARCHAR2(1) NOT NULL	Composite Asset
53	COMPOSITE_ID	Character(12)	VARCHAR2(12) NOT NULL	Composite Asset ID
54	FERC_CD	Character(10)	VARCHAR2(10) NOT NULL	FERC Code
55	SEQUENCE_NBR_6	Number(6,0)	INTEGER NOT NULL	Sequence
56	ACQUISITION_DESCR	Character(30)	VARCHAR2(30) NOT NULL	DESCR field for ACQ_DETAIL
57	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
58	BUSINESS_UNIT_AP	Character(5)	VARCHAR2(5) NOT NULL	AP Business Unit
59	CURRENCY_CD	Character(3)	VARCHAR2(3) NOT NULL	Currency Code
60	BUSINESS_UNIT_PO	Character(5)	VARCHAR2(5) NOT NULL	PO Business Unit
61	PO_ID	Character(10)	VARCHAR2(10) NOT NULL	Purchase Order
62	PO_LINE_NBR	Number(5,0)	INTEGER NOT NULL	Purchase Order Line Number
63	SCHED_NBR	Number(3,0)	SMALLINT NOT NULL	Schedule Number
64	PO_DIST_LINE_NUM	Number(5,0)	INTEGER NOT NULL	PO Distribution Line Number
65	REFERENCE_ID	Character(10)	VARCHAR2(10) NOT NULL	Reference ID
66	INVOICE_DT	Date(10)	DATE	Invoice Date
67	VENDOR_ID	Character(10)	VARCHAR2(10) NOT NULL	Vendor Identifier
68	VENDOR_NAME	Character(30)	VARCHAR2(30) NOT NULL	Supplier Name
69	INVOICE_ID	Character(30)	VARCHAR2(30) NOT NULL	Invoice Number
70	TXN_AMOUNT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Transaction Amount
71	AMOUNT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Amount
72	QTY_INV_RECV	Number(16,4)	DECIMAL(15,4) NOT NULL	Quantity Received
73	SALETX_AMT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Sales Tax Amount
74	SALETX_AMT_BSE	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Base Sales Tax Amount
75	SALETX_CD	Character(8)	VARCHAR2(8) NOT NULL	Sales Tax Code
76	USETAX_AMT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Amount
77	USETAX_AMT_BSE	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Base Use Tax Amount
78	USETAX_CD	Character(8)	VARCHAR2(8) NOT NULL	Use Tax Code
79	FREIGHT_AMT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Freight Amount
80	FREIGHT_AMT_BSE	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Base Freight Amount
81	MISC_AMT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Misc. Amount
82	MISC_AMT_BSE	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Base Misc. Amount
83	BUSINESS_UNIT_RECV	Character(5)	VARCHAR2(5) NOT NULL	Receiving Business Unit
84	RECEIVER_ID	Character(10)	VARCHAR2(10) NOT NULL	Receiver number
85	RECV_LN_NBR	Number(5,0)	INTEGER NOT NULL	Receipt Line
86	RECV_SHIP_SEQ_NBR	Number(3,0)	SMALLINT NOT NULL	Receiver Shipping Sequence
87	RECV_DIST_LINE_NUM	Number(5,0)	INTEGER NOT NULL	Receiver Distrib Line
88	DISTRIB_SEQ_NUM	Number(5,0)	INTEGER NOT NULL	Distribution Sequence
89	INV_ITEM_ID	Character(18)	VARCHAR2(18) NOT NULL	Item ID
90	BUSINESS_UNIT_PC	Character(5)	VARCHAR2(5) NOT NULL	PC Business Unit
91	MASTER_PROJECT	Character(15)	VARCHAR2(15) NOT NULL	Master Project
92	ACTIVITY_ID	Character(15)	VARCHAR2(15) NOT NULL	Activity ID
93	RESOURCE_TYPE	Character(5)	VARCHAR2(5) NOT NULL	Source Type
94	CUSTODIAN_EFFDT	Date(10)	DATE	Asset Custodian Effective Dt
95	EFFSEQ	Number(3,0)	SMALLINT NOT NULL	Effective Sequence
96	CUSTODIAN	Character(30)	VARCHAR2(30) NOT NULL	Custodian
97	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID
98	CUSTODIAN_DEPTID	Character(10)	VARCHAR2(10) NOT NULL	Asset Custodian Deptid
99	CUSTODIAN_PROJECT	Character(15)	VARCHAR2(15) NOT NULL	Asset Custodian Project
100	OFFSITE_SW	Character(1)	VARCHAR2(1) NOT NULL	This Asset is Offsite
101	AUTH_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Authorization Status A=Authorized N=Not Authorized P=Authorization Pending
102	AUTHORIZATION_NAME	Character(30)	VARCHAR2(30) NOT NULL	Authorization Name
103	AUTHORIZATION_DT	Date(10)	DATE	Date Authorized
104	LOCATION_EFFDT	Date(10)	DATE	Location Effective Date
105	LOCATION_EFFSEQ	Number(3,0)	SMALLINT NOT NULL	Asset Location Effective Seq
106	LOCATION	Character(10)	VARCHAR2(10) NOT NULL	Location Code
107	PI_ID	Character(10)	VARCHAR2(10) NOT NULL	Physical Inventory ID
108	INVENTORY_DT	Date(10)	DATE	Inventory Date
109	PERFORMED_BY	Character(30)	VARCHAR2(30) NOT NULL	Performed By
110	DOCUMENT_ID	Character(12)	VARCHAR2(12) NOT NULL	Document
111	LOC_AUTH_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Location Authorization Status
112	LOC_AUTH_NAME	Character(30)	VARCHAR2(30) NOT NULL	Location Authorization Name
113	LOC_AUTH_DT	Date(10)	DATE	Location Authorization Date
114	ORIG_INTFC_ID	Number(8,0)	INTEGER NOT NULL	Original Interface ID
115	ORIG_LINE_NUM	Number(8,0)	INTEGER NOT NULL	Original Interface Line Number
116	BOOK	Character(10)	VARCHAR2(10) NOT NULL	Asset Book Name
117	COST	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Total Cost
118	SALVAGE_VALUE	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Salvage Value
119	QUANTITY	Signed Number(17,4)	DECIMAL(15,4) NOT NULL	Qty Interface
120	OPERATING_UNIT	Character(8)	VARCHAR2(8) NOT NULL	Operating Unit ChartField Prompt Table: OPER_UNIT_TBL
121	PRODUCT	Character(6)	VARCHAR2(6) NOT NULL	Product ChartField Prompt Table: PRODUCT_TBL
122	FUND_CODE	Character(5)	VARCHAR2(5) NOT NULL	Fund Code Prompt Table: FUND_TBL
123	CLASS_FLD	Character(5)	VARCHAR2(5) NOT NULL	Class Field Prompt Table: CLASS_CF_TBL
124	PROGRAM_CODE	Character(5)	VARCHAR2(5) NOT NULL	Program Code ChartField Prompt Table: PROGRAM_TBL
125	BUDGET_REF	Character(8)	VARCHAR2(8) NOT NULL	Budget Reference Prompt Table: BUD_REF_TBL
126	AFFILIATE	Character(5)	VARCHAR2(5) NOT NULL	Affiliate Prompt Table: AFFILIATE_VW
127	AFFILIATE_INTRA1	Character(10)	VARCHAR2(10) NOT NULL	IntraUnit Affiliate1 Prompt Table: %EDIT_INTRA01
128	AFFILIATE_INTRA2	Character(10)	VARCHAR2(10) NOT NULL	Operating Unit Affiliate Prompt Table: %EDIT_INTRA02
129	CHARTFIELD1	Character(10)	VARCHAR2(10) NOT NULL	Expansion chartfield 1 Prompt Table: CHARTFIELD1_TBL
130	CHARTFIELD2	Character(10)	VARCHAR2(10) NOT NULL	Expansion Chartfield 2 Prompt Table: CHARTFIELD2_TBL
131	CHARTFIELD3	Character(10)	VARCHAR2(10) NOT NULL	Expansion Chartfield 3 Prompt Table: CHARTFIELD3_TBL
132	PROJECT_ID	Character(15)	VARCHAR2(15) NOT NULL	Project Id ChartField Prompt Table: PROJECT_ID_VW
133	DEPTID	Character(10)	VARCHAR2(10) NOT NULL	Department Prompt Table: DEPT_TBL
134	CATEGORY	Character(5)	VARCHAR2(5) NOT NULL	Asset Category
135	COST_TYPE	Character(1)	VARCHAR2(1) NOT NULL	Cost Type
136	TRANS_DT	Date(10)	DATE	Transaction Date
137	ACCOUNTING_DT	Date(10)	DATE	The accounting entry construction date for a given transaction (a generic field that crosses multiple
138	IN_SERVICE_DT	Date(10)	DATE	In Service Date
139	CALCULATION_TYPE	Character(1)	VARCHAR2(1) NOT NULL	Calculation Type L=Life-to-Date R=Remaining Value
140	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
141	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
142	OPEN_TRANS_ID	Number(10,0)	DECIMAL(10) NOT NULL	Open Transaction ID
143	OPRID	Character(30)	VARCHAR2(30) NOT NULL	A user's ID (see PSOPRDEFN).
144	DEPR_IN_SERVICE_SW	Character(1)	VARCHAR2(1) NOT NULL	Depreciate When In Service N=No X=Used to be set to 'Y' Y=Yes
145	DEPR_AVG_OPTION	Character(1)	VARCHAR2(1) NOT NULL	Depreciation Averaging Option M=Monthly Averaging N=No Averaging Y=Yearly Averaging
146	MERCH_AMT_BSE	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Base Merchandise Amount
147	VAT_INV_AMT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	VAT Invoice Amount
148	VAT_INV_AMT_BSE	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	VAT Invoice Amt Base Curr
149	VAT_NRCVR_AMT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	VAT Non Recoverable
150	VAT_NRCVR_AMT_BSE	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	VAT NonRecoverable Amount
151	VAT_RCVRY_AMT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	VAT Recovery Amt
152	VAT_RCVRY_AMT_BSE	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	VAT Recovery Amt in Base Curr
153	TXN_COST	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Transaction Cost
154	TXN_CURRENCY_CD	Character(3)	VARCHAR2(3) NOT NULL	Transaction Currency
155	RATE_MULT	Signed Number(17,8)	DECIMAL(15,8) NOT NULL	Rate Multiplier
156	RATE_DIV	Number(16,8)	DECIMAL(15,8) NOT NULL	Rate Divisor
157	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.
158	MERCHANDISE_AMT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Merchandise Amt F_KDHIL_R87H8 062804 MLM: Added new Line Amount Received Label
159	CONVENTION	Character(2)	VARCHAR2(2) NOT NULL	Book Depreciation Convention or Cost Convention
160	RETIRE_CONVENTION	Character(2)	VARCHAR2(2) NOT NULL	Retirement Convention
161	LIFE	Number(4,0)	SMALLINT NOT NULL	Useful Life
162	DEPR_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Depreciation Status D=Depreciable N=Non Depreciable
163	METHOD	Character(2)	VARCHAR2(2) NOT NULL	Method DL=DB w/SL By Limit% DX=Declining Balance w/SL F1=France Derogatory Balance FL=Flat Rate % G1=Germany Staffel Method J1=Japan- Tangible/Declining Bal J2=Japan- Tangible/Strt Line J3=Japan- Intangible/Strt Line J4=Japan - Lease Depreciation J5=Japan-Changes DB to SL J6=Japan - Changes DB to SL 250 J7=Japan-Tangible/Strt Line Rev J8=Japan - Changes DB to SL 200 J9=JPN - Changes 200/250 DB to SL JE=Japan - Extended/Strt Line MN=Manual Depreciation PC=Declining Balance SC=Depreciation Schedule SL=Straight Line SP=Straight Line Percent SY=Sum of the Years UD=User Defined Method UP=Units of Production
164	DESCR_LONG	Character(254)	VARCHAR2(254) NOT NULL	Long Description
165	AREA_ID	Character(10)	VARCHAR2(10) NOT NULL	Area ID Prompt Table: AM_AREA_TBL
166	LINEAR_ASSET_SW	Character(1)	VARCHAR2(1) NOT NULL	Linear Asset Y/N Table Edit
167	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.
168	FULLY_DEPR_SW	Character(1)	VARCHAR2(1) NOT NULL	Retire As Fully Depreciated SW F=Fully Depr with Future Expense N=Calculate Gain/Loss Y=Fully Depr no Future Expense
169	CAP_THRSHLD_ID	Character(10)	VARCHAR2(10) NOT NULL	Threshold ID
170	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
171	ARO_SW	Character(1)	VARCHAR2(1) NOT NULL	Asset Retirement Obligations N=No Y=Yes Y/N Table Edit
172	VAT_SETID	Character(5)	VARCHAR2(5) NOT NULL	VAT SetID
173	VAT_USE_ID	Character(6)	VARCHAR2(6) NOT NULL	VAT Use Type
174	BUSINESS_UNIT_VAT	Character(5)	VARCHAR2(5) NOT NULL	Vat Apportionment Business Uni
175	CHARTFIELD_PR1_VAL	Character(20)	VARCHAR2(20) NOT NULL	Chartfield Priority 1 Value
176	CHARTFIELD_PR2_VAL	Character(20)	VARCHAR2(20) NOT NULL	Chartfield Priority 2 Value
177	VAT_RECOVERY_PCT	Signed Number(7,2)	DECIMAL(5,2) NOT NULL	VAT Recovery Percent
178	VAT_CONSTRAINT_PCT	Number(6,2)	DECIMAL(5,2) NOT NULL	Coefficient of Constraint
179	VAT_TAXATION_PCT	Number(6,2)	DECIMAL(5,2) NOT NULL	Coefficient of Taxation
180	VAT_ADMISSION_PCT	Number(6,2)	DECIMAL(5,2) NOT NULL	Coefficient of Admission
181	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.
182	ARO_ID	Character(12)	VARCHAR2(12) NOT NULL	ARO Identification
183	PO_GROUP_ID	Character(18)	VARCHAR2(18) NOT NULL	GroupID
184	MFG_ID	Character(50)	VARCHAR2(50) NOT NULL	Manufacturer ID
185	RT_EFFDT	Date(10)	DATE	The effective date for a given item of market rate data.
186	CONSOLIDATION_ID	Number(8,0)	INTEGER NOT NULL	Consolidation ID
187	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
188	COMPONENT_OF_ID	Character(12)	VARCHAR2(12) NOT NULL	Component of Asset Prompt Table: AM_COMPONENT
189	RESOURCE_CATEGORY	Character(5)	VARCHAR2(5) NOT NULL	Category
190	RESOURCE_SUB_CAT	Character(5)	VARCHAR2(5) NOT NULL	Subcategory
191	ANALYSIS_TYPE	Character(3)	VARCHAR2(3) NOT NULL	Analysis Type
192	AM_CAP_STATUS_SW	Character(1)	VARCHAR2(1) NOT NULL	Physical Book Cost
193	AVAIL_FOR_USE	Character(1)	VARCHAR2(1) NOT NULL	Available For Use
194	CHARGE_BACK_SW	Character(1)	VARCHAR2(1) NOT NULL	Charge Back Switch D=Default N=No Y=Yes
195	IN_PHY_USE	Character(1)	VARCHAR2(1) NOT NULL	Describes if entity is in physical use.
196	OFFLINE_FLG	Character(1)	VARCHAR2(1) NOT NULL	Asset Offline
197	ALLOW_OVERBOOK_SW	Character(1)	VARCHAR2(1) NOT NULL	Allow Overbooking
198	GROUP_ASSET_FLAG	Character(1)	VARCHAR2(1) NOT NULL	Group Asset Flag G=Group Asset M=Group Member N=None
199	REPAIR_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Repair Status 0=None 1=Needs Repair 2=In Repair
200	REPAIRABLE_FLG	Character(1)	VARCHAR2(1) NOT NULL	Repairable Flag
201	SCHEDULABLE_SW	Character(1)	VARCHAR2(1) NOT NULL	Schedulable Switch