REQ_LINE_SHIP

(SQL Table)
Index Back

Requisition Line Delivery Schd

Requisition Line Schedule Date Initials Issue Description 092107 dh F-AHAYT-95051 PRICE_REQ for ePro change from number to Sign to allow negative

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
2 REQ_ID Character(10) VARCHAR2(10) NOT NULL Requisition ID

Default Value: NEXT

3 LINE_NBR Number(5,0) INTEGER NOT NULL Line Number: 11/24/08 - Added TARGET label [PC product]

Default Value: 1

4 SCHED_NBR Number(3,0) SMALLINT NOT NULL Schedule Number

Default Value: 1

5 DUE_DT Date(10) DATE Specifies the date that a transaction is due. It is a generic field used in multiple PeopleSoft applications including Receivables Payables and Purchasing. For example it represents the date that payment is due for a voucher or the date that a scheduled shipment is due to be received.
6 SHIPTO_SETID Character(5) VARCHAR2(5) NOT NULL ShipTo SetID
7 SHIPTO_ID Character(10) VARCHAR2(10) NOT NULL Ship To Location

Prompt Table: %EDIT_SHIPTO

8 QTY_REQ Number(16,4) DECIMAL(15,4) NOT NULL Requisition Quantity
9 MERCHANDISE_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Merchandise Amt F_KDHIL_R87H8 062804 MLM: Added new Line Amount Received Label
10 DISTRIB_MTHD_FLG Character(1) VARCHAR2(1) NOT NULL Distribute by
A=Amount
Q=Quantity

Default Value: Q

11 LIQUIDATE_METHOD Character(1) VARCHAR2(1) NOT NULL Liquidate by
A=Amount
Q=Quantity

Default Value: A

12 PRICE_REQ Signed Number(17,5) DECIMAL(15,5) NOT NULL Date Initials Issue Description 092107 dh F-AHAYT-95051 ePro change from number to Sign to allow negative
13 BAL_STATUS Character(1) VARCHAR2(1) NOT NULL A flag that indicates whether or not the control totals for a deposit match the entered totals. A deposit is considered "balanced" when the two sets of totals are equal.
I=Balanced
O=Not Balanced

Default Value: I

14 BUSINESS_UNIT_OM Character(5) VARCHAR2(5) NOT NULL Order Management Business Unit
15 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
16 ORDER_INT_LINE_NO Number(5,0) INTEGER NOT NULL Order Line
17 SCHED_LINE_NBR Number(6,0) INTEGER NOT NULL Schedule Line Number
18 SHIP_TO_CUST_ID Character(15) VARCHAR2(15) NOT NULL Ship To Customer
19 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code

Default Value: REQ_HDR.CURRENCY_CD

20 CURRENCY_CD_BASE Character(3) VARCHAR2(3) NOT NULL Business Unit Base Currency

Default Value: REQ_HDR.CURRENCY_CD_BASE

21 PRICE_REQ_BSE Signed Number(17,5) DECIMAL(15,5) NOT NULL Date Initials Issue Description 092107 dh F-AHAYT-95051 ePro change from number to Sign to allow negative
22 MERCH_AMT_BSE Signed Number(28,3) DECIMAL(26,3) NOT NULL Base Merchandise Amount
23 QTY_REQ_STD Number(16,4) DECIMAL(15,4) NOT NULL Quantity Requested Stand. UOM
24 SHIP_TYPE_ID Character(10) VARCHAR2(10) NOT NULL Ship Via Code

Prompt Table: SHIP_METHOD

25 CARRIER_ID Character(10) VARCHAR2(10) NOT NULL Carrier ID
26 UNIT_MEASURE_STD Character(3) VARCHAR2(3) NOT NULL Standard Unit of Measure
27 DUE_TIME Time(15) TIMESTAMP Due Time
28 ZERO_PRICE_IND Character(1) VARCHAR2(1) NOT NULL Zero Price Indicator

Y/N Table Edit

Default Value: N

29 SUT_BASE_ID Character(10) VARCHAR2(10) NOT NULL Sales/Use Tax Destination

Prompt Table: SUT_BASE_VW

30 ULTIMATE_USE_CD Character(8) VARCHAR2(8) NOT NULL Ultimate Use Code

Prompt Table: SUT_USE_CD

31 ATTN_TO Character(30) VARCHAR2(30) NOT NULL Attention
32 REVISION Character(4) VARCHAR2(4) NOT NULL 01/27/2000 RML Added "As of" label

Prompt Table: EN_REV_PO_VW

33 USER_SCHED_CHAR1 Character(1) VARCHAR2(1) NOT NULL Custom Character 1
34 CUSTOM_C100_C1 Character(100) VARCHAR2(100) NOT NULL Custom Field 1
35 CUSTOM_C100_C2 Character(100) VARCHAR2(100) NOT NULL Custom Field 2
36 CUSTOM_C100_C3 Character(100) VARCHAR2(100) NOT NULL Custom Field 3
37 CUSTOM_DATE_C1 Date(10) DATE Custom Date 1
38 CUSTOM_DATE_C2 Date(10) DATE Custom Date 2
39 CUSTOM_C1_C Character(1) VARCHAR2(1) NOT NULL Custom Character 2
40 CHANGE_STATUS Character(1) VARCHAR2(1) NOT NULL Change Order Status
C=Changed
U=Unchanged

Default Value: U

41 CHNG_ORD_SEQ Number(3,0) SMALLINT NOT NULL Change Order Sequence Number
42 CURR_STATUS Character(1) VARCHAR2(1) NOT NULL Current Status
A=Approved
C=Closed
D=Denied
H=Hold
O=Open
P=Pending
X=Canceled

Default Value: A

43 FREIGHT_TERMS Character(10) VARCHAR2(10) NOT NULL Freight Terms Code

Prompt Table: FREIGHT_TERMS