PL_POST_DATA_TYPE010=Purchases
020=Production
030=Transfers
040=Planned Purchases
050=Planned Production
060=Planned Transfers
070=Stock Requests
080=Quotes
090=Sales Orders
100=Buying Agreements
110=Projected Useup
PL_POST_DATA_VW(SQL View) |
Index Back |
|---|---|
Data Types Available for Post01/17/01 EBN (CN#PL900-1.0): Added for posting changes from planning to the transaction system. |
| SELECT A.FIELDVALUE FROM PSXLATITEM A WHERE A.FIELDNAME = 'PL_POST_DATA_TYPE' AND A.EFF_STATUS = 'A' |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | PL_POST_DATA_TYPE |
Character(4) | VARCHAR2(4) NOT NULL |
Data Type
010=Purchases 020=Production 030=Transfers 040=Planned Purchases 050=Planned Production 060=Planned Transfers 070=Stock Requests 080=Quotes 090=Sales Orders 100=Buying Agreements 110=Projected Useup |