|
|
Field Name
|
Label
|
Col-Label
|
Format
|
Dec
|
|
|
oid_sbid_det
|
|
|
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
|
10
|
|
|
sbid__qadc01
|
|
|
X(8)
|
|
|
|
sbid__qadc02
|
|
|
X(8)
|
|
|
|
sbid__qadc03
|
|
|
X(8)
|
|
|
|
sbid__qadc04
|
|
|
X(8)
|
|
|
|
sbid__qadc05
|
|
|
X(8)
|
|
|
|
sbid__qadc06
|
|
|
X(8)
|
|
|
|
sbid__qadc07
|
|
|
X(8)
|
|
|
|
sbid__qadc08
|
|
|
X(8)
|
|
|
|
sbid__qadc09
|
|
|
X(8)
|
|
|
|
sbid__qadc10
|
|
|
X(8)
|
|
|
|
sbid__qadd01
|
|
|
->>>,>>>,>>9.9<<<<<<<<<
|
10
|
|
|
sbid__qadd02
|
|
|
->>>,>>>,>>9.9<<<<<<<<<
|
10
|
|
|
sbid__qadd03
|
|
|
->>>,>>>,>>9.9<<<<<<<<<
|
10
|
|
|
sbid__qadd04
|
|
|
->>>,>>>,>>9.9<<<<<<<<<
|
10
|
|
|
sbid__qadd05
|
|
|
->>>,>>>,>>9.9<<<<<<<<<
|
10
|
|
|
sbid__qadi01
|
|
|
>>>>>>9
|
|
|
|
sbid__qadi02
|
|
|
>>>>>>9
|
|
|
|
sbid__qadi03
|
|
|
>>>>>>9
|
|
|
|
sbid__qadi04
|
|
|
>>>>>>9
|
|
|
|
sbid__qadi05
|
|
|
>>>>>>9
|
|
|
|
sbid__qadl01
|
|
|
yes/no
|
|
|
|
sbid__qadl02
|
|
|
yes/no
|
|
|
|
sbid__qadl03
|
|
|
yes/no
|
|
|
|
sbid__qadl04
|
|
|
yes/no
|
|
|
|
sbid__qadl05
|
|
|
yes/no
|
|
|
|
sbid__qadt01
|
|
|
99/99/99
|
|
|
|
sbid__qadt02
|
|
|
99/99/99
|
|
|
|
sbid__qadt03
|
|
|
99/99/99
|
|
|
|
sbid__qadt04
|
|
|
99/99/99
|
|
|
|
sbid__qadt05
|
|
|
99/99/99
|
|
|
|
sbid_amt
|
Paid Amount
|
|
->>>>,>>>,>>9.99<<<
|
10
|
|
|
sbid_authorization
|
Authorization
|
|
x(24)
|
|
|
|
sbid_bill
|
Bill-To
|
|
x(8)
|
|
|
|
sbid_cust
|
Sold-To
|
|
x(8)
|
|
|
|
sbid_custref
|
Customer Ref
|
|
x(30)
|
|
|
|
sbid_domain
|
Domain
|
|
x(8)
|
|
|
|
sbid_inv_nbr
|
Invoice/Memo
|
Inv/Memo
|
x(22)
|
|
|
|
sbid_line
|
Line
|
|
>>>,>>9
|
|
|
|
sbid_mod_date
|
Modified Date
|
Mod Date
|
99/99/99
|
|
|
|
sbid_mod_userid
|
User ID
|
|
X(8)
|
|
|
|
sbid_modelyr
|
Model Year
|
|
x(4)
|
|
|
|
sbid_nbr
|
Self-Bill
|
|
x(20)
|
|
|
|
sbid_order
|
Sales Order
|
SO
|
x(8)
|
|
|
|
sbid_origin
|
Origin
|
O
|
x(1)
|
|
|
|
sbid_part
|
Self-Bill Item
|
|
x(30)
|
|
|
|
sbid_po
|
Customer PO
|
|
x(22)
|
|
|
|
sbid_price
|
Paid Price
|
|
>>,>>>,>>9.99<<<
|
10
|
|
|
sbid_qty
|
Paid Qty
|
|
->,>>>,>>9.9<<<<<<<<
|
10
|
|
|
sbid_remarks
|
Remarks
|
|
x(40)
|
|
|
|
sbid_ship_id
|
Shipper
|
|
x(20)
|
|
|
|
sbid_tax_amt
|
Tax Amt
|
|
->>>>,>>>,>>9.99<<<
|
10
|
|
|
sbid_tax_pct
|
Tax Rate
|
|
->>9.99<<%
|
10
|
|
|
sbid_trnbr
|
Trans
|
|
>>>>>>>>
|
|
|
|
sbid_type
|
Type
|
T
|
x(1)
|
|
|
|
sbid_um
|
UM
|
|
x(2)
|
|
|
|
sbid_user1
|
Ufld1
|
|
X(8)
|
|
|
|
sbid_user2
|
Ufld2
|
|
X(8)
|
|
|
|
sbid_user3
|
|
|
X(8)
|
|
|
|
sbid_user4
|
|
|
X(8)
|
|
|
|
sbid_user5
|
|
|
X(8)
|
|
|
|
sbid_user6
|
|
|
X(8)
|
|
|
|
sbid_user7
|
|
|
X(8)
|
|
|
|
Index-Name
|
Uni
|
Field-Name
|
Asc
|
Abbr
|
|
|
oid_sbid_det
|
yes
|
oid_sbid_det
|
yes
|
no
|
|
|
sbid_authorization
|
no
|
sbid_domain
|
yes
|
no
|
|
|
|
|
sbid_authorization
|
yes
|
no
|
|
|
sbid_inv_nbr
|
no
|
sbid_domain
|
yes
|
no
|
|
|
|
|
sbid_inv_nbr
|
yes
|
no
|
|
∗
|
sbid_nbr_line
|
yes
|
sbid_domain
|
yes
|
no
|
|
|
|
|
sbid_bill
|
yes
|
no
|
|
|
|
|
sbid_nbr
|
yes
|
no
|
|
|
|
|
sbid_line
|
yes
|
no
|
|
|
sbid_order
|
no
|
sbid_domain
|
yes
|
no
|
|
|
|
|
sbid_order
|
yes
|
no
|
|
|
sbid_part
|
no
|
sbid_domain
|
yes
|
no
|
|
|
|
|
sbid_part
|
yes
|
no
|
|
|
|
|
sbid_type
|
yes
|
no
|
|
|
sbid_ship_id
|
no
|
sbid_domain
|
yes
|
no
|
|
|
|
|
sbid_ship_id
|
yes
|
no
|
|
|
sbid_trnbr
|
no
|
sbid_domain
|
yes
|
no
|
|
|
|
|
sbid_trnbr
|
yes
|
no
|