| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 PROCESS_INSTANCE |
Number(10,0) |
DECIMAL(10) NOT NULL |
Process Instance
|
| 2 |
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)
|
| 3 |
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.
|
| 4 |
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
Default Value: I
|
| 5 |
EMPLID |
Character(11) |
VARCHAR2(11) NOT NULL |
Employee ID
Prompt Table:
CC_SEC_VW
|
| 6 |
CREDIT_CARD_VENDOR |
Character(5) |
VARCHAR2(5) NOT NULL |
Corporate Card Vendor
|
| 7 |
CRDMEM_ACCT_NBR |
Character(44) |
VARCHAR2(44) NOT NULL |
Cardmember Number
Prompt Table:
CC_CARD_DATA_EX
|
| 8 |
TRANS_NBR |
Character(24) |
VARCHAR2(24) NOT NULL |
Transaction Number
|
| 9 |
SEQUENCENO |
Number(10,0) |
DECIMAL(10) NOT NULL |
Sequence Number
|
| 10 |
TRANS_DT |
Date(10) |
DATE NOT NULL |
Transaction Date
|
| 11 |
LINE_NBR |
Number(5,0) |
INTEGER NOT NULL |
Line Number:
11/24/08 - Added TARGET label [PC product]
|
| 12 |
POST_DT |
Date(10) |
DATE |
The Date a transaction was Posted.
|
| 13 |
BILLING_DATE |
Date(10) |
DATE |
Billing Date
|
| 14 |
SIC_CODE |
Character(10) |
VARCHAR2(10) NOT NULL |
Standard Industry Code
|
| 15 |
MERCHANT |
Character(40) |
VARCHAR2(40) NOT NULL |
Merchant
|
| 16 |
MERCHANT_REF |
Character(30) |
VARCHAR2(30) NOT NULL |
Reference Number
|
| 17 |
COUNTRY |
Character(3) |
VARCHAR2(3) NOT NULL |
Country
Prompt Table:
COUNTRY_TBL
|
| 18 |
ADDRESS1 |
Character(55) |
VARCHAR2(55) NOT NULL |
Address 1
|
| 19 |
ADDRESS2 |
Character(55) |
VARCHAR2(55) NOT NULL |
Address 2
|
| 20 |
ADDRESS3 |
Character(55) |
VARCHAR2(55) NOT NULL |
Address 3
|
| 21 |
ADDRESS4 |
Character(55) |
VARCHAR2(55) NOT NULL |
Address 4
|
| 22 |
CITY |
Character(30) |
VARCHAR2(30) NOT NULL |
City
|
| 23 |
NUM1 |
Character(6) |
VARCHAR2(6) NOT NULL |
Number 1
|
| 24 |
NUM2 |
Character(6) |
VARCHAR2(6) NOT NULL |
Number 2
|
| 25 |
HOUSE_TYPE |
Character(2) |
VARCHAR2(2) NOT NULL |
House Type
AB=House Boat
WW=Trailer
|
| 26 |
ADDR_FIELD1 |
Character(2) |
VARCHAR2(2) NOT NULL |
Address Field 1
|
| 27 |
ADDR_FIELD2 |
Character(4) |
VARCHAR2(4) NOT NULL |
Address Field 2
|
| 28 |
ADDR_FIELD3 |
Character(4) |
VARCHAR2(4) NOT NULL |
Address Field 3
|
| 29 |
COUNTY |
Character(30) |
VARCHAR2(30) NOT NULL |
County
|
| 30 |
STATE |
Character(6) |
VARCHAR2(6) NOT NULL |
State
Prompt Table:
%EDIT_STATE
|
| 31 |
POSTAL |
Character(12) |
VARCHAR2(12) NOT NULL |
Postal
|
| 32 |
GEO_CODE |
Character(11) |
VARCHAR2(11) NOT NULL |
Geo Code
|
| 33 |
IN_CITY_LIMIT |
Character(1) |
VARCHAR2(1) NOT NULL |
In City Limit
Y/N Table Edit
|
| 34 |
TAXPAYER_ID |
Character(14) |
VARCHAR2(14) NOT NULL |
Taxpayer ID
|
| 35 |
ITM_ID_VNDR |
Character(50) |
VARCHAR2(50) NOT NULL |
Vendor Item ID
Default Value: ITM_VENDOR.ITM_ID_VNDR
|
| 36 |
ACCOUNT |
Character(10) |
VARCHAR2(10) NOT NULL |
Account
|
| 37 |
ALTACCT |
Character(10) |
VARCHAR2(10) NOT NULL |
Alternate Account
|
| 38 |
COMMODITY_CD |
Character(10) |
VARCHAR2(10) NOT NULL |
Commodity Code
Prompt Table:
COMMOD_CODE
|
| 39 |
DESCR60 |
Character(60) |
VARCHAR2(60) NOT NULL |
Description
|
| 40 |
SHIPTO_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Ship To Location
Prompt Table:
SHIPTO_TBL
|
| 41 |
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
|
| 42 |
QTY_PO |
Number(16,4) |
DECIMAL(15,4) NOT NULL |
Purchase Order Quantity
|
| 43 |
UNIT_PRICE |
Signed Number(17,5) |
DECIMAL(15,5) NOT NULL |
Unit Price
|
| 44 |
TXN_AMOUNT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Transaction Amount
|
| 45 |
TXN_CURRENCY_CD |
Character(3) |
VARCHAR2(3) NOT NULL |
Transaction Currency
Prompt Table:
CURRENCY_CD_TBL
|
| 46 |
PRICE_PO |
Signed Number(17,5) |
DECIMAL(15,5) NOT NULL |
Purchase Order Price
|
| 47 |
MERCHANDISE_AMT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Merchandise Amt
F_KDHIL_R87H8 062804 MLM: Added new Line Amount Received Label
|
| 48 |
INCLUDE_TAX |
Character(1) |
VARCHAR2(1) NOT NULL |
Bill Includes Tax if Applied
Default Value: N
|
| 49 |
TAX_PAID |
Character(1) |
VARCHAR2(1) NOT NULL |
Tax Paid
Default Value: N
|
| 50 |
CHARGE_CATEGORY |
Character(3) |
VARCHAR2(3) NOT NULL |
Transaction Charge Type
1=New Charge
2=Other Debits
4=Payment
5=Other Credits
|
| 51 |
CURRENCY_CD |
Character(3) |
VARCHAR2(3) NOT NULL |
Currency Code
Prompt Table:
CURRENCY_CD_TBL
|
| 52 |
CORP_ACCT_NBR |
Character(20) |
VARCHAR2(20) NOT NULL |
Corporate Number
|
| 53 |
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
|
| 54 |
CUR_RT_TYPE_BNK |
Character(5) |
VARCHAR2(5) NOT NULL |
Currency Rate Type
|
| 55 |
CUR_EXCHNG_RT |
Number(16,8) |
DECIMAL(15,8) NOT NULL |
Currency Exchange Rate
|
| 56 |
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
|
| 57 |
SUT_BASE_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Sales/Use Tax Destination
|
| 58 |
TAX_CD_SUT |
Character(8) |
VARCHAR2(8) NOT NULL |
Tax Code - Sales and Use Tax
|
| 59 |
TAX_CD_SUT_PCT |
Number(8,4) |
DECIMAL(7,4) NOT NULL |
Sales/Use Tax Code Percent
|
| 60 |
TXN_SALETX_AMT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Transaction Sales Tax Amount
|
| 61 |
SALETX_AMT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Sales Tax Amount
|
| 62 |
TXN_USETAX_AMT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Transaction Use Tax Amount
|
| 63 |
USETAX_AMT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Amount
|
| 64 |
BUSINESS_UNIT |
Character(5) |
VARCHAR2(5) NOT NULL |
Business Unit
|
| 65 |
PO_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Purchase Order
|
| 66 |
MERCHANT_UOM |
Character(20) |
VARCHAR2(20) NOT NULL |
Merchant UOM
|
| 67 |
MERCHANT_CAT_CODE |
Character(10) |
VARCHAR2(10) NOT NULL |
MCC - Merchant Category Code
|
| 68 |
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.
|
| 69 |
CURRENCY_CD_BASE |
Character(3) |
VARCHAR2(3) NOT NULL |
Business Unit Base Currency
|
| 70 |
MERCH_AMT_BSE |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Base Merchandise Amount
|
| 71 |
RATE_MULT |
Signed Number(17,8) |
DECIMAL(15,8) NOT NULL |
Rate Multiplier
|
| 72 |
RATE_DIV |
Number(16,8) |
DECIMAL(15,8) NOT NULL |
Rate Divisor
|
| 73 |
CC_STATUS |
Character(1) |
VARCHAR2(1) NOT NULL |
Statement Status
0=Staged
1=Initial
2=Verified
3=Approved
4=Closed
5=Error
6=Processing
|
| 74 |
CURRENCY_CD_MISC |
Character(3) |
VARCHAR2(3) NOT NULL |
Miscellaneous Charge Code
|
| 75 |
PHYSICAL_NATURE |
Character(1) |
VARCHAR2(1) NOT NULL |
Physical Nature
G=Goods
S=Services
|
| 76 |
VAT_ENTRD_AMT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Entered VAT Amount
|
| 77 |
VAT_ENTRD_AMT_BSE |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Entered VAT Amount Base Cur
|
| 78 |
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.
|
| 79 |
VAT_RGSTRN_SELLER |
Character(20) |
VARCHAR2(20) NOT NULL |
Seller's VAT Registration
|
| 80 |
VAT_INCLUDE_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Includes VAT
E=Exclude VAT
I=Include VAT
|
| 81 |
SALETX_PAID |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Sales Tax Paid Amount
|
| 82 |
SALETX_PAID_BSE |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Sales Tax Paid Base Amount
|
| 83 |
USETAX_PAID |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Use Tax Paid Amount
|
| 84 |
USETAX_PAID_BSE |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Use Tax Paid Base Amount
|
| 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
|
| 90 |
CC_SECURITY_ID |
Number(10,0) |
DECIMAL(10) NOT NULL |
Procurement Card Number
|
| 91 |
PREPAID_REF |
Character(10) |
VARCHAR2(10) NOT NULL |
Prepayment Reference
|
| 92 |
MC_ADJDESCR |
Character(40) |
VARCHAR2(40) NOT NULL |
Adjustment Description
|