|
|
Field Name
|
Label
|
Col-Label
|
Format
|
Dec
|
|
|
ins__qadc01
|
|
|
x(24)
|
|
|
|
ins__qadd01
|
|
|
->>>>,>>>,>>9.99<<<
|
10
|
|
|
ins__qadi01
|
|
|
>>>>>>>9
|
|
|
|
ins__qadl01
|
|
|
yes/no
|
|
|
|
ins__qadt01
|
|
|
99/99/99
|
|
|
|
ins_ar_acct
|
AR Account
|
|
x(8)
|
|
|
|
ins_ar_cc
|
AR Cost Center
|
|
x(4)
|
|
|
|
ins_ar_sub
|
AR Sub-Account
|
|
x(8)
|
|
|
|
ins_bill_to
|
Bill-To
|
|
x(8)
|
|
|
|
ins_cmtindx
|
Comment Index
|
|
>>>>>>>9
|
|
|
|
ins_cr_terms
|
Credit Terms
|
|
x(8)
|
|
|
|
ins_curr
|
Currency
|
Cur
|
x(3)
|
|
|
|
ins_domain
|
Domain
|
|
x(8)
|
|
|
|
ins_fixed
|
Fixed
|
|
yes/no
|
|
|
|
ins_hold
|
Hold Invoice
|
|
yes/no
|
|
|
|
ins_hold_rmks
|
Hold Remarks
|
|
x(40)
|
|
|
|
ins_inv_amt
|
Invoice Amount
|
|
->>>>,>>>,>>9.99<<<
|
10
|
|
|
ins_inv_nbr
|
Invoice
|
|
x(22)
|
|
|
|
ins_inv_pct
|
Invoice Percent
|
|
->>9.9<%
|
10
|
|
|
ins_inv_type
|
Invoice Type
|
|
x(4)
|
|
|
|
ins_mod_date
|
Modified Date
|
Mod Date
|
99/99/99
|
|
|
|
ins_mod_userid
|
User ID
|
|
x(8)
|
|
|
|
ins_ord_date
|
Creation Date
|
|
99/99/99
|
|
|
|
ins_orig_date
|
Original Date
|
|
99/99/99
|
|
|
|
ins_prepayment
|
Prepayment
|
|
yes/no
|
|
|
|
ins_prj_nbr
|
Project
|
|
x(8)
|
|
|
|
ins_rel_date
|
Release Date
|
|
99/99/99
|
|
|
|
ins_released
|
Release
|
|
yes/no
|
|
|
|
ins_rmks
|
Remarks
|
|
x(40)
|
|
|
|
ins_sched_date
|
Schedule Date
|
|
99/99/99
|
|
|
|
ins_sched_nbr
|
Schedule
|
|
x(8)
|
|
|
|
ins_so_nbr
|
Pending Invoice
|
|
x(8)
|
|
|
|
ins_sub_nbr
|
Subproject
|
|
>>>9
|
|
|
|
ins_user1
|
Ufld1
|
|
x(8)
|
|
|
|
ins_user2
|
Ufld2
|
|
x(8)
|
|
|
|
ins_userid
|
Entered By
|
|
x(8)
|
|
|
|
oid_ins_mstr
|
|
|
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
|
10
|
|
|
Index-Name
|
Uni
|
Field-Name
|
Asc
|
Abbr
|
|
∗
|
ins_schedule
|
yes
|
ins_domain
|
yes
|
no
|
|
|
|
|
ins_prj_nbr
|
yes
|
no
|
|
|
|
|
ins_sub_nbr
|
yes
|
no
|
|
|
|
|
ins_sched_nbr
|
yes
|
no
|
|
|
ins_so
|
no
|
ins_domain
|
yes
|
no
|
|
|
|
|
ins_so_nbr
|
yes
|
no
|
|
|
oid_ins_mstr
|
yes
|
oid_ins_mstr
|
yes
|
no
|