EX_SHEET_DST_VW

(SQL View)
 Index Back

Expense Sheet Dist View

View of Expense Sheet Accounting Distributions

SELECT A.EMPLID , B.SHEET_ID , B.LINE_NBR , B.DISTRIB_LINE_NUM , B.DST_ACCT_TYPE , B.BUSINESS_UNIT_GL , B.ACCOUNT , B.ALTACCT , B.DEPTID , %subrec(CF16_AN_SBR,B) , B.PROJECT_ID , B.MONETARY_AMOUNT , B.CURRENCY_CD , B.TXN_AMOUNT , B.TXN_CURRENCY_CD , B.RATE_MULT , B.RATE_DIV , B.RT_TYPE , B.GL_DISTRIB_STATUS , B.BI_DISTRIB_STATUS , %subrec(EX_PROJFLDS,B) , %subrec(EX_VAT_DIST,B) , B.ACCOUNTING_DT , B.BUDGET_DT , B.BUDGET_LINE_STATUS , B.LEDGER_GROUP , B.LEDGER , B.KK_PROCESS_PRIOR , B.TRAVEL_AUTH_ID , B.VAT_APORT_CNTRL , B.VAT_RCVRY_PCT_SRC , B.VAT_REBATE_PCT_SRC , B.VAT_RECOVERY_PCT , B.VAT_REBATE_PCT , B.CGST_AMT , B.CGST_RATE , B.SGST_AMT , B.SGST_RATE , B.IGST_AMT , B.TAXABLE_AMT , B.TAX_AUTHORITY , B.TAX_JURISDICTION_L , B.TAX_CODE , B.IGST_RATE , B.CGST_AMT_BSE , B.IGST_AMT_BSE , B.SGST_AMT_BSE , B.TAXABLE_AMT_BSE , B.CGST_CALC_AMT , B.CGST_CALC_AMT_BSE , B.SGST_CALC_AMT , B.SGST_CALC_AMT_BSE , B.IGST_CALC_AMT , B.IGST_CALC_AMT_BSE FROM PS_EX_SHEET_HDR A , PS_EX_SHEET_DIST B WHERE B.SHEET_ID = A.SHEET_ID

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
2 SHEET_ID Character(10) VARCHAR2(10) NOT NULL Report ID
3 LINE_NBR Number(5,0) INTEGER NOT NULL Line Number: 11/24/08 - Added TARGET label [PC product]
4 DISTRIB_LINE_NUM Number(5,0) INTEGER NOT NULL Distribution Line

Default Value: 1

5 DST_ACCT_TYPE Character(4) VARCHAR2(4) NOT NULL 07/20/04 st: added RCN for Advance Reconciliation 02/16/98 ebn CN#CM800-2.0 : Added for MISC type for Landed Cost Enhancement 11/11/99 llr: Added ADVP for Payables Advance Payment

Default Value: DST

6 BUSINESS_UNIT_GL Character(5) VARCHAR2(5) NOT NULL GL Business Unit

Default Value: BUS_UNIT_TBL_EX.BUSINESS_UNIT_GL

Prompt Table: SP_BU_GL_NONVW

7 ACCOUNT Character(10) VARCHAR2(10) NOT NULL Account

Prompt Table: GL_ACCT_BUGL_VW

8 ALTACCT Character(10) VARCHAR2(10) NOT NULL Alternate Account
9 DEPTID Character(10) VARCHAR2(10) NOT NULL Department

Prompt Table: DEPTID_BUGL_VW

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

Prompt Table: OPERUNT_BUGL_VW

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

Prompt Table: PRODUCT_BUGL_VW

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

Prompt Table: FUND_BUGL_VW

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

Prompt Table: CLASSCF_BUGL_VW

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

Prompt Table: PROGRAM_BUGL_VW

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

Prompt Table: BUD_REF_BUGL_VW

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

Prompt Table: AFFILIATE_VW

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

Prompt Table: %EDIT_INTRA01

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

Prompt Table: %EDIT_INTRA02

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

Prompt Table: CF1_BUGL_VW

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

Prompt Table: CF2_BUGL_VW

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

Prompt Table: CF3_BUGL_VW

22 PROJECT_ID Character(15) VARCHAR2(15) NOT NULL Project Id ChartField
23 MONETARY_AMOUNT Signed Number(28,3) DECIMAL(26,3) NOT NULL Specifies the monetary amount of a debit or credit in the business unit base currency. Debit entries are positive and credit entries are negative. This amount is only zero if associated with a statistical account.
24 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code

Prompt Table: CURRENCY_CD_TBL

25 TXN_AMOUNT Signed Number(28,3) DECIMAL(26,3) NOT NULL Transaction Amount
26 TXN_CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Transaction Currency

Prompt Table: CURRENCY_CD_TBL

27 RATE_MULT Signed Number(17,8) DECIMAL(15,8) NOT NULL Rate Multiplier
28 RATE_DIV Number(16,8) DECIMAL(15,8) NOT NULL Rate Divisor

Default Value: 1

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

Default Value: BUS_UNIT_OPT_EX.RT_TYPE

30 GL_DISTRIB_STATUS Character(1) VARCHAR2(1) NOT NULL Distribution Status
C=Available to Contracts
D=Distributed
G=Generated
H=Hold
I=Ignored
J=Creating Journals
M=Modified
N=None
P=To be processed
X=Waiting for Reversal

Default Value: N

31 BI_DISTRIB_STATUS Character(1) VARCHAR2(1) NOT NULL Billing Distribution Status
D=Distributed
I=Ignore
N=Not Distributed
P=Priced
U=Unbillable/Non-billable
W=Billing Worksheet

Default Value: I

32 BUSINESS_UNIT_PC Character(5) VARCHAR2(5) NOT NULL PC Business Unit
33 ACTIVITY_ID Character(15) VARCHAR2(15) NOT NULL Activity ID
34 RESOURCE_CATEGORY Character(5) VARCHAR2(5) NOT NULL Category
35 RESOURCE_TYPE Character(5) VARCHAR2(5) NOT NULL Source Type
36 RESOURCE_SUB_CAT Character(5) VARCHAR2(5) NOT NULL Subcategory
37 ANALYSIS_TYPE Character(3) VARCHAR2(3) NOT NULL Analysis Type
38 VAT_BASIS_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Specifies the amount on a sale (receivables item) or purchase (Payables voucher) transaction that is subject to VAT taxation. Depending on other parameters this amount may represent the gross or net amount of the transaction and may or may not include freight charges.
39 VAT_BASIS_AMT_BSE Signed Number(28,3) DECIMAL(26,3) NOT NULL VAT Basis Amt in Base Curr
40 VAT_CALC_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL VAT Calculated Amount
41 VAT_CALC_AMT_BSE Signed Number(28,3) DECIMAL(26,3) NOT NULL VAT Calculated Amount Base Cur
42 VAT_RCVRY_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL VAT Recovery Amt
43 VAT_RCVRY_AMT_BSE Signed Number(28,3) DECIMAL(26,3) NOT NULL VAT Recovery Amt in Base Curr
44 VAT_REBATE_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL VAT Rebate Amt
45 VAT_REBATE_AMT_BSE Signed Number(28,3) DECIMAL(26,3) NOT NULL VAT Rebate Amt in Base Curr
46 VAT_TRANS_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Represents the sale or purchase amount against which the VAT is applicable.
47 VAT_TRANS_AMT_BSE Signed Number(28,3) DECIMAL(26,3) NOT NULL Represents the sale or purchase amount in base currency against which the VAT is applicable
48 VAT_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Specifies the amount of VAT associated with a transaction such as an invoice or a purchase order. In PeopleSoft Receivables this field is populated when the VAT declaration point is set to Invoice.
49 VAT_AMT_BSE Signed Number(28,3) DECIMAL(26,3) NOT NULL VAT Amount in Base Curr
50 VAT_RCLM_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL VAT Reclaim Amount
51 VAT_RCLM_AMT_BSE Signed Number(28,3) DECIMAL(26,3) NOT NULL Base VAT Reclaim Amount
52 TXN_CURRENCY_CD1 Character(3) VARCHAR2(3) NOT NULL Transaction Currency Display
53 CURRENCY_CD1 Character(3) VARCHAR2(3) NOT NULL Currency Code
54 ACCOUNTING_DT Date(10) DATE The accounting entry construction date for a given transaction (a generic field that crosses multiple
55 BUDGET_DT Date(10) DATE Budget Date

Default Value: EX_SHEET_HDR.ACCOUNTING_DT

56 BUDGET_LINE_STATUS Character(1) VARCHAR2(1) NOT NULL -> SL - 15-AUG-2002 MISC_CRITERIA label has been added <-
B=Bypass
E=Error
N=Not Chk'd
V=Valid
W=Warning
57 LEDGER_GROUP Character(10) VARCHAR2(10) NOT NULL Ledger Group
58 LEDGER Character(10) VARCHAR2(10) NOT NULL Ledger
59 KK_PROCESS_PRIOR Character(1) VARCHAR2(1) NOT NULL Process Prior Document
60 TRAVEL_AUTH_ID Character(10) VARCHAR2(10) NOT NULL Travel Authorization Identification. Number used to define travel authorizations. Key field on most travel authorization records and exists at level 0 for travel authorization panels.
61 VAT_APORT_CNTRL Character(1) VARCHAR2(1) NOT NULL VAT Apportionment Control
D=Distribution GL Business Unit
G=Transaction GL Business Unit
T=Transaction Business Unit
62 VAT_RCVRY_PCT_SRC Character(1) VARCHAR2(1) NOT NULL VAT Recovery Percent Source
A=Automatically calculated
M=Manual Entry
63 VAT_REBATE_PCT_SRC Character(1) VARCHAR2(1) NOT NULL VAT Rebate Percent Source
A=Automatically calculated
M=Manual Entry
64 VAT_RECOVERY_PCT Signed Number(7,2) DECIMAL(5,2) NOT NULL VAT Recovery Percent
65 VAT_REBATE_PCT Signed Number(7,2) DECIMAL(5,2) NOT NULL VAT Rebate Percent
66 CGST_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL CGST Tax Amount
67 CGST_RATE Number(6,2) DECIMAL(5,2) NOT NULL CGST Tax Rate
68 SGST_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL SGST Tax Amount
69 SGST_RATE Number(6,2) DECIMAL(5,2) NOT NULL SGST Tax Rate
70 IGST_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL IGST Tax Amount
71 TAXABLE_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Cost of Good(s) or Service(s)
72 TAX_AUTHORITY Character(8) VARCHAR2(8) NOT NULL Tax Authority
73 TAX_JURISDICTION_L Character(10) VARCHAR2(10) NOT NULL Tax Jurisdiction
74 TAX_CODE Character(10) VARCHAR2(10) NOT NULL Tax code
75 IGST_RATE Number(6,2) DECIMAL(5,2) NOT NULL IGST Tax Rate
76 CGST_AMT_BSE Signed Number(28,3) DECIMAL(26,3) NOT NULL CGST Tax Amount
77 IGST_AMT_BSE Signed Number(28,3) DECIMAL(26,3) NOT NULL IGST Tax Amount
78 SGST_AMT_BSE Signed Number(28,3) DECIMAL(26,3) NOT NULL SGST Tax Amount
79 TAXABLE_AMT_BSE Signed Number(28,3) DECIMAL(26,3) NOT NULL Cost of Good(s) or Service(s)
80 CGST_CALC_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Calculated CGST Tax Amount
81 CGST_CALC_AMT_BSE Signed Number(28,3) DECIMAL(26,3) NOT NULL Calculated CGST Tax Amount
82 IGST_CALC_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Calculated IGST Tax Amount
83 IGST_CALC_AMT_BSE Signed Number(28,3) DECIMAL(26,3) NOT NULL Calculated IGST Tax Amount
84 SGST_CALC_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Calculated SGST Tax Amount
85 SGST_CALC_AMT_BSE Signed Number(28,3) DECIMAL(26,3) NOT NULL Calculated SGST Tax Amount