PAYMENT_TBL_VW3 (SQL View)	Index Back
Express Check Payment View This view has all the fields of the AP Payment table, except for the long description. This view is used in peoplecode to insert payments into the AP Payment table.

PAYMENT_TBL_VW3

(SQL View)

Express Check Payment View

This view has all the fields of the AP Payment table, except for the long description. This view is used in peoplecode to insert payments into the AP Payment table.

SELECT a.bank_setid , a.bank_cd , a.bank_acct_key , a.pymnt_id , a.pymnt_id_ref , a.bank_account_num , a.branch_id , a.check_digit , a.remit_setid , a.remit_vendor , a.vndr_loc , a.emplid , a.name1 , a.name2 , %subrec(address_sbr,a) , a.pymnt_dt , a.creation_dt , a.oprid , a.pymnt_amt , a.currency_pymnt , a.pymnt_method , a.pymnt_handling_cd , a.pymnt_status , a.pymnt_reconcile_dt , a.cancel_action , a.cancel_dt , a.dft_status , a.accounting_dt , a.post_status_ap , a.process_instance , a.pay_cycle , a.pay_cycle_seq_num , a.recon_type , a.recon_cycle_nbr , a.reconcile_oprid , a.bnk_id_nbr , a.recon_status , a.dfi_id_num , a.dfi_id_qual , a.eft_pymnt_fmt_cd , a.sttlmnt_dt_est , a.sttlmnt_dt_actual , a.eft_trans_handling , a.remit_bank_account , a.remit_branch_id , a.remit_check_digit , a.rep_rtng_num , a.form_nbr_confirmed , a.in_process_flg , a.positive_pay_dt , a.positive_pay_stat , a.micr_line , a.cash_cleared_flg , a.cash_cleared_dt , a.replaced_dt , a.pymnt_type , a.preferred_language , a.doc_type , a.doc_seq_date , a.doc_seq_nbr , a.doc_seq_status , a.LAST_UPDATE_DTTM , a.SES_LAST_DTTM FROM PS_PAYMENT_TBL a

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 BANK_SETID Character(5) VARCHAR2(5) NOT NULL The PeopleSoft tableset ID associated with a given bank/counterparty.
Default Value: OPR_BANK_VW_AP.BANK_SETID

2 BANK_CD Character(5) VARCHAR2(5) NOT NULL Bank Code
Prompt Table: BANK_CD_VW2

3 BANK_ACCT_KEY Character(4) VARCHAR2(4) NOT NULL A user defined unique identifier that facilitates the identification of a given account with a given bank
Prompt Table: BANK_ACCT_VW

4 PYMNT_ID Character(10) VARCHAR2(10) NOT NULL Payment Number

5 PYMNT_ID_REF Character(20) VARCHAR2(20) NOT NULL Payment Reference

6 BANK_ACCOUNT_NUM Character(35) VARCHAR2(35) NOT NULL The literal unique identifier associated with a given bank/counterparty account.

7 BRANCH_ID Character(10) VARCHAR2(10) NOT NULL The local branch office identifier associated with a given bank/counterparty.

8 CHECK_DIGIT Character(2) VARCHAR2(2) NOT NULL Check Digit

9 REMIT_SETID Character(5) VARCHAR2(5) NOT NULL Remit SetID

10 REMIT_VENDOR Character(10) VARCHAR2(10) NOT NULL Remit Vendor

11 VNDR_LOC Character(10) VARCHAR2(10) NOT NULL Vendor Location

12 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID

13 NAME1 Character(40) VARCHAR2(40) NOT NULL Name 1
Default Value: VENDOR_ADDR.NAME1

14 NAME2 Character(40) VARCHAR2(40) NOT NULL Name 2

15 COUNTRY Character(3) VARCHAR2(3) NOT NULL Country
Prompt Table: COUNTRY_TBL

16 ADDRESS1 Character(55) VARCHAR2(55) NOT NULL Address 1

17 ADDRESS2 Character(55) VARCHAR2(55) NOT NULL Address 2

18 ADDRESS3 Character(55) VARCHAR2(55) NOT NULL Address 3

19 ADDRESS4 Character(55) VARCHAR2(55) NOT NULL Address 4

20 CITY Character(30) VARCHAR2(30) NOT NULL City

21 NUM1 Character(6) VARCHAR2(6) NOT NULL Number 1

22 NUM2 Character(6) VARCHAR2(6) NOT NULL Number 2

23 HOUSE_TYPE Character(2) VARCHAR2(2) NOT NULL House Type
AB=House Boat
WW=Trailer

24 ADDR_FIELD1 Character(2) VARCHAR2(2) NOT NULL Address Field 1

25 ADDR_FIELD2 Character(4) VARCHAR2(4) NOT NULL Address Field 2

26 ADDR_FIELD3 Character(4) VARCHAR2(4) NOT NULL Address Field 3

27 COUNTY Character(30) VARCHAR2(30) NOT NULL County

28 STATE Character(6) VARCHAR2(6) NOT NULL State
Prompt Table: STATE_TBL

29 POSTAL Character(12) VARCHAR2(12) NOT NULL Postal

30 GEO_CODE Character(11) VARCHAR2(11) NOT NULL Geo Code

31 IN_CITY_LIMIT Character(1) VARCHAR2(1) NOT NULL In City Limit
Y/N Table Edit

32 PYMNT_DT Date(10) DATE Payment Date
Default Value: %date

33 CREATION_DT Date(10) DATE Creation Date

34 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).

35 PYMNT_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Payment Amount

36 CURRENCY_PYMNT Character(3) VARCHAR2(3) NOT NULL Payment Currency
Prompt Table: CURR_PYMNT_VW

37 PYMNT_METHOD Character(3) VARCHAR2(3) NOT NULL Payment Method
ACH=Automated Clearing House
BEF=Draft - Customer EFT
BOO=Draft - Customer Initiated
CHK=System Check
D=Deposit
DD=Direct Debit
DFT=Draft - Supplier Initiated
DRA=Draft
EFT=Electronic Funds Transfer
GE=Giro - EFT
GM=Giro - Manual
LC=Letter of Credit
MAN=Manual Check
TRW=Treasury Wire
WIR=Wire Transfer

38 PYMNT_HANDLING_CD Character(2) VARCHAR2(2) NOT NULL Payment Handling

39 PYMNT_STATUS Character(1) VARCHAR2(1) NOT NULL Payment Status
A=Alignment
E=ACH/EFT Prenote
L=Stale Dated Payment
N=Reprinted with same ref number
O=Overflow
P=Paid
R=Replaced
S=Stopped
T=Undo Escheatment
U=Undo Cancel
V=Void
W=Escheated Check
X=Deleted

40 PYMNT_RECONCILE_DT Date(10) DATE Date Reconciled

41 CANCEL_ACTION Character(1) VARCHAR2(1) NOT NULL Cancel Action
C=Do Not Reissue/Close Liability
H=Re-Open Voucher(s)/Put on Hold
N=No Cancel Action
P=Processed
R=Re-Open Voucher(s)/Re-Issue
S=Stale Dated Check
W=Escheated

42 CANCEL_DT Date(10) DATE Date Cancelled

43 DFT_STATUS Character(1) VARCHAR2(1) NOT NULL Draft Payment Status
A=Approved
C=Created
D=Due
N=Non-Draft Payment
R=Reconciled
W=Write Off
X=Write Off Posted

44 ACCOUNTING_DT Date(10) DATE The accounting entry construction date for a given transaction (a generic field that crosses multiple

45 POST_STATUS_AP Character(1) VARCHAR2(1) NOT NULL Post Status
N=Payment Not Applied
P=Posted
U=Unposted
Default Value: U

46 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance

47 PAY_CYCLE Character(6) VARCHAR2(6) NOT NULL Pay Cycle

48 PAY_CYCLE_SEQ_NUM Number(6,0) INTEGER NOT NULL Pay Cycle Sequence Number

49 RECON_TYPE Character(1) VARCHAR2(1) NOT NULL Represents a series of options as to how a treasury wishes to perform reconciliation for a given bank
A=Automatically Reconciled
B=Balance System(s) to BankTran
F=Forced to Reconcile
M=Manually Reconciled
S=Semi Manual
U=Unreconciled
Default Value: U

50 RECON_CYCLE_NBR Number(10,0) DECIMAL(10) NOT NULL The bank statement ID.

51 RECONCILE_OPRID Character(30) VARCHAR2(30) NOT NULL The user ID that performed the reconciliation for a given transaction.

52 BNK_ID_NBR Character(20) VARCHAR2(20) NOT NULL A literal alphanumeric attribute that uniquely identifies a given bank or counterparty.

53 RECON_STATUS Character(3) VARCHAR2(3) NOT NULL Reconciliation Status
ALG=Alignment Check
AMB=Ambiguous Match
AMT=Amounts Not Equal
CUR=Currency not Defined
DAT=Tran Date <> Value Date
DPI=Duplicate Input Transactions
DUP=Duplicate Transaction
MSC=Miscellaneous Transaction
NAM=Payee Names Not Equal
NTB=Not Found in Statement
NTF=Not Found In System
NTP=Not Found in POS Data
NUL=Null Transaction ID Ref
OVR=Overflow
PND=Pending Reconciliation
REC=Reconciled
RPR=Reprinted Check
RR=Requires Review - BSAC
STP=Stop Payment
TYP=Wrong Transaction Type
UNR=Unreconciled
VOI=Voided Check

54 DFI_ID_NUM Character(12) VARCHAR2(12) NOT NULL A banking industry convention identifier utilized to drive electronic settlements processing for a given bank/coun

55 DFI_ID_QUAL Character(2) VARCHAR2(2) NOT NULL A banking industry convention identifier utilized to drive data validation for a given bank/counterparty.
01=Transit Number
02=Swift ID/BIC
03=CHIPS Participant ID
04=Canadian Bank Branch/Institute
05=CHIPS Universal ID
ZZ=Mutually Defined

56 EFT_PYMNT_FMT_CD Character(3) VARCHAR2(3) NOT NULL Payment Format
00=Standard SWIFT transfer
10=Urgent SWIFT
15=Euro-Transfer
21=Check, w/ receipt confirmation
22=Check, Urgent
23=Check, urgent w/ receipt
40=Postal Order
CTX=Corp Trade Exchange
PBC=Check, standard
PPD=Prearranged Pay & Deposit
WRT=Wire Transfer
Prompt Table: PYMNT_FMT_TBL

57 STTLMNT_DT_EST Date(10) DATE Date in which a deal transaction is estimated to be settled with a counterparty.

58 STTLMNT_DT_ACTUAL Date(10) DATE Date in which a deal transaction is actually settled with a counterparty.

59 EFT_TRANS_HANDLING Character(1) VARCHAR2(1) NOT NULL Transaction Handling
D=Payment Only
P=Prenotification
X=Payment and Advice

60 REMIT_BANK_ACCOUNT Character(35) VARCHAR2(35) NOT NULL Bank Account Number

61 REMIT_BRANCH_ID Character(10) VARCHAR2(10) NOT NULL Branch ID

62 REMIT_CHECK_DIGIT Character(2) VARCHAR2(2) NOT NULL Check Digit

63 REP_RTNG_NUM Character(10) VARCHAR2(10) NOT NULL Routing Code

64 FORM_NBR_CONFIRMED Character(1) VARCHAR2(1) NOT NULL Check Number Confirmed
Y/N Table Edit
Default Value: Y

65 IN_PROCESS_FLG Character(1) VARCHAR2(1) NOT NULL In process flag
Y/N Table Edit
Default Value: N

66 POSITIVE_PAY_DT Date(10) DATE Positive Payment Date

67 POSITIVE_PAY_STAT Character(1) VARCHAR2(1) NOT NULL Positive Payment Status
C=Sent to bank
N=Not Sent to bank
S=Selected for transmission
Z=Zero Payment
Default Value: N

68 MICR_LINE Character(50) VARCHAR2(50) NOT NULL MICR Line

69 CASH_CLEARED_FLG Character(1) VARCHAR2(1) NOT NULL Cash Cleared Flag
Y/N Table Edit
Default Value: N

70 CASH_CLEARED_DT Date(10) DATE Cash Cleared Date

71 REPLACED_DT Date(10) DATE Replacement Date

72 PYMNT_TYPE Character(1) VARCHAR2(1) NOT NULL Document Type
E=Express Payment
M=Manual Payment
R=Regular payment
W=Withholding Payment
Z=Zero Payment Check

73 PREFERRED_LANGUAGE Character(3) VARCHAR2(3) NOT NULL Preferred Language
ARA=Arabic
CFR=Canadian French
CZE=Czech
DAN=Danish
DUT=Dutch
E=English
ENG=English
ESP=Spanish
F=French
FIN=Finnish
FRA=French
GER=German
HUN=Hungarian
INE=International English
ITA=Italian
JPN=Japanese
KOR=Korean
NOR=Norwegian
POL=Polish
POR=Portuguese
RUS=Russian
SVE=Swedish
THA=Thai
UKE=UK English
ZHS=Simplified Chinese
ZHT=Traditional Chinese

74 DOC_TYPE Character(8) VARCHAR2(8) NOT NULL Specifies the business purpose of a financial transaction in countries that require all financial transactions to be tracked as "documents". A Document Type is associated with one and only one Journal Code.

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

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

77 DOC_SEQ_STATUS Character(1) VARCHAR2(1) NOT NULL A flag that indicates a document sequencing error. If there is no error the field is blank and document is considered valid for posting.
1=Document Sequencing Disabled
A=GL BU Undefined
B=GL BU Blank
C=Accounting Date blank
D=Doc Type Blank
E=Jrnl Type, Code, Doc Undefine
F=Sequence Range Undefine
G=Max. Sequence Number Reached
H=Manual Nbr for Auto Doc Type
I=No Manual Number Entered
J=Duplicate Manual Number
K=Invalid Ledger
L=Invalid Ledger Group
N=No Status

78 LAST_UPDATE_DTTM DateTime(26) TIMESTAMP Specifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.

79 SES_LAST_DTTM DateTime(26) TIMESTAMP PTSF Last Modified DateTimestamp

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	BANK_SETID	Character(5)	VARCHAR2(5) NOT NULL	The PeopleSoft tableset ID associated with a given bank/counterparty. Default Value: OPR_BANK_VW_AP.BANK_SETID
2	BANK_CD	Character(5)	VARCHAR2(5) NOT NULL	Bank Code Prompt Table: BANK_CD_VW2
3	BANK_ACCT_KEY	Character(4)	VARCHAR2(4) NOT NULL	A user defined unique identifier that facilitates the identification of a given account with a given bank Prompt Table: BANK_ACCT_VW
4	PYMNT_ID	Character(10)	VARCHAR2(10) NOT NULL	Payment Number
5	PYMNT_ID_REF	Character(20)	VARCHAR2(20) NOT NULL	Payment Reference
6	BANK_ACCOUNT_NUM	Character(35)	VARCHAR2(35) NOT NULL	The literal unique identifier associated with a given bank/counterparty account.
7	BRANCH_ID	Character(10)	VARCHAR2(10) NOT NULL	The local branch office identifier associated with a given bank/counterparty.
8	CHECK_DIGIT	Character(2)	VARCHAR2(2) NOT NULL	Check Digit
9	REMIT_SETID	Character(5)	VARCHAR2(5) NOT NULL	Remit SetID
10	REMIT_VENDOR	Character(10)	VARCHAR2(10) NOT NULL	Remit Vendor
11	VNDR_LOC	Character(10)	VARCHAR2(10) NOT NULL	Vendor Location
12	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID
13	NAME1	Character(40)	VARCHAR2(40) NOT NULL	Name 1 Default Value: VENDOR_ADDR.NAME1
14	NAME2	Character(40)	VARCHAR2(40) NOT NULL	Name 2
15	COUNTRY	Character(3)	VARCHAR2(3) NOT NULL	Country Prompt Table: COUNTRY_TBL
16	ADDRESS1	Character(55)	VARCHAR2(55) NOT NULL	Address 1
17	ADDRESS2	Character(55)	VARCHAR2(55) NOT NULL	Address 2
18	ADDRESS3	Character(55)	VARCHAR2(55) NOT NULL	Address 3
19	ADDRESS4	Character(55)	VARCHAR2(55) NOT NULL	Address 4
20	CITY	Character(30)	VARCHAR2(30) NOT NULL	City
21	NUM1	Character(6)	VARCHAR2(6) NOT NULL	Number 1
22	NUM2	Character(6)	VARCHAR2(6) NOT NULL	Number 2
23	HOUSE_TYPE	Character(2)	VARCHAR2(2) NOT NULL	House Type AB=House Boat WW=Trailer
24	ADDR_FIELD1	Character(2)	VARCHAR2(2) NOT NULL	Address Field 1
25	ADDR_FIELD2	Character(4)	VARCHAR2(4) NOT NULL	Address Field 2
26	ADDR_FIELD3	Character(4)	VARCHAR2(4) NOT NULL	Address Field 3
27	COUNTY	Character(30)	VARCHAR2(30) NOT NULL	County
28	STATE	Character(6)	VARCHAR2(6) NOT NULL	State Prompt Table: STATE_TBL
29	POSTAL	Character(12)	VARCHAR2(12) NOT NULL	Postal
30	GEO_CODE	Character(11)	VARCHAR2(11) NOT NULL	Geo Code
31	IN_CITY_LIMIT	Character(1)	VARCHAR2(1) NOT NULL	In City Limit Y/N Table Edit
32	PYMNT_DT	Date(10)	DATE	Payment Date Default Value: %date
33	CREATION_DT	Date(10)	DATE	Creation Date
34	OPRID	Character(30)	VARCHAR2(30) NOT NULL	A user's ID (see PSOPRDEFN).
35	PYMNT_AMT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Payment Amount
36	CURRENCY_PYMNT	Character(3)	VARCHAR2(3) NOT NULL	Payment Currency Prompt Table: CURR_PYMNT_VW
37	PYMNT_METHOD	Character(3)	VARCHAR2(3) NOT NULL	Payment Method ACH=Automated Clearing House BEF=Draft - Customer EFT BOO=Draft - Customer Initiated CHK=System Check D=Deposit DD=Direct Debit DFT=Draft - Supplier Initiated DRA=Draft EFT=Electronic Funds Transfer GE=Giro - EFT GM=Giro - Manual LC=Letter of Credit MAN=Manual Check TRW=Treasury Wire WIR=Wire Transfer
38	PYMNT_HANDLING_CD	Character(2)	VARCHAR2(2) NOT NULL	Payment Handling
39	PYMNT_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Payment Status A=Alignment E=ACH/EFT Prenote L=Stale Dated Payment N=Reprinted with same ref number O=Overflow P=Paid R=Replaced S=Stopped T=Undo Escheatment U=Undo Cancel V=Void W=Escheated Check X=Deleted
40	PYMNT_RECONCILE_DT	Date(10)	DATE	Date Reconciled
41	CANCEL_ACTION	Character(1)	VARCHAR2(1) NOT NULL	Cancel Action C=Do Not Reissue/Close Liability H=Re-Open Voucher(s)/Put on Hold N=No Cancel Action P=Processed R=Re-Open Voucher(s)/Re-Issue S=Stale Dated Check W=Escheated
42	CANCEL_DT	Date(10)	DATE	Date Cancelled
43	DFT_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Draft Payment Status A=Approved C=Created D=Due N=Non-Draft Payment R=Reconciled W=Write Off X=Write Off Posted
44	ACCOUNTING_DT	Date(10)	DATE	The accounting entry construction date for a given transaction (a generic field that crosses multiple
45	POST_STATUS_AP	Character(1)	VARCHAR2(1) NOT NULL	Post Status N=Payment Not Applied P=Posted U=Unposted Default Value: U
46	PROCESS_INSTANCE	Number(10,0)	DECIMAL(10) NOT NULL	Process Instance
47	PAY_CYCLE	Character(6)	VARCHAR2(6) NOT NULL	Pay Cycle
48	PAY_CYCLE_SEQ_NUM	Number(6,0)	INTEGER NOT NULL	Pay Cycle Sequence Number
49	RECON_TYPE	Character(1)	VARCHAR2(1) NOT NULL	Represents a series of options as to how a treasury wishes to perform reconciliation for a given bank A=Automatically Reconciled B=Balance System(s) to BankTran F=Forced to Reconcile M=Manually Reconciled S=Semi Manual U=Unreconciled Default Value: U
50	RECON_CYCLE_NBR	Number(10,0)	DECIMAL(10) NOT NULL	The bank statement ID.
51	RECONCILE_OPRID	Character(30)	VARCHAR2(30) NOT NULL	The user ID that performed the reconciliation for a given transaction.
52	BNK_ID_NBR	Character(20)	VARCHAR2(20) NOT NULL	A literal alphanumeric attribute that uniquely identifies a given bank or counterparty.
53	RECON_STATUS	Character(3)	VARCHAR2(3) NOT NULL	Reconciliation Status ALG=Alignment Check AMB=Ambiguous Match AMT=Amounts Not Equal CUR=Currency not Defined DAT=Tran Date <> Value Date DPI=Duplicate Input Transactions DUP=Duplicate Transaction MSC=Miscellaneous Transaction NAM=Payee Names Not Equal NTB=Not Found in Statement NTF=Not Found In System NTP=Not Found in POS Data NUL=Null Transaction ID Ref OVR=Overflow PND=Pending Reconciliation REC=Reconciled RPR=Reprinted Check RR=Requires Review - BSAC STP=Stop Payment TYP=Wrong Transaction Type UNR=Unreconciled VOI=Voided Check
54	DFI_ID_NUM	Character(12)	VARCHAR2(12) NOT NULL	A banking industry convention identifier utilized to drive electronic settlements processing for a given bank/coun
55	DFI_ID_QUAL	Character(2)	VARCHAR2(2) NOT NULL	A banking industry convention identifier utilized to drive data validation for a given bank/counterparty. 01=Transit Number 02=Swift ID/BIC 03=CHIPS Participant ID 04=Canadian Bank Branch/Institute 05=CHIPS Universal ID ZZ=Mutually Defined
56	EFT_PYMNT_FMT_CD	Character(3)	VARCHAR2(3) NOT NULL	Payment Format 00=Standard SWIFT transfer 10=Urgent SWIFT 15=Euro-Transfer 21=Check, w/ receipt confirmation 22=Check, Urgent 23=Check, urgent w/ receipt 40=Postal Order CTX=Corp Trade Exchange PBC=Check, standard PPD=Prearranged Pay & Deposit WRT=Wire Transfer Prompt Table: PYMNT_FMT_TBL
57	STTLMNT_DT_EST	Date(10)	DATE	Date in which a deal transaction is estimated to be settled with a counterparty.
58	STTLMNT_DT_ACTUAL	Date(10)	DATE	Date in which a deal transaction is actually settled with a counterparty.
59	EFT_TRANS_HANDLING	Character(1)	VARCHAR2(1) NOT NULL	Transaction Handling D=Payment Only P=Prenotification X=Payment and Advice
60	REMIT_BANK_ACCOUNT	Character(35)	VARCHAR2(35) NOT NULL	Bank Account Number
61	REMIT_BRANCH_ID	Character(10)	VARCHAR2(10) NOT NULL	Branch ID
62	REMIT_CHECK_DIGIT	Character(2)	VARCHAR2(2) NOT NULL	Check Digit
63	REP_RTNG_NUM	Character(10)	VARCHAR2(10) NOT NULL	Routing Code
64	FORM_NBR_CONFIRMED	Character(1)	VARCHAR2(1) NOT NULL	Check Number Confirmed Y/N Table Edit Default Value: Y
65	IN_PROCESS_FLG	Character(1)	VARCHAR2(1) NOT NULL	In process flag Y/N Table Edit Default Value: N
66	POSITIVE_PAY_DT	Date(10)	DATE	Positive Payment Date
67	POSITIVE_PAY_STAT	Character(1)	VARCHAR2(1) NOT NULL	Positive Payment Status C=Sent to bank N=Not Sent to bank S=Selected for transmission Z=Zero Payment Default Value: N
68	MICR_LINE	Character(50)	VARCHAR2(50) NOT NULL	MICR Line
69	CASH_CLEARED_FLG	Character(1)	VARCHAR2(1) NOT NULL	Cash Cleared Flag Y/N Table Edit Default Value: N
70	CASH_CLEARED_DT	Date(10)	DATE	Cash Cleared Date
71	REPLACED_DT	Date(10)	DATE	Replacement Date
72	PYMNT_TYPE	Character(1)	VARCHAR2(1) NOT NULL	Document Type E=Express Payment M=Manual Payment R=Regular payment W=Withholding Payment Z=Zero Payment Check
73	PREFERRED_LANGUAGE	Character(3)	VARCHAR2(3) NOT NULL	Preferred Language ARA=Arabic CFR=Canadian French CZE=Czech DAN=Danish DUT=Dutch E=English ENG=English ESP=Spanish F=French FIN=Finnish FRA=French GER=German HUN=Hungarian INE=International English ITA=Italian JPN=Japanese KOR=Korean NOR=Norwegian POL=Polish POR=Portuguese RUS=Russian SVE=Swedish THA=Thai UKE=UK English ZHS=Simplified Chinese ZHT=Traditional Chinese
74	DOC_TYPE	Character(8)	VARCHAR2(8) NOT NULL	Specifies the business purpose of a financial transaction in countries that require all financial transactions to be tracked as "documents". A Document Type is associated with one and only one Journal Code.
75	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.
76	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.
77	DOC_SEQ_STATUS	Character(1)	VARCHAR2(1) NOT NULL	A flag that indicates a document sequencing error. If there is no error the field is blank and document is considered valid for posting. 1=Document Sequencing Disabled A=GL BU Undefined B=GL BU Blank C=Accounting Date blank D=Doc Type Blank E=Jrnl Type, Code, Doc Undefine F=Sequence Range Undefine G=Max. Sequence Number Reached H=Manual Nbr for Auto Doc Type I=No Manual Number Entered J=Duplicate Manual Number K=Invalid Ledger L=Invalid Ledger Group N=No Status
78	LAST_UPDATE_DTTM	DateTime(26)	TIMESTAMP	Specifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.
79	SES_LAST_DTTM	DateTime(26)	TIMESTAMP	PTSF Last Modified DateTimestamp