BCT_GRP_AET

(SQL Table)
Index Back

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance
2 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit

Prompt Table: SP_BUIN_OPRVW

3 EIP_CTL_ID Character(25) VARCHAR2(25) NOT NULL Enterprise Components EIP (enterprise integration point) control field
4 SEQ_NBR Number(15,0) DECIMAL(15) NOT NULL Sequence Number
5 TRANSACTION_CODE Character(4) VARCHAR2(4) NOT NULL Transaction Code
6 BCT_DET_STATUS Character(1) VARCHAR2(1) NOT NULL BCTP Detail Status
0=Open
1=Error
2=Complete
3=Cancel

Default Value: 0

7 SHIP_DATE Date(10) DATE Item Shipping Date
8 SHIP_TIME Time(15) TIMESTAMP Ship Time
9 DEMAND_SOURCE Character(2) VARCHAR2(2) NOT NULL Demand Source
IN=Material Request
OM=Sales Order
PL=Planning Requisition
PO=Purchase Order
PR=Purchasing Requisition
RT=Material Return
SF=Production Request
WM=Work Order
10 SOURCE_BUS_UNIT Character(5) VARCHAR2(5) NOT NULL Source Bus Unit
11 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
12 CARRIER_ID Character(10) VARCHAR2(10) NOT NULL Carrier ID
13 BILL_OF_LADING Character(30) VARCHAR2(30) NOT NULL Specifies a bill of lading number associated with a Receivables item.
14 PICK_BATCH_ID Number(10,0) DECIMAL(10) NOT NULL Pick Batch ID
15 PICKLIST_LINE_NO Number(7,0) INTEGER NOT NULL Pick List Sorting Line Number
16 SHIP_CNTR_ID Character(20) VARCHAR2(20) NOT NULL Shipping Container ID
17 LOCATION_ID Character(3) VARCHAR2(3) NOT NULL Location ID
18 SHIP_TO_CUST_ID Character(15) VARCHAR2(15) NOT NULL Ship To Customer
19 LOAD_ID Character(10) VARCHAR2(10) NOT NULL Load ID
20 PICK_BATCH_FROM Number(10,0) DECIMAL(10) NOT NULL From Pick Batch ID
21 PICK_BATCH_TO Number(10,0) DECIMAL(10) NOT NULL To Pick Batch ID
22 ROUTE_CD Character(6) VARCHAR2(6) NOT NULL A unique identifier assigned to a delivery route. Route codes can be associated with customer addresses for external orders or locations for internal orders. Route codes can be used to identify the appropriate delivery schedule for a customer/location if you are managing product shipments with your own vehicles.
23 WAVE_CD Character(6) VARCHAR2(6) NOT NULL A unique identifier used to group together one or more delivery route codes.
24 TO_CARRIER_ID Character(10) VARCHAR2(10) NOT NULL Carrier selection
25 TO_SHIP_TYPE_ID Character(10) VARCHAR2(10) NOT NULL Ship Via selection
26 TO_BILL_OF_LADING Character(30) VARCHAR2(30) NOT NULL Specifies a bill of lading number associated with a Receivables item.
27 TO_PRO_NUMBER Character(30) VARCHAR2(30) NOT NULL Pro Number
28 TO_FREIGHT_TERMS Character(10) VARCHAR2(10) NOT NULL Freight Terms Code