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 |