EX_CC_TRANS(SQL Table) |
Index Back |
|---|---|
Expense Credit Card LoadThis record contains Credit Card data loaded from a data file. |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | ECFILEROWID | Character(3) | VARCHAR2(3) NOT NULL | Electronic Commerce File Row ID. Used in EDI Manager. There must be one work record for every PeopleSoft Business Document file. The first field in the record is the Record_Id and the rest of the fields must match the corresponding business document, in the same order and length. |
| 2 | EMPLID | Character(11) | VARCHAR2(11) NOT NULL |
Employee ID
Prompt Table: PERSONAL_DATA |
| 3 | TRANS_NBR | Character(24) | VARCHAR2(24) NOT NULL | Transaction Number |
| 4 | SHEET_ID | Character(10) | VARCHAR2(10) NOT NULL | Report ID |
| 5 | EXPENSE_TYPE | Character(7) | VARCHAR2(7) NOT NULL | Expense Type |
| 6 | RECEIPT_VERIFIED | Character(1) | VARCHAR2(1) NOT NULL | Receipt Verified |
| 7 | TRANS_DT | Date(10) | DATE | Transaction Date |
| 8 | TXN_AMOUNT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Transaction Amount |
| 9 | TXN_CURRENCY_CD | Character(3) | VARCHAR2(3) NOT NULL |
Transaction Currency
Prompt Table: CURRENCY_CD_TBL |
| 10 | MONETARY_AMOUNT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Specifies the monetary amount of a debit or credit in the business unit base currency. Debit entries are positive and credit entries are negative. This amount is only zero if associated with a statistical account. |
| 11 | CURRENCY_CD | Character(3) | VARCHAR2(3) NOT NULL |
Currency Code
Prompt Table: CURRENCY_CD_TBL |
| 12 | CUR_EXCHNG_RT | Number(16,8) | DECIMAL(15,8) NOT NULL | Currency Exchange Rate |
| 13 | CITY | Character(30) | VARCHAR2(30) NOT NULL | City |
| 14 | COUNTRY | Character(3) | VARCHAR2(3) NOT NULL | Country |
| 15 | EXPEND_MTHD | Character(3) | VARCHAR2(3) NOT NULL | Payment Type |
| 16 | MERCHANT | Character(40) | VARCHAR2(40) NOT NULL | Merchant |
| 17 | DESCR60 | Character(60) | VARCHAR2(60) NOT NULL | Description |
| 18 | CORP_ACCT_NBR | Character(20) | VARCHAR2(20) NOT NULL | Corporate Number |
| 19 | CRDMEM_ACCT_NBR | Character(44) | VARCHAR2(44) NOT NULL | Cardmember Number |
| 20 | SSN | Character(9) | VARCHAR2(9) NOT NULL | Social Security # |
| 21 | SUPPLIER_NBR | Character(11) | VARCHAR2(11) NOT NULL | Supplier Reference Nbr |
| 22 | TXN_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Transaction Status
A=Assigned D=Marked for Delete R=Rejected T=All Transaction Statuses U=Unassigned |
| 23 | DESCR_LN1 | Character(50) | VARCHAR2(50) NOT NULL | Description Line 1 |
| 24 | DESCR_LN2 | Character(50) | VARCHAR2(50) NOT NULL | Description Line 2 |
| 25 | DESCR_LN3 | Character(50) | VARCHAR2(50) NOT NULL | Description Line 3 |
| 26 | DESCR_LN4 | Character(50) | VARCHAR2(50) NOT NULL | Description Line 4 |