TL_DIST_DIL_AET

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	PROCESS_INSTANCE	Number(10,0)	DECIMAL(10) NOT NULL	Process Instance
2	PAY_SYSTEM	Character(4)	VARCHAR2(4) NOT NULL	Payroll System GP=Global Payroll NA=North American Payroll
3	LDILU_FLAG	Character(1)	VARCHAR2(1) NOT NULL	Labor Dilution Used
4	SEQ_NBR	Number(15,0)	DECIMAL(15) NOT NULL	Sequence Number
5	XREF_NUM	Number(15,0)	DECIMAL(15) NOT NULL	T&L Xref Num
6	CURRENCY_CD	Character(3)	VARCHAR2(3) NOT NULL	Currency Code
7	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID
8	EMPL_RCD	Number(3,0)	SMALLINT NOT NULL	Empl Rcd Nbr
9	DUR	Date(10)	DATE	Date Under Report associates time being reported, scheduled or paid, to a specific date.
10	TRC	Character(5)	VARCHAR2(5) NOT NULL	Time Reporting Code used to report time in Time and Labor
11	DIST_AMOUNT1	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	This field is used just to store amounts for labor distribution from one step to another.
12	DIST_AMOUNT2	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	This field is used just to store amounts for labor distribution from one step to another.
13	DIST_AMOUNT3	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	This field is used just to store amounts for labor distribution from one step to another.
14	EXIST	Character(1)	VARCHAR2(1) NOT NULL	Currency Exist
15	ITEMCOUNT	Number(4,0)	SMALLINT NOT NULL	Item Count
16	PROCESS_NAME	Character(12)	VARCHAR2(12) NOT NULL	Process Name
17	USE_CURRENT_DATE	Character(1)	VARCHAR2(1) NOT NULL	Use Current Date
18	ACCOUNTING_DT	Date(10)	DATE	Accounting Date
19	OPRID	Character(30)	VARCHAR2(30) NOT NULL	A user's ID (see PSOPRDEFN).
20	RUN_CNTL_ID	Character(30)	VARCHAR2(30) NOT NULL	Run Control ID
21	PAY_BEGIN_DT	Date(10)	DATE	Pay Period Begin Date
22	COMMIT_ACCTG_FLG	Character(1)	VARCHAR2(1) NOT NULL	Commitment Accounting
23	TL_IG_RP_PNA	Character(1)	VARCHAR2(1) NOT NULL	Ignore Payable time Rows for PNA
24	TL_PYBL_REASON_CD	Character(3)	VARCHAR2(3) NOT NULL	Payable Reason Code CAN=Cancelled CRV=Reversed MRJ=Manual Reject NDS=Not Distributed NOP=Not OK to Pay NSP=Not Sent to Payroll NUS=Not Used PNP=Not Processed in Payroll PPS=Prior Period Adjustment RAJ=Record Adjustment
25	PAYABLE_STATUS	Character(2)	VARCHAR2(2) NOT NULL	Payable Status AP=Approved CL=Closed DL=Diluted ES=Estimated IG=Ignore NA=Needs Approval NP=No Pay OE=Online Estimate PD=Distributed RP=Rejected by Payroll RV=Reversed Check SP=Sent to Payroll TP=Taken by Payroll
26	PAYROLL_REQ_NUM	Number(6,0)	INTEGER NOT NULL	Last payroll request number.
27	TL_QUANTITY4	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	TL_QUANTITY4
28	TL_QUANTITY3	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	TL_QUANTITY3