AR_POST_STS_LVW(SQL View) |
Index Back |
---|---|
Post Status Descriptions |
SELECT %Substring(fieldvalue,1,1) , language_cd , xlatlongname , xlatshortname FROM PSXLATITEMLANG WHERE fieldname = 'POST_STATUS' |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | POST_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
A flag that indicates whether or not a control group of pending items has been fully posted to customer accounts. The posting status also indicates whether or not there were errors encountered during posting. This field is automatically populated by the Receivables Update program.
%=All C=Complete E=Errors N=Not Posted |
2 | LANGUAGE_CD | Character(3) | VARCHAR2(3) NOT NULL | Language Code |
3 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
4 | DESCRSHORT | Character(10) | VARCHAR2(10) NOT NULL | Short Description |