UPG_GL_SHPO_TMP

(SQL Table)
Index Back

KK Source Header TAO

KK Source Header TAO

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance
2 KK_TRAN_ID Character(10) VARCHAR2(10) NOT NULL Commitment Control Foreign Key for Transaction Identification.
3 KK_TRAN_DT Date(10) DATE Commitment Control Transaction Original processing date. Primary key with KK_TRAN_ID.
4 KK_SOURCE_TRAN Character(10) VARCHAR2(10) NOT NULL Source Transaction Type
5 SEQUENCE_NBR_9 Number(9,0) DECIMAL(9) NOT NULL Sequence
6 KK_PROCESS_STATUS Character(1) VARCHAR2(1) NOT NULL Process Status
E=Errors Exist
I=Document in process
N=Process Unsuccessful
P=Provisionally Valid
V=No Errors or Warnings
W=Only Warnings Exist
X=Unrecorded Errors Exist
7 KK_PROC_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance
8 KK_ROLLED Character(1) VARCHAR2(1) NOT NULL PO Rolled Flag

Default Value: N

9 ACCOUNTING_DT Date(10) DATE The accounting entry construction date for a given transaction (a generic field that crosses multiple
10 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
11 CC_GROUP_SEQ_NUM Number(6,0) INTEGER NOT NULL Group Sequency
12 CRDMEM_ACCT_NBR Character(44) VARCHAR2(44) NOT NULL Cardmember Number
13 CREDIT_CARD_VENDOR Character(5) VARCHAR2(5) NOT NULL Corporate Card Vendor
14 CUST_ID Character(15) VARCHAR2(15) NOT NULL Uniquely identifies an organizational entity that purchases goods or services from the enterprise. Represents the sold-to customer which is the customer organization that places orders. The CUST_ID may or may not be the same as the identifiers for the bill-to and ship-to locations.
15 DEPOSIT_BU Character(5) VARCHAR2(5) NOT NULL Identifies the business unit to which a deposit is posted.
16 DEPOSIT_ID Character(15) VARCHAR2(15) NOT NULL Uniquely identifies a deposit of customer payments. The deposit ID can be manually assigned or system-generated.
17 DT_TIMESTAMP DateTime(26) TIMESTAMP Date Timestamp
18 DTTM_STAMP 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.
19 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
20 INTFC_ID Number(8,0) INTEGER NOT NULL Interface ID
21 INV_ITEM_ID Character(18) VARCHAR2(18) NOT NULL Item ID
22 INVOICE Character(22) VARCHAR2(22) NOT NULL Invoice
23 ITEM Character(30) VARCHAR2(30) NOT NULL Uniquely identifies an invoice credit memo or debit memo. The item ID is also called the invoice number.
24 ITEM_LINE Number(6,0) INTEGER NOT NULL Item Line
25 ITEM_SEQ_NUM Number(3,0) SMALLINT NOT NULL Item Sequence Number
26 JOURNAL_DATE Date(10) DATE Specifies the date the journal was created.
27 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.
28 KK_AMOUNT_TYPE Character(1) VARCHAR2(1) NOT NULL Commitment Control Amount Type
0=Budget
1=Actuals and Recognized
2=Encumbrance
3=Pre-Encumbrance
4=Collected Revenue
5=Planned
7=Actuals, Recognize and Collect
9=Dynamic
29 KK_DISTRIB_STATUS Character(1) VARCHAR2(1) NOT NULL Commitment Control
B=Budget Check
C=Budget Create
D=Distributed
E=Posting Error
K=Post to Commitment control
N=None
S=Security Error
30 PAYMENT_SEQ_NUM Number(6,0) INTEGER NOT NULL Specifies the system-generated sequence number assigned to each payment as it is entered in a deposit.
31 PO_ID Character(10) VARCHAR2(10) NOT NULL Purchase Order
32 PROCESSINSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance
33 REQ_ID Character(10) VARCHAR2(10) NOT NULL Requisition ID
34 RUN_DT Date(10) DATE Run Date
35 RESOURCE_ID Character(40) VARCHAR2(40) NOT NULL Transaction ID
36 SEQ_NBR Number(15,0) DECIMAL(15) NOT NULL Sequence Number
37 SEQNUM Number(3,0) SMALLINT NOT NULL Sequence Number
38 SHEET_ID Character(10) VARCHAR2(10) NOT NULL Report ID
39 TRANS_DT Date(10) DATE Transaction Date
40 TRANS_NBR Character(24) VARCHAR2(24) NOT NULL Transaction Number
41 TRAVEL_AUTH_ID Character(10) VARCHAR2(10) NOT NULL Travel Authorization Identification. Number used to define travel authorizations. Key field on most travel authorization records and exists at level 0 for travel authorization panels.
42 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".
43 VOUCHER_ID Character(8) VARCHAR2(8) NOT NULL Voucher ID
44 RECEIVER_ID Character(10) VARCHAR2(10) NOT NULL Receiver number
45 RECV_LN_NBR Number(5,0) INTEGER NOT NULL Receipt Line
46 RECV_SHIP_SEQ_NBR Number(3,0) SMALLINT NOT NULL Receiver Shipping Sequence
47 DISTRIB_LINE_NUM Number(5,0) INTEGER NOT NULL Distribution Line
48 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
49 APPL_JRNL_ID Character(10) VARCHAR2(10) NOT NULL Journal Template
50 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.
51 FISCAL_YEAR Number(4,0) SMALLINT NOT NULL Fiscal Year
52 ORIGINAL_TRANS Character(1) VARCHAR2(1) NOT NULL Receipt Accrual Original Trans
53 SEQUENCENO Number(10,0) DECIMAL(10) NOT NULL Sequence Number
54 LINE_NBR Number(5,0) INTEGER NOT NULL Line Number: 11/24/08 - Added TARGET label [PC product]
55 PYMNT_CNT Number(5,0) INTEGER NOT NULL Payments
56 EX_DOC_ID Character(10) VARCHAR2(10) NOT NULL Documentation ID
57 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
58 ACTIVITY_ID Character(15) VARCHAR2(15) NOT NULL Activity ID
59 PROJECT_ID Character(15) VARCHAR2(15) NOT NULL Project Id ChartField
60 BUSINESS_UNIT_PC Character(5) VARCHAR2(5) NOT NULL PC Business Unit
61 KK_DATETIME_STAMP DateTime(26) TIMESTAMP DateTime Stamp
62 KEYLIST Character(254) VARCHAR2(254) NOT NULL KeyList