PROCESS_INSTANCEAP=Approved
CL=Closed
DL=Diluted
DN=Denied
ES=Estimated
IG=Ignore
NA=Needs Approval
NP=No Pay
OE=Online Estimate
PB=Pushed Back
PD=Distributed
RP=Rejected by Payroll
RV=Reversed Check
SP=Sent to Payroll
TP=Taken by Payroll
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 | PAYABLE_STATUS | Character(2) | VARCHAR2(2) NOT NULL |
Payable Status
AP=Approved CL=Closed DL=Diluted DN=Denied ES=Estimated IG=Ignore NA=Needs Approval NP=No Pay OE=Online Estimate PB=Pushed Back PD=Distributed RP=Rejected by Payroll RV=Reversed Check SP=Sent to Payroll TP=Taken by Payroll |