UPG_EE_POACG_LN

(SQL Table)
Index Back

PO Acctg Entry Table

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
2 PO_ID Character(10) VARCHAR2(10) NOT NULL Purchase Order
3 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".
4 APPL_JRNL_ID Character(10) VARCHAR2(10) NOT NULL Journal Template
5 LINE_NBR Number(5,0) INTEGER NOT NULL Line Number: 11/24/08 - Added TARGET label [PC product]
6 SCHED_NBR Number(3,0) SMALLINT NOT NULL Schedule Number
7 DISTRIB_LINE_NUM Number(5,0) INTEGER NOT NULL Distribution Line
8 MOD_SEQ_NBR Number(3,0) SMALLINT NOT NULL Modification Sequence Nbr
9 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
10 VOUCHER_ID Character(8) VARCHAR2(8) NOT NULL Voucher ID
11 EE_EVENT_STEP Character(10) VARCHAR2(10) NOT NULL Entry Event Step
12 KK_TRAN_ID Character(10) VARCHAR2(10) NOT NULL Commitment Control Foreign Key for Transaction Identification.
13 KK_TRAN_DT Date(10) DATE Commitment Control Transaction Original processing date. Primary key with KK_TRAN_ID.
14 KK_TRAN_LN Number(9,0) DECIMAL(9) NOT NULL Commitment Control Transaction Line number.
15 RVRSL_FLG Character(1) VARCHAR2(1) NOT NULL Commitment Control Reversal Flag

Y/N Table Edit

16 SEQNBR Number(5,0) INTEGER NOT NULL Sequence Number

Default Value: 0

17 BALANCING_LINE Character(1) VARCHAR2(1) NOT NULL Balancing Line
18 REFERENCED_BUDGET Character(1) VARCHAR2(1) NOT NULL Referenced Budget
19 CLOSED_VALUE Character(1) VARCHAR2(1) NOT NULL Closed Status field value
20 EVENT_LINE Number(5,0) INTEGER NOT NULL Entry Event Line Number
21 ACCOUNTING_DT Date(10) DATE The accounting entry construction date for a given transaction (a generic field that crosses multiple
22 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.
23 FISCAL_YEAR Number(4,0) SMALLINT NOT NULL Fiscal Year
24 ENTRY_EVENT Character(10) VARCHAR2(10) NOT NULL Entry Event
25 MONETARY_AMOUNT3 Signed Number(28,3) DECIMAL(26,3) NOT NULL Monetary Amount 3
26 FOREIGN_AMOUNT3 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 DTTM_STAMP_SEC DateTime(26) TIMESTAMP Specifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.

Default Value: %Datetime