# |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
1 |
SBTTYPE1 |
Character(1) |
VARCHAR2(1) NOT NULL |
RECORD TYPE ID
|
2 |
SBTABANK |
Character(4) |
VARCHAR2(4) NOT NULL |
AGENT BANK
|
3 |
SBTCMPNY |
Character(5) |
VARCHAR2(5) NOT NULL |
Company Number
|
4 |
SBTDATE |
Character(6) |
VARCHAR2(6) NOT NULL |
Processing Date
|
5 |
SBTCACCT |
Character(16) |
VARCHAR2(16) NOT NULL |
Corporate Account Number
|
6 |
SBTBTYPE |
Character(1) |
VARCHAR2(1) NOT NULL |
Billing Type
|
7 |
SBTCTS |
Character(1) |
VARCHAR2(1) NOT NULL |
Contains CTS Indicator
|
8 |
SBTBCYCL |
Character(2) |
VARCHAR2(2) NOT NULL |
CYCLE DATE
|
9 |
SBTY1LL |
Long Character(319) |
VARCHAR2(319) |
FILLER
|