PO_PCL_TRAN_EVW

(SQL View)
 Index Back

ProCard Electronic Document VW

SELECT EMPLID , CREDIT_CARD_VENDOR , CRDMEM_ACCT_NBR , TRANS_NBR , TRANS_DT , POST_DT , BILLING_DATE , SIC_CODE , MERCHANT , MERCHANT_REF , ADDRESS_SBR , TAXPAYER_ID , ITM_ID_VNDR , ACCOUNT , ALTACCT , COMMODITY_CD , DESCR60 , SHIPTO_ID , UNIT_OF_MEASURE , QTY_PO , UNIT_PRICE , TXN_AMOUNT , TXN_CURRENCY_CD , PRICE_PO , MERCHANDISE_AMT , INCLUDE_TAX , TAX_PAID , CHARGE_CATEGORY , CURRENCY_CD , CORP_ACCT_NBR , VENDOR_TYPE , CUR_RT_TYPE_BNK , CUR_EXCHNG_RT , SUT_APPLICABILITY , SUT_BASE_ID , TAX_CD_SUT , TAX_CD_SUT_PCT , TXN_SALETX_AMT , SALETX_AMT , USETAX_AMT FROM PS_CC_TRANS_EC

SELECT EMPLID , CREDIT_CARD_VENDOR , CRDMEM_ACCT_NBR , TRANS_NBR , SEQUENCENO , TRANS_DT , LINE_NBR , POST_DT , BILLING_DATE , SIC_CODE , MERCHANT , MERCHANT_REF , COUNTRY , ADDRESS1 , ADDRESS2 , ADDRESS3 , ADDRESS4 , CITY , NUM1 , NUM2 , HOUSE_TYPE , ADDR_FIELD1 , ADDR_FIELD2 , ADDR_FIELD3 , COUNTY , STATE , POSTAL , GEO_CODE , IN_CITY_LIMIT , TAXPAYER_ID , ITM_ID_VNDR , ACCOUNT , ALTACCT , COMMODITY_CD , DESCR60 , SHIPTO_ID , UNIT_OF_MEASURE , QTY_PO , UNIT_PRICE , TXN_AMOUNT , TXN_CURRENCY_CD , PRICE_PO , MERCHANDISE_AMT , INCLUDE_TAX , TAX_PAID , CHARGE_CATEGORY , CURRENCY_CD , CORP_ACCT_NBR , VENDOR_TYPE , CUR_RT_TYPE_BNK , CUR_EXCHNG_RT , SUT_APPLICABILITY , SUT_BASE_ID , TAX_CD_SUT , TAX_CD_SUT_PCT , TXN_SALETX_AMT , SALETX_AMT , TXN_USETAX_AMT , USETAX_AMT , BUSINESS_UNIT , PO_ID , PHYSICAL_NATURE , VAT_ENTRD_AMT , VAT_ENTRD_TAX_PCT , VAT_RGSTRN_SELLER , VAT_INCLUDE_FLG , MERCHANT_UOM , MERCHANT_CAT_CODE FROM PS_CC_TRANS_EC

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
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
4 TRANS_NBR Character(24) VARCHAR2(24) NOT NULL Transaction Number
5 SEQUENCENO Number(10,0) DECIMAL(10) NOT NULL Sequence Number
6 TRANS_DT Date(10) DATE Transaction Date
7 LINE_NBR Number(5,0) INTEGER NOT NULL Line Number: 11/24/08 - Added TARGET label [PC product]
8 POST_DT Date(10) DATE The Date a transaction was Posted.
9 BILLING_DATE Date(10) DATE Billing Date
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 ACCOUNT Character(10) VARCHAR2(10) NOT NULL Account
33 ALTACCT Character(10) VARCHAR2(10) NOT NULL Alternate Account
34 COMMODITY_CD Character(10) VARCHAR2(10) NOT NULL Commodity Code
35 DESCR60 Character(60) VARCHAR2(60) NOT NULL Description
36 SHIPTO_ID Character(10) VARCHAR2(10) NOT NULL Ship To Location
37 UNIT_OF_MEASURE Character(3) VARCHAR2(3) NOT NULL Used on an approval rule set.
MHR=Muti Hourly
PER=Percentage
SQF=Square Footage
38 QTY_PO Number(16,4) DECIMAL(15,4) NOT NULL Purchase Order Quantity
39 UNIT_PRICE Signed Number(17,5) DECIMAL(15,5) NOT NULL Unit Price
40 TXN_AMOUNT Signed Number(28,3) DECIMAL(26,3) NOT NULL Transaction Amount
41 TXN_CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Transaction Currency
42 PRICE_PO Signed Number(17,5) DECIMAL(15,5) NOT NULL Purchase Order Price
43 MERCHANDISE_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Merchandise Amt F_KDHIL_R87H8 062804 MLM: Added new Line Amount Received Label
44 INCLUDE_TAX Character(1) VARCHAR2(1) NOT NULL Bill Includes Tax if Applied
45 TAX_PAID Character(1) VARCHAR2(1) NOT NULL Tax Paid
46 CHARGE_CATEGORY Character(3) VARCHAR2(3) NOT NULL Transaction Charge Type
1=New Charge
2=Other Debits
4=Payment
5=Other Credits
47 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code
48 CORP_ACCT_NBR Character(20) VARCHAR2(20) NOT NULL Corporate Number
49 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
50 CUR_RT_TYPE_BNK Character(5) VARCHAR2(5) NOT NULL Currency Rate Type
51 CUR_EXCHNG_RT Number(16,8) DECIMAL(15,8) NOT NULL Currency Exchange Rate
52 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
53 SUT_BASE_ID Character(10) VARCHAR2(10) NOT NULL Sales/Use Tax Destination
54 TAX_CD_SUT Character(8) VARCHAR2(8) NOT NULL Tax Code - Sales and Use Tax
55 TAX_CD_SUT_PCT Number(8,4) DECIMAL(7,4) NOT NULL Sales/Use Tax Code Percent
56 TXN_SALETX_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Transaction Sales Tax Amount
57 SALETX_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Sales Tax Amount
58 TXN_USETAX_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Transaction Use Tax Amount
59 USETAX_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Amount
60 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
61 PO_ID Character(10) VARCHAR2(10) NOT NULL Purchase Order
62 PHYSICAL_NATURE Character(1) VARCHAR2(1) NOT NULL Physical Nature
G=Goods
S=Services
63 VAT_ENTRD_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Entered VAT Amount
64 VAT_ENTRD_TAX_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.
65 VAT_RGSTRN_SELLER Character(20) VARCHAR2(20) NOT NULL Seller's VAT Registration
66 VAT_INCLUDE_FLG Character(1) VARCHAR2(1) NOT NULL Includes VAT
E=Exclude VAT
I=Include VAT
67 MERCHANT_UOM Character(20) VARCHAR2(20) NOT NULL Merchant UOM
68 MERCHANT_CAT_CODE Character(10) VARCHAR2(10) NOT NULL MCC - Merchant Category Code