SAC_VCHR_DS_V

(SQL View)
 Index Back

EC Voucher Distrib Line

Outbound message view

SELECT A.BUSINESS_UNIT ,A.VOUCHER_ID ,A.VOUCHER_LINE_NUM ,A.DISTRIB_LINE_NUM ,A.BUSINESS_UNIT_GL ,A.ACCOUNT ,A.ALTACCT ,A.DEPTID ,A.STATISTICS_CODE ,A.STATISTIC_AMOUNT ,A.QTY_VCHR ,A.DESCR ,A.MERCHANDISE_AMT ,A.BUSINESS_UNIT_PO ,A.PO_ID ,A.LINE_NBR ,A.SCHED_NBR ,A.PO_DIST_LINE_NUM ,A.BUSINESS_UNIT_PC ,A.ACTIVITY_ID ,A.ANALYSIS_TYPE ,A.RESOURCE_TYPE ,A.RESOURCE_CATEGORY ,A.RESOURCE_SUB_CAT ,A.BUSINESS_UNIT_AM ,A.PROFILE_ID ,A.VAT_TXN_TYPE_CD ,A.VAT_APORT_CNTRL ,A.BUSINESS_UNIT_RECV ,A.RECEIVER_ID ,A.RECV_LN_NBR ,A.RECV_DIST_LINE_NUM ,A.BUDGET_DT ,%subrec(CF15_AN_SBR, A) ,A.PROJECT_ID ,A.PROCESS_INSTANCE ,A.ASSET_FLG ,A.COST_TYPE ,A.ASSET_ID ,A.ENTRY_EVENT ,A.JRNL_LN_REF ,A.ECTRANSID ,A.ECQUEUEINSTANCE ,A.ECTRANSINOUTSW ,A.RECV_SHIP_SEQ_NBR ,A.TXN_CURRENCY_CD ,%subrec(VCHRD_USER_SBR, A) ,%subrec(PUR_USR_DST_SBR, A) ,A.OPEN_ITEM_KEY ,A.VAT_RECOVERY_PCT ,A.VAT_REBATE_PCT ,A.VAT_CALC_AMT ,A.VAT_BASIS_AMT ,A.VAT_RCVRY_AMT ,A.VAT_NRCVR_AMT ,A.VAT_REBATE_AMT ,A.VAT_TRANS_AMT ,A.TAX_CD_VAT_PCT ,A.VAT_INV_AMT ,A.VAT_NONINV_AMT FROM PS_VCHR_DIST_QV A

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
2 VOUCHER_ID Character(8) VARCHAR2(8) NOT NULL Voucher ID
3 VOUCHER_LINE_NUM Number(5,0) INTEGER NOT NULL Voucher Line Number

Default Value: 1

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

Default Value: 1

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

Prompt Table: SP_BUPRCR_NONVW

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

Prompt Table: GL_ACCT_BUGL_VW

7 ALTACCT Character(10) VARCHAR2(10) NOT NULL Alternate Account

Prompt Table: ALT_BUGL_VW

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

Prompt Table: DEPTID_BUGL_VW

9 STATISTICS_CODE Character(3) VARCHAR2(3) NOT NULL Statistics Code
10 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.
11 QTY_VCHR Signed Number(17,4) DECIMAL(15,4) NOT NULL Quantity Vouchered
12 DESCR Character(30) VARCHAR2(30) NOT NULL Description
13 MERCHANDISE_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Merchandise Amt F_KDHIL_R87H8 062804 MLM: Added new Line Amount Received Label
14 BUSINESS_UNIT_PO Character(5) VARCHAR2(5) NOT NULL PO Business Unit
15 PO_ID Character(10) VARCHAR2(10) NOT NULL Purchase Order
16 LINE_NBR Number(5,0) INTEGER NOT NULL Line Number: 11/24/08 - Added TARGET label [PC product]
17 SCHED_NBR Number(3,0) SMALLINT NOT NULL Schedule Number
18 PO_DIST_LINE_NUM Number(5,0) INTEGER NOT NULL PO Distribution Line Number
19 BUSINESS_UNIT_PC Character(5) VARCHAR2(5) NOT NULL PC Business Unit
20 ACTIVITY_ID Character(15) VARCHAR2(15) NOT NULL Activity ID
21 ANALYSIS_TYPE Character(3) VARCHAR2(3) NOT NULL Analysis Type
22 RESOURCE_TYPE Character(5) VARCHAR2(5) NOT NULL Source Type
23 RESOURCE_CATEGORY Character(5) VARCHAR2(5) NOT NULL Category
24 RESOURCE_SUB_CAT Character(5) VARCHAR2(5) NOT NULL Subcategory
25 BUSINESS_UNIT_AM Character(5) VARCHAR2(5) NOT NULL AM Business Unit

Prompt Table: %EDITTABLE5

26 PROFILE_ID Character(10) VARCHAR2(10) NOT NULL Asset Profile ID

Prompt Table: %EDITTABLE7

27 VAT_TXN_TYPE_CD Character(4) VARCHAR2(4) NOT NULL Specifies a user-defined category of business transaction that is subject to VAT accounting and reporting. The VAT code and the VAT transaction type are used in conjunction with the VAT account type to obtain the ChartFields for accounting entries. Some examples of VAT Transaction Types are Exempt Sales Exempt Purchases Triangulation EU Sales and Domestic Sales.
28 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
29 BUSINESS_UNIT_RECV Character(5) VARCHAR2(5) NOT NULL Receiving Business Unit
30 RECEIVER_ID Character(10) VARCHAR2(10) NOT NULL Receiver number
31 RECV_LN_NBR Number(5,0) INTEGER NOT NULL Receipt Line
32 RECV_DIST_LINE_NUM Number(5,0) INTEGER NOT NULL Receiver Distrib Line
33 BUDGET_DT Date(10) DATE Budget Date
34 OPERATING_UNIT Character(8) VARCHAR2(8) NOT NULL Operating Unit ChartField

Prompt Table: OPERUNT_BUGL_VW

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

Prompt Table: PRODUCT_BUGL_VW

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

Prompt Table: FUND_BUGL_VW

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

Prompt Table: CLASSCF_BUGL_VW

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

Prompt Table: PROGRAM_BUGL_VW

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

Prompt Table: BUD_REF_BUGL_VW

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

Prompt Table: AFFILIATE_VW

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

Prompt Table: %EDIT_INTRA01

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

Prompt Table: %EDIT_INTRA02

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

Prompt Table: CF1_BUGL_VW

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

Prompt Table: CF2_BUGL_VW

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

Prompt Table: CF3_BUGL_VW

46 PROJECT_ID Character(15) VARCHAR2(15) NOT NULL Project Id ChartField
47 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance
48 ASSET_FLG Character(1) VARCHAR2(1) NOT NULL Assets Applicable
49 COST_TYPE Character(1) VARCHAR2(1) NOT NULL Cost Type

Prompt Table: %EDITTABLE18

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

Prompt Table: %EDITTABLE6

51 ENTRY_EVENT Character(10) VARCHAR2(10) NOT NULL Entry Event

Prompt Table: EE_AP_CODES_VW
Set Control Field: BUSINESS_UNIT

52 JRNL_LN_REF Character(10) VARCHAR2(10) NOT NULL Identifies a document, person, invoice, date, or any other piece of information that is associated with a journal line. It can be manually entered, or be defaulted from an accounting entry definition or from a Journal Generator Template. The journal line reference is optional, but helpful if you need to trace back to the source of the transaction.
53 ECTRANSID Character(15) VARCHAR2(15) NOT NULL Electronic Commerce Transaction ID. Used in EDI Manager. One of three(3) Key Fields(ECTRANSID, ECTRANSINOUTSW, ECQUEUEINSTANCE) used in Electronic Commerce(EC) Staging Tables. ECTRANSID in EDI Manager identifies a transaction type(like "PO" for Purchase Orders)
54 ECQUEUEINSTANCE Number(9,0) DECIMAL(9) NOT NULL Electronic Commerce Queue Instance ID. Used in EDI Manager. One of three(3) Key Fields(ECTRANSID, ECTRANSINOUTSW, ECQUEUEINSTANCE) used in Electronic Commerce(EC) Staging Tables.
55 ECTRANSINOUTSW Character(1) VARCHAR2(1) NOT NULL Electronic Commerce Inbound/Outbound Switch. Used in EDI Manager. One of three(3) Key Fields(ECTRANSID, ECTRANSINOUTSW, ECQUEUEINSTANCE) used in Electronic Commerce(EC) Staging Tables. The field value is "I" for Inbound Transactions, and "O" for Outbound.
I=Inbound
O=Outbound
56 RECV_SHIP_SEQ_NBR Number(3,0) SMALLINT NOT NULL Receiver Shipping Sequence
57 TXN_CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Transaction Currency

Default Value: VCHR_LINE_QV.TXN_CURRENCY_CD

58 USER_VCHR_CHAR1 Character(1) VARCHAR2(1) NOT NULL User Character Field
59 USER_VCHR_CHAR2 Character(1) VARCHAR2(1) NOT NULL User Character Field 2
60 USER_VCHR_DEC Signed Number(28,3) DECIMAL(26,3) NOT NULL User Amount Field
61 USER_VCHR_DATE Date(10) DATE User Date
62 USER_VCHR_NUM1 Number(3,0) SMALLINT NOT NULL User Number field
63 USER_DIST_CHAR1 Character(1) VARCHAR2(1) NOT NULL Custom Character 1
64 CUSTOM_C100_D1 Character(100) VARCHAR2(100) NOT NULL Custom Field 1
65 CUSTOM_C100_D2 Character(100) VARCHAR2(100) NOT NULL Custom Field 2
66 CUSTOM_C100_D3 Character(100) VARCHAR2(100) NOT NULL Custom Field 3
67 CUSTOM_C100_D4 Character(100) VARCHAR2(100) NOT NULL Custom Field 4
68 CUSTOM_DATE_D Date(10) DATE Custom Date
69 CUSTOM_C1_D Character(1) VARCHAR2(1) NOT NULL Custom Character 2
70 OPEN_ITEM_KEY Character(30) VARCHAR2(30) NOT NULL Open Item Key
71 VAT_RECOVERY_PCT Signed Number(7,2) DECIMAL(5,2) NOT NULL VAT Recovery Percent
72 VAT_REBATE_PCT Signed Number(7,2) DECIMAL(5,2) NOT NULL VAT Rebate Percent
73 VAT_CALC_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL VAT Calculated Amount
74 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.
75 VAT_RCVRY_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL VAT Recovery Amt
76 VAT_NRCVR_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL VAT Non Recoverable
77 VAT_REBATE_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL VAT Rebate Amt
78 VAT_TRANS_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Represents the sale or purchase amount against which the VAT is applicable.
79 TAX_CD_VAT_PCT Signed Number(9,4) DECIMAL(7,4) NOT NULL Specifies the tax percentage that corresponds to the VAT code. If more than one VAT authority is linked to a VAT code this will represent an aggregate percentage.
80 VAT_INV_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL VAT Invoice Amount
81 VAT_NONINV_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL VAT Non-Invoice Amount