About This Guide > bbl_mstr
  
bbl_mstr
Brazilian Bank bill
 
 
Field Name
Label
Col-Label
Format
Dec
 
bbl__qadc01
 
 
x(24)
 
 
bbl__qadc02
 
 
x(24)
 
 
bbl__qadd01
 
 
->>>>,>>>,>>9.9<<<<<<<<<
10
 
bbl__qadt01
 
 
99/99/99
 
 
bbl_bbl_amt
Document Amount
Doc Amt
->>>>,>>>,>>9.99<
10
 
bbl_bk_acct_code
Bank Acct Code
 
x(8)
 
 
bbl_cinvoice_id
Supplier Invoice ID
Supp Inv ID
9999999999
 
 
bbl_creditor_id
Creditor ID
 
9999999999
 
 
bbl_domain
Domain
 
x(8)
 
 
bbl_due_date
Due Date
 
99/99/99
 
 
bbl_exec_date
Execution Date
 
99/99/99
 
 
bbl_file_name
Bank File Name
 
x(60)
 
 
bbl_gst_id
Tax ID - Federal
 
x(18)
 
 
bbl_lgd_nbr
Legal Doc Nbr
Legal Doc
x(12)
 
 
bbl_man_bar_code
Manual Bar Code
Man Bar Code
x(47)
 
 
bbl_mod_date
Last Modified Date
Mod Date
99/99/99
 
 
bbl_mod_userid
Last Modified User Id
 
x(8)
 
 
bbl_opt_bar_code
Optical Bar Code
Opt Bar Code
x(44)
 
 
bbl_owner_bk_acct_code
Bank Account Code
 
x(8)
 
 
bbl_receive_date
Received Date
 
99/99/99
 
 
bbl_user1
User Field Character 1
 
x(24)
 
 
bbl_user2
User Field Character 2
 
x(24)
 
 
oid_bbl_mstr
 
 
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
10
 
 
 
Index-Name
Uni
Field-Name
Asc
Abbr
 
bbl_cinvoice_id
no
bbl_cinvoice_id
yes
no
bbl_man_bar_code
no
bbl_domain
yes
no
 
 
 
bbl_man_bar_code
yes
no
 
 
 
bbl_file_name
yes
no
 
oid_bbl_mstr
yes
oid_bbl_mstr
yes
no