VCHR_MTCH_WS2

(SQL Table)
Index Back

Voucher Match Dist Work Scroll

# 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
4 BUSINESS_UNIT_PO Character(5) VARCHAR2(5) NOT NULL PO Business Unit
5 PO_ID Character(10) VARCHAR2(10) NOT NULL Purchase Order
6 LINE_NBR Number(5,0) INTEGER NOT NULL Line Number: 11/24/08 - Added TARGET label [PC product]
7 SCHED_NBR Number(3,0) SMALLINT NOT NULL Schedule Number
8 BUSINESS_UNIT_RECV Character(5) VARCHAR2(5) NOT NULL Receiving Business Unit
9 RECEIVER_ID Character(10) VARCHAR2(10) NOT NULL Receiver number
10 RECV_LN_NBR Number(5,0) INTEGER NOT NULL Receipt Line
11 RECV_SHIP_SEQ_NBR Number(3,0) SMALLINT NOT NULL Receiver Shipping Sequence
12 DISTRIB_LINE_NUM Number(5,0) INTEGER NOT NULL Distribution Line
13 DISTRIB_SEQ_NUM Number(5,0) INTEGER NOT NULL Distribution Sequence
14 TAG_NUMBER Character(12) VARCHAR2(12) NOT NULL Tag Number
15 SERIAL_ID Character(20) VARCHAR2(20) NOT NULL Serial ID
16 PO_DIST_LINE_NUM Number(5,0) INTEGER NOT NULL PO Distribution Line Number
17 RECV_DIST_LINE_NUM Number(5,0) INTEGER NOT NULL Receiver Distrib Line
18 ACCOUNT Character(10) VARCHAR2(10) NOT NULL Account
19 ALTACCT Character(10) VARCHAR2(10) NOT NULL Alternate Account
20 DEPTID Character(10) VARCHAR2(10) NOT NULL Department
21 BUSINESS_UNIT_GL Character(5) VARCHAR2(5) NOT NULL GL Business Unit
22 DESCR Character(30) VARCHAR2(30) NOT NULL Description
23 STATISTICS_CODE Character(3) VARCHAR2(3) NOT NULL Statistics Code
24 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.
25 MERCHANDISE_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Merchandise Amt F_KDHIL_R87H8 062804 MLM: Added new Line Amount Received Label
26 QTY_VCHR Signed Number(17,4) DECIMAL(15,4) NOT NULL Quantity Vouchered
27 DISTRIB_PCT Number(8,4) DECIMAL(7,4) NOT NULL Distribution Percentage
28 BUSINESS_UNIT_PC Character(5) VARCHAR2(5) NOT NULL PC Business Unit
29 ACTIVITY_ID Character(15) VARCHAR2(15) NOT NULL Activity ID
30 ANALYSIS_TYPE Character(3) VARCHAR2(3) NOT NULL Analysis Type
31 RESOURCE_TYPE Character(5) VARCHAR2(5) NOT NULL Source Type
32 RESOURCE_CATEGORY Character(5) VARCHAR2(5) NOT NULL Category
33 RESOURCE_SUB_CAT Character(5) VARCHAR2(5) NOT NULL Subcategory
34 BUSINESS_UNIT_AM Character(5) VARCHAR2(5) NOT NULL AM Business Unit
35 PROFILE_ID Character(10) VARCHAR2(10) NOT NULL Asset Profile ID
36 ASSET_FLG Character(1) VARCHAR2(1) NOT NULL Assets Applicable
37 ASSET_ID Character(12) VARCHAR2(12) NOT NULL Asset Identification
38 COST_TYPE Character(1) VARCHAR2(1) NOT NULL Cost Type
39 FOREIGN_CURRENCY Character(3) VARCHAR2(3) NOT NULL Foreign Currency Code
40 OPERATING_UNIT Character(8) VARCHAR2(8) NOT NULL Operating Unit ChartField
41 PRODUCT Character(6) VARCHAR2(6) NOT NULL Product ChartField
42 FUND_CODE Character(5) VARCHAR2(5) NOT NULL Fund Code
43 CLASS_FLD Character(5) VARCHAR2(5) NOT NULL Class Field
44 PROGRAM_CODE Character(5) VARCHAR2(5) NOT NULL Program Code ChartField
45 BUDGET_REF Character(8) VARCHAR2(8) NOT NULL Budget Reference
46 AFFILIATE Character(5) VARCHAR2(5) NOT NULL Affiliate
47 AFFILIATE_INTRA1 Character(10) VARCHAR2(10) NOT NULL IntraUnit Affiliate1
48 AFFILIATE_INTRA2 Character(10) VARCHAR2(10) NOT NULL Operating Unit Affiliate
49 CHARTFIELD1 Character(10) VARCHAR2(10) NOT NULL Expansion chartfield 1
50 CHARTFIELD2 Character(10) VARCHAR2(10) NOT NULL Expansion Chartfield 2
51 CHARTFIELD3 Character(10) VARCHAR2(10) NOT NULL Expansion Chartfield 3
52 PROJECT_ID Character(15) VARCHAR2(15) NOT NULL Project Id ChartField
53 SALETX_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Sales Tax Amount
54 USETAX_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Amount
55 CUR_RT_TYPE Character(5) VARCHAR2(5) NOT NULL Currency Rate Type
56 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code
57 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.
58 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
59 VAT_APPLICABILITY Character(1) VARCHAR2(1) NOT NULL A flag that indicates whether or not a transaction is eligible for VAT (Value Added Tax) taxation or why it is not eligible.
E=Exempt
N=Not Applicable
O=Outside of Scope of VAT
S=Suspended
T=Taxable
V=VAT Only
X=Exonerated
60 TAX_CD_VAT Character(8) VARCHAR2(8) NOT NULL Defines the VAT (Value Added Tax) percentage (via link to the Tax Authority) and is used to retrieve VAT accounting ChartFields. The VAT code determines how the VAT amount is calculated on a transaction and how that amount is accounted and reported for.
61 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.
62 VAT_RECOVERY_PCT Signed Number(7,2) DECIMAL(5,2) NOT NULL VAT Recovery Percent
63 VAT_REBATE_PCT Signed Number(7,2) DECIMAL(5,2) NOT NULL VAT Rebate Percent
64 VAT_CALC_TYPE Character(1) VARCHAR2(1) NOT NULL "A flag that indicates how VAT is stated and determines how the system performs the relevant VAT calculations. If ""Exclusive"", the VAT amount is stated separately from the merchandise amount. If ""Inclusive"", the VAT is not stated separately but is included with the merchandise amount."
E=Exclusive
I=Inclusive
65 VAT_NRCVR_PRO_FLG Character(1) VARCHAR2(1) NOT NULL Prorate Non-Recoverable VAT
66 VAT_RCVRY_PCT_SRC Character(1) VARCHAR2(1) NOT NULL VAT Recovery Percent Source
A=Automatically calculated
M=Manual Entry
67 VAT_REBATE_PCT_SRC Character(1) VARCHAR2(1) NOT NULL VAT Rebate Percent Source
A=Automatically calculated
M=Manual Entry
68 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.
69 KK_PROCESS_PRIOR Character(1) VARCHAR2(1) NOT NULL Process Prior Document

Y/N Table Edit

70 USER_DIST_CHAR1 Character(1) VARCHAR2(1) NOT NULL Custom Character 1
71 CUSTOM_C100_D1 Character(100) VARCHAR2(100) NOT NULL Custom Field 1
72 CUSTOM_C100_D2 Character(100) VARCHAR2(100) NOT NULL Custom Field 2
73 CUSTOM_C100_D3 Character(100) VARCHAR2(100) NOT NULL Custom Field 3
74 CUSTOM_C100_D4 Character(100) VARCHAR2(100) NOT NULL Custom Field 4
75 CUSTOM_DATE_D Date(10) DATE Custom Date
76 CUSTOM_C1_D Character(1) VARCHAR2(1) NOT NULL Custom Character 2
77 VENDOR_ID Character(10) VARCHAR2(10) NOT NULL Vendor Identifier
78 VNDR_LOC Character(10) VARCHAR2(10) NOT NULL Vendor Location
79 ENTRY_EVENT Character(10) VARCHAR2(10) NOT NULL Entry Event
80 OPEN_ITEM_KEY Character(30) VARCHAR2(30) NOT NULL Open Item Key
81 BUDGET_DT Date(10) DATE Budget Date
82 BUSINESS_UNIT_IN Character(5) VARCHAR2(5) NOT NULL Inventory Unit
83 PEG_STATUS Character(2) VARCHAR2(2) NOT NULL 07/21/04 EGS: Created
10=Open
20=Completed
30=Canceled
40=Not Pegged
84 VAT_USE_ID Character(6) VARCHAR2(6) NOT NULL VAT Use Type
85 BUSINESS_UNIT_WO Character(5) VARCHAR2(5) NOT NULL Business Unit Work Order

Prompt Table: SP_BU_WM_NONVW

86 WO_ID Character(10) VARCHAR2(10) NOT NULL Work Order Identification

Prompt Table: %EDIT_WO_ID

87 WO_TASK_ID Number(5,0) INTEGER NOT NULL Task Number

Prompt Table: %EDIT_WO_TASK

88 RSRC_TYPE Character(1) VARCHAR2(1) NOT NULL Work Order Management Resource Types
1=Labor
2=Tools
3=Material
89 RES_LN_NBR Number(5,0) INTEGER NOT NULL Resource Line No.

Prompt Table: %EDIT_RES_LINE