CB_PROFIT_AET(SQL Table) |
Index Back |
---|---|
Profitability State Record |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | PROCESS_INSTANCE | Number(10,0) | DECIMAL(10) NOT NULL | Process Instance |
2 | AE_APPLID | Character(12) | VARCHAR2(12) NOT NULL | Program Name (see PSAEAPPLDEFN). |
3 | AE_SECTION | Character(8) | VARCHAR2(8) NOT NULL | Section |
4 | PROBINST | Character(20) | VARCHAR2(20) NOT NULL | Optimization Problem Instance |
5 | BUSINESS_UNIT_IN | Character(5) | VARCHAR2(5) NOT NULL | Inventory Unit |
6 | BUSINESS_UNIT_OM | Character(5) | VARCHAR2(5) NOT NULL | Order Management Business Unit |
7 | CUST_ID | Character(15) | VARCHAR2(15) NOT NULL | Uniquely identifies an organizational entity that purchases goods or services from the enterprise. Represents the sold-to customer which is the customer organization that places orders. The CUST_ID may or may not be the same as the identifiers for the bill-to and ship-to locations. |
8 | PRODUCT_ID | Character(18) | VARCHAR2(18) NOT NULL | Product ID |
9 | PROD_GRP_TYPE | Character(4) | VARCHAR2(4) NOT NULL |
Product Group Type
ACCT=Accounting BO=Backorder/Reservations CA=Contract CLMB=Claimback Contract CTLG=Product Catalogs FCST=Forecast FRT=Freight PRC=Pricing RPT=Reporting SCON=Buying Agreement SSRC=Alternate Sources of Supply TAX=Tax TRPT=Transportations VAT=VAT WEB=WEB Order Entry |
10 | PRODUCT_GROUP | Character(10) | VARCHAR2(10) NOT NULL | Product Group |
11 | CB_CLEAR_STG | Character(1) | VARCHAR2(1) NOT NULL | Clear Staged Data |
12 | SETID | Character(5) | VARCHAR2(5) NOT NULL | SetID |
13 | 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. " |
14 | RT_TYPE | Character(5) | VARCHAR2(5) NOT NULL | Defines a category of market rates for currency conversion. Some examples of rate types are commercial, average, floating, and historical. |