OM_CREDIT_AET(SQL Table) |
Index Back |
|---|---|
State Table for OMHOLDUsed as a state work table for the AE OMHOLD program. Date Init. Issue # Description 080102 JJM F-CJORGENS-43 Performance Improvements |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  PROCESS_INSTANCE |
Number(10,0) | DECIMAL(10) NOT NULL | Process Instance |
| 2 | OPRID | Character(30) | VARCHAR2(30) NOT NULL | A user's ID (see PSOPRDEFN). |
| 3 | OPRID2 | Character(30) | VARCHAR2(30) NOT NULL | A user's ID |
| 4 | RUN_CNTL_ID | Character(30) | VARCHAR2(30) NOT NULL | Run Control ID |
| 5 | SCHED_LINE_NBR | Number(6,0) | INTEGER NOT NULL | Schedule Line Number |
| 6 | SETID_RUNCNTL | Character(5) | VARCHAR2(5) NOT NULL | Run Control SETID Value |
| 7 | SETID_CUSTOMER | Character(5) | VARCHAR2(5) NOT NULL | Customer SetID |
| 8 | SETID_CUST_GRP_LNK | Character(5) | VARCHAR2(5) NOT NULL | Date Maintenance History ==================== Date Initials Issue No. Description ----------------- --------- -------------------------------- ------------------------------------ 2001-26-01 EPT R-ETIMBA-D63MG Miscellaneous Changes. See APRD for details. |
| 9 | SETID_CUST_PARENT | Character(5) | VARCHAR2(5) NOT NULL | Parent SetID |
| 10 | INCL_EXCL_TYPE | Character(1) | VARCHAR2(1) NOT NULL |
Include/Exclude Type
E=Exclusive I=Inclusive |
| 11 | BILL_TO_CUST_ID | Character(15) | VARCHAR2(15) NOT NULL | Customer |
| 12 | SOURCE_CD | Character(6) | VARCHAR2(6) NOT NULL | Source Code |
| 13 | CURRENT_DATE1 | Date(10) | DATE | 12/20/01 EGS (CN#PL900-1): Added 10/07/02 JC (CN#PL880-1): Added FROM_DATE label |
| 14 | CURRENT_DTTM | DateTime(26) | TIMESTAMP | 08/27/01 EGS (CN#PL900-1.0): Added |
| 15 | TIME_TO | Time(15) | TIMESTAMP | To Time |
| 16 | LOOP_COUNT | Number(4,0) | SMALLINT NOT NULL | Number of Program Loops |
| 17 | BUSINESS_UNIT_OM | Character(5) | VARCHAR2(5) NOT NULL | Order Management Business Unit |
| 18 | SOLD_TO_CUST_ID | Character(15) | VARCHAR2(15) NOT NULL | Sold To Customer |
| 19 | SETID_ORD_GRP | Character(5) | VARCHAR2(5) NOT NULL | Order Group Setid |
| 20 | SETID_AGING | Character(5) | VARCHAR2(5) NOT NULL | Cust Receivables Aging SETID |
| 21 | HOLD_CUST_CR | Character(6) | VARCHAR2(6) NOT NULL | Exceeds Customer Credit |
| 22 | HOLD_CORP_CR | Character(6) | VARCHAR2(6) NOT NULL | Exceeds Corporate Credit |
| 23 | HOLD_MAX_ORDER_AMT | Character(6) | VARCHAR2(6) NOT NULL | Exceeds Maximum Order Amount |
| 24 | HOLD_OS_AR | Character(6) | VARCHAR2(6) NOT NULL | Outstanding AR |
| 25 | CR_OFF_ORDER | Character(1) | VARCHAR2(1) NOT NULL | Sales Order |
| 26 | CR_OFF_QUOTE | Character(1) | VARCHAR2(1) NOT NULL | Quote |
| 27 | CR_CHK_ORDER | Character(1) | VARCHAR2(1) NOT NULL | Sales Order Entry |
| 28 | CR_CHK_QUOTE | Character(1) | VARCHAR2(1) NOT NULL | Quote Entry |
| 29 | HOLD_CREDIT_CRD | Character(6) | VARCHAR2(6) NOT NULL | Credit Card Hold |
| 30 | BUSINESS_UNIT | Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
| 31 | ORDER_NO | Character(10) | VARCHAR2(10) NOT NULL | Identifies a customer order number that appears as a reference on a receivables pending item. Date Initials Issue Description 022701 mv SP2 (F-CJORGENS-3) CSR Desktop |
| 32 | ORDER_DATE | Date(10) | DATE | Date Initials Issue Description 022701 mv SP2 (F-CJORGENS-3) CSR Desktop |
| 33 | DATETIME_ADDED | DateTime(26) | TIMESTAMP | DateTime Added |
| 34 | ORDER_INT_LINE_NO | Number(5,0) | INTEGER NOT NULL | Order Line |
| 35 | ORDER_GRP | Character(6) | VARCHAR2(6) NOT NULL | Order Group |
| 36 | PROCESS_INSTANCE2 | Number(10,0) | DECIMAL(10) NOT NULL | Process Instance |
| 37 | SETID | Character(5) | VARCHAR2(5) NOT NULL | SetID |
| 38 | 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. |
| 39 | CURRENCY_CD1 | Character(3) | VARCHAR2(3) NOT NULL | Currency Code |
| 40 | CURRENCY_CD2 | Character(3) | VARCHAR2(3) NOT NULL | Currency Code |
| 41 | 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. |
| 42 | RATE_MULT | Signed Number(17,8) | DECIMAL(15,8) NOT NULL | Rate Multiplier |
| 43 | RATE_DIV | Number(16,8) | DECIMAL(15,8) NOT NULL | Rate Divisor |
| 44 | DECIMAL_POSITIONS | Number(2,0) | SMALLINT NOT NULL | Decimal Positions |
| 45 | AMOUNT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Amount |
| 46 | TAX_AMT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Tax Amount |
| 47 | VAT_AMT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Specifies the amount of VAT associated with a transaction such as an invoice or a purchase order. In PeopleSoft Receivables this field is populated when the VAT declaration point is set to Invoice. |
| 48 | REMAINING_AMOUNT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Remaining Amount |
| 49 | AMOUNT_BACKLOG | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Backlog Amount |
| 50 | DEPOSIT_AMOUNT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Deposit Amount |
| 51 | PAYMENT_AMT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Specifies the amount of a customer payment. |
| 52 | FREIGHT_CHARGE | Signed Number(17,4) | DECIMAL(15,4) NOT NULL | Freight Charge |
| 53 | FREIGHT_CHARGE_BSE | Signed Number(17,4) | DECIMAL(15,4) NOT NULL | Freight Charge (base) |
| 54 | OM_FLAG | Character(1) | VARCHAR2(1) NOT NULL | OM Work Flag |
| 55 | RUN_OM_BACKGRND | Character(1) | VARCHAR2(1) NOT NULL |
Run Order Completion
Y/N Table Edit |
| 56 | RUN_OM_PRICING | Character(1) | VARCHAR2(1) NOT NULL |
Run Repricing
Y/N Table Edit |
| 57 | RUN_OMCREDIT | Character(1) | VARCHAR2(1) NOT NULL |
Run Credit Checking
Y/N Table Edit |
| 58 | RUN_OMDEMAND | Character(1) | VARCHAR2(1) NOT NULL |
Run Populate Demand
Y/N Table Edit |
| 59 | RUN_OMHOLD | Character(1) | VARCHAR2(1) NOT NULL |
Run Hold Checking
Y/N Table Edit |
| 60 | RUN_RESERVATIONS | Character(1) | VARCHAR2(1) NOT NULL |
Run Reservations Job
Y/N Table Edit |
| 61 | RUN_DELIVERIES | Character(1) | VARCHAR2(1) NOT NULL |
Manage Deliveries
Y/N Table Edit |
| 62 | RUN_FREIGHT | Character(1) | VARCHAR2(1) NOT NULL |
Perform Freight
Y/N Table Edit |
| 63 | FLAG | Character(1) | VARCHAR2(1) NOT NULL |
Flag
N=No Y=Yes |
| 64 | FLAG1 | Character(1) | VARCHAR2(1) NOT NULL | Flag1 |
| 65 | FLAG2 | Character(1) | VARCHAR2(1) NOT NULL | Flag2 |
| 66 | FLAG3 | Character(1) | VARCHAR2(1) NOT NULL | Flag3 |
| 67 | FLAG4 | Character(1) | VARCHAR2(1) NOT NULL | Flag4 |
| 68 | FLAG5 | Character(1) | VARCHAR2(1) NOT NULL | Flag5 |
| 69 | AR | Character(1) | VARCHAR2(1) NOT NULL | Receivables |
| 70 | SQL_WHERE_001 | Character(254) | VARCHAR2(254) NOT NULL | |
| 71 | SQL_WHERE_002 | Character(254) | VARCHAR2(254) NOT NULL | |
| 72 | SQL_WHERE_004 | Long Character | CLOB | |
| 73 | SQL_TABLES | Character(254) | VARCHAR2(254) NOT NULL | SQL Tables |
| 74 | SQL_SET_001 | Character(254) | VARCHAR2(254) NOT NULL | |
| 75 | INC_DEPOSIT_FLG | Character(1) | VARCHAR2(1) NOT NULL | Allow Deposit in Credit Check |
| 76 | IN_PREPAYMT_FLG | Character(1) | VARCHAR2(1) NOT NULL | Incl Pending Payment in Credit |
| 77 | CUST_HIERARCHY_PB | Character(1) | VARCHAR2(1) NOT NULL | Hierarchy |
| 78 | CR_CHK_ALG_INSTALL | Character(1) | VARCHAR2(1) NOT NULL |
Corporate Cr. Check Algorithm
A=Basic, Allow Override B=Basic, Do Not Allow Override C=Advanced, Allow Override D=Advanced, Do Not Allow Ovr |
| 79 | CR_CHK_ALG | Character(1) | VARCHAR2(1) NOT NULL |
Corporate Cr. Check Algorithm
A=Advanced B=Basic |
| 80 | CR_SUM_INSTALL | Character(1) | VARCHAR2(1) NOT NULL |
Use Corporate Summary Table
A=Yes, Override Allowed B=Yes, Override Not Allowed C=No, Override Allowed D=Disabled |
| 81 | CR_CHK_SUM | Character(1) | VARCHAR2(1) NOT NULL |
Use Corporate Summary Table
N=No Y=Yes |
| 82 | CR_CHK_BI | Character(1) | VARCHAR2(1) NOT NULL | Include Non-OM Invoices |
| 83 | CUST_DRAFTS | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Total Actual Draft Debt |
| 84 | TOTAL_AGED_AR | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Total Aged AR |
| 85 | BILLING_AMOUNT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Resource Billing Amount |