SCE_IDSCE_DEPLOY_REQ_IDRTBL_ELEMENT_TYPEA=Allocation
C=Close Ledgers
J=Journal
M=Multi-currency
U=User Defined
RTBL_DEPLOYLINE(SQL Table) |
Index Back |
|---|
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | SCE_ID |
Character(10) | VARCHAR2(10) NOT NULL | ID |
| 2 | SCE_DEPLOY_REQ_ID |
Number(15,0) | DECIMAL(15) NOT NULL | Request ID |
| 3 | RTBL_ELEMENT_TYPE |
Character(1) | VARCHAR2(1) NOT NULL |
Element name to identify (in peoplesoft) an element along with its label.
A=Allocation C=Close Ledgers J=Journal M=Multi-currency U=User Defined |
| 4 | SCE_SUBMIT_DT | DateTime(26) | TIMESTAMP | Date Submitted |
| 5 | SCE_DEPLOY_DT | DateTime(26) | TIMESTAMP | Date Deployed |