TD_INTFC_BI_VW2

(SQL View)
Index Back

Promo Mgmt BI Interface View


SELECT B.INTFC_ID , B.INTFC_LINE_NUM , B.TRANS_TYPE_BI , B.TRANS_TYPE_BI_SEQ , B.STATISTICS_CODE , B.STATISTIC_AMOUNT , B.ACCOUNT , B.ALTACCT , B.DEPTID , B.AMOUNT , B.PERCENTAGE , B.DST_ID , B.PROJECT_ID , %subrec(CF21_AN_SBR, B) FROM PS_INTFC_BI A , PS_INTFC_BI_AEDS B WHERE A.LOAD_STATUS_BI = 'ERR' AND A.INTFC_ID = B.INTFC_ID AND A.INTFC_LINE_NUM = B.INTFC_LINE_NUM AND A.TRANS_TYPE_BI = B.TRANS_TYPE_BI

# 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 TRANS_TYPE_BI Character(4) VARCHAR2(4) NOT NULL Transaction Type
AE=Accounting Entry
AHDR=Adjustment Header
DDS=Deferred Discount/Surcharge
DS=Discount/Surcharge
EXSD=Indian Excise/Sales Tax Detail
LINE=Chargeable Line
NOTE=Note/Comment
TAX=Sales/Use Tax Detail
4 TRANS_TYPE_BI_SEQ Number(3,0) SMALLINT NOT NULL Transaction Type Seq
010=Invalid Transaction Type
020=Too many charge lines
030=No charge line for activity
040=Invalid Business Unit
050=Invalid bill-to customer
060=Invalid Billing Address
070=Invalid bill-to contact
080=No Bill Source provided
090=Invalid Bill Source
100=Invalid Bill Type
110=Invalid Bill Cycle
120=Invalid Payment Term
130=Invalid Tax Code
140=Invalid Unit of measure
200=Invalid Standard Note Code
210=No Note Code or Text exists
300=Both Amount & Percentage are 0
5 STATISTICS_CODE Character(3) VARCHAR2(3) NOT NULL Statistics Code
6 STATISTIC_AMOUNT Signed Number(17,2) DECIMAL(15,2) NOT NULL Specifies the amount associated with a statistical account on a journal line or a distribution line. It represents a quantity rather than a monetary amount and is qualified by the Unit of Measure associated with the STATISTICS_CODE or statistics ACCOUNT.
7 ACCOUNT Character(10) VARCHAR2(10) NOT NULL Account
8 ALTACCT Character(10) VARCHAR2(10) NOT NULL Alternate Account
9 DEPTID Character(10) VARCHAR2(10) NOT NULL Department
10 AMOUNT Signed Number(28,3) DECIMAL(26,3) NOT NULL Amount
11 PERCENTAGE Signed Number(7,2) DECIMAL(5,2) NOT NULL Percentage
12 DST_ID Character(10) VARCHAR2(10) NOT NULL Distribution Code
13 PROJECT_ID Character(15) VARCHAR2(15) NOT NULL Project Id ChartField
14 OPERATING_UNIT Character(8) VARCHAR2(8) NOT NULL Operating Unit ChartField

Prompt Table: OPERUNT_SC_VW

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

Prompt Table: PRODUCT_SC_VW

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

Prompt Table: FUND_SC_VW

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

Prompt Table: CLASS_CF_SC_VW

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

Prompt Table: PROGRAM_SC_VW

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

Prompt Table: BUD_REF_SC_VW

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

Prompt Table: AFFILIATE_VW

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

Prompt Table: %EDIT_INTRA01

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

Prompt Table: %EDIT_INTRA02

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

Prompt Table: CF1_SC_VW

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

Prompt Table: CF2_SC_VW

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

Prompt Table: CF3_SC_VW