TL_TA001100_AET(SQL Table) |
Index Back |
|---|---|
State Record for Payable Time |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | 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 |