REGION_SHIPTO(SQL Table) |
Index Back |
|---|---|
Contract Domain Ship To IDPO002 Manufactuer Contract. Provides Ship To Locaitons for Contract Domains. |
| # | 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 | REGION_CD_TYPE |
Character(4) | VARCHAR2(4) NOT NULL |
Region Code Type
ACCT=Accounting BO=Backorder/Reservation CDOM=Contract Domain CNTR=Contracts FRT=Freight MBR=Team Member PRC=Pricing RPT=Reporting RS=Resource Management SPRS=Procurement SSRC=Alternate Sources Of Supply TRPT=Transportation |
| 3 | REGION_CD |
Character(10) | VARCHAR2(10) NOT NULL |
Identifies the Sales Region. Populated on the Item Table to identify the Sales Region the Item is applied to.
Prompt Table: REGION_CD |
| 4 | EFFDT |
Date(10) | DATE NOT NULL |
Effective Date
Default Value: %date |
| 5 | SHIPTO_SETID |
Character(5) | VARCHAR2(5) NOT NULL |
ShipTo SetID
Default Value: OPR_DEF_TBL_FS.SETID Prompt Table: SP_SETID_NONVW |
| 6 | SHIPTO_ID |
Character(10) | VARCHAR2(10) NOT NULL |
Ship To Location
Prompt Table: CDOM_SHIPTO_VW |