EX_ACCTG_AET

(SQL Table)
Index Back

Expenses ACCTG Cache Record

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance
2 ADVANCE_ID Character(10) VARCHAR2(10) NOT NULL Advance ID
3 SHEET_ID Character(10) VARCHAR2(10) NOT NULL Report ID
4 LINE_NBR Number(5,0) INTEGER NOT NULL Line Number: 11/24/08 - Added TARGET label [PC product]
5 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
6 ACCOUNT Character(10) VARCHAR2(10) NOT NULL Account
7 ALTACCT Character(10) VARCHAR2(10) NOT NULL Alternate Account
8 DEPTID Character(10) VARCHAR2(10) NOT NULL Department
9 OPERATING_UNIT Character(8) VARCHAR2(8) NOT NULL Operating Unit ChartField

Prompt Table: OPERUNT_BUGL_VW

10 PRODUCT Character(6) VARCHAR2(6) NOT NULL Product ChartField

Prompt Table: PRODUCT_BUGL_VW

11 FUND_CODE Character(5) VARCHAR2(5) NOT NULL Fund Code

Prompt Table: FUND_BUGL_VW

12 CLASS_FLD Character(5) VARCHAR2(5) NOT NULL Class Field

Prompt Table: CLASSCF_BUGL_VW

13 PROGRAM_CODE Character(5) VARCHAR2(5) NOT NULL Program Code ChartField

Prompt Table: PROGRAM_BUGL_VW

14 BUDGET_REF Character(8) VARCHAR2(8) NOT NULL Budget Reference

Prompt Table: BUD_REF_BUGL_VW

15 AFFILIATE Character(5) VARCHAR2(5) NOT NULL Affiliate

Prompt Table: AFFILIATE_VW

16 AFFILIATE_INTRA1 Character(10) VARCHAR2(10) NOT NULL IntraUnit Affiliate1

Prompt Table: %EDIT_INTRA01

17 AFFILIATE_INTRA2 Character(10) VARCHAR2(10) NOT NULL Operating Unit Affiliate

Prompt Table: %EDIT_INTRA02

18 CHARTFIELD1 Character(10) VARCHAR2(10) NOT NULL Expansion chartfield 1

Prompt Table: CF1_BUGL_VW

19 CHARTFIELD2 Character(10) VARCHAR2(10) NOT NULL Expansion Chartfield 2

Prompt Table: CF2_BUGL_VW

20 CHARTFIELD3 Character(10) VARCHAR2(10) NOT NULL Expansion Chartfield 3

Prompt Table: CF3_BUGL_VW

21 PROJECT_ID Character(15) VARCHAR2(15) NOT NULL Project Id ChartField
22 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.
23 GROSS_UP_EST_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Gross Up Estimated Amount
24 AMOUNT Signed Number(28,3) DECIMAL(26,3) NOT NULL Amount
25 GROSS_UP_EST_PCT Number(7,4) DECIMAL(6,4) NOT NULL Gross Up Percent
26 TEMP_FLD Character(1) VARCHAR2(1) NOT NULL Temporary Field for App Engine
27 IU_SYS_TRAN_CD Character(8) VARCHAR2(8) NOT NULL System Transactions are delivered system data, representing the activities that can require interunit or intraunit accounting entries.
28 IU_TRAN_CD Character(8) VARCHAR2(8) NOT NULL Transaction Codes are user-defined. They are mapped to the delivered System Transactions. InterUnit and IntraUnit Templates are keyed by Transaction code, allowing users to vary their accounting by transaction.
29 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
30 GROSSUP Character(1) VARCHAR2(1) NOT NULL Gross Up Indicator
31 RECONCILE_DT Date(10) DATE The transaction reconciliation date.
32 SETID Character(5) VARCHAR2(5) NOT NULL SetID
33 ACTION_NAME Character(3) VARCHAR2(3) NOT NULL Action taken on a transaction
APR=Approved
AUT=Auto Approved
BUD=Budget Checked
DEL=Deleted
DNY=Denied
HLD=On Hold
PAS=Post Approval Submit
REC=Receipt Verified
RES=Resubmitted
REV=Reviewed
RSN=Reassigned
SBR=Sent Back For Revision
SUB=Submitted
WDR=Withdrawn
34 APPROVER_OPRID Character(30) VARCHAR2(30) NOT NULL Approver Oprid
35 DISTRIB_LINE_NUM Number(5,0) INTEGER NOT NULL Distribution Line
36 EX_DOC_ID Character(10) VARCHAR2(10) NOT NULL Documentation ID
37 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.
38 PAID_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Paid Amount
39 PAID_AMT_BNK_BSE Signed Number(28,3) DECIMAL(26,3) NOT NULL Paid Amount - Base Bank Unit
40 TXN_ID_TYPE Character(15) VARCHAR2(15) NOT NULL Transaction ID type
41 TXN_HDR_TB_NM Character(20) VARCHAR2(20) NOT NULL Transaction Header Table Name
42 DST_CNTRL_ID Character(10) VARCHAR2(10) NOT NULL Accounting Template