ORD_SSRC_HDR

(SQL Table)
Index Back

Supply Source Header Record

Supply Source Header Record

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit

Prompt Table: BUS_UNIT_TBL_OM

2 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
3 SSRC_BUS_UNIT Character(5) VARCHAR2(5) NOT NULL Supply Source business unit

Prompt Table: SP_BU_PM_NONVW

4 TRFT_SRC_TYPE Character(1) VARCHAR2(1) NOT NULL Alternate Source Type
0=All Sources
1=Inventory Business Unit
2=Distribution Network
3=New Requisition
4=New Purchase Order
5=Existing Requisition
6=Existing Purchase Order
7=Existing Interunit Transfer
8=Existing Production Order
9=New Production Order
5 SSRC_KEY2 Character(30) VARCHAR2(30) NOT NULL Supply Source key
6 VNDR_LOC Character(10) VARCHAR2(10) NOT NULL Vendor Location

Prompt Table: VNDR_LOC_VW1

7 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.

Default Value: %date

8 BUYER_ID Character(30) VARCHAR2(30) NOT NULL Buyer
9 TRFT_DISPOSITION Character(1) VARCHAR2(1) NOT NULL Supply Source disposition
1=Direct Ship
2=Direct Receipt
10 SHIP_TYPE_ID Character(10) VARCHAR2(10) NOT NULL Ship Via Code
11 FREIGHT_TERMS Character(10) VARCHAR2(10) NOT NULL Freight Terms Code
12 CARRIER_ID Character(10) VARCHAR2(10) NOT NULL Carrier ID