| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 BUSINESS_UNIT |
Character(5) |
VARCHAR2(5) NOT NULL |
Business Unit
|
| 2 |
INVOICE |
Character(22) |
VARCHAR2(22) NOT NULL |
Invoice
|
| 3 |
SEQ_NUM |
Number(3,0) |
SMALLINT NOT NULL |
Sequence
Default Value: 1
|
| 4 |
CR_CARD_TYPE |
Character(3) |
VARCHAR2(3) NOT NULL |
"See OM
01=Visa
02=MasterCard
03=Diners Club/Carte Blanche
04=AMEX
05=Discover
06=EnRoute
Prompt Table:
FS_CR_CARD_VW
|
| 5 |
CR_CARD_VENDOR |
Character(16) |
VARCHAR2(16) NOT NULL |
Processor Name
|
| 6 |
CC_PROF_TOKEN |
Character(44) |
VARCHAR2(44) NOT NULL |
Profile Token ID
|
| 7 |
CR_CARD_NBR |
Character(44) |
VARCHAR2(44) NOT NULL |
"See OM
|
| 8 |
CR_CARD_LNAME |
Character(40) |
VARCHAR2(40) NOT NULL |
Credit Card Last Name
|
| 9 |
CR_CARD_FNAME |
Character(40) |
VARCHAR2(40) NOT NULL |
Credit Card First Name
|
| 10 |
CR_CARD_EXPMO |
Character(2) |
VARCHAR2(2) NOT NULL |
Card Expiration Month
01=January
02=February
03=March
04=April
05=May
06=June
07=July
08=August
09=September
10=October
11=November
12=December
|
| 11 |
CR_CARD_EXPYR |
Character(4) |
VARCHAR2(4) NOT NULL |
Card Expiration Year
2011=2011
2012=2012
2013=2013
2014=2014
2015=2015
2016=2016
2017=2017
2018=2018
2019=2019
2020=2020
|
| 12 |
CR_CARD_DIGITS |
Character(4) |
VARCHAR2(4) NOT NULL |
Card Number's Last Four Digits
|
| 13 |
CR_CARD_CVNUM |
Character(44) |
VARCHAR2(44) NOT NULL |
Card Verification Number
|
| 14 |
NAME_EXACT |
Character(40) |
VARCHAR2(40) NOT NULL |
Exact Name on Card
|
| 15 |
EXPIRATION_DT |
Date(10) |
DATE |
Expiration Date
|
| 16 |
BI_CURRENCY_CD |
Character(3) |
VARCHAR2(3) NOT NULL |
Billing Currency Code
Default Value: BI_HDR.BI_CURRENCY_CD
|
| 17 |
BASE_CURRENCY |
Character(3) |
VARCHAR2(3) NOT NULL |
"Specifies the primary currency for a general ledger business unit, and is sometimes referred to as the ""book"" currency. Each business unit has one base currency. which is usually, but not always, the local currency for the organization. Journal entries are posted to a business unit in its base currency. "
Default Value: BI_HDR.BASE_CURRENCY
|
| 18 |
CURRENCY_CD_XEU |
Character(3) |
VARCHAR2(3) NOT NULL |
Euro Currency
Default Value: BI_HDR.CURRENCY_CD_XEU
|
| 19 |
AMOUNT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Amount
|
| 20 |
AMOUNT_BSE |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Amount
|
| 21 |
AMOUNT_XEU |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Amount
|
| 22 |
ADDRESS1 |
Character(55) |
VARCHAR2(55) NOT NULL |
Address 1
|
| 23 |
ADDRESS2 |
Character(55) |
VARCHAR2(55) NOT NULL |
Address 2
|
| 24 |
ADDRESS3 |
Character(55) |
VARCHAR2(55) NOT NULL |
Address 3
|
| 25 |
ADDRESS4 |
Character(55) |
VARCHAR2(55) NOT NULL |
Address 4
|
| 26 |
NUM1 |
Character(6) |
VARCHAR2(6) NOT NULL |
Number 1
|
| 27 |
NUM2 |
Character(6) |
VARCHAR2(6) NOT NULL |
Number 2
|
| 28 |
CITY |
Character(30) |
VARCHAR2(30) NOT NULL |
City
|
| 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 |
COUNTRY |
Character(3) |
VARCHAR2(3) NOT NULL |
Country
Default Value: INSTALLATION.COUNTRY
Prompt Table:
COUNTRY_TBL
|
| 34 |
PHONE |
Character(24) |
VARCHAR2(24) NOT NULL |
Telephone
|
| 35 |
EMAILID |
Character(70) |
VARCHAR2(70) NOT NULL |
A user's E-mail address
|
| 36 |
HOUSE_TYPE |
Character(2) |
VARCHAR2(2) NOT NULL |
House Type
AB=House Boat
WW=Trailer
|
| 37 |
ADDR_FIELD1 |
Character(2) |
VARCHAR2(2) NOT NULL |
Address Field 1
|
| 38 |
ADDR_FIELD2 |
Character(4) |
VARCHAR2(4) NOT NULL |
Address Field 2
|
| 39 |
ADDR_FIELD3 |
Character(4) |
VARCHAR2(4) NOT NULL |
Address Field 3
|
| 40 |
IN_CITY_LIMIT |
Character(1) |
VARCHAR2(1) NOT NULL |
In City Limit
Y/N Table Edit
|
| 41 |
CR_CARD_RQST_ID |
Character(30) |
VARCHAR2(30) NOT NULL |
Credit Card Request ID
|
| 42 |
CR_CARD_AUTH_STAT |
Character(1) |
VARCHAR2(1) NOT NULL |
Credit Card Auth Status
A=Authorized
B=Billed
C=Credited
D=Denied
E=Validation Errors
F=Auth Reversal
G=Validated
H=Auth Reversal Denied
J=Reauthorize
K=No Action
L=Credit Card Not In Group
M=Manually Approved/Settled
N=Change to Terms
P=Authorized and Billed
R=Processing
T=Cancel Order
U=Unprocessed/Retry
V=Pending Approval
W=Deleted after Settlement
X=Deleted
Y=Cancelled
Z=Zero Payment for Maintenance
Default Value: U
|
| 43 |
CR_CARD_AUTH_CD |
Character(10) |
VARCHAR2(10) NOT NULL |
Credit Card Auth Code
|
| 44 |
CR_CARD_A_DTTM |
Character(20) |
VARCHAR2(20) NOT NULL |
Cr Card Auth Date/Time
|
| 45 |
CR_CARD_AUTH_DTTM |
DateTime(26) |
TIMESTAMP |
Credit Card Auth Datetime
|
| 46 |
CR_CARD_MSG1 |
Character(50) |
VARCHAR2(50) NOT NULL |
Credit Card Message 1
|
| 47 |
CR_CARD_MSG2 |
Character(50) |
VARCHAR2(50) NOT NULL |
Credit Card Message 2
|
| 48 |
CR_CARD_MSG3 |
Character(50) |
VARCHAR2(50) NOT NULL |
Credit Card Message 3
|
| 49 |
CC_RQST_TOKEN |
Long Character(256) |
VARCHAR2(256) |
Request Token
|
| 50 |
ADD_DTTM |
DateTime(26) |
TIMESTAMP |
Date Time Added
|
| 51 |
LAST_UPDATE_DTTM |
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.
|
| 52 |
LAST_MAINT_OPRID |
Character(30) |
VARCHAR2(30) NOT NULL |
Last Maintained By Operator ID
|