OMBI_DS_TMP(SQL Table) |
Index Back |
|---|---|
OMBILL temp tableThis table is a working table for SQR OMBILL. It holds total order discount and surcharge data for each invoice line. |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | INTFC_ID | Number(8,0) | INTEGER NOT NULL | Interface ID |
| 2 | INTFC_LINE_NUM | Number(8,0) | INTEGER NOT NULL | Interface Line Number |
| 3 | TRANS_TYPE_BI | Character(4) | VARCHAR2(4) NOT NULL |
Transaction Type
AE=Accounting Entry AHDR=Adjustment Header DDS=Deferred Discount/Surcharge DS=Discount/Surcharge EXSD=Indian Excise/Sales Tax Detail LINE=Chargeable Line NOTE=Note/Comment TAX=Sales/Use Tax Detail |
| 4 | TRANS_TYPE_BI_SEQ | Number(3,0) | SMALLINT NOT NULL |
Transaction Type Seq
010=Invalid Transaction Type 020=Too many charge lines 030=No charge line for activity 040=Invalid Business Unit 050=Invalid bill-to customer 060=Invalid Billing Address 070=Invalid bill-to contact 080=No Bill Source provided 090=Invalid Bill Source 100=Invalid Bill Type 110=Invalid Bill Cycle 120=Invalid Payment Term 130=Invalid Tax Code 140=Invalid Unit of measure 200=Invalid Standard Note Code 210=No Note Code or Text exists 300=Both Amount & Percentage are 0 |
| 5 | BUSINESS_UNIT | Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
| 6 | DST_ID | Character(10) | VARCHAR2(10) NOT NULL | Distribution Code |
| 7 | DST_ID_SUR | Character(10) | VARCHAR2(10) NOT NULL | Surcharge Distribution Code |
| 8 | DST_ID_DFR | Character(10) | VARCHAR2(10) NOT NULL | Deferred Distribution Code |
| 9 | AMOUNT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Amount |
| 10 | UNIT_AMT | Signed Number(17,4) | DECIMAL(15,4) NOT NULL | Unit Price |
| 11 | PERCENTAGE | Signed Number(7,2) | DECIMAL(5,2) NOT NULL | Percentage |
| 12 | DISC_SUR_INDICATOR | Character(1) | VARCHAR2(1) NOT NULL |
Discount/Surcharge
D=Discount I=Installment Surcharge S=Surcharge |
| 13 | DISC_SUR_ID | Character(15) | VARCHAR2(15) NOT NULL | Identifier |
| 14 | DISC_SUR_LVL | Number(2,0) | SMALLINT NOT NULL | Discount/Surcharge Level |
| 15 | EOEP_RULE_ID | Character(30) | VARCHAR2(30) NOT NULL | Price Rule ID |
| 16 | PRICE_SET_TYPE | Character(2) | VARCHAR2(2) NOT NULL |
Price Set Type
99=Standard Discount A=Price Override F=Cascading S=Summed Adjustments Z=Giveaway |
| 17 | SEQ_NUM | Number(3,0) | SMALLINT NOT NULL | Sequence |
| 18 | BUSINESS_UNIT_OM | Character(5) | VARCHAR2(5) NOT NULL | Order Management Business Unit |
| 19 | 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 |
| 20 | PROCESS_INSTANCE | Number(10,0) | DECIMAL(10) NOT NULL | Process Instance |
| 21 | BI_CURRENCY_CD | Character(3) | VARCHAR2(3) NOT NULL | Billing Currency Code |
| 22 | 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. " |
| 23 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
| 24 | MERCH_TYPE | Character(10) | VARCHAR2(10) NOT NULL | Merchandising Type |
| 25 | PPRC_PROMO_CD | Character(20) | VARCHAR2(20) NOT NULL | Price Promotion Code |