OMBI_DISTRB_TMP(SQL Table) |
Index Back |
|---|---|
OMBILL temp tableThis table is a working table for SQR OMBILL. It holds the revenue, discount, and surcharge distribution IDs for shipment to invoice. |
| # | 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 | DISTRIB_SET_ID | Character(10) | VARCHAR2(10) NOT NULL | Distribution Set ID |
| 6 | DST_ID_DIS | Character(10) | VARCHAR2(10) NOT NULL | Discount Distribution Code |
| 7 | DST_ID_REV | Character(10) | VARCHAR2(10) NOT NULL | Revenue Dist Code |
| 8 | DST_ID_SUR | Character(10) | VARCHAR2(10) NOT NULL | Surcharge Distribution Code |
| 9 | DST_PCT_DIS | Signed Number(7,2) | DECIMAL(5,2) NOT NULL | Discount Dist Percentage |
| 10 | DST_PCT_REV | Signed Number(7,2) | DECIMAL(5,2) NOT NULL | Revenue Dist Percentage |
| 11 | DST_PCT_SUR | Signed Number(7,2) | DECIMAL(5,2) NOT NULL | Surcharge Dist Percentage |
| 12 | PROCESS_INSTANCE | Number(10,0) | DECIMAL(10) NOT NULL | Process Instance |