BCT_CDTL_INV_VW(SQL View) |
Index Back |
---|---|
Prompt xlat for DTL Cmp FlgsPrompt view for fulfillment Detail Complete Flags. |
SELECT B.FIELDVALUE , B.XLATLONGNAME , B.XLATSHORTNAME FROM PSXLATITEM B WHERE B.FIELDNAME = 'COMPLETE_FLG' AND B.FIELDVALUE IN ('1','2','3','4','6','7','8','A') AND %EffdtCheck(PSXLATITEM C, B, %CurrentDateIn) AND B.EFF_STATUS = 'A' |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | COMPLETE_FLG | Character(1) | VARCHAR2(1) NOT NULL |
Complete Flag
0=Process Location 1=Pick Line Complete 2=Pick Batch Complete 3=Pick Line as Planned 4=Pick Batch as Planned 5=Process Location - Incomplete 6=Complete Pick - Zero Quantity 7=Complete Pick - Leave Alone 8=Complete Pick - Dft Ship Loc A=Use Defaults B=No Action Prompt Table: BCT_XSHP_INV_VW |
2 | XLATLONGNAME | Character(30) | VARCHAR2(30) NOT NULL | Translate Long Name |
3 | XLATSHORTNAME | Character(10) | VARCHAR2(10) NOT NULL | Translate Value Short Name |