EX_VAT2_VW(SQL View) |
Index Back |
---|---|
Expenses VAT 2 ViewExpenses VAT 2 View |
SELECT EX_DOC_ID , EX_DOC_TYPE , LINE_NBR , DISTRIB_LINE_NUM , DST_ACCT_TYPE , APPL_JRNL_ID , UNPOST_SEQ , ACCOUNTING_DT , DOC_TYPE , DOC_SEQ_NBR , DOC_SEQ_DATE , ACCOUNTING_PERIOD , BUSINESS_UNIT , BUSINESS_UNIT_GL , FISCAL_YEAR , JOURNAL_ID , JOURNAL_DATE , JOURNAL_LINE , GL_DISTRIB_STATUS , LEDGER_CATEGORY , LEDGER_GROUP , LEDGER , PROCESS_INSTANCE , MONETARY_AMOUNT , CURRENCY_CD , FOREIGN_AMOUNT , FOREIGN_CURRENCY , RATE_MULT , RATE_DIV , RT_TYPE , EMPLID , BI_DISTRIB_STATUS , ACCOUNT , ALTACCT , VAT_DISTRIB_STATUS FROM PS_EX_ACCTG_LINE |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | EX_DOC_ID | Character(10) | VARCHAR2(10) NOT NULL | Documentation ID |
2 | 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 |
3 | EX_LINE_NBR | Number(5,0) | INTEGER NOT NULL | Line Number |
4 | DISTRIB_LINE_NUM | Number(5,0) | INTEGER NOT NULL | Distribution Line |
5 | DST_ACCT_TYPE | Character(4) | VARCHAR2(4) NOT NULL | 07/20/04 st: added RCN for Advance Reconciliation 02/16/98 ebn CN#CM800-2.0 : Added for MISC type for Landed Cost Enhancement 11/11/99 llr: Added ADVP for Payables Advance Payment |
6 | APPL_JRNL_ID | Character(10) | VARCHAR2(10) NOT NULL | Journal Template |
7 | UNPOST_SEQ | Number(2,0) | SMALLINT NOT NULL | Identifies the sequence of journal entries when a journal is "unposted". When a journal is posted the UnPost Sequence is automatically set to "0". When a journal is unposted, a new reversing entry is automatically created with an UnPost Sequence of "1". |
8 | ACCOUNTING_DT | Date(10) | DATE | The accounting entry construction date for a given transaction (a generic field that crosses multiple |
9 | DOC_TYPE | Character(8) | VARCHAR2(8) NOT NULL | Specifies the business purpose of a financial transaction in countries that require all financial transactions to be tracked as "documents". A Document Type is associated with one and only one Journal Code. |
10 | DOC_SEQ_NBR | Character(12) | VARCHAR2(12) NOT NULL | Specifies the sequence number assigned to each financial transaction (a document). The sequence number may be manually entered or system-generated. |
11 | DOC_SEQ_DATE | Date(10) | DATE | Specifies the date that a document sequence number is assigned to a document or the date the document was created. |
12 | ACCOUNTING_PERIOD | Number(3,0) | SMALLINT NOT NULL | Identifies a time period to which you post transactions. Typically, an accounting period represents a month, but it can also represent a week, a day, or any user-defined interval. An accounting period has a beginning date and an ending date, and is defined in the calendar table. |
13 | BUSINESS_UNIT | Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
14 | BUSINESS_UNIT_GL | Character(5) | VARCHAR2(5) NOT NULL | GL Business Unit |
15 | FISCAL_YEAR | Number(4,0) | SMALLINT NOT NULL | Fiscal Year |
16 | JOURNAL_ID | Character(10) | VARCHAR2(10) NOT NULL | Identifies a journal entry, consisting of a header and one or more lines. The Journal ID itself does not have to be unique, but together with the journal business unit and journal date, it forms a unique journal identifier. |
17 | JOURNAL_DATE | Date(10) | DATE | Specifies the date the journal was created. |
18 | JOURNAL_LINE | Number(9,0) | DECIMAL(9) NOT NULL | Uniquely identifies a journal line with a sequence number. Within a single journal entry, the line sequence begins with 1 and automatically increments by 1 for each succeeding journal line. There can be any number of lines associated with a journal header. |
19 | GL_DISTRIB_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Distribution Status
C=Available to Contracts D=Distributed G=Generated H=Hold I=Ignored J=Creating Journals M=Modified N=None P=To be processed X=Waiting for Reversal Default Value: N |
20 | LEDGER_CATEGORY | Character(3) | VARCHAR2(3) NOT NULL | Ledger Category |
21 | LEDGER_GROUP | Character(10) | VARCHAR2(10) NOT NULL | Ledger Group |
22 | LEDGER | Character(10) | VARCHAR2(10) NOT NULL | Ledger |
23 | PROCESS_INSTANCE | Number(10,0) | DECIMAL(10) NOT NULL | Process Instance |
24 | 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. |
25 | CURRENCY_CD | Character(3) | VARCHAR2(3) NOT NULL |
Currency Code
Prompt Table: CURRENCY_CD_TBL |
26 | 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. |
27 | FOREIGN_CURRENCY | Character(3) | VARCHAR2(3) NOT NULL |
Foreign Currency Code
Prompt Table: CURRENCY_CD_TBL |
28 | RATE_MULT | Signed Number(17,8) | DECIMAL(15,8) NOT NULL | Rate Multiplier |
29 | RATE_DIV | Number(16,8) | DECIMAL(15,8) NOT NULL | Rate Divisor |
30 | RT_TYPE | Character(5) | VARCHAR2(5) NOT NULL | Defines a category of market rates for currency conversion. Some examples of rate types are commercial, average, floating, and historical. |
31 | EMPLID | Character(11) | VARCHAR2(11) NOT NULL | Employee ID |
32 | BI_DISTRIB_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Billing Distribution Status
D=Distributed I=Ignore N=Not Distributed P=Priced U=Unbillable/Non-billable W=Billing Worksheet |
33 | ACCOUNT | Character(10) | VARCHAR2(10) NOT NULL | Account |
34 | ALTACCT | Character(10) | VARCHAR2(10) NOT NULL | Alternate Account |
35 | VAT_DISTRIB_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
VAT Distribution Status
D=Distributed E=Error Flag I=Ignored M=Archival Entry N=Not Distributed P=Processed R=Reversal Entry U=Undefined |