IN_TMS_L_N_EVW

(SQL View)
 Index Back

TMS Load Line Note

Transportation Management System (TMS) Load Notification Line Note

SELECT A.PROCESS_INSTANCE , A.BUSINESS_UNIT , A.TMS_EXT_REF_ID , A.TMS_EXT_REF_LN_NBR , A.SEQ_NBR , A.IN_PROCESS_FLG , A.AUDIT_ACTN , A.DOCUMENT_CD , A.ORD_NOTE_TYPE , A.TEXT254 FROM PS_IN_TMS_L_N_TBL A

# 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
3 TMS_EXT_REF_ID Character(10) VARCHAR2(10) NOT NULL TMS Reference ID
4 TMS_EXT_REF_LN_NBR Number(7,0) INTEGER NOT NULL TMS Line Number
5 SEQ_NBR Number(15,0) DECIMAL(15) NOT NULL Sequence Number
6 IN_PROCESS_FLG Character(1) VARCHAR2(1) NOT NULL In process flag
7 AUDIT_ACTN Character(1) VARCHAR2(1) NOT NULL Audit Action Code for Application Messages. This tells the subscriber whether the row has been added, changed, or deleted.
A=Add
C=Change Old (PPR Only)
D=Delete
K=Change - Old Values
N=Change - New Values
O=Change - Original Values
8 DOCUMENT_CD Character(4) VARCHAR2(4) NOT NULL Document Code
ACKN=Order Acknowledgment
ASN=Advance Shipping Notification
BOL=Bill of Lading
CACK=Order Change Acknowledgement
CREN=Buying Agreement Renewal
CSTS=Buying Agreement Status
INCC=Invoice Courtesy Copy
INVC=Invoice
INVN=Invoice Notification
PACK=Packing List
PICK=Picking Plan
PPRC=Product Price List
PRAD=Payment Remittance Advice
QUOT=Quotation
RMA=Return Material Authorization
9 ORD_NOTE_TYPE Character(1) VARCHAR2(1) NOT NULL Order Note Flag
10 TEXT254 Character(254) VARCHAR2(254) NOT NULL Text