TRA_ENT_SUM_VW(SQL View) |
Index Back |
|---|---|
TRA Acctg Entry Summary ViewView of TRA_ACCTG_HDR and TRA_ACCTG_LINE for the Accounting Entry Summary Inquiry Panel. |
| SELECT A.BUSINESS_UNIT , A.ACCOUNTING_ID , B.ACCOUNTING_LINE , A.TRA_SOURCE_CD , A.EVENT_ID , A.ACCOUNTING_DT , A.ACCTG_STATUS , A.ACCTG_EVENT_TYPE , A.BANK_ACCOUNT_NUM , A.TRAN_REF_ID , B.BUSINESS_UNIT_GL , B.ACCOUNT , B.FOREIGN_AMOUNT , B.FOREIGN_CURRENCY , B.MONETARY_AMOUNT , B.CURRENCY_CD , A.PROCESS_INSTANCE , A.SEQ_NBR , A.BATCH_ID , A.INTEGRATION_STATUS FROM PS_TRA_ACCTG_HDR A , PS_TRA_ACCTG_LINE B WHERE A.BUSINESS_UNIT = B.BUSINESS_UNIT AND A.ACCOUNTING_ID = B.ACCOUNTING_ID |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  BUSINESS_UNIT |
Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
| 2 | ACCOUNTING_ID |
Character(10) | VARCHAR2(10) NOT NULL | Represents the unique alphanumeric identifier for treasury-specific accounting entries. |
| 3 | ACCOUNTING_LINE |
Number(5,0) | INTEGER NOT NULL | The specific unique numeric identifier that distinguishes debit and credits for a given treasury accounting ent |
| 4 | TRA_SOURCE_CD | Character(1) | VARCHAR2(1) NOT NULL |
Note: Changes to Translate Values must also be made to TR_SOURCE_CD and SOURCE_TYPE. These 3 fields must be kept in sync.
Values that are inactive are for use in TR Cash Flows only
B=BSP D=Deals E=Deal Fees F=Facility Fees H=Hedges I=Interest M=Deal: Estimated Maturity Accr N=Netted Deal O=Other P=Investment Pools R=EFT Fees S=Securities T=LC Fees W=EFT Requests X=Bank Transfers |
| 5 | EVENT_ID | Character(20) | VARCHAR2(20) NOT NULL | The unique key identifier that enumerates Treasury accounting events. Accounting events are transaction events that have been created by the Treasury sources (deals, fees, bank transfers, EFTs, etc). |
| 6 | ACCOUNTING_DT | Date(10) | DATE | The accounting entry construction date for a given transaction (a generic field that crosses multiple |
| 7 | ACCTG_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Indicates the state of a set of accounting entries.
C=Needs Correction E=Error F=Final P=Provisional |
| 8 | ACCTG_EVENT_TYPE | Character(2) | VARCHAR2(2) NOT NULL | Accounting types for deal capture and hedging |
| 9 | BANK_ACCOUNT_NUM | Character(35) | VARCHAR2(35) NOT NULL | The literal unique identifier associated with a given bank/counterparty account. |
| 10 | TRAN_REF_ID | Character(20) | VARCHAR2(20) NOT NULL | Represents the unique transaction identifier in bank reconciliation processing. |
| 11 | BUSINESS_UNIT_GL | Character(5) | VARCHAR2(5) NOT NULL | GL Business Unit |
| 12 | ACCOUNT | Character(10) | VARCHAR2(10) NOT NULL | Account |
| 13 | FOREIGN_AMOUNT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Specifies the monetary amount of a debit or credit (accounting entry line) in the entry currency of the item. The sum of FOREIGN_AMOUNT values on AR lines should equal the ENTRY_AMT on the pending item. |
| 14 | FOREIGN_CURRENCY | Character(3) | VARCHAR2(3) NOT NULL | Foreign Currency Code |
| 15 | 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. |
| 16 | CURRENCY_CD | Character(3) | VARCHAR2(3) NOT NULL | Currency Code |
| 17 | PROCESS_INSTANCE | Number(10,0) | DECIMAL(10) NOT NULL | Process Instance |
| 18 | SEQ_NBR | Number(15,0) | DECIMAL(15) NOT NULL | Sequence Number |
| 19 | BATCH_ID | Character(18) | VARCHAR2(18) NOT NULL | Batch ID |
| 20 | INTEGRATION_STATUS | Character(3) | VARCHAR2(3) NOT NULL |
Treasury integration status. Used to keep track of status for accounting entries that are passed to EnterpriseOne.
ERR=Error LOA=Loaded NA=Not Applicable PEN=Pending POS=Posted REC=Received SEN=Sent |