About This Guide > sbid_det
  
sbid_det
Self-Bill Detail
 
 
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