| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 INVOICE_FORM_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Invoice Form
|
| 2 |
STATUS_BI |
Character(1) |
VARCHAR2(1) NOT NULL |
Status
A=Active
I=Inactive
Default Value: A
|
| 3 |
DESCR |
Character(30) |
VARCHAR2(30) NOT NULL |
Description
|
| 4 |
DESCRSHORT |
Character(10) |
VARCHAR2(10) NOT NULL |
Short Description
|
| 5 |
INVOICE_LAYOUT_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Invoice Layout ID
Prompt Table:
BI_IVCLAYOUT_VW
|
| 6 |
PRINT_FORM |
Character(1) |
VARCHAR2(1) NOT NULL |
Print Form
Y/N Table Edit
Default Value: Y
|
| 7 |
INVOICE_SORT_BY_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Invoice Sort By Identifier
Prompt Table:
BI_SORT_BY_VW
|
| 8 |
IVC_SUMMARY_PAGE |
Character(1) |
VARCHAR2(1) NOT NULL |
Invoice Summary Page
L=Leading Page
N=No Summary Page
O=Only Summary Page
T=Trailing Page
Default Value: N
|
| 9 |
CONFIG_CD_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Configuration Code Flag
Y/N Table Edit
Default Value: N
|
| 10 |
CONFIG_DTL_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Configuration Detail Flag
Y/N Table Edit
Default Value: N
|
| 11 |
LIST_PRICE_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
List price Flag
Default Value: N
|
| 12 |
PRICE_ADJ_DTL_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Price Adjustment Detail Flag
Default Value: N
|
| 13 |
INCLUDE_PRIM_HDR |
Character(1) |
VARCHAR2(1) NOT NULL |
Include Primary Notes on SumPg
Y/N Table Edit
Default Value: N
|
| 14 |
INCLUDE_SEC_HDR |
Character(1) |
VARCHAR2(1) NOT NULL |
Include Secondary Hdr Notes
Y/N Table Edit
Default Value: N
|
| 15 |
INCLUDE_VAT_MSG |
Character(1) |
VARCHAR2(1) NOT NULL |
Include VAT Treatment Msg
Y/N Table Edit
Default Value: N
|
| 16 |
REPEAT_HEADING |
Character(1) |
VARCHAR2(1) NOT NULL |
Repeat Heading
Y/N Table Edit
Default Value: N
|
| 17 |
PRIM_HDR_NOTE_TYPE |
Character(10) |
VARCHAR2(10) NOT NULL |
Primary Header Note Type
Prompt Table:
NOTE_TYPE_FMTVW
|
| 18 |
PRIM_H_NOTE_POSITN |
Character(1) |
VARCHAR2(1) NOT NULL |
Primary Header Note Position
F=Within Inv Heading (First Pg)
L=Within Inv Heading (All Pages)
Default Value: F
|
| 19 |
SEC_HDR_NOTE_TYPE |
Character(10) |
VARCHAR2(10) NOT NULL |
Secondary Header Note Type
Prompt Table:
NOTE_TYPE_FMTVW
|
| 20 |
SEC_H_NOTE_POSITN |
Character(1) |
VARCHAR2(1) NOT NULL |
Secondary Header Note Position
A=After Last Line
B=Before First Line
T=After Totals
Default Value: B
|
| 21 |
REM_H_NOTE_POSITN |
Character(1) |
VARCHAR2(1) NOT NULL |
Remaining Header Note Position
A=After Last Line
B=Before First Line
T=After Totals
Default Value: B
|
| 22 |
ORD_H_NOTE_POSITN |
Character(1) |
VARCHAR2(1) NOT NULL |
Order Header Note Position
0=Suppress printing
A=After Last Line
B=Before First Line
T=After Totals
Default Value: 0
|
| 23 |
PRIM_LIN_NOTE_TYPE |
Character(10) |
VARCHAR2(10) NOT NULL |
Primary Line Note Type
Prompt Table:
NOTE_TYPE_FMTVW
|
| 24 |
PRIM_L_NOTE_POSITN |
Character(1) |
VARCHAR2(1) NOT NULL |
Primary Line Note Position
A=After Line
B=Before Line
F=Footnotes
Default Value: A
|
| 25 |
LINE_NOTE_POSITION |
Character(1) |
VARCHAR2(1) NOT NULL |
Line Note Position
A=After Line
B=Before Line
F=Footnotes
Default Value: A
|
| 26 |
FOOTNOTE_POSITION |
Character(1) |
VARCHAR2(1) NOT NULL |
Footnote Position
A=After Totals
B=Before Totals
N=No Footnotes
Default Value: B
|
| 27 |
VAT_MSG_POSITION |
Character(1) |
VARCHAR2(1) NOT NULL |
VAT Treatment Msg Placement
A=After Last Line
B=Before First Line
F=Within Inv Heading (First Pg)
L=Within Inv Heading (All Pages)
T=After Totals
Default Value: F
|
| 28 |
LIN_DS_FORMAT |
Character(1) |
VARCHAR2(1) NOT NULL |
Line Disc-Surchg Format
C=Combined Discount w/Surcharges
E=Summarized Each
N=No Detail
Default Value: N
|
| 29 |
TOT_DS_FORMAT |
Character(1) |
VARCHAR2(1) NOT NULL |
Total Disc-Surchg Format
C=Total Combined Disc/Surchg
E=Total for Each
N=No Discount or Surcharge Total
Default Value: E
|
| 30 |
APPLY_DS_TO_LINE |
Character(1) |
VARCHAR2(1) NOT NULL |
Apply Disc/Surchg to Line Amt
Y/N Table Edit
Default Value: Y
|
| 31 |
LIN_TAX_FORMAT |
Character(1) |
VARCHAR2(1) NOT NULL |
Line Tax Format
A=By Tax Authority
C=By Tax Code
N=No Line Tax
Default Value: N
|
| 32 |
TOT_TAX_FORMAT |
Character(1) |
VARCHAR2(1) NOT NULL |
Total Tax Format
C=Total Tax by Tax Code
T=Total Tax Only
Default Value: T
|
| 33 |
DISCNT_PRETAX_AMT |
Character(1) |
VARCHAR2(1) NOT NULL |
Early Pymt Discnt on PretaxAmt
Y/N Table Edit
Default Value: Y
|
| 34 |
DISCNT_SALES_TAX |
Character(1) |
VARCHAR2(1) NOT NULL |
Early Pymt Discnt on SalesTax
Y/N Table Edit
Default Value: N
|
| 35 |
PRINT_INST_DETAIL |
Character(1) |
VARCHAR2(1) NOT NULL |
Print Installment Detail
Y/N Table Edit
Default Value: N
|
| 36 |
PRINT_INST_SUMMARY |
Character(1) |
VARCHAR2(1) NOT NULL |
Print Installment Bill Summary
Y/N Table Edit
Default Value: N
|
| 37 |
TREE_SETID |
Character(5) |
VARCHAR2(5) NOT NULL |
Tree SetID
Prompt Table:
SP_SETID_NONVW
|
| 38 |
TREE_NAME |
Character(18) |
VARCHAR2(18) NOT NULL |
Tree Name
Prompt Table:
GM_TREE_NAME_VW
Set Control Field: TREE_SETID
|
| 39 |
TREE_LEVEL |
Character(10) |
VARCHAR2(10) NOT NULL |
Tree Level Number
Prompt Table:
TREE_LEVEL_VW3
Set Control Field: SETID
|
| 40 |
REPORT_DEFN_ID |
Character(12) |
VARCHAR2(12) NOT NULL |
Report Name (see PSXPRPTDEFN).
Prompt Table:
BI_XPRPTDEF_VW
|
| 41 |
REPORT_DEFN_ID2 |
Character(12) |
VARCHAR2(12) NOT NULL |
Consolidated Report ID
Prompt Table:
BI_XPRPTDEF_VW
|
| 42 |
BI_EIVC_OPTION |
Character(1) |
VARCHAR2(1) NOT NULL |
Electronic Invoice Option
|
| 43 |
FS_MAP_ID |
Character(30) |
VARCHAR2(30) NOT NULL |
Map ID
Prompt Table:
FS_MAP_HDR_VW
|
| 44 |
ADD_DTTM |
DateTime(26) |
TIMESTAMP |
Date Time Added
|
| 45 |
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.
|
| 46 |
LAST_MAINT_OPRID |
Character(30) |
VARCHAR2(30) NOT NULL |
Last Maintained By Operator ID
|