|
SELECT B.KK_SOURCE_TRAN , A.KK_TRAN_ID , A.KK_TRAN_DT , A.KK_TRAN_LN , A.LEDGER_GROUP , A.LEDGER , A.BUSINESS_UNIT , B.BUSINESS_UNIT , %subrec(KK_SHN_KEY_SBR3, B) , A.ACCOUNT , A.DEPTID , %subrec(CF12_AN_SBR, A) , %subrec(CFCC1_AN_SBR, A) , A.FISCAL_YEAR , A.ACCOUNTING_PERIOD , A.ACCOUNTING_DT , A.FOREIGN_CURRENCY , A.FOREIGN_AMOUNT , A.BASE_CURRENCY , A.MONETARY_AMOUNT , A.KK_QUANTITY , B.KK_PROCESS_STATUS , B.KK_PROC_INSTANCE , A.STATISTICS_CODE , A.STATISTIC_AMOUNT , A.ENTRY_EVENT , A.EE_PROC_STATUS , A.KK_BUDG_TRANS_TYPE , A.KK_GEN_PARENT , A.KK_AUTO_GEN , A.REFERENCED_BUDGET FROM PS_KK_ACTIVITY_LOG A ,PS_KK_SOURCE_HDR B WHERE A.BALANCING_LINE = 'N' AND A.KK_TRAN_ID = B.KK_TRAN_ID AND A.KK_TRAN_DT = B.KK_TRAN_DT
|
| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 KK_SOURCE_TRAN |
Character(10) |
VARCHAR2(10) NOT NULL |
Source Transaction Type
|
| 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_TRAN_LN |
Number(9,0) |
DECIMAL(9) NOT NULL |
Commitment Control Transaction Line number.
|
| 5 |
LEDGER_GROUP |
Character(10) |
VARCHAR2(10) NOT NULL |
Ledger Group
|
| 6 |
LEDGER |
Character(10) |
VARCHAR2(10) NOT NULL |
Ledger
|
| 7 |
BUSINESS_UNIT |
Character(5) |
VARCHAR2(5) NOT NULL |
Business Unit
|
| 8 |
BUSINESS_UNIT_APPL |
Character(5) |
VARCHAR2(5) NOT NULL |
Application Business Unit
used in KK
|
| 9 |
ACCOUNTING_DT |
Date(10) |
DATE |
The accounting entry construction date for a given transaction (a generic field that crosses multiple
|
| 10 |
CC_GROUP_SEQ_NUM |
Number(6,0) |
INTEGER NOT NULL |
Group Sequency
|
| 11 |
CRDMEM_ACCT_NBR |
Character(44) |
VARCHAR2(44) NOT NULL |
Cardmember Number
|
| 12 |
CREDIT_CARD_VENDOR |
Character(5) |
VARCHAR2(5) NOT NULL |
Corporate Card Vendor
|
| 13 |
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.
|
| 14 |
DEPOSIT_BU |
Character(5) |
VARCHAR2(5) NOT NULL |
Identifies the business unit to which a deposit is posted.
|
| 15 |
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.
|
| 16 |
DT_TIMESTAMP |
DateTime(26) |
TIMESTAMP |
Date Timestamp
|
| 17 |
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.
|
| 18 |
EMPLID |
Character(11) |
VARCHAR2(11) NOT NULL |
Employee ID
|
| 19 |
INTFC_ID |
Number(8,0) |
INTEGER NOT NULL |
Interface ID
|
| 20 |
INV_ITEM_ID |
Character(18) |
VARCHAR2(18) NOT NULL |
Item ID
|
| 21 |
INVOICE |
Character(22) |
VARCHAR2(22) NOT NULL |
Invoice
|
| 22 |
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.
|
| 23 |
ITEM_LINE |
Number(6,0) |
INTEGER NOT NULL |
Item Line
|
| 24 |
ITEM_SEQ_NUM |
Number(3,0) |
SMALLINT NOT NULL |
Item Sequence Number
|
| 25 |
JOURNAL_DATE |
Date(10) |
DATE |
Specifies the date the journal was created.
|
| 26 |
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.
|
| 27 |
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
|
| 28 |
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
|
| 29 |
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.
|
| 30 |
PO_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Purchase Order
|
| 31 |
PROCESS_INSTANCE |
Number(10,0) |
DECIMAL(10) NOT NULL |
Process Instance
|
| 32 |
REQ_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Requisition ID
|
| 33 |
RUN_DT |
Date(10) |
DATE |
Run Date
|
| 34 |
RESOURCE_ID |
Character(40) |
VARCHAR2(40) NOT NULL |
Transaction ID
|
| 35 |
SEQ_NBR |
Number(15,0) |
DECIMAL(15) NOT NULL |
Sequence Number
|
| 36 |
SEQNUM |
Number(3,0) |
SMALLINT NOT NULL |
Sequence Number
|
| 37 |
SHEET_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Report ID
|
| 38 |
TRANS_DT |
Date(10) |
DATE |
Transaction Date
|
| 39 |
TRANS_NBR |
Character(24) |
VARCHAR2(24) NOT NULL |
Transaction Number
|
| 40 |
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.
|
| 41 |
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".
|
| 42 |
VOUCHER_ID |
Character(8) |
VARCHAR2(8) NOT NULL |
Voucher ID
|
| 43 |
RECEIVER_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Receiver number
|
| 44 |
RECV_LN_NBR |
Number(5,0) |
INTEGER NOT NULL |
Receipt Line
|
| 45 |
RECV_SHIP_SEQ_NBR |
Number(3,0) |
SMALLINT NOT NULL |
Receiver Shipping Sequence
|
| 46 |
DISTRIB_LINE_NUM |
Number(5,0) |
INTEGER NOT NULL |
Distribution Line
|
| 47 |
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
|
| 48 |
APPL_JRNL_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Journal Template
|
| 49 |
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.
|
| 50 |
FISCAL_YEAR |
Number(4,0) |
SMALLINT NOT NULL |
Fiscal Year
|
| 51 |
ORIGINAL_TRANS |
Character(1) |
VARCHAR2(1) NOT NULL |
Receipt Accrual Original Trans
|
| 52 |
SEQUENCENO |
Number(10,0) |
DECIMAL(10) NOT NULL |
Sequence Number
|
| 53 |
LINE_NBR |
Number(5,0) |
INTEGER NOT NULL |
Line Number:
11/24/08 - Added TARGET label [PC product]
|
| 54 |
EX_DOC_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Documentation ID
|
| 55 |
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
|
| 56 |
HYP_TRAN_ID |
Character(44) |
VARCHAR2(44) NOT NULL |
Commitment Control Foreign Key for Transaction Identification.
|
| 57 |
HP_KK_DOC_ID |
Number(31,0) |
DECIMAL(31) NOT NULL |
Commitment Control Document ID
|
| 58 |
HP_FISCAL_YEAR |
Number(4,0) |
SMALLINT NOT NULL |
Fiscal Year when there is more than one occurence on a record
|
| 59 |
HP_BUDGET_YEAR |
Number(4,0) |
SMALLINT NOT NULL |
Budget Year for Commitment Control
|
| 60 |
ACCOUNT |
Character(10) |
VARCHAR2(10) NOT NULL |
Account
|
| 61 |
DEPTID |
Character(10) |
VARCHAR2(10) NOT NULL |
Department
|
| 62 |
OPERATING_UNIT |
Character(8) |
VARCHAR2(8) NOT NULL |
Operating Unit ChartField
|
| 63 |
PRODUCT |
Character(6) |
VARCHAR2(6) NOT NULL |
Product ChartField
|
| 64 |
FUND_CODE |
Character(5) |
VARCHAR2(5) NOT NULL |
Fund Code
|
| 65 |
CLASS_FLD |
Character(5) |
VARCHAR2(5) NOT NULL |
Class Field
|
| 66 |
PROGRAM_CODE |
Character(5) |
VARCHAR2(5) NOT NULL |
Program Code ChartField
|
| 67 |
BUDGET_REF |
Character(8) |
VARCHAR2(8) NOT NULL |
Budget Reference
|
| 68 |
AFFILIATE |
Character(5) |
VARCHAR2(5) NOT NULL |
Affiliate
|
| 69 |
AFFILIATE_INTRA1 |
Character(10) |
VARCHAR2(10) NOT NULL |
IntraUnit Affiliate1
|
| 70 |
AFFILIATE_INTRA2 |
Character(10) |
VARCHAR2(10) NOT NULL |
Operating Unit Affiliate
|
| 71 |
CHARTFIELD1 |
Character(10) |
VARCHAR2(10) NOT NULL |
Expansion chartfield 1
|
| 72 |
CHARTFIELD2 |
Character(10) |
VARCHAR2(10) NOT NULL |
Expansion Chartfield 2
|
| 73 |
CHARTFIELD3 |
Character(10) |
VARCHAR2(10) NOT NULL |
Expansion Chartfield 3
|
| 74 |
BUSINESS_UNIT_PC |
Character(5) |
VARCHAR2(5) NOT NULL |
PC Business Unit
|
| 75 |
PROJECT_ID |
Character(15) |
VARCHAR2(15) NOT NULL |
Project Id ChartField
|
| 76 |
ACTIVITY_ID |
Character(15) |
VARCHAR2(15) NOT NULL |
Activity ID
|
| 77 |
RESOURCE_TYPE |
Character(5) |
VARCHAR2(5) NOT NULL |
Source Type
|
| 78 |
BUDGET_PERIOD |
Character(8) |
VARCHAR2(8) NOT NULL |
Budget Period
|
| 79 |
FISCAL_YEAR_GL |
Number(4,0) |
SMALLINT NOT NULL |
Fiscal Year - USED IN KK ACT LOG INQUIRY
|
| 80 |
ACCTING_PERIOD_GL |
Number(3,0) |
SMALLINT NOT NULL |
Used in KK Act Log Inquiry
|
| 81 |
ACCOUNTING_DT_AP |
Date(10) |
DATE |
Accounting Date
|
| 82 |
FOREIGN_CURRENCY |
Character(3) |
VARCHAR2(3) NOT NULL |
Foreign Currency Code
|
| 83 |
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.
|
| 84 |
BASE_CURRENCY |
Character(3) |
VARCHAR2(3) NOT NULL |
"Specifies the primary currency for a general ledger business unit, and is sometimes referred to as the ""book"" currency. Each business unit has one base currency. which is usually, but not always, the local currency for the organization. Journal entries are posted to a business unit in its base currency. "
|
| 85 |
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.
|
| 86 |
KK_QUANTITY |
Signed Number(20,4) |
DECIMAL(18,4) NOT NULL |
Commitment Control Quantity
|
| 87 |
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
|
| 88 |
KK_PROC_INSTANCE |
Number(10,0) |
DECIMAL(10) NOT NULL |
Process Instance
|
| 89 |
STATISTICS_CODE |
Character(3) |
VARCHAR2(3) NOT NULL |
Statistics Code
|
| 90 |
STATISTIC_AMOUNT |
Signed Number(17,2) |
DECIMAL(15,2) NOT NULL |
Specifies the amount associated with a statistical account on a journal line or a distribution line. It represents a quantity rather than a monetary amount and is qualified by the Unit of Measure associated with the STATISTICS_CODE or statistics ACCOUNT.
|
| 91 |
ENTRY_EVENT |
Character(10) |
VARCHAR2(10) NOT NULL |
Entry Event
|
| 92 |
EE_PROC_STATUS |
Character(1) |
VARCHAR2(1) NOT NULL |
Entry Event Line Status
|
| 93 |
KK_BUDG_TRANS_TYPE |
Character(1) |
VARCHAR2(1) NOT NULL |
Budget Entry Type
0=Original
1=Adjustment
2=Transfer Adjustment
3=Transfer Original
4=Closing
5=Roll Forward
|
| 94 |
KK_GEN_PARENT |
Character(1) |
VARCHAR2(1) NOT NULL |
Yes/No Indicator - Generate Parent Budgets
|
| 95 |
KK_AUTO_GEN |
Character(1) |
VARCHAR2(1) NOT NULL |
Budget Processor Generated Ln
|
| 96 |
REFERENCED_BUDGET |
Character(1) |
VARCHAR2(1) NOT NULL |
Referenced Budget
|