CC_TRANS_AET(SQL Table) |
Index Back |
|---|---|
ProCard AE Process Cache Rec |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  PROCESS_INSTANCE |
Number(10,0) | DECIMAL(10) NOT NULL | Process Instance |
| 2 | OPRID | Character(30) | VARCHAR2(30) NOT NULL | A user's ID (see PSOPRDEFN). |
| 3 | RUN_CNTL_ID | Character(30) | VARCHAR2(30) NOT NULL | Run Control ID |
| 4 | BUSINESS_UNIT | Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
| 5 | BILLING_DATE | Date(10) | DATE | Billing Date |
| 6 | 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. |
| 7 | SETID | Character(5) | VARCHAR2(5) NOT NULL | SetID |
| 8 | DST_CNTRL_ID | Character(10) | VARCHAR2(10) NOT NULL | Accounting Template |
| 9 | DTTM_STAMP | 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. |
| 10 | CREDIT_CARD_VENDOR | Character(5) | VARCHAR2(5) NOT NULL | Corporate Card Vendor |
| 11 | INCLUDE_TAX | Character(1) | VARCHAR2(1) NOT NULL | Bill Includes Tax if Applied |
| 12 | DELETE_FLG | Character(1) | VARCHAR2(1) NOT NULL | Delete Loaded Items |
| 13 | BANK_CD | Character(5) | VARCHAR2(5) NOT NULL | Bank Code |
| 14 | BANK_ACCT_KEY | Character(4) | VARCHAR2(4) NOT NULL | A user defined unique identifier that facilitates the identification of a given account with a given bank |
| 15 | PROCARD_PYMNT_ID | Character(10) | VARCHAR2(10) NOT NULL | Procard Payment ID |
| 16 | PAY_DOC_SEQ | Number(5,0) | INTEGER NOT NULL | Advice Sequence |
| 17 | VENDOR_ID | Character(10) | VARCHAR2(10) NOT NULL | Vendor Identifier |
| 18 | EMPLID | Character(11) | VARCHAR2(11) NOT NULL | Employee ID |
| 19 | TRANS_NBR | Character(24) | VARCHAR2(24) NOT NULL | Transaction Number |
| 20 | CRDMEM_ACCT_NBR | Character(44) | VARCHAR2(44) NOT NULL | Cardmember Number |
| 21 | PREFERRED_LANGUAGE | Character(3) | VARCHAR2(3) NOT NULL |
Preferred Language
ARA=Arabic CFR=Canadian French CZE=Czech DAN=Danish DUT=Dutch E=English ENG=English ESP=Spanish F=French FIN=Finnish FRA=French GER=German HUN=Hungarian INE=International English ITA=Italian JPN=Japanese KOR=Korean NOR=Norwegian POL=Polish POR=Portuguese RUS=Russian SVE=Swedish THA=Thai UKE=UK English ZHS=Simplified Chinese ZHT=Traditional Chinese |
| 22 | CC_RECNAME | Character(18) | VARCHAR2(18) NOT NULL | CC Record Name |
| 23 | CC_RECNAME2 | Character(18) | VARCHAR2(18) NOT NULL | CC Record Name 2 |