OMBCK2_AET(SQL Table) |
Index Back |
|---|---|
OM Completion AE - Part 2OM Completion AE Cache - Part 2 Date Maintenance History ==================== Date Initials Issue No. Description ----------------- --------- -------------------------------- ------------------------------------ 2000-12-04 DMS 5744301 Add field CNTCT_SEQ_BILL 2001-26-01 EPT R-ETIMBA-D63MG Miscellaneous AE changes which requires changes on this record. See APRD for details. 2001-03-07 EPT R-ETIMBA-T28VR Added DELETE_FLG 2001-10-30 dms D-RBADARIN-6 Added setid_source_cd |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  PROCESS_INSTANCE |
Number(10,0) | DECIMAL(10) NOT NULL | Process Instance |
| 2 | ADDTL_ADJUST_AMT | Signed Number(29,4) | DECIMAL(27,4) NOT NULL | Adjustment Amount |
| 3 | ADDTL_ADJUST_BASE | Signed Number(29,4) | DECIMAL(27,4) NOT NULL | Adjustment Amount (base) |
| 4 | ADDTL_ADJUST_PCT | Signed Number(7,2) | DECIMAL(5,2) NOT NULL | Adjustment % |
| 5 | AERP | Character(50) | VARCHAR2(50) NOT NULL | Automated Exporter Rptg Prgm |
| 6 | ANALYSIS_TYPE | Character(3) | VARCHAR2(3) NOT NULL | Analysis Type |
| 7 | BUSINESS_UNIT_IN | Character(5) | VARCHAR2(5) NOT NULL | Inventory Unit |
| 8 | BUSINESS_UNIT_OLD | Character(5) | VARCHAR2(5) NOT NULL | Old Business Unit |
| 9 | CCI_REQ_EXP | Character(1) | VARCHAR2(1) NOT NULL |
Canadian Customs Invoice
N=No Y=Yes |
| 10 | CNTCT_SEQ_BILL | Number(5,0) | INTEGER NOT NULL | Contact Sequence - Bill To |
| 11 | CNTCT_SEQ_SHIP | Number(5,0) | INTEGER NOT NULL | Primary Contact - Ship To |
| 12 | COO_REQ_EXP | Character(1) | VARCHAR2(1) NOT NULL |
Certificate of Origin
N=No Y=Yes |
| 13 | CR_CARD_FNAME | Character(40) | VARCHAR2(40) NOT NULL | Credit Card First Name |
| 14 | CR_CARD_LNAME | Character(40) | VARCHAR2(40) NOT NULL | Credit Card Last Name |
| 15 | CR_CARD_VENDOR | Character(16) | VARCHAR2(16) NOT NULL | Processor Name |
| 16 | CC_PROF_TOKEN | Character(44) | VARCHAR2(44) NOT NULL | Profile Token ID |
| 17 | CC_PROF_OPT | Character(1) | VARCHAR2(1) NOT NULL |
Credit Card Profile Option
0=No Tokenization 1=Create Profiles Before 2=Create Profiles After |
| 18 | CP | Character(1) | VARCHAR2(1) NOT NULL | Product Configuration Field |
| 19 | CUST_CHANNEL | Character(15) | VARCHAR2(15) NOT NULL | Customer Channel |
| 20 | DELETE_FLG | Character(1) | VARCHAR2(1) NOT NULL | Delete Loaded Items |
| 21 | DELETE_TEMP | Character(1) | VARCHAR2(1) NOT NULL | Delete Temp. Tables |
| 22 | EMAILID | Character(70) | VARCHAR2(70) NOT NULL | A user's E-mail address |
| 23 | FREIGHT_BILLD_FLAG | Character(1) | VARCHAR2(1) NOT NULL | Freight Amount Billed/Posted |
| 24 | FREIGHT_CHARGE | Signed Number(17,4) | DECIMAL(15,4) NOT NULL | Freight Charge |
| 25 | FREIGHT_CHARGE_BSE | Signed Number(17,4) | DECIMAL(15,4) NOT NULL | Freight Charge (base) |
| 26 | FRT_CHRG_OVERRIDE | Character(1) | VARCHAR2(1) NOT NULL | Freight Charge Override |
| 27 | NAFTA_REQ_EXP | Character(1) | VARCHAR2(1) NOT NULL |
North American Free Trade Agmt
N=No Y=Yes |
| 28 | OM_ADJST_AMT | Signed Number(19,4) | DECIMAL(17,4) NOT NULL | Order Adjustment Amount |
| 29 | OM_ADJST_AMT_BSE | Signed Number(19,4) | DECIMAL(17,4) NOT NULL | Adjustment Amount (Base) |
| 30 | OPRID | Character(30) | VARCHAR2(30) NOT NULL | A user's ID (see PSOPRDEFN). |
| 31 | OPRID_ENTERED_BY | Character(30) | VARCHAR2(30) NOT NULL | Entered By 07/25/2011 MRAD 12383033 :Ensured that OPRID_ENTERED_BY is set with format type of MixedCase. 03/22/2013 GL 16482301: Switched OPRID_ENTERED_BY back to MixedCase again. Please don't change it to UpperCase!!! FYI - The alternatives to use a User ID as uppercase: 1) Create your own User ID, add comments in the Field Properties, and fill out the Owner ID 2) Use %Upper meta-SQL in SQL statements 3) Use Upper function in peoplecodes |
| 32 | OPRID_OWNER | Character(30) | VARCHAR2(30) NOT NULL | Operator id of the owner of a document |
| 33 | PHONE | Character(24) | VARCHAR2(24) NOT NULL | Telephone |
| 34 | PROCESS_INSTANCE2 | Number(10,0) | DECIMAL(10) NOT NULL | Process Instance |
| 35 | RUN_CNTL_ID | Character(30) | VARCHAR2(30) NOT NULL | Run Control ID |
| 36 | SED_REQ_EXP | Character(1) | VARCHAR2(1) NOT NULL |
Shippers Export Declaration
N=No Y=Yes |
| 37 | SQL_WHERE_001 | Character(254) | VARCHAR2(254) NOT NULL | |
| 38 | SELECT_PARM1 | Character(254) | VARCHAR2(254) NOT NULL | Dynamic Where Select Parms 1 |
| 39 | SQL_TABLES | Character(254) | VARCHAR2(254) NOT NULL | SQL Tables |
| 40 | SETID_SOURCE_CD | Character(5) | VARCHAR2(5) NOT NULL | Source Code SetId |
| 41 | UNIT_OF_MEASURE | Character(3) | VARCHAR2(3) NOT NULL |
Used on an approval rule set.
MHR=Muti Hourly PER=Percentage SQF=Square Footage |
| 42 | UNIT_MEASURE_VOL | Character(3) | VARCHAR2(3) NOT NULL | Volume UOM |
| 43 | UNIT_MEASURE_WT | Character(3) | VARCHAR2(3) NOT NULL | Weight UOM |
| 44 | RUN_OM_BACKGRND | Character(1) | VARCHAR2(1) NOT NULL |
Run Order Completion
Y/N Table Edit |
| 45 | RUN_OM_PRICING | Character(1) | VARCHAR2(1) NOT NULL |
Run Repricing
Y/N Table Edit |
| 46 | RUN_OMCREDIT | Character(1) | VARCHAR2(1) NOT NULL |
Run Credit Checking
Y/N Table Edit |
| 47 | RUN_OMDEMAND | Character(1) | VARCHAR2(1) NOT NULL |
Run Populate Demand
Y/N Table Edit |
| 48 | RUN_OMHOLD | Character(1) | VARCHAR2(1) NOT NULL |
Run Hold Checking
Y/N Table Edit |
| 49 | RUN_RESERVATIONS | Character(1) | VARCHAR2(1) NOT NULL |
Run Reservations Job
Y/N Table Edit |
| 50 | RUN_DELIVERIES | Character(1) | VARCHAR2(1) NOT NULL |
Manage Deliveries
Y/N Table Edit |
| 51 | RUN_FREIGHT | Character(1) | VARCHAR2(1) NOT NULL |
Perform Freight
Y/N Table Edit |
| 52 | WHERE_CLAUSE_LONG | Long Character(4000) | CLOB | Where Clause |
| 53 | DESCR254 | Character(254) | VARCHAR2(254) NOT NULL | Description of length 254 |