PC_INTF_TRX_TAO(SQL Table) |
Index Back |
|---|---|
Interface Threshold Summary |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  PROCESS_INSTANCE |
Number(10,0) | DECIMAL(10) NOT NULL | Process Instance |
| 2 | ANALYSIS_TYPE |
Character(3) | VARCHAR2(3) NOT NULL | Analysis Type |
| 3 | BUSINESS_UNIT |
Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
| 4 | PROJECT_ID |
Character(15) | VARCHAR2(15) NOT NULL | Project Id ChartField |
| 5 | ACTIVITY_ID |
Character(15) | VARCHAR2(15) NOT NULL | Activity ID |
| 6 | ACCOUNTING_DT |
Date(10) | DATE | The accounting entry construction date for a given transaction (a generic field that crosses multiple |
| 7 | BUSINESS_UNIT_AP |
Character(5) | VARCHAR2(5) NOT NULL | AP Business Unit |
| 8 | VOUCHER_ID |
Character(8) | VARCHAR2(8) NOT NULL | Voucher ID |
| 9 | BUSINESS_UNIT_PO |
Character(5) | VARCHAR2(5) NOT NULL | PO Business Unit |
| 10 | REQ_ID |
Character(10) | VARCHAR2(10) NOT NULL | Requisition ID |
| 11 | PO_ID |
Character(10) | VARCHAR2(10) NOT NULL | Purchase Order |
| 12 | BUSINESS_UNIT_IN |
Character(5) | VARCHAR2(5) NOT NULL | Inventory Unit |
| 13 | TRANSACTION_GROUP |
Character(3) | VARCHAR2(3) NOT NULL | 11/7/02 LLR - Added the new (600's) transactions groups for 8.8. |
| 14 | EX_DOC_ID |
Character(10) | VARCHAR2(10) NOT NULL | Documentation ID |
| 15 | EX_DOC_TYPE |
Character(1) | VARCHAR2(1) NOT NULL |
Identifies Expenses Document Type
A=Cash Advance C=Time Report J=Time Adjustment M=Accrual - My Wallet R=Accrual - Expense Report S=Expense Report T=Travel Authorization |
| 16 | AMOUNT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Amount |
| 17 | CURRENCY_CD | Character(3) | VARCHAR2(3) NOT NULL | Currency Code |
| 18 | PC_PROJECT_FLG | Character(1) | VARCHAR2(1) NOT NULL |
Project Flag
I=Invalid P=Pending V=Valid X=Doc Partially Valid |
| 19 | PC_ACTIVITY_FLG | Character(1) | VARCHAR2(1) NOT NULL |
Activity Flag
I=Invalid P=Pending V=Valid X=Doc Partially Valid |