INTFC_RE_DST_VW

(SQL View)
 Index Back

Lease Interface Term Distrib

Lease Interface Term Distrib

SELECT A.INTFC_ID , A.INTFC_LINE_NUM , A.DISTRIBUTION_ID , A.INTFC_TXN_ID , A.INTFC_TXN_GRP , A.LEASE_OBLG , A.TXN_GRP , A.CHG_GRP_CD , A.DEFAULT_ACCT_DIST , CASE WHEN A.LEASE_OBLG = '1' THEN 'DR' WHEN A.LEASE_OBLG = '2' THEN 'CR' ELSE ' ' END , A.BUSINESS_UNIT , A.BUSINESS_UNIT_GL , A.TXN_ROUTE_CD , A.TXN_DEST , A.ACCOUNT , A.ALTACCOUNT , A.DEPTID , A.PERCENTAGE , ' ' , A.CURRENCY_CD , A.AMOUNT , %subrec(CF16_AN_SBR, A) , %subrec(PC_CF1_N_SBR, A) , A.STATISTICS_CODE , ' ' FROM PS_INTFC_RE_TRM 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

Default Value: 1

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 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
8 CHG_GRP_CD Character(10) VARCHAR2(10) NOT NULL This field holds the Charge Group Code for the Transaction Groups.
9 DEFAULT_ACCT_DIST Character(1) VARCHAR2(1) NOT NULL Defaul Accounting Distribution
10 DEBIT_CREDIT Character(2) VARCHAR2(2) NOT NULL Debit / Credit Indicator
CR=Credit
DR=Debit
11 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
12 BUSINESS_UNIT_GL Character(5) VARCHAR2(5) NOT NULL GL Business Unit

Prompt Table: SP_BU_GL_NONVW

13 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.
14 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
15 ACCOUNT Character(10) VARCHAR2(10) NOT NULL Account

Prompt Table: GL_ACCOUNT_TBL
Set Control Field: BUSINESS_UNIT_GL

16 ALTACCOUNT Character(10) VARCHAR2(10) NOT NULL Alternate Account

Prompt Table: ALTX_ALT_VW
Set Control Field: BUSINESS_UNIT_GL

17 DEPTID Character(10) VARCHAR2(10) NOT NULL Department

Prompt Table: DEPTID_BUGL_VW
Set Control Field: BUSINESS_UNIT_GL

18 PERCENTAGE Signed Number(7,2) DECIMAL(5,2) NOT NULL Percentage
19 DST_AREA Number(18,3) DECIMAL(17,3) NOT NULL Captures the Distribution Area for accounting distributions.
20 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code
21 AMOUNT Signed Number(28,3) DECIMAL(26,3) NOT NULL Amount
22 OPERATING_UNIT Character(8) VARCHAR2(8) NOT NULL Operating Unit ChartField

Prompt Table: OPERUNT_BUGL_VW

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

Prompt Table: PRODUCT_BUGL_VW

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

Prompt Table: FUND_BUGL_VW

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

Prompt Table: CLASSCF_BUGL_VW

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

Prompt Table: PROGRAM_BUGL_VW

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

Prompt Table: BUD_REF_BUGL_VW

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

Prompt Table: AFFILIATE_VW

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

Prompt Table: %EDIT_INTRA01

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

Prompt Table: %EDIT_INTRA02

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

Prompt Table: CF1_BUGL_VW

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

Prompt Table: CF2_BUGL_VW

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

Prompt Table: CF3_BUGL_VW

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

Prompt Table: %EDIT_BU_PC

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

Prompt Table: %EDIT_PROJECT

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

Prompt Table: %EDIT_ACTIVITY

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

Prompt Table: PROJ_RESTYPE_FS
Set Control Field: BUSINESS_UNIT_PC

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

Prompt Table: %EDIT_RES_CAT
Set Control Field: BUSINESS_UNIT_PC

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

Prompt Table: %EDIT_RES_SUB
Set Control Field: BUSINESS_UNIT_PC

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

Prompt Table: %EDIT_ANALYSIS
Set Control Field: BUSINESS_UNIT_PC

41 STATISTICS_CODE Character(3) VARCHAR2(3) NOT NULL Statistics Code
42 COMBO_VALID_FLG Character(1) VARCHAR2(1) NOT NULL ChartField Combinatn Valid Flg
?=Validation in Progress
V=Valid ChartField Combination
X=Invalid ChartField Combo