IN_TMS_H_N_TBL

(SQL Table)

# 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 SEQ_NBR Number(15,0) DECIMAL(15) NOT NULL Sequence Number

5 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

6 ORD_NOTE_TYPE Character(1) VARCHAR2(1) NOT NULL Order Note Flag

7 TEXT254 Character(254) VARCHAR2(254) NOT NULL Text

8 IN_PROCESS_FLG Character(1) VARCHAR2(1) NOT NULL In process flag

9 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

#	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	SEQ_NBR	Number(15,0)	DECIMAL(15) NOT NULL	Sequence Number
5	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
6	ORD_NOTE_TYPE	Character(1)	VARCHAR2(1) NOT NULL	Order Note Flag
7	TEXT254	Character(254)	VARCHAR2(254) NOT NULL	Text
8	IN_PROCESS_FLG	Character(1)	VARCHAR2(1) NOT NULL	In process flag
9	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