EM_PROPOSAL_HDR(SQL Table) |
Index Back |
|---|---|
Dynamic Discount Proposal HeadDynamic Discount Proposal Header |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  EM_BUSINESS_UNIT |
Character(5) | VARCHAR2(5) NOT NULL |
From Business Unit
Prompt Table: EM_BU_VNAGRT_VW |
| 2 | VENDOR_SETID |
Character(5) | VARCHAR2(5) NOT NULL |
Vendor SetID
Default Value: OPR_DEF_TBL_FS.SETID |
| 3 | VENDOR_ID |
Character(10) | VARCHAR2(10) NOT NULL | Vendor Identifier |
| 4 | VNDR_LOC |
Character(10) | VARCHAR2(10) NOT NULL | Vendor Location |
| 5 | PROPOSE_ID |
Character(8) | VARCHAR2(8) NOT NULL |
Propose ID
Default Value: NEXT |
| 6 | PROPOSE_TYPE |
Character(1) | VARCHAR2(1) NOT NULL |
Proposal Type
O=Buyer Offer P=Supplier Proposal |
| 7 | CREATE_DATE | Date(10) | DATE |
Creation Date
Default Value: %DATE |
| 8 | PROPOSAL_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Proposal Status:
A=Approved C=Cancelled D=Denied P=Pending S=Submitted Default Value: P |
| 9 | 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.
Prompt Table: PYMT_TRMS_VW |
| 10 | DUE_DATE | Date(10) | DATE | Delivery Due Date from PO |
| 11 | EXPIRATION_DATE | Date(10) | DATE |
Expiration Date
Default Value: %DATE |
| 12 | NEW_TOT_DISC_AMT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | New Amount |
| 13 | NEW_TOT_SETL_AMT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | New Amount |
| 14 | CUR_TOT_DISC_AMT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Current total discount amount |
| 15 | CUR_TOT_INV_AMT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Current total invoice amount |
| 16 | CUR_TOT_SETL_AMT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Current total settlement amount |
| 17 | TOT_DISC_DIFF_AMT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Total discount differenct amounts |
| 18 | BASIS_DATE | Date(10) | DATE |
Basis Date
Default Value: %DATE |
| 19 | TOT_INTEREST_AMT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Total potential interest amounts earned |
| 20 | TOT_GAIN_LOSS | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Total gain or loss of potential total interest earned |
| 21 | DSCNT_DUE_DT | Date(10) | DATE | Discount Due Date |
| 22 | INTEREST_RATE | Number(9,5) | DECIMAL(8,5) NOT NULL | Interest Rate |
| 23 | CURRENCY_CD | Character(3) | VARCHAR2(3) NOT NULL | Currency Code |
| 24 | COMMENT1 | Character(254) | VARCHAR2(254) NOT NULL | Comments |