BI_HDR_CC_TEO1(SQL Table) |
Index Back |
|---|---|
CCU TEO temp tableCCU temporary table for BI_HDR_CRCARD |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | EO_PROCESS_INST | Number(10,0) | DECIMAL(10) NOT NULL | Process Instance |
| 2 | BUSINESS_UNIT | Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
| 3 | INVOICE | Character(22) | VARCHAR2(22) NOT NULL | Invoice |
| 4 | SEQ_NUM | Number(3,0) | SMALLINT NOT NULL |
Sequence
Default Value: 1 |
| 5 | 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 |
| 6 | CR_CARD_VENDOR | Character(16) | VARCHAR2(16) NOT NULL | Processor Name |
| 7 | CC_PROF_TOKEN | Character(44) | VARCHAR2(44) NOT NULL | Profile Token ID |
| 8 | CR_CARD_NBR | Character(44) | VARCHAR2(44) NOT NULL | "See OM |
| 9 | CR_CARD_LNAME | Character(40) | VARCHAR2(40) NOT NULL | Credit Card Last Name |
| 10 | CR_CARD_FNAME | Character(40) | VARCHAR2(40) NOT NULL | Credit Card First Name |
| 11 | 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 |
| 12 | 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 |
| 13 | CR_CARD_DIGITS | Character(4) | VARCHAR2(4) NOT NULL | Card Number's Last Four Digits |
| 14 | CR_CARD_CVNUM | Character(44) | VARCHAR2(44) NOT NULL | Card Verification Number |
| 15 | NAME_EXACT | Character(40) | VARCHAR2(40) NOT NULL | Exact Name on Card |
| 16 | EXPIRATION_DT | Date(10) | DATE | Expiration Date |
| 17 | BI_CURRENCY_CD | Character(3) | VARCHAR2(3) NOT NULL |
Billing Currency Code
Default Value: BI_HDR.BI_CURRENCY_CD |
| 18 | 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 |
| 19 | CURRENCY_CD_XEU | Character(3) | VARCHAR2(3) NOT NULL |
Euro Currency
Default Value: BI_HDR.CURRENCY_CD_XEU |
| 20 | AMOUNT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Amount |
| 21 | AMOUNT_BSE | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Amount |
| 22 | AMOUNT_XEU | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Amount |
| 23 | ADDRESS1 | Character(55) | VARCHAR2(55) NOT NULL | Address 1 |
| 24 | ADDRESS2 | Character(55) | VARCHAR2(55) NOT NULL | Address 2 |
| 25 | ADDRESS3 | Character(55) | VARCHAR2(55) NOT NULL | Address 3 |
| 26 | ADDRESS4 | Character(55) | VARCHAR2(55) NOT NULL | Address 4 |
| 27 | NUM1 | Character(6) | VARCHAR2(6) NOT NULL | Number 1 |
| 28 | NUM2 | Character(6) | VARCHAR2(6) NOT NULL | Number 2 |
| 29 | CITY | Character(30) | VARCHAR2(30) NOT NULL | City |
| 30 | COUNTY | Character(30) | VARCHAR2(30) NOT NULL | County |
| 31 | STATE | Character(6) | VARCHAR2(6) NOT NULL | State |
| 32 | POSTAL | Character(12) | VARCHAR2(12) NOT NULL | Postal |
| 33 | GEO_CODE | Character(11) | VARCHAR2(11) NOT NULL | Geo Code |
| 34 | COUNTRY | Character(3) | VARCHAR2(3) NOT NULL | Country |
| 35 | PHONE | Character(24) | VARCHAR2(24) NOT NULL | Telephone |
| 36 | EMAILID | Character(70) | VARCHAR2(70) NOT NULL | A user's E-mail address |
| 37 | HOUSE_TYPE | Character(2) | VARCHAR2(2) NOT NULL |
House Type
AB=House Boat WW=Trailer |
| 38 | ADDR_FIELD1 | Character(2) | VARCHAR2(2) NOT NULL | Address Field 1 |
| 39 | ADDR_FIELD2 | Character(4) | VARCHAR2(4) NOT NULL | Address Field 2 |
| 40 | ADDR_FIELD3 | Character(4) | VARCHAR2(4) NOT NULL | Address Field 3 |
| 41 | IN_CITY_LIMIT | Character(1) | VARCHAR2(1) NOT NULL | In City Limit |
| 42 | CR_CARD_RQST_ID | Character(30) | VARCHAR2(30) NOT NULL | Credit Card Request ID |
| 43 | 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: P |
| 44 | CR_CARD_AUTH_CD | Character(10) | VARCHAR2(10) NOT NULL | Credit Card Auth Code |
| 45 | CR_CARD_A_DTTM | Character(20) | VARCHAR2(20) NOT NULL | Cr Card Auth Date/Time |
| 46 | CR_CARD_AUTH_DTTM | DateTime(26) | TIMESTAMP | Credit Card Auth Datetime |
| 47 | CR_CARD_MSG1 | Character(50) | VARCHAR2(50) NOT NULL | Credit Card Message 1 |
| 48 | CR_CARD_MSG2 | Character(50) | VARCHAR2(50) NOT NULL | Credit Card Message 2 |
| 49 | CR_CARD_MSG3 | Character(50) | VARCHAR2(50) NOT NULL | Credit Card Message 3 |
| 50 | CC_RQST_TOKEN | Long Character(256) | VARCHAR2(256) | Request Token |
| 51 | ADD_DTTM | DateTime(26) | TIMESTAMP | Date Time Added |
| 52 | 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. |
| 53 | LAST_MAINT_OPRID | Character(30) | VARCHAR2(30) NOT NULL | Last Maintained By Operator ID |
| 54 | EO_FROM_CURRENCY | Character(3) | VARCHAR2(3) NOT NULL | Currency Code |