OMBI_INBU_AET(SQL Table) |
Index Back |
---|---|
INBU set control values.This record will store vales for inbu related set control values used in ombill processing. |
# | 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_IN | Character(5) | VARCHAR2(5) NOT NULL | Inventory Unit |
3 | SETID_PRODUCT | Character(5) | VARCHAR2(5) NOT NULL | Product SetID |
4 | SETID_PRODKIT | Character(5) | VARCHAR2(5) NOT NULL | SetID |
5 | SETID_MST_ITEM | Character(5) | VARCHAR2(5) NOT NULL | Master Item SETID |
6 | BASE_CURRENCY | Character(3) | VARCHAR2(3) NOT NULL | "Specifies the primary currency for a general ledger business unit, and is sometimes referred to as the ""book"" currency. Each business unit has one base currency. which is usually, but not always, the local currency for the organization. Journal entries are posted to a business unit in its base currency. " |
7 | BILL_TYPE_ID | Character(3) | VARCHAR2(3) NOT NULL | Bill Type Identifier |
8 | BILL_SOURCE_ID | Character(10) | VARCHAR2(10) NOT NULL | Bill Source |
9 | BUSINESS_UNIT_BI | Character(5) | VARCHAR2(5) NOT NULL | Billing Business Unit |
10 | DST_ID_REV | Character(10) | VARCHAR2(10) NOT NULL | Revenue Dist Code |
11 | DST_ID_DIS | Character(10) | VARCHAR2(10) NOT NULL | Discount Distribution Code |
12 | DST_ID_SUR | Character(10) | VARCHAR2(10) NOT NULL | Surcharge Distribution Code |
13 | FREIGHT_PROD_ID | Character(18) | VARCHAR2(18) NOT NULL | Freight Product ID |
14 | LOCATION | Character(10) | VARCHAR2(10) NOT NULL | Location Code |
15 | MISC_CHRG_PROD_ID | Character(18) | VARCHAR2(18) NOT NULL | Misc Charge Product ID |