PO_DC_MFG_AET

(SQL Table)
Index Back

DCAE for MFG Contract

PO002 Manufacturer Contract. Data conversion for populating contract control table for non-corporate contract.

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance
2 SETID Character(5) VARCHAR2(5) NOT NULL SetID
3 CNTRCT_ID Character(25) VARCHAR2(25) NOT NULL Buying Agreement ID
4 VERSION_NBR Number(5,0) INTEGER NOT NULL Contract Version number
5 CONTROL_TYPE Character(4) VARCHAR2(4) NOT NULL PO002 Manufacturer Contract
BU=Business Unit
CDOM=Contract Domain
SHIP=Ship To
X=Not Used
6 SEQ_NO Number(15,0) DECIMAL(15) NOT NULL Sequence Number
7 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit

Prompt Table: SP_BU_PM_NONVW