| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 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)
|
| 2 |
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.
|
| 3 |
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
|
| 4 |
EMPLID |
Character(11) |
VARCHAR2(11) NOT NULL |
Employee ID
Prompt Table:
CC_SEC_VW
|
| 5 |
CREDIT_CARD_VENDOR |
Character(5) |
VARCHAR2(5) NOT NULL |
Corporate Card Vendor
|
| 6 |
CRDMEM_ACCT_NBR |
Character(44) |
VARCHAR2(44) NOT NULL |
Cardmember Number
Prompt Table:
CC_CARD_DATA_EX
|
| 7 |
TRANS_NBR |
Character(24) |
VARCHAR2(24) NOT NULL |
Transaction Number
|
| 8 |
SEQUENCENO |
Number(10,0) |
DECIMAL(10) NOT NULL |
Sequence Number
|
| 9 |
TRANS_DT |
Date(10) |
DATE NOT NULL |
Transaction Date
|
| 10 |
LINE_NBR |
Number(5,0) |
INTEGER NOT NULL |
Line Number:
11/24/08 - Added TARGET label [PC product]
|
| 11 |
POST_DT |
Date(10) |
DATE |
The Date a transaction was Posted.
|
| 12 |
BILLING_DATE |
Date(10) |
DATE |
Billing Date
|
| 13 |
SIC_CODE |
Character(10) |
VARCHAR2(10) NOT NULL |
Standard Industry Code
|
| 14 |
MERCHANT |
Character(40) |
VARCHAR2(40) NOT NULL |
Merchant
|
| 15 |
MERCHANT_REF |
Character(30) |
VARCHAR2(30) NOT NULL |
Reference Number
|
| 16 |
COUNTRY |
Character(3) |
VARCHAR2(3) NOT NULL |
Country
Prompt Table:
COUNTRY_TBL
|
| 17 |
ADDRESS1 |
Character(55) |
VARCHAR2(55) NOT NULL |
Address 1
|
| 18 |
ADDRESS2 |
Character(55) |
VARCHAR2(55) NOT NULL |
Address 2
|
| 19 |
ADDRESS3 |
Character(55) |
VARCHAR2(55) NOT NULL |
Address 3
|
| 20 |
ADDRESS4 |
Character(55) |
VARCHAR2(55) NOT NULL |
Address 4
|
| 21 |
CITY |
Character(30) |
VARCHAR2(30) NOT NULL |
City
|
| 22 |
NUM1 |
Character(6) |
VARCHAR2(6) NOT NULL |
Number 1
|
| 23 |
NUM2 |
Character(6) |
VARCHAR2(6) NOT NULL |
Number 2
|
| 24 |
HOUSE_TYPE |
Character(2) |
VARCHAR2(2) NOT NULL |
House Type
AB=House Boat
WW=Trailer
|
| 25 |
ADDR_FIELD1 |
Character(2) |
VARCHAR2(2) NOT NULL |
Address Field 1
|
| 26 |
ADDR_FIELD2 |
Character(4) |
VARCHAR2(4) NOT NULL |
Address Field 2
|
| 27 |
ADDR_FIELD3 |
Character(4) |
VARCHAR2(4) NOT NULL |
Address Field 3
|
| 28 |
COUNTY |
Character(30) |
VARCHAR2(30) NOT NULL |
County
|
| 29 |
STATE |
Character(6) |
VARCHAR2(6) NOT NULL |
State
Prompt Table:
%EDIT_STATE
|
| 30 |
POSTAL |
Character(12) |
VARCHAR2(12) NOT NULL |
Postal
|
| 31 |
GEO_CODE |
Character(11) |
VARCHAR2(11) NOT NULL |
Geo Code
|
| 32 |
IN_CITY_LIMIT |
Character(1) |
VARCHAR2(1) NOT NULL |
In City Limit
Y/N Table Edit
|
| 33 |
TAXPAYER_ID |
Character(14) |
VARCHAR2(14) NOT NULL |
Taxpayer ID
|
| 34 |
ITM_ID_VNDR |
Character(50) |
VARCHAR2(50) NOT NULL |
Vendor Item ID
Default Value: ITM_VENDOR.ITM_ID_VNDR
|
| 35 |
ACCOUNT |
Character(10) |
VARCHAR2(10) NOT NULL |
Account
|
| 36 |
ALTACCT |
Character(10) |
VARCHAR2(10) NOT NULL |
Alternate Account
|
| 37 |
COMMODITY_CD |
Character(10) |
VARCHAR2(10) NOT NULL |
Commodity Code
Prompt Table:
COMMOD_CODE
|
| 38 |
DESCR60 |
Character(60) |
VARCHAR2(60) NOT NULL |
Description
|
| 39 |
SHIPTO_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Ship To Location
Prompt Table:
SHIPTO_TBL
|
| 40 |
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
|
| 41 |
QTY_PO |
Number(16,4) |
DECIMAL(15,4) NOT NULL |
Purchase Order Quantity
|
| 42 |
UNIT_PRICE |
Signed Number(17,5) |
DECIMAL(15,5) NOT NULL |
Unit Price
|
| 43 |
TXN_AMOUNT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Transaction Amount
|
| 44 |
TXN_CURRENCY_CD |
Character(3) |
VARCHAR2(3) NOT NULL |
Transaction Currency
Prompt Table:
CURRENCY_CD_TBL
|
| 45 |
PRICE_PO |
Signed Number(17,5) |
DECIMAL(15,5) NOT NULL |
Purchase Order Price
|
| 46 |
MERCHANDISE_AMT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Merchandise Amt
F_KDHIL_R87H8 062804 MLM: Added new Line Amount Received Label
|
| 47 |
INCLUDE_TAX |
Character(1) |
VARCHAR2(1) NOT NULL |
Bill Includes Tax if Applied
|
| 48 |
TAX_PAID |
Character(1) |
VARCHAR2(1) NOT NULL |
Tax Paid
|
| 49 |
CHARGE_CATEGORY |
Character(3) |
VARCHAR2(3) NOT NULL |
Transaction Charge Type
1=New Charge
2=Other Debits
4=Payment
5=Other Credits
|
| 50 |
CURRENCY_CD |
Character(3) |
VARCHAR2(3) NOT NULL |
Currency Code
Prompt Table:
CURRENCY_CD_TBL
|
| 51 |
CORP_ACCT_NBR |
Character(20) |
VARCHAR2(20) NOT NULL |
Corporate Number
|
| 52 |
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
|
| 53 |
CUR_RT_TYPE_BNK |
Character(5) |
VARCHAR2(5) NOT NULL |
Currency Rate Type
|
| 54 |
CUR_EXCHNG_RT |
Number(16,8) |
DECIMAL(15,8) NOT NULL |
Currency Exchange Rate
|
| 55 |
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
|
| 56 |
SUT_BASE_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Sales/Use Tax Destination
|
| 57 |
TAX_CD_SUT |
Character(8) |
VARCHAR2(8) NOT NULL |
Tax Code - Sales and Use Tax
|
| 58 |
TAX_CD_SUT_PCT |
Number(8,4) |
DECIMAL(7,4) NOT NULL |
Sales/Use Tax Code Percent
|
| 59 |
TXN_SALETX_AMT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Transaction Sales Tax Amount
|
| 60 |
SALETX_AMT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Sales Tax Amount
|
| 61 |
TXN_USETAX_AMT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Transaction Use Tax Amount
|
| 62 |
USETAX_AMT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Amount
|
| 63 |
BUSINESS_UNIT |
Character(5) |
VARCHAR2(5) NOT NULL |
Business Unit
|
| 64 |
PO_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Purchase Order
|
| 65 |
MERCHANT_UOM |
Character(20) |
VARCHAR2(20) NOT NULL |
Merchant UOM
|