TL_TA001100_AET

(SQL Table)
Index Back

State Record for Payable Time

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance
2 SEQ_NBR Number(15,0) DECIMAL(15) NOT NULL Sequence Number
3 RECNAME_1 Character(15) VARCHAR2(15) NOT NULL Record 1 Name
4 RECNAME_2 Character(15) VARCHAR2(15) NOT NULL Record 2 Name
5 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
6 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