PYMNT_REMIT_VW (SQL View)	Index Back
AP Manual Payment Entry View

PYMNT_REMIT_VW

(SQL View)

AP Manual Payment Entry View

SELECT a.Remit_Setid , a.Remit_Vendor , a.Vndr_Loc , a.bank_setid , a.bank_cd , a.bank_acct_key , a.pymnt_id , a.pymnt_dt , a.pymnt_method , a.pymnt_handling_cd , a.pymnt_id_ref , a.bank_account_num , a.branch_id , a.check_digit , a.name1 , a.name2 , %subrec(address_sbr,a) , a.creation_dt , a.oprid , a.pymnt_amt , a.currency_pymnt , 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.eft_pymnt_fmt_cd , a.eft_trans_handling , a.dfi_id_qual , a.dfi_id_num , a.rep_rtng_num , a.remit_bank_account , a.remit_branch_id , a.remit_check_digit , a.sttlmnt_dt_est , a.sttlmnt_dt_actual , a.form_nbr_confirmed , a.in_process_flg , a.positive_pay_dt , a.positive_pay_stat , a.micr_line , a.cash_cleared_flg , a.emplid , a.doc_type , a.doc_seq_date , a.doc_seq_nbr , a.doc_seq_status , a.pymnt_type , a.preferred_language , a.descrlong , a.LAST_UPDATE_DTTM , a.SES_LAST_DTTM FROM PS_PAYMENT_TBL a WHERE pymnt_status <> 'X'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

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

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

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

4 BANK_SETID Character(5) VARCHAR2(5) NOT NULL The PeopleSoft tableset ID associated with a given bank/counterparty.

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

6 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_TBL

7 PYMNT_ID Character(10) VARCHAR2(10) NOT NULL Payment Number
Default Value: NEXT

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

9 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
Default Value: MAN

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

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

12 BANK_ACCOUNT_NUM Character(35) VARCHAR2(35) NOT NULL The literal unique identifier associated with a given bank/counterparty account.
Default Value: BANK_ACCT_VW.BANK_ACCOUNT_NUM

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

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

15 NAME1 Character(40) VARCHAR2(40) NOT NULL Name 1
Default Value: REMIT_LOOK_VW.NAME1

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

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

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

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

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

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

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

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

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

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

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

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

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

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

30 STATE Character(6) VARCHAR2(6) NOT NULL State
Prompt Table: %EDIT_STATE

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

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

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

34 CREATION_DT Date(10) DATE Creation Date
Default Value: %date

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

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

37 CURRENCY_PYMNT Character(3) VARCHAR2(3) NOT NULL Payment Currency
Default Value: BANK_ACCT_VW.CURRENCY_CD

38 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
Default Value: P

39 PYMNT_RECONCILE_DT Date(10) DATE Date Reconciled

40 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
Default Value: R

41 CANCEL_DT Date(10) DATE Date Cancelled

42 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

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

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

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

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

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

48 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

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

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

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

52 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

53 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

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

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

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

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

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

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

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

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

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

64 IN_PROCESS_FLG Character(1) VARCHAR2(1) NOT NULL In process flag
Default Value: N

65 POSITIVE_PAY_DT Date(10) DATE Positive Payment Date

66 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

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

68 CASH_CLEARED_FLG Character(1) VARCHAR2(1) NOT NULL Cash Cleared Flag

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

70 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.
Prompt Table: DOC_TYPE_TBL

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

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

73 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

74 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

75 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

76 DESCRLONG Long Character CLOB Long Description

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

78 SES_LAST_DTTM DateTime(26) TIMESTAMP PTSF Last Modified DateTimestamp

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	REMIT_SETID	Character(5)	VARCHAR2(5) NOT NULL	Remit SetID
2	REMIT_VENDOR	Character(10)	VARCHAR2(10) NOT NULL	Remit Vendor
3	VNDR_LOC	Character(10)	VARCHAR2(10) NOT NULL	Vendor Location
4	BANK_SETID	Character(5)	VARCHAR2(5) NOT NULL	The PeopleSoft tableset ID associated with a given bank/counterparty.
5	BANK_CD	Character(5)	VARCHAR2(5) NOT NULL	Bank Code Prompt Table: BANK_CD_TBL
6	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_TBL
7	PYMNT_ID	Character(10)	VARCHAR2(10) NOT NULL	Payment Number Default Value: NEXT
8	PYMNT_DT	Date(10)	DATE	Payment Date Default Value: %date
9	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 Default Value: MAN
10	PYMNT_HANDLING_CD	Character(2)	VARCHAR2(2) NOT NULL	Payment Handling
11	PYMNT_ID_REF	Character(20)	VARCHAR2(20) NOT NULL	Payment Reference
12	BANK_ACCOUNT_NUM	Character(35)	VARCHAR2(35) NOT NULL	The literal unique identifier associated with a given bank/counterparty account. Default Value: BANK_ACCT_VW.BANK_ACCOUNT_NUM
13	BRANCH_ID	Character(10)	VARCHAR2(10) NOT NULL	The local branch office identifier associated with a given bank/counterparty.
14	CHECK_DIGIT	Character(2)	VARCHAR2(2) NOT NULL	Check Digit
15	NAME1	Character(40)	VARCHAR2(40) NOT NULL	Name 1 Default Value: REMIT_LOOK_VW.NAME1
16	NAME2	Character(40)	VARCHAR2(40) NOT NULL	Name 2
17	COUNTRY	Character(3)	VARCHAR2(3) NOT NULL	Country Prompt Table: COUNTRY_TBL
18	ADDRESS1	Character(55)	VARCHAR2(55) NOT NULL	Address 1
19	ADDRESS2	Character(55)	VARCHAR2(55) NOT NULL	Address 2
20	ADDRESS3	Character(55)	VARCHAR2(55) NOT NULL	Address 3
21	ADDRESS4	Character(55)	VARCHAR2(55) NOT NULL	Address 4
22	CITY	Character(30)	VARCHAR2(30) NOT NULL	City
23	NUM1	Character(6)	VARCHAR2(6) NOT NULL	Number 1
24	NUM2	Character(6)	VARCHAR2(6) NOT NULL	Number 2
25	HOUSE_TYPE	Character(2)	VARCHAR2(2) NOT NULL	House Type AB=House Boat WW=Trailer
26	ADDR_FIELD1	Character(2)	VARCHAR2(2) NOT NULL	Address Field 1
27	ADDR_FIELD2	Character(4)	VARCHAR2(4) NOT NULL	Address Field 2
28	ADDR_FIELD3	Character(4)	VARCHAR2(4) NOT NULL	Address Field 3
29	COUNTY	Character(30)	VARCHAR2(30) NOT NULL	County
30	STATE	Character(6)	VARCHAR2(6) NOT NULL	State Prompt Table: %EDIT_STATE
31	POSTAL	Character(12)	VARCHAR2(12) NOT NULL	Postal
32	GEO_CODE	Character(11)	VARCHAR2(11) NOT NULL	Geo Code
33	IN_CITY_LIMIT	Character(1)	VARCHAR2(1) NOT NULL	In City Limit Y/N Table Edit
34	CREATION_DT	Date(10)	DATE	Creation Date Default Value: %date
35	OPRID	Character(30)	VARCHAR2(30) NOT NULL	A user's ID (see PSOPRDEFN).
36	PYMNT_AMT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Payment Amount
37	CURRENCY_PYMNT	Character(3)	VARCHAR2(3) NOT NULL	Payment Currency Default Value: BANK_ACCT_VW.CURRENCY_CD
38	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 Default Value: P
39	PYMNT_RECONCILE_DT	Date(10)	DATE	Date Reconciled
40	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 Default Value: R
41	CANCEL_DT	Date(10)	DATE	Date Cancelled
42	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
43	ACCOUNTING_DT	Date(10)	DATE	The accounting entry construction date for a given transaction (a generic field that crosses multiple
44	POST_STATUS_AP	Character(1)	VARCHAR2(1) NOT NULL	Post Status N=Payment Not Applied P=Posted U=Unposted Default Value: U
45	PROCESS_INSTANCE	Number(10,0)	DECIMAL(10) NOT NULL	Process Instance
46	PAY_CYCLE	Character(6)	VARCHAR2(6) NOT NULL	Pay Cycle
47	PAY_CYCLE_SEQ_NUM	Number(6,0)	INTEGER NOT NULL	Pay Cycle Sequence Number
48	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
49	RECON_CYCLE_NBR	Number(10,0)	DECIMAL(10) NOT NULL	The bank statement ID.
50	RECONCILE_OPRID	Character(30)	VARCHAR2(30) NOT NULL	The user ID that performed the reconciliation for a given transaction.
51	BNK_ID_NBR	Character(20)	VARCHAR2(20) NOT NULL	A literal alphanumeric attribute that uniquely identifies a given bank or counterparty.
52	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
53	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
54	EFT_TRANS_HANDLING	Character(1)	VARCHAR2(1) NOT NULL	Transaction Handling D=Payment Only P=Prenotification X=Payment and Advice
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	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
57	REP_RTNG_NUM	Character(10)	VARCHAR2(10) NOT NULL	Routing Code
58	REMIT_BANK_ACCOUNT	Character(35)	VARCHAR2(35) NOT NULL	Bank Account Number
59	REMIT_BRANCH_ID	Character(10)	VARCHAR2(10) NOT NULL	Branch ID
60	REMIT_CHECK_DIGIT	Character(2)	VARCHAR2(2) NOT NULL	Check Digit
61	STTLMNT_DT_EST	Date(10)	DATE	Date in which a deal transaction is estimated to be settled with a counterparty.
62	STTLMNT_DT_ACTUAL	Date(10)	DATE	Date in which a deal transaction is actually settled with a counterparty.
63	FORM_NBR_CONFIRMED	Character(1)	VARCHAR2(1) NOT NULL	Check Number Confirmed Y/N Table Edit Default Value: Y
64	IN_PROCESS_FLG	Character(1)	VARCHAR2(1) NOT NULL	In process flag Default Value: N
65	POSITIVE_PAY_DT	Date(10)	DATE	Positive Payment Date
66	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
67	MICR_LINE	Character(50)	VARCHAR2(50) NOT NULL	MICR Line
68	CASH_CLEARED_FLG	Character(1)	VARCHAR2(1) NOT NULL	Cash Cleared Flag
69	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID
70	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. Prompt Table: DOC_TYPE_TBL
71	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.
72	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.
73	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
74	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
75	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
76	DESCRLONG	Long Character	CLOB	Long Description
77	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.
78	SES_LAST_DTTM	DateTime(26)	TIMESTAMP	PTSF Last Modified DateTimestamp