PC_PO_REV_TAO (SQL Table)	Index Back
KK Reversals for POADJUST Used during PC_POADJUST to store reversals from the commitment control tables KK_SOURCE_HDR, KK_SOURCE_LN, KK_LIQUIDATION.

PC_PO_REV_TAO

(SQL Table)

KK Reversals for POADJUST

Used during PC_POADJUST to store reversals from the commitment control tables KK_SOURCE_HDR, KK_SOURCE_LN, KK_LIQUIDATION.

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 KK_TRAN_ID Character(10) VARCHAR2(10) NOT NULL Commitment Control Foreign Key for Transaction Identification.

2 KK_TRAN_DT Date(10) DATE Commitment Control Transaction Original processing date. Primary key with KK_TRAN_ID.

3 KK_TRAN_LN Number(9,0) DECIMAL(9) NOT NULL Commitment Control Transaction Line number.

4 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance

5 KK_SOURCE_TRAN Character(10) VARCHAR2(10) NOT NULL Source Transaction Type

6 BUSINESS_UNIT_PO Character(5) VARCHAR2(5) NOT NULL PO Business Unit

7 PO_ID Character(10) VARCHAR2(10) NOT NULL Purchase Order

8 LINE_NBR Number(5,0) INTEGER NOT NULL Line Number: 11/24/08 - Added TARGET label [PC product]

9 SCHED_NBR Number(3,0) SMALLINT NOT NULL Schedule Number

10 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

11 DISTRIB_LINE_NUM Number(5,0) INTEGER NOT NULL Distribution Line

12 REQ_ID Character(10) VARCHAR2(10) NOT NULL Requisition ID

13 REQ_LINE_NBR Number(5,0) INTEGER NOT NULL Requisition Line Number

14 REQ_SCHED_NBR Number(3,0) SMALLINT NOT NULL Requisition Schedule Number

15 REQ_DISTRIB_NBR Number(5,0) INTEGER NOT NULL Requisition Distrib Number

16 PC_DISTRIB_STATUS Character(1) VARCHAR2(1) NOT NULL PC Distribution Status
B=Budget Check
D=Distributed
G=Generated
H=Hold
I=Ignore
M=Modified
N=Not Distributed
S=Staged

17 RESOURCE_QUANTITY Signed Number(16,2) DECIMAL(14,2) NOT NULL Quantity

18 FOREIGN_CURRENCY Character(3) VARCHAR2(3) NOT NULL Foreign Currency Code

19 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.

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	KK_TRAN_ID	Character(10)	VARCHAR2(10) NOT NULL	Commitment Control Foreign Key for Transaction Identification.
2	KK_TRAN_DT	Date(10)	DATE	Commitment Control Transaction Original processing date. Primary key with KK_TRAN_ID.
3	KK_TRAN_LN	Number(9,0)	DECIMAL(9) NOT NULL	Commitment Control Transaction Line number.
4	PROCESS_INSTANCE	Number(10,0)	DECIMAL(10) NOT NULL	Process Instance
5	KK_SOURCE_TRAN	Character(10)	VARCHAR2(10) NOT NULL	Source Transaction Type
6	BUSINESS_UNIT_PO	Character(5)	VARCHAR2(5) NOT NULL	PO Business Unit
7	PO_ID	Character(10)	VARCHAR2(10) NOT NULL	Purchase Order
8	LINE_NBR	Number(5,0)	INTEGER NOT NULL	Line Number: 11/24/08 - Added TARGET label [PC product]
9	SCHED_NBR	Number(3,0)	SMALLINT NOT NULL	Schedule Number
10	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
11	DISTRIB_LINE_NUM	Number(5,0)	INTEGER NOT NULL	Distribution Line
12	REQ_ID	Character(10)	VARCHAR2(10) NOT NULL	Requisition ID
13	REQ_LINE_NBR	Number(5,0)	INTEGER NOT NULL	Requisition Line Number
14	REQ_SCHED_NBR	Number(3,0)	SMALLINT NOT NULL	Requisition Schedule Number
15	REQ_DISTRIB_NBR	Number(5,0)	INTEGER NOT NULL	Requisition Distrib Number
16	PC_DISTRIB_STATUS	Character(1)	VARCHAR2(1) NOT NULL	PC Distribution Status B=Budget Check D=Distributed G=Generated H=Hold I=Ignore M=Modified N=Not Distributed S=Staged
17	RESOURCE_QUANTITY	Signed Number(16,2)	DECIMAL(14,2) NOT NULL	Quantity
18	FOREIGN_CURRENCY	Character(3)	VARCHAR2(3) NOT NULL	Foreign Currency Code
19	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.