PROCARD_HDR_VW

(SQL View)
 Index Back

ProCard Trans. Dispute View

03/26/01 mj: Changed default for DISTRIB_MTHD_FLG from 'P' to 'Q'.

SELECT A.EMPLID , A.CREDIT_CARD_VENDOR , A.CRDMEM_ACCT_NBR , A.TRANS_NBR , A.TRANS_DT , A.DTTM_STAMP , A.POST_DT , A.BILLING_DATE , A.CC_STATUS , A.SIC_CODE , A.MERCHANT , A.MERCHANT_REF , %subrec(ADDRESS_SBR, A) , A.TAXPAYER_ID , A.ITM_ID_VNDR , A.COMMODITY_CD , A.DESCR60 , A.SHIPTO_ID , A.UNIT_OF_MEASURE , A.DISTRIB_MTHD_FLG , A.CHARGE_CATEGORY , A.INCLUDE_TAX , A.TAX_PAID , A.QTY_PO , A.UNIT_PRICE , A.TXN_AMOUNT , A.TXN_CURRENCY_CD , A.PRICE_PO , A.MERCHANDISE_AMT , A.CURRENCY_CD , A.CUR_RT_TYPE_BNK , A.CUR_EXCHNG_RT , A.CORP_ACCT_NBR , A.CREDIT_AMT , A.CREDIT_COLLECTED , A.BUSINESS_UNIT , A.VENDOR_SETID , A.VENDOR_ID , A.VNDR_LOC , A.VENDOR_TYPE , A.ITM_SETID , A.INV_ITEM_ID , A.CATEGORY_ID , A.MERCH_AMT_BSE , A.CURRENCY_CD_BASE , A.RT_TYPE , A.RATE_MULT , A.RATE_DIV , A.OPRID_ENTERED_BY , A.ENTERED_DT , A.OPRID_APPROVED_BY , A.APPROVAL_DT , %subrec(LAST_UPDATE_SBR, A) , A.OPRID , A.COMMENT_ID , A.RANDOM_CMMT_NBR , A.SUT_APPLICABILITY , A.SUT_BASE_ID , A.SUT_EXCPTN_CERTIF , A.SUT_EXCPTN_TYPE , A.TAX_CD_SUT , A.TAX_CD_SUT_PCT , A.PROCESS_INSTANCE , %subrec(KK_TRAN_SBR, A) , A.PO_ID , A.PO_LINE_NBR , A.PO_SCHED_NBR , A.CC_ORIGINAL_PO , A.MERCHANT_CAT_CODE , A.INVOICE_ID , A.BUSINESS_UNIT_AP , A.VOUCHER_ID , A.MERCHANT_UOM , %subrec(PUR_USR_HDR_SBR, A) , %subrec(PUR_USR_LIN_SBR, A) , %subrec(PUR_USR_SHP_SBR, A) FROM PS_CC_TRANS_LINE A

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID

Prompt Table: PERSONAL_DATA

2 CREDIT_CARD_VENDOR Character(5) VARCHAR2(5) NOT NULL Corporate Card Vendor
3 CRDMEM_ACCT_NBR Character(44) VARCHAR2(44) NOT NULL Cardmember Number

Prompt Table: CC_CARD_DATA_EX

4 TRANS_NBR Character(24) VARCHAR2(24) NOT NULL Transaction Number
5 TRANS_DT Date(10) DATE NOT NULL Transaction Date
6 DTTM_STAMP DateTime(26) TIMESTAMP Specifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.

Default Value: %DATE

7 POST_DT Date(10) DATE The Date a transaction was Posted.
8 BILLING_DATE Date(10) DATE Billing Date
9 CC_STATUS Character(1) VARCHAR2(1) NOT NULL Statement Status
0=Staged
1=Initial
2=Verified
3=Approved
4=Closed
5=Error
6=Processing
10 SIC_CODE Character(10) VARCHAR2(10) NOT NULL Standard Industry Code
11 MERCHANT Character(40) VARCHAR2(40) NOT NULL Merchant
12 MERCHANT_REF Character(30) VARCHAR2(30) NOT NULL Reference Number
13 COUNTRY Character(3) VARCHAR2(3) NOT NULL Country

Prompt Table: COUNTRY_TBL

14 ADDRESS1 Character(55) VARCHAR2(55) NOT NULL Address 1
15 ADDRESS2 Character(55) VARCHAR2(55) NOT NULL Address 2
16 ADDRESS3 Character(55) VARCHAR2(55) NOT NULL Address 3
17 ADDRESS4 Character(55) VARCHAR2(55) NOT NULL Address 4
18 CITY Character(30) VARCHAR2(30) NOT NULL City
19 NUM1 Character(6) VARCHAR2(6) NOT NULL Number 1
20 NUM2 Character(6) VARCHAR2(6) NOT NULL Number 2
21 HOUSE_TYPE Character(2) VARCHAR2(2) NOT NULL House Type
AB=House Boat
WW=Trailer
22 ADDR_FIELD1 Character(2) VARCHAR2(2) NOT NULL Address Field 1
23 ADDR_FIELD2 Character(4) VARCHAR2(4) NOT NULL Address Field 2
24 ADDR_FIELD3 Character(4) VARCHAR2(4) NOT NULL Address Field 3
25 COUNTY Character(30) VARCHAR2(30) NOT NULL County
26 STATE Character(6) VARCHAR2(6) NOT NULL State

Prompt Table: %EDIT_STATE

27 POSTAL Character(12) VARCHAR2(12) NOT NULL Postal
28 GEO_CODE Character(11) VARCHAR2(11) NOT NULL Geo Code
29 IN_CITY_LIMIT Character(1) VARCHAR2(1) NOT NULL In City Limit

Y/N Table Edit

30 TAXPAYER_ID Character(14) VARCHAR2(14) NOT NULL Taxpayer ID
31 ITM_ID_VNDR Character(50) VARCHAR2(50) NOT NULL Vendor Item ID

Default Value: ITM_VENDOR.ITM_ID_VNDR

32 COMMODITY_CD Character(10) VARCHAR2(10) NOT NULL Commodity Code

Prompt Table: COMMOD_CODE

33 DESCR60 Character(60) VARCHAR2(60) NOT NULL Description
34 SHIPTO_ID Character(10) VARCHAR2(10) NOT NULL Ship To Location

Prompt Table: SHIPTO_TBL

35 UNIT_OF_MEASURE Character(3) VARCHAR2(3) NOT NULL Used on an approval rule set.
MHR=Muti Hourly
PER=Percentage
SQF=Square Footage

Prompt Table: UNITS_TBL

36 DISTRIB_MTHD_FLG Character(1) VARCHAR2(1) NOT NULL Distribute by
A=Amount
Q=Quantity

Default Value: Q

37 CHARGE_CATEGORY Character(3) VARCHAR2(3) NOT NULL Transaction Charge Type
1=New Charge
2=Other Debits
4=Payment
5=Other Credits
38 INCLUDE_TAX Character(1) VARCHAR2(1) NOT NULL Bill Includes Tax if Applied
39 TAX_PAID Character(1) VARCHAR2(1) NOT NULL Tax Paid
40 QTY_PO Number(16,4) DECIMAL(15,4) NOT NULL Purchase Order Quantity
41 UNIT_PRICE Signed Number(17,5) DECIMAL(15,5) NOT NULL Unit Price
42 TXN_AMOUNT Signed Number(28,3) DECIMAL(26,3) NOT NULL Transaction Amount
43 TXN_CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Transaction Currency

Prompt Table: CURRENCY_CD_TBL

44 PRICE_PO Signed Number(17,5) DECIMAL(15,5) NOT NULL Purchase Order Price
45 MERCHANDISE_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Merchandise Amt F_KDHIL_R87H8 062804 MLM: Added new Line Amount Received Label
46 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code

Prompt Table: CURRENCY_CD_TBL

47 CUR_RT_TYPE_BNK Character(5) VARCHAR2(5) NOT NULL Currency Rate Type
48 CUR_EXCHNG_RT Number(16,8) DECIMAL(15,8) NOT NULL Currency Exchange Rate

Default Value: 1

49 CORP_ACCT_NBR Character(20) VARCHAR2(20) NOT NULL Corporate Number
50 CREDIT_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Date Init Ref# Descr 112007 LAKM 1717216002 Changed the filed type to enter credit value for Dispute amount field
51 CREDIT_COLLECTED Character(1) VARCHAR2(1) NOT NULL Credit Collected

Y/N Table Edit

Default Value: N

52 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit

Prompt Table: SP_BU_PM_NONVW

53 VENDOR_SETID Character(5) VARCHAR2(5) NOT NULL Vendor SetID
54 VENDOR_ID Character(10) VARCHAR2(10) NOT NULL Vendor Identifier

Prompt Table: VENDOR_POVW1

55 VNDR_LOC Character(10) VARCHAR2(10) NOT NULL Vendor Location
56 VENDOR_TYPE Character(3) VARCHAR2(3) NOT NULL Vendor Type
ADV=Ads
CNS=Consultant
CNT=Contractor
ENT=Entertain
FRG=Foreign
GVT=Government
MNR=Minority
PR=PR
TRD=Tradesman
TRN=Transport
TRV=Travel
57 ITM_SETID Character(5) VARCHAR2(5) NOT NULL Item SetID
58 INV_ITEM_ID Character(18) VARCHAR2(18) NOT NULL Item ID

Prompt Table: ITM_ITMSETID_VW

59 CATEGORY_ID Character(5) VARCHAR2(5) NOT NULL Category ID

Default Value: MASTER_ITEM_TBL.CATEGORY_ID

Prompt Table: ITM_CAT_VW

60 MERCH_AMT_BSE Signed Number(28,3) DECIMAL(26,3) NOT NULL Base Merchandise Amount
61 CURRENCY_CD_BASE Character(3) VARCHAR2(3) NOT NULL Business Unit Base Currency

Prompt Table: CURRENCY_CD_TBL

62 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.
63 RATE_MULT Signed Number(17,8) DECIMAL(15,8) NOT NULL Rate Multiplier

Default Value: 1

64 RATE_DIV Number(16,8) DECIMAL(15,8) NOT NULL Rate Divisor

Default Value: 1

65 OPRID_ENTERED_BY Character(30) VARCHAR2(30) NOT NULL Entered By 07/25/2011 MRAD 12383033 :Ensured that OPRID_ENTERED_BY is set with format type of MixedCase. 03/22/2013 GL 16482301: Switched OPRID_ENTERED_BY back to MixedCase again. Please don't change it to UpperCase!!! FYI - The alternatives to use a User ID as uppercase: 1) Create your own User ID, add comments in the Field Properties, and fill out the Owner ID 2) Use %Upper meta-SQL in SQL statements 3) Use Upper function in peoplecodes
66 ENTERED_DT Date(10) DATE Entered on
67 OPRID_APPROVED_BY Character(30) VARCHAR2(30) NOT NULL Approved By
68 APPROVAL_DT Date(10) DATE Date of Approval
69 OPRID_MODIFIED_BY Character(30) VARCHAR2(30) NOT NULL Last User to Modify Entered By 07/25/2011:Ensured that OPRID_MODIFIED_BY is set with format type of MixedCase.
70 LAST_DTTM_UPDATE DateTime(26) TIMESTAMP Specifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.
71 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
72 COMMENT_ID DateTime(26) TIMESTAMP DtTm Entered
73 RANDOM_CMMT_NBR Number(4,0) SMALLINT NOT NULL Random Comments Number
74 SUT_APPLICABILITY Character(1) VARCHAR2(1) NOT NULL Sales/Use Tax Applicability
D=Direct Pay
E=Item is Exempt
S=Sales Tax Applicable
U=Use Tax Applicable
X=Purchaser Is Exonerated
75 SUT_BASE_ID Character(10) VARCHAR2(10) NOT NULL Sales/Use Tax Destination
76 SUT_EXCPTN_CERTIF Character(20) VARCHAR2(20) NOT NULL Sales/Use Tax Exception Certif
77 SUT_EXCPTN_TYPE Character(1) VARCHAR2(1) NOT NULL Sales/Use Tax Exception Type
D=Direct Pay
E=Exempt/Exonerated
N=None
78 TAX_CD_SUT Character(8) VARCHAR2(8) NOT NULL Tax Code - Sales and Use Tax
79 TAX_CD_SUT_PCT Number(8,4) DECIMAL(7,4) NOT NULL Sales/Use Tax Code Percent
80 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance
81 BUDGET_HDR_STATUS Character(1) VARCHAR2(1) NOT NULL Budget Checking Header Status
E=Error in Budget Check
I=Document In Processing
N=Not Budget Checked
P=Provisionally Valid
V=Valid

Default Value: V

82 KK_AMOUNT_TYPE Character(1) VARCHAR2(1) NOT NULL Commitment Control Amount Type
0=Budget
1=Actuals and Recognized
2=Encumbrance
3=Pre-Encumbrance
4=Collected Revenue
5=Planned
7=Actuals, Recognize and Collect
9=Dynamic
83 KK_TRAN_OVER_FLAG Character(1) VARCHAR2(1) NOT NULL Commitment Control source transaction override flag
N=No
Y=Yes
84 KK_TRAN_OVER_OPRID Character(30) VARCHAR2(30) NOT NULL Commitment Control source transaction override operator
85 KK_TRAN_OVER_DTTM DateTime(26) TIMESTAMP Commitment Control source transaction override datetime
86 PO_ID Character(10) VARCHAR2(10) NOT NULL Purchase Order
87 PO_LINE_NBR Number(5,0) INTEGER NOT NULL Purchase Order Line Number
88 PO_SCHED_NBR Number(3,0) SMALLINT NOT NULL PO Schedule Number
89 CC_ORIGINAL_PO Character(1) VARCHAR2(1) NOT NULL Original PO

Y/N Table Edit

Default Value: N

90 MERCHANT_CAT_CODE Character(10) VARCHAR2(10) NOT NULL MCC - Merchant Category Code
91 INVOICE_ID Character(30) VARCHAR2(30) NOT NULL Invoice Number
92 BUSINESS_UNIT_AP Character(5) VARCHAR2(5) NOT NULL AP Business Unit
93 VOUCHER_ID Character(8) VARCHAR2(8) NOT NULL Voucher ID
94 MERCHANT_UOM Character(20) VARCHAR2(20) NOT NULL Merchant UOM
95 USER_HDR_CHAR1 Character(1) VARCHAR2(1) NOT NULL Custom Character 1
96 CUSTOM_C100_A1 Character(100) VARCHAR2(100) NOT NULL Custom Field 1
97 CUSTOM_C100_A2 Character(100) VARCHAR2(100) NOT NULL Custom Field 2
98 CUSTOM_C100_A3 Character(100) VARCHAR2(100) NOT NULL Custom Field 3
99 CUSTOM_C100_A4 Character(100) VARCHAR2(100) NOT NULL Custom Field 4
100 CUSTOM_DATE_A Date(10) DATE Custom Date
101 CUSTOM_C1_A Character(1) VARCHAR2(1) NOT NULL Custom Character 2
102 USER_LINE_CHAR1 Character(1) VARCHAR2(1) NOT NULL Custom Character 1
103 CUSTOM_C100_B1 Character(100) VARCHAR2(100) NOT NULL Custom Field 1
104 CUSTOM_C100_B2 Character(100) VARCHAR2(100) NOT NULL Custom Field 2
105 CUSTOM_C100_B3 Character(100) VARCHAR2(100) NOT NULL Custom Field 3
106 CUSTOM_C100_B4 Character(100) VARCHAR2(100) NOT NULL Custom Field 4
107 CUSTOM_DATE_B Date(10) DATE Custom Date
108 CUSTOM_C1_B Character(1) VARCHAR2(1) NOT NULL Custom Character 2
109 USER_SCHED_CHAR1 Character(1) VARCHAR2(1) NOT NULL Custom Character 1
110 CUSTOM_C100_C1 Character(100) VARCHAR2(100) NOT NULL Custom Field 1
111 CUSTOM_C100_C2 Character(100) VARCHAR2(100) NOT NULL Custom Field 2
112 CUSTOM_C100_C3 Character(100) VARCHAR2(100) NOT NULL Custom Field 3
113 CUSTOM_DATE_C1 Date(10) DATE Custom Date 1
114 CUSTOM_DATE_C2 Date(10) DATE Custom Date 2
115 CUSTOM_C1_C Character(1) VARCHAR2(1) NOT NULL Custom Character 2