CUSTCPY_RGNTY_V(SQL View) |
Index Back |
---|---|
Cust Copy VW-Region Code TypesView of Region Code types on the customer record for copy function. |
SELECT SETID, CUST_ID, REGION_CD_TYPE, REGION_CD FROM PS_CUST_REGN_TYPE |
# | 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 | CUST_CPY_ID | Character(15) | VARCHAR2(15) NOT NULL | Customer Copy ID |
3 | 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 |
4 | 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 |