INTFC_OT_DST_VW

(SQL View)
 Index Back

Asset Cost Dist View

Asset Cost Dist View

SELECT A.INTFC_ID , A.INTFC_LINE_NUM , A.DISTRIBUTION_ID , A.INTFC_TXN_ID , A.INTFC_TXN_GRP , A.LEASE_OBLG , A.ASSET_SEQ_NBR , A.LS_MAP_ID , A.PROPERTY_ID , A.BUSINESS_UNIT , A.BUSINESS_UNIT_AM , A.DEFAULT_ACCT_DIST , A.CF_OVERRIDE , CASE WHEN A.LEASE_OBLG = '1' THEN 'DR' WHEN A.LEASE_OBLG = '2' THEN 'CR' ELSE ' ' END , A.BUSINESS_UNIT_GL , A.TXN_DEST , A.TXN_GRP , A.TXN_ROUTE_CD , A.PERCENTAGE , A.AMOUNT , A.QUANTITY , A.CURRENCY_CD , ' ' , A.DEPTID , %subrec(CF14_AN_SBR, A) , %subrec(PC_CF1_N_SBR, A) , A.STATISTICS_CODE , ' ' , A.COST_TYPE , A.CF_SEQNO , A.CF_SEQNO_INC , A.CF_SEQNO_REC , A.AMOUNT_RENT_EXP , A.AMOUNT_INCENTIVE , A.AMOUNT_RECLASS , A.ACCOUNT , A.ALTACCOUNT , A.INTEREST_ACCT , A.INTEREST_ALTACT , A.RENT_EXP_ACCT , A.RENT_EXP_ALTACT , A.INCENTIVE_ACCT , A.INCENTIVE_ALTACT , A.PLP_OBLG_ACCT , A.PLP_OBLG_ALTACT , A.PLP_INTRST_ACCT , A.PLP_INTRST_ALTACT FROM PS_INTFC_RE_OTHR A

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 INTFC_ID Number(8,0) INTEGER NOT NULL Interface ID
2 INTFC_LINE_NUM Number(8,0) INTEGER NOT NULL Interface Line Number
3 DISTRIBUTION_ID Number(5,0) INTEGER NOT NULL Distribution ID
4 INTFC_TXN_ID Number(3,0) SMALLINT NOT NULL Interface Transaction ID
5 INTFC_TXN_GRP Character(1) VARCHAR2(1) NOT NULL Interace transaction group
1=Base Rent
2=Opex
3=Opex Category
4=Misc Rent
5=Asset Details
6=Rent Escalations
7=Clauses
A=Initial Direct Cost
B=Lease Incentive
C=Prepaid Rent
D=Purchase Option
E=Termination Option
F=Renewal Option
6 LEASE_OBLG Character(1) VARCHAR2(1) NOT NULL Lease Obligation either Payables or Receivables Lease
1=Payables
2=Receivables
7 ASSET_SEQ_NBR Number(5,0) INTEGER NOT NULL Asset Sequence Number
8 LS_MAP_ID Character(12) VARCHAR2(12) NOT NULL Field For Lease Map ID
9 PROPERTY_ID Number(10,0) DECIMAL(10) NOT NULL Property ID
10 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
11 BUSINESS_UNIT_AM Character(5) VARCHAR2(5) NOT NULL AM Business Unit
12 DEFAULT_ACCT_DIST Character(1) VARCHAR2(1) NOT NULL Defaul Accounting Distribution
13 CF_OVERRIDE Character(1) VARCHAR2(1) NOT NULL ChartField Overrides
14 DEBIT_CREDIT Character(2) VARCHAR2(2) NOT NULL Debit / Credit Indicator
CR=Credit
DR=Debit
15 BUSINESS_UNIT_GL Character(5) VARCHAR2(5) NOT NULL GL Business Unit
16 TXN_DEST Character(1) VARCHAR2(1) NOT NULL This field indicates the Destination for Transaction Billing processor is 'Billing' or 'Payables'
1=Accounts Payable
2=Billing
3=General Ledger
17 TXN_GRP Character(1) VARCHAR2(1) NOT NULL Transaction Group
1=Base Rent
2=Security Deposit
3=Straightline Accounting
4=Operating Expense
5=Percent Rent
6=Miscellaneous Rent
7=Manual Fee
8=Lease Obligation
9=Lease Interest Expense
A=Prior Period Lease Obligation
B=Prior Period Lease Interest
C=Rent Expense
D=Lease Incentive
18 TXN_ROUTE_CD Character(20) VARCHAR2(20) NOT NULL This field holds the Transaction routing Codes used to configure the Billing, SUT and Withholding defaults.
19 PERCENTAGE Signed Number(7,2) DECIMAL(5,2) NOT NULL Percentage
20 AMOUNT Signed Number(28,3) DECIMAL(26,3) NOT NULL Amount
21 QUANTITY Signed Number(17,4) DECIMAL(15,4) NOT NULL Qty Interface
22 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code
23 DST_AREA Number(18,3) DECIMAL(17,3) NOT NULL Captures the Distribution Area for accounting distributions.
24 DEPTID Character(10) VARCHAR2(10) NOT NULL Department

Prompt Table: DEPTID_BUGL_VW

25 OPERATING_UNIT Character(8) VARCHAR2(8) NOT NULL Operating Unit ChartField

Prompt Table: OPERUNT_BUGL_VW

26 PRODUCT Character(6) VARCHAR2(6) NOT NULL Product ChartField

Prompt Table: PRODUCT_BUGL_VW

27 FUND_CODE Character(5) VARCHAR2(5) NOT NULL Fund Code

Prompt Table: FUND_BUGL_VW

28 CLASS_FLD Character(5) VARCHAR2(5) NOT NULL Class Field

Prompt Table: CLASSCF_BUGL_VW

29 PROGRAM_CODE Character(5) VARCHAR2(5) NOT NULL Program Code ChartField

Prompt Table: PROGRAM_BUGL_VW

30 BUDGET_REF Character(8) VARCHAR2(8) NOT NULL Budget Reference

Prompt Table: BUD_REF_BUGL_VW

31 AFFILIATE Character(5) VARCHAR2(5) NOT NULL Affiliate

Prompt Table: AFFILIATE_VW

32 AFFILIATE_INTRA1 Character(10) VARCHAR2(10) NOT NULL IntraUnit Affiliate1

Prompt Table: %EDIT_INTRA01

33 AFFILIATE_INTRA2 Character(10) VARCHAR2(10) NOT NULL Operating Unit Affiliate

Prompt Table: %EDIT_INTRA02

34 CHARTFIELD1 Character(10) VARCHAR2(10) NOT NULL Expansion chartfield 1

Prompt Table: CF1_BUGL_VW

35 CHARTFIELD2 Character(10) VARCHAR2(10) NOT NULL Expansion Chartfield 2

Prompt Table: CF2_BUGL_VW

36 CHARTFIELD3 Character(10) VARCHAR2(10) NOT NULL Expansion Chartfield 3

Prompt Table: CF3_BUGL_VW

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

Prompt Table: %EDIT_BU_PC

38 PROJECT_ID Character(15) VARCHAR2(15) NOT NULL Project Id ChartField

Prompt Table: %EDIT_PROJECT

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

Prompt Table: %EDIT_ACTIVITY

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

Prompt Table: PROJ_RESTYPE_FS
Set Control Field: BUSINESS_UNIT_PC

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

Prompt Table: %EDIT_RES_CAT
Set Control Field: BUSINESS_UNIT_PC

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

Prompt Table: %EDIT_RES_SUB
Set Control Field: BUSINESS_UNIT_PC

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

Prompt Table: %EDIT_ANALYSIS
Set Control Field: BUSINESS_UNIT_PC

44 STATISTICS_CODE Character(3) VARCHAR2(3) NOT NULL Statistics Code
45 COMBO_VALID_FLG Character(1) VARCHAR2(1) NOT NULL ChartField Combinatn Valid Flg
?=Validation in Progress
V=Valid ChartField Combination
X=Invalid ChartField Combo
46 COST_TYPE Character(1) VARCHAR2(1) NOT NULL Cost Type

Prompt Table: AM_LO_CSTTYP_VW
Set Control Field: BUSINESS_UNIT_AM

47 CF_SEQNO Number(6,0) INTEGER NOT NULL Chartfield Sequence Number
48 CF_SEQNO_INC Number(6,0) INTEGER NOT NULL Chartfield Sequence Number
49 CF_SEQNO_REC Number(6,0) INTEGER NOT NULL Chartfield Seq No Reclass
50 AMOUNT_RENT_EXP Signed Number(28,3) DECIMAL(26,3) NOT NULL Rent Expense Amount
51 AMOUNT_INCENTIVE Signed Number(28,3) DECIMAL(26,3) NOT NULL Incentive Amount
52 AMOUNT_RECLASS Signed Number(28,3) DECIMAL(26,3) NOT NULL Reclassification Amount
53 ACCOUNT Character(10) VARCHAR2(10) NOT NULL Account

Prompt Table: GL_ACCOUNT_TBL
Set Control Field: BUSINESS_UNIT_GL

54 ALTACCOUNT Character(10) VARCHAR2(10) NOT NULL Obligation Alternate Account

Prompt Table: ALTX_ALT_VW
Set Control Field: BUSINESS_UNIT_GL

55 INTEREST_ACCT Character(10) VARCHAR2(10) NOT NULL Interest Account

Prompt Table: GL_ACCOUNT_TBL
Set Control Field: BUSINESS_UNIT_GL

56 INTEREST_ALTACT Character(10) VARCHAR2(10) NOT NULL Interest Alternate Account

Prompt Table: ALTX_ALT_LI_VW
Set Control Field: BUSINESS_UNIT_GL

57 RENT_EXP_ACCT Character(10) VARCHAR2(10) NOT NULL Rent Expense Account

Prompt Table: GL_ACCOUNT_TBL
Set Control Field: BUSINESS_UNIT_GL

58 RENT_EXP_ALTACT Character(10) VARCHAR2(10) NOT NULL Rent Expense Alternate Account

Prompt Table: ALTX_ALT_RE_VW
Set Control Field: BUSINESS_UNIT_GL

59 INCENTIVE_ACCT Character(10) VARCHAR2(10) NOT NULL Incentive Account

Prompt Table: GL_ACCOUNT_TBL
Set Control Field: BUSINESS_UNIT_GL

60 INCENTIVE_ALTACT Character(10) VARCHAR2(10) NOT NULL Incentive Alternate Account

Prompt Table: ALTX_ALT_IN_VW
Set Control Field: BUSINESS_UNIT_GL

61 PLP_OBLG_ACCT Character(10) VARCHAR2(10) NOT NULL PLP Obligation Account

Prompt Table: GL_ACCOUNT_TBL
Set Control Field: BUSINESS_UNIT_GL

62 PLP_OBLG_ALTACT Character(10) VARCHAR2(10) NOT NULL PLP Obligation Alt Account

Prompt Table: ALTX_ALT_PLO_VW
Set Control Field: BUSINESS_UNIT_GL

63 PLP_INTRST_ACCT Character(10) VARCHAR2(10) NOT NULL Interest Account

Prompt Table: GL_ACCOUNT_TBL
Set Control Field: BUSINESS_UNIT_GL

64 PLP_INTRST_ALTACT Character(10) VARCHAR2(10) NOT NULL Interest Alternate Account

Prompt Table: ALTX_ALT_PLI_VW
Set Control Field: BUSINESS_UNIT_GL