VCHR_MMT_TMP2

(SQL Table)
Index Back

Vchr Mass Maint Srch/Sel Tmp2

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance
2 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).

Default Value: OPR_DEF_TBL_FS.OPRID

3 RUN_CNTL_ID Character(30) VARCHAR2(30) NOT NULL Run Control ID
4 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
5 VOUCHER_ID Character(8) VARCHAR2(8) NOT NULL Voucher ID
6 BUSINESS_UNIT_GL Character(5) VARCHAR2(5) NOT NULL GL Business Unit
7 PYMNT_CNT_TOTAL Number(5,0) INTEGER NOT NULL Total Payment Count
8 VCHR_LINE_APPR Character(1) VARCHAR2(1) NOT NULL Invoice Line Approval Status
0=Line Routing Not Required
1=Completed
2=Routed for Approval
9 POST_STATUS_AP Character(1) VARCHAR2(1) NOT NULL Post Status
N=Payment Not Applied
P=Posted
U=Unposted
10 ACCOUNTING_DT Date(10) DATE The accounting entry construction date for a given transaction (a generic field that crosses multiple
11 DOC_SEQ_NBR Character(12) VARCHAR2(12) NOT NULL Specifies the sequence number assigned to each financial transaction (a document). The sequence number may be manually entered or system-generated.
12 DOC_SEQ_DATE Date(10) DATE Specifies the date that a document sequence number is assigned to a document or the date the document was created.