PROCESS_INSTANCEOMBI_DFTL_AET(SQL Table) |
Index Back |
|---|---|
Used in AE OM_OMBIDFTL |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | PROCESS_INSTANCE |
Number(10,0) | DECIMAL(10) NOT NULL | Process Instance |
| 2 | BUSINESS_UNIT | Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
| 3 | BILL_TYPE_ID | Character(3) | VARCHAR2(3) NOT NULL | Bill Type Identifier |
| 4 | BILL_SOURCE_ID | Character(10) | VARCHAR2(10) NOT NULL | Bill Source |
| 5 | PYMNT_TERMS_CD | Character(5) | VARCHAR2(5) NOT NULL | Specifies how the payment due date and discount due date are calculated. A payment terms code is associated with various business units bill-to customers vendors as well as sales orders purchase orders and vouchers. |
| 6 | PRODUCT_ID | Character(18) | VARCHAR2(18) NOT NULL | Product ID |
| 7 | DIST_CFG_FLAG | Character(1) | VARCHAR2(1) NOT NULL | Distribution Configuration |
| 8 | BUSINESS_UNIT_OM | Character(5) | VARCHAR2(5) NOT NULL | Order Management Business Unit |
| 9 | PRODUCT_ID_ALT | Character(18) | VARCHAR2(18) NOT NULL | Alternate Product ID |
| 10 | OM_FLAG | Character(1) | VARCHAR2(1) NOT NULL | OM Work Flag |