SOURCE_BUS_UNITDESTIN_BU0=Calculate Cost at Depletions
1=Transfer at Zero Cost
INIU_DMD_VW(SQL View) |
Index Back |
|---|---|
IN Pairs Intercompany attribs |
| SELECT A.BUSINESS_UNIT , A.DESTIN_BU , A.CUST_ID , A.SHIP_TO_CUST_ID , A.ADDRESS_SEQ_NUM , A.AUTO_PUTAWAY_FLAG , A.ALLOW_ADDR_OVRRIDE , A.INTERCOMPANY_FLG , '0' FROM PS_DMD_IU_DEF_INV A , PS_INSTALLATION_IN IIN WHERE IIN.IUNIT_VALUES IN ('2', '3') |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | SOURCE_BUS_UNIT |
Character(5) | VARCHAR2(5) NOT NULL | Source Bus Unit |
| 2 | DESTIN_BU |
Character(5) | VARCHAR2(5) NOT NULL | Destination Unit |
| 3 | CUST_ID | Character(15) | VARCHAR2(15) NOT NULL | Uniquely identifies an organizational entity that purchases goods or services from the enterprise. Represents the sold-to customer which is the customer organization that places orders. The CUST_ID may or may not be the same as the identifiers for the bill-to and ship-to locations. |
| 4 | SHIP_TO_CUST_ID | Character(15) | VARCHAR2(15) NOT NULL | Ship To Customer |
| 5 | ADDRESS_SEQ_NUM | Number(5,0) | INTEGER NOT NULL | Address Sequence Number |
| 6 | AUTO_PUTAWAY_FLAG | Character(1) | VARCHAR2(1) NOT NULL | Flag Items for Auto-Putaway |
| 7 | ALLOW_ADDR_OVRRIDE | Character(1) | VARCHAR2(1) NOT NULL | Allow Address Override |
| 8 | INTERCOMPANY_FLG | Character(1) | VARCHAR2(1) NOT NULL | /* GMG 02/1999 R-CJOHNS-0E8DU InterCompany transfer enhancement*/ |
| 9 | TRANSFER_CALC_TYPE | Character(1) | VARCHAR2(1) NOT NULL |
Holds information regarding when the transfer price is calculated.
0=Calculate Cost at Depletions 1=Transfer at Zero Cost |