SCON_INTFC_VW(SQL View) |
Index Back |
|---|---|
Buying Agreements Interface VwBuying Agreements Interface View. Used when determining what amounts to pass to Billing for Rebates or Penalties. |
| SELECT 0 , 0 , 'LINE' , 1 , 'Y' , 'N' , OM.BUSINESS_UNIT_BI , SCON.SOLD_TO_CUST_ID , 0 , OM.BILL_SOURCE_ID , OM.BILL_TYPE_ID , ' ' , SCON.CURRENCY_CD , SCON.CURRENCY_CD , 'REV' , OM.REBATE_PROD_ID , PI.DESCR , 'EA' , 1 , %Round(%DecMult(SCON.REBATE_AMT, -1) ,4) , %DecMult(SCON.REBATE_AMT, -1) , SCON.PENALTY_AMT , ' ' , %DecMult(SCON.REBATE_AMT, -1) , 100 , OM.REBATE_PROD_ID , SCON.SETID , SCON.CNTRCT_ID , SCON.LINE_NBR , OM.BUSINESS_UNIT , ' ' , %DateNull FROM PS_BUS_UNIT_TBL_OM OM , PS_SCON_REBATES SCON , PS_SCON_LINE SLIN , PS_PROD_ITEM PI , PS_SET_CNTRL_REC S WHERE OM.BUSINESS_UNIT = SLIN.BUSINESS_UNIT AND SCON.SETID = SLIN.SETID AND SCON.CNTRCT_ID = SLIN.CNTRCT_ID AND SCON.LINE_NBR = SLIN.LINE_NBR AND SCON.RBT_PNLTY_STATUS = 'A' AND s.setcntrlvalue = SLIN.business_unit AND s.recname = 'PROD_ITEM' AND pi.setid = s.setid AND pi.product_id = OM.REBATE_PROD_ID |
| # | 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 | CREATE_NEW_BILL | Character(1) | VARCHAR2(1) NOT NULL | Create New Bill |
| 6 | TMP_BILL_FLG | Character(1) | VARCHAR2(1) NOT NULL | Temporary Bill |
| 7 | BUSINESS_UNIT | Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
| 8 | BILL_TO_CUST_ID | Character(15) | VARCHAR2(15) NOT NULL | Customer |
| 9 | ADDRESS_SEQ_NUM | Number(5,0) | INTEGER NOT NULL | Address Sequence Number |
| 10 | BILL_SOURCE_ID | Character(10) | VARCHAR2(10) NOT NULL | Bill Source |
| 11 | BILL_TYPE_ID | Character(3) | VARCHAR2(3) NOT NULL | Bill Type Identifier |
| 12 | PYMNT_TERMS_CD | Character(5) | VARCHAR2(5) NOT NULL | Specifies how the payment due date and discount due date are calculated. A payment terms code is associated with various business units bill-to customers vendors as well as sales orders purchase orders and vouchers. |
| 13 | BI_CURRENCY_CD | Character(3) | VARCHAR2(3) NOT NULL | Billing Currency Code |
| 14 | 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. " |
| 15 | LINE_TYPE | Character(4) | VARCHAR2(4) NOT NULL |
Line Type 1
ADV=Advance Billing BAE=Billed Amount in Excess BRT=Billing Retainage DAPP=Cust Deposit Applied DEP=Customer Deposit DISC=Discount Line DREF=Cust Deposit Refunded DRFF=Cust Deposit Refund Fee FRGT=Freight (Surcharge) MISC=Miscellaneous Charge PYCV=Payment with Corporate Voucher RAE=Reclaimed Amount in Excess REV=Revenue Line RSTK=Restock (Surcharge) SUR=Surcharge Line UTL=Utilization Line |
| 16 | IDENTIFIER | Character(18) | VARCHAR2(18) NOT NULL | Identifier |
| 17 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
| 18 | UNIT_OF_MEASURE | Character(3) | VARCHAR2(3) NOT NULL |
Used on an approval rule set.
MHR=Muti Hourly PER=Percentage SQF=Square Footage |
| 19 | QTY | Signed Number(17,4) | DECIMAL(15,4) NOT NULL | Quantity |
| 20 | UNIT_AMT | Signed Number(17,4) | DECIMAL(15,4) NOT NULL | Unit Price |
| 21 | GROSS_EXTENDED_AMT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Gross Extended |
| 22 | PENALTY_AMT | Number(16,2) | DECIMAL(15,2) NOT NULL | Penalty Amount |
| 23 | DST_ID | Character(10) | VARCHAR2(10) NOT NULL | Distribution Code |
| 24 | AMOUNT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Amount |
| 25 | PERCENTAGE | Signed Number(7,2) | DECIMAL(5,2) NOT NULL | Percentage |
| 26 | PRODUCT_ID | Character(18) | VARCHAR2(18) NOT NULL | Product ID |
| 27 | SETID | Character(5) | VARCHAR2(5) NOT NULL | SetID |
| 28 | CONTRACT_NUM | Character(25) | VARCHAR2(25) NOT NULL | Contract |
| 29 | CNTRCT_LINE_NBR | Number(5,0) | INTEGER NOT NULL | Buying Agreement Line Nbr |
| 30 | BUSINESS_UNIT_OM | Character(5) | VARCHAR2(5) NOT NULL | Order Management Business Unit |
| 31 | SRBT_ID | Character(6) | VARCHAR2(6) NOT NULL | Sales Rebate ID |
| 32 | END_DATE | Date(10) | DATE | End Date |