| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 BUSINESS_UNIT |
Character(5) |
VARCHAR2(5) NOT NULL |
Business Unit
Default Value: OPR_DEF_TBL_CS.BUSINESS_UNIT
Prompt Table:
SP_BU_SF_NONVW
|
| 2 |
CASHIER_OFFICE |
Character(8) |
VARCHAR2(8) NOT NULL |
Cashier's Office
Default Value: OPR_DEF_TBL_CS.CASHIER_OFFICE
Prompt Table:
SP_CSHOFF_NONVW
|
| 3 |
RECEIPT_NBR |
Number(12,0) |
DECIMAL(12) NOT NULL |
Receipt Number
Default Value: 999999999999
|
| 4 |
CURRENT_BUS_DT |
Date(10) |
DATE |
Current Business Date
|
| 5 |
CASHIER |
Character(30) |
VARCHAR2(30) NOT NULL |
Cashier
|
| 6 |
SF_REGISTER |
Character(5) |
VARCHAR2(5) NOT NULL |
Cash Register
|
| 7 |
EMPLID |
Character(11) |
VARCHAR2(11) NOT NULL |
Employee ID
Prompt Table:
PEOPLE_SRCH
|
| 8 |
CO_TRANS_TYPE |
Character(2) |
VARCHAR2(2) NOT NULL |
Cashier Office Trans Type
01=Open Register
02=Student Payment
03=Departmental Receipt
04=Cash Check
05=Cash Withdrawl
06=Close Register
07=Interim Deposit
08=Corporate Payment
09=Cash Replenishment
|
| 9 |
TOTAL_AMOUNT_SF |
Signed Number(17,2) |
DECIMAL(15,2) NOT NULL |
Total Amount
|
| 10 |
CURRENCY_CD |
Character(3) |
VARCHAR2(3) NOT NULL |
Currency Code
Prompt Table:
CURRENCY_CD_TBL
|
| 11 |
TRANS_DT |
Date(10) |
DATE |
Transaction Date
|
| 12 |
TRANS_TIME |
Time(15) |
TIMESTAMP |
Transaction Time
|
| 13 |
REF1_DESCR |
Character(30) |
VARCHAR2(30) NOT NULL |
Reference Nbr
|
| 14 |
CHANGE_DUE |
Signed Number(17,2) |
DECIMAL(15,2) NOT NULL |
Change Due
|
| 15 |
EXT_ORG_ID |
Character(11) |
VARCHAR2(11) NOT NULL |
External Org ID
Prompt Table:
EXT_ORG_TBL
|
| 16 |
CONTRACT_NUM |
Character(25) |
VARCHAR2(25) NOT NULL |
Contract Number
Prompt Table:
TP_CONTRACT_VW
|
| 17 |
CONTRACT_EMPLID |
Character(11) |
VARCHAR2(11) NOT NULL |
Contract ID
Prompt Table:
PEOPLE_TP_SF
|
| 18 |
ENTERED_BY_CASHIER |
Character(30) |
VARCHAR2(30) NOT NULL |
Entering Cashier
|
| 19 |
ENTERED_DATETIME |
DateTime(26) |
TIMESTAMP |
Entered Datetime
|
| 20 |
APPROVAL_DATETIME |
DateTime(26) |
TIMESTAMP |
Datetime Approval
|
| 21 |
SSF_APPR_STATUS |
Character(1) |
VARCHAR2(1) NOT NULL |
Approval status flag .
A=Approved
C=Cancelled
D=Denied
G=Group Post
N=Not Posted
P=Pending
T=Posted
U=Unprocessed
V=Voided
X=Delayed Post
Z=Processed
Default Value: N
|
| 22 |
SSF_GL_IFC_RUN |
Character(1) |
VARCHAR2(1) NOT NULL |
GL Interface Run
N=Not Interfaced
P=Awaiting Reversal
R=Reversal Generated
X=Reversal Not Needed
Y=Interfaced
Default Value: N
|
| 23 |
RECEIPT_NBR_BD |
Number(12,0) |
DECIMAL(12) NOT NULL |
Business Date Sequence Nbr
Default Value: 999999999999
|
| 24 |
VOID_REASON_CD |
Character(3) |
VARCHAR2(3) NOT NULL |
Void Reason Code
Prompt Table:
CO_VOID_RSN_VW
|
| 25 |
ORIG_RECEIPT_NBR |
Number(12,0) |
DECIMAL(12) NOT NULL |
Original Receipt Number
|
| 26 |
SF_MERCHANT_ID |
Character(12) |
VARCHAR2(12) NOT NULL |
SF Merchant ID
|
| 27 |
CR_CARD_SRVC_PROV |
Character(2) |
VARCHAR2(2) NOT NULL |
Credit Card Service Provider
01=Cybersource
02=TouchNet
99=Unsupported
|
| 28 |
SSF_RESTRICT_INV |
Character(1) |
VARCHAR2(1) NOT NULL |
This field indicates that the payment will be held until an invoice is provided.
|
| 29 |
INVOICE_ID |
Character(22) |
VARCHAR2(22) NOT NULL |
Invoice Number
|