SETIDDefault Value: OPR_DEF_TBL_FS.SETID
Prompt Table: SP_SETID_NONVW
SHIPTO_IDPrompt Table: SHIPTO_TBL
Y/N Table Edit
Default Value: N
Y/N Table Edit
Default Value: N
SHIPTO_CMMT_VW(SQL View) |
Index Back |
|---|---|
Shipping Locations CommentsShipping Locations Comments |
| SELECT A.SETID , A.SHIPTO_ID , A.COPY_TO_PO , A.PUBLIC_FLG , A.OPRID , A.COMMENT_ID , A.RANDOM_CMMT_NBR , B.COMMENTS_2000 FROM PS_SHIPTO_TBL A , PS_COMMENTS_TBL B WHERE A.OPRID = B.OPRID AND A.COMMENT_ID = B.COMMENT_ID AND A.RANDOM_CMMT_NBR = B.RANDOM_CMMT_NBR AND A.COPY_TO_PO = 'Y' AND A.EFF_STATUS = 'A' AND %EffdtCheck(SHIPTO_TBL AA, A, %CurrentDateIn) |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | SETID |
Character(5) | VARCHAR2(5) NOT NULL |
SetID
Default Value: OPR_DEF_TBL_FS.SETID Prompt Table: SP_SETID_NONVW |
| 2 | SHIPTO_ID |
Character(10) | VARCHAR2(10) NOT NULL |
Ship To Location
Prompt Table: SHIPTO_TBL |
| 3 | COPY_TO_PO | Character(1) | VARCHAR2(1) NOT NULL |
Copy to Purchase Order
Y/N Table Edit Default Value: N |
| 4 | PUBLIC_FLG | Character(1) | VARCHAR2(1) NOT NULL |
Send to Vendor
Y/N Table Edit Default Value: N |
| 5 | OPRID | Character(30) | VARCHAR2(30) NOT NULL | A user's ID (see PSOPRDEFN). |
| 6 | COMMENT_ID | DateTime(26) | TIMESTAMP | DtTm Entered |
| 7 | RANDOM_CMMT_NBR | Number(4,0) | SMALLINT NOT NULL | Random Comments Number |
| 8 | COMMENTS_2000 | Long Character | CLOB | Comment Text |