EM_DISC_UPD_AET

(SQL Table)
Index Back

Dynamic Discount update

Dynamic Discount update process AE state record

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance
2 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
3 RUN_CNTL_ID Character(30) VARCHAR2(30) NOT NULL Run Control ID
4 REQUEST_ID Character(10) VARCHAR2(10) NOT NULL Request ID
5 EM_BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL From Business Unit
6 VENDOR_SETID Character(5) VARCHAR2(5) NOT NULL Vendor SetID
7 VENDOR_ID Character(10) VARCHAR2(10) NOT NULL Vendor Identifier
8 VNDR_LOC Character(10) VARCHAR2(10) NOT NULL Vendor Location
9 PROPOSE_ID Character(8) VARCHAR2(8) NOT NULL Propose ID
10 VOUCHER_ID Character(8) VARCHAR2(8) NOT NULL Voucher ID
11 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.
12 BASIS_DATE Date(10) DATE Basis Date
13 PAY_TRM_BSE_DT_OPT Character(1) VARCHAR2(1) NOT NULL Payment Terms Basis Date Type
A=Acct Date
C=Doc Date
I=Inv Date
R=Recpt Date
S=Ship Date
U=User Date
14 DATE1 Date(10) DATE Date
15 DATE_FIELD Character(18) VARCHAR2(18) NOT NULL Date Field
16 UNPOST_FLG Character(1) VARCHAR2(1) NOT NULL Unpost Flag