SETIDSHIP_TO_CUST_IDADDRESS_SEQ_NUMEFFDTA=Active
I=Inactive
INV_CST_ADR2_VW(SQL View) |
Index Back |
|---|---|
Ship-To Cust Addr by SBUCopy of INV_CST_ADDR_VW, except that: 1. Ship-To Customer ID and Address Sequence Number fields used are SHIP_TO_CUST_ID and ADDRESS_SEQ_NUM, instead of SL_SHIP_TO_CUST_ID and SL_ADDRESS_SEQ_NUM 2. Set Control Field used is BUSINESS_UNIT, instead of SL_SOURCE_BUS_UNIT |
| SELECT B.SETID , B.CUST_ID , B.ADDRESS_SEQ_NUM , B.EFFDT , B.EFF_STATUS FROM %Table(CUST_ADDR_SEQ) A , %Table(CUST_ADDRESS) B WHERE %Join(COMMON_KEYS, CUST_ADDR_SEQ A, CUST_ADDRESS B) AND A.SHIP_TO_ADDR = 'Y' |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | SETID |
Character(5) | VARCHAR2(5) NOT NULL | SetID |
| 2 | SHIP_TO_CUST_ID |
Character(15) | VARCHAR2(15) NOT NULL | Ship To Customer |
| 3 | ADDRESS_SEQ_NUM |
Number(5,0) | INTEGER NOT NULL | Address Sequence Number |
| 4 | EFFDT |
Date(10) | DATE | Effective Date |
| 5 | EFF_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Effective Status
A=Active I=Inactive |